OCCURTYPE – COBRA Occurrence Type

System: Benefits (BN)
Prefix: OCC
Primary key: COMPANY, OCCUR-TYPE
Fields: 6
Updated by: 2 programs
Referenced by: 43 programs

OCCURTYPE is the COBRA Occurrence Type table in Lawson Benefits (prefix OCC). It is indexed by COMPANY, OCCUR-TYPE (OCCSET1). It is related 1:1 to BNCOMPANY, PRSYSTEM and LETTERCODE. It is updated by BN00.1 and BN00.3 and referenced by BN05.1, BN100, BN101, BN102, BN103, BN105, BN106, BN16.1 and 35 more. The table has 6 fields, 1 index and 3 documented relations.

About OCCURTYPE

The COBRA Occurrence Type file contains information about occurrences.

Fields (6)

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

Field / column	Type	Description & values	Updated by
`OCC-COMPANY` PK COMPANY	Numeric 4	Contains the company number. The number correlates all information about the company.	BN00.3
`OCC-OCCUR-TYPE` PK OCCUR_TYPE	Alpha 2	Contains the user-defined code that represents an occurrence.	BN00.3
`OCC-DESC` DESC	Alpha 30 (Lower Case)	Contains a description of the occurrence.	BN00.3, BN16.4
`OCC-MONTHS-EXT` MONTHS_EXT	Numeric 2	Contains the number of months a COBRA participant's coverage extends for the occurrence.	BN00.3
`OCC-IN-LTR-CODE` IN_LTR_CODE	Alpha 2	Contains the letter code assigned to the occurrence.	BN00.3
`OCC-EVENT-CODE` EVENT_CODE	Numeric 1	— `1` Termination of Employment `2` Reduction of Work Hours `3` Medicare `4` Death `5` Divorce `6` Separation `7` Ineligible Child `8` Bankruptcy of Retiree	BN00.3

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`OCCSET1`	`COMPANY`, `OCCUR-TYPE`	Primary		BN00.1, BN00.3, BN05.1, BN100, BN101, BN102, BN103, BN105 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	BNCOMPANY	Required		`OCC-COMPANY` → `BNC-COMPANY`
Company Name	PRSYSTEM	Required		`OCC-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Letter Code	LETTERCODE	Required	When OCC-IN-LTR-CODE != Spaces	`OCC-COMPANY` → `LTC-COMPANY`, `OCC-IN-LTR-CODE` → `LTC-LETTER-CODE`, `Zeroes` → `LTC-EMPLOYEE`, `Zeroes` → `LTC-DEPENDENT`, `Zeroes` → `LTC-PARTICIPNT`, `Zeroes` → `LTC-DATE`

Programs

Updated by (2)

BN00.1 Benefits Company
BN00.3 COBRA Occurrence Types

Referenced by (43)

BN05.1 Standard Letter
BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN106 Benefit Transaction Export
BN16.1 Benefit Entry Rules
BN16.2 Add Rules
BN16.3 Change Rules
BN16.4 Termination Rules
BN170 COBRA Notification Report
BN171 COBRA Letter Print
BN200 Company Parameter Listing
BN216 Benefit Entry Rules Listing
BN270 COBRA Participant Listing
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
BN531 Batch Benefit Enrollment
BN532 Batch Dependent Benefit Enrollment
BN70.1 COBRA Participant
BN70.2 Participant Dates
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS32.1 Web Enrollment Stop Benefits Update
HR13.1 Dependent
HR13.2 Dependent Benefits
HR13.3 Dependent Benefits
HR13.4 Dependent Benefits
HR513 Dependent Conversion
PA100 Action Update
PA218 Travel Listing
PA52.1 Individual Action
PA52.5 Position and Job Action
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