HCPATIENT FILE
Patient
This is the Patient Information file.
REFERENCED BY
PC210 PC530 WH130 WH33.5 WH34.1 WH34.2
WH34.3 WH34.4
UPDATED BY
PC20.2 PC310 PC520 PC521
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HPT-COMPANY Numeric 4 PC20.2 PC520
Company The company number represents an PC521
established company and is entered on
all function codes.
HPT-PATIENT-ID Alpha 12 PC20.2 PC520
Patient ID This uniquely identifies a patient PC521
within a company.
HPT-LAST-NAME Alpha 30 (Lower Case) PC20.2 PC520
Last Name This field contains the last name of PC521
the patient.
HPT-FIRST-NAME Alpha 15 (Lower Case) PC20.2 PC520
First Name This field contains the first name of PC521
the patient.
HPT-MIDDLE-INIT Alpha 1 PC20.2 PC520
Middle Initial This field contains the middle initial PC521
of the patient.
HPT-BIRTHDATE Numeric 8 (yyyymmdd) PC20.2 PC520
Date of Birth This field contains the patient's date PC521
of birth.
HPT-UPDATE-DATE Numeric 8 (yyyymmdd) PC20.2 PC520
Update Date This is the date of the last update to PC521
the patient record.
HPT-CONTRACT Alpha 10 PC20.2 PC520
Contract This field contains the contract
information for the patient.
HPT-FICA-NBR Alpha 15 PC20.2 PC521
Social Security
Number
HCPATIENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HPTSET1 COMPANY PC20.1 PC20.2
PATIENT-ID PC210 PC310
PC520 PC521
PC530 WH130
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
HPTSET2 COMPANY KeyChange
LAST-NAME
FIRST-NAME
PATIENT-ID
HCPATIENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
HPT-COMPANY -> ICC-COMPANY (ICCSET1)
HCPATIENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hcpatvisit HCPATVISIT
HPT-COMPANY -> HPV-COMPANY
HPT-PATIENT-ID -> HPV-PATIENT-ID
HPV-VISIT-NBR
|
