PATIENT
Description:
The PATIENT table contains one record for each patient in your system. The data contained in each record consists of demographics, PCP and primary location information, registration information, and other information.

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 by other tables to link to PATIENT.
2 PAT_NAME VARCHAR No
The patient’s name in the format Lastname, Firstname MI.
3 CITY VARCHAR No
The city in which the patient lives.
4 STATE_C_NAME VARCHAR No
The category value corresponding to the state in which the patient lives.
May contain organization-specific values: Yes
5 COUNTY_C_NAME VARCHAR No
The category value corresponding to the county in which the patient lives.
May contain organization-specific values: Yes
6 COUNTRY_C_NAME VARCHAR No
The category value corresponding to the country in which the patient lives.
May contain organization-specific values: Yes
7 ZIP VARCHAR No
The ZIP Code area in which the patient lives.
8 HOME_PHONE VARCHAR No
The patient’s home phone number.
9 WORK_PHONE VARCHAR No
The patient’s work phone number.
10 EMAIL_ADDRESS VARCHAR No
The patient’s e-mail address.
11 BIRTH_DATE DATETIME (Local) No
The date on which the patient was born.
12 ETHNIC_GROUP_C_NAME VARCHAR No
The category value associated with the patient’s ethnic background.
May contain organization-specific values: Yes
13 RELIGION_C_NAME VARCHAR No
The category value associated with the patient’s religion.
May contain organization-specific values: Yes
14 LANGUAGE_C_NAME VARCHAR No
The category value associated with the patient’s language.
May contain organization-specific values: Yes
15 SSN VARCHAR No
The patient’s Social Security Number. This number is formatted as 999-99-9999, and a single trailing alphabetic character is also allowed.
16 REG_DATE DATETIME No
The date on which the last patient verification occurred. If a patient was verified and then re-verified at a later date, this column will show the re-verified date. This column will be null for patients that have never been verified.
17 REG_STATUS_C_NAME VARCHAR No
The category value associated with the patient’s status in terms of the patient registration process as of the enterprise reporting extract. This is a customizable list, examples may include: 1 – New, 2 – Verified, and so on.
May contain organization-specific values: Yes
18 MEDICARE_NUM VARCHAR No
The patient’s Medicare-assigned identification number, if applicable.
19 MEDICAID_NUM VARCHAR No
Patient's Medicaid ID.
20 ADV_DIRECTIVE_YN VARCHAR No
This column contains the value “Y” if the patient has a signed living will on file with your facility indicating how they want their health chare to be handled in the event of an incapacitating emergency. This information is entered in clinical system. If the patient has no signed living will on file this column contains the value “N”.
May contain organization-specific values: No
Category Entries:
Yes
No
21 ADV_DIRECTIVE_DATE DATETIME No
The date a living will was received from the patient.
22 CUR_PCP_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
23 CUR_PRIM_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
24 LEGAL_STATUS_C_NAME VARCHAR No
The medical and/or legal status associated with the patient’s death. This item is populated through Admission/Discharge/Transfer (ADT) workflows.
May contain organization-specific values: Yes
No Entries Defined
25 BIRTH_STATUS_C_NAME VARCHAR No
The category value associated with the newborn’s status at birth as entered in ADT.
May contain organization-specific values: Yes
No Entries Defined
26 PED_MULT_BIRTH_ORD INTEGER No
For multiple births, the place in the birth order of the current newborn patient.
27 PED_MULT_BIRTH_TOT INTEGER No
The total number of births during the mother’s labor and delivery of this newborn patient.
28 CREATE_USER_ID VARCHAR No
The unique ID of the system user who entered this patient’s record. This ID may be encrypted.
29 CREATE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
30 PAT_MRN_ID VARCHAR No
The patient's medical record number (MRN), of the type associated with the patient's current primary location.
31 DEATH_DATE DATETIME (Local) No
The date of death for the patient.
32 REC_CREATE_PAT_ID VARCHAR No
The unique ID of the system user who created this patient’s record. This ID may be encrypted. NOTE: For historical reasons, the column name ends in PAT_ID and cannot be changed; despite its name, it does not link to patient ID. It instead links to CLARITY_EMP.USER_ID.
33 REC_CREATE_PAT_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
34 ORGAN_DONOR_YN VARCHAR No
Indicates if the patient is an organ donor.
May contain organization-specific values: No
Category Entries:
Yes
No
35 TMP_CITY VARCHAR No
Contains the city in which the patient is temporarily residing.
36 TMP_STATE_C_NAME VARCHAR No
Contains the state in which the patient is temporarily residing.
The category values for this column were already listed for column: STATE_C_NAME
37 TMP_COUNTRY_C_NAME VARCHAR No
Contains the country in which the patient is temporarily residing.
The category values for this column were already listed for column: COUNTRY_C_NAME
38 TMP_ZIP VARCHAR No
Contains the ZIP Code in which the patient is temporarily residing.
39 TMP_HOME_PHONE VARCHAR No
Contains the temporary phone number where the patient can be reached.
40 TMP_COUNTY_C_NAME VARCHAR No
Contains the county in which the patient is temporarily residing.
The category values for this column were already listed for column: COUNTY_C_NAME
41 TMP_ADDR_START_DT DATETIME No
Contains the starting effective date of the patients temporary address information.
42 TMP_ADDR_END_DT DATETIME No
Contains the ending effective date of the patients temporary address information.
43 TMP_CARE_OF_PERSON VARCHAR No
Contains the name of the contact person for the patient at the temporary residence.
44 PAT_LAST_NAME VARCHAR No
The last name of the patient.
45 PAT_FIRST_NAME VARCHAR No
The first name of the patient.
46 PAT_MIDDLE_NAME VARCHAR No
The middle name of the patient.
47 PAT_TITLE_C_NAME VARCHAR No
The patient's title, e.g. Mr., Mrs., Miss, Dr., etc.
May contain organization-specific values: Yes
Category Entries:
Ms.
Mr.
Miss
Mrs.
Dr.
Fr.
Sr.
Rev.
Lord
King
Queen
Prince
Princess
Sheikh
Sheikha
48 PAT_NAME_SUFFIX_C_NAME VARCHAR No
The suffix to the patient's name, e.g. Jr., Sr., III, etc.
May contain organization-specific values: Yes
Category Entries:
Sr.
Jr.
II
III
IV
V
49 SPECIAL_STATUS_C_NAME VARCHAR No
The special status of the patient, such as employee or VIP.
May contain organization-specific values: Yes
50 LANG_CARE_C_NAME VARCHAR No
The patient's preferred language to receive care.
The category values for this column were already listed for column: LANGUAGE_C_NAME
51 LANG_WRIT_C_NAME VARCHAR No
The patient's preferred language to receive written material.
The category values for this column were already listed for column: LANGUAGE_C_NAME
52 PROXY_PAT_YN VARCHAR No
Indicates if the patient has a proxy already.
May contain organization-specific values: Yes
Category Entries:
Yes
No
53 PROXY_PACK_YN VARCHAR No
Indicates if the proxy packet was given to the patient.
May contain organization-specific values: Yes
Category Entries:
Yes
No
54 EMPLOYER_ID VARCHAR No
This is the unique ID of the patient's employer if the item linking the patient to an employer (I EAF 6410) is set to 1. This is free text if the item linking the patient to an employer (I EAF 6410) is set to 2.
55 EMPLOYER_ID_EMPLOYER_NAME VARCHAR No
The name of the employer.
56 EMPY_STATUS_C_NAME VARCHAR No
The employee's employment status (e.g. Full Time, Part time, Not Employed, etc.)
May contain organization-specific values: Yes
Category Entries:
Full Time
Part Time
Not Employed
Self Employed
Retired
On Active Military Duty
Student - Full Time
Student - Part Time
Unknown
57 GUARDIAN_NAME VARCHAR No
The name of the patient's legal guardian, if any.
58 PREF_CLIN_ZIP VARCHAR No
The zip code of the patient's preferred clinic.
59 PREF_PCP_SEX_C_NAME VARCHAR No
The category value of the sex of the patient's preferred primary care physician.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
60 PREF_PCP_SPEC_C_NAME VARCHAR No
The category value of the specialty of the patient's preferred physician.
May contain organization-specific values: Yes
61 PREF_PCP_LANG_C_NAME VARCHAR No
The category value of the language of the patient's preferred primary care physician.
The category values for this column were already listed for column: LANGUAGE_C_NAME
62 COUNTRY_OF_ORIG_C_NAME VARCHAR No
Holds data on the country in which a patient was born
The category values for this column were already listed for column: COUNTRY_C_NAME
63 PED_CESAREAN_YN VARCHAR No
This column contains the value "Y" if the patient was delivered by Cesarean Section. If the patient was not delivered by Cesarean Section, this column contains the value "N".
May contain organization-specific values: No
Category Entries:
Yes
No
64 PED_NOUR_METH_C_NAME VARCHAR No
Indicates the patient's pediatric nourishment method.
May contain organization-specific values: Yes
Category Entries:
Breast Fed
Bottle Fed
Unknown
Not Asked
Bottle Fed - Breast Milk
Bottle Fed - Formula
65 PED_DELIVR_METH_C_NAME VARCHAR No
Indicates the patient's delivery method at birth.
May contain organization-specific values: Yes
Category Entries:
Vaginal, Spontaneous
C-Section, Low Transverse
Vertical C-Section
C-Section, Unspecified
Vaginal, Vacuum (Extractor)
Vaginal, Forceps
Vaginal, Breech
Non-Spontaneous Vaginal Delivery
VBAC, Spontaneous
C-Section, Low Vertical
C-Section, Classical
Biochemical
66 PED_MULTI_BIRTH_YN VARCHAR No
This column contains the value "Y" if the patient is one of a multiple birth. This column contains the value "N" if the patient was a single birth.
The category values for this column were already listed for column: ORGAN_DONOR_YN
67 EDD_DT DATETIME No
The patient's Expected Date of Delivery.
68 EDD_ENTERED_DT DATETIME No
Date the Expected Date of Delivery was entered.
69 EDD_CMT VARCHAR No
Expected Date of Delivery comment.
70 INTRPTR_NEEDED_YN VARCHAR No
Indicates whether the patient needs an interpreter.
The category values for this column were already listed for column: ORGAN_DONOR_YN
71 PCP_DON_CHART_YN VARCHAR No
Indicates whether the primary care physician has finished moving all the information from the paper chart into the system.
The category values for this column were already listed for column: ORGAN_DONOR_YN
72 PAT_HAS_IOL_YN VARCHAR No
This item is used as a data item to mark those patients having intraocular lenses.
The category values for this column were already listed for column: ORGAN_DONOR_YN
73 PED_BIRTH_LABOR VARCHAR No
Stores the duration of labor related to a patient's birth history.
74 PED_HOSP_DAYS VARCHAR No
Stores the number of days spent in the hospital related to a patient's birth history.
75 PED_HOSP_NAME VARCHAR No
Stores the name of the hospital where the patient was born as part of birth history.
76 PED_HOSP_LOCATION VARCHAR No
Stores the hospital location where the patient was born as part of birth history.
77 MEDS_LAST_REV_TM DATETIME (Local) No
Stores the last time the encounter medications list was reviewed.
78 MEDS_LST_REV_USR_ID VARCHAR No
Stores the last user to review the encounter medications list.
79 MEDS_LST_REV_USR_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
80 SELF_EC_VERIF_DATE DATETIME No
Most recent date patient marked their emergency contact information as verified.
81 SELF_EC_VERIF_ST_YN VARCHAR No
The status of the patient's last verified emergency contact request (e.g. verified yes or no).
May contain organization-specific values: No
Category Entries:
No
Yes
82 EMPR_ID_CMT VARCHAR No
A free text comment that can be entered when the value that is considered to be "Other" is selected as the employer. This option is available only if your organization has chosen to link the patient employer to the Employer (EEP) master file in the Facility Profile.
83 PAT_STATUS_C_NAME VARCHAR No
The category value of the patient status. Possible statuses include alive and deceased. Note that there are many patient creation workflows that do not populate this item so many alive patients could have blank statuses. If using this column to report on the Alive or Deceased status of a patient population use PATIENT_4.PAT_LIVING_STAT_C instead.
May contain organization-specific values: Yes
Category Entries:
Alive
Deceased
84 MEDS_LAST_REV_CSN NUMERIC No
Stores the contact serial number of the encounter in which the patient's current medications list was last reviewed.
85 SEX_C_NAME VARCHAR No
The category number corresponding to the patient's sex.
The category values for this column were already listed for column: PREF_PCP_SEX_C_NAME