Table Detail Report

HF_D_ARRIVAL_MODE



Column Section Top of Page


Table-level Detail

Description: HF_D_ARRIVAL_MODE
Definition: Dimension table for potential arrival modes.
Table Type: REFERENCE





Column Detail - HF_D_ARRIVAL_MODE


Column Name Type Null? Definition
ARRIVAL_MODE_CODE VARCHAR(10) Y The mode of arrival value per HL7 table 0430.
ARRIVAL_MODE_DESC VARCHAR(100) Y The mode of label value per HL7 table 0430/
ARRIVAL_MODE_ID DOUBLE N 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.


HF_D_CARESETTING



Column Section Top of Page


Table-level Detail

Description: HF_D_CARESETTING
Definition: This is the HealthFacts dimension table that contains the standard value for caresetting
Table Type: REFERENCE





Column Detail - HF_D_CARESETTING


Column Name Type Null? Definition
CARESETTING_DESC VARCHAR(60) Y The description of the caresetting
CARESETTING_ID DOUBLE Y Primary key to the table. Uniquely defines a caresetting
PHIN_CARESETTING_DESC VARCHAR(100) Y PHINVADs is expecting a specific description for valid nursing units. Only records that match the PHINVads table will be populated.
PHIN_CODE VARCHAR(10) Y The standard PHIN concept code for the medical service.
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_COLLECTION_SRC_SITE



Column Section Top of Page


Table-level Detail

Description: HF_D_COLLECTION_SRC_SITE
Definition: health facts dimension collection source site table
Table Type: REFERENCE





Column Detail - HF_D_COLLECTION_SRC_SITE


Column Name Type Null? Definition
COLLECTION_SOURCE_SITE_DESC VARCHAR(40) Y The collection source or site for the microbiology specimen
COLLECTION_SOURCE_SITE_ID DOUBLE Y Primary key to the table. Uniquely defines a collection source/site
HL7_CODE VARCHAR(6) Y The SNOMED code for sources from an HL7 file
METHOD_SNOMED VARCHAR(10) Y If this record is a collection method, this is the collection method SNOMED CT code.
MODIFIER_DESC VARCHAR(100) Y If the source/site has a modifier such as left, right, upper, lower, this field is the modifier description like Left, Right.
MODIFIER_SNOMED VARCHAR(10) Y If the source/site has a modifier such as left, right, upper, lower, this field is the SNOMED for the modifier.
SITE_IND DOUBLE Y An indicator to flag the items most commonly considered a specimen site
SITE_SNOMED VARCHAR(10) Y If this record is a body site, this is the site SNOMED CT code.
SNOMED_CODE VARCHAR(10) Y The SNOMED 5 code for a specimen source
SOURCE_IND DOUBLE Y An indicator to flag the items most commonly considered a specimen source
SOURCE_TYPE VARCHAR(20) Y A grouping for common sources
STERILE_IND DOUBLE Y An indicator to flag the sources/sites considered sterile
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_COLLECTION_STATUS



Column Section Top of Page


Table-level Detail

Description: HF_D_Collection_Status
Definition: This is the HealthFacts dimension table that contains standard values for collection statuses
Table Type: REFERENCE





Column Detail - HF_D_COLLECTION_STATUS


Column Name Type Null? Definition
COLLECTION_STATUS_CODE DOUBLE Y An internal Health Facts identifier for a collection status
COLLECTION_STATUS_DESC VARCHAR(60) Y The textual description of a collection status (collection, ordered, scheduled, etc.)
COLLECTION_STATUS_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_COUNTRY



Column Section Top of Page


Table-level Detail

Description: HF_D_COUNTRY
Definition: Dimension table that stores the list of potential countries for HealthSentry.
Table Type: REFERENCE





Column Detail - HF_D_COUNTRY


Column Name Type Null? Definition
COUNTRY_CODE VARCHAR(10) Y The PHINVADs concept code that represents the country.
COUNTRY_ID DOUBLE Y PRIMARY KEY
COUNTRY_NAME VARCHAR(50) Y The name of the country.
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.