Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FLEXPLAN


                             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     BN340
BN350     BN430     BN45.1    BN531     BN59.1    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
Element: Company       Contains the company number, which
                       represents an established company.

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

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

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

FLP-ENTRY-MMDD         Numeric 4                                 BN06.1  BN430
Element: Entry Month DaContains 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
Element: Deduction TablContains the frequency table assigned
                       to the flex plan.

FLP-FLEX-PAY-CODE      Alpha 4                                   BN06.1
Element: Flex Credit PaContains the code that represents the
                       flex credit pay code assigned to the
                       flex plan.

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

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

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

FLP-CORE-HEALTH        Alpha 4                                   BN15.1
Element: Core Health PlIf 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
Element: Core Dental PlIf 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
Element: Core DisabilitIf 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
Element: Core Life PlanIf 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
Element: 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
Element: 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
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

FLP-CURR-ND            Numeric 1                                 BN06.1
Account Currency
Code

                         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