OCCURTYPE

COBRA Occurrence Type

The COBRA Occurrence Type file contains information about occurrences.

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


UPDATED BY
BN00.1 BN00.3 BN05.1 BN171 BN200

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: Wed Jun 08 20:48:08 2016

Home
Contact Us



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