Table Detail Report

HF_D_REPORTING_PRIORITY



Column Section Top of Page


Table-level Detail

Description: HF_D_Reporting_Priority
Definition: This is the HealthFacts dimension table that contains standard values for lab reporting priorities
Table Type: REFERENCE





Column Detail - HF_D_REPORTING_PRIORITY


Column Name Type Null? Definition
REPORTING_PRIORITY_CODE VARCHAR(12) Y A short description of the reporting priority (ASAP)
REPORTING_PRIORITY_DESC VARCHAR(60) Y The textual description of the reporting priority (As Soon As Possible)
REPORTING_PRIORITY_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_RESULT_INDICATOR



Column Section Top of Page


Table-level Detail

Description: HF_D_Result_Indicator
Definition: This is the HealthFacts dimension table that contains standard values for the normalcy of gen lab results
Table Type: REFERENCE





Column Detail - HF_D_RESULT_INDICATOR


Column Name Type Null? Definition
PHIN_CODE VARCHAR(10) Y PHINVADs is expecting a specific code for valid nursing units. Only records that match the PHINVads table will be populated.
PHIN_CONCEPT_DESC VARCHAR(100) Y PHINVADs has defined long descriptions for abnormal flags. This translates the Health Data values to a standard concept description for HL7.
RESULT_INDICATOR_DESC VARCHAR(60) Y The textual description of the normality of the result (out of range, not normal, etc.)
RESULT_INDICATOR_ID DOUBLE Y A unique non-intelligent identifier for the table
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_RESULT_TIME_UNIT



Column Section Top of Page


Table-level Detail

Description: HF_D_RESULT_TIME_UNIT
Definition: HF_D_RESULT_TIME_UNIT table
Table Type: REFERENCE





Column Detail - HF_D_RESULT_TIME_UNIT


Column Name Type Null? Definition
RESULT_TIME_UNIT_DESC VARCHAR(60) Y The description for the result unit
RESULT_TIME_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_RESULT_TYPE_PROC



Column Section Top of Page


Table-level Detail

Description: HF_D_Result_Type_Proc
Definition: This is the HealthFacts dimension table that contains standard values for the type of a result a procedure represents
Table Type: REFERENCE





Column Detail - HF_D_RESULT_TYPE_PROC


Column Name Type Null? Definition
RESULT_TYPE_PROC_DESC VARCHAR(60) Y A textual description of the detail procedure/report (preliminary, final, etc.)
RESULT_TYPE_PROC_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_RESULT_TYPE_SUSC



Column Section Top of Page


Table-level Detail

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





Column Detail - HF_D_RESULT_TYPE_SUSC


Column Name Type Null? Definition
SUSC_RESULT_TYPE_DESC VARCHAR(25) Y The description of the susceptibility result type (Numeric, Interp, Alpha/Numeric)
SUSC_RESULT_TYPE_ID DOUBLE N Primary key to 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.