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