EMPFLEXDOL – Employee Flex Dollars

System: Benefits (BN)
Prefix: EFD
Primary key: COMPANY, START-DATE, EMPLOYEE
Fields: 76
Updated by: 21 programs
Referenced by: 59 programs

EMPFLEXDOL is the Employee Flex Dollars table in Lawson Benefits (prefix EFD). It is indexed by COMPANY, START-DATE, EMPLOYEE (EFDSET1); alternate indexes: EFDSET2, EFDSET3, EFDSET4 and EFDSET5. It is related 1:1 to BNCOMPANY, PRSYSTEM, EMPLOYEE, PERSGROUP, FLEXPLAN and PAEMPLOYEE and 1:M to EMPFLEXREM. It is updated by BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 and 13 more and referenced by BN00.1, BN04.1, BN06.1, BN08.1, BN104, BN232, BN242, BN245 and 51 more. The table has 76 fields, 5 indexes and 8 documented relations.

About EMPFLEXDOL

The Employee Flex Dollar file contains information about an employee's flex and pre-tax dollars for the flex plan year.

Fields (76)

Column = COBOL field name without the EFD- 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
#`EFD-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN100, BN102, BN145, BN45.1
#`EFD-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the start date of the employee flex dollars.	BN100, BN102, BN145, BN45.1
#`EFD-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee's number.	BN100, BN102, BN145, BN45.1
#`EFD-STOP-DATE` STOP_DATE	Numeric 8 (yyyymmdd)	Contains the stop date of the flex dollars.	BN100, BN102, BN103, BN145, BN45.1
#`EFD-MO-COMP-SPENT` MO_COMP_SPENT	Derived	This field is not used.	—
#`EFD-COMP-SPENT` COMP_SPENT	Signed 11.2	This field is not used.	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
#`EFD-MO-EMP-SPENT` MO_EMP_SPENT	Derived	This field is not used.	—
#`EFD-EMP-SPENT` EMP_SPENT	Signed 11.2	This field is not used.	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
#`EFD-FLEX-PLAN` SET3 SET4 FLEX_PLAN	Alpha 4	Contains the flex plan for the flex dollars.	BN100, BN102, BN145, BN45.1
#`EFD-SALARY` SALARY	Signed 11.2	Contains the employee's salary used to calculate the employee flex dollars.	BN100, BN102, BN145, BN45.1
#`EFD-ANNUAL-HOURS` 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` NBR_FTE	Signed 7.6	Contains the FTE used to calculate the EFD-SALARY.	BN100, BN102, BN145, BN45.1
#`EFD-MO-COMP-FLX` MO_COMP_FLX	Derived	—	—
#`EFD-COMP-FLX-AMT` 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` MO_SERVICE	Derived	—	—
#`EFD-SERV-CREDIT` 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` MO_AGE	Derived	—	—
#`EFD-AGE-CREDIT` 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` MO_DEPENDENTS	Derived	—	—
#`EFD-DEP-CREDIT` 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` 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` MO_VACATION	Derived	—	—
#`EFD-VAC-CREDIT` 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 +5 more
#`EFD-MO-EMP-FLEX` MO_EMP_FLEX	Derived	—	—
#`EFD-EMP-FLEX-AMT` 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` MO_COMP_AMT	Derived	—	—
#`EFD-TOT-COMP-AMT` 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` TOT_FLX_AMT	Derived	—	—
#`EFD-UPDATE-FLAG` 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` 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` 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` SAL_CALC_DATE	Numeric 8 (yyyymmdd)	Contains the date used to calculate the flex salary.	BN100, BN102, BN145, BN45.1
#`EFD-AGE-CALC-DATE` AGE_CALC_DATE	Numeric 8 (yyyymmdd)	Contains the date used to calculate age credits.	BN100, BN102, BN145
#`EFD-SERV-CALC-DATE` SERV_CALC_DATE	Numeric 8 (yyyymmdd)	Contains the date used to calculate the years of service credits.	BN100, BN102, BN145
#`EFD-WK-COMP-FLX` WK_COMP_FLX	Derived	—	—
#`EFD-BI-COMP-FLX` BI_COMP_FLX	Derived	—	—
#`EFD-SM-COMP-FLX` SM_COMP_FLX	Derived	—	—
#`EFD-PP-COMP-FLX` PP_COMP_FLX	Derived	—	—
#`EFD-WK-SERVICE` WK_SERVICE	Derived	—	—
#`EFD-BI-SERVICE` BI_SERVICE	Derived	—	—
#`EFD-SM-SERVICE` SM_SERVICE	Derived	—	—
#`EFD-PP-SERVICE` PP_SERVICE	Derived	—	—
#`EFD-WK-AGE` WK_AGE	Derived	—	—
#`EFD-BI-AGE` BI_AGE	Derived	—	—
#`EFD-SM-AGE` SM_AGE	Derived	—	—
#`EFD-PP-AGE` PP_AGE	Derived	—	—
#`EFD-WK-DEPENDENTS` WK_DEPENDENTS	Derived	—	—
#`EFD-BI-DEPENDENTS` BI_DEPENDENTS	Derived	—	—
#`EFD-SM-DEPENDENTS` SM_DEPENDENTS	Derived	—	—
#`EFD-PP-DEPENDENTS` PP_DEPENDENTS	Derived	—	—
#`EFD-WK-LIFE` WK_LIFE	Derived	—	—
#`EFD-BI-LIFE` BI_LIFE	Derived	—	—
#`EFD-SM-LIFE` SM_LIFE	Derived	—	—
#`EFD-MO-LIFE` MO_LIFE	Derived	—	—
#`EFD-PP-LIFE` PP_LIFE	Derived	—	—
#`EFD-WK-EMP-FLEX` WK_EMP_FLEX	Derived	—	—
#`EFD-BI-EMP-FLEX` BI_EMP_FLEX	Derived	—	—
#`EFD-SM-EMP-FLEX` SM_EMP_FLEX	Derived	—	—
#`EFD-PP-EMP-FLEX` PP_EMP_FLEX	Derived	—	—
#`EFD-WK-COMP-AMT` WK_COMP_AMT	Derived	—	—
#`EFD-BI-COMP-AMT` BI_COMP_AMT	Derived	—	—
#`EFD-SM-COMP-AMT` SM_COMP_AMT	Derived	—	—
#`EFD-PP-COMP-AMT` PP_COMP_AMT	Derived	—	—
#`EFD-WK-TOT-FLX-AMT` WK_TOT_FLX_AMT	Derived	—	—
#`EFD-BI-TOT-FLX-AMT` BI_TOT_FLX_AMT	Derived	—	—
#`EFD-SM-TOT-FLX-AMT` SM_TOT_FLX_AMT	Derived	—	—
#`EFD-MO-TOT-FLX-AMT` MO_TOT_FLX_AMT	Derived	—	—
#`EFD-PP-TOT-FLX-AMT` PP_TOT_FLX_AMT	Derived	—	—
#`EFD-CREATION-DATE` 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` UPD_DATE	Numeric 8 (yyyymmdd)	—	BN100, BN102, BN103, BN145, BN45.1
#`EFD-TIME-STAMP` 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` USER_ID	Alpha 10 (Lower Case)	—	BN100, BN102, BN103, BN145, BN45.1
#`EFD-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BN100, BN102, BN145
#`EFD-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BN100, BN102, BN145
#`EFD-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN100, BN102, BN145, BN45.1
#`EFD-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN100, BN102, BN145, BN45.1

Indexes (5)

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
`EFDSET1`	`COMPANY` `START-DATE` `EMPLOYEE`	Primary	BN00.1, BN100, BN101, BN102, BN103, BN105, BN145, BN246 +22 more
`EFDSET2`	`COMPANY` `EMPLOYEE` `START-DATE` ↓		BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN242 +22 more (list truncated in source)
`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 +22 more (list truncated in source)

Relations

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

One to one (7) — lookups and parents

Relation Table Rules Condition Field map

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`

One to many (1) — child tables

Relation Table Rules Condition Field map

Empflexrem

EMPFLEXREM

Delete Cascades

`EFD-COMPANY`	→	`EFR-COMPANY`
`EFD-EMPLOYEE`	→	`EFR-EMPLOYEE`
`EFD-START-DATE`	→	`EFR-PLAN-START-DT`
—	→	`EFR-START-DATE`

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 (59)

BN00.1 Benefits Company
BN04.1 Frequency Table
BN06.1 Flex Plan
BN08.1 Flex Credits
BN104 Frequency Table Update
BN232 Benefits Statement
BN242 One Page Benefits Statement
BN245 Benefit Election Form
BN246 Flex Missing Benefits Report
BN260 Employee Benefit Extract
BN305 Highly Compensated Employees
BN320 Premium Report
BN325 Benefit Exception Report
BN340 ADP and ACP Tests
BN350 Coverage Test - Classification
BN36.1 Investment
BN46.1 Flex Benefit Periods
BN65.1 Election Simulation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS10.1 Web Enrollment Current Benefit Inquiry
BS11.1 Web Enrollment Employee Flex Dollar Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR170 Human Resource Writer Report Request
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR70.1 Human Resource Writer Inquiry
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP

EMPFLEXDOL – Employee Flex Dollars

About EMPFLEXDOL

Fields (76) Copy as SQL

Indexes (5)

Relations

One to one (7) — lookups and parents

One to many (1) — child tables

Programs

Updated by (21)

Referenced by (59)

Fields (76)