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 |