PARTICIPNT FILE
COBRA Participant
The COBRA Participant file contains information about COBRA participants.
REFERENCED BY
BN00.1 BN102 BN105 BN181 BN230 BN233
BN270 BN281 BN285 BN321 BN331 BN430
BN480 BN71.1 BN72.1 BN77.1 BN81.1 BN81.2
BN82.1 BN85.1 HR30.1
UPDATED BY
BN100 BN170 BN171 BN175 BN180 BN70.1
BN70.2 BN80.1 BN90.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAR-COMPANY Numeric 4 BN100 BN70.1
Company Contains the company number. BN70.2
PAR-PARTICIPNT Numeric 9 BN100 BN70.1
Participant Number Contains COBRA participant numbers. BN70.2
PAR-LAST-NAME Alpha 30 (Lower Case) BN100 BN70.1
Last Name Contains the last name of the COBRA
participant or retiree.
PAR-FIRST-NAME Alpha 15 (Lower Case) BN100 BN70.1
First Name Contains the first name of the COBRA
participant or retiree.
PAR-MIDDLE-INIT Alpha 1 BN100 BN70.1
Middle Initial Contains the middle initial of the
COBRA participant or retiree.
PAR-EMPLOYEE Numeric 9 BN100 BN70.1
Employee Contains the employee's number. The
number correlates all information about
the employee.
PAR-DEPENDENT Numeric 4 BN70.1
Dependent Number If the participant is a dependent, this
field contains the dependent number.
PAR-ADDR1 Alpha 30 (Lower Case) BN100 BN70.1
Address 1 Contains the first line of address
information.
PAR-ADDR2 Alpha 30 (Lower Case) BN100 BN70.1
Address 2 Contains the second line of address
information.
PAR-ADDR3 Alpha 30 (Lower Case) BN70.1
Address 3 Contains the third line of address
information.
PAR-ADDR4 Alpha 30 (Lower Case) BN70.1
Address 4 Contains the fourth line of address
information.
PAR-CITY Alpha 18 (Lower Case) BN100 BN70.1
City Contains the city of the address.
PAR-STATE Alpha 2 BN100 BN70.1
State or Province Contains the state of the address.
PAR-ZIP Alpha 10 BN100 BN70.1
Postal Code Contains the postal code of the address.
PAR-HM-PHONE-CNTRY Alpha 6 BN100 BN70.1
Hm Phone Cntry Contains the prefix of the home
telephone number.
PAR-HM-PHONE-NBR Alpha 15 BN100 BN70.1
Hm Phone Nbr Contains the telephone number.
PAR-BIRTHDATE Numeric 8 (yyyymmdd) BN100 BN70.1
Date of Birth Contains the birthdate of the
participant.
PAR-SEX Alpha 1 BN100 BN70.1
Gender Contains the gender of the COBRA
participant.
M = Male
F = Female
PAR-SMOKER Alpha 1 BN100 BN70.1
Smoker Indicates whether the COBRA participant
is a smoker.
Y = Yes
N = No
" "
PAR-OCCUR-TYPE Alpha 2 BN100 BN70.1
Type of First Contains the first occurrence.
Occurrence
PAR-OCCUR-DATE Numeric 8 (yyyymmdd) BN100 BN70.1
Date of First Contains the date of the first
Occurrence occurrence.
PAR-OCCUR-TYPE2 Alpha 2 BN70.2
Type of Second Contains the second occurrence.
Occurrence
PAR-OCCUR-DATE2 Numeric 8 (yyyymmdd) BN70.2
Date of Second Contains the date of the second
Occurrence occurrence.
PAR-EVENT-DATE Numeric 8 (yyyymmdd) BN70.1
Date of First Cobra Contains the date the individual
Event notified the company of the first
occurrence.
PAR-EVENT-DATE2 Numeric 8 (yyyymmdd)
Date of Second Contains the date the individual
Cobra Event notified the company of the second
occurrence.
PAR-RIGHTS-DATE Numeric 8 (yyyymmdd) BN171 BN70.2
Notification of Contains the date the company notified
Cobra Rights the individual of his or her COBRA
rights.
PAR-ELECT-DATE Numeric 8 (yyyymmdd) BN70.2
Elect Date Contains the date the COBRA participant
notified the company of his or her
benefit election.
PAR-DELINQ-DATE Numeric 8 (yyyymmdd) BN171 BN70.2
Delinq Date Contains the date the company notified
the COBRA participant of his or her
delinquent payment.
PAR-REFUSE-DATE Numeric 8 (yyyymmdd) BN70.2
Refusal of Coverage Contains the date the individual
Date declined COBRA benefit coverage.
PAR-CANCEL-DATE Numeric 8 (yyyymmdd) BN170 BN70.2
Cancel Date Contains the date the COBRA
participant's benefits were canceled.
PAR-DIF-PLN-DATE Numeric 8 (yyyymmdd) BN70.2
Different Ins Contains the date the COBRA
Coverage Date participant's coverage began in another
plan.
PAR-MEDIC-DATE Numeric 8 (yyyymmdd) BN70.2
Date Medicare Begins Contains the date that Medicare begins.
PAR-DEFLT-DATE Numeric 8 (yyyymmdd) BN175 BN70.2
Cancel for Delinq Contains the cancellation date for
Premium Date premium delinquency.
PAR-TERM-DATE Numeric 8 (yyyymmdd) BN100 BN170
Termination Date Contains the date coverage terminates. BN175 BN70.1
BN70.2
PAR-LAST-CMT-SEQ Numeric 4 BN90.1
Last Comment Contains the sequence number of the
Sequence Number last comment entry.
PAR-LAST-INV-NBR Numeric 4 BN180 BN80.1
Last Invoice Number Contains the last invoice number issued
to the COBRA participant.
PAR-FICA-NBR Alpha 15 BN100 BN70.1
Social Security Contains the COBRA participant's Social
Number Security number.
PAR-SEC-LVL Numeric 1
Sec Lvl
PAR-SEC-LOCATION Alpha 10
Sec Location
PAR-FULL-NAME Derived
Full Name
PAR-LABEL-NAME Derived
Label Name
PAR-LABEL-ADDR Derived
Label Address
PAR-COUNTRY-CODE Alpha 2 BN100 BN70.1
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PAR-CONSENT Alpha 1 BN70.1
Consent N = No
Y = Yes
" " = No
PARTICIPNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PARSET1 COMPANY BN00.1 BN100
PARTICIPNT BN102 BN105
BN170 BN171
BN175 BN180
BN181 BN230
BN233 BN270
BN281 BN285
BN321 BN331
BN430 BN480
BN70.1 BN70.2
BN71.1 BN72.1
BN77.1 BN80.1
BN81.1 BN81.2
BN82.1 BN85.1
BN90.1 HR30.1
PARSET2 COMPANY KeyChange BN270
LAST-NAME
FIRST-NAME
MIDDLE-INIT
PARTICIPNT
PARSET3 COMPANY KeyChange BN100
EMPLOYEE
PARTICIPNT
PARTICIPNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
PAR-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
PAR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (PAR-COUNTRY-CODE != Spaces )
PAR-COUNTRY-CODE -> INT-COUNTRY-CODE
Dependent EMDEPEND Required
When PAR-DEPENDENT != Zeroes
PAR-COMPANY -> EMD-COMPANY
PAR-EMPLOYEE -> EMD-EMPLOYEE
PAR-DEPENDENT -> EMD-SEQ-NBR
Employee EMPLOYEE Required
When PAR-EMPLOYEE != Zeroes
PAR-COMPANY -> EMP-COMPANY
PAR-EMPLOYEE -> EMP-EMPLOYEE
Occur Type OCCURTYPE Required
When PAR-OCCUR-TYPE != Spaces
PAR-COMPANY -> OCC-COMPANY
PAR-OCCUR-TYPE -> OCC-OCCUR-TYPE
Occurtype2 OCCURTYPE Required
When PAR-OCCUR-TYPE2 != Spaces
PAR-COMPANY -> OCC-COMPANY
PAR-OCCUR-TYPE2 -> OCC-OCCUR-TYPE
PARTICIPNT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Correspondence HRCORRESP
PAR-COMPANY -> HCP-COMPANY
"3" -> HCP-REQ-TYPE
PAR-PARTICIPNT -> HCP-ID-NBR
Zeroes -> HCP-DEPENDENT
HCP-SEQ-NBR
Part Benefit PARTBEN Delete Restricted
PAR-COMPANY -> PTB-COMPANY
PAR-PARTICIPNT -> PTB-PARTICIPNT
PTB-EMPLOYEE
PTB-PLAN-TYPE
PTB-PLAN-CODE
PTB-START-DATE
|
