BNPLNENR – No description in the Lawson data dictionary

System: Benefits (BN)
Prefix: BPE
Primary key: COMPANY, PROCESS-LEVEL, GROUP-NAME, PLAN-GROUP, PLAN-TYPE, PLAN-CODE
Fields: 30
Updated by: 2 programs
Referenced by: 40 programs

BNPLNENR is a Lawson Benefits table (prefix BPE); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, GROUP-NAME, PLAN-GROUP, PLAN-TYPE, PLAN-CODE (BPESET1); alternate indexes: BPESET2, BPESET3, BPESET4 and BPESET5. It is related 1:1 to BNCOMPANY, PERSGROUP, PLAN, BNPLNGROUP, PRSYSTEM and PCODES. It is updated by BS02.1 and BS03.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN232 and 32 more. The table has 30 fields, 5 indexes and 6 documented relations.

About BNPLNENR

No description in the Lawson data dictionary.

Fields (30)

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

Field / column	Type	Description & values	Updated by
`BPE-COMPANY` PK COMPANY	Numeric 4	—	BS03.1
`BPE-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	— `DB` Defined Benefit `DC` Defined Contribution `DI` Disability `DL` Dependent Life `EL` Employee Life `HL` Health `RS` Spending Account `SB` Savings Bond `SP` Stock Purchase `VA` Vacation	BS03.1
`BPE-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BS03.1
`BPE-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	—	BS03.1
`BPE-GROUP-NAME` PK GROUP_NAME	Alpha 10	—	BS03.1
`BPE-PLAN-GROUP` PK PLAN_GROUP	Alpha 20	—	BS03.1
`BPE-PROCESS-ORDER` PROCESS_ORDER	Numeric 2	—	BS02.1, BS03.1
`BPE-ANNUAL-ENROLL` ANNUAL_ENROLL	Alpha 1	— `Y` Yes `N` No	—
`BPE-LIFE-EVENT` LIFE_EVENT	Alpha 1	— `M` Marriage `D` Divorce `B` Birth `A` Adoption	—
`BPE-INQUIRY` INQUIRY	Alpha 1	— `Y` Yes `N` No	—
`BPE-CHANGE` CHANGE	Alpha 1	— `Y` Yes `N` No	—
`BPE-HIRE` HIRE	Alpha 1	— `Y` Yes `N` No	—
`BPE-EMPLOYEE-COST` EMPLOYEE_COST	Alpha 1	— `E` Employee Only `F` Flex Only `B` Both Employee and Flex `T` Total of Employee and Flex	BS03.1
`BPE-COMPANY-COST` COMPANY_COST	Alpha 1	— `Y` Yes `N` No	BS03.1
`BPE-DEP-BENEFITS` DEP_BENEFITS	Alpha 1	— `Y` Yes `N` No	BS03.1
`BPE-BENEFICIARY` BENEFICIARY	Alpha 1	— `Y` Yes `N` No	—
`BPE-CO-PROVIDED` CO_PROVIDED	Alpha 1	— `Y` Yes `N` No	—
`BPE-DATE-1` DATE_1	Numeric 8 (yyyymmdd)	—	—
`BPE-DATE-2` DATE_2	Numeric 8 (yyyymmdd)	—	—
`BPE-MISC-1` MISC_1	Alpha 10	—	—
`BPE-MISC-2` MISC_2	Alpha 10	—	—
`BPE-CREATE-TRANS` CREATE_TRANS	Alpha 1	— `Y` Yes `N` No	BS03.1
`BPE-DEFAULT-REASON` DEFAULT_REASON	Alpha 10 Occurs 3 Times ×3	—	BS03.1
`BPE-REASON-1` REASON_1	Derived	—	—
`BPE-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BS03.1
`BPE-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BS03.1
`BPE-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BS03.1
`BPE-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BS02.1, BS03.1
`BPE-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BS02.1, BS03.1
`BPE-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BS02.1, BS03.1

Indexes (5)

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

Index	Keys	Flags	Used in
`BPESET1`	`COMPANY`, `PROCESS-LEVEL`, `GROUP-NAME`, `PLAN-GROUP`, `PLAN-TYPE`, `PLAN-CODE`	Primary	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
`BPESET2`	`COMPANY`, `PROCESS-LEVEL`, `GROUP-NAME`, `PROCESS-ORDER`, `PLAN-TYPE`, `PLAN-CODE`		BS10.1, BS12.1
`BPESET3`	`COMPANY`, `PROCESS-LEVEL`, `GROUP-NAME`, `PLAN-TYPE`, `PLAN-CODE`		BS03.1, BS13.1, BS14.1, BS15.1
`BPESET4`	`COMPANY`, `PROCESS-LEVEL`, `PLAN-GROUP`, `GROUP-NAME`, `PLAN-TYPE`, `PLAN-CODE`		BS02.1
`BPESET5`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `PROCESS-LEVEL`, `GROUP-NAME`, `PLAN-GROUP`		BN15.1

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Condition	Field map
Bncompany	BNCOMPANY	Required		`BPE-COMPANY` → `BNC-COMPANY`
Employee Group	PERSGROUP	Required		`BPE-COMPANY` → `PRG-COMPANY`, `BPE-GROUP-NAME` → `PRG-GROUP-NAME`
Plan	PLAN	Required		`BPE-COMPANY` → `PLN-COMPANY`, `BPE-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BPE-PLAN-CODE` → `PLN-PLAN-CODE`
Plan Group	BNPLNGROUP	Required		`BPE-COMPANY` → `BPG-COMPANY`, `BPE-PLAN-GROUP` → `BPG-PLAN-GROUP`
Prsystem	PRSYSTEM	Required		`BPE-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Reason Code	PCODES	Required	When BPE-REASON-1 != Zeroes	`"BT"` → `PCO-TYPE`, `BPE-DEFAULT-REASON` → `PCO-CODE`

Programs

Updated by (2)

BS02.1 Benefits Plan Groups
BS03.1 Benefits Annual Enrollment Plan Rules

Referenced by (40)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN145 Flex Dollars Calculation
BN15.1 Benefit Plan
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
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
ZB599 Update Enrollment Data Structu