PATIENT_3

Description:

This table supplements the information contained in the PATIENT table. It contains basic information about patients, such as the patient's ID, occupation, English fluency, etc.

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	LACT_STAT_CUR_C_NAME	VARCHAR	No
	The category number for the patient's current lactation status. May contain organization-specific values: No Category Entries: Yes No Unknown
3	LACT_STAT_INST_DTTM	DATETIME (UTC)	No
	The instant when the patient's lactation status was updated.
4	LACT_STAT_CSN	NUMERIC	No
	The contact serial number of the encounter in which the lactation status updated. The contact serial number is the unique identifier for the encounter.
5	LACT_STAT_USER_ID	VARCHAR	No
	The unique ID of the user who last updated the patient's lactation status.
6	LACT_STAT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	AMBULATORY_STATUS_C_NAME	VARCHAR	No
	Information regarding a patient's ambulatory status. May contain organization-specific values: Yes Category Entries: Ambulates with assistive device Wheelchair/stretcher bound Comatose; non-responsive Disoriented Vision impaired Hearing impaired Speech impaired Non-English speaking Functional level unknown Oxygen Therapy Special Equipment Amputee Mastectomy Paraplegic Pregnant
8	OCCUPATION	VARCHAR	No
	A patient's occupation.
9	ADVANCED_DIR_YN	VARCHAR	No
	Indicates whether the patient has any advanced directives. May contain organization-specific values: No Category Entries: Yes No
10	ABST_DT	DATETIME	No
	The date of abstraction of the patient record.
11	ALRGY_REV_REAS_C_NAME	VARCHAR	No
	Reason for the review status of allergy assessment. May contain organization-specific values: Yes Category Entries: Patient unable to communicate Patient unreliable Patient not present Language barrier Parent, guardian, or caregiver unavailable
12	ALLOW_HALF_PILLS_YN	VARCHAR	No
	Indicates whether the patient uses half pills May contain organization-specific values: No Category Entries: Yes No
13	L_GROWTH_CHART_USED	VARCHAR	No
	Contains the last growth chart accessed by a user for a particular patient. This allows the activity to display that same growth chart for that patient the next time the activity is accessed.
14	ALRG_LAST_UPDA_DTTM	DATETIME (Local)	No
	The latest instant in which allergies were updated.
15	PED_BIRTH_LEN_NUM	NUMERIC	No
	Newborn birth length stored in inches.
16	PED_BIRTH_WT_NUM	NUMERIC	No
	Newborn birth weight stored in ounces.
17	PED_DISCHRG_WGT_NUM	NUMERIC	No
	Newborn discharge weight stored in ounces.
18	PED_APGAR_ONE_C_NAME	VARCHAR	No
	Newborn 1 minute Apgar. May contain organization-specific values: Yes Category Entries: 0 1 2 3 4 5 6 7 8 9 10
19	PED_APGAR_FIVE_C_NAME	VARCHAR	No
	Newborn 5 minute Apgar. The category values for this column were already listed for column: PED_APGAR_ONE_C_NAME
20	PED_APGAR_TEN_C_NAME	VARCHAR	No
	Newborn 10 minute Apgar. The category values for this column were already listed for column: PED_APGAR_ONE_C_NAME
21	UNOS_PRIM_COD_C_NAME	VARCHAR	No
	The transplant patient's primary cause of death, as defined by UNOS (United Network for Organ Sharing). May contain organization-specific values: Yes Category Entries: Accidental Acid/Base Disorder Acute Pancreatitis AIDS Amyloidosis ARDS Brain Dead: Never Recovered From Surgery Cardiovascular Cardiovascular: Aortic Aneurysm Cardiovascular: Arrhythmia Cardiovascular: Arterial Embolism Cardiovascular: Arterial or Pulmonary Embolism Cardiovascular: Atherosclerosis Cardiovascular: Cardiac Arrest Cardiovascular: Cardiogenic Shock Cardiovascular: Carditis Cardiovascular: Congestive Failure (CHF) Cardiovascular: Coronary Artery Disease Cardiovascular: Hyperkalemic Arrest Cardiovascular: MF/CHF Cardiovascular: Myocardial Infarction Cardiovascular: Other, Specify Cardiovascular: Pulmonary Embolism Cardiovascular: Rhythm Disorder Cardiovascular: Vascular Embolism Cardiovascular: Ventricular Failure Cerebrovascular: Brain Anoxia Cerebrovascular: Degenerative Brain Disease Cerebrovascular: Embolic Stroke Cerebrovascular: Hemorrhage (Non-Stroke) Cerebrovascular: Hemorrhagic Stroke Cerebrovascular: Other, Specify Cerebrovascular: Stroke CVA Diabetes Mellitus Diabetes Mellitus Complications Domino Liver Donor Transplant Related Death (Liver donors only) Fluid/Electrolyte Disorder Graft vs. Host Disease Hematologic Other, Specify Hemorrhage Hemorrhage: Disseminated Intravascular Coagulation (DIC) Hemorrhage: Donation/Surgery Related Hemorrhage: Gastrointestinal Hemorrhage: Intraoperative Hemorrhage: Lower Gastrointestinal Hemorrhage: Neurological (Brain) Hemorrhage: Not Donation/Surgery Related Hemorrhage: Other, Specify Hemorrhage: Post-Operative Hemorrhage: Respiratory Hemorrhage: Variceal Homicide Immunosuppressive Drug Related Hematologic Immunosuppressive Drug Related Non-Hematologic Infection Infection: Bacterial Other, Specify Infection: Bacterial Peritonitis Infection: Bacterial Pneumonia Infection: Bacterial Septicemia Infection: Donation/Surgery Related Infection: Fungal Infection: Fungal Aspergillus Infection: Fungal Other, Specify Infection: Fungal Aspergillus Cryptococcal Infection: Fungal Peritonitis Infection: Fungal Pneumonia Infection: Fungal Septicemia Infection: Generalized Sepsis Infection: Mixed Other, Specify Infection: Not Donation/Surgery Related Infection: Opportunistic Infection: Opportunistic Other, Specify Infection: Other, Specify Infection: Pneumonia Legionella Pneumocystosis Infection: Protozoal Infection: Urinary Tract Infection: Viral Infection: Viral Cytomegalovirus (CMV) Infection: Viral Hepatitis Infection: Viral Non-CMV Infection: Viral Other, Specify Infection: Viral Septicemia Intestine Graft Failure: Infection Other, Specify Intestine Graft Failure: Other, Specify Intestine Graft Failure: Primary Intestine Graft Failure: Recurrent Disease Other, Specify Intestine Graft Failure: Rejection Intestine Graft Failure: Vascular Thrombosis Intraoperative: Other, Specify Intraoperative: Not Hemorrhage Other, Specify Kidney Graft Failure: Graft Infection Kidney Graft Failure: Other, Specify Kidney Graft Failure: Primary Failure Kidney Graft Failure: Recurrent Disease Kidney Graft Failure: Rejection Kidney Graft Failure: Technical Liver Failure Liver Graft Failure: Biliary Tract Complication Liver Graft Failure: Hepatitis Liver Graft Failure: Infection (Non-Hepatitis) Liver Graft Failure: Other, Specify Liver Graft Failure: Primary Failure Liver Graft Failure: Recurrent Disease (Non-Hepatitis) Liver Graft Failure: Rejection Liver Graft Failure: Vascular Thrombosis Malignancy Malignancy: Lymphoma Malignancy: Metastatic Other, Specify Malignancy: Other, Specify Malignancy: Post-Txp Lymphoproliferative Malignancy: Primary Other, Specify Malignancy: Skin Multiple Organ System Failure Non-Compliance Non-Immunosuppressive Non-Hematologic, Specify Drug Non-Immunosuppressive Drug Related Hematologic Operative: Other, Specify Pancreatitis Pancreatitis (Graft) Pancreatitis (Native) Post-Txp Lymphoproliferative Disorder Primary Pulmonary Hypertension Pulmonary Embolism Pulmonary Insuff or Edema (Exc Pneumonia) Pulmonary: Acute Respiratory Distress Disease Pulmonary: Bronchiolitis Pulmonary: Dehiscence Pulmonary: Other, Specify Pulmonary: Respiratory Failure Renal Failure Respiratory Failure Respiratory Failure (Non-Pneumonia) Respiratory Failure: Other, Specify Suicide Suicide: Attempted Suicide Died Later Thoracic Graft Failure: Graft Infection Thoracic Graft Failure: Non-Specific Thoracic Graft Failure: Primary Failure Thoracic Graft Failure: Recurrent Disease Thoracic Graft Failure: Rejection Acute Thoracic Graft Failure: Rejection Chronic Thoracic Graft Failure: Rejection Hyperacute Thoracic Graft Failure: Technical Trauma: Motor Vehicle Trauma: Other, Specify Kidney Graft Failure: Primary Non-Function (Graft Never Functioned Post-Transplant) Liver Graft Failure: Primary Non-Function Liver Graft Failure: Hepatic Artery Thrombosis Liver Graft Failure: Other Vascular Thrombosis Liver Graft Failure: Diffuse Cholangiopathy Infection: Viral COVID-19 Unknown Other, Specify
22	UNOS_PRIM_COD_SP	VARCHAR	No
	Free text description of the transplant patient's primary cause of death.
23	UNOS_CTRB_COD1_C_NAME	VARCHAR	No
	The transplant patient's first contributory cause of death, as defined by UNOS (United Network for Organ Sharing). The category values for this column were already listed for column: UNOS_PRIM_COD_C_NAME
24	UNOS_CNTB_COD1_SP	VARCHAR	No
	Free text description of the transplant patient's first contributory cause of death.
25	UNOS_CTRB_COD2_C_NAME	VARCHAR	No
	The transplant patient's second contributory cause of death, as defined by UNOS (United Network for Organ Sharing). The category values for this column were already listed for column: UNOS_PRIM_COD_C_NAME
26	UNOS_CNTB_COD2_SP	VARCHAR	No
	Free text description of the transplant patient's second contributory cause of death.
27	PREFERRED_NAME	VARCHAR	No
	The preferred name for the patient.
28	LAST_VERIFIED_BY_ID	VARCHAR	No
	The last user who verified the patient.
29	LAST_VERIFIED_BY_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
30	LEARN_ASSMT_ID	NUMERIC	No
	Learning assessment ID. This can be used to check that the learning assessments are being given to the appropriate patients at the appropriate times.
31	CURR_LOC_ID	NUMERIC	No
	The unique ID of the most recent confirmed patient location that is associated with the patient.
32	PCOD_CAUSE_DX_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.
33	PCOD_REC_USER_ID	VARCHAR	No
	Stores the user that filed the preliminary cause of death
34	PCOD_REC_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
35	PCOD_INST_REC_DTTM	DATETIME (UTC)	No
	Stores the instant that the preliminary cause of death was recorded
36	EMPL_ID_NUM	VARCHAR	No
	The patient's employee identification number.
37	SCHOOL_PHONE	VARCHAR	No
	The patient's school phone number.
38	CONTRACT_ID_CONTRACT_NAME	VARCHAR	No
	The name of the pricing contract.
39	SPOT_UPD_USER_ID	VARCHAR	No
	This item saves the user ID of the person who most recently updated the patient's Spotlight folder in the Synopsis activity by adding a row that previously had not been tracked by any other user.
40	SPOT_UPD_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
41	GYN_HX_CMT_NOTE_ID	VARCHAR	No
	ID of HNO (note) record for free-text gynecological information
42	GYN_HX_MENARCHE_AGE	INTEGER	No
	The patient's age at menarche
43	GYN_HX_FST_PREG_AGE	INTEGER	No
	The patient's age at first pregnancy
44	GYN_HX_MO_BRSTFDG	INTEGER	No
	The number of months the patient spent breastfeeding
45	GYN_HX_MENOPAUS_AGE	INTEGER	No
	The patient's age at menopause
46	FAMILY_GROUPER	VARCHAR	No
	A family identifier that may be used to group family members together. Note that this is not guaranteed to be unique across deployments in IntraConnect.
47	FETUS_YN	VARCHAR	No
	Indicates whether this row is a fetus record or a patient record. YES indicates that the row is a fetus record. NO indicates that the row is a patient record. May contain organization-specific values: No Category Entries: No Yes
48	DENT_CLASS_C_NAME	VARCHAR	No
	This item identifies the dental classification of the patient. May contain organization-specific values: No Category Entries: I II III IV
49	DENT_LAST_USER_ID	VARCHAR	No
	This item stores the last user who edited the dental classification of the patient.
50	DENT_LAST_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
51	DENT_INST_DTTM	DATETIME (Local)	No
	This item stores the instant when the dental classification of the patient was last edited.
52	ENGLISH_FLUENCY_C_NAME	VARCHAR	No
	Record the patient's fluency in English. May contain organization-specific values: Yes
53	FORM_CONFIDENCE_C_NAME	VARCHAR	No
	Record the patient's confidence level in filling out medical forms. May contain organization-specific values: Yes No Entries Defined
54	BRANCH_OF_SERVICE_C_NAME	VARCHAR	No
	This column stores the branch of service in which the patient serves. May contain organization-specific values: Yes
55	MILITARY_RANK_C_NAME	VARCHAR	No
	This column stores the patient's military rank. May contain organization-specific values: Yes No Entries Defined
56	FMP_C_NAME	VARCHAR	No
	This column stores the relationship between the patient and the patient's sponsor. May contain organization-specific values: Yes No Entries Defined
57	PAT_CAT_C_NAME	VARCHAR	No
	This column, patient category, combines the branch of service and eligibility type into a three-character code, such as A14. This code affects billing and other downstream systems. May contain organization-specific values: Yes No Entries Defined
58	MIL_COMPONENT_C_NAME	VARCHAR	No
	This column stores the patient's military component, which is used to distinguish between patients who are on regular active duty and those who are members of one of the augmenting support groups. May contain organization-specific values: Yes No Entries Defined
59	ASGN_MIL_UNIT_ID	NUMERIC	No
	This column stores the military unit ID to which the patient is assigned.
60	ASGN_MIL_UNIT_ID_RECORD_NAME	VARCHAR	No
	This column stores the name of the military unit's record.
61	MIL_PAY_GRADE_C_NAME	VARCHAR	No
	This column stores the patient's military pay grade. May contain organization-specific values: Yes No Entries Defined
62	TEMP_MIL_UNIT_ID	NUMERIC	No
	This column stores the patient's temporary military unit ID.
63	TEMP_MIL_UNIT_ID_RECORD_NAME	VARCHAR	No
	This column stores the name of the military unit's record.
64	PED_GEST_AGE_DAYS	INTEGER	No
	Newborn gestational age at birth in total number of days
65	PED_BIRTH_HD_CIRCUM	NUMERIC	No
	Newborn birth head circumference stored in inches.