OCCURTYPE

COBRA Occurrence Type

The COBRA Occurrence Type file contains information about occurrences.

REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN106
BN170 BN270 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN531 BN532 BN70.1 BN70.2 BN71.1
BN72.1 BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1
ZB32.2 ZB32.3 HR13.1 HR13.2 HR13.3 HR13.4
HR513 PA100 PA218 PA52.1 PA52.5 BN05.1
BN16.1 BN16.2 BN16.3 BN16.4 BN200 BN216


UPDATED BY
BN00.1 BN00.3 BN171

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OCC-COMPANY
Element: Company Hr
Numeric 4
Contains the company number. The number correlates all information about the company.
BN00.3
OCC-OCCUR-TYPE
Element: Occur Type
Alpha 2
Contains the user-defined code that represents an occurrence.
BN00.3
OCC-DESC
Element: Description
Alpha 30 (Lower Case)
Contains a description of the occurrence.
BN00.3 BN16.4
OCC-MONTHS-EXT
Element: Months Ext
Numeric 2
Contains the number of months a COBRA participant's coverage extends for the occurrence.
BN00.3
OCC-IN-LTR-CODE
Element: In Ltr Code
Alpha 2
Contains the letter code assigned to the occurrence.
BN00.3
OCC-EVENT-CODE
Element: 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


OCCURTYPE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OCCSET1 COMPANY
OCCUR-TYPE
...
BN00.1 BN00.3
BN05.1 BN100
BN101 BN102
BN103 BN105
BN106 BN16.1
BN16.2 BN16.3
BN16.4 BN170
BN171 BN200
BN216 BN270
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN532 BN70.1
BN70.2 BN71.1
BN72.1 BS32.1


OCCURTYPE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:10:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.