Table Detail Report

LH_CNT_WL_POP_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_WL_POP_STATUS_HIST
Definition: This table stores the addition/removal history of a population.
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_POP_STATUS


Column Name Type Null? Definition
ADDED_REASON_CD DOUBLE N Reason the patient was added.
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.
END_EFFECTIVE_DT_TM DATETIME Y 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_WL_POP_ID DOUBLE N Foreign key of the associated population member.
LH_CNT_WL_POP_STATUS_ID DOUBLE N Primary key of the table.
REMOVED_REASON_CD DOUBLE N Reason the patient was removed.
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_WL_POP_STATUS


Child Column in LH_CNT_WL_POP_STATUS(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_WL_POP_ID LH_CNT_WL_POP LH_CNT_WL_POP_ID


LH_CNT_WL_POP_STATUS_H



Column Section Top of Page


Table-level Detail

Description: LH_CNT_WL_POP_STATUS_H
Definition: This table is used to store the history of the LH_CNT_WL_POP_STATUS table.
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_POP_STATUS_H


Column Name Type Null? Definition
ADDED_REASON_CD DOUBLE N Reason the patient was added.
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.
END_EFFECTIVE_DT_TM DATETIME Y 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_WL_POP_ID DOUBLE N Foreign key of the associated population member.
LH_CNT_WL_POP_STATUS_H_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_WL_POP_STATUS_H table.
LH_CNT_WL_POP_STATUS_ID DOUBLE N Foreign key of the associated population status.
REMOVED_REASON_CD DOUBLE N Reason the patient was removed.
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_WL_RATING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Content Worklist Rating
Definition: This table contains the historical record of changes made to a persons Worklist Rating.
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_RATING


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.
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 The ID of the re-admit worklist related to this rating.
LH_CNT_WL_RATING_ID DOUBLE N The unique primary key of this table.
RATING_REASON_CD DOUBLE N Represents the reason the individual increased or decreased the rating for this person.
RATING_UPDT_DT_TM DATETIME N The Date/Time Rating was updated.
RATING_UPDT_ID DOUBLE N Individual that update the rating.
RATING_VALUE DOUBLE N Numerical representation of the persons rating.
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_WL_RATING


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


LH_CNT_WL_RATING_HIST



Column Section Top of Page


Table-level Detail

Description: LH_CNT_WL_RATING_HIST
Definition: Holds the history of the rating associated to patients in the readmission worklist
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_RATING_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.
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.
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 ID of corresponding row on the LH_CNT_READMIT_WORKLIST table
LH_CNT_WL_RATING_HIST_ID DOUBLE N PRIMARY KEY
LH_CNT_WL_RATING_ID DOUBLE N ID of corresponding row on the LH_CNT_WL_RATING table
RATING_REASON_CD DOUBLE N The reason code from code set 4003033
RATING_UPDT_DT_TM DATETIME N Date & time that the rating was assigned to the patient
RATING_UPDT_ID DOUBLE N The id of person who assigned the rating to the patient
RATING_VALUE DOUBLE N Rating value of the patient
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.