EMPFLEXREM – Employee Flex Period Dollars

System: Benefits (BN)
Prefix: EFR
Primary key: COMPANY, EMPLOYEE, PLAN-START-DT, START-DATE
Fields: 42
Updated by: 21 programs
Referenced by: 9 programs

EMPFLEXREM is the Employee Flex Period Dollars table in Lawson Benefits (prefix EFR). It is indexed by COMPANY, EMPLOYEE, PLAN-START-DT, START-DATE (EFRSET1); alternate indexes: EFRSET2 and EFRSET3. It is related 1:1 to PRSYSTEM, CUCODES, EMPFLEXDOL, EMPLOYEE, FLEXPLAN and STANDTIME. It is updated by BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 and 13 more and referenced by BN104, BN232, BN242, BN46.1, BN46.2, BN51.2, BS12.1, HR170 and 1 more. The table has 42 fields, 3 indexes and 6 documented relations.

About EMPFLEXREM

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

Fields (42)

Column = COBOL field name without the EFR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`EFR-COMPANY` PK COMPANY	Numeric 4	Contains the company number. The number correlates all information about the company.	BN100, BN102, BN145, BN45.1
#`EFR-EMPLOYEE` PK 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` PK PLAN_START_DT	Numeric 8 (yyyymmdd)	Contains the start date of the flex plan year.	BN100, BN102, BN145, BN45.1
#`EFR-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the start date of the flex benefit period.	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
#`EFR-STOP-DATE` STOP_DATE	Numeric 8 (yyyymmdd)	Contains the stop date of the flex benefit period.	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
#`EFR-CREDITS-AVAIL` 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 +12 more
#`EFR-CREDITS-SPENT` 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 +10 more
#`EFR-PRE-TAX-AVAIL` 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 +12 more
#`EFR-PRE-TAX-SPENT` 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 +10 more
#`EFR-STM-SEQ-NBR` 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 +12 more
#`EFR-CRDT-AVL-SHORT` CRDT_AVL_SHORT	Derived	—	—
#`EFR-CRDT-SPT-SHORT` CRDT_SPT_SHORT	Derived	—	—
#`EFR-PT-AVL-SHORT` PT_AVL_SHORT	Derived	—	—
#`EFR-PT-SPT-SHORT` PT_SPT_SHORT	Derived	—	—
#`EFR-WK-CRDTS-AVAIL` WK_CRDTS_AVAIL	Derived	—	—
#`EFR-BI-CRDTS-AVAIL` BI_CRDTS_AVAIL	Derived	—	—
#`EFR-SM-CRDTS-AVAIL` SM_CRDTS_AVAIL	Derived	—	—
#`EFR-MO-CRDTS-AVAIL` MO_CRDTS_AVAIL	Derived	—	—
#`EFR-PP-CRDTS-AVAIL` PP_CRDTS_AVAIL	Derived	—	—
#`EFR-WK-CRDTS-SPENT` WK_CRDTS_SPENT	Derived	—	—
#`EFR-BI-CRDTS-SPENT` BI_CRDTS_SPENT	Derived	—	—
#`EFR-SM-CRDTS-SPENT` SM_CRDTS_SPENT	Derived	—	—
#`EFR-MO-CRDTS-SPENT` MO_CRDTS_SPENT	Derived	—	—
#`EFR-PP-CRDTS-SPENT` PP_CRDTS_SPENT	Derived	—	—
#`EFR-WK-PT-AVAIL` WK_PT_AVAIL	Derived	—	—
#`EFR-BI-PT-AVAIL` BI_PT_AVAIL	Derived	—	—
#`EFR-SM-PT-AVAIL` SM_PT_AVAIL	Derived	—	—
#`EFR-MO-PT-AVAIL` MO_PT_AVAIL	Derived	—	—
#`EFR-PP-PT-AVAIL` PP_PT_AVAIL	Derived	—	—
#`EFR-WK-PT-SPENT` WK_PT_SPENT	Derived	—	—
#`EFR-BI-PT-SPENT` BI_PT_SPENT	Derived	—	—
#`EFR-SM-PT-SPENT` SM_PT_SPENT	Derived	—	—
#`EFR-MO-PT-SPENT` MO_PT_SPENT	Derived	—	—
#`EFR-PP-PT-SPENT` PP_PT_SPENT	Derived	—	—
#`EFR-CURRENCY-CODE` 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 +12 more
#`EFR-CURR-ND` CURR_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 +12 more
#`EFR-CREATION-DATE` 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 +12 more
#`EFR-UPD-DATE` UPD_DATE	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
#`EFR-TIME-STAMP` 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 +12 more
#`EFR-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
#`EFR-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
#`EFR-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`EFRSET1`	`COMPANY` `EMPLOYEE` `PLAN-START-DT` `START-DATE`	Primary	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN31.1 +15 more
`EFRSET2`	`COMPANY` `EMPLOYEE` `PLAN-START-DT` `START-DATE` ↓		BN100, BN101, BN102, BN103, BN105, BN232, BN242, BN31.1 +13 more
`EFRSET3`	`COMPANY` `EMPLOYEE` `START-DATE`		BN46.1, BN46.2, BS12.1, HR170, HR70.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (6) — lookups and parents

Relation Table Rules Condition Field map

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`

Programs

Updated by (21)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN145 Flex Dollars Calculation
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN430 Benefit Purge
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BS32.1 Web Enrollment Stop Benefits Update
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add

Referenced by (9)

BN104 Frequency Table Update
BN232 Benefits Statement
BN242 One Page Benefits Statement
BN46.1 Flex Benefit Periods
BN46.2 Flex Benefits Inquiry
BN51.2 Employee Benefit Detail
BS12.1 Web Enrollment Eligible New Plans
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry

EMPFLEXREM – Employee Flex Period Dollars

About EMPFLEXREM

Fields (42) Copy as SQL

Indexes (3)

Relations

One to one (6) — lookups and parents

Programs

Updated by (21)

Referenced by (9)

Fields (42)