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 |