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 |