CONDITION REPORT
----------------
FILE - PLAN
Condition Type
--------------------------------------------------------------------------------
ACR-ACCOUNT FILEFLD
where ( Acr Acct Unt != Spaces
And Acr Account != Zeroes
And Acr Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In Rel - ACR-ACCOUNT
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
--------------------------------------------------------------------------------
AFT-DED-CODE-A FILEFLD
where ( Aft Ded Code A != Spaces )
Is Used In No Indexes
Is Used In Rel - AFT-DED-CODE-A
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
--------------------------------------------------------------------------------
AFT-DED-CODE-P FILEFLD
where ( Aft Ded Mtch P != Spaces )
Is Used In No Indexes
Is Used In Rel - AFT-DED-CODE-P
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
--------------------------------------------------------------------------------
AFT-DED-MTCH-A FILEFLD
where ( Aft Ded Mtch A != Spaces )
Is Used In No Indexes
Is Used In Rel - AFT-DED-MTCH-A
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
--------------------------------------------------------------------------------
AFT-DED-MTCH-P FILEFLD
where ( Aft Ded Mtch P != Spaces )
Is Used In No Indexes
Is Used In Rel - AFT-DED-MTCH-P
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
--------------------------------------------------------------------------------
AFT-LMT-DED-A FILEFLD
where ( Aft Lmt Ded A != Spaces )
Is Used In No Indexes
Is Used In Rel - AFT-LMT-DED-A
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
--------------------------------------------------------------------------------
AFT-LMT-DED-P FILEFLD
where ( Aft Lmt Ded P != Spaces )
Is Used In No Indexes
Is Used In Rel - AFT-LMT-DED-P
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
--------------------------------------------------------------------------------
AFT-LMT-MTCH-A FILEFLD
where ( Aft Lmt Mtch A != Spaces )
Is Used In No Indexes
Is Used In Rel - AFT-LMT-MTCH-A
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
--------------------------------------------------------------------------------
AFT-LMT-MTCH-P FILEFLD
where ( Aft Lmt Mtch P != Spaces )
Is Used In No Indexes
Is Used In Rel - AFT-LMT-MTCH-P
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
--------------------------------------------------------------------------------
AMT-DEDS-EXIST FILEFLD
where ( Pre Ded Code A != Spaces
Or Aft Ded Code A != Spaces
Or Cmp Ded Code A != 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
--------------------------------------------------------------------------------
AMT-MTCH-EXIST FILEFLD
where ( Pre Ded Mtch A != Spaces
Or Aft Ded Mtch A != 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
--------------------------------------------------------------------------------
AR-ACCOUNT FILEFLD
where ( Ar Acct Unit != Spaces
And Ar Account != Zeroes
And Ar Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In Rel - AR-ACCOUNT
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
--------------------------------------------------------------------------------
BNA-EXISTS OTOFLDS
where ( Relation: Bnaccounts 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
--------------------------------------------------------------------------------
CANADA FILEFLD
where ( Country Code = "CA" )
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
--------------------------------------------------------------------------------
CMP-DED-CODE-A FILEFLD
where ( Cmp Ded Code A != Spaces )
Is Used In No Indexes
Is Used In Rel - CMP-DED-CODE-A
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
--------------------------------------------------------------------------------
CMP-DED-CODE-P FILEFLD
where ( Cmp Ded Code P != Spaces )
Is Used In No Indexes
Is Used In Rel - CMP-DED-CODE-P
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
--------------------------------------------------------------------------------
CO-MATCH-EXIST FILEFLD
where ( Pre Ded Mtch A != Spaces
Or Aft Ded Mtch A != Spaces
Or Pre Ded Mtch P != Spaces
Or Aft Ded Mtch P != 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
--------------------------------------------------------------------------------
COBRA-TYPES FILEFLD
where ( Plan Type = "HL"
Or Plan Type = "DN"
Or Plan Type = "EL"
Or Plan Type = "RS" )
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
--------------------------------------------------------------------------------
COMMENTS-EXIST OTOFLDS
where ( Relation: Comments 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
--------------------------------------------------------------------------------
COMP-CLASS FILEFLD
where ( Comp Class != Spaces )
Is Used In No Indexes
Is Used In Rel - COMP-CLASS
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
--------------------------------------------------------------------------------
CONTRIB-1 FILEFLD
where ( Contrib 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
--------------------------------------------------------------------------------
CONTRIB-2 FILEFLD
where ( Contrib Type = "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
--------------------------------------------------------------------------------
CONTRIB-3 FILEFLD
where ( Contrib Type = "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
--------------------------------------------------------------------------------
CONTRIB-4 FILEFLD
where ( Contrib Type = "4" )
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
--------------------------------------------------------------------------------
CONTRIB-5 FILEFLD
where ( Contrib Type = "5" )
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
--------------------------------------------------------------------------------
CONTRIB-6 FILEFLD
where ( Contrib Type = "6" )
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
--------------------------------------------------------------------------------
CONTRIB-7 FILEFLD
where ( Contrib Type = "7" )
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
--------------------------------------------------------------------------------
CONTRIB-BLANK FILEFLD
where ( Contrib Type != "1"
Or Contrib Type != "2"
Or Contrib Type != "3"
Or Contrib Type != "4"
Or Contrib Type != "5"
Or Contrib Type != "6"
Or Contrib Type != "7" )
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-1 FILEFLD
where ( Coverage 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
--------------------------------------------------------------------------------
COVERAGE-2 FILEFLD
where ( Coverage Type = "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
--------------------------------------------------------------------------------
COVERAGE-BLANK FILEFLD
where ( Coverage Type != "1"
Or Coverage Type != "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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
DC-TYPE-1-3 FILEFLD
where ( Plan Type = "DC"
And ( Plan Option = 1
Or Plan Option = 2
Or Plan Option = 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
--------------------------------------------------------------------------------
DC-TYPE-4-7 FILEFLD
where ( Plan Type = "DC"
And ( Plan Option = 4
Or Plan Option = 5
Or Plan Option = 6
Or Plan Option = 7 ))
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
--------------------------------------------------------------------------------
DED-FREQ-TABLE FILEFLD
where ( Ded Table != Spaces )
Is Used In No Indexes
Is Used In Rel - DED-FREQ-TABLE
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
--------------------------------------------------------------------------------
DED-NOT-UPDATE FILEFLD
where ( Ded Freq Flag != 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
--------------------------------------------------------------------------------
DEF-CONT-BEN FILEFLD
where ( Plan Type = "DB"
Or Plan Type = "DC" )
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
--------------------------------------------------------------------------------
DEFAULT-PLAN FILEFLD
where ( Default != "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
--------------------------------------------------------------------------------
DEP-LIFE FILEFLD
where ( Plan Type = "DL" )
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
--------------------------------------------------------------------------------
DISABILITY FILEFLD
where ( Plan Type = "DI" )
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-LIFE FILEFLD
where ( Plan Type = "EL" )
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
--------------------------------------------------------------------------------
EXP-ACCOUNT FILEFLD
where ( Exp Acct Unt != Spaces
And Exp Account != Zeroes
And Exp Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In Rel - EXP-ACCOUNT
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
--------------------------------------------------------------------------------
FLEX-DED-CODE FILEFLD
where ( Flex Ded Code != Spaces )
Is Used In No Indexes
Is Used In Rel - FLEX-DED-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
--------------------------------------------------------------------------------
FLEX-HL-DN FILEFLD
where (( Plan Type = "HL"
Or Plan Type = "DN" )
And Flex Plan != 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
--------------------------------------------------------------------------------
FLEX-PAY-CODE FILEFLD
where ( Flex Pay Code != Spaces )
Is Used In No Indexes
Is Used In Rel - FLEX-PAY-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
--------------------------------------------------------------------------------
FLEXIBLE-PLAN FILEFLD
where ( Flex Plan != Spaces )
Is Used In No Indexes
Is Used In Rel - FLEXIBLE-PLAN
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
--------------------------------------------------------------------------------
HEALTH-DENTAL FILEFLD
where (( Plan Type = "HL"
Or Plan Type = "DN" )
And Flex Plan = 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
--------------------------------------------------------------------------------
INS-CARRIER FILEFLD
where ( Ins Carrier != Spaces )
Is Used In No Indexes
Is Used In Rel - INS-CARRIER
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
--------------------------------------------------------------------------------
INVEST-EXISTS OTOFLDS
where ( Relation: Investment 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
--------------------------------------------------------------------------------
NO-AMT-DEDS FILEFLD
where (( Pre Ded Code A = Spaces
And Aft Lmt Ded A = Spaces
And Aft Ded Code A = Spaces
And Cmp Ded Code A = 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
--------------------------------------------------------------------------------
NO-MATCH-DEDS FILEFLD
where (( Pre Ded Mtch A = Spaces
And Aft Lmt Mtch A = Spaces
And Aft Ded Mtch A = Spaces
And Pre Ded Mtch P = Spaces
And Pre Ded Mtch P = Spaces
And Aft Ded Mtch P = 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
--------------------------------------------------------------------------------
NO-PCT-DEDS FILEFLD
where (( Pre Ded Code P = Spaces
And Aft Lmt Ded P = Spaces
And Aft Ded Code P = Spaces
And Cmp Ded Code P = 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
--------------------------------------------------------------------------------
NON-FLEX FILEFLD
where ( Flex Plan = 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
--------------------------------------------------------------------------------
NON-WAIVE-PLAN FILEFLD
where ( Waive Flag != "Y" )
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-CANADA FILEFLD
where ( Country Code != "CA" )
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-DC-4-7 FILEFLD
where ( Plan Type != "DC"
And ( Plan Option != 4
Or Plan Option != 5
Or Plan Option != 6
Or Plan Option != 7 ))
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
--------------------------------------------------------------------------------
PARTBEN-EXISTS OTOFLDS
where ( Relation: Partben 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
--------------------------------------------------------------------------------
PCT-DEDS-EXIST FILEFLD
where ( Pre Ded Code P != Spaces
Or Aft Ded Code P != Spaces
Or Cmp Ded Code P != 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
--------------------------------------------------------------------------------
PCT-MTCH-EXIST FILEFLD
where ( Pre Ded Mtch P != Spaces
Or Aft Ded Mtch P != 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
--------------------------------------------------------------------------------
PERSONNEL-GRP FILEFLD
where ( Group Name != Spaces )
Is Used In No Indexes
Is Used In Rel - PERSONNEL-GRP
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-NAME FILEFLD
where ( Plan Name != Spaces )
Is Used In No Indexes
Is Used In Rel - PLAN-NAME
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
--------------------------------------------------------------------------------
PLNSET4 FILEFLD
where ( Ded Freq Flag = Zeroes )
Is Used In Index - PLNSET4
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
--------------------------------------------------------------------------------
POSTAL-CODE FILEFLD
where ( Post Code Tbl != Spaces )
Is Used In No Indexes
Is Used In Rel - POSTAL-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
--------------------------------------------------------------------------------
PRE-DED-CODE-A FILEFLD
where ( Pre Ded Code A != Spaces )
Is Used In No Indexes
Is Used In Rel - PRE-DED-CODE-A
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
--------------------------------------------------------------------------------
PRE-DED-CODE-P FILEFLD
where ( Pre Ded Code P != Spaces )
Is Used In No Indexes
Is Used In Rel - PRE-DED-CODE-P
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
--------------------------------------------------------------------------------
PRE-DED-MTCH-A FILEFLD
where ( Pre Ded Mtch A != Spaces )
Is Used In No Indexes
Is Used In Rel - PRE-DED-MTCH-A
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
--------------------------------------------------------------------------------
PRE-DED-MTCH-P FILEFLD
where ( Pre Ded Mtch P != Spaces )
Is Used In No Indexes
Is Used In Rel - PRE-DED-MTCH-P
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
--------------------------------------------------------------------------------
PT-AT-AMT-DED FILEFLD
where (( Pre Ded Code A != Spaces
Or Aft Ded Code A != Spaces )
And Cmp Ded Code A = 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
--------------------------------------------------------------------------------
PT-AT-PCT-DED FILEFLD
where (( Pre Ded Code P != Spaces
Or Aft Ded Code P != Spaces )
And Cmp Ded Code P = 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
--------------------------------------------------------------------------------
REGISTR-EXISTS FILEFLD
where ( Registr Nbr != 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
--------------------------------------------------------------------------------
RESERVE-ACCT FILEFLD
where ( Plan Type = "RS" )
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-TYPES FILEFLD
where ( Plan Type = "HL"
Or Plan Type = "DN"
Or Plan Type = "EL"
Or Plan Type = "DL" )
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
--------------------------------------------------------------------------------
SAVINGS-BOND FILEFLD
where ( Plan Type = "SB" )
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
--------------------------------------------------------------------------------
STOCK-PURCH FILEFLD
where ( Plan Type = "SP" )
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
--------------------------------------------------------------------------------
UNITED-STATES FILEFLD
where ( Country Code = "US" )
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
--------------------------------------------------------------------------------
VACATION FILEFLD
where ( Plan Type = "VA" )
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
--------------------------------------------------------------------------------
VEST-CLASS FILEFLD
where ( Vest Class != Spaces )
Is Used In No Indexes
Is Used In Rel - VEST-CLASS
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
--------------------------------------------------------------------------------
WAIVE-PLAN FILEFLD
where ( Waive Flag = "Y" )
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
|
