Table Detail Report

LH_CNT_READMIT_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_READMIT_STATUS
Definition: This table will contain the statuses of the filters used in the readmission worklist
Table Type: ACTIVITY





Column Detail - LH_CNT_READMIT_STATUS


Column Name Type Null? Definition
DOC_AS_FLAG DOUBLE Y Status of the Assessment documentation for this encounter
DOC_ED_FLAG DOUBLE Y Status of the Education documentation for this encounter
DOC_PP_FLAG DOUBLE Y Status of the PowerPlan documentation for this encounter
FU_DEPART_FLAG DOUBLE Y Status of the Follow Up Depart Process documentation for this encounter
FU_PHONE_DT_TM DATETIME Y Contains the date/time of the follow up phone call
FU_PHONE_FLAG DOUBLE Y Status of the Follow Up Phone Call documentation for this encounter
FU_VISIT_FLAG DOUBLE Y Status of the Follow Up Visits documentation for this encounter
LAST_UPDT_DT_TM DATETIME Y This is the last date that the entire table was updated. This will be used to show on the front end how old the data is the end user is reviewing.
LH_CNT_READMIT_STATUS_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_READMIT_STATUS table.
LH_CNT_READMIT_WORKLIST_ID DOUBLE N ID of the corresponding row from the LH_CNT_READMIT_WORKLIST table.
SS_CD1_FLAG DOUBLE Y Status of the Support Services Client Defined 1 documentation for this encounter
SS_CD2_FLAG DOUBLE Y Status of the Support Services Home Health documentation for this encounter
SS_CD3_FLAG DOUBLE Y Status of the Support Services Home Health documentation for this encounter
SS_CM_FLAG DOUBLE Y Status of the Support Services Care Management documentation for this encounter
SS_HC_FLAG DOUBLE Y Status of the Support Services Hospice Consult documentation for this encounter
SS_HH_FLAG DOUBLE Y Status of the Support Services Home Health documentation for this encounter
SS_NC_FLAG DOUBLE Y Status of the Support Services Nutrition Consult documentation for this encounter
SS_OT_FLAG DOUBLE Y Status of the Support Services Occ Therapy documentation for this encounter
SS_PC_FLAG DOUBLE Y Status of the Support Services Palliative Care documentation for this encounter
SS_PT_FLAG DOUBLE Y Status of the Support Services Physical Therapy documentation for this encounter
SS_RC_FLAG DOUBLE Y Status of the Support Services Rehab Consult documentation for this encounter
SS_SS_FLAG DOUBLE Y Status of the Support Services Social Services documentation for this encounter
SS_ST_FLAG DOUBLE Y Status of the Support Services Speech Therapy documentation for this encounter
TR_DC_FLAG DOUBLE Y Status of the Transition Readiness Discharge documentation for this encounter
TR_MED_REC_FLAG DOUBLE Y Status of the Transition Readiness Meds Rec documentation for this encounter
TR_ORDER_FLAG DOUBLE Y Status of the Transition Readiness Order documentation for this encounter
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_READMIT_STATUS


Child Column in LH_CNT_READMIT_STATUS(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_READMIT_WORKLIST_ID LH_CNT_READMIT_WORKLIST LH_CNT_READMIT_WORKLIST_ID


LH_CNT_READMIT_USER_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_READMIT_USER_LIST
Definition: This table will contain user specific saved filter settings used in the readmission worklist
Table Type: ACTIVITY





Column Detail - LH_CNT_READMIT_USER_LIST


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DEFAULT_IND DOUBLE N Field to indicate whether this list is the default set of filters for this user.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LH_CNT_READMIT_USER_LIST_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_READMIT_USER_LIST table.
LIST_NAME VARCHAR(255) Y Name of the saved filter list.
LONG_TEXT_ID DOUBLE N The row on LONG_TEXT table which contains the complete JSON string the readmission worklist will read to load the user defined saved filters.
PRSNL_ID DOUBLE N The prsnl_id of the user saving filters from the worklist.
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_READMIT_USER_LIST


Child Column in LH_CNT_READMIT_USER_LIST(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PRSNL_ID PRSNL PERSON_ID


LH_CNT_READMIT_WORKLIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_READMIT_WORKLIST
Definition: This table will contain a list of patients to be displayed in the Readmission Worklist Mpage
Table Type: ACTIVITY





Column Detail - LH_CNT_READMIT_WORKLIST


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.
ADDED_DT_TM DATETIME N Date and Time the row was added to the table.
ADDED_REASON_CD DOUBLE N Reason for manually adding a patient to the worklist.
ADDED_UPDT_ID DOUBLE N User who manually added the patient to the worklist.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
ENCNTR_ID DOUBLE N Encounter_ID for the patient qualified for Readmission Risk.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LH_CNT_READMIT_WORKLIST_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_READMIT_WORKLIST table.
MANUALLY_ADDED_IND DOUBLE N Indicates that this row was manually added to the worklist.
PERSON_ID DOUBLE N PERSON_ID for the patient qualified for Readmission Risk.
RATING_DT_TM DATETIME N Date/Time the rating was updated.
RATING_REASON_CD DOUBLE N Represents the reason the individual increased or decreased the rating for this person.
RATING_UPDT_ID DOUBLE N Individual that updated the rating.
RATING_VALUE DOUBLE N Represents the persons rating on the worklist.
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_READMIT_WORKLIST


Child Column in LH_CNT_READMIT_WORKLIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID




Parent Column in LH_CNT_READMIT_WORKLIST (PK) Child Table Name Child Column Name
Children: LH_CNT_READMIT_WORKLIST_ID LH_CNT_READMIT_RISK LH_CNT_READMIT_WORKLIST_ID
LH_CNT_READMIT_STATUS LH_CNT_READMIT_WORKLIST_ID
LH_CNT_WL_RATING LH_CNT_READMIT_WORKLIST_ID


LH_CNT_READ_WL_PT_HIST



Column Section Top of Page


Table-level Detail

Description: Readmission Worklist Patient History
Definition: Contains the historical records of patients that were placed on the Readmission Worklist.
Table Type: ACTIVITY





Column Detail - LH_CNT_READ_WL_PT_HIST


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.
ADDED_DT_TM DATETIME N Date/Time the patient was added
ADDED_REASON_CD DOUBLE N Reason patient was added to the worklist
ADDED_UPDT_ID DOUBLE N User who added the patient to the worklist
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
ENCNTR_ID DOUBLE N Encounter Id
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LH_CNT_READMIT_WORKLIST_ID DOUBLE N Original Key ID
LH_CNT_READ_WL_PT_HIST_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_READ_WL_PT_HIST table.
MANUALLY_ADDED_IND DOUBLE N Defines if the patient was manually added to the worklist
PERSON_ID DOUBLE N Person Id
RATING_DT_TM DATETIME N Date/Time the rating was created
RATING_REASON_CD DOUBLE N Reason for the rating
RATING_UPDT_ID DOUBLE N User who created the rating
RATING_VALUE DOUBLE N Current Rating value for the patient
REMOVE_DT_TM DATETIME N Date/Time patient was removed from the worklist
REMOVE_REASON_CD DOUBLE N Reason for removing the patient from the worklist
REMOVE_UPDT_ID DOUBLE N User who removed the patient from the worklist
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.


LH_CNT_SEP_ADVSR_SCENARIO



Column Section Top of Page


Table-level Detail

Description: LH_CNT_SEP_ADVSR_SCENARIO
Definition: This table is used to store scenarios that are used to create the Recommended Antibiotics section for the Sepsis Advisor 2020
Table Type: REFERENCE





Column Detail - LH_CNT_SEP_ADVSR_SCENARIO


Column Name Type Null? Definition
AGE_1 DOUBLE Y First age restriction, given in MINUTES
AGE_1_OP VARCHAR(2) Y The operator that goes along with Age_1 column
AGE_2 DOUBLE Y Second age restriction, given in MINUTES
AGE_2_OP VARCHAR(2) Y The operator that goes along with Age_2 column
CRCL_1 DOUBLE Y First CrCl restriction, given in mL/min
CRCL_1_OP VARCHAR(2) Y The operator that goes along with Crcl_1 column
CRCL_2 DOUBLE Y Second CrCl restriction, given in mL/min
CRCL_2_OP VARCHAR(2) Y The operator that goes along with Crcl_2 column
EST_GEST_AGE_1 DOUBLE Y First estimated gestational age restriction. * Obsolete Column **. Column no longer used after enhancement to solution Sepsis Advisor
EST_GEST_AGE_1_OP VARCHAR(2) Y The operator that goes along with est_gest_age_1 column. * Obsolete Column **. Column no longer used after enhancement to solution Sepsis Advisor
EST_GEST_AGE_2 DOUBLE Y Second estimated gestational age restriction. * Obsolete Column **. Column no longer used after enhancement to solution Sepsis Advisor
EST_GEST_AGE_2_OP VARCHAR(2) Y The operator that goes along with est_gest_age_2 column. * Obsolete Column **. Column no longer used after enhancement to solution Sepsis Advisor
FILTER_MEAN VARCHAR(30) Y Bedrock filter mean for the order scenario number
INFECTION_FACTOR VARCHAR(100) Y Infection factor for the scenario
INFECTION_SOURCE VARCHAR(100) Y Infection source for the scenario
LH_CNT_SEP_ADVSR_SCENARIO_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_SEP_ADVSR_SCENARIO table.
SCENARIO_NUMBER DOUBLE N Unique number that represents a specific scenario in the advisor
SPECIAL_DOSING VARCHAR(30) Y Special dosing restriction (e.g. Single Dose)
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.
WEIGHT_1 DOUBLE Y First weight restriction, given in GRAMS. * Obsolete Column **. Column no longer used after enhancement to solution Sepsis Advisor
WEIGHT_1_OP VARCHAR(2) Y The operator that goes along with Weight_1 column. * Obsolete Column **. Column no longer used after enhancement to solution Sepsis Advisor
WEIGHT_2 DOUBLE Y Second weight restriction, given in GRAMS. * Obsolete Column **. Column no longer used after enhancement to solution Sepsis Advisor
WEIGHT_2_OP VARCHAR(2) Y The operator that goes along with Weight_2 column. * Obsolete Column **. Column no longer used after enhancement to solution Sepsis Advisor