Table Detail Report

LH_CNT_IC_PATIENT_READMIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT READMIT
Definition: 0
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_READMIT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop
LH_CNT_IC_PATIENT_READMIT_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_READMIT table.
READMIT_30_IND DOUBLE N Indicates whether this patient's encounter occurred with 30 days of being discharged from a previous encounter. 0=no, 1 = yes
READMIT_30_SURG_DT_TM DATETIME Y The date/time the previous surgery occurred
READMIT_30_SURG_IND DOUBLE N Indicates whether this patient's encounter occurred with 30 days of being discharged from a previous surgery encounter. 0=no, 1 = yes
READMIT_365_IMPLANT_DT_TM DATETIME Y The date/time the surgical implant occurred.
READMIT_365_IMPLANT_IND DOUBLE N Indicates whether this patient's encounter occurred with 365 days of being discharged from a previous encounter that had a surgical implant performed. 0=no, 1 = yes
READMIT_90_SURG_DT_TM DATETIME Y The date/time of the surgery that occurred within the previous 90 days of this encounter's registration date/time.
READMIT_90_SURG_IND DOUBLE N Indicates whether this patient's encounter occurred with 90 days of having surgery. 0=no, 1=yes.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_CNT_IC_PATIENT_READMIT


Child Column in LH_CNT_IC_PATIENT_READMIT(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_PATIENT_POP_ID LH_CNT_IC_PATIENT_POP LH_CNT_IC_PATIENT_POP_ID


LH_CNT_IC_PATIENT_READ_SRG



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_PATIENT_READ_SRG
Definition: Infection Control Worklist table to store surgical procedures that fall within readmission timeframes.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_READ_SRG


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to LH_CNT_IC_PATIENT_POP table.
LH_CNT_IC_PATIENT_READ_SRG_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_READ_SRG table.
READMIT_GROUP_FLAG DOUBLE N 1=30 day readmit, 2=90 day readmit, 3=365 day readmit after implant
SURG_CASE_PROC_ID DOUBLE N Foreign key to SURG_CASE_PROCEDURE table.
SURG_DT_TM DATETIME Y Stores the date/time of when the surgical procedure took place.
SURG_PROC_CD DOUBLE N Stores the surgical procedure code from the SURG_CASE_PROCEDURE table.
SURG_PROC_NHSN_CAT_CD DOUBLE N Stores the NHSN code value mapped to a surgical procedure within Bedrock.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_CNT_IC_PATIENT_READ_SRG


Child Column in LH_CNT_IC_PATIENT_READ_SRG(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_PATIENT_POP_ID LH_CNT_IC_PATIENT_POP LH_CNT_IC_PATIENT_POP_ID
SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID


LH_CNT_IC_PATIENT_RPT_RISK



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT RPT RISK
Definition: This table stores patient's RPT risk information
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_RPT_RISK


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
BODY_SITE_CD DOUBLE N Stores code value of the body site from where the specimen is collected.
BODY_SITE_DISPLAY VARCHAR(40) Y The body site
COLLECT_DT_TM DATETIME Y The date/time the specimen was collected
CREATED_DT_TM DATETIME N Stores date time when the row is created.
EVENT_CD DOUBLE N The event code from the clinical event table.
EVENT_DISPLAY VARCHAR(255) Y The display for this reportable event
EVENT_STATUS_CD DOUBLE N Stores the status code of the event.
EVENT_STATUS_DISPLAY VARCHAR(40) Y The event status display
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop
LH_CNT_IC_PATIENT_RPT_RISK_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_RPT_RISK table.
ORDER_DT_TM DATETIME Y The date/time the order was placed
ORDER_ID DOUBLE N Stores the Id of the associated order.
ORDER_MNEMONIC VARCHAR(100) Y The mnemonic of the order
ORGANISM_DESCRIPTION VARCHAR(2000) Y The description of the organism that caused an infection
PARENT_EVENT_ID DOUBLE N Stores the parent event id from clinical event.
REPORTABLE_FLAG DOUBLE N 1=24HR, 2=OTHER
RPT_TYPE_FLAG DOUBLE N 1=24HR, 2=OTHER
SOURCE_TYPE_DISPLAY VARCHAR(40) Y The source type/site
SPECIMEN_TYPE_CD DOUBLE N Stores code value of the type of specimen collected.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update 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_DT_TM DATETIME N 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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. 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 DOUBLE N 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.



Relationship Detail - LH_CNT_IC_PATIENT_RPT_RISK


Child Column in LH_CNT_IC_PATIENT_RPT_RISK(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_PATIENT_POP_ID LH_CNT_IC_PATIENT_POP LH_CNT_IC_PATIENT_POP_ID
ORDER_ID ORDERS ORDER_ID


LH_CNT_IC_PATIENT_XRAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT XRAY
Definition: This table stores patient's X-Ray information
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_XRAY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
CATALOG_CD DOUBLE N Stores code value of the corresponding order catalog.
EVENT_END_DT_TM DATETIME Y The date/time the event ended
EVENT_ID DOUBLE N Event_id from clinical_event
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop
LH_CNT_IC_PATIENT_XRAY_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_XRAY table.
ORDER_DESCRIPTION VARCHAR(100) Y The description of this xray order
ORDER_ID DOUBLE N Stores the id of the corresponding order.
RESULT_STATUS_CD DOUBLE N Stores code value of the result status.
RESULT_STATUS_DISPLAY VARCHAR(40) Y The status of the result
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update 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_DT_TM DATETIME N 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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. 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 DOUBLE N 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.



Relationship Detail - LH_CNT_IC_PATIENT_XRAY


Child Column in LH_CNT_IC_PATIENT_XRAY(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_PATIENT_POP_ID LH_CNT_IC_PATIENT_POP LH_CNT_IC_PATIENT_POP_ID
ORDER_ID ORDERS ORDER_ID


LH_CNT_IC_PAT_HAI_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Content Infection Control Patient Hospital Acquired Infection Codes
Definition: This table will contain a list of code values corresponding to each entry in LH_CNT_IC_PATIENT_HAI_RISK.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PAT_HAI_CODE


Column Name Type Null? Definition
HAI_CD DOUBLE N Code value of the status of the Infection.
HAI_EVENT_DT_TM DATETIME Y Event Date time corresponding to the HAI event.
HAI_TYPE_FLAG DOUBLE N Flag indicating the type of HAI (1 : BSI; 2 : PNEU; 4: SSI; 8: UTI)
LH_CNT_IC_PATIENT_HAI_RISK_ID DOUBLE N The identifier of the row on the LH_CNT_IC_PATIENT_HAI_RISK table that is related to the Hospital Aquired Infection Code.
LH_CNT_IC_PAT_HAI_CODE_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PAT_HAI_CODES table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_CNT_IC_PAT_HAI_CODE


Child Column in LH_CNT_IC_PAT_HAI_CODE(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_PATIENT_HAI_RISK_ID LH_CNT_IC_PATIENT_HAI_RISK LH_CNT_IC_PATIENT_HAI_RISK_ID