|
HCPATIENT FILE
Patient
This is the Patient Information file.
REFERENCED BY
BL92.1 WH130 WH132 WH190 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH33.5
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HPT-COMPANY Numeric 4
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
HPT-PATIENT-ID Alpha 12
Element: Patient Id This uniquely identifies a patient
within a company.
HPT-LAST-NAME Alpha 30 (Lower Case)
Element: Last Name This field contains the last name of
the patient.
HPT-FIRST-NAME Alpha 15 (Lower Case)
Element: First Name This field contains the first name of
the patient.
HPT-MIDDLE-INIT Alpha 1
Element: Middle Init This field contains the middle initial
of the patient.
HPT-BIRTHDATE Numeric 8 (yyyymmdd)
Element: Birthdate This field contains the patient's date
of birth.
HPT-UPDATE-DATE Numeric 8 (yyyymmdd)
Element: Update Date This is the date of the last update to
the patient record.
HPT-CONTRACT Alpha 15
Element: Contract This field contains the contract
information for the patient.
HPT-FICA-NBR Alpha 20
Element: Fica Nbr
HCPATIENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HPTSET1 COMPANY BL92.1 WH130
PATIENT-ID WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
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
|