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 BN36.1 BN65.1 BN71.1 BN72.1 BS10.1
BS11.1 BS12.1 BN04.1 BN06.1 BN08.1 BN104
HR11.1 HR511 PA02.1 PA100 PA102 PA502
PA52.1 PA52.3 PA52.4 PA52.5 PR13.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
EFD-COMPANY Numeric 4 BN100 BN102
Company Contains the company number. BN145 BN45.1
EFD-START-DATE Numeric 8 (yyyymmdd) BN100 BN102
Start Date Contains the start date of the employee BN145 BN45.1
flex dollars.
EFD-EMPLOYEE Numeric 9 BN100 BN102
Employee Contains the employee's number. BN145 BN45.1
EFD-STOP-DATE Numeric 8 (yyyymmdd) BN100 BN102
Stop Date Contains the stop date of the flex BN103 BN145
dollars. BN45.1
EFD-MO-COMP-SPENT Derived
Mo Comp Spent This field is not used.
EFD-COMP-SPENT Signed 11.2 BN100 BN101
Flex Dollars Spent This 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
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
Flex Plan Contains the flex plan for the flex BN145 BN45.1
dollars.
EFD-SALARY Signed 11.2 BN100 BN102
Salary Contains the employee's salary used to BN145 BN45.1
calculate the employee flex dollars.
EFD-ANNUAL-HOURS Numeric 4 BN100 BN102
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
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
Mo Service
EFD-SERV-CREDIT Signed 11.2 BN100 BN102
Credits Per Contains the amount of flex credits BN145 BN45.1
given based on the employee's years of
service.
EFD-MO-AGE Derived
Mo Age
EFD-AGE-CREDIT Signed 11.2 BN100 BN102
Credits Per Contains the amount of flex credits BN145 BN45.1
given based on the employee's age.
EFD-MO-DEPENDENTS Derived
Mo Dependents
EFD-DEP-CREDIT Signed 11.2 BN100 BN102
Dependent Credits Contains 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
Life Credit Contains the number of flex credits BN145 BN45.1
given based on the employee's lifestyle
points.
EFD-MO-VACATION Derived
Mo Vacation
EFD-VAC-CREDIT Signed 11.2 BN100 BN102
Vacation Credit Contains 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
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
Mo Comp Amt
EFD-TOT-COMP-AMT Signed 11.2 BN100 BN102
Total Compensation Contains 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
Tot Flx Amt
EFD-MO-REMAIN-CO Derived
Mo Remain Co
EFD-REMAIN-COMP Derived
Remain Comp
EFD-MO-REMAIN-EMP Derived
Mo Remain Emp
EFD-REMAIN-EMP Derived
Remain Emp
EFD-UPDATE-FLAG Alpha 1 BN100 BN102
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
Fld Group Name Contains 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
Fld Start Date Contains 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
Sal Calc Date Contains the date used to calculate the BN145 BN45.1
flex salary.
EFD-AGE-CALC-DATE Numeric 8 (yyyymmdd) BN100 BN102
Age Calc Date Contains the date used to calculate age BN145
credits.
EFD-SERV-CALC-DATE Numeric 8 (yyyymmdd) BN100 BN102
Serv Calc Date Contains the date used to calculate the BN145
years of service credits.
EFD-WK-COMP-FLX Derived
Wk Comp Flx
EFD-BI-COMP-FLX Derived
Bi Comp Flx
EFD-SM-COMP-FLX Derived
Sm Comp Flx
EFD-PP-COMP-FLX Derived
Pp Comp Flx
EFD-WK-SERVICE Derived
Wk Service
EFD-BI-SERVICE Derived
Bi Service
EFD-SM-SERVICE Derived
Sm Service
EFD-PP-SERVICE Derived
Pp Service
EFD-WK-AGE Derived
Wk Age
EFD-BI-AGE Derived
Bi Age
EFD-SM-AGE Derived
Sm Age
EFD-PP-AGE Derived
Pp Age
EFD-WK-DEPENDENTS Derived
Wk Dependents
EFD-BI-DEPENDENTS Derived
Bi Dependents
EFD-SM-DEPENDENTS Derived
Sm Dependents
EFD-PP-DEPENDENTS Derived
Pp Dependents
EFD-WK-LIFE Derived
Wk Life
EFD-BI-LIFE Derived
Bi Life
EFD-SM-LIFE Derived
Sm Life
EFD-MO-LIFE Derived
Mo Life
EFD-PP-LIFE Derived
Pp Life
EFD-WK-EMP-FLEX Derived
Wk Emp Flex
EFD-BI-EMP-FLEX Derived
Bi Emp Flex
EFD-SM-EMP-FLEX Derived
Sm Emp Flex
EFD-PP-EMP-FLEX Derived
Pp Emp Flex
EFD-WK-COMP-AMT Derived
Wk Comp Amt
EFD-BI-COMP-AMT Derived
Bi Comp Amt
EFD-SM-COMP-AMT Derived
Sm Comp Amt
EFD-PP-COMP-AMT Derived
Pp Comp Amt
EFD-WK-TOT-FLX-AMT Derived
Wk Tot Flx Amt
EFD-BI-TOT-FLX-AMT Derived
Bi Tot Flx Amt
EFD-SM-TOT-FLX-AMT Derived
Sm Tot Flx Amt
EFD-MO-TOT-FLX-AMT Derived
Mo Tot Flx Amt
EFD-PP-TOT-FLX-AMT Derived
Pp Tot Flx Amt
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
BN36.1 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS10.1 BS11.1
BS12.1 BS14.1
BS32.1 HR170
HR70.1
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 HR511 PA02.1
START-DATE PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
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
|