PATIENT_4

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 | INTERPRT_NEEDED_CMT | VARCHAR | No |
Comments regarding the patient's interpreter needs
3 | DENT_COMMENT | VARCHAR | No |
This item stores the comment of the current dental classification
4 | ESRD_G_START_DT | DATETIME | No |
The first date that the acute comorbidity of gastrointestinal bleeding was present during maintenance dialysis treatments for End Stage Renal Disease (ESRD).
5 | ESRD_B_START_DT | DATETIME | No |
The first date that the acute comorbidity of bacterial pneumonia was present during maintenance dialysis treatments for End Stage Renal Disease (ESRD).
6 | ESRD_P_START_DT | DATETIME | No |
The first date that the acute comorbidity of pericarditis was present during maintenance dialysis treatments for End Stage Renal Disease (ESRD).
7 | CMS_OP_ESRD_TRAIN_H | INTEGER | No |
The number of training session that have been performed for a patient's hemodialysis treatment through his/her life time.
8 | CMS_OP_ESRD_TRAIN_P | INTEGER | No |
The number of training session that have been performed for a patient's peritoneal dialysis treatment through his/her life time.
9 | FOH_ID | NUMERIC | No |
This item stores the filing order history ID for the member.
10 | TXP_PAT_YN | VARCHAR | No |
Indicates if the patient is a transplant patient.
May contain organization-specific values: No
Category Entries:
No
Yes
11 | BLIND_YN | VARCHAR | No |
Indicates the patient is blind.
The category values for this column were already listed for column: TXP_PAT_YN
12 | DEAF_YN | VARCHAR | No |
Indicates the patient is deaf.
The category values for this column were already listed for column: TXP_PAT_YN
13 | EMPR_COUNTY_C_NAME | VARCHAR | No |
The category value corresponding to the county in which the patient's employer is located.
May contain organization-specific values: Yes
14 | ALRGY_REV_EPT_CSN | NUMERIC | No |
This column contains the source encounter where allergies were most recently reviewed. If allergies were most recently reviewed outside the context of an encounter, the value is blank.
15 | OCCUPATION_C_NAME | VARCHAR | No |
Category list for the patient's occupation.
May contain organization-specific values: Yes
16 | INDUSTRY_C_NAME | VARCHAR | No |
Category list for the industry in which the patient works.
May contain organization-specific values: Yes
17 | EDUCATION_LEVEL_C_NAME | VARCHAR | No |
The patient's highest level of education achieved.
May contain organization-specific values: Yes
No Entries Defined
18 | LOC_EDUCATION_C_NAME | VARCHAR | No |
Location of the patient's highest level of education.
May contain organization-specific values: Yes
No Entries Defined
19 | PARENT_EDU_LEVEL_C_NAME | VARCHAR | No |
Parent/guardian's highest level of education achieved.
The category values for this column were already listed for column: EDUCATION_LEVEL_C_NAME
20 | PARENT_LOC_EDU_C_NAME | VARCHAR | No |
Location of parent/guardian's highest level of education.
The category values for this column were already listed for column: LOC_EDUCATION_C_NAME
21 | RES_OF_STATE_C_NAME | VARCHAR | No |
The state of residence category ID for the patient.
May contain organization-specific values: Yes
22 | US_CITIZEN_YN | VARCHAR | No |
Indicates whether the patient is a citizen of the USA.
May contain organization-specific values: No
Category Entries:
Yes
No
23 | PERMANENT_RESIDENT_YN | VARCHAR | No |
Indicates whether the patient is a permanent resident of the USA.
The category values for this column were already listed for column: US_CITIZEN_YN
24 | CNTRY_SUBDIV_CODE_C_NAME | VARCHAR | No |
Capture the patient's country subdivision code.
May contain organization-specific values: Yes
No Entries Defined
25 | RACE_COLL_MTHD_C_NAME | VARCHAR | No |
The race and ethnicity collection method category ID for the patient.
May contain organization-specific values: Yes
No Entries Defined
26 | PAT_NO_COMM_PREF_C_NAME | VARCHAR | No |
This column stores why the patient doesn't have a preference for receiving communication related to reminders and follow-up care.
May contain organization-specific values: No
Category Entries:
No Preference
27 | FST_LIVE_BIRTH_AGE | INTEGER | No |
The patient's age at first live birth.
28 | RSH_PREF_C_NAME | VARCHAR | No |
Indicates the patient's explicit research recruitment preference.
May contain organization-specific values: No
Category Entries:
OK to Contact
Do Not Contact
Undecided
29 | RSH_PREF_UTC_DTTM | DATETIME (UTC) | No |
Indicates the instant that the patient last indicated an explicit research recruitment preference.
30 | RSH_PREF_USER_ID | VARCHAR | No |
Indicates the user who last recorded the patient's explicit research recruitment preference.
31 | RSH_PREF_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
32 | EXTERNAL_DEATH_DATE | DATETIME | No |
The patient's date of death as reported by an external organization. This column is typically populated by importing data through the Patient Load utility.
33 | DEATH_DATA_IMPORT_DATE | DATETIME | No |
The date the Patient Load utility populated EXTERNAL_DEATH_DATE for this patient.
34 | DEATH_LOC_C_NAME | VARCHAR | No |
Describes the location where the patient died.
May contain organization-specific values: Yes
35 | INDIGENOUS_STAT_C_NAME | VARCHAR | No |
Indicates whether a patient is considered indigenous.
May contain organization-specific values: Yes
36 | PAT_LIVING_STAT_C_NAME | VARCHAR | No |
This column uses information from the chart to determine if the patient represents a real patient. If considered a patient the column returns whether or not the patient is Alive or Deceased. If the record does not represent a real patient then Not A Patient is returned. Patients with blank and custom statuses in the patient status item EPT 102 are assumed Alive. The logic for Not A Patient is identical to EPT 109 - Valid Patient except that test patients can be considered Alive or Deceased.
May contain organization-specific values: No
Category Entries:
Alive
Deceased
Not A Patient
37 | IS_FETAL_DEMISE_YN | VARCHAR | No |
This column is used to indicate the state of patient's chart due to fetal demise.
The category values for this column were already listed for column: TXP_PAT_YN
38 | ERROR_NEWBORN_YN | VARCHAR | No |
This column is used to indicate that the newborn chart was created in error.
The category values for this column were already listed for column: TXP_PAT_YN
39 | MEDSYNC_IS_PARTICIPANT_YN | VARCHAR | No |
Indicates whether the patient is a participant in the outpatient pharmacy medication synchronization program.
The category values for this column were already listed for column: TXP_PAT_YN
40 | MEDSYNC_RECURRENCE | INTEGER | No |
Stores the number of days that are to be between a patient's medication synchronization refills.
41 | MEDSYNC_REFILLDATE_DATE | DATETIME | No |
Stores a medication synchronization dispense date for the patient.
42 | REFILLMGMT_NOTE_ID | VARCHAR | No |
Stores the ID for a General Use Notes (HNO) record for comments regarding the patient's refill management.
43 | IHS_ENROLLMENT_NUM | VARCHAR | No |
This is the American Indian tribal enrollment ID number for the patient.
44 | IHS_BENEFICIARY_CLASS_C_NAME | VARCHAR | No |
Classification of the type of patient, indicating a category under which an individual can become eligible for Indian Health Services (IHS) benefits.
May contain organization-specific values: Yes
Category Entries:
Indian or Alaskan Native
PHS Field Employees
PHS Commissioned Officer
PHS Commissioned Officer Dependent
BEC Beneficary
Non-Indian (Emergency Case)
VISTA
Other
Military
Retired
Federal Employee (Non-PHS)
Coast Guard
Coast Guard Dependents
American Seamen
Foreign Seamen
Immigration Detainee
National Guard
Non-Indian Elective
NOAA Personnel
NOAA Personnel Dependent
Special Duty
Alaska Handicapped Children's Program Applicants
Military Active Duty Personnel Dependents
Military Retired Personnel Dependents
U.S. Coast Guard Retired Personnel
U.S. Coast Guard Retired Personnel Dependents
U.S. Military Academy Candidates
U.S. PHS Retired Commissioned Officers
U.S. PHS Retired Commissioned Officers Dependents
Non-Indian Dependent
Non-Indian (Fee Charged)
45 | IHS_PRIMARY_TRIBE_C_NAME | VARCHAR | No |
The patient's primary tribe.
May contain organization-specific values: Yes
No Entries Defined
46 | IHS_PRIM_TRIBE_BLOOD_QUANTUM_C_NAME | VARCHAR | No |
This item designates the blood quantum for the patient's primary tribe.
May contain organization-specific values: Yes
Category Entries:
Full
Greater Than or Equal to 1/2 but Less Than Full
Greater Than or Equal to 1/4 but Less Than 1/2
Indian but Less Than 1/4
Non-Indian
Unspecified
Unknown
47 | IHS_COMMUNITY_OF_RESIDENCE_C_NAME | VARCHAR | No |
The patient's community of residence is a subdivision of the state and county in which the patient resides.
May contain organization-specific values: Yes
No Entries Defined
48 | IHS_RESIDENCE_SINCE_DATE | DATETIME | No |
Date when the patient first moved to this community of residence (I EPT 4104).
49 | IHS_SERVICE_ELIGIBILITY_C_NAME | VARCHAR | No |
Specifies the types of services for which this patient is eligible.
May contain organization-specific values: Yes
Category Entries:
CHS & Direct
Direct Only
Ineligible
Pending Verification
50 | GENDER_IDENTITY_C_NAME | VARCHAR | No |
The patient's gender identity.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Not Listed
Choose not to disclose
Nonbinary
Genderqueer
51 | CURRENT_JOB_START_DATE | DATETIME | No |
The date a patient started in her current job.
52 | SEX_ASGN_AT_BIRTH_C_NAME | VARCHAR | No |
Stores the patient's sex assigned at birth.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Not recorded on birth certificate
Choose not to disclose
Uncertain
53 | PREFERENCES_ID | NUMERIC | No |
The ID number of the communication preferences record for the patient.
54 | DEATH_INFO_SOURCE_C_NAME | VARCHAR | No |
Stores the source that provided the information on the patient's death outside of the organization. This item will allow for more tracking on the patients who died outside of the organization, and allow for more accurate data on deceased patients.
May contain organization-specific values: Yes
55 | BLOOD_REQTS_UTC_DTTM | DATETIME (UTC) | No |
Instant the blood special requirements were last edited
56 | BLOOD_REQTS_USER_ID | VARCHAR | No |
Stores the user that set the current special requirements for a patient
57 | BLOOD_REQTS_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
58 | ADDR_CHG_USER_ID | VARCHAR | No |
The user who initiated the linked address changes.
59 | ADDR_CHG_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
60 | ADDR_CHG_INSTANT_DTTM | DATETIME (Local) | No |
The instant that the linked address changes were initiated.
61 | ADDR_CHG_SOURCE | VARCHAR | No |
The source record that initiated the linked address changes.
62 | EDD_BASIS_OB_DT_EVENT_C_NAME | VARCHAR | No |
Basis for the patient's expected date of delivery (EDD). Used to track the dating basis for the patient's EDD when the patient does not have a pregnancy episode.
May contain organization-specific values: Yes
Category Entries:
Other Basis
Last Menstrual Period
Est. Date of Conception
Embryo Transfer
Ultrasound
Uterus Size
Quickening
Fundal Ht. at Umbil.
FHR with Doppler
FHR with Fetoscope
Patient Reported
Alternate EDD Entry
63 | VETERAN_DENTAL_CVG_LEVEL_C_NAME | VARCHAR | No |
Each patient can have up to one dental coverage. The dental coverage denotes how much dental services a veteran can receive prior to being billed. This column is frequently used to link to the ZC_VETERAN_DENTAL_CVG table.
May contain organization-specific values: Yes
No Entries Defined
64 | VETERAN_IS_COMBAT_COVERED_YN | VARCHAR | No |
This column stores a Yes/No value that indicates whether or not a patient is covered for their service in combat.
The category values for this column were already listed for column: TXP_PAT_YN
65 | VETERAN_COMBAT_EXP_DATE | DATETIME | No |
This column stores the expiration date of a patient's combat-level coverage.
66 | VETERAN_PRIORITY_GROUP_C_NAME | VARCHAR | No |
Each patient can have up to one priority group. The priority group is a list of veteran coverage priorities that is maintained by the Department of Veteran Affairs. This column is frequently used to link to the ZC_VETERAN_PRIORITY_GROUP table.
May contain organization-specific values: Yes
No Entries Defined
67 | VETERAN_ENROLLMENT_STATUS_C_NAME | VARCHAR | No |
Each patient can have up to one enrollment status. This denotes whether or not a patient's coverage levels are active or otherwise. This column is frequently used to link to the ZC_VETERAN_ENROLL_STATUS table.
May contain organization-specific values: Yes
Category Entries:
Active
Inactive
Pending
68 | LEGACY_HICN | VARCHAR | No |
Stores the patient's Health Insurance Claim Number (HICN) if one was previously available and we've received their Medicare Beneficiary Number (MBI) (stored in PATIENT.MEDICARE_NUM). This value may be needed to look up members during the transition to MBI.
69 | RSH_PREF_MYPT_ID | VARCHAR | No |
Indicates the MyChart user who last recorded the patient's explicit research recruitment preference.
70 | NEPH_ESRD_START_DT | DATETIME | No |
This item is used to store the date of the patient's first regular chronic dialysis treatment.
71 | NEPH_PCRF_LPL_ID | NUMERIC | No |
This item is used to store the dialysis patient's primary cause of renal failure.
72 | NEPH_2728_VERIFY_YN | VARCHAR | No |
This item stores whether the dialysis patient's form-2728 was verified.
The category values for this column were already listed for column: TXP_PAT_YN