Table Detail Report
HF_D_RESULT_UNIT
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_RESULT_UNIT |
Definition: | HF_D_RESULT_UNIT table |
Table Type: | REFERENCE |
Column Detail - HF_D_RESULT_UNIT
Column Name | Type | Null? | Definition |
---|---|---|---|
RESULT_UNIT_DESC | VARCHAR(60) | Y | The description for the result unit |
RESULT_UNIT_ID | DOUBLE | Y | Primary key to the table. Uniquely defines a result unit |
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_ROUTE_ADMIN
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_ROUTE_ADMIN |
Definition: | This is the HealthFacts dimension table that contains standard values for medication administration routes |
Table Type: | REFERENCE |
Column Detail - HF_D_ROUTE_ADMIN
Column Name | Type | Null? | Definition |
---|---|---|---|
ROUTE_ADMIN_DESCRIPTION | VARCHAR(60) | Y | The full description of the administration route |
ROUTE_ADMIN_DISPLAY | VARCHAR(25) | Y | A short description for the administration route |
ROUTE_ADMIN_ID | DOUBLE | N | Primary key to the table. Uniquely defines an administration route |
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_SECTION
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_SECTION |
Definition: | HF_D_SECTION table |
Table Type: | REFERENCE |
Column Detail - HF_D_SECTION
Column Name | Type | Null? | Definition |
---|---|---|---|
SECTION_DESC | VARCHAR(40) | Y | The section description for the service resource |
SECTION_ID | DOUBLE | Y | Primary key to the table. Uniquely defines a service resource section record |
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_TEST_TYPE
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_Test_Type |
Definition: | This is the HealthFacts dimension table that contains standard values for susceptibility test types |
Table Type: | REFERENCE |
Column Detail - HF_D_TEST_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
TEST_TYPE_DESC | VARCHAR(40) | Y | The textual description for the type of susceptibility test (Minimum Inhibitory Concentration, Kirby Bauer, etc.) |
TEST_TYPE_ID | DOUBLE | Y | A unique non-intelligent identifier for the table |
TEST_TYPE_MNEMONIC | VARCHAR(25) | Y | A standard abbreviation for the type of susceptibility test (MIC, KB, etc.) |
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_UNIT
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_UNIT |
Definition: | This is the HealthFacts dimension table that contains standard values for unit of measure |
Table Type: | REFERENCE |
Column Detail - HF_D_UNIT
Column Name | Type | Null? | Definition |
---|---|---|---|
UCUM_IND | DOUBLE | Y | An indicator that will be used for the Health Data mapping tool to help find records that have a standard UCUM definition. |
UCUM_LONG_DESC | VARCHAR(250) | Y | The UCUM standard long description for the unit of measure. |
UNIT_DESC | VARCHAR(60) | Y | A description of the unit of measure. |
UNIT_DISPLAY | VARCHAR(20) | Y | The display of the unit of measure |
UNIT_ID | DOUBLE | Y | Primary key to the table. Uniquely defines a unit of measure |
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. |