Table Detail Report
AP_QA_INFO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AP Quality Assurance Info |
Definition: | This activity table contains the quality assurance indicators associated with gynecologic cytology cases. Indicators include classifications such as normal, atypical, abnormal, and unsatisfactory. |
Table Type: | ACTIVITY |
Column Detail - AP_QA_INFO
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVATED_DT_TM | DATETIME | Y | This field contains the date and time the record was written to the AP_QA_INFO table. |
ACTIVATED_ID | DOUBLE | N | This field contains the internal identification code of the user who performed the activation event associated with the QA record. The activation event is most often the report verification event. This ID could be used to join to the user tables. |
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. |
CANCEL_CD | DOUBLE | N | This field is not used at this time. |
CASE_ID | DOUBLE | N | This field contains the foreign key value used to join to case information stored on the PATHOLOGY_CASE activity table. |
COMPLETE_DT_TM | DATETIME | Y | This field is not used at this time. |
COMPLETE_ID | DOUBLE | N | This field is not used at this time. |
FLAG_TYPE_CD | DOUBLE | N | This field contains a reference to codeset 1316 indicating the type of quality assurance that is associated with this entry. Quality assurance flag options include previous normal, previous atypical, previous abnormal, and clinical high risk. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
QA_FLAG_ID | DOUBLE | N | This field uniquely identifies the row (the quality assurance flag) included on the AP_QA_INFO table. |
SUSPEND_DT_TM | DATETIME | Y | This field is not used at this time. |
SUSPEND_ID | DOUBLE | N | This field is not used at this time. |
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_QA_INFO
Child Column in AP_QA_INFO(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CASE_ID | PATHOLOGY_CASE | CASE_ID |
PERSON_ID | PERSON | PERSON_ID | |
ACTIVATED_ID | PRSNL | PERSON_ID | |
COMPLETE_ID | PRSNL | PERSON_ID | |
SUSPEND_ID | PRSNL | PERSON_ID |
AP_QUERY_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AP Case Query Result |
Definition: | This activity table contains the pathology case number which have qualified for a given Case Retrieval query. |
Table Type: | ACTIVITY |
Column Detail - AP_QUERY_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION_NBR | CHAR(21) | Y | This field contains the case number which has qualified for a given Case Query. |
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 the AP_CASE_QUERY table. |
EVENT_ID | DOUBLE | N | This is the MDOC level event ID of the report that qualified |
QUERY_RESULT_ID | DOUBLE | N | This field contains the internal identification code which uniquely identifies this row on the ap_query_result table. This value is used to join to the AP_QUERY_RESULT_OFFSET table. |
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_QUERY_RESULT
Child Column in AP_QUERY_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CASE_QUERY_ID | AP_CASE_QUERY | CASE_QUERY_ID |
Parent Column in AP_QUERY_RESULT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | QUERY_RESULT_ID | AP_QUERY_RESULT_OFFSET | QUERY_RESULT_ID |
AP_QUERY_RESULT_OFFSET
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AP Case Query Result Offset |
Definition: | This activity table is NOT currently is use. In the future, this table will contain lenght/offset of freetext data which is used to qualify the a Case Query. |
Table Type: | ACTIVITY |
Column Detail - AP_QUERY_RESULT_OFFSET
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_ID | DOUBLE | N | This is the unique identifier of the CE_BLOB which qualified within the free textCase Query Retrieval. |
LENGTH | DOUBLE | Y | This field contains the text length from the CE_BLOB table which was used to qualify the event in the Case Query. |
OFFSET | DOUBLE | Y | This field contains the text offset within the CE_BLOB table which was used to qualify the event in the Case Query. |
QUERY_RESULT_ID | DOUBLE | N | This field contains the internal identificationcode which uniquely identifies the ap_query_result this row is associated with. This column along with the SEQUENCE column make of the primary key for this table. |
SEQUENCE | DOUBLE | N | This field contains a sequential value which is used with the QUERY_RESULT_ID in order to make this a unique row within this 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_QUERY_RESULT_OFFSET
Child Column in AP_QUERY_RESULT_OFFSET(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | QUERY_RESULT_ID | AP_QUERY_RESULT | QUERY_RESULT_ID |
AP_SOURCE_DEVICE_ADDL
Column Section | Top of Page |
Table-level Detail
Description: | AP Source Device Additional Information |
Definition: | This table contains parameters defined of an imaging source device. The include parameters required to connect to a foreign imaging system. |
Table Type: | REFERENCE |
Column Detail - AP_SOURCE_DEVICE_ADDL
Column Name | Type | Null? | Definition |
---|---|---|---|
AP_SOURCE_DEVICE_ADDL_ID | DOUBLE | N | Uniquely identifies additional information related to a given source device. |
DEVICE_PASSWORD | VARCHAR(100) | Y | Contains the password required to access an imaging device/system. |
DEVICE_USERNAME | VARCHAR(100) | Y | Contains the username required to access an imaging device/system. |
IMAGE_SERVER_URL | VARCHAR(1000) | Y | Applications can access image server to check if slide images are available for a given pathology case. |
NETWORK_SHARE_PATH | VARCHAR(1000) | Y | Contains the path of a network file share that could be used to acquire images from an imaging device/system. |
SOURCE_DEVICE_CD | DOUBLE | N | Contains the code_value of the device to which the additional information relates. |
SOURCE_DEVICE_URL | VARCHAR(1000) | Y | Contains the URL address used to access an imaging device/system. |
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. |
AP_SOURCE_VOCABULARY_R
Column Section | Top of Page |
Table-level Detail
Description: | AP Source Vocabulary Resolution |
Definition: | This reference table is used to link the standard diagnostic coding source vocabulary, such as SNOMED II or SNOMED International, to the user-defined "extension" diagnostic code file for the same vocabulary. |
Table Type: | REFERENCE |
Column Detail - AP_SOURCE_VOCABULARY_R
Column Name | Type | Null? | Definition |
---|---|---|---|
INCLUDE_SOURCE_VOCABULARY_CD | DOUBLE | N | This field contains the internal identification code of the "extension" source vocabulary that contains the user-defined codes. |
SOURCE_VOCABULARY_CD | DOUBLE | N | This field contains the internal identification code of the "standard" (published) diagnostic coding vocabulary to which an extension vocabulary (containing user-defined codes) is now 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. |