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 |