Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPFLEXDOL


                            EMPFLEXDOL FILE

                         Employee Flex Dollars

The Employee Flex Dollar file contains information about an employee's flex
and pre-tax dollars for the flex plan year.

REFERENCED BY

BN00.1    BN246     BN320     BN325     BN46.1    BS13.1
BS14.1    BS15.1    HR170     HR70.1    BN232     BN242
BN245     BN340     BN350     BN36.1    BN65.1    BN71.1
BN72.1    BS10.1    BS11.1    BS12.1    HR11.1    HR11.2
HR511     HR650     PA02.1    PA100     PA102     PA502
PA52.1    PA52.3    PA52.4    PA52.5    PR110     PR113
PR120     PR13.1    PR13.5    PR13.6    PR13.8    BN04.1
BN06.1    BN08.1    BN104

UPDATED BY

BN100     BN101     BN102     BN103     BN105     BN145
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN430
BN45.1    BN531     BS32.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EFD-COMPANY            Numeric 4                                 BN100   BN102
Element: Company       Contains the company number.              BN145   BN45.1

EFD-START-DATE         Numeric 8  (yyyymmdd)                     BN100   BN102
Element: Date          Contains the start date of the employee   BN145   BN45.1
                       flex dollars.

EFD-EMPLOYEE           Numeric 9                                 BN100   BN102
Element: Employee      Contains the employee's number.           BN145   BN45.1

EFD-STOP-DATE          Numeric 8  (yyyymmdd)                     BN100   BN102
Element: Date          Contains the stop date of the flex        BN103   BN145
                       dollars.                                  BN45.1

EFD-MO-COMP-SPENT      Derived
Element: Mo Comp Spent This field is not used.

EFD-COMP-SPENT         Signed 11.2                               BN100   BN101
Element: Flex Dollars SThis field is not used.                   BN102   BN103
                                                                 BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFD-MO-EMP-SPENT       Derived
Element: Mo Emp Spent  This field is not used.

EFD-EMP-SPENT          Signed 11.2                               BN100   BN101
Employee Pre-tax       This field is not used.                   BN102   BN103
Dollars Spent                                                    BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFD-FLEX-PLAN          Alpha 4                                   BN100   BN102
Element: Flex Plan     Contains the flex plan for the flex       BN145   BN45.1
                       dollars.

EFD-SALARY             Signed 11.2                               BN100   BN102
Element: Salary        Contains the employee's salary used to    BN145   BN45.1
                       calculate the employee flex dollars.

EFD-ANNUAL-HOURS       Numeric 4                                 BN100   BN102
Element: Annual Hours  Contains the employee's annual hours      BN145   BN45.1
                       used to calculate the EFD-SALARY.

EFD-NBR-FTE            Signed 4.3                                BN100   BN102
Full Time              Contains the FTE used to calculate the    BN145   BN45.1
Equivalent Number      EFD-SALARY.

EFD-MO-COMP-FLX        Derived
Element: Mo Comp Flx

EFD-COMP-FLX-AMT       Signed 11.2                               BN100   BN102
Company Paid Flex      Contains the flex dollars the employee    BN145   BN45.1
Dollar Amt             received before benefit election. The
                       company can give flex dollars as a base
                       amount or as a percent of the employee's
                       salary.

EFD-MO-SERVICE         Derived
Element: Mo Service

EFD-SERV-CREDIT        Signed 11.2                               BN100   BN102
Element: Credits Per   Contains the amount of flex credits       BN145   BN45.1
                       given based on the employee's years of
                       service.

EFD-MO-AGE             Derived
Element: Mo Age

EFD-AGE-CREDIT         Signed 11.2                               BN100   BN102
Element: Credits Per   Contains the amount of flex credits       BN145   BN45.1
                       given based on the employee's age.

EFD-MO-DEPENDENTS      Derived
Element: Mo Dependents

EFD-DEP-CREDIT         Signed 11.2                               BN100   BN102
Element: Dependent CredContains the amount of flex credits       BN145   BN45.1
                       given based on the employee's number of
                       dependents.

EFD-LIFE-CREDIT        Signed 11.2                               BN100   BN102
Element: Life Credit   Contains the number of flex credits       BN145   BN45.1
                       given based on the employee's lifestyle
                       points.

EFD-MO-VACATION        Derived
Element: Mo Vacation

EFD-VAC-CREDIT         Signed 11.2                               BN100   BN102
Element: Vacation CrediContains the amount of flex dollars       BN31.1  BN31.2
                       given for the vacation hours the          BN32.1  BN32.2
                       employee sold.                            BN32.3

EFD-MO-EMP-FLEX        Derived
Element: Mo Emp Flex

EFD-EMP-FLEX-AMT       Signed 11.2                               BN100   BN102
Employee Flex          Contains the amount of employee pre-tax   BN145   BN45.1
Dollar Amount          dollars that can be used to purchase
                       benefits.

EFD-MO-COMP-AMT        Derived
Element: Mo Comp Amt

EFD-TOT-COMP-AMT       Signed 11.2                               BN100   BN102
Element: Total CompensaContains the total flex dollars           BN145   BN45.1
                       calculated for the employee based on the
                       COMP-FLX-AMT and all credits. This
                       amount will be increased or decreased if
                       the  flex dollars have a minimum or
                       maximum amount defined.

EFD-TOT-FLX-AMT        Derived
Element: Tot Flx Amt

EFD-UPDATE-FLAG        Alpha 1                                   BN100   BN102
Element: Update Flag   Indicates whether the employee's flex     BN145   BN45.1
                       dollar record was overridden.
                       Y = Yes

EFD-FLD-GROUP-NAME     Alpha 10                                  BN100   BN102
Element: Fld Group NameContains the employee group from the      BN145   BN45.1
                       flex dollar record used to calculate the
                       employee's flex dollars.

EFD-FLD-START-DATE     Numeric 8  (yyyymmdd)                     BN100   BN102
Element: Fld Start DateContains the flex dollar start date       BN145   BN45.1
                       from the flex dollar record used to
                       calculate the employee's flex dollars.

EFD-SAL-CALC-DATE      Numeric 8  (yyyymmdd)                     BN100   BN102
Element: Sal Calc Date Contains the date used to calculate the   BN145   BN45.1
                       flex salary.

EFD-AGE-CALC-DATE      Numeric 8  (yyyymmdd)                     BN100   BN102
Element: Age Calc Date Contains the date used to calculate age   BN145
                       credits.

EFD-SERV-CALC-DATE     Numeric 8  (yyyymmdd)                     BN100   BN102
Element: Serv Calc DateContains the date used to calculate the   BN145
                       years of service credits.

EFD-WK-COMP-FLX        Derived
Element: Wk Comp Flx

EFD-BI-COMP-FLX        Derived
Element: Bi Comp Flx

EFD-SM-COMP-FLX        Derived
Element: Sm Comp Flx

EFD-PP-COMP-FLX        Derived
Element: Pp Comp Flx

EFD-WK-SERVICE         Derived
Element: Wk Service

EFD-BI-SERVICE         Derived
Element: Bi Service

EFD-SM-SERVICE         Derived
Element: Sm Service

EFD-PP-SERVICE         Derived
Element: Pp Service

EFD-WK-AGE             Derived
Element: Wk Age

EFD-BI-AGE             Derived
Element: Bi Age

EFD-SM-AGE             Derived
Element: Sm Age

EFD-PP-AGE             Derived
Element: Pp Age

EFD-WK-DEPENDENTS      Derived
Element: Wk Dependents

EFD-BI-DEPENDENTS      Derived
Element: Bi Dependents

EFD-SM-DEPENDENTS      Derived
Element: Sm Dependents

EFD-PP-DEPENDENTS      Derived
Element: Pp Dependents

EFD-WK-LIFE            Derived
Element: Wk Life

EFD-BI-LIFE            Derived
Element: Bi Life

EFD-SM-LIFE            Derived
Element: Sm Life

EFD-MO-LIFE            Derived
Element: Mo Life

EFD-PP-LIFE            Derived
Element: Pp Life

EFD-WK-EMP-FLEX        Derived
Element: Wk Emp Flex

EFD-BI-EMP-FLEX        Derived
Element: Bi Emp Flex

EFD-SM-EMP-FLEX        Derived
Element: Sm Emp Flex

EFD-PP-EMP-FLEX        Derived
Element: Pp Emp Flex

EFD-WK-COMP-AMT        Derived
Element: Wk Comp Amt

EFD-BI-COMP-AMT        Derived
Element: Bi Comp Amt

EFD-SM-COMP-AMT        Derived
Element: Sm Comp Amt

EFD-PP-COMP-AMT        Derived
Element: Pp Comp Amt

EFD-WK-TOT-FLX-AMT     Derived
Element: Wk Tot Flx Amt

EFD-BI-TOT-FLX-AMT     Derived
Element: Bi Tot Flx Amt

EFD-SM-TOT-FLX-AMT     Derived
Element: Sm Tot Flx Amt

EFD-MO-TOT-FLX-AMT     Derived
Element: Mo Tot Flx Amt

EFD-PP-TOT-FLX-AMT     Derived
Element: Pp Tot Flx Amt

EFD-CREATION-DATE      Numeric 8  (yyyymmdd)                     BN100   BN102
Element: Date                                                    BN145   BN45.1

EFD-UPD-DATE           Numeric 8  (yyyymmdd)                     BN100   BN102
Element: Upd Date                                                BN103   BN145
                                                                 BN45.1

EFD-TIME-STAMP         Numeric 6  (hhmmss)                       BN100   BN102
Element: Time Stamp    Contains the server time (hour, minute,   BN103   BN145
                       and second) when the record was last      BN45.1
                       changed.

EFD-USER-ID            Alpha 10  (Lower Case)                    BN100   BN102
Element: User                                                    BN103   BN145
                                                                 BN45.1

EFD-CURRENCY-CODE      Alpha 5                                   BN100   BN102
Element: Currency Code This field contains the company base      BN145
                       currency code established in Company
                       (GL10.1 ).

EFD-CURR-ND            Numeric 1                                 BN100   BN102
Account Currency                                                 BN145
Code

                         EMPFLEXDOL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EFDSET1   COMPANY                                                BN00.1  BN100
          START-DATE                                             BN101   BN102
          EMPLOYEE                                               BN103   BN105
                                                                 BN145   BN246
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN320
                                                                 BN325   BN430
                                                                 BN46.1  BN531
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 HR170   HR70.1

EFDSET2   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          START-DATE*                                            BN105   BN145
                                                                 BN232   BN242
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN340   BN350
                                                                 BN36.1  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS10.1  BS11.1
                                                                 BS12.1  BS14.1
                                                                 BS32.1  HR11.1
                                                                 HR11.2  HR170
                                                                 ...

EFDSET3   COMPANY                                                BN04.1  BN06.1
          FLEX-PLAN                                              BN08.1  BN104
          START-DATE
          EMPLOYEE

EFDSET4   COMPANY                                                BN100   BN102
          EMPLOYEE                                               BN103
          FLEX-PLAN
          START-DATE

EFDSET5   COMPANY                                                BN145   HR11.1
          EMPLOYEE                                               HR11.2  HR511
          START-DATE                                             HR650   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

                         EMPFLEXDOL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            EFD-COMPANY           -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            EFD-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            EFD-COMPANY           -> EMP-COMPANY
                            EFD-EMPLOYEE          -> EMP-EMPLOYEE

Employee Group PERSGROUP    Not Required

                            EFD-COMPANY           -> PRG-COMPANY
                            EFD-FLD-GROUP-NAME    -> PRG-GROUP-NAME

Flex Plan      FLEXPLAN     Required

                            EFD-COMPANY           -> FLP-COMPANY
                            EFD-FLEX-PLAN         -> FLP-FLEX-PLAN

Flexplan       FLEXPLAN     Required

                            EFD-COMPANY           -> FLP-COMPANY
                            EFD-FLEX-PLAN         -> FLP-FLEX-PLAN

Pa Employee    PAEMPLOYEE   Required

                            EFD-COMPANY           -> PEM-COMPANY
                            EFD-EMPLOYEE          -> PEM-EMPLOYEE

                         EMPFLEXDOL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Empflexrem     EMPFLEXREM   Delete Cascades

                            EFD-COMPANY           -> EFR-COMPANY
                            EFD-EMPLOYEE          -> EFR-EMPLOYEE
                            EFD-START-DATE        -> EFR-PLAN-START-DT
                                                     EFR-START-DATE