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 |