Table Detail Report
AP_DC_EVENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnostic Correlation Event |
Definition: | This activity table includes an entry for every diagnostic correlation event that has been established, regardless of whether or not the evaluation has simply been initiated, is in process, is complete, or is canceled. |
Table Type: | ACTIVITY |
Column Detail - AP_DC_EVENT
Column Name | Type | Null? | Definition |
---|---|---|---|
ASSIGN_TO_GROUP_IND | DOUBLE | Y | Indicates whether the correlation event is currently assigned to a group. |
CANCEL_DT_TM | DATETIME | Y | If the correlation event was cancelled before the evaluation was completed, this field contains the date and time the event was cancelled. |
CANCEL_PRSNL_ID | DOUBLE | N | If the correlation event was cancelled before the evaluation was completed, this field contains the internal identification code associated with the user who completed the cancel request. Information about the user can be obtained by joining to the PERSON and/or PRSNL tables. |
CASE_ID | DOUBLE | N | This field contains the internal identification code representing the case to which the diagnostic correlation event is assigned. Information about the case can be obtained by joining to the PATHOLOGY_CASE activity table. |
COMPLETE_DT_TM | DATETIME | Y | If the correlation evaluation is complete, this field contains the date and time the event was completed. |
COMPLETE_PRSNL_ID | DOUBLE | N | If the correlation evaluation is complete, this field contains the internal identification code associated with the user who completed the event. The event is considered "complete" when the final evaluation reason is entered and saved (and the final discrepancy reason, if required). This is the user who was signed on to the system when the interaction occurred. This is not necessarily the user who is actually associated with the evaluation process. |
CORRELATE_CASE_ID | DOUBLE | N | If the diagnostic correlation study is specified as an "across case" correlation, this field contains the internal identification code representing the other pathology case to which the initiated case is to be compared. Information about this case can be obtained by joining to the PATHOLOGY_CASE activity table. Information about the study itself can be obtained by viewing or joining to the information stored on the AP_DC_STUDY reference table. |
DISAGREE_REASON_CD | DOUBLE | N | If a disagreement reason was entered for the diagnostic correlation study event, this field contains the internal identification code assigned to the disagreement reason. Disagreement reasons are stored on code_set 15429. |
EVENT_ID | DOUBLE | N | This field contains the internal identification code that uniquely identifies this diagnostic correlation study event. This field is referenced on other activity tables, such as the AP_DC_EVENT_PRSNL table. |
FINAL_DISCREP_TERM_ID | DOUBLE | N | If a final discrepancy evaluation term was entered for the diagnostic correlation study event, this field contains the internal identification code assigned to the discrepancy evaluation term. Discrepancy evaluation terms are stored on the AP_DC_DISCREPANCY_TERM reference table. |
FINAL_EVAL_TERM_ID | DOUBLE | N | If a final evaluation term was entered for the diagnostic correlation study event, this field contains the internal identification code assigned to the evaluation term. Evaluation terms are stored on the AP_DC_EVALUATION_TERM reference table. |
INITIATED_DT_TM | DATETIME | Y | This field contains the date and time the diagnostic correlation study event was initiated. |
INITIATED_PRSNL_ID | DOUBLE | N | This field contains the internal identification code associated with the user who initiated the diagnostic correlation study event. This is the user who was signed on and actually completed the initiation conversation. This may not be the actual user (users or user group) who is associated with the evaluation process. Information about the user can be obtained by joining to the PERSON and/or PRSNL tables. |
INIT_DISCREP_TERM_ID | DOUBLE | N | If an initial discrepancy evaluation term was entered for the diagnostic correlation study event, this field contains the internal identification code assigned to the discrepancy evaluation term. Discrepancy evaluation terms are stored on the AP_DC_DISCREPANCY_TERM reference table. |
INIT_EVAL_TERM_ID | DOUBLE | N | If an initial evaluation term was entered for the diagnostic correlation study event, this field contains the internal identification code assigned to the evaluation term. Evaluation terms are stored on the AP_DC_EVALUATION_TERM reference table. |
INVESTIGATION_CD | DOUBLE | N | If an investigation value was entered for the diagnostic correlation study event, this field contains the internal identification code assigned to the investigation term. Investigation terms are stored on code_set 15449. |
LONG_TEXT_ID | DOUBLE | N | If a free-text comment was entered for the diagnostic correlation study event, this field contains the internal identification code representing the stored location of the comment text. This text is stored on the LONG_TEXT table. |
PRSNL_GROUP_ID | DOUBLE | N | If the diagnostic correlation event was associated with a "group" rather than an individual (or multiple individuals), this field contains the internal identification code representing the group. Members of the group associated with the specific diagnostic correlation event can be identified by viewing or joining to information stored on the AP_DC_EVENT_PRSNL activity table. |
REPORT_ISSUED_BY_PRSNL_ID | DOUBLE | N | This field contains the internal identification of the person to which issued the report. This field can be used to join to the PRSNL table. |
RESOLUTION_CD | DOUBLE | N | If a resolution value was entered for the diagnostic correlation study event, this field contains the internal identification code assigned to the resolution term. Resolution terms are stored on code_set 15450. |
SLIDE_COUNTS | DOUBLE | N | This field contains the number of slides that were reviewed for a correlation event. |
STUDY_ID | DOUBLE | N | This field contains the internal identification code for the correlation study to be initiated upon qualification. |
SYS_CORR_ID | DOUBLE | N | This field contains the internal identification code to the AP_SYS_CORR table. |
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 - AP_DC_EVENT
Child Column in AP_DC_EVENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FINAL_DISCREP_TERM_ID | AP_DC_DISCREPANCY_TERM | DISCREPANCY_TERM_ID |
INIT_DISCREP_TERM_ID | AP_DC_DISCREPANCY_TERM | DISCREPANCY_TERM_ID | |
FINAL_EVAL_TERM_ID | AP_DC_EVALUATION_TERM | EVALUATION_TERM_ID | |
INIT_EVAL_TERM_ID | AP_DC_EVALUATION_TERM | EVALUATION_TERM_ID | |
STUDY_ID | AP_DC_STUDY | STUDY_ID | |
SYS_CORR_ID | AP_SYS_CORR | SYS_CORR_ID | |
LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
CASE_ID | PATHOLOGY_CASE | CASE_ID | |
CORRELATE_CASE_ID | PATHOLOGY_CASE | CASE_ID | |
CANCEL_PRSNL_ID | PRSNL | PERSON_ID | |
COMPLETE_PRSNL_ID | PRSNL | PERSON_ID | |
INITIATED_PRSNL_ID | PRSNL | PERSON_ID | |
REPORT_ISSUED_BY_PRSNL_ID | PRSNL | PERSON_ID | |
PRSNL_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID |
Parent Column in AP_DC_EVENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EVENT_ID | AP_DC_EVENT_PRSNL | EVENT_ID |
AP_DC_EVENT_PRSNL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnostic Correlation Event Personnel |
Definition: | This activity table includes information about the individual user (or users) or user group members associated with a specific diagnostic correlation event. |
Table Type: | ACTIVITY |
Column Detail - AP_DC_EVENT_PRSNL
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_ID | DOUBLE | N | This field contains the internal identification code assigned to the diagnostic correlation event. Information about the event can be obtained by viewing or joining to the AP_DC_EVENT table. |
PRSNL_GROUP_ID | DOUBLE | N | If the diagnostic correlation event was associated with a user group (rather than an individual or set of individuals), this field contains the reference back to the PRSNL_GROUP_ID value for the specific diagnostic correlation study event (as stored on the AP_DC_EVENT table). |
PRSNL_ID | DOUBLE | N | This field contains the internal identification code assigned to the individual user, users, or group members assigned to the evaluation of the diagnostic correlation event. Information about the user can be obtained by viewing or joining to the PERSON and/or PRSNL tables. |
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 - AP_DC_EVENT_PRSNL
Child Column in AP_DC_EVENT_PRSNL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EVENT_ID | AP_DC_EVENT | EVENT_ID |
PRSNL_ID | PRSNL | PERSON_ID | |
PRSNL_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID |
AP_DC_STUDY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnostic Correlation Study |
Definition: | This reference table includes the parameters established for diagnostic correlation studies. Every study contains parameters regarding a specific set of events or information to be evaluated and correlated. |
Table Type: | REFERENCE |
Column Detail - AP_DC_STUDY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACROSS_CASE_IND | DOUBLE | N | This field contains a value indicating that the study is defined as "within case" (value = "0") or "across case (value = "1"). Study elements to be evaluated for "within case" studies must reside on the same PathNet Anatomic Pathology case number (or must be associated with a case or accession that will not be tracked as an "across case" study). Study elements to be evaluated for "across case" studies must reside on different PathNet Anatomic Pathology case numbers. |
ACTIVE_IND | DOUBLE | N | 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. |
DEFAULT_TO_GROUP_IND | DOUBLE | N | This field indicates whether assignment of new correlation events involving this study type will be defaulted to a group (value=1) or an individual (value=0). |
DESCRIPTION | VARCHAR(100) | Y | This field includes the long description, up-to-60 characters, defined for the diagnostic correlation study. |
INCLUDE_CYTOTECHS_IND | DOUBLE | N | This field indicates whether to include cytotechnologists in assignment of correlation events involving this study. A value of 1 indicates that they will be included. |
SERVICE_RESOURCE_CD | DOUBLE | N | Uniquely identifies the work area at which the study will be performed for access control. |
SLIDE_COUNTS_PROMPT_IND | DOUBLE | N | This field indicates whether to prompt to tally cytology slide counts for correlation events involving this study type. |
STUDY_ID | DOUBLE | N | This field includes the internal identification code assigned to the diagnostic correlation study. This value would be referenced on other tables, such as the AP_DC_EVENT activity table. |
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 - AP_DC_STUDY
Parent Column in AP_DC_STUDY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | STUDY_ID | AP_DC_EVENT | STUDY_ID |
AP_DC_STUDY_RPT_PROC | STUDY_ID | ||
AP_SYS_CORR | STUDY_ID |
AP_DC_STUDY_RPT_PROC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnostic Correlation Study Report Procedure |
Definition: | This reference table includes the report components (discrete task assays) that can be printed on diagnostic correlation worksheets and statistical reports for a specific diagnostic correlation study. |
Table Type: | REFERENCE |
Column Detail - AP_DC_STUDY_RPT_PROC
Column Name | Type | Null? | Definition |
---|---|---|---|
STUDY_ID | DOUBLE | N | This field contains the internal identification code representing the diagnostic correlation study to which the report component procedure is assigned. Diagnostic correlation studies are defined on the AP_DC_STUDY reference table. |
TASK_ASSAY_CD | DOUBLE | N | This field contains the internal identification code representing the report component (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. |
Relationship Detail - AP_DC_STUDY_RPT_PROC
Child Column in AP_DC_STUDY_RPT_PROC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | STUDY_ID | AP_DC_STUDY | STUDY_ID |
TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
AP_DIAG_AUTO_CODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnostic Automatic Code |
Definition: | This reference table contains information about the automatic diagnostic coding assignment process. This table identifies the components within the pathology reports that should be coded automatically at the time the results are performed and/or verified |
Table Type: | REFERENCE |
Column Detail - AP_DIAG_AUTO_CODE
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | This field contains the internal identification code assigned to the report order catalog item from which one or more report components (discrete task assays) have been selected for automatic diagnostic coding. |
TASK_ASSAY_CD | DOUBLE | N | This field contains the internal identification code assigned to the individual report component (discrete task assay) that has been selected for automatic diagnostic coding. |
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 - AP_DIAG_AUTO_CODE
Child Column in AP_DIAG_AUTO_CODE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD |