Table Detail Report

DM_DCM_UOW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Change Management Unit of Work
Definition: A table to hold the units of work of a work plan for the change management solution
Table Type: ACTIVITY





Column Detail - DM_DCM_UOW


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE Y References the application that performed the unit of work
DATA_DETAIL VARCHAR(4000) Y Detail of data generated by this unit of work
DESCRIPTION VARCHAR(100) Y Holds a description of the workflow being performed
DM_DCM_UOW_ID DOUBLE N PRIMARY KEY
DM_DCM_WORK_PLAN_ID DOUBLE N Data Change Management Work Plan identifier
PRODUCT_STRING VARCHAR(150) Y String value to represent the product id string from a Java RCP application
PRSNL_ID DOUBLE N References the personnel account that performed the unit of work
START_DT_TM DATETIME Y The time the unit of work started
STOP_DT_TM DATETIME Y The time the unit of work stopped
UOW_GUID VARCHAR(50) N Holds a globally unique value
UOW_PARENT_GUID VARCHAR(50) Y Holds the globally unique value of the parent workflow
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 - DM_DCM_UOW


Child Column in DM_DCM_UOW(FK) Parent Table Name Parent Column Name
Parents: DM_DCM_WORK_PLAN_ID DM_DCM_WORK_PLAN DM_DCM_WORK_PLAN_ID
PRSNL_ID PRSNL PERSON_ID


DM_DCM_UOW_LOG



Column Section Top of Page


Table-level Detail

Description: Data Change Management Unit of Work Log
Definition: A table to hold details of the units of work of a work plan for the change management process
Table Type: ACTIVITY





Column Detail - DM_DCM_UOW_LOG


Column Name Type Null? Definition
DELETE_CNT DOUBLE N Indicates the number of times a unit of work performed a delete
DM_DCM_UOW_LOG_ID DOUBLE N PRIMARY KEY
FIRST_DML_DT_TM DATETIME N The Date/Time the first DML occurred for a given table and UOW_GUID
INSERT_CNT DOUBLE N Indicates the number of times a unit of work performed an insert
LAST_DML_DT_TM DATETIME N The Date/Time the last DML occurred for a given table and UOW_GUID
TABLE_NAME VARCHAR(30) N Holds table name that was altered by unit of work
UOW_GUID VARCHAR(50) N Holds a globally unique value
UPDATE_CNT DOUBLE N Indicates the number of times a unit of work performed an update
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.


DM_DCM_WORK_PLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Change Management Work Plan
Definition: A table to track work plan items for the change management solution
Table Type: ACTIVITY





Column Detail - DM_DCM_WORK_PLAN


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.
ADHOC_FLAG DOUBLE N 0 - Work plan added manually, 1 - User added work plan on the fly, 2 - Application added work plan on the fly
DM_DCM_WORK_PLAN_ID DOUBLE N PRIMARY KEY
EXTERNAL_IDENT VARCHAR(50) Y Identifier from data being imported from external system
NOTE_REQUIRED_IND DOUBLE N Indicates if the user is forced to fill out comments when selecting a work plan
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.
WORK_PLAN_NAME VARCHAR(100) N A column to hold a name or summary of the work plan
WORK_PLAN_TEXT_ID DOUBLE N Points to the LONG_TEXT table for work plan details



Relationship Detail - DM_DCM_WORK_PLAN


Child Column in DM_DCM_WORK_PLAN(FK) Parent Table Name Parent Column Name
Parents: WORK_PLAN_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in DM_DCM_WORK_PLAN (PK) Child Table Name Child Column Name
Children: DM_DCM_WORK_PLAN_ID DM_DCM_UOW DM_DCM_WORK_PLAN_ID
DM_DCM_WP_LOG DM_DCM_WORK_PLAN_ID
DM_DCM_WP_PRSNL_R DM_DCM_WORK_PLAN_ID
DM_DCM_WP_STATUS_HIST DM_DCM_WORK_PLAN_ID


DM_DCM_WP_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Change Management Work Plan Log
Definition: A table to old notes about a work plan for the change management solution
Table Type: ACTIVITY





Column Detail - DM_DCM_WP_LOG


Column Name Type Null? Definition
DM_DCM_WORK_PLAN_ID DOUBLE N Points to the DM_DCM_WORK_PLAN table
DM_DCM_WP_LOG_ID DOUBLE N PRIMARY KEY
LOG_DESCRIPTION VARCHAR(50) Y Holds a description of the type of information in LOG_TEXT
LOG_TEXT VARCHAR(4000) Y Holds the text user chose to store
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 - DM_DCM_WP_LOG


Child Column in DM_DCM_WP_LOG(FK) Parent Table Name Parent Column Name
Parents: DM_DCM_WORK_PLAN_ID DM_DCM_WORK_PLAN DM_DCM_WORK_PLAN_ID


DM_DCM_WP_PRSNL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Change Management Work Plan Personnel Relation
Definition: A table to indicate the rsnl that can work on a work plan for the change management process.
Table Type: ACTIVITY





Column Detail - DM_DCM_WP_PRSNL_R


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.
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.
DM_DCM_WORK_PLAN_ID DOUBLE N Points to the DM_DCM_WORK_PLAN table
DM_DCM_WP_PRSNL_R_ID DOUBLE N PRIMARY KEY
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.
PRSNL_ID DOUBLE N Points to the PRSNL that can work on the work plan
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 - DM_DCM_WP_PRSNL_R


Child Column in DM_DCM_WP_PRSNL_R(FK) Parent Table Name Parent Column Name
Parents: DM_DCM_WORK_PLAN_ID DM_DCM_WORK_PLAN DM_DCM_WORK_PLAN_ID
PRSNL_ID PRSNL PERSON_ID