Table Detail Report

UCMR_POSITION_MAP_CELL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Position Map Cell
Definition: Store the details for each cell in the position map for a protocol worksheet.
Table Type: REFERENCE





Column Detail - UCMR_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.
BATCH_ITEM_SEQ_NBR DOUBLE N The sequence number of the batch item that should be displayed in this cell.
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.
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.
LABEL_TXT VARCHAR(40) N The text to display in a placeholder cell.
MAP_NBR DOUBLE N The map to which this cell belongs.
PLACEHOLDER_IND DOUBLE N Indicator whether this cell is a placeholder or contains an order/container.
ROW_NBR DOUBLE N The row to which this cell belongs.
UCMR_POSITION_MAP_CELL_ID DOUBLE N Uniquely identifies a cell in the position map for a protocol worksheet and contains the details related to this cell.
UCMR_POSITION_MAP_ID DOUBLE N Uniquely identifiesthe position map to which this 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 - UCMR_POSITION_MAP_CELL


Child Column in UCMR_POSITION_MAP_CELL(FK) Parent Table Name Parent Column Name
Parents: UCMR_POSITION_MAP_ID UCMR_POSITION_MAP UCMR_POSITION_MAP_ID


UCMR_REQUIRED_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Reference Required Step
Definition: This table stores case steps that are dependent on other case steps.
Table Type: REFERENCE





Column Detail - UCMR_REQUIRED_STEP


Column Name Type Null? Definition
ACROSS_WORKUPS_IND DOUBLE N Indicates if the required step must be completed across all instances of this workup, Not just the same instance of the workup.
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.
REQUIRED_UCMR_CASE_STEP_ID DOUBLE N This field is a unique identifier for the required case step version.
UCMR_CASE_STEP_ID DOUBLE N This field indicates the case step that has other steps that are required before it can be accessed.
UCMR_REQUIRED_STEP_ID DOUBLE N This field contains the unique identifier for the required case step version.
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 - UCMR_REQUIRED_STEP


Child Column in UCMR_REQUIRED_STEP(FK) Parent Table Name Parent Column Name
Parents: REQUIRED_UCMR_CASE_STEP_ID UCMR_CASE_STEP UCMR_CASE_STEP_ID
UCMR_CASE_STEP_ID UCMR_CASE_STEP UCMR_CASE_STEP_ID


UCMR_STATEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Reference Statement
Definition: This table stores specific information about a protocol statement.
Table Type: REFERENCE





Column Detail - UCMR_STATEMENT


Column Name Type Null? Definition
ACCEPT_TYPE_CD DOUBLE N This field indicates the type of data accepted.
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.
ALLOW_MULTIPLE_IND DOUBLE N When True, the statement can be added multiple times to Process or Output areas, but cannot be added to Input.
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.
CODE_SET DOUBLE N When the accept type is coded list, this number will indicate which code set should appear in list at activity time.
DEFAULT_LABEL_TEXT VARCHAR(250) Y Stores the statement default label text.
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.
MAX_DIGITS_NBR DOUBLE N This field defines the maximum number of digits allowed in the numeric accept.
MIN_DECIMAL_PLACES_NBR DOUBLE N This field defines the minimum number of decimal places required in the numeric accept.
MIN_DIGITS_NBR DOUBLE N This field defines the minimum number of digits required in the numeric accept.
PREV_UCMR_STATEMENT_ID DOUBLE N This field is used to track versions of the statement 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.
SCI_NOTATION_IND DOUBLE N This field indicates whether the statement allows numeric values in scientific notation. If set, any value that exceeds the maximum digits and decimal places data map settings will be formatted in scientific notation (e.g. MaxDigits = 5, Decimal Places = 2, Value = 1000.00 then the FormattedValue = 1.00e3). Otherwise, the value will be formatted using the data map settings.
STATEMENT_NAME_CD DOUBLE N The code value associated to the statement name.
UCMR_STATEMENT_ID DOUBLE N This field uniquely identifies a row in the UCMR_STATEMENT table.
UNITS_CD DOUBLE N This field contains a unique code value that identifies the unites of measure for interpreting the result value.
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.
XML_FORMATTING_TEXT_ID DOUBLE N This field contains statement formatting information in an xml blob. This information may include whether accept appears before statement text or any other information pertaining the statement within a worksheet.



Relationship Detail - UCMR_STATEMENT


Child Column in UCMR_STATEMENT(FK) Parent Table Name Parent Column Name
Parents: XML_FORMATTING_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
PREV_UCMR_STATEMENT_ID UCMR_STATEMENT UCMR_STATEMENT_ID




Parent Column in UCMR_STATEMENT (PK) Child Table Name Child Column Name
Children: UCMR_STATEMENT_ID UCMR_STATEMENT PREV_UCMR_STATEMENT_ID
UCMR_STATEMENT_VALIDATION UCMR_STATEMENT_ID


UCMR_STATEMENT_VALIDATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Reference - Statement Validation
Definition: This table stores relationships between worksheets statements and validation information. Includes numeric range validation and whether the statement is enabled for a specific sample.
Table Type: REFERENCE





Column Detail - UCMR_STATEMENT_VALIDATION


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_UCMR_STMT_VALIDATION_ID DOUBLE N Used to track versions of the statement validation 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.
UCMR_STATEMENT_ID DOUBLE N Uniquely identifies the statement.
UCMR_STATEMENT_VALIDATION_ID DOUBLE N This field contains the key that uniquely identifies a row on the UCMR_STATEMENT_VALIDATION table.
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.
VALIDATION_CD DOUBLE N A code value from any code set that is checked at activity time to determine if a valid selection from a code list was made.
VALIDATION_NBR DOUBLE N The number used for comparison with the statement accept value on the activity side to determine if the input is valid.
VALIDATION_TEXT VARCHAR(250) Y This field is used to store textual validation information for a worksheet statement (e.g. ensuring current date entered.)
VALIDATION_TYPE_CD DOUBLE N This field is used to store the internal code for the type of validation (e.g., minimum, maximum, etc.)



Relationship Detail - UCMR_STATEMENT_VALIDATION


Child Column in UCMR_STATEMENT_VALIDATION(FK) Parent Table Name Parent Column Name
Parents: UCMR_STATEMENT_ID UCMR_STATEMENT UCMR_STATEMENT_ID
PREV_UCMR_STMT_VALIDATION_ID UCMR_STATEMENT_VALIDATION UCMR_STATEMENT_VALIDATION_ID




Parent Column in UCMR_STATEMENT_VALIDATION (PK) Child Table Name Child Column Name
Children: UCMR_STATEMENT_VALIDATION_ID UCMR_STATEMENT_VALIDATION PREV_UCMR_STMT_VALIDATION_ID


UCMR_WORKSHEET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Worksheet
Definition: This table stores reference data for a protocol worksheet.
Table Type: REFERENCE





Column Detail - UCMR_WORKSHEET


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 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.
UCMR_WORKSHEET_ID DOUBLE N This field uniquely identifies a row on the UCMR_WORKSHEET table.
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.
WORKSHEET_NAME_CD DOUBLE N The code value of the worksheet name.
XML_FORMATTING_TEXT_ID DOUBLE N Stores worksheet formatting information in an xml blob. This information may include input section, process section, output section flags or any other information pertaining to the worksheet.



Relationship Detail - UCMR_WORKSHEET


Child Column in UCMR_WORKSHEET(FK) Parent Table Name Parent Column Name
Parents: XML_FORMATTING_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in UCMR_WORKSHEET (PK) Child Table Name Child Column Name
Children: UCMR_WORKSHEET_ID UCMR_POSITION_MAP UCMR_WORKSHEET_ID
UCMR_WORKSHEET_ORDERABLE_R UCMR_WORKSHEET_ID
UCMR_WORKSHEET_STATEMENT_R UCMR_WORKSHEET_ID
UCM_PTL_BATCH UCMR_WORKSHEET_ID