Table Detail Report

HF_F_PSP_RULES



Column Section Top of Page


Table-level Detail

Description: HF_F_PSP_RULES
Definition: This fact table contains information on encounters that triggered any of the PSP rules
Table Type: REFERENCE





Column Detail - HF_F_PSP_RULES


Column Name Type Null? Definition
ADE_ID DOUBLE N Links to HF_D_Ade to define the adverse drug event
DRUG_ID DOUBLE N Links to HF_D_Drug to define the drug
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.
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
NBR_LABS_WORSEN_AFTER_1ST_FIRE DOUBLE Y Number of lab results that indicate a declining condition after the ADE was triggered
NBR_OF_DRUG_ORDERS DOUBLE Y The number of medication orders that triggered this ADE
NBR_OF_HOURS_AFTER_1ST_FIRE DOUBLE Y Number of hours since the ADE was triggered to the discontinuationof the drug
NBR_OF_LABS_AFTER_1ST_FIRE DOUBLE Y Number of labs found by this ADE after the first lab triggered the ADE
NBR_OF_TIMES_RULE_FIRED DOUBLE Y The number of times this ADE was triggered
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_RULES_KEY DOUBLE Y Uniquely identifies a PSP Rules record
TEST_ID DOUBLE N LInks to HF_D_Test to define the lab test
UPDT_DT_TM DATETIME Y The date/time that this record was updated.
UPDT_TASK VARCHAR(40) Y The user id that performed the update or insert on this record.
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


HF_OTH_HS_FACILITY_BREAKOUT



Column Section Top of Page


Table-level Detail

Description: HF_OTH_HS_FACILITY_BREAKOUT
Definition: Work table that is used to help explode out the Facilities per Health System.
Table Type: REFERENCE





Column Detail - HF_OTH_HS_FACILITY_BREAKOUT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
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 associated hospital.
OUTBOUND_HSS_ID DOUBLE N The unique identifier of the organization that this result will be reported to.
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_OTH_HS_RUN



Column Section Top of Page


Table-level Detail

Description: HF_OTH_HS_RUN
Definition: Work table that is used during HealthSentry loads.
Table Type: REFERENCE





Column Detail - HF_OTH_HS_RUN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_DT_TM DATETIME Y The begin date and time of the period being processed.
END_DT_TM DATETIME Y The end date and time of the period being processed.
HF_RUN_GROUP_ID DOUBLE N The identifier of the group of runs.
HF_RUN_KEY DOUBLE N Unique identifier of the Informatic run.
MNEMONIC VARCHAR(40) Y The mnemonic of the client run logged.
PROCESS_RANGE_END_DT_TM DATETIME Y The end date of the processing range.
PROCESS_RANGE_START_DT_TM DATETIME Y The start date of the processing range.
RUN_ID DOUBLE N The Run Identifier.
RUN_TYPE_FLG DOUBLE Y A numeric code indicating what type of workflow is or was running at the time of this processing. The codes are: 1=w_HF_Reference_Load, 2=w_HS_Cln_EDW, 3=w_DM_HealthSentry, 4=w_HF_DM_i2b2, 5=w_HF_DM_Critical_Outcomes, 6=w_CERN_DM, 10=w_HF_Blended_View, 11=w_DH_DM, 12=w_HF_CRN or =UNKNOWN_WORKFLOW
STATUS_FLG DOUBLE Y The current or last status of this run. The codes are: 1=COMPLETE, 2=DISABLED, 3=FAILED, 4=STOPPED, 5=ABORTED, 6=IN PROCESS, 15=TERMINATED or =MISSING.
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 id that performed the update or insert on this record.


HF_OTH_HS_R_TEST_DETAIL



Column Section Top of Page


Table-level Detail

Description: HF_OTH_HS_R_TEST_DETAIL
Definition: BLANK
Table Type: REFERENCE





Column Detail - HF_OTH_HS_R_TEST_DETAIL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DIRECTION_IND DOUBLE Y This indicator specifies which direction to either look back or look forward for the out result relative to the in result. 1 is look back. 2 is look forward.
ENC_FLG DOUBLE Y This lets the rule know if this is person centric or encounter centric. 0 is person and 1 is encounter.
IN_DETAIL_LAB_PROCEDURE_ID DOUBLE N If the look back rule is going to trigger off a general lab test, then the lab_procedure id (from hf_d_lab_procedure) shall be entered. Each rule should only have 1 in_isolate_id or in_detail_lab_procedure_id not both.
IN_ISOLATE_ID DOUBLE N If the look back rule is going to trigger off a microbiology test, then the isolate id (from hf_d_isolate) shall be entered. Each rule should only have 1 in_isolate_id or in_detail_lab_procedure_id not both.
NUMBER_OF_DAYS DOUBLE Y The number of days to look backwards or forwards for the Out test based on the In results.
OUT_DETAIL_LAB_PROCEDURE_ID DOUBLE N This shall contain a lab_procedure_id from hf_d_lab_procedure that the rule will also report if the in_isolate or in_detail_lab_procedure had a reportable result.
TEST_DETAIL_ID DOUBLE N A unique identifier that joins to HF_OTH_HS_R_TEST_RULES for this look back rule.
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_OTH_HS_R_TEST_RULES



Column Section Top of Page


Table-level Detail

Description: HF_OTH_HS_R_TEST_RULES
Definition: A work table for processing test rules.
Table Type: REFERENCE





Column Detail - HF_OTH_HS_R_TEST_RULES


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
OUTBOUND_HSS_ID DOUBLE N The unique identifier of the organization that this result will be reported to.
TEST_DETAIL_ID DOUBLE N A unique identifier that joins to HF_OTH_HS_R_TEST_DETAIL for this look back rule. Each combination of In and Out tests needs a unique test_detail_id.
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.