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 |