EMPFLEXDOL

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
BN320 BN46.1 BS13.1 BS15.1 BN00.1 BN04.1
BN06.1 BN08.1


UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN232 BN242 BN245 BN246 BN305
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN325
BN340 BN350 BN36.1 BN430 BN45.1 BN531
BN65.1 BN71.1 BN72.1 BS10.1 BS11.1 BS12.1
BS14.1 BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1
ZB32.2 ZB32.3 HR11.1 HR11.2 HR170 HR28.1
HR511 HR70.1 LT101 ZH510 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR12.6 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EFD-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN100 BN102
BN145 BN45.1
EFD-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Contains the start date of the employee flex dollars.
BN100 BN102
BN145 BN45.1
EFD-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee's number.
BN100 BN102
BN145 BN45.1
EFD-STOP-DATE
Element: Stop Date
Numeric 8 (yyyymmdd)
Contains the stop date of the flex dollars.
BN100 BN102
BN103 BN145
BN45.1
EFD-MO-COMP-SPENT
Element: Mo Comp Spent
Derived
This field is not used.
EFD-COMP-SPENT
Element: Comp Spent
Signed 11.2
This field is not used.
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
EFD-MO-EMP-SPENT
Element: Mo Emp Spent
Derived
This field is not used.
EFD-EMP-SPENT
Element: Emp Spent
Signed 11.2
This field is not used.
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
EFD-FLEX-PLAN
Element: Flex Plan
Alpha 4
Contains the flex plan for the flex dollars.
BN100 BN102
BN145 BN45.1
EFD-SALARY
Element: Salary
Signed 11.2
Contains the employee's salary used to calculate the employee flex dollars.
BN100 BN102
BN145 BN45.1
EFD-ANNUAL-HOURS
Element: Annual Hours
Numeric 4
Contains the employee's annual hours used to calculate the EFD-SALARY.
BN100 BN102
BN145 BN45.1
EFD-NBR-FTE
Element: Nbr Fte
Signed 7.6
Contains the FTE used to calculate the EFD-SALARY.
BN100 BN102
BN145 BN45.1
EFD-MO-COMP-FLX
Element: Mo Comp Flx
Derived
EFD-COMP-FLX-AMT
Element: Comp Flx Amt
Signed 11.2
Contains the flex dollars the employee received before benefit election. The company can give flex dollars as a base amount or as a percent of the employee's salary.
BN100 BN102
BN145 BN45.1
EFD-MO-SERVICE
Element: Mo Service
Derived
EFD-SERV-CREDIT
Element: Serv Credit
Signed 11.2
Contains the amount of flex credits given based on the employee's years of service.
BN100 BN102
BN145 BN45.1
EFD-MO-AGE
Element: Mo Age
Derived
EFD-AGE-CREDIT
Element: Age Credit
Signed 11.2
Contains the amount of flex credits given based on the employee's age.
BN100 BN102
BN145 BN45.1
EFD-MO-DEPENDENTS
Element: Mo Dependents
Derived
EFD-DEP-CREDIT
Element: Dep Credit
Signed 11.2
Contains the amount of flex credits given based on the employee's number of dependents.
BN100 BN102
BN145 BN45.1
EFD-LIFE-CREDIT
Element: Life Credit
Signed 11.2
Contains the number of flex credits given based on the employee's lifestyle points.
BN100 BN102
BN145 BN45.1
EFD-MO-VACATION
Element: Mo Vacation
Derived
EFD-VAC-CREDIT
Element: Vac Credit
Signed 11.2
Contains the amount of flex dollars given for the vacation hours the employee sold.
BN100 BN102
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EFD-MO-EMP-FLEX
Element: Mo Emp Flex
Derived
EFD-EMP-FLEX-AMT
Element: Emp Flex Amt
Signed 11.2
Contains the amount of employee pre-tax dollars that can be used to purchase benefits.
BN100 BN102
BN145 BN45.1
EFD-MO-COMP-AMT
Element: Mo Comp Amt
Derived
EFD-TOT-COMP-AMT
Element: Tot Comp Amt
Signed 11.2
Contains the total flex dollars 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.
BN100 BN102
BN145 BN45.1
EFD-TOT-FLX-AMT
Element: Tot Flx Amt
Derived
EFD-UPDATE-FLAG
Element: Update Flag
Alpha 1
Indicates whether the employee's flex dollar record was overridden.
Y = Yes
BN100 BN102
BN145 BN45.1
EFD-FLD-GROUP-NAME
Element: Fld Group Name
Alpha 10
Contains the employee group from the flex dollar record used to calculate the employee's flex dollars.
BN100 BN102
BN145 BN45.1
EFD-FLD-START-DATE
Element: Fld Start Date
Numeric 8 (yyyymmdd)
Contains the flex dollar start date from the flex dollar record used to calculate the employee's flex dollars.
BN100 BN102
BN145 BN45.1
EFD-SAL-CALC-DATE
Element: Sal Calc Date
Numeric 8 (yyyymmdd)
Contains the date used to calculate the flex salary.
BN100 BN102
BN145 BN45.1
EFD-AGE-CALC-DATE
Element: Age Calc Date
Numeric 8 (yyyymmdd)
Contains the date used to calculate age credits.
BN100 BN102
BN145
EFD-SERV-CALC-DATE
Element: Serv Calc Date
Numeric 8 (yyyymmdd)
Contains the date used to calculate the years of service credits.
BN100 BN102
BN145
EFD-WK-COMP-FLX
Element: Wk Comp Flx
Derived
EFD-BI-COMP-FLX
Element: Bi Comp Flx
Derived
EFD-SM-COMP-FLX
Element: Sm Comp Flx
Derived
EFD-PP-COMP-FLX
Element: Pp Comp Flx
Derived
EFD-WK-SERVICE
Element: Wk Service
Derived
EFD-BI-SERVICE
Element: Bi Service
Derived
EFD-SM-SERVICE
Element: Sm Service
Derived
EFD-PP-SERVICE
Element: Pp Service
Derived
EFD-WK-AGE
Element: Wk Age
Derived
EFD-BI-AGE
Element: Bi Age
Derived
EFD-SM-AGE
Element: Sm Age
Derived
EFD-PP-AGE
Element: Pp Age
Derived
EFD-WK-DEPENDENTS
Element: Wk Dependents
Derived
EFD-BI-DEPENDENTS
Element: Bi Dependents
Derived
EFD-SM-DEPENDENTS
Element: Sm Dependents
Derived
EFD-PP-DEPENDENTS
Element: Pp Dependents
Derived
EFD-WK-LIFE
Element: Wk Life
Derived
EFD-BI-LIFE
Element: Bi Life
Derived
EFD-SM-LIFE
Element: Sm Life
Derived
EFD-MO-LIFE
Element: Mo Life
Derived
EFD-PP-LIFE
Element: Pp Life
Derived
EFD-WK-EMP-FLEX
Element: Wk Emp Flex
Derived
EFD-BI-EMP-FLEX
Element: Bi Emp Flex
Derived
EFD-SM-EMP-FLEX
Element: Sm Emp Flex
Derived
EFD-PP-EMP-FLEX
Element: Pp Emp Flex
Derived
EFD-WK-COMP-AMT
Element: Wk Comp Amt
Derived
EFD-BI-COMP-AMT
Element: Bi Comp Amt
Derived
EFD-SM-COMP-AMT
Element: Sm Comp Amt
Derived
EFD-PP-COMP-AMT
Element: Pp Comp Amt
Derived
EFD-WK-TOT-FLX-AMT
Element: Wk Tot Flx Amt
Derived
EFD-BI-TOT-FLX-AMT
Element: Bi Tot Flx Amt
Derived
EFD-SM-TOT-FLX-AMT
Element: Sm Tot Flx Amt
Derived
EFD-MO-TOT-FLX-AMT
Element: Mo Tot Flx Amt
Derived
EFD-PP-TOT-FLX-AMT
Element: Pp Tot Flx Amt
Derived
EFD-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the date that this line was added to the requisition.
BN100 BN102
BN145 BN45.1
EFD-UPD-DATE
Element: Upd Date
Numeric 8 (yyyymmdd)
BN100 BN102
BN103 BN145
BN45.1
EFD-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN100 BN102
BN103 BN145
BN45.1
EFD-USER-ID
Element: User
Alpha 10 (Lower Case)
BN100 BN102
BN103 BN145
BN45.1
EFD-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN100 BN102
BN145
EFD-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN100 BN102
BN145


EMPFLEXDOL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EFDSET1 COMPANY
START-DATE
EMPLOYEE
BN00.1 BN100
BN101 BN102
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
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
HR170 HR70.1
EFDSET2 COMPANY
EMPLOYEE
START-DATE*
...
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN242
BN245 BN305
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
ZB10.1 ZB31.1
EFDSET3 COMPANY
FLEX-PLAN
START-DATE
EMPLOYEE
BN04.1 BN06.1
BN08.1 BN104
EFDSET4 COMPANY
EMPLOYEE
FLEX-PLAN
START-DATE
BN100 BN102
BN103
EFDSET5 COMPANY
EMPLOYEE
START-DATE
...
BN100 BN145
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9


EMPFLEXDOL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:10:04 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.