|
CONDITION REPORT
----------------
FILE - PAPREREQ
Condition Type
--------------------------------------------------------------------------------
COMPETENCY FILEFLD
where (( Prereq Type = "AB" )
Or ( Prereq Type = "KN" )
Or ( Prereq Type = "OA" )
Or ( Prereq Type = "SK" ))
Is Used In No Indexes
Is Used In Rel - COMPETENCY
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 FILEFLD, OTOFLDS
where (( Prereq Type = "CS" )
And ( Relation: Course Prereq 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 3 Rules
Condition Type
--------------------------------------------------------------------------------
COURSE-TYPE FILEFLD
where ( Prereq Type = "CS" )
Is Used In No Indexes
Is Used In Rel - COURSE-PREREQ
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
--------------------------------------------------------------------------------
CURRENT FILEFLD
where (( Effective Date <= )
And (( End Date = Zeroes )
Or ( End Date >= )))
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
--------------------------------------------------------------------------------
GROUP FILEFLD, OTOFLDS
where (( Prereq Type = "EG" )
And ( Relation: Group 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 1 Rule
Condition Type
--------------------------------------------------------------------------------
GROUP-TYPE FILEFLD
where ( Prereq Type = "EG" )
Is Used In No Indexes
Is Used In Rel - COMPGROUP
- GROUP
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-REQUIRED FILEFLD
where (( Required Flag = "N" ))
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 (( Profic Level != Spaces ))
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
--------------------------------------------------------------------------------
REQUIRED 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
--------------------------------------------------------------------------------
SERVICE FILEFLD
where (( Prereq Type = "SV" ))
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
--------------------------------------------------------------------------------
SKILL FILEFLD, OTOFLDS
where (( Prereq Type = "SK" )
And ( Relation: Skillcode Exists ))
Is Used In No Indexes
Is Used In Rel - SKILLCODE
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
|