BNNEWHIRE – No description in the Lawson data dictionary

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

BNNEWHIRE is a Lawson Benefits table (prefix BNN); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, GROUP-NAME, PLAN-GROUP, PLAN-TYPE, PLAN-CODE (BNNSET1); alternate indexes: BNNSET2, BNNSET3, BNNSET4 and BNNSET5. It is related 1:1 to BNPLNGROUP, PERSGROUP, PLAN, PRSYSTEM and PCODES. It is updated by BS02.1 and BS03.3 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN232 and 31 more. The table has 23 fields, 5 indexes and 6 documented relations.

About BNNEWHIRE

No description in the Lawson data dictionary.

Fields (23)

Column = COBOL field name without the BNN- 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
#`BNN-COMPANY` PK COMPANY	Numeric 4	—	BS03.3
#`BNN-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	—	BS03.3
#`BNN-GROUP-NAME` PK GROUP_NAME	Alpha 10	—	BS03.3
#`BNN-PLAN-GROUP` PK PLAN_GROUP	Alpha 20	—	BS03.3
#`BNN-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	— `DB` Defined Benefit `DC` Defined Contribution `DI` Disability `DL` Dependent Life `DN` Dental `EL` Employee Life `HL` Health `RS` Spending Account `SB` Savings Bond `SP` Stock Purchase `VA` Vacation	BS03.3
#`BNN-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BS03.3
#`BNN-PROCESS-ORDER` SET2 PROCESS_ORDER	Numeric 2	—	BS02.1, BS03.3
#`BNN-EMPLOYEE-COST` EMPLOYEE_COST	Alpha 1	— `E` Employee Only `F` Flex Only `B` Employee And Flex Both `T` Total of Employee And Flex	BS03.3
#`BNN-COMPANY-COST` COMPANY_COST	Alpha 1	— `Y` Yes `N` No	BS03.3
#`BNN-DEP-BENEFITS` DEP_BENEFITS	Alpha 1	— `Y` Yes `N` No	BS03.3
#`BNN-BENEFICIARY` BENEFICIARY	Alpha 1	— `Y` Yes `N` No	—
#`BNN-CO-PROVIDED` CO_PROVIDED	Alpha 1	— `Y` Yes `N` No	—
#`BNN-EOI-DAYS` EOI_DAYS	Numeric 3	—	BS03.3
#`BNN-CREATE-TRANS` CREATE_TRANS	Alpha 1	— `Y` Yes `N` No	BS03.3
#`BNN-DEFAULT-REASON` DEFAULT_REASON	Alpha 10 Occurs 3 Times ×3	—	BS03.3
#`BNN-REASON-1` REASON_1	Derived	—	—
#`BNN-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BS03.3
#`BNN-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BS03.3
#`BNN-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BS03.3
#`BNN-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BS02.1, BS03.3
#`BNN-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BS02.1, BS03.3
#`BNN-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BS02.1, BS03.3
#`BNN-EFFECTIVE-CODE` EFFECTIVE_CODE	Alpha 2	Coded value to represent the effective date of changes. `CD` Current Date `ED` Eligibility Date	BS03.3

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	Used in
`BNNSET1`	`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)
`BNNSET2`	`COMPANY` `PROCESS-LEVEL` `GROUP-NAME` `PROCESS-ORDER` `PLAN-TYPE` `PLAN-CODE`		BS10.1, BS12.1
`BNNSET3`	`COMPANY` `PROCESS-LEVEL` `GROUP-NAME` `PLAN-TYPE` `PLAN-CODE`		BS03.3, BS13.1, BS14.1, BS15.1
`BNNSET4`	`COMPANY` `PROCESS-LEVEL` `PLAN-GROUP` `GROUP-NAME` `PLAN-TYPE` `PLAN-CODE`		BS02.1
`BNNSET5`	`COMPANY` `PLAN-TYPE` `PLAN-CODE` `PROCESS-LEVEL` `GROUP-NAME` `PLAN-GROUP`		BN15.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (6) — lookups and parents

Relation Table Rules Condition Field map

Bnplngroup

BNPLNGROUP

Required

`BNN-COMPANY`	→	`BPG-COMPANY`
`BNN-PLAN-GROUP`	→	`BPG-PLAN-GROUP`

Group Name

PERSGROUP

Required

`BNN-COMPANY`	→	`PRG-COMPANY`
`BNN-GROUP-NAME`	→	`PRG-GROUP-NAME`

Plan

PLAN

Required

`BNN-COMPANY`	→	`PLN-COMPANY`
`BNN-PLAN-TYPE`	→	`PLN-PLAN-TYPE`
`BNN-PLAN-CODE`	→	`PLN-PLAN-CODE`

Process Level

PRSYSTEM

Required

`BNN-COMPANY`	→	`PRS-COMPANY`
`BNN-PROCESS-LEVEL`	→	`PRS-PROCESS-LEVEL`

Prsystem

PRSYSTEM

Required

`BNN-COMPANY`	→	`PRS-COMPANY`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Reason Code

PCODES

Required

When BNN-REASON-1 != Zeroes

`"BT"`	→	`PCO-TYPE`
`BNN-DEFAULT-REASON`	→	`PCO-CODE`

Programs

Updated by (2)

BS02.1 Benefits Plan Groups
BS03.3 Benefits New Hire Plan Rules

Referenced by (39)

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

BNNEWHIRE – No description in the Lawson data dictionary

About BNNEWHIRE

Fields (23) Copy as SQL

Indexes (5)

Relations

One to one (6) — lookups and parents

Programs

Updated by (2)

Referenced by (39)

Fields (23)