CONDITION REPORT
----------------
FILE - APPLICANT
Condition Type
--------------------------------------------------------------------------------
APP-STATUS FILEFLD
where ( App Status != Spaces )
Is Used In No Indexes
Is Used In Rel - APP-STATUS
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
--------------------------------------------------------------------------------
CERTIFICATIONS OTOFLDS
where ( Relation: Certificates 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
--------------------------------------------------------------------------------
COMPET-EXIST OTOFLDS
where ( Relation: Competency 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
--------------------------------------------------------------------------------
CORRES-EXIST OTOFLDS
where ( Relation: Correspondence 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
--------------------------------------------------------------------------------
COUNTRY FILEFLD
where (( Country Code != Spaces ))
Is Used In No Indexes
Is Used In Rel - COUNTRY
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
--------------------------------------------------------------------------------
CURR-CODE-2 FILEFLD
where ( Curr Code 2 != Spaces )
Is Used In No Indexes
Is Used In Rel - CURRENCY2
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
--------------------------------------------------------------------------------
DISABILITY FILEFLD
where ( Disability != Spaces )
Is Used In No Indexes
Is Used In Rel - DISABILITY
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
--------------------------------------------------------------------------------
EDUCATION OTOFLDS
where ( Relation: Education 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
--------------------------------------------------------------------------------
EMP-STATUS FILEFLD
where ( Emp Status != Spaces )
Is Used In No Indexes
Is Used In Rel - EMP-STATUS
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
--------------------------------------------------------------------------------
EMPLOYEE FILEFLD
where ( Employee != Zeroes )
Is Used In Index - APLSET4
Is Used In Rel - EMPLOYEE
- PAEMPLOYEE
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
--------------------------------------------------------------------------------
EMPLOYEE-EXIST OTOFLDS
where ( Relation: Employee 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
--------------------------------------------------------------------------------
EMPLOYERS OTOFLDS
where ( Relation: Employers 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
--------------------------------------------------------------------------------
ETHNICITY FILEFLD
where ( Eeo Class != Spaces )
Is Used In No Indexes
Is Used In Rel - ETHNICITY
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
--------------------------------------------------------------------------------
HIRE-SOURCE FILEFLD
where ( Hire Source != Spaces )
Is Used In No Indexes
Is Used In Rel - HIRE-SOURCE
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
--------------------------------------------------------------------------------
HRHISTORY 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
--------------------------------------------------------------------------------
INTERVIEWS OTOFLDS
where ( Relation: Interviews 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-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-REQS-EXIST OTOFLDS
where ( Relation: Requisitions 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
--------------------------------------------------------------------------------
JOB1 FILEFLD
where ( Job1 != Spaces )
Is Used In No Indexes
Is Used In Rel - JOB1
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
--------------------------------------------------------------------------------
JOB2 FILEFLD
where ( Job2 != Spaces )
Is Used In No Indexes
Is Used In Rel - JOB2
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
--------------------------------------------------------------------------------
JOB3 FILEFLD
where ( Job3 != Spaces )
Is Used In No Indexes
Is Used In Rel - JOB3
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
--------------------------------------------------------------------------------
JOBS-APPLIED FILEFLD
where ( Job1 != Spaces
Or Job2 != Spaces
Or Job3 != 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
--------------------------------------------------------------------------------
LANGUAGE FILEFLD
where ( Language Code != 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
--------------------------------------------------------------------------------
LAST-NAME-PRE FILEFLD
where ( Last Name Pre != Spaces )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - LAST-NAME-EXP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
MIDDLE-INIT FILEFLD
where ( Middle Init != Spaces )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - FIRST-MI-EXP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NAME-PREFIX FILEFLD
where ( Name Prefix != Spaces )
Is Used In No Indexes
Is Used In Rel - NAME-PREFIX
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
--------------------------------------------------------------------------------
NAME-SUFFIX FILEFLD
where ( Name Suffix != Spaces )
Is Used In No Indexes
Is Used In Rel - NAME-SUFFIX
Is Used In No SubType
Is Used In No States
Is Used In CndFld - LAST-NAME-EXP
- LAST-NAME-EXP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
POSITION1 FILEFLD
where ( Position1 != Spaces )
Is Used In No Indexes
Is Used In Rel - POSITION1
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
--------------------------------------------------------------------------------
POSITION2 FILEFLD
where ( Position2 != Spaces )
Is Used In No Indexes
Is Used In Rel - POSITION2
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
--------------------------------------------------------------------------------
POSITION3 FILEFLD
where ( Position3 != Spaces )
Is Used In No Indexes
Is Used In Rel - POSITION3
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
--------------------------------------------------------------------------------
PREV-COUNTRY FILEFLD
where (( Prev Cntry Cd != Spaces ))
Is Used In No Indexes
Is Used In Rel - PREV-COUNTRY
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
--------------------------------------------------------------------------------
RATING FILEFLD
where ( Rating != Spaces )
Is Used In No Indexes
Is Used In Rel - RATING
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
--------------------------------------------------------------------------------
REFERENCES OTOFLDS
where ( Relation: References 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
--------------------------------------------------------------------------------
RELIGION FILEFLD
where ( Religion != Spaces )
Is Used In No Indexes
Is Used In Rel - RELIGION
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-LOG OTOFLDS
where ( Relation: Requis Log 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
--------------------------------------------------------------------------------
WK-RST-CODE1 FILEFLD
where ( Wk Rst Code1 != Spaces )
Is Used In No Indexes
Is Used In Rel - WK-RST-CODE1
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
--------------------------------------------------------------------------------
WK-RST-CODE2 FILEFLD
where ( Wk Rst Code2 != Spaces )
Is Used In No Indexes
Is Used In Rel - WK-RST-CODE2
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
--------------------------------------------------------------------------------
WK-RST-CODE3 FILEFLD
where ( Wk Rst Code3 != Spaces )
Is Used In No Indexes
Is Used In Rel - WK-RST-CODE3
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
--------------------------------------------------------------------------------
WK-RST-CODE4 FILEFLD
where ( Wk Rst Code4 != Spaces )
Is Used In No Indexes
Is Used In Rel - WK-RST-CODE4
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
--------------------------------------------------------------------------------
WORK-SCHEDULE FILEFLD
where ( Work Sched != Spaces )
Is Used In No Indexes
Is Used In Rel - WORK-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
|
