CONDITION REPORT
----------------
FILE - BNCOVERAGE
Condition Type
--------------------------------------------------------------------------------
AGE-AS-OF-DATE FILEFLD
where ( Age First Mo = "A" )
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
--------------------------------------------------------------------------------
AGE-NOT-AS-OF FILEFLD
where ( Age First Mo = "C"
Or Age First Mo = "M"
Or Age First Mo = "F" )
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
--------------------------------------------------------------------------------
BN-SAL-RATE FILEFLD
where ( Salary Type != "B1"
Or Salary Type != "B2"
Or Salary Type != "B3"
Or Salary Type != "B4"
Or Salary Type != "B5"
Or Salary Type != "X" )
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
--------------------------------------------------------------------------------
BOTH-SPS-DEP FILEFLD
where ( Life Add Flg = "B" )
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
--------------------------------------------------------------------------------
COB-NOT-UPDATE FILEFLD
where ( Cobra Status != 3 )
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
--------------------------------------------------------------------------------
COBRA-COVER FILEFLD
where ( Cover Type = "C" )
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
--------------------------------------------------------------------------------
COV-0-EXISTS OTOFLDS
where ( Relation: Coverage 0 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
--------------------------------------------------------------------------------
COV-1-EXISTS OTOFLDS
where ( Relation: Coverage 1 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
--------------------------------------------------------------------------------
COV-2-EXISTS OTOFLDS
where ( Relation: Coverage 2 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
--------------------------------------------------------------------------------
COV-REDUCTION FILEFLD
where ( Rate Table != Spaces )
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
--------------------------------------------------------------------------------
COV-U-EXISTS OTOFLDS
where ( Relation: Coverage User 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
--------------------------------------------------------------------------------
COVERAGE-0 OTOFLDS
where ( Plan->Coverage Type = "0" )
Is Used In No Indexes
Is Used In Rel - COVERAGE-0
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
--------------------------------------------------------------------------------
COVERAGE-1 OTOFLDS
where ( Plan->Coverage Type = "1" )
Is Used In No Indexes
Is Used In Rel - COVERAGE-1
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
--------------------------------------------------------------------------------
COVERAGE-2 OTOFLDS
where ( Plan->Coverage Type = "2" )
Is Used In No Indexes
Is Used In Rel - COVERAGE-2
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
--------------------------------------------------------------------------------
COVERAGE-USER OTOFLDS
where ( Plan->Coverage Type = "X" )
Is Used In No Indexes
Is Used In Rel - COVERAGE-USER
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-ONLY FILEFLD
where ( Life Add Flg = "D" )
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-NOT-UPDATE FILEFLD
where ( Status != 3 )
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-COVER FILEFLD
where ( Cover Type = "E" )
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-ONLY FILEFLD
where ( Life Add Flg = "E" )
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-RATE FILEFLD
where ( Salary Type != "EM"
Or Salary Type != "E1"
Or Salary Type != "E2"
Or Salary Type != "E3"
Or Salary Type != "E4"
Or Salary Type != "E5" )
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
--------------------------------------------------------------------------------
FIXED-MULTIPLE FILEFLD
where (( Calc Type = "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
--------------------------------------------------------------------------------
FLAT-AMOUNT FILEFLD
where ( Calc Type = "F" )
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
--------------------------------------------------------------------------------
MULTIPLE FILEFLD
where ( Calc Type = "M" )
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
--------------------------------------------------------------------------------
PERCENT FILEFLD
where ( Calc Type = "P" )
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
--------------------------------------------------------------------------------
RET-NOT-UPDATE FILEFLD
where ( Ret Status != 3 )
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
--------------------------------------------------------------------------------
RETIREE-COVER FILEFLD
where ( Cover Type = "R" )
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
--------------------------------------------------------------------------------
SAL-AS-OF-DATE FILEFLD
where ( Sal First Mo = "A" )
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
--------------------------------------------------------------------------------
SAL-NOT-AS-OF FILEFLD
where ( Sal First Mo = "C"
Or Sal First Mo = "M"
Or Sal First Mo = "F" )
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
--------------------------------------------------------------------------------
SPOUSE-ONLY FILEFLD
where ( Life Add Flg = "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
--------------------------------------------------------------------------------
SUPPLEMENTAL FILEFLD
where ( Calc Type = "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
|