Table Detail Report

TL_MULTPAT_COL_CONTENT



Column Section Top of Page


Table-level Detail

Description: TL MULTPAT COL CONTENT
Definition: The column names defined for a specific tab while in multipatient mode.
Table Type: REFERENCE





Column Detail - TL_MULTPAT_COL_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.
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 parent entity name
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.


TL_PURGE_CRITERIA



Column Section Top of Page


Table-level Detail

Description: Task List Purge Criteria
Definition: Defines the purge and retention criteria for task_activity records.
Table Type: REFERENCE





Column Detail - TL_PURGE_CRITERIA


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ARCHIVE_IND DOUBLE Y This field defines whether the qualifying task activity records should be archived before purging.
ORDER_STATUS_FLAG DOUBLE Y This field determines the order statuses that qualify a task_activity record for purge.
PATIENT_STATUS_FLAG DOUBLE Y This field determines the patient status to qualify a task activity record for purge.
PURGE_ACTIVE_FLAG DOUBLE Y This field determines whether the active status of a task activity record qualifies it of rpurge.
RETENTION_DAYS DOUBLE Y This field defines the number of days after a specified event that the task activity record should remain in the active data.
TASK_STATUS_FLAG DOUBLE Y This field determines what task statuses qualify a task activity record for purge.
TASK_TYPE_CD DOUBLE Y This field determines the task types that qualify a task activity record for purge.
TL_PURGE_DESCRIPTION VARCHAR(100) Y This field names the purge criteria entry.
TL_PURGE_ID DOUBLE N This field is a generated number that uniquely identifies the purge criteria record to the system.
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.


TL_QUICK_BUILD_PARAMS



Column Section Top of Page


Table-level Detail

Description: TL QUICK BUILD PARAMS
Definition: Holds the values when quick build functionality is executed.
Table Type: REFERENCE





Column Detail - TL_QUICK_BUILD_PARAMS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVITY_TYPE_CD DOUBLE N The activity_type_cd from the activity type codeset.Column
ALLPOSITIONCHART_IND DOUBLE Y An indicator that identifies whether this task can be charted by any position.Column
ANCILLARY_SYNONYM_IND DOUBLE Y An indicator that identifies whether the task will be built with the ancillary synonym.
BUILD_EVENT_CD_IND DOUBLE Y Identifies whether or not to build an event cdColumn
BUILD_INPUT_FORM_IND DOUBLE Y Defines whether a new input form template should be automatically generated.
CATALOG_TYPE_CD DOUBLE N The catalog_type_cd from the catalog type codeset.Column
CHART_NOT_CMPLT_IND DOUBLE Y An indicator that identifies whether this task can be charted as not complete.Column
DCP_SYNONYM_IND DOUBLE Y An indicator that identifies whether the task will be built with the dcp synonym.
INPUT_FORM_CD DOUBLE Y The input (charting) form to be associated with the tasks built.
OVERDUE_MIN DOUBLE Y The number of minutes used to define when a task is considered overdue.Column
OVERDUE_UNITS DOUBLE Y Identifies whether the overdue value is in minutes or hours
PRIMARY_SYNONYM_IND DOUBLE Y An indicator that identifies whether the task will be built with the primary synonym.
QUICK_CHART_DONE_IND DOUBLE Y An indicator that identifies whether this task can be quick charted as done.Column
QUICK_CHART_IND DOUBLE Y Identifies whether or not the specified task can be quick charted (future functionality)
QUICK_CHART_NOTDONE_IND DOUBLE Y An indicator that identifies whether this task can be quick charted as not done.Column
RESCHEDULE_TIME DOUBLE Y The number of hours that a task can be rescheduled.
RETAIN_TIME DOUBLE Y The number of minutes/hours/days/weeks that is used to determine if a task is overdue and whether the task should be included on the task list.
RETAIN_UNITS DOUBLE Y The unit that determines if minutes, hours, days, or weeks are being used in reference to the retain_time field. (values are 1 - 4)
TASK_TYPE_CD DOUBLE Y The task_type_cd, from the task type codeset, that is defined for this task.
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.


TL_QUICK_BUILD_POSITION_XREF



Column Section Top of Page


Table-level Detail

Description: TL QUICK BUILD POSITION XREF
Definition: Defines which positions can perform a specific task for the quick build action.
Table Type: REFERENCE





Column Detail - TL_QUICK_BUILD_POSITION_XREF


Column Name Type Null? Definition
ACTIVITY_TYPE_CD DOUBLE N The activity_type_cd from the activity_type codeset.Column
CATALOG_TYPE_CD DOUBLE N The catalog_type_cd from the catalog_type codeset.Column
POSITION_CD DOUBLE N The position_cd used to identify what positions may perform action against this task.
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.


TL_TAB_CONTENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: TL TAB CONTENT
Definition: Hold the values to the tab content fields for a specific tab for the tasklist.
Table Type: REFERENCE





Column Detail - TL_TAB_CONTENT


Column Name Type Null? Definition
ALLSTATUS_IND DOUBLE Y An indicator that identifies whether tasks of any status should be included on this tab.
ALLTIMEPARAM_IND DOUBLE Y An indicator that identifies whether tasks of any time parameter should be included on this tab.
COMPLETE_IND DOUBLE Y An indicator that identifies whether completed tasks should be included on this tab.
CONTINUOUS_IND DOUBLE Y An indicator that identifies whether continuous tasks should be included on this tab.
DISCONTINUED_IND DOUBLE Y An indicator that identifies whether discontinued tasks should be included on this tab.
INPROCESS_IND DOUBLE Y An indicator that identifies whether inprocess tasks should be included on this tab.
IV_IND DOUBLE Y An indicator that identifies whether iv tasks should be included on this tab.Column
LOCATION_CD DOUBLE N Location_cd of the task group view location group associated with this task view.
MED_FLAG DOUBLE Y An indicator that identifies whether no meds, all meds, or some meds are being defined (0 = none, 1= all meds, 2 = selected meds).
NONPATIENT_IND DOUBLE Y An indicator that identifies whether non patient tasks should be included on this tab.
NONPHYSORDER_IND DOUBLE Y An indicator that identifies whether nonphysician ordered tasks should be included on this tab.
NONSCHEDULED_IND DOUBLE Y An indicator that identifies whether nonscheduled tasks should be included on this tab.
OUTCOMES_IND DOUBLE Y An indicator that identifies whether outcomes tasks should be included on this tab.
OVERDUE_IND DOUBLE Y An indicator that identifies whether overdue tasks should be included on this tab.
PENDINGVALIDATION_IND DOUBLE Y An indicator that identifies whether tasks in a pending validation status should be displayed in this tab.
PENDING_IND DOUBLE Y An indicator that identifies whether pending tasks should be included on this tab.
PHYSORDER_IND DOUBLE Y An indicator that identifies whether physician ordered tasks should be included on this tab.
POSITION_CD DOUBLE N A position_cd that corresponds with who can perform an action against a task and is used when determining which tasks will be represented in a task list.
POSITION_FLAG DOUBLE Y An indicator that identifies whether no positions, all positions, or some positions are being defined (0 = none, 1 = all, 2 = selected positions).
PRN_IND DOUBLE Y An indicator that identifies whether prn tasks should be included on this tab.Column
RESPONSE_IND DOUBLE Y An indicator that identifies whether response tasks should be included on this tab.
SCHEDULED_IND DOUBLE Y An indicator that identifies whether scheduled tasks should be included on this tab.
SUSPEND_IND DOUBLE Y This column defines whether suspended tasks are displayed in the task list.
TAB_NAME VARCHAR(25) Y The name of the specific tab.Column
TL_TAB_ID DOUBLE N A unique, generated number that identifies a specific tab.Column
TPN_IND DOUBLE Y An indicator that identifies whether tpn tasks should be included on this tab.Column
TYPE_FLAG DOUBLE Y An indicator that identifies whether no task types, all types, or some types are being defined (0 =none, 1 = all, 2 = selected task types).
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.
VIEW_COMP_PREFS_ID DOUBLE N This column is a foreign key to the view_comp_prefs table.
VIEW_MODE_FLAG DOUBLE Y This field defines whether the task list will display in task view or order view.
VIEW_PREFS_MP_ID DOUBLE N This column is a foreign key to the view_prefs table for multi-patient tasklist.
VIEW_PREFS_SP_ID DOUBLE N This column is a foreign key to the view_prefs table.Column



Relationship Detail - TL_TAB_CONTENT




Parent Column in TL_TAB_CONTENT (PK) Child Table Name Child Column Name
Children: TL_TAB_ID TL_COLUMN_CONTENT TL_TAB_ID
TL_ELIGIBLE_TASK_CODE TL_TAB_ID
TL_MASTER_TAB_SET_XREF TL_TAB_ID
TL_TAB_MEDICATION TL_TAB_ID
TL_TAB_POSITION_XREF TL_TAB_ID
TL_USER_XREF TL_TAB_ID