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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#BPE-COMPANY PKCOMPANY | Numeric 4 | — | BS03.1 |
#BPE-PLAN-TYPE PKPLAN_TYPE | Alpha 2 | —
| BS03.1 |
#BPE-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains the user-defined code that represents a benefit plan. | BS03.1 |
#BPE-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | BS03.1 |
#BPE-GROUP-NAME PKGROUP_NAME | Alpha 10 | — | BS03.1 |
#BPE-PLAN-GROUP PKPLAN_GROUP | Alpha 20 | — | BS03.1 |
#BPE-PROCESS-ORDER SET2PROCESS_ORDER | Numeric 2 | — | BS02.1, BS03.1 |
#BPE-ANNUAL-ENROLLANNUAL_ENROLL | Alpha 1 | —
| — |
#BPE-LIFE-EVENTLIFE_EVENT | Alpha 1 | —
| — |
#BPE-INQUIRYINQUIRY | Alpha 1 | —
| — |
#BPE-CHANGECHANGE | Alpha 1 | —
| — |
#BPE-HIREHIRE | Alpha 1 | —
| — |
#BPE-EMPLOYEE-COSTEMPLOYEE_COST | Alpha 1 | —
| BS03.1 |
#BPE-COMPANY-COSTCOMPANY_COST | Alpha 1 | —
| BS03.1 |
#BPE-DEP-BENEFITSDEP_BENEFITS | Alpha 1 | —
| BS03.1 |
#BPE-BENEFICIARYBENEFICIARY | Alpha 1 | —
| — |
#BPE-CO-PROVIDEDCO_PROVIDED | Alpha 1 | —
| — |
#BPE-DATE-1DATE_1 | Numeric 8 (yyyymmdd) | — | — |
#BPE-DATE-2DATE_2 | Numeric 8 (yyyymmdd) | — | — |
#BPE-MISC-1MISC_1 | Alpha 10 | — | — |
#BPE-MISC-2MISC_2 | Alpha 10 | — | — |
#BPE-CREATE-TRANSCREATE_TRANS | Alpha 1 | —
| BS03.1 |
#BPE-DEFAULT-REASONDEFAULT_REASON | Alpha 10 Occurs 3 Times ×3 | — | BS03.1 |
#BPE-REASON-1REASON_1 | Derived | — | — |
#BPE-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | BS03.1 |
#BPE-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | BS03.1 |
#BPE-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | BS03.1 |
#BPE-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | BS02.1, BS03.1 |
#BPE-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | BS02.1, BS03.1 |
#BPE-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | BS02.1, BS03.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 | Condition | Used in |
|---|---|---|---|---|
BPESET1 |
| Primary | BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source) | |
BPESET2 |
| BS10.1, BS12.1 | ||
BPESET3 |
| BS03.1, BS13.1, BS14.1, BS15.1 | ||
BPESET4 |
| BS02.1 | ||
BPESET5 |
| BN15.1 |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bncompany | BNCOMPANY | Required |
| ||||||||||
| Employee Group | PERSGROUP | Required |
| ||||||||||
| Plan | PLAN | Required |
| ||||||||||
| Plan Group | BNPLNGROUP | Required |
| ||||||||||
| Prsystem | PRSYSTEM | Required |
| ||||||||||
| Reason Code | PCODES | Required | When BPE-REASON-1 != Zeroes |
|
Programs
Updated by (2)
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