Table Detail Report

AP_FT_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Followup Tracking Type
Definition: This reference table contains the basic parameters regarding follow-up tracking for cytology. Cases are optionally associated with a follow-up tracking type based on the alpha response value assigned to the diagnosis.
Table Type: REFERENCE





Column Detail - AP_FT_TYPE


Column Name Type Null? Definition
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.
DESCRIPTION VARCHAR(60) Y This field contains the description of the follow-up tracking type.
DOCTOR_FINAL_OVERDUE_IND DOUBLE Y This field contains a flag value indicating whether or not the patient's physician (the physician that submitted the cytology case that caused the follow-up event to be initiated) should receive a copy of the follow-up tracking final overdue report.
DOCTOR_FINAL_TEMPLATE_ID DOUBLE N This field contains the foreign key value used to join to the follow-up report template used for the physician final overdue notification report. Template information is stored on the WP_TEMPLATE and WP_TEMPLATE_TEXT reference tables.
DOCTOR_FIRST_OVERDUE_IND DOUBLE Y This field contains a flag value indicating whether or not the patient's physician (the physician that submitted the cytology case that caused the follow-up event to be initiated) should receive a copy of the follow-up tracking initial overdue report.
DOCTOR_FIRST_TEMPLATE_ID DOUBLE N This field contains the foreign key value used to join to the follow-up report template used for the physician initial overdue notification report. Template information is stored on the WP_TEMPLATE and WP_TEMPLATE_TEXT reference tables.
DOCTOR_NOTIFICATION_IND DOUBLE Y This field contains a flag value indicating whether or not the patient's physician (the physician that submitted the cytology case that caused the follow-up event to be initiated) should receive a copy of the follow-up initial notification report.
DOCTOR_NOTIF_TEMPLATE_ID DOUBLE N This field contains the foreign key value used to join to the follow-up report template used for the physician initial notification report. Template information is stored on the WP_TEMPLATE and WP_TEMPLATE_TEXT reference tables.
FOLLOWUP_TRACKING_TYPE_CD DOUBLE N This uniquely identifies a row included on the AP_FT_TYPE table. This field would be used to join to other tables (as a foreign key). The follow-up tracking type is also represented as an entry on codeset 1317.
PATIENT_FINAL_OVERDUE_IND DOUBLE Y This field contains a flag value indicating whether or not the patient should receive a copy of the follow-up final overdue report. Note: This functionality is not yet available.
PATIENT_FINAL_TEMPLATE_ID DOUBLE N This field contains the foreign key value used to join to the follow-up report template used for the patient final overdue report. Template information is stored on the WP_TEMPLATE and WP_TEMPLATE_TEXT reference tables.
PATIENT_FIRST_OVERDUE_IND DOUBLE Y This field contains a flag value indicating whether or not the patient should receive a copy of the follow-up initial overdue report. Note: This functionality is not yet available.
PATIENT_FIRST_TEMPLATE_ID DOUBLE N This field contains the foreign key value used to join to the follow-up report template used for the patient initial overdue report. Template information is stored on the WP_TEMPLATE and WP_TEMPLATE_TEXT reference tables.
PATIENT_NOTIFICATION_IND DOUBLE Y This field contains a flag value indicating whether or not the patient should receive a copy of the follow-up initial notification report. Note: This functionality is not yet available.
PATIENT_NOTIF_TEMPLATE_ID DOUBLE N This field contains the foreign key value used to join to the follow-up report template used for the patient initial notification report. Template information is stored on the WP_TEMPLATE and WP_TEMPLATE_TEXT reference tables.
SHORT_DESC VARCHAR(25) Y This field contains the short description (mnemonic) of the follow-up tracking type.
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_FT_TYPE


Child Column in AP_FT_TYPE(FK) Parent Table Name Parent Column Name
Parents: FOLLOWUP_TRACKING_TYPE_CD CODE_VALUE CODE_VALUE
DOCTOR_FINAL_TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID
DOCTOR_FIRST_TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID
DOCTOR_NOTIF_TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID
PATIENT_FINAL_TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID
PATIENT_FIRST_TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID
PATIENT_NOTIF_TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID




Parent Column in AP_FT_TYPE (PK) Child Table Name Child Column Name
Children: FOLLOWUP_TRACKING_TYPE_CD AP_FT_EVENT FOLLOWUP_TYPE_CD
AP_FT_REPORT_PROC FOLLOWUP_TRACKING_TYPE_CD
AP_FT_TERM_PROC FOLLOWUP_TRACKING_TYPE_CD
CYTO_ALPHA_SECURITY FOLLOWUP_TRACKING_TYPE_CD


AP_IMAGE_GROUP_INI



Column Section Relationship Section Top of Page


Table-level Detail

Description: ap_image_group_ini
Definition: This activity table contains records for each user who has accessed the ap image management application. Each user will have a row for each imaging bar group they have created.
Table Type: ACTIVITY





Column Detail - AP_IMAGE_GROUP_INI


Column Name Type Null? Definition
NAME VARCHAR(255) N This field contains the display name of the image bar group.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SEQUENCE DOUBLE N This field contains the logical order (sequence) that this image group should be displayed.
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_IMAGE_GROUP_INI


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


AP_IMAGE_ITEM_INI



Column Section Relationship Section Top of Page


Table-level Detail

Description: ap_image_item_ini
Definition: This table contains a row for each item a user has in a particular imaging bar group designated on the ap_image_group_ini table.
Table Type: ACTIVITY





Column Detail - AP_IMAGE_ITEM_INI


Column Name Type Null? Definition
NAME VARCHAR(255) N This field contains the display name for this imaging bar item.
PARENT_ENTITY_ID DOUBLE N This field contains the key value of the parent row on the ap_image_group_ini table.
PARENT_ENTITY_NAME VARCHAR(32) N This field contains the table name of the parent row on the ap_image_group_ini table.
PARENT_SEQUENCE DOUBLE N This field contains the parent sequence of the imaging bar group item.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SEQUENCE DOUBLE N This field contains the logical display ordering (sequence) for the imaging bar group item.
TYPE_FLAG DOUBLE N This field contains the type of the imaging bar group item. Valid values are 1 - 5.
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_IMAGE_ITEM_INI


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


AP_IMAGE_MIGRATED



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Image Migrated
Definition: This table contains records of image blobs migrated from DICOM to MMF.
Table Type: ACTIVITY





Column Detail - AP_IMAGE_MIGRATED


Column Name Type Null? Definition
AP_IMAGE_MIGRATED_ID DOUBLE N Uniquely identifies a given migrated image.
CASE_ID DOUBLE N Uniquely identifies the Pathology Case related to this migrated image.
DICOM_BLOB_HANDLE_IDENT VARCHAR(255) N This stores the identifier with which the image was stored in DICOM.
ENTITY_ID DOUBLE N Uniquely stores the identifier of the ap discrete entity related to this migrated image.
MMF_BLOB_HANDLE_IDENT VARCHAR(255) N Stores the identifier of the image stored in MMF.
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_IMAGE_MIGRATED


Child Column in AP_IMAGE_MIGRATED(FK) Parent Table Name Parent Column Name
Parents: ENTITY_ID AP_DISCRETE_ENTITY ENTITY_ID
CASE_ID PATHOLOGY_CASE CASE_ID


AP_IMAGE_STATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: ap_image_station
Definition: This table contains all of the anatomic pathology image stations. Image stations are used to stream line the process of acquiring pathology images by allowing users to setup acquisition defaults at a particular imaging station.
Table Type: REFERENCE





Column Detail - AP_IMAGE_STATION


Column Name Type Null? Definition
SOURCE_DEVICE_CD DOUBLE N This field contains the code_value of the device that was used to capture the image.
STATION_ID DOUBLE N This field contains the unique identifier for each image station on the ap_image_station table.
STATION_NAME VARCHAR(40) Y This field contains the display name for an image station.
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_IMAGE_STATION




Parent Column in AP_IMAGE_STATION (PK) Child Table Name Child Column Name
Children: STATION_ID AP_PREFIX_STATION_R STATION_ID