Table Detail Report

UCM_CASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Case
Definition: This table stores high level case information.
Table Type: ACTIVITY





Column Detail - UCM_CASE


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N This field contains the date and time this record was created.
LOCKED_IND DOUBLE Y This field indicates if this case is locked by another user. Use the UPDT* fields to determine who and when the case was locked.
ORDER_ID DOUBLE N This field uniquely identifies the order that represents this case.
STATUS_ORDER_ID DOUBLE N Indicates order updated by UCM to help control the case order status.
UCMR_CASE_TYPE_ID DOUBLE N This field contains the unique Identifier for the case type version.
UCM_CASE_ID DOUBLE N This field contains the unique identifier for the case.
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_CASE


Child Column in UCM_CASE(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
STATUS_ORDER_ID ORDERS ORDER_ID
UCMR_CASE_TYPE_ID UCMR_CASE_TYPE UCMR_CASE_TYPE_ID




Parent Column in UCM_CASE (PK) Child Table Name Child Column Name
Children: UCM_CASE_ID UCM_CASE_FLAG UCM_CASE_ID
UCM_CASE_GROUP_PREQUAL UCM_CASE_ID
UCM_CASE_STEP UCM_CASE_ID
UCM_CHARGE_ORDER_R UCM_CASE_ID
UCM_PRSNL_ASSIGNMENT UCM_CASE_ID


UCM_CASE_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management - Case Event
Definition: This table stores events that occur to cases and case steps.
Table Type: ACTIVITY





Column Detail - UCM_CASE_EVENT


Column Name Type Null? Definition
EVENT_TYPE_CD DOUBLE N This field contains the code to describe the type of event.
RELATED_CASE_STEP_ID DOUBLE N Identifies the case step related to the ucm_case_step_id by way of event_type_cd.
UCM_CASE_EVENT_ID DOUBLE N This field uniquely identifies the case event.
UCM_CASE_STEP_ID DOUBLE N This field uniquely identifies the case step for this event. Note that not all events are also tied to a step. In those cases, this will be 0
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_CASE_EVENT


Child Column in UCM_CASE_EVENT(FK) Parent Table Name Parent Column Name
Parents: RELATED_CASE_STEP_ID UCM_CASE_STEP UCM_CASE_STEP_ID
UCM_CASE_STEP_ID UCM_CASE_STEP UCM_CASE_STEP_ID


UCM_CASE_FLAG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Case Flag
Definition: This table contains the relationships between a ucm_case and a code value on the Case Flag code set.
Table Type: ACTIVITY





Column Detail - UCM_CASE_FLAG


Column Name Type Null? Definition
CASE_FLAG_CD DOUBLE N Identifies the corresponding flag.
UCM_CASE_FLAG_ID DOUBLE N Uniquely identifies a relationshipbetween a ucm_case and a case flag code value.
UCM_CASE_ID DOUBLE N Uniquely identifies the corresponding case.
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_CASE_FLAG


Child Column in UCM_CASE_FLAG(FK) Parent Table Name Parent Column Name
Parents: UCM_CASE_ID UCM_CASE UCM_CASE_ID


UCM_CASE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Case Group
Definition: Contains case groups.
Table Type: ACTIVITY





Column Detail - UCM_CASE_GROUP


Column Name Type Null? Definition
CASE_GROUP_DESCRIPTION VARCHAR(100) N The description of the case group which may be different than reference.
CREATE_DT_TM DATETIME N Date and Time when the case group was created.
UCM_CASE_GROUP_ID DOUBLE N Uniquely identifies a case group.
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_CASE_GROUP




Parent Column in UCM_CASE_GROUP (PK) Child Table Name Child Column Name
Children: UCM_CASE_GROUP_ID UCM_CASE_GROUP_PREQUAL UCM_CASE_GROUP_ID


UCM_CASE_GROUP_PREQUAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Case Group Prequal
Definition: Contains case groups for which cases prequalify
Table Type: ACTIVITY





Column Detail - UCM_CASE_GROUP_PREQUAL


Column Name Type Null? Definition
EVALUATED_IND DOUBLE N Evaluated Indicator - true if the case has been evaluated for inclusion in real case group.
TRIGGER_UCM_CASE_ID DOUBLE N Case that triggered the initial formation of the prequalification rows. Generically describes what will route to the same unified case manager case group.
UCMR_CASE_GROUP_ID DOUBLE N Identifies the reference case group to which this case type prequlifies.
UCM_CASE_GROUP_ID DOUBLE N Identifies the case group related to this record.
UCM_CASE_GROUP_PREQUAL_ID DOUBLE N Uniquely identifies a case group for which a case is prequalified.
UCM_CASE_ID DOUBLE N Uniquely identifies the case related to this record.
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_CASE_GROUP_PREQUAL


Child Column in UCM_CASE_GROUP_PREQUAL(FK) Parent Table Name Parent Column Name
Parents: UCMR_CASE_GROUP_ID UCMR_CASE_GROUP UCMR_CASE_GROUP_ID
UCM_CASE_ID UCM_CASE UCM_CASE_ID
UCM_CASE_GROUP_ID UCM_CASE_GROUP UCM_CASE_GROUP_ID