Table Detail Report

REPORT_HISTORY_GROUPING_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report History Grouping Reltn
Definition: This reference table contains the associations between pathology history groupings, defined on codeset 1311, and the report component procedures (discrete tasks) that are associated with the groupings.
Table Type: REFERENCE





Column Detail - REPORT_HISTORY_GROUPING_R


Column Name Type Null? Definition
COLLATING_SEQ DOUBLE Y This field is used to sequence the report sections.
GROUPING_CD DOUBLE N This field contains the foreign key value used to reference the report history grouping value to which the associated report component procedures (discrete tasks) are assigned. Report history grouping parameters are stored on codeset 1311.
TASK_ASSAY_CD DOUBLE N This field contains the foreign key value used to reference the discrete task report component that is assigned to a report history grouping.
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_HISTORY_GROUPING_R


Child Column in REPORT_HISTORY_GROUPING_R(FK) Parent Table Name Parent Column Name
Parents: GROUPING_CD CODE_VALUE CODE_VALUE
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD


REPORT_INPROC_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report Inprocess Status
Definition: This reference table contains the associations between report order catalog items, report component procedures, and the in process status and cancelation options associated with those entries.
Table Type: REFERENCE





Column Detail - REPORT_INPROC_STATUS


Column Name Type Null? Definition
CANCELABLE_IND DOUBLE Y This field contains an indicator documenting whether or not a report that has achieved the associated status can be cancelled.
CATALOG_CD DOUBLE N This field contains the foreign key value representing the order catalog item to which the report component procedures (discrete tasks) are associated.
DICTATED_STATUS_CD DOUBLE N This field is not used at this time.
PROCESSING_SEQUENCE DOUBLE Y This field contains a sequence value used to determine hierarchy if multiple report components have reached their associated statuses. If multiple components have been updated, this field determines which sequence takes precedence in display.
TASK_ASSAY_CD DOUBLE N This field contains the foreign key value representing the report component procedure (discrete task) to which the in process status and parameters are defined.
TRANSCRIBED_STATUS_CD DOUBLE N This field is used to store the identification code of the transcribed status value. Report status codes are stored on codeset1305.
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_INPROC_STATUS


Child Column in REPORT_INPROC_STATUS(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD PROFILE_TASK_R CATALOG_CD
TASK_ASSAY_CD PROFILE_TASK_R TASK_ASSAY_CD


REPORT_QUEUE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report Queue Reltn
Definition: This activity table contains the relationship between user-built queues (defined on codeset 1319) and the cases assigned to the queues.
Table Type: ACTIVITY





Column Detail - REPORT_QUEUE_R


Column Name Type Null? Definition
REPORT_ID DOUBLE N This field contains the foreign key value representing the individual report that is associated with a report queue. This value can be used to join to report information stored on the CASE_REPORT table, if desired.
REPORT_QUEUE_CD DOUBLE N This field contains the foreign key value representing the report queue. Report queues are stored on codeset 1319.
SEQUENCE DOUBLE Y This field contains a sequence value used to determine display and processing hierarchy if multiple reports are associated with a single report queue. The report assigned the lowest sequence displays first; the report assigned the highest displays last.
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_QUEUE_R


Child Column in REPORT_QUEUE_R(FK) Parent Table Name Parent Column Name
Parents: REPORT_ID CASE_REPORT REPORT_ID
REPORT_QUEUE_CD CODE_VALUE CODE_VALUE


REPORT_TASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report Task
Definition: This activity table contains parameters associated with pathology case reports. Information such as the hold status (and hold reason and comment), last edit date and time, and responsible pathologist and resident (for the report) are included.
Table Type: ACTIVITY





Column Detail - REPORT_TASK


Column Name Type Null? Definition
COMMENTS VARCHAR(100) Y This field is no longer used. Refer to the COMMENTS_LONG_TEXT_ID for information regarding the order comment.
COMMENTS_LONG_TEXT_ID DOUBLE N This field contains the value representing the entry on the LONG_TEXT table that contains the report order comment.
EDITING_DT_TM DATETIME Y This field contains the last date and time this report was viewed in a 'result entry application'.
EDITING_PRSNL_ID DOUBLE N This field contains the internal identification code of the user who is currently viewing/modifying this report in a 'result entry application'.
HOLD_CD DOUBLE N If the report is currently associated with a hold status, this field contains the internal identification code associated with the hold reason. Hold reasons are stored on codeset 1300.
HOLD_COMMENT VARCHAR(100) Y This field is no longer used. Refer to the COMMENTS_LONG_TEXT_ID for information regarding the report hold comment.
HOLD_COMMENT_LONG_TEXT_ID DOUBLE N This field contains the value representing the entry on the LONG_TEXT table that contains the report hold comment.
HOLD_DT_TM DATETIME Y If the report is currently associated with a hold status, this field contains the date and time the hold status was assigned to the report.
HOLD_PRSNL_ID DOUBLE N If the report is currently associated with a hold status, the internal identification code of the user who updated the report to a hold status is contained in this field. This value could be used to join to information on the PRSNL and PERSON tables.
LAST_EDIT_DT_TM DATETIME Y This field contains the date and time that text was added to the report.
LAST_TASK_ASSAY_CD DOUBLE N This field contains the internal identification code of the report component (discrete task) for which text was last added.
ORDER_ID DOUBLE N This field contains the foreign key value representing the report order.
PRIORITY_CD DOUBLE N This field contains the identification code of the priority (stat, routine, for example) currently assigned to the report.
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.
RESPONSIBLE_PATHOLOGIST_ID DOUBLE N This field contains the internal identification code of the user designated as the responsible pathologist for the report. This may, or may not, be the same as the responsible pathologist assigned to the case (stored on the PATHOLOGY_CASE table).
RESPONSIBLE_RESIDENT_ID DOUBLE N This field contains the internal identification code of the user designated as the responsible resident for the report. This may, or may not, be the same as the responsible resident assigned to the case (stored on the PATHOLOGY_CASE table).
SERVICE_RESOURCE_CD DOUBLE N This field contains the internal identification code of the service resource to which the report is assigned. This could be used to join to the service_resource 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 - REPORT_TASK


Child Column in REPORT_TASK(FK) Parent Table Name Parent Column Name
Parents: REPORT_ID CASE_REPORT REPORT_ID
LAST_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
EDITING_PRSNL_ID PRSNL PERSON_ID
HOLD_PRSNL_ID PRSNL PERSON_ID
RESPONSIBLE_PATHOLOGIST_ID PRSNL PERSON_ID
RESPONSIBLE_RESIDENT_ID PRSNL PERSON_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in REPORT_TASK (PK) Child Table Name Child Column Name
Children: REPORT_ID REPORT_DETAIL_TASK REPORT_ID


SIGN_LINE_DTA_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Signature Line - Discrete Task Assay Relationships
Definition: This table contains the relationships between the discrete task assay (and/or activity sub-type) with the signature line format code.
Table Type: REFERENCE





Column Detail - SIGN_LINE_DTA_R


Column Name Type Null? Definition
ACTIVITY_SUBTYPE_CD DOUBLE N This field stores the activity sub-type code, if defined, to which a signature line format can be defined. Association of a signature line format to an activity sub-type is more generic than when associated to an actual discrete task assay.
FORMAT_ID DOUBLE N This field contains the internal identication code representing the signature line format. This value is used to join to the signature line format information stored on the SIGN_LINE_FORMAT table.
STATUS_FLAG DOUBLE N This field contains a flag value representing the result status for which the signature line format is associated. Optionally, signature lines can be associated with "performed and verified" results, only "performed" results, or only "verified" results.
TASK_ASSAY_CD DOUBLE N This field stores the discrete task assay identification code, if defined, to which a signature line format is assigned. Association of a signature line format to a discrete task assay is more specific than assigning a format to an activity sub-type value.
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 - SIGN_LINE_DTA_R


Child Column in SIGN_LINE_DTA_R(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
FORMAT_ID SIGN_LINE_FORMAT FORMAT_ID