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 |