|
|
CONDITION REPORT
----------------
FILE - PAJOBREQ
Condition Type
--------------------------------------------------------------------------------
APP-STATUS FILEFLD
where ( App Status != Spaces )
Is Used In No Indexes
Is Used In Rel - APP-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
--------------------------------------------------------------------------------
APPROVAL-EMP FILEFLD, ARRFLDS
where ( Approval Emp != Zeroes )
Is Used In No Indexes
Is Used In Rel - APPROVAL-EMP
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
--------------------------------------------------------------------------------
APPROVED FILEFLD
where ( Approval 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
--------------------------------------------------------------------------------
BARGAIN-UNIT FILEFLD
where ( Bargain Unit != Spaces )
Is Used In No Indexes
Is Used In Rel - BARGAIN-UNIT
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
--------------------------------------------------------------------------------
BASE-CURRENCY FILEFLD
where ( Currency Code != Spaces
Or Curr Code 2 != Spaces )
Is Used In No Indexes
Is Used In Rel - BASE-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
--------------------------------------------------------------------------------
CONTACT-NBR FILEFLD
where ( Contact Nbr != Zeroes )
Is Used In No Indexes
Is Used In Rel - CONTACT-NBR
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
--------------------------------------------------------------------------------
COST OTOFLDS
where ( Relation: Cost 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
--------------------------------------------------------------------------------
CUR-EXT-POST FILEFLD
where ( External Start <=
And ( External Stop = Zeroes
Or External Stop >= ))
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
--------------------------------------------------------------------------------
CUR-INT-POST FILEFLD
where ( Internal Start <=
And ( Internal Stop >=
Or Internal Stop = 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
--------------------------------------------------------------------------------
CURR-CODE-2 FILEFLD
where (( Curr Code 2 != Spaces ))
Is Used In No Indexes
Is Used In Rel - CURRENCY2
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
--------------------------------------------------------------------------------
EXT-APPLICANTS OTOFLDS
where ( Relation: Ext Applicants 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
--------------------------------------------------------------------------------
EXT-POST-OPEN FILEFLD
where (( External Start != Zeroes
And External Start <= )
And ( External Stop = Zeroes
Or External Stop >= )
And ( Closed Date = Zeroes
Or Closed 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
--------------------------------------------------------------------------------
GRADE-STEP FILEFLD
where (( Schedule != Spaces )
And ( Pay Grade != Spaces )
And ( Pay Step != Zeroes ))
Is Used In No Indexes
Is Used In Rel - GRADE-STEP
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
--------------------------------------------------------------------------------
INT-APPLICANTS OTOFLDS
where ( Relation: Int Applicants 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
--------------------------------------------------------------------------------
LOCATION FILEFLD
where ( Locat Code != Spaces )
Is Used In No Indexes
Is Used In Rel - LOCATION
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
--------------------------------------------------------------------------------
NO-POSITION FILEFLD
where (( Position = Spaces ))
Is Used In Index - PJRSET3
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-APPROVED FILEFLD
where ( Approval 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
--------------------------------------------------------------------------------
NOT-CLOSED FILEFLD
where ( Closed Date = 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
--------------------------------------------------------------------------------
NOT-CLOSED2 FILEFLD
where ( Closed Date = Zeroes
Or Closed 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-OPEN FILEFLD
where ( Open Date = 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
--------------------------------------------------------------------------------
OFFERS OTOFLDS
where ( Relation: Offers 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
--------------------------------------------------------------------------------
OPEN FILEFLD
where ( Open Date != 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
--------------------------------------------------------------------------------
OPEN-APPROVED FILEFLD
where ( Closed Date = Zeroes
And Open Date != 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
--------------------------------------------------------------------------------
POS-CHG-ERROR OTOFLDS
where ( Relation: Pos Chg Error 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
--------------------------------------------------------------------------------
POSITION FILEFLD
where (( Position != Spaces ))
Is Used In Index - PJRSET2
Is Used In Rel - POS-CHG-ERROR
- POS-DATE
- 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
--------------------------------------------------------------------------------
REP-EMPLOYEE FILEFLD
where ( Rep Employee != Zeroes )
Is Used In No Indexes
Is Used In Rel - REP-EMPLOYEE
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
--------------------------------------------------------------------------------
REQ-STATUS FILEFLD
where ( Req Status != Spaces )
Is Used In No Indexes
Is Used In Rel - REQ-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
--------------------------------------------------------------------------------
REQUEST-BY FILEFLD
where ( Request By != Zeroes )
Is Used In No Indexes
Is Used In Rel - REQUEST-BY
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
--------------------------------------------------------------------------------
SCHED-GRADE FILEFLD
where (( Schedule != Spaces )
And ( Pay Grade != Spaces )
And ( Pay Step = Zeroes ))
Is Used In No Indexes
Is Used In Rel - SCHED-GRADE
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
--------------------------------------------------------------------------------
SCHEDULE FILEFLD
where (( Schedule != Spaces )
And ( Pay Step = Zeroes ))
Is Used In No Indexes
Is Used In Rel - SCHEDULE
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
--------------------------------------------------------------------------------
SUPERVISOR FILEFLD
where ( Supervisor != Spaces )
Is Used In Index - PJRSET5
Is Used In Rel - SUPERVISOR
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
--------------------------------------------------------------------------------
UNION FILEFLD
where ( Union Code != Spaces )
Is Used In No Indexes
Is Used In Rel - UNION-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
--------------------------------------------------------------------------------
USER-LEVEL FILEFLD
where ( User Level != Spaces )
Is Used In No Indexes
Is Used In Rel - USER-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
--------------------------------------------------------------------------------
WORK-SCHEDULE FILEFLD
where ( Work Sched != Spaces )
Is Used In No Indexes
Is Used In Rel - WORK-SCHEDULE
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
|
