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
Company Contains the company number. The number BN145 BN45.1
correlates all information about the
company.
EFR-EMPLOYEE Numeric 9 BN100 BN102
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
Start Date Contains the start date of the flex BN145 BN45.1
plan year.
EFR-START-DATE Numeric 8 (yyyymmdd) BN100 BN101
Start 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
Stop 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
Flex Available Contains 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
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
Pre-Tax Available Contains 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
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
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
Crdt Avl Short
EFR-CRDT-SPT-SHORT Derived
Crdt Spt Short
EFR-PT-AVL-SHORT Derived
Pt Avl Short
EFR-PT-SPT-SHORT Derived
Pt Spt Short
EFR-WK-CRDTS-AVAIL Derived
Wk Crdts Avail
EFR-BI-CRDTS-AVAIL Derived
Bi Crdts Avail
EFR-SM-CRDTS-AVAIL Derived
Sm Crdts Avail
EFR-MO-CRDTS-AVAIL Derived
Mo Crdts Avail
EFR-PP-CRDTS-AVAIL Derived
Pp Crdts Avail
EFR-WK-CRDTS-SPENT Derived
Wk Crdts Spent
EFR-BI-CRDTS-SPENT Derived
Bi Crdts Spent
EFR-SM-CRDTS-SPENT Derived
Sm Crdts Spent
EFR-MO-CRDTS-SPENT Derived
Mo Crdts Spent
EFR-PP-CRDTS-SPENT Derived
Pp Crdts Spent
EFR-WK-PT-AVAIL Derived
Wk Pt Avail
EFR-BI-PT-AVAIL Derived
Bi Pt Avail
EFR-SM-PT-AVAIL Derived
Sm Pt Avail
EFR-MO-PT-AVAIL Derived
Mo Pt Avail
EFR-PP-PT-AVAIL Derived
Pp Pt Avail
EFR-WK-PT-SPENT Derived
Wk Pt Spent
EFR-BI-PT-SPENT Derived
Bi Pt Spent
EFR-SM-PT-SPENT Derived
Sm Pt Spent
EFR-MO-PT-SPENT Derived
Mo Pt Spent
EFR-PP-PT-SPENT Derived
Pp Pt Spent
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
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
|