Table Detail Report
HF_D_ISOLATE
Column Section | Top of Page |
Table-level Detail
Description: | health facts dimension isolates |
Definition: | This is the HealthFacts dimension table that contains standard values for isolates |
Table Type: | REFERENCE |
Column Detail - HF_D_ISOLATE
Column Name | Type | Null? | Definition |
---|---|---|---|
ALT_LOINC_CODE | VARCHAR(10) | Y | An alternate LOINC code that is not PHIN approved |
ANTIBIOGRAM_IND | DOUBLE | Y | Indicates if the isolate is commonly found on antibiograms |
ANTIBIOGRAM_NAME | VARCHAR(25) | Y | A short version of the isolate name used for antibiogram reporting purposes |
HEALTHAWARE_IND | DOUBLE | Y | Indicates if the record was generated via the HealthAware solution. |
ISOLATE_CATEGORY | VARCHAR(30) | Y | A high level category for the isolate. Generally this is the genus |
ISOLATE_CODE | DOUBLE | Y | No such field on this table. |
ISOLATE_GROUP | VARCHAR(30) | Y | Identifies the areas within an antibiogram report that a isolate should be displayed |
ISOLATE_ID | DOUBLE | Y | Primary key to the table. Uniquely defines an isolate |
ISOLATE_NAME | VARCHAR(50) | Y | The scientific name for the isolate |
ISOLATE_REPT_CATEGORY | VARCHAR(30) | Y | The reporting category for the isolate. Typically the genus; however sometimes this is at a finer grain than the genus |
ISOLATE_TYPE | VARCHAR(25) | Y | The type of isolate |
ODIN_IND | DOUBLE | Y | Indicates if the isolate is typically reportable |
PHIN_LOINC_CODE | VARCHAR(10) | Y | The PHIN approved LOINC codes used for reporting purposes |
SNOMEDCT_CODE | VARCHAR(15) | Y | A newer version of the SNOMED code. Only populated when the SNOMEDCT code is different from the SNOMED code |
SNOMED_CODE | VARCHAR(15) | Y | The SNOMED code(s) for the isolate |
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_LAB_PROCEDURE
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_LAB_PROCEDURE |
Definition: | health facts lab procedure table |
Table Type: | REFERENCE |
Column Detail - HF_D_LAB_PROCEDURE
Column Name | Type | Null? | Definition |
---|---|---|---|
HEALTHAWARE_IND | DOUBLE | Y | Indicates if the record was generated via the HealthAware solution. |
LAB_PROCEDURE_GROUP | VARCHAR(60) | Y | The lab procedure group can be used to find all related tests |
LAB_PROCEDURE_ID | DOUBLE | Y | Primary key to the table. Uniquely defines a lab procedure |
LAB_PROCEDURE_MNEMONIC | VARCHAR(100) | Y | Abbreviated name for a lab procedure |
LAB_PROCEDURE_NAME | VARCHAR(100) | Y | Full name of a laboratory test |
LAB_SUPER_GROUP | VARCHAR(25) | Y | A high level group relating lab procedures together |
LOINC_CODE | VARCHAR(10) | Y | Contains the Loinc Code associated with a lab procedure |
LOINC_IND | DOUBLE | Y | Reserved for future functionality |
LOINC_LONG | VARCHAR(255) | Y | The LOINC code display associated with a foreign file system DTA. |
LOINC_SHORT | VARCHAR(60) | Y | The LOINC code display associated with a foreign file system DTA. |
ODIN_IND | DOUBLE | Y | Indicates if a lab procedure is potentially reportable in the HealthSentry process |
PSP_RULE_GROUP | VARCHAR(25) | Y | Which group of PSP rules this lab |
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_LAB_RESULT_TYPE
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_Lab_Result_Type |
Definition: | This is the HealthFacts dimension table that contains standard values for general lab result types |
Table Type: | REFERENCE |
Column Detail - HF_D_LAB_RESULT_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
LAB_RESULT_TYPE_DESC | VARCHAR(60) | Y | The textual description of the lab result (numeric, character, date, etc.) |
LAB_RESULT_TYPE_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_LAB_SECTION
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_LAB_SECTION |
Definition: | This is the HealthFacts dimension table that contains standard values for lab sections |
Table Type: | REFERENCE |
Column Detail - HF_D_LAB_SECTION
Column Name | Type | Null? | Definition |
---|---|---|---|
LAB_SECTION_DESC | VARCHAR(60) | Y | The description of the lab section. This might be General Lab, Microbiology, AP, etc. |
LAB_SECTION_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. |
HF_D_LANGUAGE
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_LANGUAGE |
Definition: | Dimension table of languages spoken. |
Table Type: | REFERENCE |
Column Detail - HF_D_LANGUAGE
Column Name | Type | Null? | Definition |
---|---|---|---|
LANGUAGE_CODE | VARCHAR(10) | Y | The PHINVADS concept code that represents the primary language that is spoken. |
LANGUAGE_DESC | VARCHAR(120) | Y | The description of the primary language that is spoken. |
LANGUAGE_ID | DOUBLE | Y | PRIMARY KEY |
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. |