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
Other
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