FLEXDOLLAR – Flex Dollars

System: Benefits (BN)
Prefix: FLD
Primary key: COMPANY, FLEX-PLAN, START-DATE, GROUP-NAME
Fields: 67
Updated by: 41 programs
Referenced by: 15 programs

FLEXDOLLAR is the Flex Dollars table in Lawson Benefits (prefix FLD). It is indexed by COMPANY, FLEX-PLAN, START-DATE, GROUP-NAME (FLDSET1); alternate indexes: FLDSET3 and FLDSET4. It is related 1:1 to RATETBLHDR, BNCOMPANY, PRSYSTEM, FLEXPLAN and PERSGROUP and 1:M to EMPFLEXDOL. It is updated by BN00.1, BN08.1, BN100, BN101, BN102, BN103, BN105, BN145 and 33 more and referenced by BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN06.1, BN104, BN206 and 7 more. The table has 67 fields, 3 indexes and 9 documented relations.

About FLEXDOLLAR

The Flex Dollars file contains the parameters used to calculate flex dollars for employees. BN08.1 (Flex Dollars) is the primary program that updates this file.

Fields (67)

Column = COBOL field name without the FLD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`FLD-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN08.1
`FLD-FLEX-PLAN` PK FLEX_PLAN	Alpha 4	Contains the flex plan name.	BN08.1
`FLD-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the flex dollar start date. The month and date corresponds to the month and date on the flex plan.	BN08.1
`FLD-GROUP-NAME` PK GROUP_NAME	Alpha 10	Contains the employee group used to define flex dollars.	BN08.1
`FLD-STOP-DATE` STOP_DATE	Numeric 8 (yyyymmdd)	Contains the flex dollar's stop date. This is calculated as 12 months from the start date.	BN08.1
`FLD-CMP-BASE-AMT` CMP_BASE_AMT	Signed 11.2	Contains the base amount of dollars the company gives each employee.	BN08.1
`FLD-CMP-BASE-PCT` CMP_BASE_PCT	Signed 5.2	Contains the percent of an employee's salary used to determine how many flex dollars the employee receives.	BN08.1
`FLD-ADD-TO-GRS-PCT` ADD_TO_GRS_PCT	Signed 5.2	Contains the percent of unspent flex dollars which employees can add to taxable wages.	BN08.1
`FLD-MIN-TOT-CREDTS` MIN_TOT_CREDTS	Signed 11.2	Contains the minimum number of credits an employee receives.	BN08.1
`FLD-MAX-TOT-CREDTS` MAX_TOT_CREDTS	Signed 11.2	Contains the maximum number of credits an employee receives.	BN08.1
`FLD-EMP-BASE-AMT` EMP_BASE_AMT	Signed 11.2	Contains the amount of an employee's salary which can be spent on a pre-tax basis to purchase benefits.	BN08.1
`FLD-EMP-BASE-PCT` EMP_BASE_PCT	Signed 5.2	Contains the percent of an employee's salary which can be spent on a pre-tax basis to purchase benefits.	BN08.1
`FLD-SALARY-TYPE` SALARY_TYPE	Alpha 2	Defines the salary that is used to calculate the flex dollars. `EM` HR11 Salary `B1` Benefit Salary 1 `B2` Benefit Salary 2 `B3` Benefit Salary 3 `B4` Benefit Salary 4 `B5` Benefit Salary 5 `E1` HR11 and Ben Sal 1 `E2` HR11 and Ben Sal 2 `E3` HR11 and Ben Sal 3 `E4` HR11 and Ben Sal 4 `E5` HR11 and Ben Sal 5 `ET` Total Emp Salary `T1` Total Emp and Sal 1 `T2` Total Emp and Sal 2 `T3` Total Emp and Sal 3 `T4` Total Emp and Sal 4 `T5` Total Emp and Sal 5 `X` Custom Calculation	BN08.1
`FLD-SALARY-DATE` SALARY_DATE	Numeric 4 (mmdd)	If flex dollars are based on the employee's salary, and the salary is determined on a specific month and day, this field contains the date the salary is determined.	BN08.1
`FLD-SAL-FIRST-MO` SAL_FIRST_MO	Alpha 1	If flex dollars are based on salary, this field determines the salary calculation date. `C` Current `M` First of Month `A` As of Date	BN08.1
`FLD-SAL-ROUND-METH` SAL_ROUND_METH	Alpha 1	If flex dollars are based on salary, this field defines how the salary amount should be rounded. `H` High `L` Low `R` Normal `N` No Rounding	BN08.1
`FLD-SAL-BEF-AFT` SAL_BEF_AFT	Alpha 1	If flex dollars are based on the salary, this field defines when the salary should be rounded. It does not affect the calculation. `B` Before `A` After	BN08.1
`FLD-SAL-ROUND-TO` SAL_ROUND_TO	Signed 9.4	If the salary amount is rounded, this defines to what place the amount is rounded.	BN08.1
`FLD-MIN-SALARY` MIN_SALARY	Signed 11.2	Contains the minimum salary for calculating flex dollars. If an employee's salary is less than this amount, the system uses this amount to calculate flex dollars for the employee.	BN08.1
`FLD-MAX-SALARY` MAX_SALARY	Signed 11.2	Contains the maximum salary that can be used in the flex dollar calculation. If the employee's salary is greater than this amount, the system uses this amount to calculate flex dollars for the employee.	BN08.1
`FLD-AGE-DATE` AGE_DATE	Numeric 4 (mmdd)	If flex dollars are based on a specific age, this field contains the date on which the age is calculated.	BN08.1
`FLD-AGE-FIRST-MO` AGE_FIRST_MO	Alpha 1	If the flex dollars are calculated for specific ages, this field determines the age calculation date. `C` Current `M` First of Month `A` As of Date	BN08.1
`FLD-AGE-RATE-TBL` AGE_RATE_TBL	Alpha 4	If flex dollars are calculated for specific ages, this is the table used to define flex dollars ages.	BN08.1
`FLD-AGE-CREDIT` AGE_CREDIT	Signed 11.2	Contains the age flex credits.	BN08.1
`FLD-AGE-ROUND-METH` AGE_ROUND_METH	Alpha 1	If flex dollars are based on age, this field defines how the age credits should be rounded. `H` High `L` Low `R` Normal `N` No Rounding	BN08.1
`FLD-AGE-BEF-AFT` AGE_BEF_AFT	Alpha 1	If flex dollars are based on age, this field determines when rounding is performed. It has no affect on calculations. `B` Before `A` After	BN08.1
`FLD-AGE-ROUND-TO` AGE_ROUND_TO	Signed 9.4	If flex credits are rounded, this field defines to what place the amount is rounded.	BN08.1
`FLD-AGE-MIN-CREDTS` AGE_MIN_CREDTS	Signed 11.2	Contains the minimum number of credits for an age.	BN08.1
`FLD-AGE-MAX-CREDTS` AGE_MAX_CREDTS	Signed 11.2	Contains the maximum number of credits for an age.	BN08.1
`FLD-FROM-DATE` FROM_DATE	Alpha 2	Contains the code that defines the date from which service credits are calculated. `HI` Hire Date `AJ` Adjusted Hire Date `AN` Anniversary Date `SN` Seniority Date `B1` Benefit Date 1 `B2` Benefit Date 2 `B3` Benefit Date 3 `B4` Benefit Date 4 `B5` Benefit Date 5 `X` Custom Calculation	BN08.1
`FLD-SERV-DATE` SERV_DATE	Numeric 4 (mmdd)	If flex dollars are based on service, and service is determined on a certain month and day, this field contains the day to be used.	BN08.1
`FLD-SERV-FIRST-MO` SERV_FIRST_MO	Alpha 1	If the flex dollars include service credits, this field contains the service calculation month and days. `C` Current `M` First of Month `A` As of Date	BN08.1
`FLD-SERV-RATE-TBL` SERV_RATE_TBL	Alpha 4	If flex dollars are calculated based on years of service, this is the rate table used to define the service credits.	BN08.1
`FLD-SERV-CREDIT` SERV_CREDIT	Signed 11.2	Contains the service flex credits.	BN08.1
`FLD-SERV-RND-METH` SERV_RND_METH	Alpha 1	If flex dollars are based on service, this field defines how the service credits should be rounded. `H` High `L` Low `R` Normal `N` No Rounding	BN08.1
`FLD-SERV-BEF-AFT` SERV_BEF_AFT	Alpha 1	If service credits are rounded, this field defines the place to which the amount is rounded. `B` Before `A` After	BN08.1
`FLD-SERV-ROUND-TO` SERV_ROUND_TO	Signed 9.4	If the service credits are rounded, this defines to what place the amount is rounded.	BN08.1
`FLD-SERV-MIN-CREDT` SERV_MIN_CREDT	Signed 11.2	Contains the minimum number of credits for a service.	BN08.1
`FLD-SERV-MAX-CREDT` SERV_MAX_CREDT	Signed 11.2	Contains the maximum number of credits for a service.	BN08.1
`FLD-DEP-FIRST-MO` DEP_FIRST_MO	Alpha 1	If flex dollars include dependent credits, this field contains the date used to determine the number of dependents from the HR History file. `A` As of Date `C` Current `M` First of Month	BN08.1
`FLD-DEP-RATE-TBL` DEP_RATE_TBL	Alpha 4	If flex dollars are based on the number of dependents, this field contains the rate table used to define the number of dependent credits.	BN08.1
`FLD-DEP-DATE` DEP_DATE	Numeric 4 (mmdd)	If flex dollars are based on the number of dependents, this contains the month and year used to determine the number of dependents from the HR History file.	BN08.1
`FLD-LIFE-FIRST-MO` LIFE_FIRST_MO	Alpha 1	If flex dollars are based on the number of lifestyle credits, this field contains the date used to define the number of lifestyle credits from the HR History file. `A` As of Date `C` Current `M` First of Month	BN08.1
`FLD-LIFE-RATE-TBL` LIFE_RATE_TBL	Alpha 4	If flex dollars are based on the number of lifestyle credits, this field contains the rate table used to define the number of lifestyle credits.	BN08.1
`FLD-LIFE-DATE` LIFE_DATE	Numeric 4 (mmdd)	If flex dollars are based on the number of lifestyle credits, this field contains the month and year used to determine the number of lifestyle credits from the HR History file.	BN08.1
`FLD-LAST-CMT-SEQ` LAST_CMT_SEQ	Numeric 4	Contains the sequence number of the last comment.	BN90.1
`FLD-SALARY-YEAR` SALARY_YEAR	Numeric 4	If flex dollars are based on salary year, and an "as of" date is used, this field contains the year.	BN08.1
`FLD-AGE-YEAR` AGE_YEAR	Numeric 4	If flex dollars are based on age and an "as of" date is used, this field contains the year.	BN08.1
`FLD-SERV-YEAR` SERV_YEAR	Numeric 4	If flex credits are based on a service and an "as of" date is used, this field contains the year.	BN08.1
`FLD-DEP-YEAR` DEP_YEAR	Numeric 4	If flex dollars are based on dependents and an "as of" date is used, this field contains the year.	BN08.1
`FLD-LIFE-YEAR` LIFE_YEAR	Numeric 4	If flex dollars are based on lifestyle credits and an "as of" date is used, this field contains the year.	BN08.1
`FLD-CASH-PLAN-FLAG` CASH_PLAN_FLAG	Alpha 1	" " = Not Applicable `1` Cash `2` Plan	—
`FLD-AFTER-TAX-FLAG` AFTER_TAX_FLAG	Alpha 1	— `N` No `Y` Yes	—
`FLD-PLAN-TYPE-1` PLAN_TYPE_1	Alpha 2	—	—
`FLD-PLAN-TYPE-2` PLAN_TYPE_2	Alpha 2	—	—
`FLD-PLAN-TYPE-3` PLAN_TYPE_3	Alpha 2	—	—
`FLD-PLAN-TYPE-4` PLAN_TYPE_4	Alpha 2	—	—
`FLD-PLAN-CODE-1` PLAN_CODE_1	Alpha 4	Contains the user-defined code that represents a benefit plan.	—
`FLD-PLAN-CODE-2` PLAN_CODE_2	Alpha 4	Contains the user-defined code that represents a benefit plan.	—
`FLD-PLAN-CODE-3` PLAN_CODE_3	Alpha 4	Contains the user-defined code that represents a benefit plan.	—
`FLD-PLAN-CODE-4` PLAN_CODE_4	Alpha 4	Contains the user-defined code that represents a benefit plan.	—
`FLD-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN08.1
`FLD-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN08.1
`FLD-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN08.1
`FLD-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN08.1
`FLD-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN08.1
`FLD-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN08.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`FLDSET1`	`COMPANY`, `FLEX-PLAN`, `START-DATE`, `GROUP-NAME`	Primary		BN00.1, BN02.1, BN02.3, BN06.1, BN08.1, BN100, BN101, BN102 +22 more (list truncated in source)
`FLDSET3`	`COMPANY`, `FLEX-PLAN`, `START-DATE*`, `GROUP-NAME`			BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
`FLDSET4`	`COMPANY`, `FLEX-PLAN`, `START-DATE`, `GROUP-NAME`	KeyChange, Subset	Where (AGE-RATE-TBL != Spaces) Or (SERV-RATE-TBL != Spaces) Or (DEP-RATE-TBL != Spaces) Or (LIFE-RATE-TBL != Spaces)	BN02.1, BN02.2, BN02.3, BN02.4, BN02.5

Relations

One to one (8) — lookups and parents

Relation	Table	Rules	Field map
Age Rate Tbl	RATETBLHDR	Required	`FLD-COMPANY` → `RTH-COMPANY`, `FLD-AGE-RATE-TBL` → `RTH-TABLE-CODE`, `FLD-START-DATE` → `RTH-START-DATE`
Company	BNCOMPANY	Required	`FLD-COMPANY` → `BNC-COMPANY`
Company Name	PRSYSTEM	Required	`FLD-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Dep Rate Tbl	RATETBLHDR	Required	`FLD-COMPANY` → `RTH-COMPANY`, `FLD-DEP-RATE-TBL` → `RTH-TABLE-CODE`, `FLD-START-DATE` → `RTH-START-DATE`
Flexible Plan	FLEXPLAN	Required	`FLD-COMPANY` → `FLP-COMPANY`, `FLD-FLEX-PLAN` → `FLP-FLEX-PLAN`
Life Rate Tbl	RATETBLHDR	Required	`FLD-COMPANY` → `RTH-COMPANY`, `FLD-LIFE-RATE-TBL` → `RTH-TABLE-CODE`, `FLD-START-DATE` → `RTH-START-DATE`
Persgroup	PERSGROUP	Required	`FLD-COMPANY` → `PRG-COMPANY`, `FLD-GROUP-NAME` → `PRG-GROUP-NAME`
Serv Rate Tbl	RATETBLHDR	Required	`FLD-COMPANY` → `RTH-COMPANY`, `FLD-SERV-RATE-TBL` → `RTH-TABLE-CODE`, `FLD-START-DATE` → `RTH-START-DATE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Emp Flex Dol	EMPFLEXDOL	Delete Restricted		`FLD-COMPANY` → `EFD-COMPANY`, `FLD-START-DATE` → `EFD-START-DATE`, → `EFD-EMPLOYEE`

Programs

Updated by (41)

BN00.1 Benefits Company
BN08.1 Flex Credits
BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN145 Flex Dollars Calculation
BN232 Benefits Statement
BN245 Benefit Election Form
BN260 Employee Benefit Extract
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
BN320 Premium Report
BN331 HIPAA Certification Report
BN340 ADP and ACP Tests
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BN90.1 Comments
BS09.1 Employee Annual Enrollment Rules
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
BS32.1 Web Enrollment Stop Benefits Update
ZB01.1 Years Of Service Calculation
ZB10.1 Coverage Options Calculator
ZB10.2 Get Benefit Eligibility Dates
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 (15)

BN02.1 Age Rate Table
BN02.2 Salary Rate Table
BN02.3 Service Rate Table
BN02.4 Credits Rate Table
BN02.5 Coverage Reduction Table
BN06.1 Flex Plan
BN104 Frequency Table Update
BN206 Flex Plan Listing
BN238 Vacation Hours History
BN246 Flex Missing Benefits Report
BN258 Spending Account Balance
BN259 Spending Account Payment Report
BN325 Benefit Exception Report
HR55.1 Employee Group Definition
LP138 Absence Plan Hours Update