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 |