Table Detail Report

AP_IMG_MIGRATION_XCPTN



Column Section Top of Page


Table-level Detail

Description: AP Image Migration Exception
Definition: Contains exception records from the ap imaging migration server.
Table Type: ACTIVITY





Column Detail - AP_IMG_MIGRATION_XCPTN


Column Name Type Null? Definition
AP_IMG_MIGRATION_XCPTN_ID DOUBLE N Uniquely identifies an exception record from the ap imaging migration server.
PARENT_ENTITY_ID DOUBLE N Contains the id of the row on the parent entity table that caused the exception.
PARENT_ENTITY_NAME VARCHAR(30) N Contains the name of the parent entity table that caused the exception.
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.
XCPTN_MSG VARCHAR(255) N Textual description of the exception. This is an untranslated internal error message.


AP_INV_RETENTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Aatomic Pathology Inventory Retention
Definition: Describes the retention times of Anatomic Pathology inventory.
Table Type: REFERENCE





Column Detail - AP_INV_RETENTION


Column Name Type Null? Definition
AP_INV_RETENTION_ID DOUBLE N Uniquely identifies a given retention time for specific Anatomic Pathology inventory
INVENTORY_TYPE_CD DOUBLE N The type of inventory the retention defines.
NORMALCY_CD DOUBLE N The normalcy code associated with the inventory that the retention defines.
PREFIX_ID DOUBLE N Contains the prefix associated with the inventory that the retention defines.
RETENTION_TM_VALUE DOUBLE N Contains the retention time.
RETENTION_UNITS_CD DOUBLE N The retention time unit of measure.
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_INV_RETENTION


Child Column in AP_INV_RETENTION(FK) Parent Table Name Parent Column Name
Parents: PREFIX_ID AP_PREFIX PREFIX_ID


AP_LOGIN_ORDER_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Login Order List
Definition: This activity table contains anatomic pathology orders which have been initiated in an "outside department" orders application (such as Departmental Order Entry), and must be "logged in" using Maintain Case when received in pathology.
Table Type: ACTIVITY





Column Detail - AP_LOGIN_ORDER_LIST


Column Name Type Null? Definition
ACCESSION_ID DOUBLE N This field contains the foreign key value used to represent the accession value to which order is associated with.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ORDER_ID DOUBLE N This is the value of the unique primary identifier of the orders table. It is an internal system assigned number used to represent the actual order record.
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_LOGIN_ORDER_LIST


Child Column in AP_LOGIN_ORDER_LIST(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_ID ACCESSION ACCESSION_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID


AP_OPS_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Operations Exception
Definition: This activity table contains data used to reprocess 'Quick Verify' jobs that have failed. When the job has been processed successfully, the row is deleted.
Table Type: ACTIVITY





Column Detail - AP_OPS_EXCEPTION


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N Indicates the type of action to be performed on the ops exception order.(-1) Held Verify, (1) Quick Verify Order, (2) Specimen Order, (3) Report Order, (4) Processing Task Order, (5) Specimen Update, (6) Report Update, (7) Processing Task Update
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.
FLEX1_ID DOUBLE Y Unique identifier to additional information required for a given action (action_flag).
PARENT_ID DOUBLE N Unique identifier to the parent table which wrote the row. Table is based on the value in action_flag.
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_OPS_EXCEPTION




Parent Column in AP_OPS_EXCEPTION (PK) Child Table Name Child Column Name
Children: ACTION_FLAG AP_OPS_EXCEPTION_DETAIL ACTION_FLAG
PARENT_ID AP_OPS_EXCEPTION_DETAIL PARENT_ID


AP_OPS_EXCEPTION_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: This activity table contains additional information for processing an AP order.
Definition: AP Operations Exception Details
Table Type: ACTIVITY





Column Detail - AP_OPS_EXCEPTION_DETAIL


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N Indicates the type of action to be performed on the ops exception order. (-1) Held Verify, (1) Quick Verify Order, (2) Specimen Order, (3) Report Order, (4) Processing Task Order, (5) Specimen Update, (6) Report Update, (7) Processing Task Update
FIELD_DESC VARCHAR(255) Y A text value of the additional information for the ops exception order.
FIELD_DT_TM DATETIME Y A date and time value of the additional information for the ops exception order.
FIELD_ID DOUBLE N A number value of the additional information for the ops exception order.
FIELD_MEANING VARCHAR(40) Y The description of the type of additional information being stored for the ops exception order.
FIELD_NBR DOUBLE Y A number value of the additional information for the ops exception order.
PARENT_ID DOUBLE N Identifies the ops exception order that the detail information is for.
SEQUENCE DOUBLE N This field is used in combination with the parent id to make the primary key for this table.
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_OPS_EXCEPTION_DETAIL


Child Column in AP_OPS_EXCEPTION_DETAIL(FK) Parent Table Name Parent Column Name
Parents: ACTION_FLAG AP_OPS_EXCEPTION ACTION_FLAG
PARENT_ID AP_OPS_EXCEPTION PARENT_ID