Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BENEFIT


                               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