CONDITION REPORT
----------------
FILE - JOBCODE
Condition Type
--------------------------------------------------------------------------------
ACADEMIC-RANK FILEFLD
where (( Academic Rank >= "1" ))
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ACTIVE FILEFLD
where ( Active Flag = "A" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
APPROVED-BY FILEFLD
where ( Approved By != Zeroes )
Is Used In No Indexes
Is Used In Rel - APPROVED-BY
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CLERICAL FILEFLD
where ( Eeo Cat = "50"
Or Eeo Cat = "51" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CRAFT-WORKERS FILEFLD
where ( Eeo Cat = "60"
Or Eeo Cat = "61" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CURRENCY FILEFLD
where (( Currency Code != Spaces ))
Is Used In No Indexes
Is Used In Rel - BASE-CURRENCY
- CURRENCY
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
DEPARTMENT FILEFLD
where ( Department != Spaces )
Is Used In No Indexes
Is Used In Rel - DEPARTMENT
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
DESCRIPTION OTOFLDS
where ( Relation: Description Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
EEO-CATEGORY FILEFLD
where (( Eeo Cat >= "01" )
And ( Eeo Cat != "99" ))
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
EMPLOYEES OTOFLDS
where ( Relation: Employees Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
EXPENSE-ACCT FILEFLD
where ( Exp Acct Unit != Spaces
Or Exp Account != Zeroes
Or Exp Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In Rel - EXPENSE-ACCT
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
FEMALE FILEFLD
where ( Gender Class = "1" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
GRADE FILEFLD
where ( Pay Grade != Spaces )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HIGHER-ED FILEFLD
where (( High Ed Cat >= 1 ))
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HIST-ERR OTOFLDS
where ( Relation: Hist Err Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HOURLY FILEFLD
where ( Salary Class = "H" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HR-OCCUP-CODE OTOFLDS
where ( Relation: Hr Occup Code Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HRHIST-EXISTS OTOFLDS
where ( Relation: Hrhistory Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
JOB-CLASS FILEFLD
where ( Job Class != Spaces )
Is Used In No Indexes
Is Used In Rel - JOB-CLASS
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
JOB-INTEREST OTOFLDS
where ( Relation: Job Interest Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
JOB-RELATIONS OTOFLDS
where ( Relation: Job Relations Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
LABORERS FILEFLD
where ( Eeo Cat = "80"
Or Eeo Cat = "82" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
MALE FILEFLD
where ( Gender Class = "2" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NEUTRAL FILEFLD
where ( Gender Class = "3" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NO-SCHEDULE FILEFLD
where ( Schedule = Spaces )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
OFFICLS-MNGRS FILEFLD
where ( Eeo Cat = "10"
Or Eeo Cat = "11" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
OPERATORS FILEFLD
where ( Eeo Cat = "70"
Or Eeo Cat = "72" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
PROCESS-LEVEL FILEFLD
where ( Process Level != Spaces )
Is Used In No Indexes
Is Used In Rel - PROCESS-LEVEL
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
PROFESSIONALS FILEFLD
where ( Eeo Cat = "20"
Or Eeo Cat = "21" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
REPORTS-TO FILEFLD
where ( Reports To != Zeroes )
Is Used In No Indexes
Is Used In Rel - REPORTS-TO
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
REQUIS-EXISTS OTOFLDS
where ( Relation: Requisition Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SALARY FILEFLD
where ( Salary Class = "S" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SALES-WORKERS FILEFLD
where ( Eeo Cat = "40"
Or Eeo Cat = "41" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SCHEDGRADE FILEFLD
where (( Schedule != Spaces )
And ( Pay Grade != Spaces ))
Is Used In No Indexes
Is Used In Rel - GRADE
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SCHEDULE FILEFLD
where ( Schedule != Spaces )
Is Used In No Indexes
Is Used In Rel - SCHEDULE
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SERVICE FILEFLD
where ( Eeo Cat = "90"
Or Eeo Cat = "92" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TECHNICIANS FILEFLD
where ( Eeo Cat = "30"
Or Eeo Cat = "31" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TENURE-ELIG FILEFLD
where (( Tenure Elig = "Y" ))
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
WC-CLASS FILEFLD
where ( Wc Class != Spaces )
Is Used In No Indexes
Is Used In Rel - WC-CLASS
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
WC-CLASS-CA FILEFLD
where ( Ca Wc Class != Spaces )
Is Used In No Indexes
Is Used In Rel - WC-CLASS-CA
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
|