|
|
CONDITION REPORT
----------------
FILE - HRCORRESP
Condition Type
--------------------------------------------------------------------------------
APPLICANT FILEFLD
where ( Req Type = "2" )
Is Used In No Indexes
Is Used In Rel - APPLICANT
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 ( Base Currency != 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
--------------------------------------------------------------------------------
CHANGE-REASON FILEFLD
where ( Reason != Spaces )
Is Used In No Indexes
Is Used In Rel - CHANGE-REASON
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
--------------------------------------------------------------------------------
CHANGE-REQUEST FILEFLD
where ( Change Request != Spaces )
Is Used In No Indexes
Is Used In Rel - CHANGE-REQUEST
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
--------------------------------------------------------------------------------
COBRA-PART FILEFLD
where ( Req Type = "3" )
Is Used In No Indexes
Is Used In Rel - COBRA-PART
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
--------------------------------------------------------------------------------
COMM-METH-CHG FILEFLD
where ( Comm Meth Chg != Spaces )
Is Used In No Indexes
Is Used In Rel - COMM-METH-CHG
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
--------------------------------------------------------------------------------
COMM-METH-REQ FILEFLD
where ( Comm Method != Spaces )
Is Used In No Indexes
Is Used In Rel - COMM-METH-REQ
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 - 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
--------------------------------------------------------------------------------
DATA-REQUEST FILEFLD
where ( Data Requested != Spaces )
Is Used In No Indexes
Is Used In Rel - DATA-REQUEST
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 ( Req Type = "4" )
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
--------------------------------------------------------------------------------
EMP-HOME-ADDR FILEFLD
where ( Emp Address = "H" )
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
--------------------------------------------------------------------------------
EMP-NEITHER-AD FILEFLD
where ( Emp Address = "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
--------------------------------------------------------------------------------
EMP-SUP-ADDR FILEFLD
where ( Emp Address = "S" )
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
--------------------------------------------------------------------------------
EMPLOYEE FILEFLD
where ( Req Type = "1" )
Is Used In No Indexes
Is Used In Rel - 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
--------------------------------------------------------------------------------
EXTENSION-RSN FILEFLD
where ( Extension Rsn != Spaces )
Is Used In No Indexes
Is Used In Rel - EXTENSION-RSN
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
--------------------------------------------------------------------------------
EXTERNAL-INSTR OTOFLDS
where ( Relation: Instructor Exists
And Instructor->Employee = Zeroes )
Is Used In No Indexes
Is Used In Rel - EXTERNAL-INSTR
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
--------------------------------------------------------------------------------
INSTRUCTOR FILEFLD
where ( Req Type = "5" )
Is Used In No Indexes
Is Used In Rel - INSTRUCTOR
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
--------------------------------------------------------------------------------
INTER-INST-HM OTOFLDS
where ( Relation: Instruct Home Exists
And Relation: Instruct Pem 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
--------------------------------------------------------------------------------
INTER-INST-SUP OTOFLDS
where ( Relation: Instruct Pem 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
--------------------------------------------------------------------------------
INTERNAL-INSTR FILEFLD, OTOFLDS
where ( Relation: Instruct Home Exists
And Instruct Home->First Name != Spaces
And Id Nbr = Instructor->Instruct )
Is Used In No Indexes
Is Used In Rel - INSTRUCT-HOME
- INSTRUCT-PEM
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
|
