Table Detail Report

HF_D_MED_ORDER_STATUS



Column Section Top of Page


Table-level Detail

Description: HF_D_MED_ORDER_STATUS
Definition: This is the HealthFacts dimension table that contains standard values for medication order status
Table Type: REFERENCE





Column Detail - HF_D_MED_ORDER_STATUS


Column Name Type Null? Definition
MED_ORDER_STATUS_DESC VARCHAR(60) Y The description for the medication order status
MED_ORDER_STATUS_ID DOUBLE Y Primary key to the table. Uniquely defines a medication order status
UPDT_DT_TM DATETIME Y The date/time that this record was updated.
UPDT_TASK VARCHAR(40) Y The application that performed the insert or update on this record. If this was done manually, 'MANUAL' should be entered.
UPDT_USER VARCHAR(40) Y The user id that performed the update or insert on this record.


HF_D_MICRO_RESULT_TYPE



Column Section Top of Page


Table-level Detail

Description: HF_D_Micro_Result_Type
Definition: This is the HealthFacts dimension table that contains standard values for micro result types
Table Type: REFERENCE





Column Detail - HF_D_MICRO_RESULT_TYPE


Column Name Type Null? Definition
MICRO_RESULT_TYPE_CODE DOUBLE Y An internal Health Facts identifier for the micro result type (the same as Task_Type_Flg in HNAM)
MICRO_RESULT_TYPE_DESC VARCHAR(60) Y The textual description of the micro result type (preliminary, final, amended, etc.)
MICRO_RESULT_TYPE_ID DOUBLE Y A unique non-intelligent identifier for the table
TEST_TYPE VARCHAR(20) Y Identifies the result as a microbiology or a susceptibility result
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.


HF_D_MIC_ORDER_STATUS



Column Section Top of Page


Table-level Detail

Description: HF_D_Mic_Order_Status
Definition: This is the HealthFacts dimension table that contains standard values for micro order statuses
Table Type: REFERENCE





Column Detail - HF_D_MIC_ORDER_STATUS


Column Name Type Null? Definition
MICRO_ORDER_STATUS_CODE DOUBLE Y An internal Health Facts identifier for a micro order status
MICRO_ORDER_STATUS_DESC VARCHAR(60) Y The textual description of the micro order status (preliminary report, final report, etc.)
MICRO_ORDER_STATUS_ID DOUBLE Y A unique non-intelligent identifier for the table
UPDT_DT_TM DATETIME Y The date/time that this record was updated.
UPDT_TASK VARCHAR(40) Y The application that performed the insert or update on this record. If this was done manually, 'MANUAL' should be entered.
UPDT_USER VARCHAR(40) Y The user id that performed the update or insert on this record.


HF_D_NORMALCY



Column Section Top of Page


Table-level Detail

Description: HF_D_NORMALCY
Definition: HF_D_NORMALCY table
Table Type: REFERENCE





Column Detail - HF_D_NORMALCY


Column Name Type Null? Definition
NORMALCY_DESC VARCHAR(60) Y The description for the event normalcy
NORMALCY_ID DOUBLE Y Primary key to the table. Uniquely defines an event normalcy
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.


HF_D_NORMALCY_METHOD



Column Section Top of Page


Table-level Detail

Description: HF_D_NORMALCY_METHOD
Definition: HF_D_NORMALCY_METHOD table
Table Type: REFERENCE





Column Detail - HF_D_NORMALCY_METHOD


Column Name Type Null? Definition
NORMALCY_METHOD_DESC VARCHAR(60) Y The description for the event normalcy method
NORMALCY_METHOD_ID DOUBLE Y Primary key to the table. Uniquely defines an event normalcy method
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.