TL_COLUMN_CONTENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TL COLUMN CONTENT |
Definition: | Holds the column names defined for a specific tab for the tasklist. |
Table Type: | REFERENCE |
Column Detail - TL_COLUMN_CONTENT
Column Name | Type | Null? | Definition |
---|---|---|---|
COLUMN_MEANING | VARCHAR(12) | Y | The column header of the specific column.Column |
COLUMN_NBR | DOUBLE | N | A number that identifies which column in the list that this entry corresponds with. |
TL_TAB_ID | DOUBLE | N | A unique, generated number that identifies a specific tab.Column |
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 - TL_COLUMN_CONTENT
Child Column in TL_COLUMN_CONTENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TL_TAB_ID | TL_TAB_CONTENT | TL_TAB_ID |
TL_ELIGIBLE_TASK_CODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TL ELIGIBLE TASK CODE |
Definition: | Holds all specific task types for a specific tab for the tasklist. |
Table Type: | REFERENCE |
Column Detail - TL_ELIGIBLE_TASK_CODE
Column Name | Type | Null? | Definition |
---|---|---|---|
DESCRIPTION | VARCHAR(60) | Y | The description of the specific task type identified by the task_type_cd.Column |
TASK_TYPE_CD | DOUBLE | N | The task_type_cd from the task type codeset that identifies a specific task type. |
TL_TAB_ID | DOUBLE | N | A unique, generated number that identifies a specific tab.Column |
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 - TL_ELIGIBLE_TASK_CODE
Child Column in TL_ELIGIBLE_TASK_CODE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TL_TAB_ID | TL_TAB_CONTENT | TL_TAB_ID |
TL_MASTER_TAB_SET
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TL MASTER TAB SET |
Definition: | Holds the define d/t and user for the application default info. for the tasklist |
Table Type: | REFERENCE |
Column Detail - TL_MASTER_TAB_SET
Column Name | Type | Null? | Definition |
---|---|---|---|
DEFINE_DT_TM | DATETIME | Y | The date and time that the application default information was originally defined. |
DEFINE_ID | DOUBLE | N | The id of the person who originally defined the application default information.Column |
MASTER_TAB_ID | DOUBLE | N | A unique number that identifies the application default definition.Value will be either 111111 or 0 depending on option selected in tool. |
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 - TL_MASTER_TAB_SET
Parent Column in TL_MASTER_TAB_SET (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MASTER_TAB_ID | TL_MASTER_TAB_SET_XREF | MASTER_TAB_ID |
TL_MASTER_TAB_SET_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TL MASTER TAB SET XREF |
Definition: | Holds the tabs defined for the application default for the tasklist. |
Table Type: | REFERENCE |
Column Detail - TL_MASTER_TAB_SET_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
MASTER_TAB_ID | DOUBLE | N | A unique number that identifies the application default definition.Column |
MASTER_TAB_NBR | DOUBLE | Y | A number that identifies which tab in the list that the tl_tab_cd corresponds with. |
TL_TAB_ID | DOUBLE | N | A unique, generated number that identifies a specific tab.Column |
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 - TL_MASTER_TAB_SET_XREF
Child Column in TL_MASTER_TAB_SET_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MASTER_TAB_ID | TL_MASTER_TAB_SET | MASTER_TAB_ID |
TL_TAB_ID | TL_TAB_CONTENT | TL_TAB_ID |
TL_MULTIPATIENT_XREF
Column Section | Top of Page |
Table-level Detail
Description: | TL MULTIPATIENT XREF |
Definition: | Indicates whether the code is for a person, role, or default. |
Table Type: | REFERENCE |
Column Detail - TL_MULTIPATIENT_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
MULTIPATIENT_DEFAULT_PREF | DOUBLE | Y | A number that identifies which of seven possibilities is used as a view default. 1: all patients, 2: all pats in a specific loc, 3: all pats assigned to a prov., 4: all pats in a pat list, 5: all tasks, 6: all tasks assigned to a prov, 7: all tasks that prov has priv. |
MULTIPATIENT_IND | DOUBLE | N | An indicator used to determine if the parent_entity_cd is a person, position, or application default. 0 = person, 1 - position, 2 = app default. |
PARENT_ENTITY_ID | DOUBLE | N | A unique number that is used to identify a specific person, position, or app default. |
PARENT_ENTITY_NAME | VARCHAR(30) | Y | The name of the parent table that corresponds to the parent_entity_cd: PERSON, PRNSL_ROLE, or MASTER |
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. |