|
|
CONDITION REPORT
----------------
FILE - BENEFIT
Condition Type
--------------------------------------------------------------------------------
AFT-DED-MTCH-A FILEFLD
where ( Cmp Aft Seq != Zeroes
And Pct Amt Flag = "A" )
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 ( Cmp Aft Seq != Zeroes
And Pct Amt Flag = "P" )
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-MTCH-ONLY OTOFLDS
where (( Relation: Aft Ded Mtch A Exists
Or Relation: Aft Ded Mtch P Exists )
And ( Relation: Pre Ded Mtch A Does Not Exist
And Relation: Pre Ded Mtch P Does Not Exist ))
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-CONT FILEFLD, OTOFLDS
where ( Cnt Age Date != Zeroes
And Comp Match = Zeroes
And ( Plan->Contrib Type = "1"
Or Plan->Contrib Type = "2"
Or Plan->Contrib Type = "3"
Or Plan->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
--------------------------------------------------------------------------------
AMOUNT-CONT FILEFLD
where ( Pct Amt Flag = "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
--------------------------------------------------------------------------------
BI-WEEKLY OTOFLDS
where ( Employee->Pay Frequency = 2 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - EMP-PER-AMT
- PP-FLEX-PT
- PP-FLEX-PT-AT
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
BN-TA-EMPLOYEE OTOFLDS
where ( Relation: Bn Ta Employee 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
--------------------------------------------------------------------------------
BOTH-MTCH-A OTOFLDS
where ( Relation: Aft Ded Mtch A Exists
And Relation: Pre Ded Mtch A 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
--------------------------------------------------------------------------------
BOTH-MTCH-P OTOFLDS
where ( Relation: Aft Ded Mtch P Exists
And Relation: Pre Ded Mtch P 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
--------------------------------------------------------------------------------
BUY-VACATION OTOFLDS
where ( Plan->Plan Option = 14 )
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-AFT-DED FILEFLD
where ( Cmp Aft Seq != Zeroes
And Pct Amt Flag != "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
--------------------------------------------------------------------------------
CMP-AFT-DED-A FILEFLD
where ( Cmp Aft Seq != Zeroes
And Pct Amt Flag = "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
--------------------------------------------------------------------------------
CODA-EXISTS OTOFLDS
where ( Relation: Coda Account 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-DEDUCT FILEFLD
where ( Cmp Seq Nbr != Zeroes
And Pct Amt Flag != "A" )
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
--------------------------------------------------------------------------------
COMP-DEDUCT-A FILEFLD
where ( Cmp Seq Nbr != Zeroes
And Pct Amt Flag = "A" )
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
--------------------------------------------------------------------------------
COMPHIST-EXIST OTOFLDS
where ( Relation: Comphist 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
--------------------------------------------------------------------------------
CONT-0-EXISTS OTOFLDS
where ( Relation: Contrib 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
--------------------------------------------------------------------------------
CONT-1-EXISTS OTOFLDS
where ( Relation: Contrib 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
--------------------------------------------------------------------------------
CONT-2-EXISTS OTOFLDS
where ( Relation: Contrib 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
--------------------------------------------------------------------------------
CONT-3-EXISTS OTOFLDS
where ( Relation: Contrib 3 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
--------------------------------------------------------------------------------
CONT-4-EXISTS OTOFLDS
where ( Relation: Contrib 4 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
--------------------------------------------------------------------------------
CONT-5-EXISTS OTOFLDS
where ( Relation: Contrib 5 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
--------------------------------------------------------------------------------
CONT-5-NOT-VA FILEFLD, OTOFLDS
where ( Plan Type != "VA"
And Plan->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
--------------------------------------------------------------------------------
CONT-5-VAC FILEFLD, OTOFLDS
where ( Plan Type = "VA"
And Plan->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
--------------------------------------------------------------------------------
CONT-6-EXISTS OTOFLDS
where ( Relation: Contrib 6 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
--------------------------------------------------------------------------------
CONT-7-EXISTS OTOFLDS
where ( Relation: Contrib 7 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
--------------------------------------------------------------------------------
CONT-NOT-6 OTOFLDS
where ( Plan->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
--------------------------------------------------------------------------------
CONT-NOT-6-7 OTOFLDS
where (( Plan->Contrib Type != "6" )
And ( Plan->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-0 OTOFLDS
where ( Plan->Contrib Type = "0" )
Is Used In No Indexes
Is Used In Rel - CONTRIB-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
--------------------------------------------------------------------------------
CONTRIB-1 OTOFLDS
where ( Plan->Contrib Type = "1" )
Is Used In No Indexes
Is Used In Rel - CONTRIB-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
--------------------------------------------------------------------------------
CONTRIB-2 OTOFLDS
where ( Plan->Contrib Type = "2" )
Is Used In No Indexes
Is Used In Rel - CONTRIB-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
--------------------------------------------------------------------------------
CONTRIB-3 OTOFLDS
where ( Plan->Contrib Type = "3" )
Is Used In No Indexes
Is Used In Rel - CONTRIB-3
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 OTOFLDS
where ( Plan->Contrib Type = "4" )
Is Used In No Indexes
Is Used In Rel - CONTRIB-4
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 OTOFLDS
where ( Plan->Contrib Type = "5" )
Is Used In No Indexes
Is Used In Rel - CONTRIB-5
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 OTOFLDS
where ( Plan->Contrib Type = "6" )
Is Used In No Indexes
Is Used In Rel - CONTRIB-6
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 OTOFLDS
where ( Plan->Contrib Type = "7" )
Is Used In No Indexes
Is Used In Rel - CONTRIB-7
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-AMT-EXIST FILEFLD
where ( Cover Amt != 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
--------------------------------------------------------------------------------
COV-OPT-EXIST FILEFLD
where ( Cov Option != 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
--------------------------------------------------------------------------------
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 - BNCOVOPT
- 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
--------------------------------------------------------------------------------
CURRENT FILEFLD
where ( Start Date <=
And ( Stop Date >=
Or Stop Date = Zeroes ))
Is Used In No Indexes
Is Used In No Rels
Is Used In SubType - CURRENT
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
DC-AMOUNT FILEFLD
where ( Pct Amt Flag = "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
--------------------------------------------------------------------------------
DC-CO-ONLY FILEFLD
where ( Pct Amt Flag != "A"
And Pct Amt Flag != "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
--------------------------------------------------------------------------------
DC-PERCENT FILEFLD
where ( Pct Amt Flag = "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
--------------------------------------------------------------------------------
DEF-BENEFIT FILEFLD
where ( Plan Type = "DB" )
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 FILEFLD
where ( 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
--------------------------------------------------------------------------------
DEP-BENEFITS OTOFLDS
where ( Relation: Dependents 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
--------------------------------------------------------------------------------
DEP-COVER FILEFLD
where ( Dep Cover Amt != 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
--------------------------------------------------------------------------------
DEPENDENT-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-AFT-DED FILEFLD
where ( Aft Seq Nbr != Zeroes
And Pct Amt Flag != "A" )
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
--------------------------------------------------------------------------------
EMP-AFT-DED-A FILEFLD
where ( Aft Seq Nbr != Zeroes
And Pct Amt Flag = "A" )
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
--------------------------------------------------------------------------------
EMP-PRE-DED FILEFLD
where ( Pre Seq Nbr != Zeroes
And Pct Amt Flag != "A" )
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
--------------------------------------------------------------------------------
EMP-PRE-DED-A FILEFLD
where ( Pre Seq Nbr != Zeroes
And Pct Amt Flag = "A" )
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
--------------------------------------------------------------------------------
EMPLOYEE-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
--------------------------------------------------------------------------------
FLEX-CONT-6 FILEFLD, OTOFLDS
where ( Flex Plan != Spaces
And Plan->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
--------------------------------------------------------------------------------
FLEX-DC FILEFLD
where ( Flex Plan != Spaces
And 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
--------------------------------------------------------------------------------
FLEX-DED-SEQ FILEFLD
where ( Flex Ded Seq != Zeroes )
Is Used In No Indexes
Is Used In Rel - EMP-FLEX-DED
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-NOT-DC FILEFLD
where ( Flex Plan != Spaces
And 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
--------------------------------------------------------------------------------
FLEX-PLAN FILEFLD
where ( Flex Plan != Spaces )
Is Used In No Indexes
Is Used In Rel - FLEX-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
--------------------------------------------------------------------------------
FLEX-TYPES FILEFLD
where ( Plan Type = "HL"
Or Plan Type = "DN"
Or Plan Type = "DI"
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
--------------------------------------------------------------------------------
HEALTH-DENTAL FILEFLD
where ( Plan Type = "HL"
Or Plan Type = "DN" )
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
--------------------------------------------------------------------------------
INVEST-EXISTS OTOFLDS
where ( Relation: Invest Distrib 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
--------------------------------------------------------------------------------
MONTHLY OTOFLDS
where ( Employee->Pay Frequency = 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
--------------------------------------------------------------------------------
MULTIPLE FILEFLD
where ( Multiple != 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
--------------------------------------------------------------------------------
NO-COMP-DEDUCT FILEFLD
where ( Cmp Seq Nbr = Zeroes
And Cmp Aft Seq = 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
--------------------------------------------------------------------------------
NO-FLEX-CONT-6 FILEFLD, OTOFLDS
where ( Flex Plan = Spaces
And Plan->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
--------------------------------------------------------------------------------
NO-SAL-AGE-SRV FILEFLD, OTOFLDS
where ( Cnt Sal Date = Zeroes
And Cnt Age Date = Zeroes
And Cnt Serv Date = Zeroes
And Comp Match = Zeroes
And ( Plan->Contrib Type = "1"
Or Plan->Contrib Type = "2"
Or Plan->Contrib Type = "3"
Or Plan->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
--------------------------------------------------------------------------------
NON-FLEX-PLAN 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-FLEX-TYPES FILEFLD
where ( Plan Type = "HL"
Or Plan Type = "DN"
Or Plan Type = "DI"
Or Plan Type = "DL"
Or 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
--------------------------------------------------------------------------------
NON-WAIVE OTOFLDS
where ( Plan->Waive 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-MULT-DEP FILEFLD
where ( Multiple = Zeroes
And Dep Cover Amt = 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-SAV-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
--------------------------------------------------------------------------------
PERCENT-CONT FILEFLD
where ( Pct Amt Flag = "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
--------------------------------------------------------------------------------
PERCENT-COV FILEFLD
where ( Pay Rate != Zeroes
And Dep Cover Amt = Zeroes
And Multiple = Zeroes
And Cover Amt != 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
--------------------------------------------------------------------------------
PLANS-1-3 OTOFLDS
where ( Plan->Plan Option = 1
Or Plan->Plan Option = 2
Or Plan->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
--------------------------------------------------------------------------------
PRE-DED-MTCH-A FILEFLD
where ( Cmp Seq Nbr != Zeroes
And Pct Amt Flag = "A" )
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 ( Cmp Seq Nbr != Zeroes
And Pct Amt Flag = "P" )
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
--------------------------------------------------------------------------------
PRE-MTCH-ONLY OTOFLDS
where (( Relation: Pre Ded Mtch A Exists
Or Relation: Pre Ded Mtch P Exists )
And ( Relation: Aft Ded Mtch A Does Not Exist
And Relation: Aft Ded Mtch P Does Not Exist ))
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
--------------------------------------------------------------------------------
SAL-AGE-SRV FILEFLD, OTOFLDS
where((( Cnt Sal Date != Zeroes
Or Cnt Age Date != Zeroes
Or Cnt Serv Date != Zeroes )
And ( Comp Match = Zeroes ))
And ( Plan->Contrib Type = "1"
Or Plan->Contrib Type = "2"
Or Plan->Contrib Type = "3"
Or Plan->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
--------------------------------------------------------------------------------
SALARY-CONT FILEFLD, OTOFLDS
where ( Cnt Sal Date != Zeroes
And Comp Match = Zeroes
And ( Plan->Contrib Type = "1"
Or Plan->Contrib Type = "2"
Or Plan->Contrib Type = "3"
Or Plan->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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
SELL-VACATION OTOFLDS
where ( Plan->Plan Option = 15 )
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
--------------------------------------------------------------------------------
SEMI-MONTHLY OTOFLDS
where ( Employee->Pay Frequency = 1 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - EMP-PER-AMT
- PP-FLEX-PT
- PP-FLEX-PT-AT
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SERVICE-CONT FILEFLD, OTOFLDS
where ( Cnt Serv Date != Zeroes
And Comp Match = Zeroes
And ( Plan->Contrib Type = "1"
Or Plan->Contrib Type = "2"
Or Plan->Contrib Type = "3"
Or Plan->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
--------------------------------------------------------------------------------
SPEND-ONLY OTOFLDS
where ( Flex Plan->Spend Only = "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
--------------------------------------------------------------------------------
SPEND-ONLY-NO OTOFLDS
where ( Flex Plan->Spend Only = "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
--------------------------------------------------------------------------------
STM-EXISTS OTOFLDS
where ( Relation: Standtime 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
SUP-FLAT-COV FILEFLD
where ( Dep Cover Amt = Zeroes
And Pay Rate = Zeroes
And Multiple = Zeroes
And Cover Amt != 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
VESTING-EXISTS OTOFLDS
where ( Relation: Vesting Hours 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
--------------------------------------------------------------------------------
WAIVE OTOFLDS
where ( Plan->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
--------------------------------------------------------------------------------
WEEKLY OTOFLDS
where ( Employee->Pay Frequency = 1 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - EMP-PER-AMT
- PP-FLEX-PT
- PP-FLEX-PT-AT
Is Used In No AvfFlds
Is Used In No Rules
|
