| 
 | 
                               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
 |