CONDITION REPORT
----------------
FILE - TAEMPSERV
Condition Type
--------------------------------------------------------------------------------
ABSENCES FILEFLD
where (( Event Type = 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
--------------------------------------------------------------------------------
ALL-OPEN FILEFLD
where (( Service Status != 9 )
And ( Event Status != 9 ))
Is Used In Index - TESSET8
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
--------------------------------------------------------------------------------
CURRENCY FILEFLD
where (( Currency Code != Spaces ))
Is Used In No Indexes
Is Used In Rel - 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
--------------------------------------------------------------------------------
DEPARTMENT FILEFLD
where (( Department != Spaces ))
Is Used In No Indexes
Is Used In Rel - DEPARTMENT
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
--------------------------------------------------------------------------------
EVENT-STATUS FILEFLD
where (( Service Code != Spaces )
And ( Plan Balance != Zeroes )
And ( Event Status != 9 )
And (( Status = 2 )
Or ( Status = 3 )
Or ( Status = 4 )
Or ( Status = 5 )
Or ( Status = 9 )))
Is Used In Index - TESSET5
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
--------------------------------------------------------------------------------
OCCURRENCE FILEFLD
where (( Occurrence = "2" ))
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
--------------------------------------------------------------------------------
OPEN-EVENTS FILEFLD
where (( Event Status != 9 ))
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
--------------------------------------------------------------------------------
PLAN-EVENT FILEFLD
where (( Service Code != Spaces )
And ( Plan Balance != 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
--------------------------------------------------------------------------------
PLAN-SERVICE FILEFLD
where (( Service Code != Spaces ))
Is Used In Index - TESSET3
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
--------------------------------------------------------------------------------
POSITION FILEFLD
where (( Position != Spaces ))
Is Used In No Indexes
Is Used In Rel - POSITION
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
--------------------------------------------------------------------------------
PROCESS-LEVEL FILEFLD
where (( Process Level != Spaces ))
Is Used In No Indexes
Is Used In Rel - PROCESS-LEVEL
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
--------------------------------------------------------------------------------
REASON-CODE FILEFLD
where (( Reason Code != Spaces ))
Is Used In No Indexes
Is Used In Rel - REASON-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
--------------------------------------------------------------------------------
SERVICE-CODE FILEFLD
where (( Service Code != Spaces ))
Is Used In No Indexes
Is Used In Rel - SERVICE-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
--------------------------------------------------------------------------------
SERVICE-STATUS FILEFLD
where (( Service Status != 9 ))
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
--------------------------------------------------------------------------------
STATUS FILEFLD
where (( Status = 2 )
Or ( Status = 3 )
Or ( Status = 4 )
Or ( Status = 5 )
Or ( Status = 9 ))
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
--------------------------------------------------------------------------------
TRD-STATUS FILEFLD
where((( Status = 2 )
Or ( Status = 3 )
Or ( Status = 4 )
Or ( Status = 5 ))
And ( Service Code != Spaces ))
Is Used In Index - TESSET2
- TESSET4
- TESSET6
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
|
