Table Detail Report

LH_CNT_WL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Content Worklist
Definition: This table holds various worklist id's used to determine which worklist filters will be returned back to a worklist mpage.
Table Type: REFERENCE





Column Detail - LH_CNT_WL


Column Name Type Null? Definition
LH_CNT_WL_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_WL 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.
WORKLIST_MEAN VARCHAR(50) N Unique name given to each worklist to help in various filtering processes.
WORKLIST_NAME VARCHAR(255) N A more readable version of the Worklist Mean.



Relationship Detail - LH_CNT_WL




Parent Column in LH_CNT_WL (PK) Child Table Name Child Column Name
Children: LH_CNT_WL_ID LH_CNT_WL_FLTR_LIST LH_CNT_WL_ID
LH_CNT_WL_POP LH_CNT_WL_ID
LH_CNT_WL_POP_H LH_CNT_WL_ID


LH_CNT_WL_FACTOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_WL_FACTOR
Definition: This table stores the factors for the population rows found on the LH_CNT_WL_POP table.
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_FACTOR


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.
CLOUD_IDENT VARCHAR(255) Y Unique identifier for cloud payloads indicating a factor value. Used for troubleshooting.
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_TXT VARCHAR(255) Y Factor text value. Not used by all risk factor types.
FACTOR_TYPE_CD DOUBLE N Factor type. Ex. AMI, PNEU, NEWS, PEWS, Sepsis, etc.
FACTOR_VALUE DOUBLE N Factor numeric value. Not used by all risk factor types.
LH_CNT_WL_FACTOR_ID DOUBLE N PRIMARY KEY
LH_CNT_WL_POP_ID DOUBLE N Foreign key of the associated population member.
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


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




Parent Column in LH_CNT_WL_FACTOR (PK) Child Table Name Child Column Name
Children: LH_CNT_WL_FACTOR_ID LH_CNT_WL_FACTOR_DETAIL LH_CNT_WL_FACTOR_ID
LH_CNT_WL_FACTOR_STATUS LH_CNT_WL_FACTOR_ID


LH_CNT_WL_FACTOR_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_WL_FACTOR_DETAIL
Definition: This table is used to store details regarding a single factor (a row in lh_cnt_wl_factor)
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_FACTOR_DETAIL


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.
DETAIL_TXT VARCHAR(255) Y This column will be used to store any textual information that needs to be saved for the detail
DETAIL_TYPE_CD DOUBLE N CODE SET: 4003482. Identifies what kind of information this detail row stores. Examples include: Order information, Severity information, Clinical Event information, etc.
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.
KEY_IND DOUBLE N Used to group a set of details together to form a "key"
LH_CNT_WL_FACTOR_DETAIL_ID DOUBLE N PRIMARY KEY
LH_CNT_WL_FACTOR_ID DOUBLE N Foreign Key to LH_CNT_WL_FACTOR
PARENT_ENTITY_ID DOUBLE N The Unique Identifier from the corresponding table referenced in PARENT_ENTITY_NAME which identifies patient attribute.
PARENT_ENTITY_NAME VARCHAR(30) Y The upper case name of the table to which this address row is related (i.e., ORDER,CLINICAL_EVENT,CATALOG_CD, etc.)
PARENT_FACTOR_DETAIL_ID DOUBLE N Used to define a detail hierarchy. A detail can have zero or more child details
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_DETAIL


Child Column in LH_CNT_WL_FACTOR_DETAIL(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_WL_FACTOR_ID LH_CNT_WL_FACTOR LH_CNT_WL_FACTOR_ID
PARENT_FACTOR_DETAIL_ID LH_CNT_WL_FACTOR_DETAIL LH_CNT_WL_FACTOR_DETAIL_ID




Parent Column in LH_CNT_WL_FACTOR_DETAIL (PK) Child Table Name Child Column Name
Children: LH_CNT_WL_FACTOR_DETAIL_ID LH_CNT_WL_FACTOR_DETAIL PARENT_FACTOR_DETAIL_ID


LH_CNT_WL_FACTOR_DETAIL_H



Column Section Top of Page


Table-level Detail

Description: LH_CNT_WL_FACTOR_DETAIL_HIST
Definition: This table is used to store the history of table LH_CNT_WL_FACTOR_DETAIL
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_FACTOR_DETAIL_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.
DETAIL_TXT VARCHAR(255) Y This column will be used to store any textual information that needs to be saved for the detail
DETAIL_TYPE_CD DOUBLE N CODE SET: 4003482. Identifies what kind of information this detail row stores. Examples include: Order information, Severity information, Clinical Event information, etc.
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.
KEY_IND DOUBLE N Used to group a set of details together to form a "key"
LH_CNT_WL_FACTOR_DETAIL_H_ID DOUBLE N PRIMARY KEY
LH_CNT_WL_FACTOR_DETAIL_ID DOUBLE N FK Value from the LH_CNT_WL_FACTOR_DETAIL table
LH_CNT_WL_FACTOR_ID DOUBLE N Foreign Key to LH_CNT_WL_FACTOR
PARENT_ENTITY_ID DOUBLE N The Unique Identifier from the corresponding table referenced in PARENT_ENTITY_NAME which identifies patient attribute.
PARENT_ENTITY_NAME VARCHAR(30) Y The upper case name of the table to which this address row is related (i.e., ORDER,CLINICAL_EVENT,CATALOG_CD, etc.)
PARENT_FACTOR_DETAIL_ID DOUBLE N Used to define a detail hierarchy. A detail can have zero or more child details
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_FACTOR_H



Column Section Top of Page


Table-level Detail

Description: LH_CNT_WL_FACTOR_HIST
Definition: This table store historical data the from LH_CNT_WL_FACTOR table.
Table Type: ACTIVITY





Column Detail - LH_CNT_WL_FACTOR_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.
CLOUD_IDENT VARCHAR(255) Y Unique identifier for cloud payloads indicating a factor value. Used for troubleshooting
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_TXT VARCHAR(255) Y Factor text value. Not used by all risk factor types.
FACTOR_TYPE_CD DOUBLE N Factor type. Ex. AMI
FACTOR_VALUE DOUBLE N Factor numeric value. Not used by all risk factor types.
LH_CNT_WL_FACTOR_H_ID DOUBLE N Primary Key
LH_CNT_WL_FACTOR_ID DOUBLE N FK to parent row.
LH_CNT_WL_POP_ID DOUBLE N Foreign key of the associated population member.
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.