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. |