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.