EMPFLEXREM

Employee Flex Period Dollars

The Employee Flex Period Dollars file contains information about an employee's flex benefit periods.
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN232 BN242 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN430 BN45.1 BN46.1 BN46.2
BN51.2 BN531 BS12.1 BS32.1 ZB10.1 ZB31.1
ZB31.2 ZB32.1 ZB32.2 ZB32.3 HR170 HR70.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EFR-COMPANY
Element: Company Hr		Numeric 4
Contains the company number. The number correlates all information about the company.
BN100 BN102
BN145 BN45.1
EFR-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee's number. The number correlates all information about the employee.
BN100 BN102
BN145 BN45.1
EFR-PLAN-START-DT
Element: Plan Start Dt		Numeric 8 (yyyymmdd)
Contains the start date of the flex plan year.
BN100 BN102
BN145 BN45.1
EFR-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the start date of the flex benefit period.
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
EFR-STOP-DATE
Element: Stop Date		Numeric 8 (yyyymmdd)
Contains the stop date of the flex benefit period.
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
EFR-CREDITS-AVAIL
Element: Credits Avail		Signed 11.2
Contains the amount of flex dollars the employee received before electing benefits for the flex benefit period.
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
EFR-CREDITS-SPENT
Element: Credits Spent		Signed 11.2
Contains the flex dollars that were spent for benefits during the flex benefit period.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
EFR-PRE-TAX-AVAIL
Element: Pre Tax Avail		Signed 11.2
Contains the employee's available pre-tax dollars for the flex benefit period.
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
EFR-PRE-TAX-SPENT
Element: Pre Tax Spent		Signed 11.2
Contains the pre-tax dollars that were spent for benefits during the flex benefit period.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
EFR-STM-SEQ-NBR
Element: Stm Seq Nbr		Numeric 4
Contains the sequence number that associates this file to the employee's standard time record in PR30.1 (Standard Time Record).
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
EFR-CRDT-AVL-SHORT
Element: Crdt Avl Short		Derived
EFR-CRDT-SPT-SHORT
Element: Crdt Spt Short		Derived
EFR-PT-AVL-SHORT
Element: Pt Avl Short		Derived
EFR-PT-SPT-SHORT
Element: Pt Spt Short		Derived
EFR-WK-CRDTS-AVAIL
Element: Wk Crdts Avail		Derived
EFR-BI-CRDTS-AVAIL
Element: Bi Crdts Avail		Derived
EFR-SM-CRDTS-AVAIL
Element: Sm Crdts Avail		Derived
EFR-MO-CRDTS-AVAIL
Element: Mo Crdts Avail		Derived
EFR-PP-CRDTS-AVAIL
Element: Pp Crdts Avail		Derived
EFR-WK-CRDTS-SPENT
Element: Wk Crdts Spent		Derived
EFR-BI-CRDTS-SPENT
Element: Bi Crdts Spent		Derived
EFR-SM-CRDTS-SPENT
Element: Sm Crdts Spent		Derived
EFR-MO-CRDTS-SPENT
Element: Mo Crdts Spent		Derived
EFR-PP-CRDTS-SPENT
Element: Pp Crdts Spent		Derived
EFR-WK-PT-AVAIL
Element: Wk Pt Avail		Derived
EFR-BI-PT-AVAIL
Element: Bi Pt Avail		Derived
EFR-SM-PT-AVAIL
Element: Sm Pt Avail		Derived
EFR-MO-PT-AVAIL
Element: Mo Pt Avail		Derived
EFR-PP-PT-AVAIL
Element: Pp Pt Avail		Derived
EFR-WK-PT-SPENT
Element: Wk Pt Spent		Derived
EFR-BI-PT-SPENT
Element: Bi Pt Spent		Derived
EFR-SM-PT-SPENT
Element: Sm Pt Spent		Derived
EFR-MO-PT-SPENT
Element: Mo Pt Spent		Derived
EFR-PP-PT-SPENT
Element: Pp Pt Spent		Derived
EFR-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
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
EFR-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
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
EFR-CREATION-DATE
Element: Creation Date		Numeric 8 (yyyymmdd)
This is the date that this line was added to the requisition.
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
EFR-UPD-DATE
Element: Upd Date		Numeric 8 (yyyymmdd)
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
EFR-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
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
EFR-USER-ID
Element: User		Alpha 10 (Lower Case)
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


EMPFLEXREM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EFRSET1 COMPANY
EMPLOYEE
PLAN-START-DT
START-DATE
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN45.1
BN51.2 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EFRSET2 COMPANY
EMPLOYEE
PLAN-START-DT
START-DATE*
BN100 BN101
BN102 BN103
BN105 BN232
BN242 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
EFRSET3 COMPANY
EMPLOYEE
START-DATE
BN46.1 BN46.2
BS12.1 HR170
HR70.1


EMPFLEXREM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
EFR-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
EFR-CURRENCY-CODE->CUC-CURRENCY-CODE
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

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

Home
Contact Us



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