PATIENT_5
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 PHYSICAL_IMPAIRED_C_NAME VARCHAR No
The Physically Impaired? category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
No
Yes
3 MEMORY_IMPAIRED_C_NAME VARCHAR No
The Memory Impaired? category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
No
Yes
4 SPEECH_IMPAIRED_C_NAME VARCHAR No
The Speech Impaired? category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
No
Yes
5 DISABLED_VETERAN_C_NAME VARCHAR No
The Disabled Veteran? category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
No
Yes
6 VA_RECOGNIZED_C_NAME VARCHAR No
The VA Recognized? category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
No
Yes
7 HEARING_IMPAIRED_C_NAME VARCHAR No
The Hard of Hearing? category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
No
Yes
8 VISUALLY_IMPAIRED_C_NAME VARCHAR No
The Low Vision? category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
No
Yes
9 DIFFICULTY_DRESS_BATHE_C_NAME VARCHAR No
The Difficulty Dressing or Bathing? category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
No
Yes
10 DIFFICULTY_WITH_ERRAND_C_NAME VARCHAR No
The Difficulty with Errands? category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
No
Yes
11 SC_PERM_FORM_OF_RES_C_NAME VARCHAR No
The social care client's permanent form of residence.
May contain organization-specific values: Yes
No Entries Defined
12 SC_GROUNDS_FOR_RES_PERM_C_NAME VARCHAR No
Reason why the social care client is able to hold a residence permit.
May contain organization-specific values: Yes
No Entries Defined
13 SC_RES_PERMIT_VALID_TO_DATE DATETIME No
Date the social care client's residence permit is valid to.
14 SC_TYPE_OF_RELATIONSHIP_C_NAME VARCHAR No
Further specify marriage details for the social care client.
May contain organization-specific values: Yes
No Entries Defined
15 SOCIAL_CARE_PASSPORT_TYPE_C_NAME VARCHAR No
The passport type.
May contain organization-specific values: Yes
No Entries Defined
16 SOCIAL_CARE_PASSPORT_EXP_DATE DATETIME No
Date passport expires.
17 RSH_PREFS_ANSWER_ID VARCHAR No
The unique ID of the questionnaire answers of the patient's most recent research preference questionnaire submission.
18 RX_AUTO_REFILL_DELIV_MTHD_C_NAME VARCHAR No
The delivery method to use for refills initiated via auto refill. If not set, the default delivery method is used.
May contain organization-specific values: Yes
Category Entries:
Pickup
Mail
Courier
Room Delivery
19 PAT_PHOTO VARCHAR No
This stores the file name of the current patient photo.
20 PEND_PAT_PHOTO VARCHAR No
This stores the file name of a photo pending approval to be added to the chart. It has most likely been submitted by the patient via Welcome or MyChart.
21 TYPE_AND_SCR_ELIG_YN VARCHAR No
This stores whether or not the patient is eligible for a type and screen.
May contain organization-specific values: No
Category Entries:
No
Yes
22 NEPH_PCRF_DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
23 CONSENT_ABILITY_YN VARCHAR No
If the patient is able to consent or not. Leaving this item blank will be treated as an answer of "Unknown."
The category values for this column were already listed for column: TYPE_AND_SCR_ELIG_YN
24 SCHOOL_DISTRICT_NUM VARCHAR No
School district number.
25 MIGRATION_TYPE_C_NAME VARCHAR No
The migrant type: either emigrant or immigrant.
May contain organization-specific values: Yes
Category Entries:
Emigrant
Immigrant
26 MIGRANT_COUNTRY_C_NAME VARCHAR No
If the patient is a migrant, this is the country which the patient is immigrating from or emigrating to.
May contain organization-specific values: Yes
27 CONGREGATE_CARE_RESIDENT_YN VARCHAR No
Denotes whether a patient is a resident of a congregate care setting such as a group home, residential treatment facility, or maternity home.
The category values for this column were already listed for column: TYPE_AND_SCR_ELIG_YN
28 SEEN_DOMESTIC_TRAVEL_ALERT_YN VARCHAR No
Indicates whether the patient has seen the alert in MyChart or Welcome warning them that they can now enter trips that they've taken inside of the United States.
The category values for this column were already listed for column: TYPE_AND_SCR_ELIG_YN
29 KI_SELF_GUAR_ACCT_VERIF_DATE DATETIME No
This item indicates the most recent date the patient verified whether the self-guarantor billing information is correct in Welcome.
30 KI_SELF_GUAR_ACCT_VERIF_STS_C_NAME VARCHAR No
This item indicates the most recent answer a patient selected when prompted to verify whether the self-guarantor billing information is correct in Welcome.
May contain organization-specific values: No
Category Entries:
Kiosk - Needs Review
Kiosk - Verified
31 PAT_PHONETIC_NAME VARCHAR No
Stores the phonetic spelling of the patient's name.
32 PAT_RETIREMENT_DATE DATETIME No
The date of a patient's retirement for MSPQ purposes.
33 SPOUSE_RETIREMENT_DATE DATETIME No
The date of a patient's spouse's retirement for MSPQ purposes.
34 DRIVERS_LICENSE_NUM VARCHAR No
The patient's driver's license number.
35 DRIVERS_LICENSE_STATE_C_NAME VARCHAR No
The state category ID for the patient's driver's license.
May contain organization-specific values: Yes
36 EMPLOYMENT_HIRE_DATE DATETIME No
The date that a patient was hired at their employer.
37 EMPLOYER_FAX VARCHAR No
the fax number of the patient's employer.
38 WORK_PHONE VARCHAR No
The patient's work phone number.
39 H1B_WORK_VISA_YN VARCHAR No
Indicates whether the patient has an H1B work visa.
May contain organization-specific values: No
Category Entries:
Yes
No
40 STUDENT_VISA_YN VARCHAR No
Indicates whether the patient has a student visa.
The category values for this column were already listed for column: H1B_WORK_VISA_YN
41 BIRTH_COUNTY_C_NAME VARCHAR No
The county category ID for where the patient was born.
May contain organization-specific values: Yes
42 CORRESP_CONTACT VARCHAR No
This name of the contact person associated with a patient's correspondence address.
43 CUR_INP_SUMMARY_BLOCK_ID NUMERIC No
The current Inpatient summary block ID.
44 PREFERRED_FORM_ADDRESS VARCHAR No
How the patient prefers to be addressed.
45 PAT_ACADEMIC_DEGREE_C_NAME VARCHAR No
Stores the academic degree of the patient as it would appear with the patient's name. For example, James Smith, PhD.
May contain organization-specific values: Yes
Category Entries:
PhD
MD
Esq.
DDS
DD
RN
LPN
PA
JD
Dr.
46 PREFERRED_NAME_TYPE_C_NAME VARCHAR No
Stores the type for the patient's preferred name.
May contain organization-specific values: Yes
Category Entries:
First Name, Preferred
Complete Name, Preferred
47 AHCIC_NUM VARCHAR No
The patient's AHCIC number.