CONDITION REPORT
----------------
FILE - JOBRELATE
Condition Type
--------------------------------------------------------------------------------
COMP-PROF-EXIS OTOFLDS
where ( Relation: Compet Profic 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
--------------------------------------------------------------------------------
COMPANY-PROF FILEFLD
where((( Type = "AB" )
Or ( Type = "KN" )
Or ( Type = "OA" )
Or ( Type = "SK" ))
And ( Job Code = Spaces )
And ( Position = 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
--------------------------------------------------------------------------------
COMPET-PROF FILEFLD
where((( Type = "AB" )
Or ( Type = "KN" )
Or ( Type = "OA" )
Or ( Type = "SK" ))
And ( Profic Level != Spaces ))
Is Used In No Indexes
Is Used In Rel - COMPET-PROFIC
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 No Indexes
Is Used In Rel - PROFICIENCY
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
--------------------------------------------------------------------------------
EMPCODES-APPS OTOFLDS
where ( Relation: Empcodes Apps 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
--------------------------------------------------------------------------------
EMPCODES-EMPS OTOFLDS
where ( Relation: Empcodes Emps 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
--------------------------------------------------------------------------------
JBRSET2 FILEFLD
where ( Required Flag = "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
--------------------------------------------------------------------------------
JOB-FUNCTIONS FILEFLD
where (( Type = "CE" )
Or ( Type = "ED" )
Or ( Type = "SK" )
Or ( Type = "AB" )
Or ( Type = "KN" )
Or ( Type = "OA" ))
Is Used In No Indexes
Is Used In Rel - EMPCODES-APPS
- EMPCODES-EMPS
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
--------------------------------------------------------------------------------
JOBCODE FILEFLD
where (( Job Code != Spaces ))
Is Used In No Indexes
Is Used In Rel - JOB-CODE
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-PROF-EXIST OTOFLDS
where ( Relation: Proficiency Does Not Exist )
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
--------------------------------------------------------------------------------
NOT-EDUCATION 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 1 Rule
Condition Type
--------------------------------------------------------------------------------
PHYS-MNTL-REQ FILEFLD
where ( Type = "PH"
Or Type = "MR" )
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
--------------------------------------------------------------------------------
PHYS-MNTL-WRK FILEFLD
where (( Type = "EC" )
Or ( Type = "EO" )
Or ( Type = "MR" )
Or ( Type = "PH" )
Or ( Type = "SR" )
Or ( Type = "TR" ))
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
--------------------------------------------------------------------------------
POSITION FILEFLD
where (( Position != Spaces ))
Is Used In No Indexes
Is Used In Rel - POSITION
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
--------------------------------------------------------------------------------
PROF-EXIST OTOFLDS
where ( Relation: Proficiency 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
--------------------------------------------------------------------------------
PROFIC-LEVEL FILEFLD
where (( Profic Level != Spaces ))
Is Used In No Indexes
Is Used In Rel - PROFIC-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
--------------------------------------------------------------------------------
SUBJECT FILEFLD
where ( Subject Code != 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
--------------------------------------------------------------------------------
TEST FILEFLD
where (( Type = "TS" ))
Is Used In No Indexes
Is Used In Rel - TEST-REQUIRE
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
--------------------------------------------------------------------------------
WORKING-COND FILEFLD
where ( Type = "SR"
Or Type = "EO"
Or Type = "TR"
Or Type = "EC" )
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
|