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.