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 into from dual. These variables will be used the pk_where.
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.