Lawson Insight Technical Documentation |
|
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
|