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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#FLP-COMPANY PKCOMPANY | Numeric 4 | Contains the company number, which represents an established company. | BN06.1 |
#FLP-FLEX-PLAN PKFLEX_PLAN | Alpha 4 | Contains the code that represents the flex plan. | BN06.1 |
#FLP-DESCDESC | Alpha 30 (Lower Case) | Contains the description of the flex plan. | BN06.1 |
#FLP-GROUP-NAMEGROUP_NAME | Alpha 10 | Contains the employee group for eligibility. | BN06.1 |
#FLP-ENTRY-MMDDENTRY_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-ONLYSPEND_ONLY | Alpha 1 | Indicates whether the flex plan is a spending account only.
| BN06.1 |
#FLP-DED-TABLE SET2DED_TABLE | Alpha 2 | Contains the frequency table assigned to the flex plan. | BN06.1 |
#FLP-FLEX-PAY-CODEFLEX_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-CODEPIK_PAY_CODE | Alpha 4 | This field is not used. | — |
#FLP-PRE-TAX-DEDPRE_TAX_DED | Alpha 4 | This field is not used. | — |
#FLP-ATN-DEDATN_DED | Alpha 4 | This field is not used. | — |
#FLP-CORE-HEALTHCORE_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-DENTALCORE_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-DISABCORE_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-LIFECORE_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-LIFECORE_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-FLAGHEALTH_FLAG | Alpha 1 | — | BN15.1 |
#FLP-DENTAL-FLAGDENTAL_FLAG | Alpha 1 | — | BN15.1 |
#FLP-DISAB-FLAGDISAB_FLAG | Alpha 1 | — | BN15.1 |
#FLP-LIFE-FLAGLIFE_FLAG | Alpha 1 | — | BN15.1 |
#FLP-DEP-LIFE-FLAGDEP_LIFE_FLAG | Alpha 1 | — | BN15.1 |
#FLP-DED-FREQ-FLAGDED_FREQ_FLAG | Numeric 1 | —
| BN04.1, BN06.1, BN104 |
#FLP-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | BN06.1 |
#FLP-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | BN06.1 |
#FLP-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | BN06.1 |
#FLP-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | BN06.1 |
#FLP-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | BN06.1 |
#FLP-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | BN06.1 |
#FLP-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | BN06.1 |
#FLP-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | BN06.1 |
Indexes (2)
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 | Condition | Used in |
|---|---|---|---|---|
FLPSET1 |
| Primary | BN00.1, BN04.1, BN06.1, BN08.1, BN100, BN101, BN102, BN103 +22 more (list truncated in source) | |
FLPSET2 |
| KeyChange | BN04.1 |
Relations
One to one (14) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Atn Ded | DEDCODE | Required |
| |||||||||||||
| Company | BNCOMPANY | Required |
| |||||||||||||
| Company Name | PRSYSTEM | Required |
| |||||||||||||
| Currency | CUCODES | Required | When FLP-CURRENCY-CODE != Spaces |
| ||||||||||||
| Deduct Table | DEDFREQTBL | Required |
| |||||||||||||
| Di Core Plan | PLAN | Not Required |
| |||||||||||||
| Dl Core Plan | PLAN | Not Required |
| |||||||||||||
| Dn Core Plan | PLAN | Not Required |
| |||||||||||||
| El Core Plan | PLAN | Not Required |
| |||||||||||||
| Flex Pay Code | PRPAYCODE | Required | When FLP-FLEX-PAY-CODE != Spaces |
| ||||||||||||
| Group Name | PERSGROUP | Not Required |
| |||||||||||||
| Hl Core Plan | PLAN | Not Required |
| |||||||||||||
| Pik Pay Code | PRPAYCODE | Required |
| |||||||||||||
| Pre Tax Ded | DEDCODE | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Flex Dollars | FLEXDOLLAR |
|
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