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.