CONDITION REPORT
----------------
FILE - EMPVISA
Condition Type
--------------------------------------------------------------------------------
APPLY-STATUS FILEFLD
where ( Apply Status != Spaces )
Is Used In No Indexes
Is Used In Rel - APPLY-STATUS
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
--------------------------------------------------------------------------------
CITIZEN FILEFLD
where ( Citizen != Spaces )
Is Used In No Indexes
Is Used In Rel - CITIZEN
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 ( Renew 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
--------------------------------------------------------------------------------
DEPENDENT FILEFLD
where ( Dependent > Zeroes )
Is Used In No Indexes
Is Used In Rel - DEPENDENT
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 ( Dependent = 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
Condition Type
--------------------------------------------------------------------------------
EXPIRED FILEFLD
where (( Exp Date != Zeroes )
And ( Exp 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
--------------------------------------------------------------------------------
NOT-EXPIRED FILEFLD
where (( Exp Date = Zeroes )
Or ( Exp 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
--------------------------------------------------------------------------------
TRAV-DOCUMENT FILEFLD
where ( Trav Document != Spaces )
Is Used In No Indexes
Is Used In Rel - TRAVEL-DOC
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
--------------------------------------------------------------------------------
VISA-COUNTRY FILEFLD
where (( Visa Cntry Cd != Spaces ))
Is Used In No Indexes
Is Used In Rel - VISA-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
|