Table Detail Report

HF_D_VITAL_STATUS



Column Section Top of Page


Table-level Detail

Description: HF_D_VITAL_STATUS
Definition: The dimension table of possible vital status.
Table Type: REFERENCE





Column Detail - HF_D_VITAL_STATUS


Column Name Type Null? Definition
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
UPDT_TASK VARCHAR(40) Y The registered (assigned) task number for the process that inserted or updated the row.
UPDT_USER VARCHAR(40) Y The user id that performed the update or insert on this record.
VITAL_STATUS_DESC VARCHAR(60) Y The description of the vital status.
VITAL_STATUS_ID DOUBLE Y PRIMARY KEY


HF_F_CLINICAL_EVENT



Column Section Top of Page


Table-level Detail

Description: HF_F_CLINICAL_EVENT
Definition: This is the fact table that contain all clinical events for patients for given encounter (visit)
Table Type: REFERENCE





Column Detail - HF_F_CLINICAL_EVENT


Column Name Type Null? Definition
ACCESSION_NBR VARCHAR(100) Y This is the accession or order number associated with this order. Allows access to events/groups of events via Accession Number. Scope and use of Accession Number is application-specific
CLINICAL_EVENT_FACT_ID DOUBLE N The unique identifier for the clinical event fact row.
CLINICAL_SEQ DOUBLE Y This field describes the sequence of an event in a series. For example, 1,2,3 is one sequence or Post Op 1, Post Op2, Post Op3 could be another separate sequence. Used to indicate what sequence clinical events took place in if they're all ensured together.
CLINSIG_UPDT_DT_ID DOUBLE Y The clinically significant date key is used to join the clinical event fact table to the date dimension table.
CLINSIG_UPDT_DT_TM DATETIME Y Clinical Significant date and time
CRITICAL_HIGH VARCHAR(20) Y Critical high value
CRITICAL_LOW VARCHAR(20) Y Critical low value
ENCOUNTER_ID DOUBLE Y The visit identifier for the encounter
EQUATION_TXT VARCHAR(2000) Y This field stores the equation used to calculate the result. Ex. MAP = SAP + (DAP x 2)/3
EVENT_CLASS_ID DOUBLE Y Coded value which specifies how the event is stored in and retrieved from the event table's sub-tables. For example, Event_Class_CDs identify events as numeric results, textual results, calculations, medications, etc.
EVENT_CODE_ID DOUBLE Y It is the code that identifies the most basic unit of the storage, i.e. RBC, discharge summary, image
EVENT_END_DT_ID DOUBLE Y The event end date key used to join the clinical event fact table to the date dimension table.
EVENT_END_DT_TM DATETIME Y Clinical date time for the end of the event. In the cases where results do not associate an Event Time range, then the event_start_dt_tm = event_end_dt_tm
EVENT_EXPIRATION_DT_ID DOUBLE Y The event expiration date key used to join the clinical event fact table to the date dimension table.
EVENT_EXPIRATION_DT_TM DATETIME Y The date on which the result no longer becomes clinically relevant. Indicates when a result can no longer be used to make clinical decisions. The result still has historical significance, but cannot be used to make decisions on the administration of care. Example: A blood bank cross match is only valid for 24-48 hours. If after that time they need a cross-match, they must do another one.
EVENT_NK VARCHAR(100) Y The source event system identifier. This is used to link multiple clinical events through the parent_event_nk.
EVENT_NOMRALCY_ID DOUBLE Y States whether the result is normal. This can be used to determine whether to display the event tag in different color on the flowsheet. For group results, this represents an ""overall"" normalcy. i.e. Is any result in the group abnormal?
EVENT_NORMALCY_METHOD_ID DOUBLE Y The method used to interpret normalcy
EVENT_RELTN_ID DOUBLE Y To indicate whether this event is a parent event of another event or a child event of another event or an orphan event where it is not parent or child of another event
EVENT_SOURCE_ID DOUBLE Y Source from which this result value originated. For example the source can be father or mother or calculated
EVENT_START_DT_ID DOUBLE Y The event start date key used to join the clinical event fact table to the date dimension table.
EVENT_START_DT_TM DATETIME Y The Clinical date and time for the start of this event
HOSPITAL_ID DOUBLE Y The dim table key for the hospital that this record's encounter is attached to
LAB_PROCEDURE_ID DOUBLE Y The unique identifier for the orderable within the Cerner Health Facts Data Warehouse
NORMAL_HIGH VARCHAR(20) Y Normal high value
NORMAL_LOW VARCHAR(20) Y Normal low value
PARENT_EVENT_NK VARCHAR(100) Y The source event system identifier. This is used to link multiple clinical events through the event_nk.
PARTITION_DT_TM DATETIME Y Indicates which partition of the table this record is in. Matches the partition date/time of the parent encounter
PATIENT_ID DOUBLE Y The patient unique identifier used within the Cerner Health Facts Data Warehouse.
PERFORMED_DT_ID DOUBLE Y The performed date key used to join the clinical event fact table to the date dimension table.
PERFORMED_DT_TM DATETIME Y The date and time when this event was performed
PERFORMED_PRSNL_ID DOUBLE Y The personnel who performed this result
REFERENCE_NBR VARCHAR(100) Y The combination of the reference nbr and the contributor system code provides a unique identifier to the origin of the data.
RESULT_FEASIBLE_IND DOUBLE Y Indicates whether or not the result is within feasible limits.
RESULT_INACCURATE_IND DOUBLE Y Indicate whether the result value is outside of the measuring instruments accurate limits.
RESULT_NORMALCY_FLG DOUBLE Y Indicates Whether A Areult Is Abnormal Or Not. A Value Of: 2 Indicates An Abnormal Result; 1 Indicates A Normal Result 0 - indicates undefined or unknown -1 - N/A
RESULT_TIME_UNIT_ID DOUBLE Y If the result refers to a rate, this field is the time component of the rate
RESULT_UNITS_ID DOUBLE Y The unit of measure of the event / result
RESULT_VALUE VARCHAR(255) Y The value of the result
RESULT_VALUE_DT_ID DOUBLE Y The result date key used to join the clinical event fact table to the date dimension table.
RESULT_VALUE_DT_TM DATETIME Y The actual date and time result value
RESULT_VALUE_NUM DOUBLE Y The actual numeric result
RESULT_VALUE_TXT VARCHAR(255) Y The actual result value in text
SECTION_ID DOUBLE Y The section where the event is performed. e.g. For Microbiology event, the bench will be stored here.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
UPDT_TASK VARCHAR(40) Y The registered (assigned) task number for the process that inserted or updated the row.
UPDT_USER VARCHAR(40) Y The user who last modified this record
VERIFIED_DT_ID DOUBLE Y The verified date key used to join the clinical event fact table to the date dimension table.
VERIFIED_DT_TM DATETIME Y Date and time this result / event is verified
VERIFIED_PRSNL_ID DOUBLE Y The personnel who verified this result / event


HF_F_DIAGNOSIS



Column Section Top of Page


Table-level Detail

Description: HF_F_DIAGNOSIS
Definition: This is the fact table that contain all diagnoses for patients for given encounter (visit)
Table Type: REFERENCE





Column Detail - HF_F_DIAGNOSIS


Column Name Type Null? Definition
DIAGNOSIS_FACT_ID DOUBLE Y The unique identifier from the diagnosis table
DIAGNOSIS_ID DOUBLE Y The link to the diagnosis such as ICD-9-CM diagnosis (Unspecified Anemia)
DIAGNOSIS_PRIORITY DOUBLE Y A number identifying the series of a diagnosis within an encounter. The diagnoses are assigned by a medical records coder for billing purposes retrospective to the encounter. The principal diagnosis (sequence =1) is the condition established after study to be chiefly responsible for the admission. The secondary diagnoses (sequences 2-9) are additional conditions that coexist at the time of admission or develop subsequently that have an effect on the treatment received or the the length of stay.
DIAGNOSIS_TYPE_ID DOUBLE Y The type of diagnosis such as admitting diagnosis, final diagnosis etc.
DISCHARGE_DT_TM DATETIME Y The patient discharged date and time
ENCOUNTER_ID DOUBLE Y The visit key for the encounter. This is unique to the patient
HOSPITAL_ID DOUBLE Y The hospital key is a unique identifier for the facility. The key is used to link the hospital dimension table to encounter_facts table."
PARTITION_DT_TM DATETIME Y Indicates which partition of the table this record is in. Matches the partition date/time of the parent encounter
PRESENT_ON_ADMIT_ID DOUBLE Y A number identifying Present on Admission of a diagnosis
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_TASK VARCHAR(40) 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.
UPDT_USER VARCHAR(40) Y The user who last modified this record


HF_F_ENCOUNTER



Column Section Top of Page


Table-level Detail

Description: HF_F_ENCOUNTER
Definition: The encounter table contains patient information for a specific period of time that a person comes in contact with a healthcare provider (i.e., inpatient hospital stay, outpatient clinic visit, office visit, phone call to the doctor, etc.).
Table Type: REFERENCE





Column Detail - HF_F_ENCOUNTER


Column Name Type Null? Definition
ADMISSION_SOURCE_ID DOUBLE Y The admission source id is a unique identifier used to join the admission_source dimension to the hf_f_encounter table.
ADMISSION_TYPE_ID DOUBLE Y The admission type id is a unique identifier used to join the admission_type dimension to the hf_f_encounter table.
ADMITTED_DT_ID DOUBLE Y The admit date id is used to join the hf_f_encounter table to the date dimension table.
ADMITTED_DT_TM DATETIME Y The date/time that the patient was admitted.
ADMITTED_TM_VALID_IND DOUBLE Y Indicates if the admitted date is a valid date.
ADMITTING_DIAGNOSIS_1_ID DOUBLE Y A unique identifier used to link the admitting_diagnosis dimension table to the hf_f_encounter table. Free text field describing the reason the patient was admitted.
ADMITTING_DIAGNOSIS_2_ID DOUBLE Y A unique identifier used to link the admitting_diagnosis dimension table to the hf_f_encounter table. Free text field describing the reason the patient was admitted.
ADMITTING_DIAGNOSIS_3_ID DOUBLE Y A unique identifier used to link the admitting_diagnosis dimension table to the hf_f_encounter table. Free text field describing the reason the patient was admitted.
ADMITTING_PHYSICIAN_ID DOUBLE Y The physician id is a unique identifier used to link the physician dimension table to fact tables.
AGE_IN_DAYS DOUBLE Y The persons age in days if 2 days thru 2 weeks old. Values 2 - 13 days. This value is blank if the age was extracted to only the whole year detail.
AGE_IN_HOURS DOUBLE Y The persons age in hours, if less than 2 days old. Values 0-47 hours. This value is blank if the age was extracted to only the whole year detail. If hours, days, weeks, months, and years are all equal 0, then these persons are less than 1 hour.
AGE_IN_MONTHS DOUBLE Y The persons age in months if 3 months thru 2 years. Values 3-23 months. This value is blank if the age was extracted to only the whole year detail.
AGE_IN_WEEKS DOUBLE Y The persons age in weeks if 2 weeks thru 3 months. Values 2-8 weeks. This value is blank if the age was extracted to only the whole year detail.
AGE_IN_YEARS DOUBLE Y The age of the patient at admission (calculated from admit date-date of birth). If age can be computed to the hours-months level, then age in years will be greater than or equal to 2 years, the other age fields will be 0. Age in years will equal the intege
ARRIVAL_MODE_CODE VARCHAR(10) Y Admit mode code which identifies the method by which the patient arrived. (i.e., helicopter, ambulance, etc.)
ARRIVAL_MODE_DESC VARCHAR(100) Y Admit mode description which identifies the method by which the patient arrived. (i.e., helicopter, ambulance, etc.)
ATTENDING_PHYSICIAN_ID DOUBLE Y The foreign key of the attending physician associated to the encounter.
BILLING_IND DOUBLE Y Yes (1)/No (0) flag indicating whether this encounter received billing information. Prior to 2009, this indicator should correlate to visits that also have diagnoses or procedures.
DIAGNOSTIC_GROUPING_ID DOUBLE Y The diagnostic grouping id is a unique identifier used to link the diagnostic groupings dimension table to the hf_f_encounter table. The diagnostic grouping identifies the MDC and DRG for the encounter if billing data were received.
DISCHARGED_DT_ID DOUBLE Y The foreign key to the date that the patient was discharged.
DISCHARGED_DT_TM DATETIME Y The date/time that the patient was discharged.
DISCHARGED_TM_VALID_IND DOUBLE Y Indicates if the discharged date is a valid date.
DISCHARGE_CARESETTING_ID DOUBLE Y Identifies the last (discharge) patient caresetting for the encounter. A unique identifier used to link the caresetting dimension table to the hf_f_encounter table.
DISCHARGE_DISPOSITION_ID DOUBLE Y The discharge disposition id is a unique identifier used to link the discharge_disposition dimension table to the hf_f_encounter table. If summarizing discharge disposition, use the encounters where discharge disposition not NULL as the population.
ENCOUNTER_ID DOUBLE Y The unique identifier from the source system of the encounter.
FINANCIAL_NBR VARCHAR(40) Y The formatted Financial Number of the encounter.
FINANCIAL_NBR_RAW VARCHAR(40) Y The unformatted Medical Record Number of the encounter.
FORMATTED_MEDICAL_RECORD_NBR VARCHAR(40) Y The formatted Medical Record Number of the encounter.
HOSPITAL_ID DOUBLE Y The hospital id is a unique identifier for the facility. The id is used to link the hospital dimension table to facts table.
MEDICAID_IND DOUBLE Y Indicates if the encounter qualifies for Medicaid.
MEDICAL_SERVICE_ID DOUBLE Y The unique identifier for the type or category of medical service that was received.
MEDICARE_IND DOUBLE Y Indicates if the encounter qualifies for Medicare.
ORG_ENCOUNTER_NBR DOUBLE Y The identifier of the organization that the encounter occurred within.
PARTITION_DT_TM DATETIME Y A column used to partition the table by. The date is generated based upon when the encounter was discharged.
PATIENT_ID DOUBLE Y The id used within the Cerner Health Facts Data Warehouse to join to the patient dim table for additional person information such as gender, race, and marital status. Patient sk on the dim table identifies the unique person.
PATIENT_TYPE_ID DOUBLE Y A unique identifier used to join the patient_type dimension table to the hf_f_encounter table.
PAYER_ID DOUBLE Y A unique identifier used to link the payer dimension table to the hf_f_encounter table.
RAW_MEDICAL_RECORD_NBR VARCHAR(40) Y The unformatted Medical Record Number of the encounter.
TOTAL_CHARGES DOUBLE Y The total charges ($) for the encounter. Total Charges includes both covered and non-covered charges. If summarizing total charges, use the encounters where total charges is not NULL or zero (0) as the population. If NULL that means billing was not received.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
UPDT_TASK VARCHAR(40) Y The registered (assigned) task number for the process that inserted or updated the row.
UPDT_USER VARCHAR(40) Y The application that performed the insert or update on this record. If this was done manually, MANUAL should be entered.
WEIGHT DOUBLE Y The weight of the patient. Weight is sparsely populated. Many of the weights extracted are 0 or NULL. Those that are populated should be used with reservation. Also check the clinical event table for addition weights if available.
WEIGHT_UNIT_ID DOUBLE Y A unique identifier used to link the unit dimension table to the encounter fact table. This field defines the unit for the weight entered.


HF_F_ENC_HISTORY



Column Section Top of Page


Table-level Detail

Description: HF_F_ENC_HISTORY
Definition: Contains the history of location, encntr type, med service, and alt level of care changes for a specific encounter.
Table Type: REFERENCE





Column Detail - HF_F_ENC_HISTORY


Column Name Type Null? Definition
BEGIN_DT_ID DOUBLE Y A date id is a unique identifier used to link the hf_f_enc_history table to the date table.
BEGIN_DT_TM DATETIME Y The beginning date and time when the person was at this location during the encounter.
CARESETTING_ID DOUBLE Y The patient caresetting (location). A unique identifier used to link the caresetting dimension table to the hf_f_enc_history table.
DISCHARGED_DT_TM DATETIME Y Used internally to identify which month/quarter the encounter occurred in. The original discharge date time. However, there is a small chance that the discharged_dt_tm on this fact does not match the discharged_dt_tm on the hf_f_encounter table.
ENCOUNTER_ID DOUBLE Y The visit identifier for the encounter.
END_DT_ID DOUBLE Y A date id is a unique identifier used to link the hf_f_enc_history table to the date table.
END_DT_TM DATETIME Y The end date and time when the person was at this location during the encounter.
ESTIMATE_IND DOUBLE Y Indicates that the times of the history are estimates.
HOSPITAL_ID DOUBLE Y The identifier for the hospital in which the encounter occurred.
PARTITION_DT_TM DATETIME Y A column used to partition the table by. The date is generated based upon when the encounter was discharged.
PATIENT_TYPE_ID DOUBLE Y A unique identifier used to join the patient_type dimension table to the hf_f_encounter table.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
UPDT_TASK VARCHAR(40) Y The registered (assigned) task number for the process that inserted or updated the row.
UPDT_USER VARCHAR(40) Y The application that performed the insert or update on this record. If this was done manually, MANUAL should be entered.