CONDITION REPORT
                               ----------------
       
   FILE - APPJOBHIST
  Condition         Type
--------------------------------------------------------------------------------
  APPLICANT         FILEFLD
  where  (                      Applicant != Zeroes                         )
  Is Used In No Indexes
  Is Used In Rel - APPLICANT
                 - 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
--------------------------------------------------------------------------------
  COMMENTS-EXIST    OTOFLDS
  where  (             Relation: 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
--------------------------------------------------------------------------------
  CONTACTED         FILEFLD
  where  (                   Contact 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
--------------------------------------------------------------------------------
  COUNTRY           FILEFLD
  where ((                   Country Code != Spaces                         ))
  Is Used In No Indexes
  Is Used In Rel - COUNTRY
  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
--------------------------------------------------------------------------------
  EMPLOYEE          FILEFLD
  where  (                       Employee != Zeroes                         )
  Is Used In Index - AJHSET3
  Is Used In Rel - EMP-COMMENTS
                 - 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
--------------------------------------------------------------------------------
  EMPLOYEE-EXIST    OTOFLDS
  where  (             Relation: Employee 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
--------------------------------------------------------------------------------
  JOB-CODE          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
--------------------------------------------------------------------------------
  SEQ-NBR-BLANK     FILEFLD
  where  (                        Seq Nbr  = 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
 |