Table Detail Report
AP_CASE_QUERY_DETAILS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AP Case Query Details |
Definition: | This reference table contains detail informations associated with a Pathology Report Query. Other parameters about the query are stored on the AP_Case_Query. |
Table Type: | ACTIVITY |
Column Detail - AP_CASE_QUERY_DETAILS
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_VALUE_DISP | VARCHAR(40) | Y | This field contains the display value of the beginning query value within a specified query parameter (denoted in the PARAM_NAME field), if defined. |
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. |
CASE_QUERY_ID | DOUBLE | N | This field contains the internal identification code which uniquely identifies the case retrieval query (and its associated parameters). This value is used to join to other tables, such as the AP_CASE_QUERY table. |
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_DISP | VARCHAR(40) | Y | This field contains the display value of the ending query value within a specified query parameter (denoted in the PARAM_NAME field), if defined. |
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. |
QUERY_DETAIL_ID | DOUBLE | N | This field is the unique identifier to the AP_CASE_QUERY_DETAILS table |
SEQUENCE | DOUBLE | N | This field, in conjunction with the value included in the CASE_QUERY_ID field, uniquely identifies a row on this table. |
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 field determines the type of synoptic query that is to be performed. |
SYNOPTIC_XML_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 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_CASE_QUERY_DETAILS
Child Column in AP_CASE_QUERY_DETAILS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CASE_QUERY_ID | AP_CASE_QUERY | CASE_QUERY_ID |
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_CASE_SYNOPTIC_WS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Anatomic Pathology Case Synoptic Worksheet |
Definition: | This table maintains a list of synoptic worksheets associated with an Anatomic Pathology case. |
Table Type: | ACTIVITY |
Column Detail - AP_CASE_SYNOPTIC_WS
Column Name | Type | Null? | Definition |
---|---|---|---|
CAP_CHECKLIST_CKI | VARCHAR(255) | Y | The CAP checklist concept the story results are for. This is a Version CKey. |
CASE_SPECIMEN_ID | DOUBLE | N | This field links the worksheet to a specific specimen (CASE_SPECIMEN). |
CASE_WORKSHEET_ID | DOUBLE | N | This field uniquely identifies a case worksheet. |
FOREIGN_WS_IDENT | VARCHAR(50) | Y | Uniquely identifies a worksheet in a third party synoptic reporting system(e.g. mTuitive). This column will only be valued for foreign worksheets. |
FOREIGN_WS_RESULT_TEXT_ID | DOUBLE | N | The long_text table id for the worksheet result from a third party synopticreporting system (e.g. mTuitive). This column will only be valued for foreign worksheets. |
REPORT_ID | DOUBLE | N | The specific report on the case (CASE_REPORT) that the worksheet is tied to. |
SCD_STORY_ID | DOUBLE | N | This field identifies the actual worksheet data in the SCD_STORY table |
SCR_PATTERN_ID | DOUBLE | N | This field identifies the SCD pattern to use for data entry on this worksheet. |
SEQUENCE | DOUBLE | N | This field is used to sort the worksheets for any one specimen. |
STATUS_FLAG | DOUBLE | N | Identifies status of worksheet: 0 - Not started 1 - Incomplete 2 - Completed 3 - Orphaned |
TASK_ASSAY_CD | DOUBLE | N | The report section this worksheet is linked to. |
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_CASE_SYNOPTIC_WS
Child Column in AP_CASE_SYNOPTIC_WS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPORT_ID | CASE_REPORT | REPORT_ID |
CASE_SPECIMEN_ID | CASE_SPECIMEN | CASE_SPECIMEN_ID | |
FOREIGN_WS_RESULT_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
SCD_STORY_ID | SCD_STORY | SCD_STORY_ID | |
SCR_PATTERN_ID | SCR_PATTERN | SCR_PATTERN_ID |
Parent Column in AP_CASE_SYNOPTIC_WS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CASE_WORKSHEET_ID | AP_CASE_SYNOPTIC_WS_DATA | CASE_WORKSHEET_ID |
AP_CASE_SYNOPTIC_WS_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AP Case Synoptic Worksheet Data |
Definition: | This table maintains discrete synoptic Worksheet data of worksheets associated with an Anatomic Pathology case. |
Table Type: | ACTIVITY |
Column Detail - AP_CASE_SYNOPTIC_WS_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
ALT_ANSWER_CKI | VARCHAR(255) | Y | Alternate identifier for the answer. |
ALT_ANSWER_CODING_SYS_IDENT | VARCHAR(255) | Y | Identifies the coding system for the alternate answer identifier/CKI. The data in this column is only applicable if ALT_ANSWER_CKI is populated. |
ALT_ANSWER_TXT | VARCHAR(2000) | Y | Alternate name or description of the answer. The data in this column is only applicable if ALT_ANSWER_CKI is populated. |
ALT_QUESTION_CKI | VARCHAR(255) | Y | Alternate identifier for the question. |
ALT_QUESTION_CODING_SYS_IDENT | VARCHAR(255) | Y | Identifies the coding system for the alternate question identifier/CKI. |
ALT_QUESTION_TXT | VARCHAR(2000) | Y | Alternate name or description of the question. |
ANSWER_CODING_SYS_IDENT | VARCHAR(255) | Y | Identifies the coding system for the answer identifier/CKI. The data in this column is only applicable if ANSWER_CONCEPT_CKI is populated. |
ANSWER_CONCEPT_CKI | VARCHAR(255) | Y | The specific answer concept cki (nomenclature table) that this data is tied to |
ANSWER_LONG_TEXT_ID | DOUBLE | N | Stores the long text identifier when answer type is text |
ANSWER_SUB_IDENT | VARCHAR(255) | Y | An identifier to group multiple answer components. This field is only applicable for fields with multiple answer components e.g. a selectable field with fill-in box. |
ANSWER_TEXT_FORMAT_CD | DOUBLE | N | Stores the answer text format code from codeset 23 (RTF, AS or AH) |
ANSWER_TXT | VARCHAR(2000) | Y | Name or description of the answer. The data in this column is only applicable if ANSWER_CONCEPT_CKI is populated. |
ANSWER_TYPE_FLAG | DOUBLE | N | Flag to indicate what type of answer is being stored |
ANSWER_TYPE_TXT | VARCHAR(255) | Y | The answer type name/identifier. |
ANSWER_UNIT_CD | DOUBLE | N | stores the unit of measure from codeset 54 when answer type is decimal or integer |
ANSWER_UNIT_CODING_SYS_IDENT | VARCHAR(255) | Y | Identifies the coding system for the answer unit of measure identifier. The data in this column is only applicable if ANSWER_UNIT_TEXT is populated. |
ANSWER_UNIT_IDENT | VARCHAR(255) | Y | Identifies the unit of measure. |
ANSWER_UNIT_TXT | VARCHAR(255) | Y | Name or description for the unit of measure. |
ANSWER_VALUE | VARCHAR(255) | Y | Stores the answer value. Answer_type_flag must be evaluated to determine proper conversion. |
AP_CASE_SYNOPTIC_WS_DATA_ID | DOUBLE | N | Unique generated number that identifies a single row on the AP_CASE_SYNOPTIC_WS_DATA table. |
CASE_WORKSHEET_ID | DOUBLE | Y | The specific worksheet (ap_case_synoptic_ws) that the question/answer data is tied to |
QUESTION_CODING_SYS_IDENT | VARCHAR(255) | Y | Identifies the coding system used for the question identifier/CKI. |
QUESTION_CONCEPT_CKI | VARCHAR(255) | N | The specific question concept cki (nomenclature table) that this data is tied to |
QUESTION_TXT | VARCHAR(2000) | Y | Name of the descitiption of the question. |
REC_TYPE_FLAG | DOUBLE | N | Identifiers the type of the result row; The value will be 0 - for question/answer pair results; 1 - for the worksheet data. |
SUB_ANSWER_TYPE_TXT | VARCHAR(255) | Y | The type for the sub answers. This column is only applicable for fields with multiple answer components e.g. a selectable field with fill-in box. |
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 - AP_CASE_SYNOPTIC_WS_DATA
Child Column in AP_CASE_SYNOPTIC_WS_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CASE_WORKSHEET_ID | AP_CASE_SYNOPTIC_WS | CASE_WORKSHEET_ID |
ANSWER_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
AP_DC_DISCREPANCY_TERM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnostic Correlation Discrepancy Terminology |
Definition: | This reference table contains entries representing diagnostic correlation discrepancy categorizations. This option is most often associated with diagnostic correlation evaluation terms that represent disagreement. |
Table Type: | REFERENCE |
Column Detail - AP_DC_DISCREPANCY_TERM
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
DESCRIPTION | VARCHAR(60) | Y | This field includes the long description, up-to-60 characters, defined for the discrepancy categorization term. |
DISCREPANCY_CD | DOUBLE | N | This field includes the internal identification code of the overall classification of the discrepancy categorization term, such as "None", "Major" or "Minor". These classifications are stored on code_set 15451. |
DISCREPANCY_TERM_ID | DOUBLE | N | This field includes the internal identification code assigned to the discrepancy categorization terminology entry. This value would be referenced on other tables, such as the AP_DC_EVENT activity table. |
DISPLAY | VARCHAR(15) | Y | This field includes the short description, up-to-15 characters, defined for the discrepancy categorization term. |
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_DISCREPANCY_TERM
Parent Column in AP_DC_DISCREPANCY_TERM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DISCREPANCY_TERM_ID | AP_DC_EVENT | FINAL_DISCREP_TERM_ID |
AP_DC_EVENT | INIT_DISCREP_TERM_ID |
AP_DC_EVALUATION_TERM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnostic Correlation Evaluation Terminology |
Definition: | This reference table includes the terminology used to designate agreement or disagreement for a diagnostic correlation event. |
Table Type: | REFERENCE |
Column Detail - AP_DC_EVALUATION_TERM
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
AGREEMENT_CD | DOUBLE | N | This field includes the internal identification code of the overall classification of the evaluation term. Typically, only two classifications are found - "Agreement" and "Disagreement". These classifications are stored on code_set 15469. |
DESCRIPTION | VARCHAR(60) | Y | This field includes the long description, up-to-60 characters, defined for the diagnostic correlation evaluation term. |
DISCREPANCY_REQ_IND | DOUBLE | Y | This field includes a value indicating whether or not the user must enter a discrepancy categorization term. If the value is set to "1", the user will be required to enter a discrepancy reason. If the value is set to "0", the user will not be required to enter a discrepancy reason. Discrepancy reasons are stored on reference table AP_DC_DISCREPANCY_TERM. |
DISPLAY | VARCHAR(15) | Y | This field includes the short description, up-to-15 characters, defined for the diagnostic correlation evaluation term. |
EVALUATION_TERM_ID | DOUBLE | N | This field includes the internal identification code assigned to the diagnostic correlation evaluation terminology entry. This value would be referenced on other tables, such as the AP_DC_EVENT activity table. |
INVESTIGATION_REQ_IND | DOUBLE | Y | This field includes a value indicating whether or not the user must enter an investigation term. If the value is set to "1", the user will be required to enter an investigation term. If the value is set to "0", the user will not be required to enter an investigation term. Investigation terms are stored on code_set 15449. |
REASON_REQ_IND | DOUBLE | Y | This field includes a value indicating whether or not the user must enter a discrepancy reason term. If the value is set to "1", the user will be required to enter a discrepancy reason term. If the value is set to "0", the user will not be required to enter a discrepancy reason term. Discrepancy reasons are stored on code_set 15429. |
RESOLUTION_REQ_IND | DOUBLE | Y | This field includes a value indicating whether or not the user must enter a discrepancy resolution term. If the value is set to "1", the user will be required to enter a discrepancy resolution term. If the value is set to "0", the user will not be required to enter a discrepancy resolution term. Resolution terms are stored on code_set 15450. |
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_EVALUATION_TERM
Parent Column in AP_DC_EVALUATION_TERM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EVALUATION_TERM_ID | AP_DC_EVENT | FINAL_EVAL_TERM_ID |
AP_DC_EVENT | INIT_EVAL_TERM_ID |