Table Detail Report

AP_DIAG_QUERY_PARAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Diagnostic Reporting Query Parameters
Definition: This reference table includes Diagnostic Reporting query parameters that have been established and saved. Using these parameters, the same report can be run multiple times, by different users.
Table Type: REFERENCE





Column Detail - AP_DIAG_QUERY_PARAM


Column Name Type Null? Definition
BEG_VALUE_DT_TM DATETIME Y This field contains the date and time of the beginning query value within a specified query parameter (denoted in the PARAM_NAME field), if defined.
BEG_VALUE_ID DOUBLE N This field contains the internal identification code of the beginning query value within a specified query parameter (denoted in the PARAM_NAME field), if defined.
CRITERIA_TYPE_FLAG DOUBLE Y This field contains a representation of the type of parameters included in the query -- case, patient, or criteria -- included on this row within the diagnostic query table. One query may be represented by multiple rows.
DATE_TYPE_FLAG DOUBLE Y This field contains a representation of the type of date included in this query parameter -- range, previous dates, months, or years.
END_VALUE_DT_TM DATETIME Y This field contains the date and time of the ending query value within a specified query parameter (denoted in the PARAM_NAME field), if defined.
END_VALUE_ID DOUBLE N This field contains the internal identification code of the ending query value within a specified query parameter (denoted in the PARAM_NAME field), if defined.
FREETEXT_LONG_TEXT_ID DOUBLE N This field contains the value representing the entry on the LONG_TEXT table that contains the free textsearch value.
FREETEXT_QUERY_FLAG DOUBLE Y This field determines whether free textsearching crosses multiple paragraphs or within a paragraph.
NEGATION_IND DOUBLE Y This field is not used at this time.
PARAM_NAME VARCHAR(20) Y This field represents the type of query criteria (collection date, diagnostic code, patient age, for example) associated with this row on the diagnostic query parameters table.
PARENT_ENTITY_NAME VARCHAR(30) Y This field contains the name of the parent table for the query parameter. The internal identifier is held in the BEG_VALUE_ID and END_VALUE_ID column.
QUERY_CD DOUBLE N This field contains the internal reference to codeset 14252 which contains the user-defined query name. At the time query parameters are saved, the user is required to enter a name for the query, and this name is saved to codeset 14252.
QUERY_PARAM_ID DOUBLE N This field contains the unique value representing the query parameters.
SEQUENCE DOUBLE Y This field contains a numeric value that is used to sequence 'query parameters' for each query (query_cd).
SOURCE_VOCABULARY_CD DOUBLE N This field contains the internal identification code of the diagnostic coding "vocabulary", if defined. Multiple vocabularies, such as SNOMED II and SNOMED III, might reside on a single system.
SYNOPTIC_CCL_LONG_TEXT_ID DOUBLE N This field contains the value representing the entry on the long_text table that contains the synoptic search query in CCL Format
SYNOPTIC_QUERY_FLAG DOUBLE N This column determines the type of synoptic query that is to be performed.0 - Search criteria not defined.1- Search current worksheets only2 - Search current and historical worksheets
SYNOPTIC_XML_LONG_TEXT_ID DOUBLE N This column contains the value representing the entry on the long_text table that contains the synoptic search query in XML format.
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_QUERY_PARAM


Child Column in AP_DIAG_QUERY_PARAM(FK) Parent Table Name Parent Column Name
Parents: QUERY_CD CODE_VALUE CODE_VALUE
FREETEXT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
SYNOPTIC_CCL_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
SYNOPTIC_XML_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


AP_DIAG_RPT_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Diag Report Review
Definition: This activity table contains information about all of the report components that were automatically coded (in terms of diagnostic coding) and are verified. The information on this table is used when printing the Diagnostic Code Assignment Review Report.
Table Type: ACTIVITY





Column Detail - AP_DIAG_RPT_REVIEW


Column Name Type Null? Definition
EVENT_ID DOUBLE N This field contains the internal identification code assigned to the clinical event tables that contain the report text information for the coded report component.
PREFIX_ID DOUBLE N This field contains the internal identification code of the prefix assigned to the case number that is associated with the report component that was flagged for automatic coding. The purpose of this field is to provide "filtering" options when printing the Diagnostic Code Assignment Review Report option of the Pathology QA Reports application.
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.
VERIFIED_DT_TM DATETIME N This field contains the date and time the report was verified.
VERIFIED_PRSNL_ID DOUBLE N This field contains the internal identification code of the user who initiated the report verification event. Information about the user can be obtained by viewing or joining to the PERSON and/or PRSNL tables.



Relationship Detail - AP_DIAG_RPT_REVIEW


Child Column in AP_DIAG_RPT_REVIEW(FK) Parent Table Name Parent Column Name
Parents: PREFIX_ID AP_PREFIX PREFIX_ID
VERIFIED_PRSNL_ID PRSNL PERSON_ID


AP_DIAG_WORD_CACHE



Column Section Top of Page


Table-level Detail

Description: AP Diagnostic Coding Word Cache
Definition: This table is used as a data store for the automatic (and interactive) diagnostic coder's diagnostic word cache. This table will be read upon startup and any time the source_vocabulary_cd changes to populate the server's internal cache.
Table Type: ACTIVITY





Column Detail - AP_DIAG_WORD_CACHE


Column Name Type Null? Definition
CACHE_RANKING DOUBLE N This column is used to store the ranking of the word within the server's cache the last time the server was shutdown.
DIAGNOSTIC_WORD VARCHAR(255) N This column is used to store the diagnostic words. Each word corresponds to a word from Anatomic Pathology report text.
LAST_CACHE_IND DOUBLE N This column is used as an indication that the corresponding diagnostic word needs to be loaded when the automatic diagnostic coder starts up.
SNGLR_DIAGNOSTIC_WORD VARCHAR(255) N This column is used to store the singular form of the diagnostic word if one was found.
SOURCE_VOCABULARY_CD DOUBLE N This column is used to store the source vocabulary code for which the diagnostic word 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.
WORD_FREQUENCY DOUBLE N This column is used to keep track of how many times the word has occurred while automatically coding AP report text.


AP_DIGITAL_SLIDE



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Digital Slide Table
Definition: This table contains information about the cases or slides for which digital images are available in a foreign imaging system.
Table Type: ACTIVITY





Column Detail - AP_DIGITAL_SLIDE


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.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
AP_DIGITAL_SLIDE_ID DOUBLE N Unique, generated number that identifies a single row on the AP_DIGITAL_SLIDE table.
CASE_ID DOUBLE Y This field uniquely identifies a row included on the PATHOLOGY_CASE table. This field is used to represent a pathology case
SLIDE_ID DOUBLE Y This field uniquely identifies a row (a slide) included in the SLIDE table.
SOURCE_CD DOUBLE Y The field contains reference to code_value table.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - AP_DIGITAL_SLIDE


Child Column in AP_DIGITAL_SLIDE(FK) Parent Table Name Parent Column Name
Parents: CASE_ID PATHOLOGY_CASE CASE_ID
SLIDE_ID SLIDE SLIDE_ID




Parent Column in AP_DIGITAL_SLIDE (PK) Child Table Name Child Column Name
Children: AP_DIGITAL_SLIDE_ID AP_DIGITAL_SLIDE_INFO AP_DIGITAL_SLIDE_ID


AP_DIGITAL_SLIDE_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Digital Slide Information
Definition: This table contains information about the digital slides sent by a foreign imaging system. This includes parameters required to connect to a foreign imaging system to view the digital slides.
Table Type: ACTIVITY





Column Detail - AP_DIGITAL_SLIDE_INFO


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.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
AP_DIGITAL_SLIDE_ID DOUBLE Y This field uniquely identifies a row (a slide) included in the AP_DIGITAL_SLIDE table.
AP_DIGITAL_SLIDE_INFO_ID DOUBLE N A system generated number that uniquely identifies a single row on the AP_DIGITAL_SLIDE_INFO table.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.
URL_ELEM_STRING_TXT VARCHAR(200) Y Specifies the type of url element stored in url_elemnt_string_txt.
URL_ELEM_TYPE_TFLG VARCHAR(30) Y Contains the URL element string which identifies the identifier to launch the URL



Relationship Detail - AP_DIGITAL_SLIDE_INFO


Child Column in AP_DIGITAL_SLIDE_INFO(FK) Parent Table Name Parent Column Name
Parents: AP_DIGITAL_SLIDE_ID AP_DIGITAL_SLIDE AP_DIGITAL_SLIDE_ID