Table Detail Report

LH_CNT_WL_FACTOR_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_WL_FACTOR_STATUS
Definition: This table is used to store the status of a single factor (a row in lh_cnt_wl_factor)
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_FACTOR_STATUS


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
FACTOR_STATUS_CD DOUBLE N CODE SET: 4003478. The factor status value.
FACTOR_STATUS_END_DT_TM DATETIME Y The date time at which this status will no longer be active
LH_CNT_WL_FACTOR_ID DOUBLE N Foreign key to LH_CNT_WL_FACTOR
LH_CNT_WL_FACTOR_STATUS_ID DOUBLE N PRIMARY KEY
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_FACTOR_STATUS


Child Column in LH_CNT_WL_FACTOR_STATUS(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_WL_FACTOR_ID LH_CNT_WL_FACTOR LH_CNT_WL_FACTOR_ID


LH_CNT_WL_FACTOR_STATUS_H



Column Section Top of Page


Table-level Detail

Description: LH_CNT_WL_FACTOR_STATUS_HIST
Definition: This table is used to store the history of the LH_CNT_WL_FACTOR_STATUS table
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_FACTOR_STATUS_H


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
FACTOR_STATUS_CD DOUBLE N CODE SET: 4003478. The factor status value
FACTOR_STATUS_END_DT_TM DATETIME Y The date time at which this status will no longer be active
LH_CNT_WL_FACTOR_ID DOUBLE N Foreign key to LH_CNT_WL_FACTOR
LH_CNT_WL_FACTOR_STATUS_H_ID DOUBLE N PRIMARY KEY
LH_CNT_WL_FACTOR_STATUS_ID DOUBLE N FK Value from the LH_CNT_WL_FACTOR_STATUS table
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.


LH_CNT_WL_FLTR_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Content Worklist Filter List
Definition: This table holds saved worklist filters by user id.
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_FLTR_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.
DEFAULT_IND DOUBLE N This value determines if the worklist Mpage when loaded will pull in this record's value by default.
LH_CNT_WL_FLTR_LIST_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_WL_FLTR_LIST table.
LH_CNT_WL_ID DOUBLE N Foreign key that links to LH_CNT_WL
LIST_NAME VARCHAR(255) N Name given to define the filters being saved by the user.
LONG_TEXT_ID DOUBLE N Foreign key that links to LONG_TEXT where the filter JSON string is stored.
PRSNL_ID DOUBLE N User ID of person who created/updated the record.
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_FLTR_LIST


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


LH_CNT_WL_POP



Column Section Relationship Section Top of Page


Table-level Detail

Description: lh_cnt_wl_pop
Definition: This table stores the relationship between encounters and the LH_CNT_WL table. Effectively identifying the underlying populations for a given worklist.
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_POP


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.
ENCNTR_ID DOUBLE N The foreign key to the parent row on the ENCOUNTER table, indicating which encounter is being associated to a worklist.
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_ID DOUBLE N The foreign key to the parent row on the LH_CNT_WL table, indicating which worklist this encounter belongs to.
LH_CNT_WL_POP_ID DOUBLE N PRIMARY KEY
PERSON_ID DOUBLE N The foreign key to the parent row on the PERSON table, indicating which person is being associated to a worklist.
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_WL_POP


Child Column in LH_CNT_WL_POP(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LH_CNT_WL_ID LH_CNT_WL LH_CNT_WL_ID
PERSON_ID PERSON PERSON_ID




Parent Column in LH_CNT_WL_POP (PK) Child Table Name Child Column Name
Children: LH_CNT_WL_POP_ID LH_CNT_WL_FACTOR LH_CNT_WL_POP_ID
LH_CNT_WL_POP_STATUS LH_CNT_WL_POP_ID


LH_CNT_WL_POP_H



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_WL_POP_HIST
Definition: Archive for lh_cnt_wl_pop table. This table stores the relationship between encounters and the LH_CNT_WL table. Effectively identifying the underlying populations for a given worklist.
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_POP_H


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.
ENCNTR_ID DOUBLE N The foreign key to the parent row on the ENCOUNTER table.
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_ID DOUBLE N The foreign key to the parent row on the LH_CNT_WL table.
LH_CNT_WL_POP_H_ID DOUBLE N PRIMARY KEY
LH_CNT_WL_POP_ID DOUBLE N The foreign key to the parent row on the LH_CNT_WL_POP table.
PERSON_ID DOUBLE N The foreign key to the parent row on the PERSON 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_WL_POP_H


Child Column in LH_CNT_WL_POP_H(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LH_CNT_WL_ID LH_CNT_WL LH_CNT_WL_ID
PERSON_ID PERSON PERSON_ID