Table Detail Report

TASK_DISCRETE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: TASK DISCRETE R
Definition: Cross reference between order_task and discrete_task_assay
Table Type: REFERENCE





Column Detail - TASK_DISCRETE_R


Column Name Type Null? Definition
ACKNOWLEDGE_IND DOUBLE N Indicates if the user will be able to acknowledge this result.
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.
DOCUMENT_IND DOUBLE N Indicates if the user will be able to document on this field. Default is 1.
REFERENCE_TASK_ID DOUBLE N Foreign key to order_task.
REQUIRED_IND DOUBLE Y Defines if the discrete is required to be charted
SEQUENCE DOUBLE Y Determines sequence of discretes for the order_task
TASK_ASSAY_CD DOUBLE N Foreign key to discrete_task_assay
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_ONLY_IND DOUBLE N Indicates if the user is restricted to only view this field.



Relationship Detail - TASK_DISCRETE_R


Child Column in TASK_DISCRETE_R(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
REFERENCE_TASK_ID ORDER_TASK REFERENCE_TASK_ID