FLEXPLAN – Flex Plan

System: Benefits (BN)
Prefix: FLP
Primary key: COMPANY, FLEX-PLAN
Fields: 30
Updated by: 5 programs
Referenced by: 54 programs

FLEXPLAN is the Flex Plan table in Lawson Benefits (prefix FLP). It is indexed by COMPANY, FLEX-PLAN (FLPSET1); alternate indexes: FLPSET2. It is related 1:1 to DEDCODE, BNCOMPANY, PRSYSTEM, CUCODES, DEDFREQTBL, PLAN, PRPAYCODE and PERSGROUP and 1:M to FLEXDOLLAR. It is updated by BN00.1, BN04.1, BN06.1, BN104 and BN15.1 and referenced by BN08.1, BN100, BN101, BN102, BN103, BN105, BN145, BN16.1 and 46 more. The table has 30 fields, 2 indexes and 15 documented relations.

About FLEXPLAN

The Flex Plan file contains information about flex plans.

Fields (30)

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

Field / column	Type	Description & values	Updated by
`FLP-COMPANY` PK COMPANY	Numeric 4	Contains the company number, which represents an established company.	BN06.1
`FLP-FLEX-PLAN` PK FLEX_PLAN	Alpha 4	Contains the code that represents the flex plan.	BN06.1
`FLP-DESC` DESC	Alpha 30 (Lower Case)	Contains the description of the flex plan.	BN06.1
`FLP-GROUP-NAME` GROUP_NAME	Alpha 10	Contains the employee group for eligibility.	BN06.1
`FLP-ENTRY-MMDD` ENTRY_MMDD	Numeric 4	Contains the date the flex plan year begins. The flex plan year is the twelve month period beginning on this month and day.	BN06.1, BN430
`FLP-SPEND-ONLY` SPEND_ONLY	Alpha 1	Indicates whether the flex plan is a spending account only. `N` No `Y` Yes	BN06.1
`FLP-DED-TABLE` DED_TABLE	Alpha 2	Contains the frequency table assigned to the flex plan.	BN06.1
`FLP-FLEX-PAY-CODE` FLEX_PAY_CODE	Alpha 4	Contains the code that represents the flex credit pay code assigned to the flex plan.	BN06.1, BN145
`FLP-PIK-PAY-CODE` PIK_PAY_CODE	Alpha 4	This field is not used.	—
`FLP-PRE-TAX-DED` PRE_TAX_DED	Alpha 4	This field is not used.	—
`FLP-ATN-DED` ATN_DED	Alpha 4	This field is not used.	—
`FLP-CORE-HEALTH` CORE_HEALTH	Alpha 4	If a health benefit plan under the flex plan is defined as a core plan, this field is updated as Yes or Spouse.	BN15.1
`FLP-CORE-DENTAL` CORE_DENTAL	Alpha 4	If a dental benefit plan under the flex plan is defined as a core plan, this field is updated as Yes or Spouse.	BN15.1
`FLP-CORE-DISAB` CORE_DISAB	Alpha 4	If a disability benefit plan under the flex plan is defined as a core plan, this field is updated with Yes.	BN15.1
`FLP-CORE-LIFE` CORE_LIFE	Alpha 4	If an employee life benefit plan under the flex plan is defined as a core plan, this field is updated as Yes.	BN15.1
`FLP-CORE-DEP-LIFE` CORE_DEP_LIFE	Alpha 4	If a dependent life benefit plan under the flex plan is defined as a core plan, this field is updated with Yes or Spouse.	BN15.1
`FLP-HEALTH-FLAG` HEALTH_FLAG	Alpha 1	—	BN15.1
`FLP-DENTAL-FLAG` DENTAL_FLAG	Alpha 1	—	BN15.1
`FLP-DISAB-FLAG` DISAB_FLAG	Alpha 1	—	BN15.1
`FLP-LIFE-FLAG` LIFE_FLAG	Alpha 1	—	BN15.1
`FLP-DEP-LIFE-FLAG` DEP_LIFE_FLAG	Alpha 1	—	BN15.1
`FLP-DED-FREQ-FLAG` DED_FREQ_FLAG	Numeric 1	— `0` Not Updated `1` Updated	BN04.1, BN06.1, BN104
`FLP-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BN06.1
`FLP-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BN06.1
`FLP-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN06.1
`FLP-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN06.1
`FLP-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN06.1
`FLP-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN06.1
`FLP-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN06.1
`FLP-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN06.1

Indexes (2)

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
`FLPSET1`	`COMPANY`, `FLEX-PLAN`	Primary		BN00.1, BN04.1, BN06.1, BN08.1, BN100, BN101, BN102, BN103 +22 more (list truncated in source)
`FLPSET2`	`COMPANY`, `DED-TABLE`, `FLEX-PLAN`	KeyChange		BN04.1

Relations

One to one (14) — lookups and parents

Relation	Table	Rules	Condition	Field map
Atn Ded	DEDCODE	Required		`FLP-COMPANY` → `DDC-COMPANY`, `FLP-ATN-DED` → `DDC-DED-CODE`
Company	BNCOMPANY	Required		`FLP-COMPANY` → `BNC-COMPANY`
Company Name	PRSYSTEM	Required		`FLP-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Currency	CUCODES	Required	When FLP-CURRENCY-CODE != Spaces	`FLP-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Deduct Table	DEDFREQTBL	Required		`FLP-COMPANY` → `DFT-COMPANY`, `FLP-DED-TABLE` → `DFT-TABLE-CODE`
Di Core Plan	PLAN	Not Required		`FLP-COMPANY` → `PLN-COMPANY`, `"DI"` → `PLN-PLAN-TYPE`, `FLP-CORE-DISAB` → `PLN-PLAN-CODE`
Dl Core Plan	PLAN	Not Required		`FLP-COMPANY` → `PLN-COMPANY`, `"DL"` → `PLN-PLAN-TYPE`, `FLP-CORE-DEP-LIFE` → `PLN-PLAN-CODE`
Dn Core Plan	PLAN	Not Required		`FLP-COMPANY` → `PLN-COMPANY`, `"DN"` → `PLN-PLAN-TYPE`, `FLP-CORE-DENTAL` → `PLN-PLAN-CODE`
El Core Plan	PLAN	Not Required		`FLP-COMPANY` → `PLN-COMPANY`, `"EL"` → `PLN-PLAN-TYPE`, `FLP-CORE-LIFE` → `PLN-PLAN-CODE`
Flex Pay Code	PRPAYCODE	Required	When FLP-FLEX-PAY-CODE != Spaces	`FLP-COMPANY` → `PCD-COMPANY`, `FLP-FLEX-PAY-CODE` → `PCD-PAY-CODE`, `Spaces` → `PCD-PROCESS-LEVEL`, `Spaces` → `PCD-JOB-CODE`
Group Name	PERSGROUP	Not Required		`FLP-COMPANY` → `PRG-COMPANY`, `FLP-GROUP-NAME` → `PRG-GROUP-NAME`
Hl Core Plan	PLAN	Not Required		`FLP-COMPANY` → `PLN-COMPANY`, `"HL"` → `PLN-PLAN-TYPE`, `FLP-CORE-HEALTH` → `PLN-PLAN-CODE`
Pik Pay Code	PRPAYCODE	Required		`FLP-COMPANY` → `PCD-COMPANY`, `FLP-PIK-PAY-CODE` → `PCD-PAY-CODE`, `Spaces` → `PCD-PROCESS-LEVEL`, `Spaces` → `PCD-JOB-CODE`
Pre Tax Ded	DEDCODE	Required		`FLP-COMPANY` → `DDC-COMPANY`, `FLP-PRE-TAX-DED` → `DDC-DED-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Flex Dollars	FLEXDOLLAR			`FLP-COMPANY` → `FLD-COMPANY`, `FLP-FLEX-PLAN` → `FLD-FLEX-PLAN`, → `FLD-START-DATE`, → `FLD-GROUP-NAME`

Programs

Updated by (5)

BN00.1 Benefits Company
BN04.1 Frequency Table
BN06.1 Flex Plan
BN104 Frequency Table Update
BN15.1 Benefit Plan

Referenced by (54)

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
BN16.1 Benefit Entry Rules
BN16.2 Add Rules
BN16.3 Change Rules
BN16.4 Termination Rules
BN206 Flex Plan Listing
BN215 Plan Parameter Listing
BN216 Benefit Entry Rules Listing
BN220 Benefit Plan Status Report
BN230 Plan Participant Report
BN232 Benefits Statement
BN238 Vacation Hours History
BN245 Benefit Election Form
BN246 Flex Missing Benefits Report
BN258 Spending Account Balance
BN259 Spending Account Payment Report
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
BN325 Benefit Exception Report
BN340 ADP and ACP Tests
BN350 Coverage Test - Classification
BN430 Benefit Purge
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN59.1 Spending Account Transactions
BN59.3 Plan Year Spending Account Totals
BN65.1 Election Simulation
BN65.2 Flex Credits
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS10.1 Web Enrollment Current Benefit Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS32.1 Web Enrollment Stop Benefits Update
HFLP.1 Flex Plan Selection Invoke
HR55.1 Employee Group Definition
LP138 Absence Plan Hours Update
PR20.4 Pay Code
PRBN.1 Payroll Cycle Benefit Edit
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