ORDER_TASK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ORDER TASK |
Definition: | Table that contains the tasks that can be done in relation to an order. |
Table Type: | REFERENCE |
Column Detail - ORDER_TASK
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. |
ALLPOSITIONCHART_IND | DOUBLE | Y | An indicator that identifies whether this task can be charted by any position. |
APP_OBJECT_NAME | VARCHAR(255) | Y | For MRNet: To determine what app needs to execute in order to complete the task |
CAPTURE_BILL_INFO_IND | DOUBLE | Y | Should charting applications prompt for additional billing information when the task is charted |
CERNERTASK_FLAG | DOUBLE | Y | A flag that will identify a certain number of Cerner defined tasks not to be changed by the user. |
CHART_NOT_CMPLT_IND | DOUBLE | Y | An indicator that identifies whether this task can be charted as not complete. |
DCP_FORMS_REF_ID | DOUBLE | N | This is a unique identifier for the charting form. |
EVENT_CD | DOUBLE | N | The event code that will be used for charting the specified task. |
GRACE_PERIOD_MINS | DOUBLE | N | Used to calculate the time window during which to update the task. |
IGNORE_REQ_IND | DOUBLE | Y | An indicator that identifies whether the required fields will be ignored when the task is invoked from ad hoc charting. |
OVERDUE_MIN | DOUBLE | Y | The number of minutes used to define when a task is considered overdue. |
OVERDUE_UNITS | DOUBLE | Y | Identifies whether or not overdue value is in terms of minutes or hours |
PROCESS_LOCATION_CD | DOUBLE | N | Location of where the task is being performed |
QUICK_CHART_DONE_IND | DOUBLE | Y | An indicator that identifies whether this task can be quick charted as done. |
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. |
REFERENCE_TASK_ID | DOUBLE | N | A unique, generated number that is used to identify this task. |
RESCHEDULE_TIME | DOUBLE | Y | The number of hours a task can be rescheduled |
RETAIN_TIME | DOUBLE | Y | The number of min/hours/weeks that is used to determined 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, or weeks are being used in reference to the retain_timefield. (values are 1 - 4) |
TASK_ACTIVITY_CD | DOUBLE | N | The type of activity that can be placed upon an order (i.e. chart, review, sign, etc.) |
TASK_DESCRIPTION | VARCHAR(100) | Y | The description of the task. |
TASK_DESCRIPTION_KEY | VARCHAR(100) | Y | The description of the task in uppercase used to access the table. |
TASK_DESCRIPTION_KEY_A_NLS | VARCHAR(400) | Y | TASK_DESCRIPTION_KEY_A_NLS column |
TASK_DESCRIPTION_KEY_NLS | VARCHAR(202) | Y | international key field |
TASK_TYPE_CD | DOUBLE | N | 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. |
Relationship Detail - ORDER_TASK
Parent Column in ORDER_TASK (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | REFERENCE_TASK_ID | ACT_PW_COMP | REFERENCE_TASK_ID |
ALT_SEL_LIST | REFERENCE_TASK_ID | ||
ORDER_TASK_POSITION_XREF | REFERENCE_TASK_ID | ||
ORDER_TASK_RESPONSE | REFERENCE_TASK_ID | ||
ORDER_TASK_RESPONSE | RESPONSE_TASK_ID | ||
ORDER_TASK_XREF | REFERENCE_TASK_ID | ||
OUTCOME_ACTIVITY | REFERENCE_TASK_ID | ||
OUTCOME_CATALOG | REFERENCE_TASK_ID | ||
PATHWAY_COMP | REFERENCE_TASK_ID | ||
TASK_ACTIVITY | REFERENCE_TASK_ID | ||
TASK_CHARTING_AGENT_R | REFERENCE_TASK_ID | ||
TASK_DISCRETE_R | REFERENCE_TASK_ID |
ORDER_TASK_POSITION_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ORDER TASK POSITION XREF |
Definition: | Defines which positions can perform a specific task. |
Table Type: | REFERENCE |
Column Detail - ORDER_TASK_POSITION_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
POSITION_CD | DOUBLE | N | The position_cd used to identify what positions may perform action against this task. |
REFERENCE_TASK_ID | DOUBLE | N | The reference_task_id from the order_task 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. |
Relationship Detail - ORDER_TASK_POSITION_XREF
Child Column in ORDER_TASK_POSITION_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REFERENCE_TASK_ID | ORDER_TASK | REFERENCE_TASK_ID |
ORDER_TASK_PROFILE_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Defines the discrete task assays that are associated with an ORC/OT relationship |
Definition: | order_task_profile_xref |
Table Type: | REFERENCE |
Column Detail - ORDER_TASK_PROFILE_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | Foreign key from order_catalog table. |
REFERENCE_TASK_ID | DOUBLE | N | Foreign key to order_task table. |
TASK_ASSAY_CD | DOUBLE | N | Foreign key from discrete_task_assay 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 - ORDER_TASK_PROFILE_XREF
Child Column in ORDER_TASK_PROFILE_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_TASK_XREF | CATALOG_CD |
REFERENCE_TASK_ID | ORDER_TASK_XREF | REFERENCE_TASK_ID | |
CATALOG_CD | PROFILE_TASK_R | CATALOG_CD | |
TASK_ASSAY_CD | PROFILE_TASK_R | TASK_ASSAY_CD |
ORDER_TASK_RESPONSE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | USED TO DEFINE THE RELATIONSHIP BETWEEN A TASK AND IT'S RESPONSE TASK |
Definition: | USED TO DEFINE THE RELATIONSHIP BETWEEN A TASK AND IT'S RESPONSE TASK TO SUPPORT THE CREATION OF PRN RESPONSE TASKS. |
Table Type: | REFERENCE |
Column Detail - ORDER_TASK_RESPONSE
Column Name | Type | Null? | Definition |
---|---|---|---|
ORDER_TASK_RESPONSE_ID | DOUBLE | N | UNIQUE_ID |
QUALIFICATION_FLAG | DOUBLE | N | The type of task that a response task can be generated for. |
REFERENCE_TASK_ID | DOUBLE | N | Entry on order_task table that we are relating a response task to. |
RESPONSE_MINUTES | DOUBLE | Y | Number of minutes after the completion of the intervention task that the response task will be scheduled for. |
RESPONSE_TASK_ID | DOUBLE | N | Entry on order_task taht represents the response task. |
ROUTE_CD | DOUBLE | N | Entry from codeset 4001 that indicates if the response is defined for a specific route of administration for medication tasks. |
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 - ORDER_TASK_RESPONSE
Child Column in ORDER_TASK_RESPONSE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REFERENCE_TASK_ID | ORDER_TASK | REFERENCE_TASK_ID |
RESPONSE_TASK_ID | ORDER_TASK | REFERENCE_TASK_ID |
ORDER_TASK_SYNONYM_XREF
Column Section | Top of Page |
Table-level Detail
Description: | ORDER TASK SYNONYM XREF |
Definition: | Holds task descriptions specific for each synonym of an order catalog item. |
Table Type: | REFERENCE |
Column Detail - ORDER_TASK_SYNONYM_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | The catalog_cd from the orders table. |
REFERENCE_TASK_ID | DOUBLE | N | The reference_task_id from the order task table. |
SYNONYM_ID | DOUBLE | N | The synonym_id from the order_catalog_synonym table. |
TASK_SYNONYM_DESC | VARCHAR(100) | Y | A user_definable synonym-specific description for the 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. |