Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PLAN


                               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 Index - PLNSET7
  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