Table Detail Report
HF_F_LAB_PROCEDURE
Column Section | Top of Page |
Table-level Detail
Description: | HF_F_Lab_Procedure |
Definition: | A fact table used to analyze the general lab results. For HealthSentry, all results are loaded. For UNV, only completed results are loaded |
Table Type: | REFERENCE |
Column Detail - HF_F_LAB_PROCEDURE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION | VARCHAR(100) | Y | The primary accession number identifies an order or a group of orders. |
CHARACTER_RESULT | VARCHAR(2000) | Y | The textual value of the gen lab result |
COLLECTION_METHOD_ID | VARCHAR(40) | Y | The identifier for the procedure for collecting a specimen. |
COLLECTION_SITE_ID | DOUBLE | Y | The identifier for the mapped body site. |
COLLECTION_SOURCE_ID | DOUBLE | Y | The dim table key for the location where the test was performed |
CONTAINER_TYPE | VARCHAR(100) | Y | The specimen container type. Raw client value. |
DATE_RESULT_ID | DOUBLE | Y | The dim table key for the date of the procedure |
DETAIL_LAB_PROCEDURE_ID | DOUBLE | Y | The dim table key for the detail lab procedure (the task assay) |
DETAIL_LAB_TASK_ASSAY_SK | VARCHAR(40) | Y | The contributing system raw task assay for the detail test. |
DISCHARGED_DT_TM | DATETIME | Y | Indicates if the timestamp on Lab_Performed_Dt_Tm is valid |
ENCOUNTER_ID | DOUBLE | Y | Uniquely identify the encounter associated with a record |
HOSPITAL_ID | DOUBLE | Y | The dim table key for the hospital that this record's encounter is attached to |
INTERFACE_IND | DOUBLE | Y | An indicator to differentiate if the lab is coming from PathNet or Clinical Event. 0 is Pathnet and 1 is Clinical Event. |
LAB_CANCELLED_DT_ID | DOUBLE | Y | The dim table key for the date the gen lab order was cancelled |
LAB_CANCELLED_DT_TM | DATETIME | Y | The date/time the gen lab order was completed |
LAB_CANCELLED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Lab_Completed_Dt_Tm is valid |
LAB_COMPLETED_DT_ID | DOUBLE | Y | The dim table key for the date the gen lab order was completed |
LAB_COMPLETED_DT_TM | DATETIME | Y | The date/time the specimen was received |
LAB_COMPLETED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Lab_Received_Dt_Tm is valid |
LAB_DRAWN_DT_ID | DOUBLE | Y | The dim table key for the date the specimen was drawn |
LAB_DRAWN_DT_TM | DATETIME | Y | The date/time a gen lab order was ordered |
LAB_DRAWN_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Lab_Ordered_Dt_Tm is valid |
LAB_ORDERED_DT_ID | DOUBLE | Y | The dim table key for the date the gen lab order was ordered |
LAB_ORDERED_DT_TM | DATETIME | Y | An obsolete column that exists for consistency with existing Health Facts fact table |
LAB_ORDERED_TM_VLD_FLG | DOUBLE | Y | The date/time the gen lab DTA was verified |
LAB_ORDER_CARESETTING_ID | DOUBLE | Y | The dim table key for the location where the test was ordered |
LAB_ORDER_CARESETTING_RAW | VARCHAR(40) | Y | The client value representing the location where the test was ordered |
LAB_PERFORMED_CARESETTING_ID | DOUBLE | Y | The process that last modified this record |
LAB_PERFORMED_DT_ID | DOUBLE | Y | The dim table key for the date the gen lab DTA was performed |
LAB_PERFORMED_DT_TM | DATETIME | Y | The date/time the gen lab order was cancelled |
LAB_PERFORMED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Lab_Proc_Verified_Dt_Tm is valid |
LAB_PROCEDURE_KEY | DOUBLE | Y | The dim table key for the date that the gen lab DTA was verified |
LAB_RECEIVED_DT_ID | DOUBLE | Y | A unique, non-intelligent identifier for the table |
LAB_RECEIVED_DT_TM | DATETIME | Y | The dim table key for the date the specimen was received |
LAB_RECEIVED_TM_VLD_FLG | DOUBLE | Y | The date/time the specimen was drawn |
LAB_RESULT_TYPE_ID | DOUBLE | Y | Indicates if the timestamp on Lab_Drawn_Dt_Tm is valid |
LAB_VERIFIED_DT_ID | DOUBLE | Y | The dim table key for the type of gen lab result (numeric, text, etc.) |
LAB_VERIFIED_DT_TM | DATETIME | Y | The date/time the gen lab DTA was performed |
LAB_VERIFIED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Lab_Cancelled_Dt_Tm is valid |
METHOD_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for the collection method. |
NORMAL_ALPHA | VARCHAR(200) | Y | Defines the normal alpha response for a procedure with the result type of alpha. |
NORMAL_RANGE_HIGH | VARCHAR(40) | Y | Defines the normal high reference range value associated with a result. The result must be greater than the normal high to be flagged as high. |
NORMAL_RANGE_LOW | VARCHAR(40) | Y | Defines the normal low reference range value associated with a result. The result must be less than the normal low to be flagged as low. |
NUMERIC_RESULT | DOUBLE | Y | The numeric value of the gen lab result |
ORDERING_PHYSICIAN_ID | DOUBLE | Y | The dim table key for the ordering physician of the gen lab test |
ORDER_LAB_ORDERABLE_SK | VARCHAR(40) | Y | The contributing system raw orderable value for the ordering test. |
ORDER_LAB_PROCEDURE_ID | DOUBLE | Y | The dim table key for the ordered lab procedure |
PARTITION_DT_TM | DATETIME | Y | The dim table key for the collection source of the isolate |
PERFORMED_BENCH_HOSP_ID | DOUBLE | Y | The Health Data hospital identifier for the perform laboratory if determined from the bench information. |
PERFORMED_HOSPITAL_ID | DOUBLE | Y | Indicates which partition of the table this record is in. Matches the partition date/time of the parent encounter |
PERFORMED_PRSNL_ID | DOUBLE | Y | The personnel who performed the procedure. |
REPORTING_PRIORITY_ID | DOUBLE | Y | The dim table key for the reporting priority of the gen lab order |
RESULT_INDICATOR_ID | DOUBLE | Y | The dim table key used to indicate special information in regards to the gen lab result (Abnormal, Low, High, Critical, etc.) |
RESULT_INDICATOR_REF | VARCHAR(40) | Y | The dim table key used to indicate special information in regards to the gen lab result (Abnormal, Low, High, Critical, etc.) |
RESULT_UNITS_ID | DOUBLE | Y | The dim table key for the units of measurement for the gen lab result |
SITE_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for body site. |
SOURCE_FLG | DOUBLE | Y | A flag that differentiates if the source of this record is from PathNet or Clinical Event (third party lab) system. |
SPECIMEN_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for specimen. |
SRC_GEN_LAB_ORDER_KEY | VARCHAR(100) | Y | The identifying source key for the record. |
UNIT_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for unit of measure. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | VARCHAR(40) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_USER | VARCHAR(40) | Y | The date this record was last modified. Populated based on the last process date/time of the Micro Task to prevent over-reporting in HealthSentry |
VERIFIED_PRSNL | VARCHAR(40) | Y | The personnel that verified the result. |
HF_F_MICROBIOLOGY
Column Section | Top of Page |
Table-level Detail
Description: | HF_F_Microbiology |
Definition: | A fact table used by Health Facts to analyze data in the Microbiology subject area. This table does not contain susceptibility results (those are in HF_F_Micro_Susceptibility). Only positive isolates are loaded into this table |
Table Type: | REFERENCE |
Column Detail - HF_F_MICROBIOLOGY
Column Name | Type | Null? | Definition |
---|---|---|---|
ABNORMAL_IND | DOUBLE | Y | This field identifies whether or not the microbiology result has been defined as an abnormal response. Valid values include: 0 = Normal response 1 = Abnormal response |
ACCESSION | VARCHAR(100) | Y | The primary accession number identifies an order or a group of orders. |
COLLECTION_METHOD_ID | VARCHAR(40) | Y | The procedure for collecting a specimen. |
COLLECTION_SITE_ID | DOUBLE | Y | The dim table key for the collection site of the isolate |
COLLECTION_SOURCE_ID | DOUBLE | Y | The dim table key for the collection source of the isolate |
COLLECTION_STATUS_ID | DOUBLE | Y | The dim table key for the collection status of the micro order |
DISCHARGED_DT_TM | DATETIME | Y | The discharge date of the encounter associated with this record |
ENCOUNTER_ID | DOUBLE | Y | Uniquely identify the encounter associated with a record |
FALSE_POSITIVE_IND | DOUBLE | Y | Indicates if Health Facts processing has determined that this result is falsely displaying as positive |
FIRST_OBSERVED_ISOLATE_DT_TM | DATETIME | Y | The date/time when an isolate was first observed on this micro task |
FIRST_REPORT_ENTERED_DT_ID | DOUBLE | Y | The dim table key for the date of the first time a report was entered for this micro task |
FIRST_REPORT_ENTERED_DT_TM | DATETIME | Y | The date/time when a report was first entered for this micro task |
FIRST_RPT_ENTERED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on First_Report_Entered_Dt_Tm is valid |
HOSPITAL_ID | DOUBLE | Y | The dim table key for the hospital that this record's encounter is attached to |
INTERFACE_IND | DOUBLE | Y | An indicator to differentiate if the value is coming from PathNet or Clinical Event. 0 is Pathnet and 1 is Clinical Event. |
ISOLATE_ID | DOUBLE | Y | The dim table key for the isolate against which the susceptibility test is run |
LAST_REPORT_UPDATED_DT_ID | DOUBLE | Y | The dim table key for the date of the last time a report was entered for this micro task |
LAST_REPORT_UPDATED_DT_TM | DATETIME | Y | The date/time when a report was last entered for this micro task |
LAST_RPT_UPDATED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Last_Report_Entered_Dt_Tm is valid |
METHOD_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for the collection method. |
MICROBIOLOGY_KEY | DOUBLE | Y | A unique, non-intelligent identifier for the table |
MICRO_LAB_CANCELLED_DT_ID | DOUBLE | Y | The dim table key for the date the micro order was cancelled |
MICRO_LAB_CANCELLED_DT_TM | DATETIME | Y | The date/time the micro order was cancelled |
MICRO_LAB_CANCELLED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Micro_Lab_Cancelled_Dt_Tm is valid |
MICRO_LAB_COMPLETED_DT_ID | DOUBLE | Y | The dim table key for the date the micro order was completed |
MICRO_LAB_COMPLETED_DT_TM | DATETIME | Y | The date/time the micro order was completed |
MICRO_LAB_COMPLTED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Micro_Lab_Completed_Dt_Tm is valid |
MICRO_LAB_DRAWN_DT_ID | DOUBLE | Y | The dim table key for the date the specimen was drawn |
MICRO_LAB_DRAWN_DT_TM | DATETIME | Y | The date/time the specimen was drawn |
MICRO_LAB_DRAWN_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Micro_Lab_Drawn_Dt_Tm is valid |
MICRO_LAB_ORDERED_DT_ID | DOUBLE | Y | The dim table key for the date the micro order was ordered |
MICRO_LAB_ORDERED_DT_TM | DATETIME | Y | The date/time a micro order was ordered |
MICRO_LAB_ORDERED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Micro_Lab_Ordered_Dt_Tm is valid |
MICRO_LAB_RECEIVED_DT_ID | DOUBLE | Y | The dim table key for the date the specimen was received |
MICRO_LAB_RECEIVED_DT_TM | DATETIME | Y | The date/time the specimen was received |
MICRO_LAB_RECEIVED_TM_VLD_FLG | DOUBLE | Y | Indicates if the timestamp on Micro_Lab_Received_Dt_Tm is valid |
MICRO_ORDER_CARESETTING_ID | DOUBLE | Y | The dim table key for the location where the test was ordered |
MICRO_ORDER_CARESETTING_RAW | VARCHAR(40) | Y | The client value representing the location where the test was ordered |
MICRO_ORDER_STATUS_ID | DOUBLE | Y | The dim table key for the status of the micro order |
MICRO_RESULT_TYPE_ID | DOUBLE | Y | The dim table key for the type of micro result (preliminary, final, etc.) |
ORDERING_PHYSICIAN_ID | DOUBLE | Y | The dim table key for the ordering physician of the micro test |
ORDER_LAB_ORDERABLE_SK | VARCHAR(40) | Y | The contributing system raw orderable value for the ordering test. |
ORDER_LAB_PROCEDURE_ID | DOUBLE | Y | The dim table key for the ordered lab procedure |
ORGANISM_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw organism from code set 1021. |
ORGANISM_OCCURRENCE_NBR | DOUBLE | Y | A unique number to identify parts of the same organism. |
PARTITION_DT_TM | DATETIME | Y | Indicates which partition of the table this record is in. Matches the partition date/time of the parent encounter |
PERFORMED_BENCH_HOSP_ID | DOUBLE | Y | The Health Data hospital identifier for the perform laboratory if determined from the bench information. |
PERFORMED_HOSPITAL_ID | DOUBLE | Y | The dim key for the hospital where the micro test was performed |
PERFORMED_PRSNL_ID | DOUBLE | Y | The personnel who performed this result |
POSITIVE_IND | DOUBLE | Y | This differentiates the positive microbiology from the negative. |
REPORTING_PRIORITY_ID | DOUBLE | Y | The dim table key for the reporting priority of the micro order |
RESPONSE_CLASS_FLG | DOUBLE | Y | The contributing system raw response class. |
RESPONSE_REF | VARCHAR(40) | Y | The contributing system raw codified response from code set 1021. |
RESULT_TYPE_PROCEDURE_ID | DOUBLE | Y | The dim table key for the type of procedure that was performed |
SITE_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for body site. |
SOURCE_FLG | DOUBLE | Y | A flag that differentiates if the source of this record is from PathNet or Clinical Event (third party lab) system. |
SPECIFIC_SOURCE | VARCHAR(40) | Y | The client code value ref for the specimen code set. Client value for the collection_source. |
SPECIMEN_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw orderable value for the ordering test. |
SRC_MICRO_ORDER_KEY | VARCHAR(40) | Y | The unique identifier for Micro_Order table's associated micro order. |
TOTAL_REPORT_UPDATES | DOUBLE | Y | The total number of times reports have been entered for this micro task |
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 who last modified this record |
VERIFIED_DT_TM | DATETIME | Y | The date time of the result being verified. |
VERIFIED_PRSNL | VARCHAR(40) | Y | The personnel that verified the result. |
HF_F_MICRO_FULL_REPORT
Column Section | Top of Page |
Table-level Detail
Description: | HF_F_Micro_Full_Report |
Definition: | A fact table used to analyze the full text of microbiology responses. |
Table Type: | REFERENCE |
Column Detail - HF_F_MICRO_FULL_REPORT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION | VARCHAR(100) | Y | The primary accession number identifies an order or a group of orders. |
CLIENT_ORDER_CULTURE_NAME | VARCHAR(100) | Y | The client display value for the ordered lab procedure |
CLIENT_REPORT_VALUE | VARCHAR(255) | Y | The textual value of the report response. This can be either free text or the code value description of a codified response |
COMPLETED_DT_TM | DATETIME | Y | The date/time the micro order was completed |
DISCHARGED_DT_TM | DATETIME | Y | The discharge date of the encounter associated with this record |
ENCOUNTER_ID | DOUBLE | Y | Uniquely identify the encounter associated with a record |
FALSE_POSITIVE_IND | DOUBLE | Y | When a response is marked as positive but the system has detected a negating phrase surrounding the response, this will be set to 1. For all other rows, it will be set to 0 |
ISOLATE_ID | DOUBLE | Y | The dim table key for the isolate against which the susceptibility test is run |
MICRO_FULL_REPORT_KEY | DOUBLE | Y | A unique, non-intelligent identifier for the table |
MICRO_RESPONSE_SEQUENCE | DOUBLE | Y | The field contains a value that uniquely identifies each report response. This value will allow multiples of the same report response to be uniquely identified. |
MICRO_TASK_ID | DOUBLE | Y | A unique identifier for a micro task. Combine with Micro_Response_Sequence for an alternate key into this table |
ORDER_LAB_PROCEDURE_ID | DOUBLE | Y | The dim table key for the ordered lab procedure |
PARTITION_DT_TM | DATETIME | Y | Indicates which partition of the table this record is in. Matches the partition date/time of the parent encounter |
PERFORMED_HOSPITAL_ID | DOUBLE | Y | The hospital in which the report was performed. |
POSITIVE_IND | VARCHAR(1) | Y | This field identifies whether or not the response has been defined as a positive report response. Valid values include: 0 = negative response 1= positive response |
RESPONSE_CLASS_FLG | DOUBLE | Y | This field identifies the type of response used in issuing the report. 0 - Textual Response 5 - Coded Response 6 - Member of a Group Response 101 - Organism |
RESULT_TYPE_PROCEDURE_ID | DOUBLE | Y | The dim table key for the type of procedure that was performed |
SRC_MICRO_ORDER_KEY | VARCHAR(200) | Y | The identifying source key for the record. |
TASK_TYPE_FLG | DOUBLE | Y | This field identifies a value that determines the task type associated with the task entered. The task type further categorizes similar tasks within each task class. |
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 who last modified this record |
HF_F_MICRO_SUSCEPTIBILITY
Column Section | Top of Page |
Table-level Detail
Description: | HF_F_Micro_Susceptibility |
Definition: | A fact table used by Health Facts to analyze data in the Micro Susceptibility subject area |
Table Type: | REFERENCE |
Column Detail - HF_F_MICRO_SUSCEPTIBILITY
Column Name | Type | Null? | Definition |
---|---|---|---|
ABNORMAL_IND | DOUBLE | Y | This field identifies whether or not the susceptibility result has been defined as an abnormal susceptibility response. Valid values include: 0 = Normal response 1 = Abnormal response |
ACCESSION | VARCHAR(100) | Y | The primary accession number identifies an order or a group of orders. |
ANTIMICROBIAL_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for the antimicrobial. |
ANTIMICROBIAL_ID | DOUBLE | Y | The dim table key for the antimicrobial being used in the susceptibility test |
COLLECTION_METHOD_ID | VARCHAR(40) | Y | The procedure for collecting a specimen. |
COLLECTION_SITE_ID | DOUBLE | Y | The dim table key for the collection site of the isolate |
COLLECTION_SOURCE_ID | DOUBLE | Y | The dim table key for the collection source of the isolate |
DISCHARGED_DT_TM | DATETIME | Y | The discharge date of the encounter associated with this record |
ENCOUNTER_ID | DOUBLE | Y | Uniquely identify the encounter associated with a record |
HOSPITAL_ID | DOUBLE | Y | The dim table key for the hospital that this record's encounter is attached to |
INTERFACE_IND | DOUBLE | Y | An indicator to differentiate if the value is coming from PathNet or Clinical Event. 0 is Pathnet and 1 is Clinical Event. |
INTERP_BLOOD_PERF_DT_ID | DOUBLE | Y | The dim table key for the performed date of the blood result |
INTERP_BLOOD_PERF_DT_TM | DATETIME | Y | The performed date/time of the blood result |
INTERP_BLOOD_PERF_TM_VLD_FLG | DOUBLE | Y | The performed time valid flag of the blood result |
INTERP_BLOOD_RESULT_ID | DOUBLE | Y | The dim table key for the interpretative result of this susceptibility test when the isolate source is blood |
INTERP_BLOOD_VERF_DT_ID | DOUBLE | Y | The dim table key for the verified date of the blood result |
INTERP_BLOOD_VERF_DT_TM | DATETIME | Y | The verified date/time of the blood result |
INTERP_BLOOD_VERF_TM_VLD_FLG | DOUBLE | Y | The verified time valid flag of the blood result |
INTERP_CSF_PERF_DT_ID | DOUBLE | Y | The dim table key for the performed date of the spinal fluid result |
INTERP_CSF_PERF_DT_TM | DATETIME | Y | The performed date/time of the spinal fluid result |
INTERP_CSF_PERF_TM_VLD_FLG | DOUBLE | Y | The performed time valid flag of the spinal fluid result |
INTERP_CSF_RESULT_ID | DOUBLE | Y | The dim table key for the interpretative result of this susceptibility test when the isolate source is spinal fluid |
INTERP_CSF_VERF_DT_ID | DOUBLE | Y | The dim table key for the verified date of the spinal fluid result |
INTERP_CSF_VERF_DT_TM | DATETIME | Y | The verified date/time of the spinal fluid result |
INTERP_CSF_VERF_TM_VLD_FLG | DOUBLE | Y | The verified time valid flag of the spinal fluid result |
INTERP_PERF_DT_ID | DOUBLE | Y | The interpretation performed date id is used to join the hf_f_micro_susceptibility table to the date dimension table. |
INTERP_PERF_DT_TM | DATETIME | Y | The date the susceptibility procedure result interpretation was performed. |
INTERP_PERF_TM_VLD_FLG | DOUBLE | Y | ;If the time stamp received for this date is valid, then '1', Else '0'. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 1 - Valid Time Stamp 0 - Invalid Time Stamp |
INTERP_RESULT_ID | DOUBLE | Y | This field contains the internal identification code for the interpretation susceptibility result value. |
INTERP_URINE_PERF_DT_ID | DOUBLE | Y | The dim table key for the performed date of the urine result |
INTERP_URINE_PERF_DT_TM | DATETIME | Y | The performed date/time of the urine result |
INTERP_URINE_PERF_TM_VLD_FLG | DOUBLE | Y | The performed time valid flag of the urine result |
INTERP_URINE_RESULT_ID | DOUBLE | Y | The dim table key for the interpretative result of this susceptibility test when the isolate source is urine |
INTERP_URINE_VERF_DT_ID | DOUBLE | Y | The dim table key for the verified date of the urine result |
INTERP_URINE_VERF_DT_TM | DATETIME | Y | The verified date/time of the urine result |
INTERP_URINE_VERF_TM_VLD_FLG | DOUBLE | Y | The verified time valid flag of the urine result |
INTERP_VERF_DT_ID | DOUBLE | Y | The interpretation verified date id is used to join the hf_f_micro_susceptibility table to the date dimension table. |
INTERP_VERF_DT_TM | DATETIME | Y | The date the susceptibility procedure result interpretation was verified. |
INTERP_VERF_TM_VLD_FLG | DOUBLE | Y | If the time stamp received for this date is valid, then '1', Else '0'. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 1 - Valid Time Stamp 0 - Invalid Time Stamp |
ISOLATE_ID | DOUBLE | Y | The dim table key for the isolate against which the susceptibility test is run |
METHOD_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for the collection method. |
MICRO_RESULT_TYPE_ID | DOUBLE | Y | The Health Data identifier for the micro result type which joins to hf_d_micro_result_type. |
MICRO_SUSCEPTIBILITY_KEY | DOUBLE | Y | A unique, non-intelligent identifier for the table |
NUMERIC_RESULT | VARCHAR(40) | Y | A numeric/alpha numeric result for this susceptibility test |
NUMERIC_RESULT_PERF_DT_ID | DOUBLE | Y | The dim table key for the performed date of the numeric/alpha numeric result |
NUMERIC_RESULT_PERF_DT_TM | DATETIME | Y | The performed date/time of the numeric/alpha numeric result |
NUMERIC_RESULT_PERF_TM_VLD_FLG | DOUBLE | Y | The performed time valid flag of the numeric/alpha numeric result |
NUMERIC_RESULT_VERF_DT_ID | DOUBLE | Y | The dim table key for the verified date of the numeric/alpha numeric result |
NUMERIC_RESULT_VERF_DT_TM | DATETIME | Y | The verified date/time of the numeric/alpha numeric result |
NUMERIC_RESULT_VERF_TM_VLD_FLG | DOUBLE | Y | The verified time valid flag of the numeric/alpha numeric result |
ORDER_LAB_ORDERABLE_SK | VARCHAR(40) | Y | The contributing system raw orderable value for the ordering test. |
ORDER_LAB_PROCEDURE_ID | DOUBLE | Y | The dim table key for the ordered lab procedure |
ORGANISM_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw orderable value for the organism or codified result. |
ORGANISM_OCCURRENCE_NBR | DOUBLE | Y | A unique number to identify parts of the same organism. |
PARTITION_DT_TM | DATETIME | Y | Indicates which partition of the table this record is in. Matches the partition date/time of the parent encounter |
PERFORMED_BENCH_HOSP_ID | DOUBLE | Y | The Health Data hospital identifier for the perform laboratory if determined from the bench information. |
PERFORMED_HOSPITAL_ID | DOUBLE | Y | The Health Data hospital identifier for the perform laboratory if determined from the facility information. |
PERFORMED_PRSNL_ID | DOUBLE | Y | The physician id that joins to hf_d_physician for the personnel performing the lab test. |
RESULT_UNITS_ID | DOUBLE | Y | The dim table key for the units of measurement for the numeric result |
SITE_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for body site. |
SOURCE_FLG | DOUBLE | Y | A flag that differentiates if the source of this record is from PathNet or Clinical Event (third party lab) system. |
SPECIFIC_SOURCE | VARCHAR(40) | Y | blank |
SPECIMEN_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw orderable value for the ordering test. |
SRC_MICRO_ORDER_KEY | VARCHAR(40) | Y | The unique identifier for Micro_Order table's associated micro order. |
TEST_TYPE_ID | DOUBLE | Y | The dim table key for the type of susceptibility test |
UNIT_CODE_VALUE_REF | VARCHAR(40) | Y | The contributing system raw code value for unit of measure. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | VARCHAR(40) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_USER | VARCHAR(40) | Y | The user who last modified this record |
VERIFIED_PRSNL | VARCHAR(40) | Y | The personnel that verified the result. |
HF_F_PSP_ENCOUNTER
Column Section | Top of Page |
Table-level Detail
Description: | HF_F_PSP_ENCOUNTER |
Definition: | This is an encounter level fact table for the PSP rules |
Table Type: | REFERENCE |
Column Detail - HF_F_PSP_ENCOUNTER
Column Name | Type | Null? | Definition |
---|---|---|---|
ADMIT_DATE_ID | DOUBLE | N | Links to HF_D_Date to define the admit date |
ADMIT_DT_TM | DATETIME | Y | The admit date of the encounter (included for troubleshooting and easy querying purposes) |
ADMIT_TM_VALID_FLG | DOUBLE | Y | Indicates if the admit date has a valid timestamp |
AGE_IN_YEARS | DOUBLE | Y | Defines the age of a person at admission in years |
BILLING_JOIN_NBR | VARCHAR(40) | Y | The number used to join billing and clinical date together |
DISCHARGE_DATE_ID | DOUBLE | N | Links to HF_D_Date to define a discharge date |
DISCHARGE_DT_TM | DATETIME | Y | The discharge date of the encounter (included for troubleshooting and easy querying purposes) |
DISCHARGE_TM_VALID_FLG | DOUBLE | Y | Indicates if the discharge date has a valid timestamp |
DISCHG_DISP_ID | DOUBLE | N | Links to HF_D_Disch_Disp to define the discharge disposition |
DRG_ID | DOUBLE | N | Links to HF_D_Drg to define the DRG |
ENCOUNTER_ID | DOUBLE | N | Uniquely defines an encounter (without taking HF create encounter logic into account). Links to the encounter_key on WH_CLN_ENCOUNTER |
ENCOUNTER_SK | VARCHAR(40) | Y | The unique value assigned to each patient visit. |
FORMATTED_MEDICAL_RECORD_NBR | VARCHAR(40) | Y | The formatted patient medical record number |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system, but may be adjusted if there is >1 HF feed from the client. |
HOSPITAL_ID | DOUBLE | N | Links to HF_D_Hospital to identify the hospital associated with an encounter |
MDC_ID | DOUBLE | N | Links to HF_D_Mdc to define the MDC |
MORTALITY_IND | DOUBLE | Y | Indicates if the for this encounter has died or not (calculated based on Dischg_Disp_ID) |
PARTITION_DT_TM | DATETIME | Y | Used to break up tables by partition. This is the admit date if available. Otherwise, it is the first process date of the record |
PSP_ENCOUNTER_KEY | DOUBLE | Y | Uniquely identifies a PSP Encounter record |
RULE_FIRED_IND | DOUBLE | Y | Indicates if this encounter had any ADE rules fired |
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 application that performed the insert or update on this record. If this was done manually, 'MANUAL' should be entered. |
VISIT_ID | DOUBLE | N | Uniquely defines an encounter (taking HF create encounter logic into account). Links to the visit_key on WH_CLN_ENCOUNTER |