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