Table Detail Report

PROCESSING_TASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Processing Task
Definition: This activity table contains records for processing tasks ordered for current pathology cases. Parameters specific to the processing tasks, and their status, are included.
Table Type: ACTIVITY





Column Detail - PROCESSING_TASK


Column Name Type Null? Definition
CANCEL_CD DOUBLE N If the processing task is cancelled, this field contains the identification code associated with the cancellation reason.
CANCEL_DT_TM DATETIME Y If the processing task is cancelled, this field contains the date and time the cancellation event occurred.
CANCEL_PRSNL_ID DOUBLE N If the processing task is cancelled, this field contains the internal identification code of the user who executed the cancellation event. This value could be used to join to user information stored on the PRSNL and PERSON tables.
CASE_ID DOUBLE N This field contains the foreign key value used to join to case information stored on the PATHOLOGY_CASE activity table.
CASE_SPECIMEN_ID DOUBLE N This field contains the foreign key value used to join to specimen information stored on the CASE_SPECIMEN table. This field represents the specimen to which the processing task is associated.
CASE_SPECIMEN_TAG_ID DOUBLE N This field contains an identifier referencing the identification code assigned to the specimen to which this processing task is associated.
CASSETTE_ID DOUBLE N This field contains the foreign key value used to join to block/cassette information stored on the CASSETTE table. This field represents the block/cassette to which the processing task is associated.
CASSETTE_TAG_ID DOUBLE N This field contains an identifier referencing the identification code assigned to the block/cassette to which this processing task is associated.
COMMENTS VARCHAR(500) Y This field in no longer used. Refer to the COMMENTS_LONG_TEXT_ID for information regarding the processing ORDER COMMENT.
COMMENTS_LONG_TEXT_ID DOUBLE N This field contains the value representing the entry on the LONG_TEXT table that contains the order comment.
CREATE_INVENTORY_FLAG DOUBLE Y This field contains a numeric flag value indicating whether or not the completion of the associated processing task (discrete task) causes one or more pathology inventory records to be created.
HOLD_CD DOUBLE N This field is not used at this time.
HOLD_COMMENT VARCHAR(100) Y This field is not used at this time.
HOLD_COMMENT_LONG_TEXT_ID DOUBLE N This field is not used at this time.
HOLD_DT_TM DATETIME Y This field is not used at this time.
HOLD_PRSNL_ID DOUBLE N This field is not used at this time.
LABEL_PRINTED_IND DOUBLE Y This field contains an indicator documenting whether or not slide labels have been printed for the associated task.
NO_CHARGE_IND DOUBLE N This field indicates whether the processing task is a 'no charge' task.
ORDER_ID DOUBLE N This field contains the foreign key value used to join to order information stored on the ORDERS table.
PRIORITY_CD DOUBLE N This field contains the priority code value associated with the processing task.
PROCESSING_TASK_ID DOUBLE N This field uniquely defines a row included on the PROCESSING_TASK table. This field represents a specific processing task order.
QUANTITY DOUBLE Y This field is not used at this time.
QUEUE_ID DOUBLE N This field is not used at this time.
REQUEST_DT_TM DATETIME Y This field contains the date and time the processing task was ordered.
REQUEST_PRSNL_ID DOUBLE N This field contains the internal identification code associated with the user who ordered the processing task. This value could be used to join to user information stored on the PRSNL and PERSON tables.
RESEARCH_ACCOUNT_ID DOUBLE N This field contains the internal ID code of the research acccount associated with the processing task.
SERVICE_RESOURCE_CD DOUBLE N This field contains the internal id code of the service resource to which the task is assigned. This could be used to join to the service_resource table.
SLIDE_ID DOUBLE N This field contains the foreign key value (representing the slide to which the processing task is associated) used to join to slide information stored on the SLIDE table.
SLIDE_TAG_ID DOUBLE N This field contains an identifier referencing the identification code assigned to the slide to which this processing task is associated.
STATUS_CD DOUBLE N This field contains the internal ID code of the status associated with the processing task. Valid statuses include options such as ordered, verified, and cancelled.
STATUS_DT_TM DATETIME Y This field includes the date and time the processing task achieved the status documented in the STATUS_CD field.
STATUS_PRSNL_ID DOUBLE N This field includes the internal identification code associated with the user who caused the task to be updated to the status documented in the STATUS_CD field. This could be used to join to personnel information on the PRSNL or PERSON tables.
TASK_ASSAY_CD DOUBLE N This field contains the internal identification code of the discrete task for which this processing task is associated.
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.
WORKLIST_NBR DOUBLE Y This field includes the worklist batch number, if assigned, associated with the processing task.



Relationship Detail - PROCESSING_TASK


Child Column in PROCESSING_TASK(FK) Parent Table Name Parent Column Name
Parents: CASE_SPECIMEN_ID CASE_SPECIMEN CASE_SPECIMEN_ID
CASSETTE_ID CASSETTE CASSETTE_ID
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
COMMENTS_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
HOLD_COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
CASE_ID PATHOLOGY_CASE CASE_ID
CANCEL_PRSNL_ID PRSNL PERSON_ID
HOLD_PRSNL_ID PRSNL PERSON_ID
REQUEST_PRSNL_ID PRSNL PERSON_ID
STATUS_PRSNL_ID PRSNL PERSON_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
SLIDE_ID SLIDE SLIDE_ID




Parent Column in PROCESSING_TASK (PK) Child Table Name Child Column Name
Children: PROCESSING_TASK_ID TASK_INSTRMT_PROTCL_R PROCESSING_TASK_ID


PROC_INSTRMT_PROTCL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Procedure Instrument Protocol Relation
Definition: Store the staining protocols to be performed on an instrument for a procedure.
Table Type: REFERENCE





Column Detail - PROC_INSTRMT_PROTCL_R


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The order catalog code of the procedure related to the protocol and instrument.
INSTRUMENT_PROTOCOL_ID DOUBLE N Uniquely identifies the instrument protocol related to this row.
PROC_INSTRMT_PROTCL_R_ID DOUBLE N Uniquely identifies a relationship between the instrument, procedure, and a protocol.
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 - PROC_INSTRMT_PROTCL_R


Child Column in PROC_INSTRMT_PROTCL_R(FK) Parent Table Name Parent Column Name
Parents: INSTRUMENT_PROTOCOL_ID INSTRUMENT_PROTOCOL INSTRUMENT_PROTOCOL_ID


PROFICIENCY_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Proficiency Event
Definition: This activity table contains records for every proficiency event documented in the system for cytotechnologists. Information such as the date of the event, date of result notification, and event status are included.
Table Type: ACTIVITY





Column Detail - PROFICIENCY_EVENT


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.
ADMINISTERED_DT_TM DATETIME Y This field contains the date and time the proficiency testing event was administered (the date and time the user completed the proficiency testing event).
COMMENTS VARCHAR(200) Y This field contains a comment associated with the documentation of a proficiency testing event.
NOTIFICATION_DT_TM DATETIME Y This field contains the date and time the user (or site) was notified of the results of the proficiency testing event.
PROFICIENCY_TYPE_CD DOUBLE N This field contains the internal identification code identifying the type of proficiency testing event. Proficiency testing event information is stored on codeset 1315.
PRSNL_ID DOUBLE N This field uniquely identifies the cytotechnologist for whom the proficiency testing event is associated. This value could be used to join to other tables, such as the PRSNL, PERSON, and CYTO_SCREENING_SECURITY, for example.
RESULT_FLAG DOUBLE Y This field contains a flag value documenting the results of the proficiency testing event.
REVIEWED_DT_TM DATETIME Y This field contains the date and time the proficiency testing event was reviewed by the authorized user who oversees the review of proficiency testing information. In most sites, this is a pathologist.
REVIEWER_ID DOUBLE N This field contains the internal identification code of the user who was documented as the reviewer of the proficiency testing event. This value could be used to join to tables containing user information, such as the PRSNL and PERSON tables.
SEQUENCE DOUBLE N This field documents the proficiency testing event sequence (for the same user).
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 - PROFICIENCY_EVENT


Child Column in PROFICIENCY_EVENT(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
REVIEWER_ID PRSNL PERSON_ID


REPORT_DETAIL_IMAGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: report_detail_image
Definition: This table is the relation table between the case_report and blob_reference tables. It specifies which sections of the anatomic pathology report contain additional blob (ie image) data.
Table Type: ACTIVITY





Column Detail - REPORT_DETAIL_IMAGE


Column Name Type Null? Definition
REPORT_DETAIL_ID DOUBLE N This field uniquely identifies a row included on the Report_Detail_Image table.
REPORT_ID DOUBLE N This field contains the anatomic pathology report_id that relates the blob_reference table back to the case_report table.
TASK_ASSAY_CD DOUBLE N This field contains the value of the task_assay_cd that represents a particular report section of a anatomic pathology report.
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 - REPORT_DETAIL_IMAGE


Child Column in REPORT_DETAIL_IMAGE(FK) Parent Table Name Parent Column Name
Parents: REPORT_ID CASE_REPORT REPORT_ID


REPORT_DETAIL_TASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report Detail Task
Definition: This activity table contains a record for every resulted (performed or verified) report component procedure included within a pathology report. Information such as the status, a modification indicator, and a signature footnote indicator are included.
Table Type: ACTIVITY





Column Detail - REPORT_DETAIL_TASK


Column Name Type Null? Definition
CASE_ID DOUBLE N This field contains the foreign key value used to join to case information stored on the PATHOLOGY_CASE activity table.
DEFAULT_RESPONSE_CD DOUBLE N This field is not used at this time.
EVENT_ID DOUBLE N This field contains the unique internal reference of the report section to the report information stored in CLINICAL_EVENT tables.
MODIFIED_IND DOUBLE Y This field contains a value which indicates whether or not an interpretation result value was modified by the user from the standard interpretation result value pre-defined in the Interpretation Tool.
REPORT_ID DOUBLE N This field contains the foreign key value used to represent the report. This is used to join to report information stored on the CASE_REPORT activity table.
REQUIRED_IND DOUBLE Y This field contains an indicator documenting whether the report component procedure is required or optional.
RESULT_TYPE_CD DOUBLE N This field contains an indicator documenting the type of result value expected for the report component procedure. Result values appropriate for PathNet Anatomic Pathology include textual, alpha, and interpretation, for example.
SECTION_SEQUENCE DOUBLE Y This field documents the report component sequence, compared to other components within the same report. This field documents which component displays first, second, third, etc.
SIGNATURE_FOOTNOTE_IND DOUBLE Y This field contains an indicator documenting whether or not a signature line is (or will be) associated with the report component (discrete task).
STATUS_CD DOUBLE N This field contains the identification code of the current status associated with the report component (discrete task).
TASK_ASSAY_CD DOUBLE N This field contains the internal identification code associated with the report component discrete 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 - REPORT_DETAIL_TASK


Child Column in REPORT_DETAIL_TASK(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
CASE_ID PATHOLOGY_CASE CASE_ID
REPORT_ID REPORT_TASK REPORT_ID