PARTICIPNT

COBRA Participant

The COBRA Participant file contains information about COBRA participants.

REFERENCED BY
BN106 BN230 BN233 BN281 BN320 BN321
BN430 BN480 BN53.1 BN81.1 BN81.2 BN82.1
BN85.1 HR30.1 BN00.1 BN181 BN285


UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN170
BN171 BN175 BN180 BN270 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN331 BN531 BN532
BN70.1 BN70.2 BN71.1 BN72.1 BN77.1 BN80.1
BN90.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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAR-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN100 BN70.1
BN70.2 PA100
PA52.1 PA52.5
PAR-PARTICIPNT
Element: Participnt		Numeric 9
Contains COBRA participant numbers.
BN100 BN70.1
BN70.2 PA100
PA52.1 PA52.5
PAR-LAST-NAME
Element: Last Name		Alpha 30 (Lower Case)
Contains the last name of the COBRA participant or retiree.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-FIRST-NAME
Element: First Name		Alpha 15 (Lower Case)
Contains the first name of the COBRA participant or retiree.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-MIDDLE-INIT
Element: Middle Init		Alpha 1
Contains the middle initial of the COBRA participant or retiree.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee's number. The number correlates all information about the employee.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-DEPENDENT
Element: Dependent		Numeric 4
If the participant is a dependent, this field contains the dependent number.
BN70.1
PAR-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
Contains the first line of address information.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
Contains the second line of address information.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
Contains the third line of address information.
BN70.1 PA52.1
PA52.5
PAR-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
Contains the fourth line of address information.
BN70.1 PA52.1
PA52.5
PAR-CITY
Element: City		Alpha 18 (Lower Case)
Contains the city of the address.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-STATE
Element: State		Alpha 2
Contains the state of the address.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-ZIP
Element: Zip		Alpha 10
Contains the postal code of the address.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-HM-PHONE-CNTRY
Element: Hm Phone Cntry		Alpha 6
Contains the prefix of the home telephone number.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-HM-PHONE-NBR
Element: Hm Phone Nbr		Alpha 15
Contains the telephone number.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-BIRTHDATE
Element: Birthdate		Numeric 8 (yyyymmdd)
Contains the birthdate of the participant.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-SEX
Element: Sex		Alpha 1
Contains the gender of the COBRA participant.
M = Male
F = Female
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-SMOKER
Element: Smoker		Alpha 1
Indicates whether the COBRA participant is a smoker.
Y = Yes
N = No
" "
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-OCCUR-TYPE
Element: Occur Type		Alpha 2
Contains the first occurrence.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-OCCUR-DATE
Element: Occur Date		Numeric 8 (yyyymmdd)
Contains the date of the first occurrence.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-OCCUR-TYPE2
Element: Occur Type2		Alpha 2
Contains the second occurrence.
BN70.2
PAR-OCCUR-DATE2
Element: Occur Date2		Numeric 8 (yyyymmdd)
Contains the date of the second occurrence.
BN70.2
PAR-EVENT-DATE
Element: Event Date		Numeric 8 (yyyymmdd)
Contains the date the individual notified the company of the first occurrence.
BN70.1
PAR-EVENT-DATE2
Element: Event Date2		Numeric 8 (yyyymmdd)
Contains the date the individual notified the company of the second occurrence.
PAR-RIGHTS-DATE
Element: Rights Date		Numeric 8 (yyyymmdd)
Contains the date the company notified the individual of his or her COBRA rights.
BN171 BN70.2
PAR-ELECT-DATE
Element: Elect Date		Numeric 8 (yyyymmdd)
Contains the date the COBRA participant notified the company of his or her benefit election.
BN70.2
PAR-DELINQ-DATE
Element: Delinq Date		Numeric 8 (yyyymmdd)
Contains the date the company notified the COBRA participant of his or her delinquent payment.
BN171 BN70.2
PAR-REFUSE-DATE
Element: Refuse Date		Numeric 8 (yyyymmdd)
Contains the date the individual declined COBRA benefit coverage.
BN70.2
PAR-CANCEL-DATE
Element: Cancel Date		Numeric 8 (yyyymmdd)
Contains the date the COBRA participant's benefits were canceled.
BN170 BN70.2
PAR-DIF-PLN-DATE
Element: Dif Pln Date		Numeric 8 (yyyymmdd)
Contains the date the COBRA participant's coverage began in another plan.
BN70.2
PAR-MEDIC-DATE
Element: Medic Date		Numeric 8 (yyyymmdd)
Contains the date that Medicare begins.
BN70.2
PAR-DEFLT-DATE
Element: Deflt Date		Numeric 8 (yyyymmdd)
Contains the cancellation date for premium delinquency.
BN175 BN70.2
PAR-TERM-DATE
Element: Term Date		Numeric 8 (yyyymmdd)
Contains the date coverage terminates.
BN100 BN170
BN175 BN70.1
BN70.2 PA100
PA52.1 PA52.5
PAR-LAST-CMT-SEQ
Element: Last Cmt Seq		Numeric 4
Contains the sequence number of the last comment entry.
BN90.1
PAR-LAST-INV-NBR
Element: Last Inv Nbr		Numeric 4
Contains the last invoice number issued to the COBRA participant.
BN180 BN80.1
PAR-FICA-NBR
Element: Social Number		Alpha 20
Contains the COBRA participant's Social Security number.
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-SEC-LVL
Element: Sec Lvl		Numeric 1
PAR-SEC-LOCATION
Element: Sec Location		Alpha 10
PAR-FULL-NAME
Element: Full Name		Derived
PAR-LABEL-NAME
Element: Label Name		Derived
PAR-LABEL-ADDR
Element: Label Addr		Derived
PAR-COUNTRY-CODE
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
BN100 BN70.1
PA100 PA52.1
PA52.5
PAR-CONSENT
Element: Consent		Alpha 1

N = No
Y = Yes
" " = No
BN70.1
PAR-MEDICARE-IND
Element: Medicare Ind		Alpha 1

A = Medicare Part A
B = Medicare Part B
C = Medicare Part A and B
D = Medicare Part Unknown
E = No Medicare
BN70.1
PAR-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN100 BN70.1
PAR-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN100 BN70.1
PAR-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN100 BN70.1
PAR-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN100 BN70.1
BN70.2
PAR-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN100 BN70.1
BN70.2
PAR-USER-ID
Element: User Id		Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN100 BN70.1
BN70.2


PARTICIPNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PARSET1 COMPANY
PARTICIPNT
...
BN00.1 BN100
BN101 BN102
BN103 BN105
BN106 BN170
BN171 BN175
BN180 BN181
BN230 BN233
BN270 BN281
BN285 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN321
BN331 BN430
BN480 BN53.1
BN531 BN532
PARSET2 COMPANY
LAST-NAME
FIRST-NAME
MIDDLE-INIT
PARTICIPNT
KeyChange
BN270
PARSET3 COMPANY
EMPLOYEE
PARTICIPNT
KeyChange
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN532
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
PA218


PARTICIPNT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

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

Home
Contact Us



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