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.