AP_ACCN_TEMPLATE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Accessioning Template Detail
Definition: This reference table includes Accessioning Template parameters that have been established and saved. Accessioning templates allow a site to predefine default values for the various fields within the accessioning conversation.
Table Type: REFERENCE





Column Detail - AP_ACCN_TEMPLATE_DETAIL


Column Name Type Null? Definition
CARRY_FORWARD_IND DOUBLE Y This field identifies whether the value from this row should be carried forward from one case to the next during the accessioning process.
CARRY_FORWARD_SPEC_IND DOUBLE Y This field identifies whether the value from this row should be carried forward from one specimen to the next during the accessioning process. This indicator is only used when adding additional specimens to a pathology case.
DETAIL_FLAG DOUBLE Y This field contains a representation of the type of data included in this template detail -- no value, data determined by the detail_id, or data determined by the detail_name.
DETAIL_ID DOUBLE Y This field contains the internal identification code of the 'template detail' value within a specified template parameter (denoted in the DETAIL_NAME field). Note this field is only used when the DETAIL_FLAG contains a value of 1.
DETAIL_NAME VARCHAR(16) Y This field represents the type of template detail (order location, requesting physician, specimen code, collected date/time) associated with this row on the 'ap accession template detail' table.
PARENT_ENTITY_NAME VARCHAR(30) Y Name of the Parent table for the Template Detail. The internal identifier is stored in the DETAIL_ID column.
TEMPLATE_CD DOUBLE N This field contains the internal reference to codeset 16689 which contains the user-defined 'Accessioning Template' name. At the time 'template' parameters are saved, the user is required to enter a name for the template, and this name is saved to codeset 16689.
TEMPLATE_DETAIL_ID DOUBLE N This field contains the unique value representing the 'accessioning template' detail.
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_ACCN_TEMPLATE_DETAIL


Child Column in AP_ACCN_TEMPLATE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_CD CODE_VALUE CODE_VALUE


AP_APP_FOLDERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ap_app_folders
Definition: This table contains a list of applications for anatomic pathology users who have folder favorites.
Table Type: ACTIVITY





Column Detail - AP_APP_FOLDERS


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N This field contains the unique application number of the anatomic pathology application that has folder "favorites".
APP_FOLDER_ID DOUBLE N This field contains the unique identifier for this row.
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.
USER_ID DOUBLE N This field contains the person id for the user who has folder "favorites" for a given anatomic pathology application.



Relationship Detail - AP_APP_FOLDERS


Child Column in AP_APP_FOLDERS(FK) Parent Table Name Parent Column Name
Parents: USER_ID PRSNL PERSON_ID




Parent Column in AP_APP_FOLDERS (PK) Child Table Name Child Column Name
Children: APP_FOLDER_ID AP_APP_FOLDER_DETAILS APP_FOLDER_ID


AP_APP_FOLDER_DETAILS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ap_app_folder_details
Definition: This table contains a list of (at most) 10 folders that each user has most frequently accessed for a given anatomic pathology application.
Table Type: ACTIVITY





Column Detail - AP_APP_FOLDER_DETAILS


Column Name Type Null? Definition
ACCESS_CNT DOUBLE N This field contains the number to times a user has accessed a particular folder for a given application.
APP_FOLDER_ID DOUBLE N This field contains a foreign key to the ap_app_folders table.
FOLDER_ID DOUBLE N This field contains folder_id from the ap_folder 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_APP_FOLDER_DETAILS


Child Column in AP_APP_FOLDER_DETAILS(FK) Parent Table Name Parent Column Name
Parents: APP_FOLDER_ID AP_APP_FOLDERS APP_FOLDER_ID


AP_BLOB_CLEANUP



Column Section Top of Page


Table-level Detail

Description: ap_blob_cleanup
Definition: This table contains a list of all images that can be deleted from the image archive by the ProView image server.
Table Type: ACTIVITY





Column Detail - AP_BLOB_CLEANUP


Column Name Type Null? Definition
BLOB_IDENTIFIER VARCHAR(128) N This field contains the unique identifier for the blob that is to be deleted from the image archive.
STORAGE_CD DOUBLE N Contains the device location where the blob is stored.
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_CASE_QUERY



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Case Query
Definition: This reference table includes basic parameters regarding an established case query. Detail parameters associated with the query are stored on the AP_CASE_QUERY_DETAILS table.
Table Type: ACTIVITY





Column Detail - AP_CASE_QUERY


Column Name Type Null? Definition
ACTIVITY_TYPE_CD DOUBLE N This is the Activity Type Cd of the product owning the Query. If this value is 0 it will be assumed to be AP.
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_DETAILS table.
NBR_COPIES DOUBLE Y This field contains the "number of copies" value specified by the user when the case query was executed.
OUTPUT_DEST_ID DOUBLE N This field contains the internal identification code of the output destination (related to a printer and a print queue) used to print the results of the case query.
QUERY_START_DT_TM DATETIME Y This field contains the date and time the user submitted the query.
REPORT_HISTORY_CD DOUBLE N This field contains the internal identification code of the report history grouping associated with the report query. The history grouping specifies the report component sections (discrete tasks) that will print on the report (if report text is printed).
REPORT_TYPE_FLAG DOUBLE Y This flag value specifies how the pathology reports qualifying for this query should be viewed. A value of "1" indicates that a summary (report parameters) view is used, while a value of "2" indicates that a detail (result text and codes) view is used.
RESULT_NAME VARCHAR(100) Y This field contains the 'Query Result Name' for this case query. This field is only filled out when the person initiating the query is saving query results.
RESULT_NAME_KEY VARCHAR(100) Y This field contains the same value as the result_name column converted to uppercase.
SEARCH_TYPE_FLAG DOUBLE Y This flag value documents how the reports should be searched for cases qualifying for this query. A value of "1" indicates that the search is at the report level, while a value of "2" indicates that the search is at the report component (discrete task) level.
STARTED_PRSNL_ID DOUBLE N This field contains the internal identification code associated with the user who submitted the report query.
STATUS_FLAG DOUBLE Y This field includes a flag value denoting the current status of the query. A value of "1" indicates that the query is pending. A status of "2" indicates that the query is in process. A status of "3" indicates that the query was cancelled. A status of "4" indicates that the query was completed. A status of "5" indicates that the execution of the query encountered an error.
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


Child Column in AP_CASE_QUERY(FK) Parent Table Name Parent Column Name
Parents: STARTED_PRSNL_ID PRSNL PERSON_ID




Parent Column in AP_CASE_QUERY (PK) Child Table Name Child Column Name
Children: CASE_QUERY_ID AP_CASE_QUERY_DETAILS CASE_QUERY_ID
AP_QUERY_RESULT CASE_QUERY_ID