Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             FLEXPLAN FILE

                               Flex Plan

The Flex Plan file contains information about flex plans.

REFERENCED BY

BN08.1    BN100     BN101     BN102     BN103     BN105
BN138     BN145     BN16.1    BN16.2    BN16.3    BN16.4
BN206     BN215     BN216     BN220     BN230     BN232
BN238     BN245     BN246     BN258     BN259     BN31.1
BN31.2    BN32.1    BN32.2    BN32.3    BN325     BN350
BN430     BN45.1    BN531     BN59.3    BN65.1    BN65.2
BN71.1    BN72.1    BS10.1    BS12.1    BS32.1    HFLP.1
HR55.1    PR20.4    PRBN.1

UPDATED BY

BN00.1    BN04.1    BN06.1    BN104     BN15.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

FLP-COMPANY          Numeric 4                                   BN06.1
Company              Contains the company number, which
                     represents an established company.

FLP-FLEX-PLAN        Alpha 4                                     BN06.1
Flex Plan            Contains the code that represents the
                     flex plan.

FLP-DESC             Alpha 30  (Lower Case)                      BN06.1
Description          Contains the description of the flex
                     plan.

FLP-GROUP-NAME       Alpha 10                                    BN06.1
Group Name           Contains the employee group for
                     eligibility.

FLP-ENTRY-MMDD       Numeric 4                                   BN06.1  BN430
Entry Month Day      Contains the date the flex plan year
                     begins.

                     The flex plan year is the twelve month
                     period beginning on this month and day.

FLP-SPEND-ONLY       Alpha 1                                     BN06.1
Spending Account     Indicates whether the flex plan is a
Only                 spending account only.
                     N = No
                     Y = Yes

FLP-DED-TABLE        Alpha 2                                     BN06.1
Deduction Table      Contains the frequency table assigned
                     to the flex plan.

FLP-FLEX-PAY-CODE    Alpha 4                                     BN06.1
Flex Credit Pay Code Contains the code that represents the
                     flex credit pay code assigned to the
                     flex plan.

FLP-PIK-PAY-CODE     Alpha 4
Pik Pay Code         This field is not used.

FLP-PRE-TAX-DED      Alpha 4
Pre Tax Ded          This field is not used.

FLP-ATN-DED          Alpha 4
Atn Ded              This field is not used.

FLP-CORE-HEALTH      Alpha 4                                     BN15.1
Core Health Plan     If a health benefit plan under the flex
                     plan is defined as a core plan, this
                     field is updated as Yes or Spouse.

FLP-CORE-DENTAL      Alpha 4                                     BN15.1
Core Dental Plan     If a dental benefit plan under the flex
                     plan is defined as a core plan, this
                     field is updated as Yes or Spouse.

FLP-CORE-DISAB       Alpha 4                                     BN15.1
Core Disability Plan If a disability benefit plan under the
                     flex plan is defined  as a core plan,
                     this field is updated  with Yes.

FLP-CORE-LIFE        Alpha 4                                     BN15.1
Core Life Plan       If an employee life benefit plan under
                     the flex plan is defined as a core plan,
                     this field is updated as Yes.

FLP-CORE-DEP-LIFE    Alpha 4                                     BN15.1
Core Dep Life        If a dependent life benefit plan under
                     the flex plan is defined as a core plan,
                     this field is updated with Yes or
                     Spouse.

FLP-HEALTH-FLAG      Alpha 1                                     BN15.1
Core Benefit Health
Flag

FLP-DENTAL-FLAG      Alpha 1                                     BN15.1
Core Benefit Dental
Flag

FLP-DISAB-FLAG       Alpha 1                                     BN15.1
Core Benefit
Disability Flag

FLP-LIFE-FLAG        Alpha 1                                     BN15.1
Core Benefit Life
Flag

FLP-DEP-LIFE-FLAG    Alpha 1                                     BN15.1
Dep Life Flag

FLP-DED-FREQ-FLAG    Numeric 1                                   BN04.1  BN06.1
Update Deduct Freq   0 = Not Updated                             BN104
Table Flag           1 = Updated

FLP-CURRENCY-CODE    Alpha 5                                     BN06.1
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

FLP-CURR-ND          Numeric 1                                   BN06.1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

                         FLEXPLAN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FLPSET1   COMPANY                                                BN00.1  BN04.1
          FLEX-PLAN                                              BN06.1  BN08.1
                                                                 BN100   BN101
                                                                 BN102   BN103
                                                                 BN104   BN105
                                                                 BN138   BN145
                                                                 BN15.1  BN16.1
                                                                 BN16.2  BN16.3
                                                                 BN16.4  BN206
                                                                 BN215   BN216
                                                                 BN220   BN230
                                                                 BN232   BN238
                                                                 BN245   BN246
                                                                 BN258   BN259
                                                                 BN31.1  BN31.2
                                                                 ...

FLPSET2   COMPANY       KeyChange                                BN04.1
          DED-TABLE
          FLEX-PLAN

                         FLEXPLAN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Atn Ded        DEDCODE      Required

                            FLP-COMPANY          -> DDC-COMPANY
                            FLP-ATN-DED          -> DDC-DED-CODE

Company        BNCOMPANY    Required

                            FLP-COMPANY          -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            FLP-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When FLP-CURRENCY-CODE != Spaces

                            FLP-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Deduct Table   DEDFREQTBL   Required

                            FLP-COMPANY          -> DFT-COMPANY
                            FLP-DED-TABLE        -> DFT-TABLE-CODE

Di Core Plan   PLAN         Not Required

                            FLP-COMPANY          -> PLN-COMPANY
                            "DI"                 -> PLN-PLAN-TYPE
                            FLP-CORE-DISAB       -> PLN-PLAN-CODE

Dl Core Plan   PLAN         Not Required

                            FLP-COMPANY          -> PLN-COMPANY
                            "DL"                 -> PLN-PLAN-TYPE
                            FLP-CORE-DEP-LIFE    -> PLN-PLAN-CODE

Dn Core Plan   PLAN         Not Required

                            FLP-COMPANY          -> PLN-COMPANY
                            "DN"                 -> PLN-PLAN-TYPE
                            FLP-CORE-DENTAL      -> PLN-PLAN-CODE

El Core Plan   PLAN         Not Required

                            FLP-COMPANY          -> PLN-COMPANY
                            "EL"                 -> PLN-PLAN-TYPE
                            FLP-CORE-LIFE        -> PLN-PLAN-CODE

Flex Pay Code  PRPAYCODE    Required
                            When FLP-FLEX-PAY-CODE != Spaces

                            FLP-COMPANY          -> PCD-COMPANY
                            FLP-FLEX-PAY-CODE    -> PCD-PAY-CODE
                            Spaces               -> PCD-PROCESS-LEVEL
                            Spaces               -> PCD-JOB-CODE

Group Name     PERSGROUP    Not Required

                            FLP-COMPANY          -> PRG-COMPANY
                            FLP-GROUP-NAME       -> PRG-GROUP-NAME

Hl Core Plan   PLAN         Not Required

                            FLP-COMPANY          -> PLN-COMPANY
                            "HL"                 -> PLN-PLAN-TYPE
                            FLP-CORE-HEALTH      -> PLN-PLAN-CODE

Pik Pay Code   PRPAYCODE    Required

                            FLP-COMPANY          -> PCD-COMPANY
                            FLP-PIK-PAY-CODE     -> PCD-PAY-CODE
                            Spaces               -> PCD-PROCESS-LEVEL
                            Spaces               -> PCD-JOB-CODE

Pre Tax Ded    DEDCODE      Required

                            FLP-COMPANY          -> DDC-COMPANY
                            FLP-PRE-TAX-DED      -> DDC-DED-CODE

                         FLEXPLAN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Flex Dollars   FLEXDOLLAR

                            FLP-COMPANY          -> FLD-COMPANY
                            FLP-FLEX-PLAN        -> FLD-FLEX-PLAN
                                                    FLD-START-DATE
                                                    FLD-GROUP-NAME