Table Detail Report
DM_REFCHG_SQL_OBJ_PARM
Column Section | Top of Page |
Table-level Detail
Description: | Dm_refchg_sql_obj_parm |
Definition: | PL/SQL object parameter names needed for RDDS objects |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_SQL_OBJ_PARM
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. |
COLUMN_NAME | VARCHAR(30) | N | Name of column that needs to be passed into the object |
DM_REFCHG_SQL_OBJ_PARM_ID | DOUBLE | N | PRIMARY KEY |
OBJECT_NAME | VARCHAR(40) | N | Name of PL/SQL object |
PARM_NBR | DOUBLE | N | Order that this parameter should be used when calling the object |
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_REFCHG_SQL_OBJ_TEXT
Column Section | Top of Page |
Table-level Detail
Description: | Dm_refchg_sql_obj_text |
Definition: | PL/SQL object creation statements needed for RDDS objects |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_SQL_OBJ_TEXT
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. |
DM_REFCHG_SQL_OBJ_TEXT_ID | DOUBLE | N | PRIMARY KEY |
LINE_NUMBER | DOUBLE | N | Order of text for the object |
OBJECT_NAME | VARCHAR(40) | N | Name of PL/SQL object |
SQL_TEXT | VARCHAR(255) | N | Object text |
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_REFCHG_STAT
Column Section | Top of Page |
Table-level Detail
Description: | Data management reference change statistics |
Definition: | Statistics for RDDS data moves |
Table Type: | ACTIVITY |
Column Detail - DM_REFCHG_STAT
Column Name | Type | Null? | Definition |
---|---|---|---|
CUR_STMT_DT_TM | DATETIME | Y | Date/time that the current statement started. |
CUR_STMT_NBR | DOUBLE | Y | Current statement being run |
DEL_ROW_CNT | DOUBLE | N | count of Number of rows deleted |
DM_REFCHG_STAT_ID | DOUBLE | N | Unique identifier |
INS_ROW_CNT | DOUBLE | N | Count of Number of rows inserted |
MRG_ROW_CNT | DOUBLE | N | Count of Number of rows merged |
ROWS_TO_PROCESS | DOUBLE | Y | Number of rows on the table_name that needed to be processed when this row was first inserted. This value is not updated. |
SOURCE_ENV_ID | DOUBLE | N | Environment id being moved in. (the dm_environment.environment_id in the Admin database) |
STAT_TYPE | VARCHAR(50) | N | Type of warning - e.g. CUTOVER, MOVER |
STMT_CNT | DOUBLE | N | Number of DML statements needed to process this table |
TABLE_NAME | VARCHAR(30) | Y | Name of the table that the statistic is related to. |
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. |
UPD_ROW_CNT | DOUBLE | N | Count of Number of rows updated |
DM_REFCHG_TAB_R
Column Section | Top of Page |
Table-level Detail
Description: | Data management reference change table relationship |
Definition: | Holds the list of tables that must be commit together when transferring reference data via RDDS. Tables are related via parent/child relationships and can be chained together to create a tree structure with a single root parent. |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_TAB_R
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_TABLE | VARCHAR(30) | N | Table which must have it's rows committed in the target environment at the same time as the parent table. |
DM_REFCHG_TAB_R_ID | DOUBLE | N | DM reference change table relationship id. Sequence generated primary key |
MD_VALUE_STR | VARCHAR(500) | Y | PL/SQL string to create the values needed for the merge delete unique identifier. |
MD_VAR_STR | VARCHAR(500) | Y | List of variables that the md_value_str will select into - e.g. select |
PARENT_ID_COL | VARCHAR(30) | N | Name of the column on the child table that holds the primary key ID of the parent_table. |
PARENT_R_COL | VARCHAR(30) | Y | The column name on the parent table that the parent_id_col points to. This is needed for reverse relationships. |
PARENT_TABLE | VARCHAR(30) | N | Parent of a table in RDDS that must have its rows committed in the target environment at the same time as the child table. |
PARENT_TAB_COL | VARCHAR(30) | Y | Name of the column on the child table that holds the name of the parent_table. If this is not filled out then the parent_table is always 'parent_table'. |
PK_WHERE | VARCHAR(2000) | N | Procedure code needed to generate a pk_where clause to be placed in dm_chg_log. |
PROCESS_SEQ | DOUBLE | N | Used by the RDDS mover to determine what order to move children tables. The lowest values are processed first. |
PROCESS_TYPE | VARCHAR(30) | Y | process type column |
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_REFCHG_TASK_QUEUE
Column Section | Top of Page |
Table-level Detail
Description: | Database Architecture Refchg Task Queue |
Definition: | Stores a queue of tasks to be completed for a variety of RDDS processes |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_TASK_QUEUE
Column Name | Type | Null? | Definition |
---|---|---|---|
BEGIN_DT_TM | DATETIME | Y | Shows the time the task was started |
CREATE_DT_TM | DATETIME | Y | Shows the time the task was added to the table |
DM_REFCHG_TASK_QUEUE_ID | DOUBLE | N | Primary Key for table |
END_DT_TM | DATETIME | Y | Shows the time the task was completed |
ERROR_TEXT | VARCHAR(250) | Y | Shows any error message that might've occurred. |
LOG_FILE | VARCHAR(80) | Y | Holds the log file name of the session that's running the task. |
PROCESS_NAME | VARCHAR(30) | N | Holds a description about what process the task belongs to |
RDBHANDLE_VALUE | DOUBLE | Y | Shows the process identifier to the session that is running a given task |
TASK_DESC | VARCHAR(50) | N | Holds the script name that should be executed as part of this task |
TASK_LEVEL | DOUBLE | N | Holds the priority level of when the task should be processed |
TASK_NAME | VARCHAR(2000) | N | Holds a description of the task |
TASK_REPLY | VARCHAR(2000) | N | Holds information used to verify task was a success |
TASK_REQUEST | VARCHAR(2000) | N | Holds information used to call the task |
TASK_RETRY_CNT | DOUBLE | N | Task retry count |
TASK_STATUS | VARCHAR(30) | N | Holds the status of each task (READY, RUNNING, SUCCESS, ERROR, etc.) |
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. |