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