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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#OCC-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. The number correlates all information about the company. | BN00.3 |
#OCC-OCCUR-TYPE PKOCCUR_TYPE | Alpha 2 | Contains the user-defined code that represents an occurrence. | BN00.3 |
#OCC-DESCDESC | Alpha 30 (Lower Case) | Contains a description of the occurrence. | BN00.3, BN16.4 |
#OCC-MONTHS-EXTMONTHS_EXT | Numeric 2 | Contains the number of months a COBRA participant's coverage extends for the occurrence. | BN00.3 |
#OCC-IN-LTR-CODEIN_LTR_CODE | Alpha 2 | Contains the letter code assigned to the occurrence. | BN00.3 |
#OCC-EVENT-CODEEVENT_CODE | Numeric 1 | —
| BN00.3 |
Indexes (1)
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 |
|---|---|---|---|---|
OCCSET1 |
| 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 |
| |||||||||||||||||||
| Company Name | PRSYSTEM | Required |
| |||||||||||||||||||
| Letter Code | LETTERCODE | Required | When OCC-IN-LTR-CODE != Spaces |
|
Programs
Updated by (2)
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