Table Detail Report

UCM_POSITION_MAP_CELL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Position Map Cell
Definition: Stores the details for each cell in the position map for a protocol batch.
Table Type: ACTIVITY





Column Detail - UCM_POSITION_MAP_CELL


Column Name Type Null? Definition
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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CELL_SEQ_NBR DOUBLE N The sequence number of this cell based on the pattern defined for the position map.
CELL_TXT VARCHAR(40) N The text to display in the cell.
COL_NBR DOUBLE N The column to which this cell belongs.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
MAP_NBR DOUBLE N The map to which this cell belongs.
PREV_UCM_POSITION_MAP_CELL_ID DOUBLE N This field is used to track versions of the protocol batch item map cell information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective date/times.
ROW_NBR DOUBLE N The row to which this cell belongs.
UCMR_POSITION_MAP_ID DOUBLE N Unique identifier of the reference position map to which this cell is associated.
UCM_POSITION_MAP_CELL_ID DOUBLE N Uniquely identifies a row for each cell in the position map for a protocol batch which stores the details about that cell.
UCM_PTL_BATCH_ITEM_ID DOUBLE N Unique identifier for the batch item to which this position map cell is associated.
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 - UCM_POSITION_MAP_CELL


Child Column in UCM_POSITION_MAP_CELL(FK) Parent Table Name Parent Column Name
Parents: UCMR_POSITION_MAP_ID UCMR_POSITION_MAP UCMR_POSITION_MAP_ID
UCM_PTL_BATCH_ITEM_ID UCM_PTL_BATCH_ITEM UCM_PTL_BATCH_ITEM_ID


UCM_PRSNL_ASSIGNMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management - Personnel Assignment
Definition: This table tracks which cases a user is responsible for completing.
Table Type: ACTIVITY





Column Detail - UCM_PRSNL_ASSIGNMENT


Column Name Type Null? Definition
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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PREV_UCM_PRSNL_ASSIGNMENT_ID DOUBLE N Used to track versions of the PRSNL_ASSIGNMENT information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PRSNL_ID DOUBLE N Uniquely identifies the person working on this assignment.
UCM_CASE_ID DOUBLE N Uniquely identifies the Case related to this assingment.
UCM_PRSNL_ASSIGNMENT_ID DOUBLE N Uniquely identifies the relationship between a case and the person assigned to complete it.
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 - UCM_PRSNL_ASSIGNMENT


Child Column in UCM_PRSNL_ASSIGNMENT(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
UCM_CASE_ID UCM_CASE UCM_CASE_ID


UCM_PTL_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Protocol Batch
Definition: This table is used to track high level protocol batch information.
Table Type: ACTIVITY





Column Detail - UCM_PTL_BATCH


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Indicates when the corresponding action was taken on the protocol batch.
ACTION_TYPE_CD DOUBLE N Indicates the type of action taken on the protocol batch.
ACTION_TZ DOUBLE Y Time Zone associated with the corresponding Action_DT_TM column.
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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COMPLETE_DT_TM DATETIME Y The complete date and time of the batch.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ORDER_CNT DOUBLE N Indicates the number of orders in this batch. Will be used to determine when one or more orders have been archived
PREV_UCM_PTL_BATCH_ID DOUBLE N This field is used to track versions of the protocol batch information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PTL_BATCH_NAME VARCHAR(40) N Contains the user defined name for this batch.
SERVICE_RESOURCE_CD DOUBLE N The code for the service resource for which the batch was initially defined.
START_DT_TM DATETIME Y The start date and time of the batch.
UCMR_WORKSHEET_ID DOUBLE N Indicates the reference worksheet this batch used.
UCM_PTL_BATCH_ID DOUBLE N Uniquely identifies a specific protocol batch 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 - UCM_PTL_BATCH


Child Column in UCM_PTL_BATCH(FK) Parent Table Name Parent Column Name
Parents: UCMR_WORKSHEET_ID UCMR_WORKSHEET UCMR_WORKSHEET_ID




Parent Column in UCM_PTL_BATCH (PK) Child Table Name Child Column Name
Children: UCM_PTL_BATCH_ID UCM_PTL_BATCH_ITEM UCM_PTL_BATCH_ID
UCM_PTL_FILE_DEF_HIST UCM_PTL_BATCH_ID


UCM_PTL_BATCH_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Protocol Batch Item
Definition: This table tracks the orders and optionally containers that were used in and created by a protocol batch.
Table Type: ACTIVITY





Column Detail - UCM_PTL_BATCH_ITEM


Column Name Type Null? Definition
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.
BATCH_ITEM_STATUS_CD DOUBLE N This field is used to indicate the status of this item within this batch.
BATCH_ORDER_STATUS_CD DOUBLE N Used to indicate the status of the order within this batch.
BATCH_SEQUENCE_NBR DOUBLE N Used to identify the sequence of the order in the batch.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTAINER_ID DOUBLE N Specifies the container that is associated to this batch.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EVALUATION_FLAG DOUBLE N Current evaluation status of a protocol order. 0 - none; 1 - Pending evaluation; 2 - Completed evaluation
INPUT_IND DOUBLE N Indicates if this batch item was used as input to the batch. If it is not an input to the batch, it was created by the batch.
ORDER_ID DOUBLE N Specifies the order that is associated to this batch.
OUTPUT_SEQUENCE_NBR DOUBLE N The sequence in which the output containers are created.
PREV_UCM_PTL_BATCH_ITEM_ID DOUBLE N This field is used to track versions of the protocol batch item information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
SPECIMEN_TYPE_CD DOUBLE N Indicates the specimen type of the container associated with the batch item.
UCM_PTL_BATCH_ID DOUBLE N Identifies the batch to which this item belongs.
UCM_PTL_BATCH_ITEM_ID DOUBLE N Uniquely identifies a given item within a batch.
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 - UCM_PTL_BATCH_ITEM


Child Column in UCM_PTL_BATCH_ITEM(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
UCM_PTL_BATCH_ID UCM_PTL_BATCH UCM_PTL_BATCH_ID




Parent Column in UCM_PTL_BATCH_ITEM (PK) Child Table Name Child Column Name
Children: UCM_PTL_BATCH_ITEM_ID UCM_POSITION_MAP_CELL UCM_PTL_BATCH_ITEM_ID
UCM_PTL_RESULT UCM_PTL_BATCH_ITEM_ID


UCM_PTL_FILE_DEF_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management - Protocol File Definition History
Definition: This table stores the history of file definition usage for a protocol batch.
Table Type: ACTIVITY





Column Detail - UCM_PTL_FILE_DEF_HIST


Column Name Type Null? Definition
FILE_DEF_CD DOUBLE N Indicates the file definition related to this record.
UCM_PTL_BATCH_ID DOUBLE N Indicated the protocol batch related to this record.
UCM_PTL_FILE_DEF_HIST_ID DOUBLE N File definition run identifier. Contains a unique history file definition for a protocol batch.
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 - UCM_PTL_FILE_DEF_HIST


Child Column in UCM_PTL_FILE_DEF_HIST(FK) Parent Table Name Parent Column Name
Parents: UCM_PTL_BATCH_ID UCM_PTL_BATCH UCM_PTL_BATCH_ID