|
|
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
|
