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 |