PATIENT_2
Description:
This table supplements the PATIENT table. It contains basic information about patients.

Primary Key
Column Name Ordinal Position
PAT_ID 1

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 RECORD_TYPE_6_C_NAME VARCHAR No
The type of patient (EPT) record that this row relates to.
May contain organization-specific values: No
Category Entries:
Patient
Responsible Party
3 BIRTH_TM DATETIME (Local) No
The date and time of the patient's birth in 24 hour format.
4 DEATH_TM DATETIME (Local) No
The date and time of the patient's death in 24 hour format.
5 FAX VARCHAR No
The patient's fax number.
6 CITIZENSHIP_C_NAME VARCHAR No
The patient's citizenship status information.
May contain organization-specific values: Yes
No Entries Defined
7 MED_HX_NOTE_ID VARCHAR No
This column contains a link to the General Use Notes (HNO) meds history note for this patient.
8 IS_ADOPTED_YN VARCHAR No
Capture if patient is adopted or not.
May contain organization-specific values: No
Category Entries:
Yes
No
9 BIRTH_HOSPITAL VARCHAR No
Capture the name of the hospital where the patient was born or first seen after a non-hospital birth.
10 ALRGY_UPD_INST DATETIME (Attached) No
The PATIENT table extracts the last date on which the patient's allergy information was verified. For more granularity, this table extracts the instant (date and time) that this information was verified.
11 BIRTH_CITY VARCHAR No
The patient's city of birth.
12 BIRTH_ST_C_NAME VARCHAR No
The patient's state of birth.
May contain organization-specific values: Yes
13 SCHOOL_C_NAME VARCHAR No
School that the patient attends.
May contain organization-specific values: Yes
No Entries Defined
14 REFERRAL_SOURCE_ID VARCHAR No
The unique ID of the provider or other source that referred the patient to the facility. This is distinct from the encounter-specific referral source in PAT_ENC.
15 REFERRAL_SOURCE_ID_REFERRING_PROV_NAM VARCHAR No
The name of the referral source.
16 PAT_NAME_RECORD_ID VARCHAR No
The networked item that points to the patient's name record (EAN).
17 COMM_METHOD_C_ZC_COMM_METHOD_NAME VARCHAR No
Column to hold the category value of Preferred Communication Method (I EPT 89) for the Patient_2 table.
May contain organization-specific values: Yes
18 FOSTER_CHILD_YN VARCHAR No
Indicates whether the patient is a foster child.
The category values for this column were already listed for column: IS_ADOPTED_YN
19 CONF_PAT_REAL_NAME VARCHAR No
The real name of a confidential patient.
20 PAT_CONF_NM_REC_ID VARCHAR No
The networked item pointing to the name record for the patient's confidential name.
21 ACTIVE_IER_ID VARCHAR No
Link to active Identity History (IER) record for this patient.
22 OTH_CITY VARCHAR No
Contains the city for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
23 OTH_ZIP VARCHAR No
Contains the zip code for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
24 OTH_PHONE VARCHAR No
Contains the phone number for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
25 OTH_EMAIL VARCHAR No
Contains the email for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
26 OTH_CONTACT_PERSON VARCHAR No
Contains the contact person for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
27 OTH_HOUSE_NUMBER VARCHAR No
Contains the house number for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
28 OTH_DISTRICT_C_NAME VARCHAR No
Contains the district for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
May contain organization-specific values: Yes
29 OTH_COUNTY_C_NAME VARCHAR No
Contains the county for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
May contain organization-specific values: Yes
30 OTH_COUNTRY_C_NAME VARCHAR No
Contains the country for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
May contain organization-specific values: Yes
31 OTH_START_DATE DATETIME No
Contains the start date for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
32 OTH_END_DATE DATETIME No
Contains the end date for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
33 DEF_ADDRESS_C_NAME VARCHAR No
Stores the address that will be used by default by the pharmacy when determining where to mail prescriptions. This can be home, temporary, or prescription.
May contain organization-specific values: No
Category Entries:
Home Address
Temporary Address
Other Address
Single-Use Address
34 OTH_STATE_C_NAME VARCHAR No
Contains the state for the patient's prescription address, which can be used by pharmacy to determine where to mail prescriptions.
The category values for this column were already listed for column: BIRTH_ST_C_NAME
35 MAIDEN_NAME VARCHAR No
The patient's maiden name.
36 EMPR_CITY VARCHAR No
The city of the patient's employer.
37 EMPR_STATE_C_NAME VARCHAR No
The category number for the state of the patient's employer.
The category values for this column were already listed for column: BIRTH_ST_C_NAME
38 EMPR_ZIP VARCHAR No
The ZIP code of the patient's employer.
39 EMPR_COUNTRY_C_NAME VARCHAR No
The category number for the country of the patient's employer.
The category values for this column were already listed for column: OTH_COUNTRY_C_NAME
40 EMPR_PHONE VARCHAR No
The phone number of the patient's employer.
41 BILL_INSTRUCT_C_NAME VARCHAR No
The category number for the Billing Instruction Code for the patient.
May contain organization-specific values: Yes
No Entries Defined
42 PAT_ASSIST_C_NAME VARCHAR No
The category number for the Patient Assistance Code.
May contain organization-specific values: Yes
No Entries Defined
43 BILL_COMMENT VARCHAR No
General comments regarding patient billing instruction
44 CHART_ABSTD_YN VARCHAR No
Indicates whether the chart was abstracted.
May contain organization-specific values: No
Category Entries:
Yes
No
45 MOTHER_HEIGHT NUMERIC No
Height of the patient's mother. This is used for calculations in the Growth Charts activity.
46 FATHER_HEIGHT NUMERIC No
Height of the patient's father. This is used for calculations in the Growth Charts activity.
47 PAT_VERIFICATION_ID NUMERIC No
Verification record for this patient
48 ALRGY_REV_STAT_C_NAME VARCHAR No
This item stores the status of the review of allergies.
May contain organization-specific values: Yes
Category Entries:
Not Used
Mark as Reviewed
Verified
Viewed Only
Fully Reviewed
Partially Reviewed
Unable to Assess
49 ALRGY_REV_CMT VARCHAR No
This item stores a comment associated with the review of allergies.
50 REVERSE_NATL_ID VARCHAR No
Used to store reverse National Identifier in an indexed item for patient search of partial National Identifier.
51 ADV_DIR_REV_DT DATETIME No
The date on which a user last reviewed the patient's advanced directive.
52 ADV_DIR_REV_USER_ID VARCHAR No
The user who last reviewed the patient's advanced directive.
53 ADV_DIR_REV_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
54 LIVING_ARRANGE_C_NAME VARCHAR No
The patient's living arrangement.
May contain organization-specific values: Yes
55 PED_COMMENT VARCHAR No
Free-text pediatric comments.