HCPATIENT

Patient

This is the Patient Information file.

REFERENCED BY
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 PC210 PC530 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 WH32.5 WH33.5 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
ZW130 CX240


UPDATED BY
CX506 PC20.2 PC310 PC520 PC521

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HPT-COMPANY
Element: Company
Numeric 4
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.
CX506 PC20.2
PC520 PC521
HPT-PATIENT-ID
Element: Patient Id
Alpha 12
This uniquely identifies a patient within a company.
CX506 PC20.2
PC520 PC521
HPT-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
This field contains the last name of the patient.
CX240 CX506
PC20.2 PC520
PC521
HPT-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
This field contains the first name of the patient.
CX240 CX506
PC20.2 PC520
PC521
HPT-MIDDLE-INIT
Element: Middle Init
Alpha 1
This field contains the middle initial of the patient.
CX240 CX506
PC20.2 PC520
PC521
HPT-BIRTHDATE
Element: Birthdate
Numeric 8 (yyyymmdd)
This field contains the patient's date of birth.
CX506 PC20.2
PC520 PC521
HPT-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This is the date of the last update to the patient record.
PC20.2 PC520
PC521
HPT-CONTRACT
Element: Contract
Alpha 15
This field contains the contract information for the patient.
PC20.2 PC520
HPT-FICA-NBR
Element: Fica Nbr
Alpha 20
PC521


HCPATIENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HPTSET1 COMPANY
PATIENT-ID
...
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX240 CX30.1
CX300 CX506
PC20.1 PC20.2
PC210 PC310
PC520 PC521
PC530 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
HPTSET2 COMPANY
LAST-NAME
FIRST-NAME
PATIENT-ID
KeyChange


HCPATIENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
HPT-COMPANY->ICC-COMPANY (ICCSET1)


HCPATIENT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Hcpatvisit HCPATVISIT
HPT-COMPANY->HPV-COMPANY
HPT-PATIENT-ID->HPV-PATIENT-ID
  HPV-VISIT-NBR


File created: Thu Jun 09 11:16:49 2016

Home
Contact Us



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