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 |