Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPFLEXREM


                            EMPFLEXREM FILE

                      Employee Flex Period Dollars

The Employee Flex Period Dollars file contains information about an
employee's flex benefit periods.

REFERENCED BY

BN104     BN51.2    BN232     BN242     BN46.1    BN46.2
BS12.1    HR170     HR70.1

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

EFR-COMPANY            Numeric 4                                 BN100   BN102
Element: Company       Contains the company number. The number   BN145   BN45.1
                       correlates all information about the
                       company.

EFR-EMPLOYEE           Numeric 9                                 BN100   BN102
Element: Employee      Contains the employee's number. The       BN145   BN45.1
                       number correlates all information about
                       the employee.

EFR-PLAN-START-DT      Numeric 8  (yyyymmdd)                     BN100   BN102
Element: Start Date    Contains the start date of the flex       BN145   BN45.1
                       plan year.

EFR-START-DATE         Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Date          Contains the start date of the flex       BN102   BN103
                       benefit period.                           BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-STOP-DATE          Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Date          Contains the stop date of the flex        BN102   BN103
                       benefit period.                           BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-CREDITS-AVAIL      Signed 11.2                               BN100   BN101
Element: Flex AvailableContains the amount of flex dollars the   BN102   BN103
                       employee received before electing         BN105   BN145
                       benefits for the flex benefit period.     BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-CREDITS-SPENT      Signed 11.2                               BN100   BN101
Element: Flex Spent    Contains the flex dollars that were       BN102   BN103
                       spent for benefits during the flex        BN105   BN31.1
                       benefit period.                           BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN531   BS32.1

EFR-PRE-TAX-AVAIL      Signed 11.2                               BN100   BN101
Element: Pre-Tax AvailaContains the employee's available         BN102   BN103
                       pre-tax dollars for the flex benefit      BN105   BN145
                       period.                                   BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-PRE-TAX-SPENT      Signed 11.2                               BN100   BN101
Element: Pre-Tax Spent Contains the pre-tax dollars that were    BN102   BN103
                       spent for benefits during the flex        BN105   BN31.1
                       benefit period.                           BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN531   BS32.1

EFR-STM-SEQ-NBR        Numeric 4                                 BN100   BN101
Element: Stm Seq Nbr   Contains the sequence number that         BN102   BN103
                       associates this file to the employee's    BN105   BN145
                       standard time record in PR30.1 (Standard  BN31.1  BN31.2
                       Time Record).                             BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-CRDT-AVL-SHORT     Derived
Element: Crdt Avl Short

EFR-CRDT-SPT-SHORT     Derived
Element: Crdt Spt Short

EFR-PT-AVL-SHORT       Derived
Element: Pt Avl Short

EFR-PT-SPT-SHORT       Derived
Element: Pt Spt Short

EFR-WK-CRDTS-AVAIL     Derived
Element: Wk Crdts Avail

EFR-BI-CRDTS-AVAIL     Derived
Element: Bi Crdts Avail

EFR-SM-CRDTS-AVAIL     Derived
Element: Sm Crdts Avail

EFR-MO-CRDTS-AVAIL     Derived
Element: Mo Crdts Avail

EFR-PP-CRDTS-AVAIL     Derived
Element: Pp Crdts Avail

EFR-WK-CRDTS-SPENT     Derived
Element: Wk Crdts Spent

EFR-BI-CRDTS-SPENT     Derived
Element: Bi Crdts Spent

EFR-SM-CRDTS-SPENT     Derived
Element: Sm Crdts Spent

EFR-MO-CRDTS-SPENT     Derived
Element: Mo Crdts Spent

EFR-PP-CRDTS-SPENT     Derived
Element: Pp Crdts Spent

EFR-WK-PT-AVAIL        Derived
Element: Wk Pt Avail

EFR-BI-PT-AVAIL        Derived
Element: Bi Pt Avail

EFR-SM-PT-AVAIL        Derived
Element: Sm Pt Avail

EFR-MO-PT-AVAIL        Derived
Element: Mo Pt Avail

EFR-PP-PT-AVAIL        Derived
Element: Pp Pt Avail

EFR-WK-PT-SPENT        Derived
Element: Wk Pt Spent

EFR-BI-PT-SPENT        Derived
Element: Bi Pt Spent

EFR-SM-PT-SPENT        Derived
Element: Sm Pt Spent

EFR-MO-PT-SPENT        Derived
Element: Mo Pt Spent

EFR-PP-PT-SPENT        Derived
Element: Pp Pt Spent

EFR-CURRENCY-CODE      Alpha 5                                   BN100   BN101
Element: Currency Code This field contains the company base      BN102   BN103
                       currency code established in Company      BN105   BN145
                       (GL10.1 ).                                BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-CURR-ND            Numeric 1                                 BN100   BN101
Account Currency                                                 BN102   BN103
Code                                                             BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-CREATION-DATE      Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Date                                                    BN102   BN103
                                                                 BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-UPD-DATE           Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Upd Date                                                BN102   BN103
                                                                 BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-TIME-STAMP         Numeric 6  (hhmmss)                       BN100   BN101
Element: Time Stamp    Contains the server time (hour, minute,   BN102   BN103
                       and second) when the record was last      BN105   BN145
                       changed.                                  BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

EFR-USER-ID            Alpha 10  (Lower Case)                    BN100   BN101
Element: User                                                    BN102   BN103
                                                                 BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

                         EMPFLEXREM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EFRSET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PLAN-START-DT                                          BN104   BN105
          START-DATE                                             BN145   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN430   BN45.1
                                                                 BN51.2  BN531
                                                                 BS32.1

EFRSET2   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PLAN-START-DT                                          BN105   BN232
          START-DATE*                                            BN242   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN531   BS32.1

EFRSET3   COMPANY                                                BN46.1  BN46.2
          EMPLOYEE                                               BS12.1  HR170
          START-DATE                                             HR70.1

                         EMPFLEXREM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            EFR-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required

                            EFR-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Empflexdol     EMPFLEXDOL   Required

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

Employee       EMPLOYEE     Required

                            EFR-COMPANY          -> EMP-COMPANY
                            EFR-EMPLOYEE         -> EMP-EMPLOYEE

Flexplan       FLEXPLAN     Required

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

Flpstandtime   STANDTIME    Not Required

                            EFR-COMPANY          -> STM-COMPANY
                            EFR-EMPLOYEE         -> STM-EMPLOYEE
                            Spaces               -> STM-TIME-GROUP
                            FLP-FLEX-PAY-CODE    -> STM-PAY-CODE
                            EFR-STM-SEQ-NBR      -> STM-SEQ-NBR