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
Complete Name
47 | AHCIC_NUM | VARCHAR | No |
The patient's AHCIC number.