Table Detail Report

WH_WRK_FCT_KEYS



Column Section Top of Page


Table-level Detail

Description: WH_WRK_FCT_KEYS
Definition: This is a Health Sentry Work table for processing fact keys
Table Type: REFERENCE





Column Detail - WH_WRK_FCT_KEYS


Column Name Type Null? Definition
DIAGNOSIS_KEY DOUBLE Y DIAGNOSIS_KEY field
ENCOUNTER_KEY DOUBLE Y ENCOUNTER_KEY field
GEN_LAB_ORDER_KEY DOUBLE Y GEN_LAB_ORDER_KEY field
GEN_LAB_RESULT_KEY DOUBLE Y GEN_LAB_RESULT_KEY field
MICRO_ORDER_KEY DOUBLE Y MICRO_ORDER_KEY field
MICRO_REPORT_RESPONSE_KEY DOUBLE Y MICRO_REPORT_RESPONSE_KEY field
MICRO_TASK_KEY DOUBLE Y MICRO_TASK_KEY field
ORDER_KEY DOUBLE Y ORDER_KEY field
PHARM_DSP_HIST_KEY DOUBLE Y PHARM_DSP_HIST_KEY field
PHARM_ORDER_KEY DOUBLE Y PHARM_ORDER_KEY field
PHARM_ORD_INGRED_KEY DOUBLE Y PHARM_ORD_INGRED_KEY field
PHARM_ORD_PRODUCT_KEY DOUBLE Y PHARM_ORD_PRODUCT_KEY field
PHARM_PRD_DSP_HIST_KEY DOUBLE Y PHARM_PRD_DSP_HIST_KEY field
PROCEDURE_KEY DOUBLE Y PROCEDURE_KEY field
SUSCEPT_RESULTS_KEY DOUBLE Y SUSCEPT_RESULTS_KEY field


WH_WRK_FCT_MICRO_RESPONSE



Column Section Top of Page


Table-level Detail

Description: WH_WRK_FCT_MICRO_RESPONSE
Definition: This is a Health Sentry Work table for processing microbiology response
Table Type: REFERENCE





Column Detail - WH_WRK_FCT_MICRO_RESPONSE


Column Name Type Null? Definition
ABNORMAL_IND DOUBLE Y ABNORMAL_IND field
FALSE_POSITIVE_IND DOUBLE Y FALSE_POSITIVE_IND field
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y HEALTH_SYSTEM_SOURCE_ID field
MICRO_REPORT_RESPONSE_KEY DOUBLE Y MICRO_REPORT_RESPONSE_KEY field
MICRO_RESPONSE_SEQUENCE DOUBLE Y MICRO_RESPONSE_SEQUENCE field
MICRO_TASK_KEY DOUBLE Y MICRO_TASK_KEY field
ORGANISM_REF VARCHAR(40) Y ORGANISM_REF field
ORG_TASK_LOG_SK VARCHAR(100) Y ORG_TASK_LOG_SK field
POSITIVE_IND DOUBLE Y POSITIVE_IND field
REPONSE_REF VARCHAR(40) Y REPONSE_REF field
RESPONSE_CLASS_FLG DOUBLE Y RESPONSE_CLASS_FLG field
RESPONSE_TEXT VARCHAR(255) Y RESPONSE_TEXT 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


WH_WRK_FCT_MICRO_TASK



Column Section Top of Page


Table-level Detail

Description: WH_WRK_FCT_MICRO_TASK
Definition: This is a Health Sentry Work table for processing microbiology task
Table Type: REFERENCE





Column Detail - WH_WRK_FCT_MICRO_TASK


Column Name Type Null? Definition
FIRST_OBSERVED_DT_TM DATETIME Y FIRST_OBSERVED_DT_TM field
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y HEALTH_SYSTEM_SOURCE_ID field
LAST_PROCESS_DT_TM DATETIME Y LAST_PROCESS_DT_TM field
MICRO_ORDER_KEY DOUBLE Y MICRO_ORDER_KEY field
MICRO_TASK_KEY DOUBLE Y MICRO_TASK_KEY field
MICRO_TASK_SK VARCHAR(100) Y MICRO_TASK_SK field
MOST_RECENT_TASK_IND DOUBLE Y MOST_RECENT_TASK_IND field
OBSERVED_DT_TM DATETIME Y OBSERVED_DT_TM field
OBSERVED_TM_ZN DOUBLE Y OBSERVED_TM_ZN field
ORGANISM_REF VARCHAR(40) Y ORGANISM_REF field
PARTITION_DT_TM DATETIME Y PARTITION_DT_TM field
REPORT_TYPE_REF VARCHAR(40) Y REPORT_TYPE_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
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_ZN DOUBLE Y VERIFIED_TM_ZN field