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. |