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