Table Detail Report

WH_WRK_FCT_CE_SUS



Column Section Top of Page


Table-level Detail

Description: WH_WRK_FCT_CE_SUS
Definition: This is a Health Sentry Work table for processing clinical events for susceptibilty
Table Type: REFERENCE





Column Detail - WH_WRK_FCT_CE_SUS


Column Name Type Null? Definition
ABNORMAL_FLG DOUBLE Y Flag to identify abnormal results. 0 = Normal; 1 = Abnormal
ACCESSION VARCHAR(100) Y ACCESSION field
ALPHA_NUMERIC_RESULT_REF VARCHAR(40) Y ALPHA_NUMERIC_RESULT_REF field
ANTIBIOTIC_MEDICATION_REF VARCHAR(40) Y ANTIBIOTIC_MEDICATION_REF field
DETAIL_TEST_TYPE_REF VARCHAR(40) Y DETAIL_TEST_TYPE_REF field
DISCH_DT_TM DATETIME Y DISCH_DT_TM field
EVENT_SK VARCHAR(100) Y EVENT_SK field
FIRST_CTNR_COLL_METHOD_REF VARCHAR(40) Y FIRST_CTNR_COLL_METHOD_REF field
FIRST_SPECIMEN_SITE_REF VARCHAR(40) Y FIRST_SPECIMEN_SITE_REF field
FIRST_SPECIMEN_TYPE_REF VARCHAR(40) Y FIRST_SPECIMEN_TYPE_REF field
FRST_PERF_SVC_RES_DEPT_HIER_SK VARCHAR(40) Y FRST_PERF_SVC_RES_DEPT_HIER_SK field
HEALTH_SYSTEM_ID DOUBLE Y HEALTH_SYSTEM_ID field
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y HEALTH_SYSTEM_SOURCE_ID field
HOSPITAL_ID DOUBLE Y HOSPITAL_ID field
INTERFACE_IND DOUBLE Y INTERFACE_IND field
INTERPRETATION_RESULT_REF VARCHAR(40) Y INTERPRETATION_RESULT_REF field
MICRO_ORDER_KEY VARCHAR(40) Y MICRO_ORDER_KEY field
MICRO_TASK_KEY DOUBLE Y MICRO_TASK_KEY field
NUMERIC_RESULT DOUBLE Y NUMERIC_RESULT field
ORDER_ORDBL VARCHAR(40) Y ORDER_ORDBL field
ORGANISM_REF VARCHAR(40) Y ORGANISM_REF field
PARTITION_DT_TM DATETIME Y PARTITION_DT_TM field
PERFORMED_DT_TM DATETIME Y PERFORMED_DT_TM field
PERFORMED_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
PERFORMED_TM_ZN DOUBLE Y PERFORMED_TM_ZN field
RESULT_TXT VARCHAR(100) Y RESULT_TXT field
RESULT_TYPE_FLG DOUBLE Y This field identifies a code value that determines the result type (Interp/Numeric) associated with the detail susceptibility procedure. The task type further categorizes similar detail susceptibility procedures. 6 - Numeric sus detail 7 - Interp sus detail 14 - Alpha sus detail"
RESULT_UNIT_REF VARCHAR(40) Y RESULT_UNIT_REF field
SOURCE_FLG DOUBLE Y The HIS system or interface being used to send us the data extract. 0 = Unknown; 1 = Classic; 2 = MSMeds; 3 = HNAM; 4 = HL7; 5 = Foreign System; 6 = CoPath; 7 = Critical Outcomes - Apache; 8 = Critical Outcomes - Project Impact; 9 = Critical Outcomes - Web; 10 = Critical Outcomes - HNAM; 11 = PI Third Party XML File; 12 = Shell Record; 13 = PI Defined Record; 14 = Healthe Analytics
SPECIFIC_SOURCE VARCHAR(40) Y SPECIFIC_SOURCE field
TASK_REF VARCHAR(40) Y TASK_REF field
TASK_SEQ DOUBLE Y TASK_SEQ field
TASK_TYPE_FLG DOUBLE Y TASK_TYPE_FLG field
VERIFIED_DT_TM DATETIME Y VERIFIED_DT_TM field
VERIFIED_PRSNL VARCHAR(40) Y VERIFIED_PRSNL field
VERIFIED_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
VERIFIED_TM_ZN DOUBLE Y VERIFIED_TM_ZN field
VISIT_ID DOUBLE Y VISIT_ID field


WH_WRK_FCT_CLNEVNT



Column Section Top of Page


Table-level Detail

Description: WH_WRK_FCT_CLNEVNT
Definition: This is a Health Sentry Work table for processing clinical events.
Table Type: REFERENCE





Column Detail - WH_WRK_FCT_CLNEVNT


Column Name Type Null? Definition
ACCESSION VARCHAR(100) Y ACCESSION field
CANCELED_DT_TM DATETIME Y CANCELED_DT_TM field
CANCELED_TM_ZN DOUBLE Y CANCELED_TM_ZN field
CANCEL_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
COMPLETED_DT_TM DATETIME Y COMPLETED_DT_TM field
COMPLETED_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
COMPLETED_TM_ZN DOUBLE Y COMPLETED_TM_ZN field
CRITICAL_REF VARCHAR(40) Y CRITICAL_REF field
DELTA_REF VARCHAR(40) Y DELTA_REF field
DISCH_DT_TM DATETIME Y DISCH_DT_TM field
EVENT_SK VARCHAR(100) Y EVENT_SK field
FEASIBLE_REF VARCHAR(40) Y FEASIBLE_REF field
FIRST_CNTR_TYPE_REF VARCHAR(40) Y FIRST_CNTR_TYPE_REF field
FIRST_CTNR_COLL_METHOD_REF VARCHAR(40) Y FIRST_CTNR_COLL_METHOD_REF field
FIRST_CTNR_DRAWN_DT_TM DATETIME Y FIRST_CTNR_DRAWN_DT_TM field
FIRST_CTNR_DRAWN_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
FIRST_CTNR_DRAWN_TM_ZN DOUBLE Y FIRST_CTNR_DRAWN_TM_ZN field
FIRST_CTNR_RECEIVED_DT_TM DATETIME Y FIRST_CTNR_RECEIVED_DT_TM field
FIRST_CTNR_RECEIVED_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
FIRST_CTNR_RECEIVED_TM_ZN DOUBLE Y FIRST_CTNR_RECEIVED_TM_ZN field
FIRST_SPECIMEN_SITE_REF VARCHAR(40) Y FIRST_SPECIMEN_SITE_REF field
FIRST_SPECIMEN_TYPE_REF VARCHAR(40) Y FIRST_SPECIMEN_TYPE_REF field
GO_HEALTH_SYSTEM_ID DOUBLE Y GO_HEALTH_SYSTEM_ID field
GO_HEALTH_SYSTEM_SOURCE_ID DOUBLE Y GO_HEALTH_SYSTEM_SOURCE_ID field
HEALTH_SYSTEM_ID DOUBLE Y HEALTH_SYSTEM_ID field
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y HEALTH_SYSTEM_SOURCE_ID field
HF_NORMAL_HIGH VARCHAR(40) Y HF_NORMAL_HIGH field
HF_NORMAL_LOW VARCHAR(40) Y HF_NORMAL_LOW field
HOSPITAL_ID DOUBLE Y HOSPITAL_ID field
INTERFACE_IND DOUBLE Y INTERFACE_IND field
LAST_PROCESS_DT_TM DATETIME Y LAST_PROCESS_DT_TM field
LINEAR_REF VARCHAR(40) Y LINEAR_REF field
NORMAL_ALPHA VARCHAR(200) Y NORMAL_ALPHA field
NORMAL_REF VARCHAR(40) Y NORMAL_REF field
ORDER_DOC_PRSNL VARCHAR(40) Y ORDER_DOC_PRSNL field
ORDER_DT_TM DATETIME Y ORDER_DT_TM field
ORDER_ORDBL VARCHAR(40) Y ORDER_ORDBL field
ORDER_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
ORDER_TM_ZN DOUBLE Y ORDER_TM_ZN field
O_HEALTH_SYSTEM_ID DOUBLE Y O_HEALTH_SYSTEM_ID field
O_HEALTH_SYSTEM_SOURCE_ID DOUBLE Y O_HEALTH_SYSTEM_SOURCE_ID field
O_SOURCE_FLG DOUBLE Y O_SOURCE_FLG field
PARTITION_DT_TM DATETIME Y PARTITION_DT_TM field
PATIENT_LOC_NURSE_UNIT_SK VARCHAR(40) Y PATIENT_LOC_NURSE_UNIT_SK field
PERFORM_DT_TM DATETIME Y PERFORM_DT_TM field
PERFORM_LOC_INST VARCHAR(40) Y PERFORM_LOC_INST field
PERFORM_SVC_RES_DEPT_HIER_SK VARCHAR(40) Y PERFORM_SVC_RES_DEPT_HIER_SK field
PERFORM_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
PERFORM_TM_ZN DOUBLE Y PERFORM_TM_ZN field
REPORTING_PRIORITY_REF VARCHAR(40) Y REPORTING_PRIORITY_REF field
RESULT_FLG_REF VARCHAR(40) Y RESULT_FLG_REF field
RESULT_TYPE_REF VARCHAR(40) Y RESULT_TYPE_REF field
RESULT_VALUE_DT_TM DATETIME Y RESULT_VALUE_DT_TM field
RESULT_VALUE_FORMATTED VARCHAR(2000) Y RESULT_VALUE_FORMATTED field
RESULT_VALUE_NUMERIC VARCHAR(2000) Y RESULT_VALUE_NUMERIC field
RESULT_VALUE_UNIT_REF VARCHAR(40) Y RESULT_VALUE_UNIT_REF field
REVIEW_REF VARCHAR(40) Y REVIEW_REF field
SOURCE_FLG DOUBLE Y The HIS system or interface being used to send us the data extract. 0 = Unknown; 1 = Classic; 2 = MSMeds; 3 = HNAM; 4 = HL7; 5 = Foreign System; 6 = CoPath; 7 = Critical Outcomes - Apache; 8 = Critical Outcomes - Project Impact; 9 = Critical Outcomes - Web; 10 = Critical Outcomes - HNAM; 11 = PI Third Party XML File; 12 = Shell Record; 13 = PI Defined Record; 14 = Healthe Analytics
SRC_GEN_LAB_ORDER_KEY VARCHAR(100) Y SRC_GEN_LAB_ORDER_KEY field
TASK_ASSAY_SK VARCHAR(40) Y TASK_ASSAY_SK field
VERIFIED_DT_TM DATETIME Y VERIFIED_DT_TM field
VERIFIED_PRSNL VARCHAR(40) Y VERIFIED_PRSNL field
VERIFIED_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
VERIFIED_TM_ZN DOUBLE Y VERIFIED_TM_ZN field
VISIT_ID DOUBLE Y VISIT_ID field


WH_WRK_FCT_ENCOUNTER



Column Section Top of Page


Table-level Detail

Description: WH_WRK_FCT_ENCOUNTER
Definition: This is a Health Sentry Work table for processing encounters
Table Type: REFERENCE





Column Detail - WH_WRK_FCT_ENCOUNTER


Column Name Type Null? Definition
ADMIT_DT DATETIME Y ADMIT_DT field
ADMIT_DT_TM DATETIME Y ADMIT_DT_TM field
ADMIT_LOC_NURSE_UNIT_REF VARCHAR(40) Y ADMIT_LOC_NURSE_UNIT_REF field
ADMIT_MODE_REF VARCHAR(40) Y ADMIT_MODE_REF field
ADMIT_SOURCE_REF VARCHAR(40) Y ADMIT_SOURCE_REF field
ADMIT_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
ADMIT_TM_ZN DOUBLE Y ADMIT_TM_ZN field
ADMIT_TYPE_REF VARCHAR(40) Y ADMIT_TYPE_REF field
AGE_IN_DAYS DOUBLE Y AGE_IN_DAYS field
AGE_IN_YEARS DOUBLE Y AGE_IN_YEARS field
CURRENT_LOC_INSTITUTION_REF VARCHAR(40) Y CURRENT_LOC_INSTITUTION_REF field
CURRENT_LOC_NURSE_UNIT_REF VARCHAR(40) Y CURRENT_LOC_NURSE_UNIT_REF field
DISCHARGE_DISPOSITION_REF VARCHAR(40) Y DISCHARGE_DISPOSITION_REF field
DISCHARGE_DT DATETIME Y DISCHARGE_DT field
DISCHARGE_DT_TM DATETIME Y DISCHARGE_DT_TM field
DISCHARGE_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
DISCHARGE_TM_ZN DOUBLE Y DISCHARGE_TM_ZN field
DISCHARGE_TO_LOC_REF VARCHAR(40) Y DISCHARGE_TO_LOC_REF field
ENCOUNTER_CLASS_REF VARCHAR(40) Y ENCOUNTER_CLASS_REF field
ENCOUNTER_KEY DOUBLE Y ENCOUNTER_KEY field
ENCOUNTER_SK VARCHAR(40) Y ENCOUNTER_SK field
ENCOUNTER_TYPE_CLASS_REF VARCHAR(40) Y ENCOUNTER_TYPE_CLASS_REF field
EXTRACT_DT_TM DATETIME Y EXTRACT_DT_TM field
FINANCIAL_CLASS_REF VARCHAR(40) Y FINANCIAL_CLASS_REF field
FINANCIAL_NBR VARCHAR(40) Y FINANCIAL_NBR field
FINANCIAL_NBR_RAW VARCHAR(40) Y FINANCIAL_NBR_RAW field
FIRST_PROCESS_DT_TM DATETIME Y FIRST_PROCESS_DT_TM field
FORMATTED_MEDICAL_RECORD_NBR VARCHAR(40) Y FORMATTED_MEDICAL_RECORD_NBR field
HEALTH_SYSTEM_ID DOUBLE Y HEALTH_SYSTEM_ID field
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y HEALTH_SYSTEM_SOURCE_ID field
HF_CALC_DRG VARCHAR(3) Y HF_CALC_DRG field
HF_CALC_MDC VARCHAR(2) Y HF_CALC_MDC field
HF_ROLLUP_INSTITUTION_REF VARCHAR(40) Y HF_ROLLUP_INSTITUTION_REF field
LAST_PROCESS_DT_TM DATETIME Y LAST_PROCESS_DT_TM field
MEDICAL_RECORD_NBR_RAW VARCHAR(40) Y MEDICAL_RECORD_NBR_RAW field
MEDICAL_SERVICE_REF VARCHAR(40) Y MEDICAL_SERVICE_REF field
NEXT_VISIT_FIRST_PROCESS_DT_TM DATETIME Y NEXT_VISIT_FIRST_PROCESS_DT_TM field
PARTITION_DT_TM DATETIME Y PARTITION_DT_TM field
PATIENT_TYPE_REF VARCHAR(40) Y PATIENT_TYPE_REF field
PERSON_KEY DOUBLE Y PERSON_KEY field
PERSON_SK VARCHAR(40) Y PERSON_SK field
SOURCE_FLG DOUBLE Y The HIS system or interface being used to send us the data extract. 0 = Unknown; 1 = Classic; 2 = MSMeds; 3 = HNAM; 4 = HL7; 5 = Foreign System; 6 = CoPath; 7 = Critical Outcomes - Apache; 8 = Critical Outcomes - Project Impact; 9 = Critical Outcomes - Web; 10 = Critical Outcomes - HNAM; 11 = PI Third Party XML File; 12 = Shell Record; 13 = PI Defined Record; 14 = Healthe Analytics
TOTAL_CHARGE_AMT DOUBLE Y TOTAL_CHARGE_AMT field
VISIT_FIRST_PROCESS_DT_TM DATETIME Y VISIT_FIRST_PROCESS_DT_TM field
VISIT_KEY DOUBLE Y VISIT_KEY field
WEIGHT DOUBLE Y WEIGHT field
WEIGHT_UNIT VARCHAR(40) Y WEIGHT_UNIT field


WH_WRK_FCT_ENCOUNTER1



Column Section Top of Page


Table-level Detail

Description: WH_WRK_FCT_ENCOUNTER1
Definition: This is a Health Sentry Work table for processing encounters
Table Type: REFERENCE





Column Detail - WH_WRK_FCT_ENCOUNTER1


Column Name Type Null? Definition
ADMIT_DT DATETIME Y ADMIT_DT field
ADMIT_DT_TM DATETIME Y ADMIT_DT_TM field
ADMIT_LOC_NURSE_UNIT_REF VARCHAR(40) Y ADMIT_LOC_NURSE_UNIT_REF field
ADMIT_MODE_REF VARCHAR(40) Y ADMIT_MODE_REF field
ADMIT_SOURCE_REF VARCHAR(40) Y ADMIT_SOURCE_REF field
ADMIT_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
ADMIT_TM_ZN DOUBLE Y ADMIT_TM_ZN field
ADMIT_TYPE_REF VARCHAR(40) Y ADMIT_TYPE_REF field
AGE_IN_DAYS DOUBLE Y AGE_IN_DAYS field
AGE_IN_YEARS DOUBLE Y AGE_IN_YEARS field
CURRENT_LOC_INSTITUTION_REF VARCHAR(40) Y CURRENT_LOC_INSTITUTION_REF field
CURRENT_LOC_NURSE_UNIT_REF VARCHAR(40) Y CURRENT_LOC_NURSE_UNIT_REF field
DISCHARGE_DISPOSITION_REF VARCHAR(40) Y DISCHARGE_DISPOSITION_REF field
DISCHARGE_DT DATETIME Y DISCHARGE_DT field
DISCHARGE_DT_TM DATETIME Y DISCHARGE_DT_TM field
DISCHARGE_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
DISCHARGE_TM_ZN DOUBLE Y DISCHARGE_TM_ZN field
DISCHARGE_TO_LOC_REF VARCHAR(40) Y DISCHARGE_TO_LOC_REF field
ENCOUNTER_CLASS_REF VARCHAR(40) Y ENCOUNTER_CLASS_REF field
ENCOUNTER_KEY DOUBLE Y ENCOUNTER_KEY field
ENCOUNTER_SK VARCHAR(40) Y ENCOUNTER_SK field
ENCOUNTER_TYPE_CLASS_REF VARCHAR(40) Y ENCOUNTER_TYPE_CLASS_REF field
EXTRACT_DT_TM DATETIME Y EXTRACT_DT_TM field
FINANCIAL_CLASS_REF VARCHAR(40) Y FINANCIAL_CLASS_REF field
FINANCIAL_NBR VARCHAR(40) Y FINANCIAL_NBR field
FINANCIAL_NBR_RAW VARCHAR(40) Y FINANCIAL_NBR_RAW field
FIRST_PROCESS_DT_TM DATETIME Y FIRST_PROCESS_DT_TM field
FORMATTED_MEDICAL_RECORD_NBR VARCHAR(40) Y FORMATTED_MEDICAL_RECORD_NBR field
HEALTH_SYSTEM_ID DOUBLE Y HEALTH_SYSTEM_ID field
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y HEALTH_SYSTEM_SOURCE_ID field
HF_CALC_DRG VARCHAR(3) Y HF_CALC_DRG field
HF_CALC_MDC VARCHAR(2) Y HF_CALC_MDC field
HF_ROLLUP_INSTITUTION_REF VARCHAR(40) Y HF_ROLLUP_INSTITUTION_REF field
LAST_PROCESS_DT_TM DATETIME Y LAST_PROCESS_DT_TM field
MEDICAL_RECORD_NBR_RAW VARCHAR(40) Y MEDICAL_RECORD_NBR_RAW field
MEDICAL_SERVICE_REF VARCHAR(40) Y MEDICAL_SERVICE_REF field
NEXT_VISIT_FIRST_PROCESS_DT_TM DATETIME Y NEXT_VISIT_FIRST_PROCESS_DT_TM field
PARTITION_DT_TM DATETIME Y PARTITION_DT_TM field
PATIENT_TYPE_REF VARCHAR(40) Y PATIENT_TYPE_REF field
PERSON_KEY DOUBLE Y PERSON_KEY field
PERSON_SK VARCHAR(40) Y PERSON_SK field
SOURCE_FLG DOUBLE Y The HIS system or interface being used to send us the data extract. 0 = Unknown; 1 = Classic; 2 = MSMeds; 3 = HNAM; 4 = HL7; 5 = Foreign System; 6 = CoPath; 7 = Critical Outcomes - Apache; 8 = Critical Outcomes - Project Impact; 9 = Critical Outcomes - Web; 10 = Critical Outcomes - HNAM; 11 = PI Third Party XML File; 12 = Shell Record; 13 = PI Defined Record; 14 = Healthe Analytics
TOTAL_CHARGE_AMT DOUBLE Y TOTAL_CHARGE_AMT field
VISIT_FIRST_PROCESS_DT_TM DATETIME Y VISIT_FIRST_PROCESS_DT_TM field
VISIT_KEY DOUBLE Y VISIT_KEY field
WEIGHT DOUBLE Y WEIGHT field
WEIGHT_UNIT VARCHAR(40) Y WEIGHT_UNIT field


WH_WRK_FCT_ENCOUNTER2



Column Section Top of Page


Table-level Detail

Description: WH_WRK_FCT_ENCOUNTER2
Definition: This is a Health Sentry Work table for processing encounters
Table Type: REFERENCE





Column Detail - WH_WRK_FCT_ENCOUNTER2


Column Name Type Null? Definition
ADMIT_DT DATETIME Y ADMIT_DT field
ADMIT_DT_TM DATETIME Y ADMIT_DT_TM field
ADMIT_LOC_NURSE_UNIT_REF VARCHAR(40) Y ADMIT_LOC_NURSE_UNIT_REF field
ADMIT_MODE_REF VARCHAR(40) Y ADMIT_MODE_REF field
ADMIT_SOURCE_REF VARCHAR(40) Y ADMIT_SOURCE_REF field
ADMIT_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
ADMIT_TM_ZN DOUBLE Y ADMIT_TM_ZN field
ADMIT_TYPE_REF VARCHAR(40) Y ADMIT_TYPE_REF field
AGE_IN_DAYS DOUBLE Y AGE_IN_DAYS field
AGE_IN_YEARS DOUBLE Y AGE_IN_YEARS field
CURRENT_LOC_INSTITUTION_REF VARCHAR(40) Y CURRENT_LOC_INSTITUTION_REF field
CURRENT_LOC_NURSE_UNIT_REF VARCHAR(40) Y CURRENT_LOC_NURSE_UNIT_REF field
DISCHARGE_DISPOSITION_REF VARCHAR(40) Y DISCHARGE_DISPOSITION_REF field
DISCHARGE_DT DATETIME Y DISCHARGE_DT field
DISCHARGE_DT_TM DATETIME Y DISCHARGE_DT_TM field
DISCHARGE_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
DISCHARGE_TM_ZN DOUBLE Y DISCHARGE_TM_ZN field
DISCHARGE_TO_LOC_REF VARCHAR(40) Y DISCHARGE_TO_LOC_REF field
ENCOUNTER_CLASS_REF VARCHAR(40) Y ENCOUNTER_CLASS_REF field
ENCOUNTER_KEY DOUBLE Y ENCOUNTER_KEY field
ENCOUNTER_SK VARCHAR(40) Y ENCOUNTER_SK field
ENCOUNTER_TYPE_CLASS_REF VARCHAR(40) Y ENCOUNTER_TYPE_CLASS_REF field
EXTRACT_DT_TM DATETIME Y EXTRACT_DT_TM field
FINANCIAL_CLASS_REF VARCHAR(40) Y FINANCIAL_CLASS_REF field
FINANCIAL_NBR VARCHAR(40) Y FINANCIAL_NBR field
FINANCIAL_NBR_RAW VARCHAR(40) Y FINANCIAL_NBR_RAW field
FIRST_PROCESS_DT_TM DATETIME Y FIRST_PROCESS_DT_TM field
FORMATTED_MEDICAL_RECORD_NBR VARCHAR(40) Y FORMATTED_MEDICAL_RECORD_NBR field
HEALTH_SYSTEM_ID DOUBLE Y HEALTH_SYSTEM_ID field
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y HEALTH_SYSTEM_SOURCE_ID field
HF_CALC_DRG VARCHAR(3) Y HF_CALC_DRG field
HF_CALC_MDC VARCHAR(2) Y HF_CALC_MDC field
HF_ROLLUP_INSTITUTION_REF VARCHAR(40) Y HF_ROLLUP_INSTITUTION_REF field
LAST_PROCESS_DT_TM DATETIME Y LAST_PROCESS_DT_TM field
MEDICAL_RECORD_NBR_RAW VARCHAR(40) Y MEDICAL_RECORD_NBR_RAW field
MEDICAL_SERVICE_REF VARCHAR(40) Y MEDICAL_SERVICE_REF field
NEXT_VISIT_FIRST_PROCESS_DT_TM DATETIME Y NEXT_VISIT_FIRST_PROCESS_DT_TM field
PARTITION_DT_TM DATETIME Y PARTITION_DT_TM field
PATIENT_TYPE_REF VARCHAR(40) Y PATIENT_TYPE_REF field
PERSON_KEY DOUBLE Y PERSON_KEY field
PERSON_SK VARCHAR(40) Y PERSON_SK field
SOURCE_FLG DOUBLE Y The HIS system or interface being used to send us the data extract. 0 = Unknown; 1 = Classic; 2 = MSMeds; 3 = HNAM; 4 = HL7; 5 = Foreign System; 6 = CoPath; 7 = Critical Outcomes - Apache; 8 = Critical Outcomes - Project Impact; 9 = Critical Outcomes - Web; 10 = Critical Outcomes - HNAM; 11 = PI Third Party XML File; 12 = Shell Record; 13 = PI Defined Record; 14 = Healthe Analytics
TOTAL_CHARGE_AMT DOUBLE Y TOTAL_CHARGE_AMT field
VISIT_FIRST_PROCESS_DT_TM DATETIME Y VISIT_FIRST_PROCESS_DT_TM field
VISIT_KEY DOUBLE Y VISIT_KEY field
WEIGHT DOUBLE Y WEIGHT field
WEIGHT_UNIT VARCHAR(40) Y WEIGHT_UNIT field