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