|
|
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.1 HR13.2 HR13.3
HR13.4 HR30.1 HR513 PA218
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 Hr Contains the company number. BN70.2 PA100
PA52.1 PA52.5
PAR-PARTICIPNT Numeric 9 BN100 BN70.1
Element: Participnt Contains COBRA participant numbers. BN70.2 PA100
PA52.1 PA52.5
PAR-LAST-NAME Alpha 30 (Lower Case) BN100 BN70.1
Element: Last 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 Init Contains 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 If the participant is a dependent, this
field contains the dependent number.
PAR-ADDR1 Alpha 30 (Lower Case) BN100 BN70.1
Element: Addr1 Contains the first line of address PA100 PA52.1
information. PA52.5
PAR-ADDR2 Alpha 30 (Lower Case) BN100 BN70.1
Element: Addr1 Contains the second line of address PA100 PA52.1
information. PA52.5
PAR-ADDR3 Alpha 30 (Lower Case) BN70.1 PA52.1
Element: Addr1 Contains the third line of address PA52.5
information.
PAR-ADDR4 Alpha 30 (Lower Case) BN70.1 PA52.1
Element: Addr1 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 Contains the state of the address. PA100 PA52.1
PA52.5
PAR-ZIP Alpha 10 BN100 BN70.1
Element: Zip 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: Birthdate Contains the birthdate of the PA100 PA52.1
participant. PA52.5
PAR-SEX Alpha 1 BN100 BN70.1
Element: Sex 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
Element: Occur Type Contains the first occurrence. PA100 PA52.1
PA52.5
PAR-OCCUR-DATE Numeric 8 (yyyymmdd) BN100 BN70.1
Element: Occur Date Contains the date of the first PA100 PA52.1
occurrence. PA52.5
PAR-OCCUR-TYPE2 Alpha 2 BN70.2
Element: Occur Type2 Contains the second occurrence.
PAR-OCCUR-DATE2 Numeric 8 (yyyymmdd) BN70.2
Element: Occur Date2 Contains the date of the second
occurrence.
PAR-EVENT-DATE Numeric 8 (yyyymmdd) BN70.1
Element: Event Date Contains the date the individual
notified the company of the first
occurrence.
PAR-EVENT-DATE2 Numeric 8 (yyyymmdd)
Element: Event Date2 Contains the date the individual
notified the company of the second
occurrence.
PAR-RIGHTS-DATE Numeric 8 (yyyymmdd) BN171 BN70.2
Element: Rights Date Contains the date the company notified
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
Element: Refuse Date Contains the date the individual
declined COBRA benefit coverage.
PAR-CANCEL-DATE Numeric 8 (yyyymmdd) BN170 BN70.2
Element: Cancel Date Contains the date the COBRA
participant's benefits were canceled.
PAR-DIF-PLN-DATE Numeric 8 (yyyymmdd) BN70.2
Element: Dif Pln Date Contains the date the COBRA
participant's coverage began in another
plan.
PAR-MEDIC-DATE Numeric 8 (yyyymmdd) BN70.2
Element: Medic Date Contains the date that Medicare begins.
PAR-DEFLT-DATE Numeric 8 (yyyymmdd) BN175 BN70.2
Element: Deflt Date Contains the cancellation date for
premium delinquency.
PAR-TERM-DATE Numeric 8 (yyyymmdd) BN100 BN170
Element: Term Date Contains the date coverage terminates. BN175 BN70.1
BN70.2 PA100
PA52.1 PA52.5
PAR-LAST-CMT-SEQ Numeric 4 BN90.1
Element: Last Cmt Seq Contains the sequence number of the
last comment entry.
PAR-LAST-INV-NBR Numeric 4 BN180 BN80.1
Element: Last Inv Nbr Contains the last invoice number issued
to the COBRA participant.
PAR-FICA-NBR Alpha 20 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 Addr
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
PAR-MEDICARE-IND Alpha 1 BN70.1
Element: Medicare Ind A = Medicare Part A
B = Medicare Part B
C = Medicare Part A and B
D = Medicare Part Unknown
E = No Medicare
PAR-CREATE-DATE Numeric 8 (yyyymmdd)
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PAR-CREATE-TIME Numeric 6 (hhmmss)
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PAR-CREATE-USER-ID Alpha 10 (Lower Case)
Element: User Id Contains the user ID of the person who
last changed this record.
PAR-DATE-STAMP Numeric 8 (yyyymmdd)
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PAR-TIME-STAMP Numeric 6 (hhmmss)
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PAR-USER-ID Alpha 10 (Lower Case)
Element: User Id Contains the user ID of the person who
last changed this record.
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 BN101
EMPLOYEE BN102 BN103
PARTICIPNT BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218
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
|
