Table Detail Report

UCM_PTL_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Protocol Result
Definition: Stores protocol results for a protocol batch item.
Table Type: ACTIVITY





Column Detail - UCM_PTL_RESULT


Column Name Type Null? Definition
ACCEPT_TYPE_CD DOUBLE N Identifies the type of accept for this result. Stored here in case the result is converted to a different accept type, and the new type is tracked here.
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.
FROM_PTL_RESULT_ID DOUBLE N Identifies the ucm_ptl_result_id from which this result's snapshot was taken.
PREV_UCM_PTL_RESULT_ID DOUBLE N This field is used to track versions of the protocol result 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.
RESULT_CD DOUBLE N Stores result for accept type of coded list (item selected from list). Note, this can be code value from any code set, since the available values for a code list are the values from any code set chosen for the worksheet statement.
RESULT_DT_TM DATETIME Y Stores result for the accept type of date and time, and date.
RESULT_FLAG DOUBLE N Stores extra information pertaining to results. This field is a bitwise combination of flag values to allow multiple values to be stored at the same time.
RESULT_NBR DOUBLE N Stores result for accept types of Checkbox (1 = Checked), Numeric, Calculation, and Time. For time, a 4 digit number will be saved. Note a time result will not be adjusted for UTC since it is stored this way.
RESULT_PRSNL_ID DOUBLE N Stores results for the accept type of Personnel ID
RESULT_TXT VARCHAR(250) N Stores result for accept type of Text and will store the appropriate textual representation of all other accept types as well.
RESULT_TZ DOUBLE N Time zone associated with the corresponding RESULT_DT_TM column.
UCMR_WORKSHEET_STATEMENT_ID DOUBLE N Identifies the reference side worksheet statement this result represents.
UCM_PTL_BATCH_ITEM_ID DOUBLE N Identifies the batch item (order/container) to which this result applies.
UCM_PTL_RESULT_ID DOUBLE N Uniquely identifies a given protocol result.
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_RESULT


Child Column in UCM_PTL_RESULT(FK) Parent Table Name Parent Column Name
Parents: RESULT_PRSNL_ID PRSNL PERSON_ID
UCMR_WORKSHEET_STATEMENT_ID UCMR_WORKSHEET_STATEMENT_R UCMR_WORKSHEET_STATEMENT_R_ID
UCM_PTL_BATCH_ITEM_ID UCM_PTL_BATCH_ITEM UCM_PTL_BATCH_ITEM_ID
FROM_PTL_RESULT_ID UCM_PTL_RESULT UCM_PTL_RESULT_ID




Parent Column in UCM_PTL_RESULT (PK) Child Table Name Child Column Name
Children: UCM_PTL_RESULT_ID UCM_PTL_RESULT FROM_PTL_RESULT_ID
UCM_REPORT_FIELD UCM_PTL_RESULT_ID


UCM_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Report
Definition: Stores activity data for Document Case Report application
Table Type: ACTIVITY





Column Detail - UCM_REPORT


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.
LAST_REFRESH_DT_TM DATETIME N The date and time of when the field data was last refreshed.
LAYOUT_VERSION_DT_TM DATETIME N Used with ucmr_layout_id to identify the correct layout version for this activity record.
ORDER_ID DOUBLE N Uniquely identifies the corresponding order for this report.
PREV_UCM_REPORT_ID DOUBLE N Used to track versions of the report 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.
REPORT_RTF_ID DOUBLE N The long blob identifier which sotres the layout RTF.
UCMR_LAYOUT_ID DOUBLE N Uniquely identifies the reference layout for this report.
UCM_REPORT_ID DOUBLE N Uniquely identifies activity data for Document Case Report application.
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_REPORT


Child Column in UCM_REPORT(FK) Parent Table Name Parent Column Name
Parents: REPORT_RTF_ID LONG_BLOB LONG_BLOB_ID
ORDER_ID ORDERS ORDER_ID
UCMR_LAYOUT_ID UCMR_LAYOUT UCMR_LAYOUT_ID




Parent Column in UCM_REPORT (PK) Child Table Name Child Column Name
Children: UCM_REPORT_ID UCM_REPORT_FIELD UCM_REPORT_ID


UCM_REPORT_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Report Field
Definition: Stores activity data for Document Case Report application
Table Type: ACTIVITY





Column Detail - UCM_REPORT_FIELD


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.
OD_ACTION_SEQ DOUBLE N The action sequence of the order detail data for this field.
OD_DETAIL_SEQ DOUBLE N The detail sequence of the order detail data for this field.
OD_ORDER_ID DOUBLE N Uniquely identifies the source order of the order detail data for this field.
PREV_UCM_REPORT_FIELD_ID DOUBLE N Used to track versions of the report field 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.
RESULT_ID DOUBLE N If populated, identifies the source result for this field.
UCMR_LAYOUT_FIELD_ID DOUBLE N Identifies the layout field reference for this report field.
UCM_PTL_RESULT_ID DOUBLE N If populated, identifies the source protocol result for this field.
UCM_REPORT_FIELD_ID DOUBLE N Uniquely identifies activity data for Document Case Report application.
UCM_REPORT_ID DOUBLE N Uniquely identifies the activity report for this field.
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_REPORT_FIELD


Child Column in UCM_REPORT_FIELD(FK) Parent Table Name Parent Column Name
Parents: OD_ORDER_ID ORDERS ORDER_ID
RESULT_ID RESULT RESULT_ID
UCMR_LAYOUT_FIELD_ID UCMR_LAYOUT_FIELD UCMR_LAYOUT_FIELD_ID
UCM_PTL_RESULT_ID UCM_PTL_RESULT UCM_PTL_RESULT_ID
UCM_REPORT_ID UCM_REPORT UCM_REPORT_ID




Parent Column in UCM_REPORT_FIELD (PK) Child Table Name Child Column Name
Children: UCM_REPORT_FIELD_ID UCM_KARYOTYPE UCM_REPORT_FIELD_ID
UCM_RPT_FIELD_IMAGE UCM_REPORT_FIELD_ID


UCM_REQUIRED_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Required Step
Definition: Identifies a prerequisite case step.
Table Type: ACTIVITY





Column Detail - UCM_REQUIRED_STEP


Column Name Type Null? Definition
REQUIRED_UCM_CASE_STEP_ID DOUBLE N Identifies the prerequisite case step.
UCM_CASE_STEP_ID DOUBLE N Identifies the related case step.
UCM_REQUIRED_STEP_ID DOUBLE N Uniquely identifies a prerequisite case step.
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_REQUIRED_STEP


Child Column in UCM_REQUIRED_STEP(FK) Parent Table Name Parent Column Name
Parents: REQUIRED_UCM_CASE_STEP_ID UCM_CASE_STEP UCM_CASE_STEP_ID
UCM_CASE_STEP_ID UCM_CASE_STEP UCM_CASE_STEP_ID


UCM_RPT_FIELD_IMAGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Report Field Image
Definition: Contains the images stored in a report field.
Table Type: ACTIVITY





Column Detail - UCM_RPT_FIELD_IMAGE


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.
IMAGE_IDENT VARCHAR(255) N Unique identifier for the image retrieved from CPDI.
IMAGE_SEQ DOUBLE N Represents the order in which the image is to be displayed for the given report field.
PAGE_NBR DOUBLE N Represents the page number when a document has multiple pages.
PREV_UCM_RPT_FIELD_IMAGE_ID DOUBLE N Used to track versions of the RPT_FIELD_IMAGE 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.
UCM_REPORT_FIELD_ID DOUBLE N Uniquely identifies the report field related to this row.
UCM_RPT_FIELD_IMAGE_ID DOUBLE N Uniquely identifies images stored in a given report field.
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_RPT_FIELD_IMAGE


Child Column in UCM_RPT_FIELD_IMAGE(FK) Parent Table Name Parent Column Name
Parents: UCM_REPORT_FIELD_ID UCM_REPORT_FIELD UCM_REPORT_FIELD_ID
PREV_UCM_RPT_FIELD_IMAGE_ID UCM_RPT_FIELD_IMAGE UCM_RPT_FIELD_IMAGE_ID




Parent Column in UCM_RPT_FIELD_IMAGE (PK) Child Table Name Child Column Name
Children: UCM_RPT_FIELD_IMAGE_ID UCM_RPT_FIELD_IMAGE PREV_UCM_RPT_FIELD_IMAGE_ID