|
|
CONDITION REPORT
----------------
FILE - PCODES
Condition Type
--------------------------------------------------------------------------------
ABILITIES FILEFLD
where (( Type = "AB" ))
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
--------------------------------------------------------------------------------
ACT-SU-WEB-ALL FILEFLD
where ( Active Flag = "A"
And Web Avail Supv = "3"
And ( Type = "CE"
Or Type = "ED"
Or Type = "KN"
Or Type = "SK"
Or Type = "AB"
Or Type = "OA" ))
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
--------------------------------------------------------------------------------
ACT-SU-WEB-CMP FILEFLD
where (( Active Flag = "A" )
And ( Web Avail Supv = "3" )
And (( Type = "SK" )
Or ( Type = "AB" )
Or ( Type = "KN" )
Or ( Type = "OA" )))
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
--------------------------------------------------------------------------------
ACT-SU-WEB-CRT FILEFLD
where (( Active Flag = "A" )
And ( Web Avail Supv = "3" )
And ( Type = "CE" ))
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
--------------------------------------------------------------------------------
ACT-SUP-WEB-ED FILEFLD
where (( Active Flag = "A" )
And ( Web Avail Supv = "3" )
And ( 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
--------------------------------------------------------------------------------
ACT-WEB-ALL FILEFLD
where ( Active Flag = "A"
And Web Available = "3"
And ( Type = "CE"
Or Type = "ED"
Or Type = "KN"
Or Type = "SK"
Or Type = "AB"
Or Type = "OA" ))
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
--------------------------------------------------------------------------------
ACT-WEB-CERT FILEFLD
where (( Active Flag = "A" )
And ( Web Available = "3" )
And ( Type = "CE" ))
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
--------------------------------------------------------------------------------
ACT-WEB-COMP FILEFLD
where (( Active Flag = "A" )
And ( Web Available = "3" )
And (( Type = "SK" )
Or ( Type = "AB" )
Or ( Type = "KN" )
Or ( Type = "OA" )))
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
--------------------------------------------------------------------------------
ACT-WEB-EDUC FILEFLD
where (( Active Flag = "A" )
And ( Web Available = "3" )
And ( 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
ACTIVE-COURSE FILEFLD, OTOFLDS
where (( Active Flag = "A" )
And ( Relation: Course Compet 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
--------------------------------------------------------------------------------
BARGAIN-EMPS OTOFLDS
where ( Relation: Bargain 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
--------------------------------------------------------------------------------
BARGAIN-UNIT FILEFLD
where ( Type = "BU" )
Is Used In No Indexes
Is Used In Rel - BARGAIN-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
--------------------------------------------------------------------------------
CERT-COMPET FILEFLD
where (( Type = "AB" )
Or ( Type = "KN" )
Or ( Type = "OA" )
Or ( Type = "SK" )
Or ( Type = "CE" ))
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
--------------------------------------------------------------------------------
CERTIFICATION FILEFLD
where ( Type = "CE" )
Is Used In No Indexes
Is Used In Rel - 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
--------------------------------------------------------------------------------
CMA FILEFLD
where ( Type = "CA" )
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
--------------------------------------------------------------------------------
COMP-PROF-EXIS OTOFLDS
where ( Relation: Comp 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
--------------------------------------------------------------------------------
COMPETENCY FILEFLD
where (( Type = "AB" )
Or ( Type = "KN" )
Or ( Type = "OA" )
Or ( Type = "SK" ))
Is Used In No Indexes
Is Used In Rel - COMP-PROFIC
- COURSE-COMPET
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
--------------------------------------------------------------------------------
KNOWLEDGE FILEFLD
where (( Type = "KN" ))
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
--------------------------------------------------------------------------------
LOCATION FILEFLD
where ( Type = "LO" )
Is Used In No Indexes
Is Used In Rel - LOCATION-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
--------------------------------------------------------------------------------
LOCATION-EMPS OTOFLDS
where ( Relation: Location 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
--------------------------------------------------------------------------------
NOC FILEFLD
where ( Type = "NC" )
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
--------------------------------------------------------------------------------
OTHER-ATTRIB FILEFLD
where (( Type = "OA" ))
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
--------------------------------------------------------------------------------
PCODESDTL OTOFLDS
where ( Relation: Pcodesdtl 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
PROFICIENCY FILEFLD
where (( Type = "PF" ))
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
--------------------------------------------------------------------------------
REVIEW FILEFLD
where (( Type = "RT" )
Or ( Type = "PR" ))
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
--------------------------------------------------------------------------------
SKILL FILEFLD
where (( Type = "SK" ))
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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
UNION FILEFLD
where ( Type = "UN" )
Is Used In No Indexes
Is Used In Rel - UNION-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
--------------------------------------------------------------------------------
UNION-EMPS OTOFLDS
where ( Relation: Union 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
--------------------------------------------------------------------------------
USER-FIELDS FILEFLD
where ( Type = "U1"
Or Type = "U2"
Or Type = "U3"
Or Type = "U4"
Or Type = "U5"
Or Type = "U6"
Or Type = "U7"
Or Type = "U8" )
Is Used In No Indexes
Is Used In No Rels
Is Used In SubType - USER-FIELDS
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
USER-LEV-EMPS OTOFLDS
where ( Relation: User Lev 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
--------------------------------------------------------------------------------
USER-LEVEL FILEFLD
where ( Type = "UL" )
Is Used In No Indexes
Is Used In Rel - USER-LEV-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
--------------------------------------------------------------------------------
VW-EM-WEB-ALL FILEFLD
where ( Active Flag = "A"
And Web Available > "1"
And ( Type = "CE"
Or Type = "ED"
Or Type = "KN"
Or Type = "SK"
Or Type = "AB"
Or Type = "OA" ))
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
--------------------------------------------------------------------------------
VW-EM-WEB-CMP FILEFLD
where ( Active Flag = "A"
And Web Available > "1"
And ( Type = "KN"
Or Type = "SK"
Or Type = "AB"
Or Type = "OA" ))
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
--------------------------------------------------------------------------------
VW-EM-WEB-CRT FILEFLD
where ( Active Flag = "A"
And Web Available > "1"
And Type = "CE" )
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
--------------------------------------------------------------------------------
VW-EM-WEB-ED FILEFLD
where ( Active Flag = "A"
And Web Available > "1"
And 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
--------------------------------------------------------------------------------
VW-SU-WEB-ALL FILEFLD
where ( Active Flag = "A"
And Web Avail Supv > "1"
And ( Type = "CE"
Or Type = "ED"
Or Type = "KN"
Or Type = "SK"
Or Type = "AB"
Or Type = "OA" ))
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
--------------------------------------------------------------------------------
VW-SU-WEB-CMP FILEFLD
where ( Active Flag = "A"
And Web Avail Supv > "1"
And ( Type = "KN"
Or Type = "SK"
Or Type = "AB"
Or Type = "OA" ))
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
--------------------------------------------------------------------------------
VW-SU-WEB-CRT FILEFLD
where ( Active Flag = "A"
And Web Avail Supv > "1"
And Type = "CE" )
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
--------------------------------------------------------------------------------
VW-SU-WEB-ED FILEFLD
where ( Active Flag = "A"
And Web Avail Supv > "1"
And 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
--------------------------------------------------------------------------------
WEB-AVAIL FILEFLD
where (( Web Available > "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
--------------------------------------------------------------------------------
WEB-SUPV-ACTIV FILEFLD
where ( Active Flag = "A"
And Web Avail Supv > "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
--------------------------------------------------------------------------------
WEB-SUPV-AVAIL FILEFLD
where (( Web Avail Supv > "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
|
