BNWAIT – Benefit Waiting Period

System: Benefits (BN)
Prefix: BWT
Primary key: COMPANY, RULE-TYPE, PLAN-TYPE, PLAN-CODE, START-DATE, GROUP-NAME, ACTION-CODE
Fields: 38
Updated by: 43 programs
Referenced by: 3 programs

BNWAIT is the Benefit Waiting Period table in Lawson Benefits (prefix BWT). It is indexed by COMPANY, RULE-TYPE, PLAN-TYPE, PLAN-CODE, START-DATE, GROUP-NAME, ACTION-CODE (BWTSET1); alternate indexes: BWTSET2, BWTSET3 and BWTSET4. It is related 1:1 to PLAN, OCCURTYPE, PAYCLASS, PERSGROUP, PRSYSTEM and PCODES. It is updated by BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN16.1 and 35 more and referenced by BN216, BN345 and HR55.1. The table has 38 fields, 4 indexes and 10 documented relations.

About BNWAIT

Contains all plan eligibility rules for employees. It includes all initial and re-enrollment rules used for benefit entry and all add, change, and termination rules used by BN100 (Employee Change Benefit Update).

Fields (38)

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

Field / column	Type	Description & values	Updated by
`BWT-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-RULE-TYPE` PK RULE_TYPE	Alpha 1	Contains waiting period rules used at benefit entry. Add, change, and termination rules are used by BN100 (Employee Change Benefit Update). " " = Waiting Periods `A` Add Rules `C` Change Rules `T` Termination Rules	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Contains the benefit plan type. `HL` Health `DN` Dental `DI` Disability `EL` Life `DL` Dependent Life `DC` Defined Contribution `DB` Defined Benefit `VA` Vacation `RS` Spending Account `SB` Savings Bond `SP` Stock Purchase `FL` Flex	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the start date for the rule.	BN100, BN101, BN102, BN103, BN105, BN145, BN16.1, BN16.2 +32 more
`BWT-GROUP-NAME` PK GROUP_NAME	Alpha 10	Contains the employee group for which the rule applies. If the group is blank, the system will use this rule for all employees.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-ACTION-CODE` PK ACTION_CODE	Alpha 10	This field contains the personnel action code for add, change, and termination rules.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-ENTRY-AGE` ENTRY_AGE	Numeric 2	Contains the entry age if eligibility rules require a minimum age for entry into the plan.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-FROM-DATE` FROM_DATE	Alpha 2	Indicates the date from which the waiting period is calculated. `HI` Hire Date `AJ` Adjusted Hire Date `AN` Anniversary Date `PA` Personnel Action Eff Date `SN` Seniority Date `WP` Work Period Begin Date `B1` Benefit Date 1 `B2` Benefit Date 2 `B3` Benefit Date 3 `B4` Benefit Date 4 `B5` Benefit Date 5 `X` Custom Calculation	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-MNTHS-SERV` MNTHS_SERV	Numeric 2	Indicates the number of months of service used to determine the initial eligibility date.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-HOURS-SERV` HOURS_SERV	Signed 7.2	Indicates the hours of service used to determine the initial eligibility date.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-QUAL-PERIOD` QUAL_PERIOD	Numeric 3	Contains the number of days used to determine the initial eligibility date.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-PAY-CLASS` PAY_CLASS	Alpha 3	If hours are used to determine eligibility, this field contains the pay class used to determine which hours are used to determine eligibility.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-INIT-ENT-POINT` INIT_ENT_POINT	Alpha 1	Indicates the initial entry point at which employees begin to receive benefits. `0` No Entry Points `1` Prior Entry Point `2` Next Entry Point `3` Prior Pay Period `4` Next Pay Period `5` Prior Work Period `6` Next Work Period	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-ENTRY-MMDD` ENTRY_MMDD	Numeric 4 Occurs 12 Times ×12	If entry points are used, this field contains the specific month and day initial eligibility date.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-SUB-FROM` SUB_FROM	Alpha 2	If re-enrollment rules are used, this field contains the beginning date used calculate re-enrollment eligibility. `HI` Hire Date `AJ` Adjusted Hire Date `AN` Anniversary Date `SN` Seniority Date `B1` Benefit Date 1 `B2` Benefit Date 2 `B3` Benefit Date 3 `B4` Benefit Date 4 `B5` Benefit Date 5 `X` Custom Calculation	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-SUB-MOS` SUB_MOS	Numeric 2	If re-enrollment rules are used, this field contains the number of months from the beginning date used to calculate re-enrollment eligibility.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-SUB-DAYS` SUB_DAYS	Numeric 3	If re-enrollment rules are used, this field contains the number of days from the beginning date used to calculate re-enrollment eligibility.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-SUB-CLASS` SUB_CLASS	Alpha 3	If re-enrollment rules are used, this field contains the pay class used to determine which hours are used for re-enrollment.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-SUB-HOURS` SUB_HOURS	Signed 7.2	If re-enrollment rules are used, this field contains the number of hours from the subsequent enrollment date used to calculate re-enrollment eligibility.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-SUB-ENT-POINT` SUB_ENT_POINT	Alpha 1	If re-enrollment rules are used, this field determines if the re-enrollment point has specific entry points. `0` No Entry Points `1` Prior Entry Point `2` Next Entry Point `3` Prior Pay Period `4` Next Pay Period `5` Prior Work Period `6` Next Work Period	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-SUB-POINTS` SUB_POINTS	Numeric 4 Occurs 12 Times ×12	If re-enrollment rules are used with entry points, this field contains the months and days used as entry points.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-TERM-STOP-DATE` TERM_STOP_DATE	Alpha 2	If termination rules are used, this field contains the beginning date used to calculate the benefit termination date. `TM` Termination Date `PA` Personnel Action Date `WP` Work Period End Date `PP` Pay Period End Date `ME` End of Month `UE` Custom Calculation	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-TERM-MOS` TERM_MOS	Numeric 2	If termination rules are used, this field contains the number of months used to calculate the benefit termination date.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-TERM-DAYS` TERM_DAYS	Numeric 3	If termination rules are used, this field contains the number of days from the termination stop date that benefits will terminate.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-CHG-WAIT` CHG_WAIT	Alpha 1	This field is not used. `0` Not Updated `1` Updated	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-COBRA-OCC` COBRA_OCC	Alpha 1	If termination rules are used, this field defines whether this benefit termination is a COBRA occurrence. `Y` Yes `N` No	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-COBRA-TYPE` COBRA_TYPE	Alpha 2	If this benefit termination is a COBRA occurrence, this field defines the of occurrence.	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-RE-ENROLL-DATE` RE_ENROLL_DATE	Alpha 2	If the rule type is " " for the waiting period, this field contains the beginning date used to calculate the re-enrollment date. `HI` Hire Date `AJ` Adjusted Hire Date `AN` Anniversary Date `PA` Personnel Action Eff Date `SN` Seniority Date `WP` Work Period Begin Date `B1` Benefit Date 1 `B2` Benefit Date 2 `B3` Benefit Date 3 `B4` Benefit Date 4 `B5` Benefit Date 5 `X` Custom Calculation	—
`BWT-CHANGE-EFFECT` CHANGE_EFFECT	Alpha 2	If change rules are used, this field contains the date the change is effective. `PA` Personnel Action Eff Date `NM` First of Next Month `PM` First of Prior Month `DC` Date of Change `PP` Prior Pay Period `NP` Next Pay Period `PW` Prior Work Period `NW` Next Work Period	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-TRAN-REASON` TRAN_REASON	Alpha 10	—	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-SUB-TYPE` SUB_TYPE	Alpha 1	— `1` By Benefit Type `2` By Plan	—
`BWT-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN16.1, BN16.2, BN16.3, BN16.4
`BWT-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN16.1, BN16.2, BN16.3, BN16.4

Indexes (4)

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

Index	Keys	Flags	Used in
`BWTSET1`	`COMPANY`, `RULE-TYPE`, `PLAN-TYPE`, `PLAN-CODE`, `START-DATE`, `GROUP-NAME`, `ACTION-CODE`	Primary	BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN16.1 +22 more (list truncated in source)
`BWTSET2`	`COMPANY`, `RULE-TYPE`, `PLAN-TYPE`, `PLAN-CODE`, `START-DATE*`, `GROUP-NAME`, `ACTION-CODE`		BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
`BWTSET3`	`COMPANY`, `RULE-TYPE`, `PLAN-TYPE`, `PLAN-CODE`, `ACTION-CODE`, `START-DATE*`, `GROUP-NAME`		BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
`BWTSET4`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `RULE-TYPE`, `START-DATE`, `GROUP-NAME`, `ACTION-CODE`		BN15.1, BN216

Relations

One to one (10) — lookups and parents

Relation	Table	Rules	Condition	Field map
Add Rules	PLAN	Required	When BWT-RULE-TYPE = "A"	`BWT-COMPANY` → `PLN-COMPANY`, `BWT-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BWT-PLAN-CODE` → `PLN-PLAN-CODE`
Change Rules	PLAN	Required	When BWT-RULE-TYPE = "C"	`BWT-COMPANY` → `PLN-COMPANY`, `BWT-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BWT-PLAN-CODE` → `PLN-PLAN-CODE`
Cobra Occur	OCCURTYPE	Required		`BWT-COMPANY` → `OCC-COMPANY`, `BWT-COBRA-TYPE` → `OCC-OCCUR-TYPE`
Payclass	PAYCLASS	Required		`BWT-COMPANY` → `PCL-COMPANY`, `BWT-PAY-CLASS` → `PCL-PAY-CLASS`
Persgroup	PERSGROUP	Not Required		`BWT-COMPANY` → `PRG-COMPANY`, `BWT-GROUP-NAME` → `PRG-GROUP-NAME`
Plan	PLAN	Required		`BWT-COMPANY` → `PLN-COMPANY`, `BWT-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BWT-PLAN-CODE` → `PLN-PLAN-CODE`
Prsystem	PRSYSTEM	Required		`BWT-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Reason Code	PCODES	Not Required		`"BT"` → `PCO-TYPE`, `BWT-TRAN-REASON` → `PCO-CODE`
Term Rules	PLAN	Required	When BWT-RULE-TYPE = "T"	`BWT-COMPANY` → `PLN-COMPANY`, `BWT-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BWT-PLAN-CODE` → `PLN-PLAN-CODE`
Wait Rules	PLAN	Required	When BWT-RULE-TYPE = Spaces	`BWT-COMPANY` → `PLN-COMPANY`, `BWT-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BWT-PLAN-CODE` → `PLN-PLAN-CODE`

Programs

Updated by (43)

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
BN16.1 Benefit Entry Rules
BN16.2 Add Rules
BN16.3 Change Rules
BN16.4 Termination Rules
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

Referenced by (3)

BN216 Benefit Entry Rules Listing
BN345 Percentage Test
HR55.1 Employee Group Definition