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 |