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 |