ACTIVE_IND |
DOUBLE |
Y |
The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMCONTRASHOCK_FLAG |
DOUBLE |
Y |
Identifies if there was administrative contraindication to care for septic shock. 1 - Yes - Documentation of refusal, 2 - Yes - Witnessed refusal, 3 - No - No documentation or witnessed refusal, 999 - Missing |
ADMCONTRA_FLAG |
DOUBLE |
Y |
Identifies if there is documentation for administrative contraindication to care. 1 - Yes - Documentation of refusal, 2 - Yes - Witnessed refusal, 3 - No - No Documentation or Witnessed refusal, 999 - Missing |
ADMIT_DT_TM |
DATETIME |
Y |
The date/time on which the patient was admitted. |
ADMIT_DT_TXT |
VARCHAR(10) |
Y |
The date response on which the patient was admitted. |
ADMIT_UTC_DT_TM |
DATETIME |
Y |
The date/time on which the patient was admitted; normalized to GMT. |
ASSESS_FLD_MIN |
DOUBLE |
Y |
Crystalloid Fluid Assessment Timing |
ASSESS_MIN |
DOUBLE |
Y |
Septic Shock Presentation Assessment Timing |
BCCOLLECTDELAY_FLAG |
DOUBLE |
Y |
Identifies if there was an acceptable delay in collecting a blood culture. 1 - Yes, 2 - No or UTD, 999 - Missing |
BCCOLLECTDT_TXT |
VARCHAR(10) |
Y |
The date response when blood culture collection was done |
BCCOLLECTTM_TXT |
VARCHAR(10) |
Y |
The time response when blood culture collection was done |
BCCOLLECT_DT_TM |
DATETIME |
Y |
The date/time blood culture collection was done |
BCCOLLECT_FLAG |
DOUBLE |
Y |
Identifies if blood culture collection was done. 1 - Yes, 2 - No, 999 - Missing |
BCCOLLECT_UTC_DT_TM |
DATETIME |
Y |
The date/time blood culture collection was done; normalized to GMT. |
BED_ULTRA_FLD_MIN |
DOUBLE |
Y |
Bedside Ultrasound Fluid Time (in minutes) |
BED_ULTRA_MIN |
DOUBLE |
Y |
Bedside Ultrasound Time (in minutes) |
BLD_CULT_ABX_MIN |
DOUBLE |
Y |
Blood Culture Antibiotic Time (in minutes) |
BLD_CULT_MIN |
DOUBLE |
Y |
Blood Culture Time (in minutes) |
BRDABXADM_FLAG |
DOUBLE |
Y |
Identifies broad spectrum or other antibiotic administration was done, 1 - Yes, 2 - No, 999 - Missing |
BRDABXDT_TXT |
VARCHAR(10) |
Y |
The date response when broad spectrum or other antibiotic administration was done |
BRDABXSELECT_FLAG |
DOUBLE |
Y |
Identifies broad spectrum or other antibiotic administration selection. 1 - Yes, 2 - No, 999 - Missing |
BRDABXTM_TXT |
VARCHAR(10) |
Y |
The time response when broad spectrum or other antibiotic administration was done |
BRDABX_DT_TM |
DATETIME |
Y |
The date/time broad spectrum or other antibiotic administration was done was done |
BRDABX_UTC_DT_TM |
DATETIME |
Y |
The date/time broad spectrum or other antibiotic administration was done was done; normalized to GMT. |
BROAD_SPEC_ABX_MIN |
DOUBLE |
Y |
Broad Spectrum Antibiotic Time (in minutes) |
BSCARDUSDT_TXT |
VARCHAR(10) |
Y |
The date response bedside cardiovascular ultrasound performed |
BSCARDUSPER_FLAG |
DOUBLE |
Y |
Identifies bedside cardiovascular ultrasound performed. 1 - Yes, 2 - No, 999 - Missing |
BSCARDUSTM_TXT |
VARCHAR(10) |
Y |
The time response bedside cardiovascular ultrasound performed |
BSCARDUS_DT_TM |
DATETIME |
Y |
The date/time bedside cardiovascular ultrasound performed |
BSCARDUS_UTC_DT_TM |
DATETIME |
Y |
The date/time bedside cardiovascular ultrasound performed; normalized to GMT. |
CAP_REFILL_FLD_MIN |
DOUBLE |
Y |
Capillary Refill Fluid Time (in minutes) |
CAP_REFILL_MIN |
DOUBLE |
Y |
Capillary Refill Time (in minutes) |
CARDEVALDT_TXT |
VARCHAR(10) |
Y |
The date response cardiopulmonary evaluation performed |
CARDEVALPERF_FLAG |
DOUBLE |
Y |
Initial cardiopulmonary evaluation performed. 1 - Yes, 2 - No, 999 - Missing |
CARDEVALTM_TXT |
VARCHAR(10) |
Y |
The time response cardiopulmonary evaluation performed |
CARDEVAL_DT_TM |
DATETIME |
Y |
The date/time cardiopulmonary evaluation performed |
CARDEVAL_UTC_DT_TM |
DATETIME |
Y |
The date/time cardiopulmonary evaluation performed; normalized to GMT. |
CARDIO_EVAL_FLD_MIN |
DOUBLE |
Y |
Cardiopulmonary Evaluation Fluid Time (in minutes) |
CARDIO_EVAL_MIN |
DOUBLE |
Y |
Cardiopulmonary Evaluation Time (in minutes) |
CEN_VEN_OXY_FLD_MIN |
DOUBLE |
Y |
Central Venous Oxygen Fluid Time (in minutes) |
CEN_VEN_OXY_MIN |
DOUBLE |
Y |
Central Venous Oxygen Time (in minutes) |
CEN_VEN_PRES_FLD_MIN |
DOUBLE |
Y |
Central Venous Pressure Fluid Time (in minutes) |
CEN_VEN_PRES_MIN |
DOUBLE |
Y |
Central Venous Pressure Time (in minutes) |
CFADMINDT_TXT |
VARCHAR(10) |
Y |
The date response crystalloid fluid administration was initiated |
CFADMINTM_TXT |
VARCHAR(10) |
Y |
The time response crystalloid fluid administration was initiated |
CFADMIN_DT_TM |
DATETIME |
Y |
The date/time when crystalloid fluid administration was initiated |
CFADMIN_FLAG |
DOUBLE |
Y |
Identifies crystalloid fluid administration. 1 - Yes - Volume order was 30 mL/kg, 2 - Yes - Volume order less than 30 mL/kg OR UTD, 3 - No - Not Administered or UTD, 999 - Missing |
CFADMIN_UTC_DT_TM |
DATETIME |
Y |
The date/time when crystalloid fluid administration was initiated; normalized to GMT. |
CLINICAL_TRIAL_IND |
DOUBLE |
Y |
During this hospital stay, was the patient enrolled in a clinical trial in which patients with the same condition as the measure set were being studied. 0 - No, 1- Yes, 999 - Missing. |
COMM_MRN_TXT |
VARCHAR(50) |
Y |
Identifies the community medical record number of the patient. |
COMPLETED_DT_TM |
DATETIME |
Y |
The Date and Time the abstracted case was completed |
CREXAMDT_TXT |
VARCHAR(10) |
Y |
The date response capillary refill examination performed |
CREXAMPERF_FLAG |
DOUBLE |
Y |
Identifies capillary refill examination performed. 1 - Yes, 2 - No, 999 - Missing |
CREXAMTM_TXT |
VARCHAR(10) |
Y |
The time response capillary refill examination performed |
CREXAM_DT_TM |
DATETIME |
Y |
The date/time capillary refill examination performed |
CREXAM_UTC_DT_TM |
DATETIME |
Y |
The date/time capillary refill examination performed; normalized to GMT |
CRYSTAL_FLD_ADMIN_MIN |
DOUBLE |
Y |
Crystalloid Fluid Admin Time (in minutes) |
CVOXYDT_TXT |
VARCHAR(10) |
Y |
The date response central venous oxygen measurement |
CVOXYTM_TXT |
VARCHAR(10) |
Y |
The time response central venous oxygen measurement |
CVOXY_DT_TM |
DATETIME |
Y |
The date/time central venous oxygen measurement |
CVOXY_FLAG |
DOUBLE |
Y |
Identifies central venous oxygen measurement. 1 - Yes, 2 - No, 999 - Missing |
CVOXY_UTC_DT_TM |
DATETIME |
Y |
The date/time central venous oxygen measurement; normalized to GMT. |
CVPDT_TXT |
VARCHAR(10) |
Y |
The date response central venous pressure measurement |
CVPTM_TXT |
VARCHAR(10) |
Y |
The time response central venous pressure measurement |
CVP_DT_TM |
DATETIME |
Y |
The date/time central venous pressure measurement |
CVP_FLAG |
DOUBLE |
Y |
Identifies central venous pressure measurement |
CVP_UTC_DT_TM |
DATETIME |
Y |
The date/time central venous pressure measurement; normalized to GMT. |
DIRCCSEPSIS_FLAG |
DOUBLE |
Y |
Identifies if directive for comfort care for severe sepsis was given. 1 - Yes, 2 - No, 999 - Missing |
DIRCCSHOCK_FLAG |
DOUBLE |
Y |
Identifies if directive for comfort care for septic shock was given. 1 - Yes, 2 - No, 999 - Missing |
DISCHARGE_DT_TM |
DATETIME |
Y |
The date/time on which the patient was discharged. |
DISCHARGE_DT_TXT |
VARCHAR(10) |
Y |
The date response on which the patient was discharged |
DISCHARGE_TM_TXT |
VARCHAR(10) |
Y |
The time response on which the patient was discharged |
DISCHARGE_UTC_DT_TM |
DATETIME |
Y |
The date/time on which the patient was discharged; normalized to GMT. |
DISC_DISP_FLAG |
DOUBLE |
Y |
The discharge disposition on the day of discharge.1 - Home, 2 - Hospice - Home, 3 - Hospice - Health Care Facility, 4 - Acute Care Facility, 5 - Other Health Care Facility, 6 - Expired, 7 - Left Against Medical Advice/AMA, 8 - Not Documented or UTD, 999 - Missing |
DOCSEPSHOCK_FLAG |
DOUBLE |
Y |
Indicates if septic shock was documented. 1 - Yes, 2 - No, 999 - Missing |
D_ADMIT_BUILDING_ID |
DOUBLE |
N |
The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID |
DOUBLE |
N |
The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID |
DOUBLE |
N |
The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID |
DOUBLE |
N |
Identifies the place from which the patient came before being admitted. |
D_ADMIT_TYPE_ID |
DOUBLE |
N |
Indicates the circumstances under which the patient was admitted. |
D_ATTEND_PRSNL_ID |
DOUBLE |
N |
Identifies the final attending physician associated to the encounter. |
D_BR_CCN_ID |
DOUBLE |
N |
CMS Certification Number. Foreign key to LH_D_BR_CCN |
D_BR_HCO_ID |
DOUBLE |
N |
Healthcare organization Number. Foreign key to LH_D_BR_HCO |
D_DISCHARGE_BUILDING_ID |
DOUBLE |
N |
The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID |
DOUBLE |
N |
The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID |
DOUBLE |
N |
The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID |
DOUBLE |
N |
The conditions under which the patient left the facility at the time of discharge. Foreign key to LH_D_DISCH_DISP |
D_ENCNTR_TYPE_ID |
DOUBLE |
N |
Categorizes the encounter into a logical group or type. |
D_MED_SERVICE_ID |
DOUBLE |
N |
The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others. |
D_METRIC_1_ID |
DOUBLE |
N |
Identifies the metric identifier for the Lighthouse metric. |
D_PERSON_ID |
DOUBLE |
N |
Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON |
ENCNTR_ID |
DOUBLE |
N |
Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
ETHNICITY_FLAG |
DOUBLE |
Y |
Identifies the patient has an ethnicity documented. 1 - Yes, 2 - No, 999 - Missing |
EXCLUDE_1_IND |
DOUBLE |
Y |
Identifies if a patient was excluded from SEP-1 |
EXTRACT_DT_TM |
DATETIME |
Y |
The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT |
VARCHAR(50) |
Y |
The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM |
DATETIME |
Y |
The date/time that the first ETL process started that created this record. |
FLCHALDT_TXT |
VARCHAR(10) |
Y |
The date response fluid challenge performed |
FLCHALPERF_FLAG |
DOUBLE |
Y |
Identifies fluid challenge performed.1 - Yes, 2 - No, 999 - Missing |
FLCHALTM_TXT |
VARCHAR(10) |
Y |
The time response fluid challenge performed |
FLCHAL_DT_TM |
DATETIME |
Y |
The date/time fluid challenge performed |
FLCHAL_UTC_DT_TM |
DATETIME |
Y |
The date/time fluid challenge performed; normalized to GMT. |
FLD_CHALL_FLD_MIN |
DOUBLE |
Y |
Fluid Challenge Fluid Time (in minutes) |
FLD_SHOCK_MIN |
DOUBLE |
Y |
Fluid Shock Time (in minutes) |
HEALTH_SYSTEM_ID |
DOUBLE |
N |
Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID |
DOUBLE |
N |
Identifies the unique source within the delivery network responsible for supplying the data. |
HICNUMBER |
VARCHAR(20) |
Y |
Identifies the patient has a HIC number documented |
HYPOTENSION_FLAG |
DOUBLE |
Y |
Identifies persistent hypotension.1 - Yes, 2 - No - Not Present, 3 - No - Not Assessed or Unable to Determine, 4 - Not Applicable, 999 - Missing |
INHYPODT_TXT |
VARCHAR(10) |
Y |
Initial Hypotension Date Response |
INHYPOTM_TXT |
VARCHAR(10) |
Y |
Initial Hypotension Time Response |
INHYPO_DT_TM |
DATETIME |
Y |
Standard Time conversion of Initial Hypotension Date/Time |
INHYPO_FLD_MIN |
DOUBLE |
Y |
Initial Hypotension Fluid Timing |
INHYPO_UTC_DT_TM |
DATETIME |
Y |
UTC Time conversion of Initial Hypotension Date/Time |
INITHYPOTENSION_FLAG |
DOUBLE |
Y |
Indicates if initial hypotension was present. 1 - Yes, 2 - No, 999 - Missing |
INITLLCOLL_FLAG |
DOUBLE |
Y |
Identifies if initial lactate level collection was done. 1 - Yes, 2 - No, 999 - Missing |
INITLLDT_TXT |
VARCHAR(10) |
Y |
The date response of initial lactate level collection |
INITLLRES_FLAG |
DOUBLE |
Y |
Identifies initial lactate level result. 1 - <= 2.0, 2 - >2.0 and < 4.0, 3 - >= 4.0, 999 - Missing |
INITLLTM_TXT |
VARCHAR(10) |
Y |
The time response of initial lactate level collection |
INITLL_DT_TM |
DATETIME |
Y |
The date/time initial lactate level collection happened |
INITLL_UTC_DT_TM |
DATETIME |
Y |
The date/time initial lactate level collection happened; normalized to GMT. |
INIT_LACTATE_MIN |
DOUBLE |
Y |
Initial Lactate Time (in minutes) |
LAST_PROCESS_DT_TM |
DATETIME |
Y |
The date/time that the last ETL process started that updated this record. |
LH_ABS_SEPSIS_METRICS_ID |
DOUBLE |
N |
Unique generated number that identifies a single row on the LH_ABS_SEPSIS_METRICS table. |
LOGICAL_DOMAIN_ID |
DOUBLE |
N |
The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NUMERATOR_1_IND |
DOUBLE |
Y |
Identifies if a patient qualifies to be met/not met for SEP-1 |
ORG_MRN_TXT |
VARCHAR(50) |
Y |
Identifies the medical record number of the patient. |
OTH_DIAGNOSIS_LIST |
VARCHAR(400) |
Y |
A comma separated list of other diagnoses associated with the encounter. |
OTH_PROCEDURE_DATES_LIST |
VARCHAR(400) |
Y |
A comma separated list of dates the other procedures associated with the encounter were performed |
OTH_PROCEDURE_LIST |
VARCHAR(400) |
Y |
A comma separated list of other procedures associated with the encounter |
PARTITION_DT_TM |
DATETIME |
Y |
The date/time the encounter was discharged from the facility |
PASSLEGDT_TXT |
VARCHAR(10) |
Y |
The date response passive leg raise exam performed |
PASSLEGPERF_FLAG |
DOUBLE |
Y |
Identifies passive leg raise exam performed. 1 - Yes, 2 - No, 999 - Missing |
PASSLEGTM_TXT |
VARCHAR(10) |
Y |
The time response passive leg raise exam performed |
PASSLEG_DT_TM |
DATETIME |
Y |
The date/time passive leg raise exam performed |
PASSLEG_UTC_DT_TM |
DATETIME |
Y |
The date/time passive leg raise exam performed; normalized to GMT. |
PASS_LEG_RAISE_FLD_MIN |
DOUBLE |
Y |
Passive Leg Raise Fluid Time (in minutes) |
PASS_LEG_RAISE_MIN |
DOUBLE |
Y |
Passive Leg Raise Time (in minutes) |
PAYMENT_SOURCE_FLAG |
DOUBLE |
Y |
Identifies the patient has a payment source documented. 1 - Medicare, 2 - Non-Medicare, 999 - Missing |
PERIP_PULSE_FLD_MIN |
DOUBLE |
Y |
Peripheral Pulse Fluid Time (in minutes) |
PERIP_PULSE_MIN |
DOUBLE |
Y |
Peripheral Pulse Time (in minutes) |
PHYSICIAN_1_TXT |
VARCHAR(50) |
Y |
First physician identifier |
PHYSICIAN_2_TXT |
VARCHAR(50) |
Y |
Second physician identifier |
POSTAL_CODE |
VARCHAR(20) |
Y |
Identifies the patient has a postal code documented |
PPEVALDT_TXT |
VARCHAR(10) |
Y |
The date response peripheral pulse evaluation performed |
PPEVALPERF_FLAG |
DOUBLE |
Y |
Identifies peripheral pulse evaluation performed. 1 - Yes, 2 - No, 999 - Missing |
PPEVALTM_TXT |
VARCHAR(10) |
Y |
The time response peripheral pulse evaluation performed |
PPEVAL_DT_TM |
DATETIME |
Y |
The date/time peripheral pulse evaluation performed |
PPEVAL_UTC_DT_TM |
DATETIME |
Y |
The date/time peripheral pulse evaluation performed; normalized to GMT. |
PREGNANT_FLAG |
DOUBLE |
Y |
Designates if user has noted that patient is pregnant or not. 1 - Pregnant, 2 - Not Pregnant, 999 - User has not given any response. A NULL value will be on rows that existed before this question was available to the user. |
PRIN_DIAGNOSIS |
VARCHAR(10) |
Y |
Identifies the principle diagnosis associated with the encounter. |
PRIN_PROCEDURE |
VARCHAR(10) |
Y |
Identifies the principle procedure associated with the encounter |
PRIN_PROCEDURE_DATE_TXT |
VARCHAR(10) |
Y |
Identifies the principle procedure response |
PRIN_PROCEDURE_DT_TM |
DATETIME |
Y |
The date/time on which the principle procedure was performed |
PRIN_PROCEDURE_UTC_DT_TM |
DATETIME |
Y |
The date/time on which the principle procedure was performed; normalized to GMT |
PRS_TXT |
VARCHAR(10) |
Y |
Identifies the Patient Reliability Score (PRS) |
RACE_FLAG |
DOUBLE |
Y |
Identifies the patient has a race documented. 1 - White, 2 - Black or African American, 3 - American Indian or Alaska Native, 4 - Asian, 5 - Native Hawaiian or Pacific Islander, 6 - RETIRED VALUE, 7 - UTD (Unable to determine), 999 - Missing |
REJECT_1_IND |
DOUBLE |
Y |
Identifies if a patient was rejected for SEP-1 |
REPEATLLCOLL_FLAG |
DOUBLE |
Y |
Identifies initial lactate Level collection.1 - Yes, 2 - No, 999 - Missing |
REPEATLLDT_TXT |
VARCHAR(10) |
Y |
The date response when initial lactate level was drawn |
REPEATLLTM_TXT |
VARCHAR(10) |
Y |
The time response when initial lactate level was drawn |
REPEATLL_DT_TM |
DATETIME |
Y |
The date/time when initial lactate level was drawn |
REPEATLL_UTC_DT_TM |
DATETIME |
Y |
The date/time when initial lactate level was drawn; normalized to GMT. |
REPEATVSDT_TXT |
VARCHAR(10) |
Y |
Repeat Volume and Tissue Perfusion Assessment Performed Date Response |
REPEATVSTM_TXT |
VARCHAR(10) |
Y |
Repeat Volume and Tissue Perfusion Assessment Performed Time Response |
REPEATVS_DT_TM |
DATETIME |
Y |
Standard Time conversion of Repeat Volume and Tissue Perfusion Assessment |
REPEATVS_FLAG |
DOUBLE |
Y |
Repeat Volume and Tissue Perfusion Assessment Performed Answer.0 - No, 1 - Yes, 999 - Unanswered |
REPEATVS_UTC_DT_TM |
DATETIME |
Y |
UTC Time conversion of Repeat Volume and Tissue Perfusion Assessment |
RPT_LACTATE_MIN |
DOUBLE |
Y |
Repeat Lactate Time (in minutes) |
SAMPLE_IND |
DOUBLE |
Y |
Indicates if the case was sampled |
SEP1_REASON_TXT |
VARCHAR(250) |
Y |
Stores the category reason obtained during the completion of abstraction. |
SEPSISPRESDT_TXT |
VARCHAR(10) |
Y |
The date response on which sepsis was present |
SEPSISPRESTM_TXT |
VARCHAR(10) |
Y |
The time response on which sepsis was present |
SEPSISPRES_DT_TM |
DATETIME |
Y |
The date/time on which sepsis was present. |
SEPSISPRES_FLAG |
DOUBLE |
Y |
Identifies if severe sepsis was present.1 - Yes, 2 - No, 999 - Missing |
SEPSISPRES_UTC_DT_TM |
DATETIME |
Y |
The date/time on which sepsis was present; normalized to GMT. |
SEPSIS_3HR_CNT |
DOUBLE |
Y |
Sepsis three hour counter |
SEPSIS_6HR_CNT |
DOUBLE |
Y |
Sepsis six hour counter |
SEPSIS_EXPIRED_MIN |
DOUBLE |
Y |
Sepsis Expired Time (in minutes) |
SHOCKPRESDT_TXT |
VARCHAR(10) |
Y |
The date response septic shock was present |
SHOCKPRESTM_TXT |
VARCHAR(10) |
Y |
The time response septic shock was present |
SHOCKPRES_DT_TM |
DATETIME |
Y |
The date/time when septic shock was present |
SHOCKPRES_FLAG |
DOUBLE |
Y |
Identifies if septic shock present.1 - Yes, 2 - No, 999 - Missing |
SHOCKPRES_UTC_DT_TM |
DATETIME |
Y |
The date/time when septic shock was present; normalized to GMT. |
SHOCK_3HR_CNT |
DOUBLE |
Y |
Shock three hour counter |
SHOCK_6HR_CNT |
DOUBLE |
Y |
Shock six hour counter |
SHOCK_EXP_MIN |
DOUBLE |
Y |
Shock Expired Time (in minutes) |
SHOCK_PA_6HR_CNT |
DOUBLE |
Y |
Shock physical assessment six hour counter |
SHOCK_PRES_MIN |
DOUBLE |
Y |
Shock Presentation Time (in minutes) |
SHOCK_VASO_6HR_CNT |
DOUBLE |
Y |
Shock vasopressor six hour counter. |
SKINEXAMDT_TXT |
VARCHAR(10) |
Y |
The date response skin examination performed |
SKINEXAMPERF_FLAG |
DOUBLE |
Y |
Identifies skin examination performed.1 - Yes, 2 - No, 999 - Missing |
SKINEXAMTM_TXT |
VARCHAR(10) |
Y |
The time response skin examination performed |
SKINEXAM_DT_TM |
DATETIME |
Y |
The date/time skin examination performed |
SKINEXAM_UTC_DT_TM |
DATETIME |
Y |
The date/time skin examination performed; normalized to GMT. |
SKIN_EXAM_FLD_MIN |
DOUBLE |
Y |
Skin Exam Fluid Time (in minutes) |
SKIN_EXAM_MIN |
DOUBLE |
Y |
Skin Exam Time (in minutes) |
TRANSFERED_FLAG |
DOUBLE |
Y |
Identifies if a patient was transferred from another hospital or ASC. 0 - TBD, 1 - Yes, 2 - No, 999 - Missing |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM |
DATETIME |
Y |
The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID |
DOUBLE |
N |
The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE |
VARCHAR(50) |
Y |
The script name responsible for updating the record. |
UPDT_TASK |
VARCHAR(50) |
Y |
The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VASOADMINDT_TXT |
VARCHAR(10) |
Y |
The date response of vasopressor administration |
VASOADMINTM_TXT |
VARCHAR(10) |
Y |
The time response of vasopressor administration |
VASOADMIN_DT_TM |
DATETIME |
Y |
The date/time of vasopressor administration |
VASOADMIN_FLAG |
DOUBLE |
Y |
Identifies if vasopressor administration was done. 1 - Yes, 2 - No, 999 - Missing |
VASOADMIN_UTC_DT_TM |
DATETIME |
Y |
The date/time of vasopressor administration; normalized to GMT. |
VASO_MIN |
DOUBLE |
Y |
Vasopressor Time (in minutes) |
VITAL_SIGNS_FLD_MIN |
DOUBLE |
Y |
Vital Signs Fluid Time (in minutes) |
VITAL_SIGNS_MIN |
DOUBLE |
Y |
Vital Signs Time (in minutes) |
VSREVIEWDT_TXT |
VARCHAR(10) |
Y |
The date response vital signs review was performed |
VSREVIEWPERF_FLAG |
DOUBLE |
Y |
Identifies vital signs review performed.1 - Yes, 2 - No, 999 - Missing |
VSREVIEWTM_TXT |
VARCHAR(10) |
Y |
The time response vital signs review was performed |
VSREVIEW_DT_TM |
DATETIME |
Y |
The date/time vital signs review was performed |
VSREVIEW_UTC_DT_TM |
DATETIME |
Y |
The date/time vital signs review was performed; normalized to GMT. |