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
BN00.1 BN246 BN320 BN325 BN46.1 BS13.1
BS14.1 BS15.1 HR170 HR70.1 BN232 BN242
BN245 BN260 BN305 BN340 BN350 BN36.1
BN65.1 BN71.1 BN72.1 BS10.1 BS11.1 BS12.1
HR11.1 HR11.2 HR11.4 HR28.1 HR511 LT101
LT111 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
PR512 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 ZB10.1 ZB31.1 ZB31.2
ZB32.1 ZB32.2 ZB32.3

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		Signed 8.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
EFD-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BN100 BN102
BN145 BN45.1
EFD-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN100 BN102
BN145 BN45.1


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 BN260
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
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 HR11.4
HR28.1 HR511
LT101 LT111
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


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 02:10:08 2016

Home
Contact Us



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