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 |