|
|
PARTICIPNT FILE
COBRA Participant
The COBRA Participant file contains information about COBRA participants.
REFERENCED BY
BN00.1 BN101 BN102 BN103 BN105 BN106
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 BN71.1 BN72.1 BN77.1 BN81.1 BN81.2
BN82.1 BN85.1 BS32.1 HR13.2 HR13.3 HR13.4
HR30.1
UPDATED BY
BN100 BN170 BN171 BN175 BN180 BN70.1
BN70.2 BN80.1 BN90.1 PA100 PA52.1 PA52.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAR-COMPANY Numeric 4 BN100 BN70.1
Element: Company Contains the company number. BN70.2 PA100
PA52.1 PA52.5
PAR-PARTICIPNT Numeric 9 BN100 BN70.1
Element: Participant NuContains COBRA participant numbers. BN70.2 PA100
PA52.1 PA52.5
PAR-LAST-NAME Alpha 30 (Lower Case) BN100 BN70.1
Element: Name Contains the last name of the COBRA PA100 PA52.1
participant or retiree. PA52.5
PAR-FIRST-NAME Alpha 15 (Lower Case) BN100 BN70.1
Element: First Name Contains the first name of the COBRA PA100 PA52.1
participant or retiree. PA52.5
PAR-MIDDLE-INIT Alpha 1 BN100 BN70.1
Element: Middle InitialContains the middle initial of the PA100 PA52.1
COBRA participant or retiree. PA52.5
PAR-EMPLOYEE Numeric 9 BN100 BN70.1
Element: Employee Contains the employee's number. The PA100 PA52.1
number correlates all information about PA52.5
the employee.
PAR-DEPENDENT Numeric 4 BN70.1
Element: Dependent NumbIf the participant is a dependent, this
field contains the dependent number.
PAR-ADDR1 Alpha 30 (Lower Case) BN100 BN70.1
Element: Address 1 Contains the first line of address PA100 PA52.1
information. PA52.5
PAR-ADDR2 Alpha 30 (Lower Case) BN100 BN70.1
Element: Address 1 Contains the second line of address PA100 PA52.1
information. PA52.5
PAR-ADDR3 Alpha 30 (Lower Case) BN70.1 PA52.1
Element: Address 1 Contains the third line of address PA52.5
information.
PAR-ADDR4 Alpha 30 (Lower Case) BN70.1 PA52.1
Element: Address 1 Contains the fourth line of address PA52.5
information.
PAR-CITY Alpha 18 (Lower Case) BN100 BN70.1
Element: City Contains the city of the address. PA100 PA52.1
PA52.5
PAR-STATE Alpha 2 BN100 BN70.1
Element: State or ProviContains the state of the address. PA100 PA52.1
PA52.5
PAR-ZIP Alpha 10 BN100 BN70.1
Element: Postal Code Contains the postal code of the address. PA100 PA52.1
PA52.5
PAR-HM-PHONE-CNTRY Alpha 6 BN100 BN70.1
Element: Hm Phone CntryContains the prefix of the home PA100 PA52.1
telephone number. PA52.5
PAR-HM-PHONE-NBR Alpha 15 BN100 BN70.1
Element: Hm Phone Nbr Contains the telephone number. PA100 PA52.1
PA52.5
PAR-BIRTHDATE Numeric 8 (yyyymmdd) BN100 BN70.1
Element: Date Contains the birthdate of the PA100 PA52.1
participant. PA52.5
PAR-SEX Alpha 1 BN100 BN70.1
Element: Gender Contains the gender of the COBRA PA100 PA52.1
participant. PA52.5
M = Male
F = Female
PAR-SMOKER Alpha 1 BN100 BN70.1
Element: Smoker Indicates whether the COBRA participant PA100 PA52.1
is a smoker. PA52.5
Y = Yes
N = No
" "
PAR-OCCUR-TYPE Alpha 2 BN100 BN70.1
Type of First Contains the first occurrence. PA100 PA52.1
Occurrence PA52.5
PAR-OCCUR-DATE Numeric 8 (yyyymmdd) BN100 BN70.1
Date of First Contains the date of the first PA100 PA52.1
Occurrence occurrence. PA52.5
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
Element: 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
Element: 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
Element: 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
Element: Date Medicare 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
Element: Termination DaContains the date coverage terminates. BN175 BN70.1
BN70.2 PA100
PA52.1 PA52.5
PAR-LAST-CMT-SEQ Numeric 4 BN90.1
Element: Sequence NumbeContains the sequence number of the
last comment entry.
PAR-LAST-INV-NBR Numeric 4 BN180 BN80.1
Element: Last Invoice NContains the last invoice number issued
to the COBRA participant.
PAR-FICA-NBR Alpha 15 BN100 BN70.1
Element: Social Number Contains the COBRA participant's Social PA100 PA52.1
Security number. PA52.5
PAR-SEC-LVL Numeric 1
Element: Sec Lvl
PAR-SEC-LOCATION Alpha 10
Element: Sec Location
PAR-FULL-NAME Derived
Element: Full Name
PAR-LABEL-NAME Derived
Element: Label Name
PAR-LABEL-ADDR Derived
Element: Label Address
PAR-COUNTRY-CODE Alpha 2 BN100 BN70.1
Element: Country Code The country code. Required for VAT and PA100 PA52.1
intrastat reporting. Must be defined in PA52.5
IN01.1 (Country Maintenance).
PAR-CONSENT Alpha 1 BN70.1
Element: Consent N = No
Y = Yes
" " = No
PARTICIPNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PARSET1 COMPANY BN00.1 BN100
PARTICIPNT 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 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
|
