Table Detail Report

AP_DISCRETE_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ap_discrete_entity
Definition: This field contains a row for each reference image stored in an anatomic pathology folder.
Table Type: ACTIVITY





Column Detail - AP_DISCRETE_ENTITY


Column Name Type Null? Definition
ENTITY_ID DOUBLE N This field contains the unique identifier for this table.
ENTITY_TYPE_FLAG DOUBLE Y This field contains the entity type. Currently, only reference image type is supported.
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_DISCRETE_ENTITY




Parent Column in AP_DISCRETE_ENTITY (PK) Child Table Name Child Column Name
Children: ENTITY_ID AP_IMAGE_MIGRATED ENTITY_ID


AP_EXT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: A/P External Data
Definition: To temporarily hold untrusted data that has come from an external source (e.g. FHIR)
Table Type: ACTIVITY





Column Detail - AP_EXT_DATA


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date and time of the action.
ACTION_PRSNL_ID DOUBLE Y The personnel who performed the action.
ACTIVE_IND DOUBLE N 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
AP_EXT_BLOB LONGBLOB Y The data that has come from an external interface.
AP_EXT_DATA_ID DOUBLE N Unique generated number that identifies a single row on the AP_EXT_DATA table.
CLIENT_IDENT VARCHAR(80) Y This unique identifier is used to indicate the parent external data that groups this external data row is related to.
CONFIDENTIALITY_TXT VARCHAR(40) Y Indicates the confidentiality of the document. For ex: From workflow perspective, if confidentiality is "restricted", the document stored in those table will not be pushed to chart(and it will not be viewable)
CORRELATION_IDENT VARCHAR(80) N Uppercase, hyphenated GUID that identifies the transaction that updated this row.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data.
EFFECTIVE_DT_TM DATETIME Y The clinicaly significant date time of this lab result.
ENCNTR_ID DOUBLE Y The encounter related to the external data.
EVENT_ID DOUBLE Y The id of the clinical event associated to this lab result.
ISSUE_DT_TM DATETIME Y The date and time this external data was added to the staging tables.
ISSUE_PRSNL_ID DOUBLE Y The personnel who issued this result.
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARENT_EXT_DATA_ID DOUBLE Y This unique identifier is used to indicate the parent external data that groups this external data row is related to.
PERSON_ID DOUBLE Y The person related to the external data.
REQUESTED_ACTION_CD DOUBLE N Action requested for the data.
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_EXT_DATA


Child Column in AP_EXT_DATA(FK) Parent Table Name Parent Column Name
Parents: PARENT_EXT_DATA_ID AP_EXT_DATA AP_EXT_DATA_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PERSON_ID PERSON PERSON_ID
ACTION_PRSNL_ID PRSNL PERSON_ID
ISSUE_PRSNL_ID PRSNL PERSON_ID




Parent Column in AP_EXT_DATA (PK) Child Table Name Child Column Name
Children: AP_EXT_DATA_ID AP_EXT_DATA PARENT_EXT_DATA_ID


AP_FAVORITE



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Favorite
Definition: Stores favorite items for users of AP Applications.
Table Type: ACTIVITY





Column Detail - AP_FAVORITE


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.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
AP_FAVORITE_ID DOUBLE N Unique generated number that identifies a single row on the AP_FAVORITE table.
GROUP_CD DOUBLE Y The processing group that this personnel has marked as a favorite.
PRSNL_ID DOUBLE Y The personnel that has chosen favorite items.
TASK_ASSAY_CD DOUBLE Y Task Assay Code that has been chosen as a favorite.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_FAVORITE


Child Column in AP_FAVORITE(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
PRSNL_ID PRSNL PERSON_ID


AP_FOLDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: ap_folder
Definition: This table contains all anatomic pathology folders, both public and private.
Table Type: ACTIVITY





Column Detail - AP_FOLDER


Column Name Type Null? Definition
ANONYMOUS_BITMAP DOUBLE Y This field contains the permission values used for users that have not been explicitly assigned proxy permissions, but do have application/task security required to use 'folder' functionality. Valid values are the same for the permission_bitmap.
COMMENT_ID DOUBLE N This field contains the value representing the entry on the long_text table that contains the comment associated with the folder.
CREATE_PRSNL_ID DOUBLE N This field contains the person_id of the person who created this folder.
DEFAULT_BITMAP DOUBLE Y This field contains the 'default' permission values used when adding new 'proxy' permissions.
FOLDER_ID DOUBLE N This field contains the unique identifier for this table.
FOLDER_NAME VARCHAR(100) Y This field contains the display name of the folder.
FOLDER_NAME_KEY VARCHAR(100) N This field contains the folder_name with all special characters removed and all alpha characters converted to uppercase. This column must be 'unique' at the nodes level.
FOLDER_NAME_KEY_A_NLS VARCHAR(400) Y FOLDER_NAME_KEY_A_NLS column
FOLDER_NAME_KEY_NLS VARCHAR(202) Y This column was added for internationalization reasons.
PARENT_FOLDER_ID DOUBLE N This field contains the folder_id of the parent folder. If this folder is at the 'root' level, this field will contain the same value as the folder_id column.
PUBLIC_IND DOUBLE Y This field indicates whether or not this folder is personal or public.
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_FOLDER


Child Column in AP_FOLDER(FK) Parent Table Name Parent Column Name
Parents: COMMENT_ID LONG_TEXT LONG_TEXT_ID
CREATE_PRSNL_ID PRSNL PERSON_ID


AP_FOLDER_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ap_folder_entity
Definition: This folder contains a row for each 'item' a folder contains. Currently, items may include reference images, images belonging to a specific pathology case, and entire pathology cases.
Table Type: ACTIVITY





Column Detail - AP_FOLDER_ENTITY


Column Name Type Null? Definition
ACCESSION_NBR CHAR(21) Y This field contains the case identifier for the pathology case to which this folder item references. This field will be empty for reference images.
COMMENT_ID DOUBLE N This field contains the value representing the entry on the long_text table that contains the comment associated with the folder.
CREATE_PRSNL_ID DOUBLE N This field contains the person_id for the user who added this item to the folder.
DISPLAY VARCHAR(255) Y This field contains the displayable name for the folder item.
ENTITY_ID DOUBLE N This field contains the unique identifier for this table.
ENTITY_TYPE_FLAG DOUBLE Y This field identifies the type of folder item. Currently, only reference images, images associated to a pathology case, and pathology cases are valid types.
FOLDER_ID DOUBLE N This field contains the foreign key value used to join to the AP_FOLDER table.
PARENT_ENTITY_ID DOUBLE N This field contains the primary identifier for the parent table.
PARENT_ENTITY_NAME VARCHAR(32) N This field contains the table name for the parent table.
SEQUENCE DOUBLE Y This field is not currently used.
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_FOLDER_ENTITY


Child Column in AP_FOLDER_ENTITY(FK) Parent Table Name Parent Column Name
Parents: COMMENT_ID LONG_TEXT LONG_TEXT_ID
CREATE_PRSNL_ID PRSNL PERSON_ID