EMPFLEXREM

Employee Flex Period Dollars

The Employee Flex Period Dollars file contains information about an employee's flex benefit periods.

REFERENCED BY
BN104 BN51.2 BN232 BN242 BN46.1 BN46.2
BS12.1 HR170 HR70.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 ZB10.1 ZB31.1 ZB31.2
ZB32.1 ZB32.2 ZB32.3

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
EFR-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
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-CREATE-USER-ID
Element: User Id
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 02:10:08 2016

Home
Contact Us



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