CONDITION REPORT
----------------
FILE - EMPCODES
Condition Type
--------------------------------------------------------------------------------
APPLICANT FILEFLD
where ( Emp App = 1 )
Is Used In No Indexes
Is Used In Rel - APPLICANT
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
--------------------------------------------------------------------------------
BENEFITS FILEFLD
where ( Type = "BN" )
Is Used In No Indexes
Is Used In Rel - BN-COMMENTS
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
--------------------------------------------------------------------------------
CERT-COMPET FILEFLD
where (( Type = "AB" )
Or ( Type = "SK" )
Or ( Type = "KN" )
Or ( Type = "OA" )
Or ( Type = "CE" ))
Is Used In No Indexes
Is Used In Rel - COURSE-SKILLS
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
--------------------------------------------------------------------------------
CERTIFICATION FILEFLD
where ( Type = "CE" )
Is Used In No Indexes
Is Used In Rel - CE-COMMENTS
- TRACK-CERT
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
--------------------------------------------------------------------------------
COMPANY-PROP FILEFLD
where ( Type = "CP" )
Is Used In No Indexes
Is Used In Rel - CP-COMMENTS
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
--------------------------------------------------------------------------------
COMPETENCY FILEFLD
where (( Type = "AB" )
Or ( Type = "KN" )
Or ( Type = "OA" )
Or ( Type = "SK" ))
Is Used In Index - EPCSET3
Is Used In Rel - SK-COMMENTS
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
--------------------------------------------------------------------------------
CONTRACT FILEFLD
where (( Type = "CN" ))
Is Used In No Indexes
Is Used In Rel - CONTRACT
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
--------------------------------------------------------------------------------
COURSE-SKILLS OTOFLDS
where ( Relation: Course Skills 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
--------------------------------------------------------------------------------
CP-COMMENTS-EX OTOFLDS
where ( Relation: Cp Comments 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
--------------------------------------------------------------------------------
CURR-CONTRACT FILEFLD
where (( Type = "CN" )
And (( Date Returned = Zeroes )
Or ( Date Returned > )))
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
--------------------------------------------------------------------------------
EDUCATION FILEFLD
where ( Type = "ED" )
Is Used In No Indexes
Is Used In Rel - ED-COMMENTS
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 ( Emp App = Zeroes )
Is Used In No Indexes
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
--------------------------------------------------------------------------------
EPCSET3 FILEFLD
where ( Type = "ED" )
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
--------------------------------------------------------------------------------
EPCSET4 FILEFLD
where ( Type = "ED" )
Is Used In Index - EPCSET4
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
--------------------------------------------------------------------------------
EPCSET5 FILEFLD
where ( Type = "ED" )
Is Used In Index - EPCSET5
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
--------------------------------------------------------------------------------
INSTITUTION FILEFLD
where ( Type = "ED"
And Instructor != Spaces )
Is Used In No Indexes
Is Used In Rel - INSTITUTION
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
--------------------------------------------------------------------------------
OBJECT-ID FILEFLD
where (( Obj Id != Zeroes ))
Is Used In Index - EPCSET6
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
--------------------------------------------------------------------------------
PAEMPLOYEE OTOFLDS
where ( Relation: Paemployee 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
--------------------------------------------------------------------------------
RELOCATION FILEFLD
where ( Type = "RL" )
Is Used In No Indexes
Is Used In Rel - RL-COMMENTS
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
--------------------------------------------------------------------------------
SET7 FILEFLD
where((( Type != "BN" )
And ( Type != "RL" )))
Is Used In Index - EPCSET7
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
--------------------------------------------------------------------------------
SKILL-SOURCE FILEFLD
where ( Skill Source != Spaces )
Is Used In No Indexes
Is Used In Rel - SKILL-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
--------------------------------------------------------------------------------
SKILLS FILEFLD
where ( Type = "SK" )
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
--------------------------------------------------------------------------------
SUBJECT FILEFLD
where ( Subject != Spaces )
Is Used In No Indexes
Is Used In Rel - SUBJECT
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
--------------------------------------------------------------------------------
TRACK-CERT OTOFLDS
where ( Relation: Track Cert 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
--------------------------------------------------------------------------------
TRAINING-SKILL FILEFLD
where ( Type = "SK"
And Obj Id != Zeroes )
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
|
