Table Detail Report

DM_REFCHG_PRSNL_CTX_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM Reference Change Prsnl/Context Relationship
Definition: Maps Users (PRSNL_ID) to the context_name(s) that should be set in DM_CHG_LOG
Table Type: REFERENCE





Column Detail - DM_REFCHG_PRSNL_CTX_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.
CONTEXT_NAME VARCHAR(255) N Context(s) to set in the dm_chg_log trigger for this prsnl_id. If multiple are needed they must be separated by :: such as C1::C2::C3
DM_REFCHG_PRSNL_CTX_R_ID DOUBLE N Unique identifier
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 Personnel to be mapped to a context
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_REFCHG_PRSNL_CTX_R


Child Column in DM_REFCHG_PRSNL_CTX_R(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


DM_REFCHG_RTABLE_RESET



Column Section Top of Page


Table-level Detail

Description: Database Architecture Refchg $R Table Reset
Definition: Stores row level information about rows in the $R tables that need to be reset.
Table Type: REFERENCE





Column Detail - DM_REFCHG_RTABLE_RESET


Column Name Type Null? Definition
BLOCK_STMT VARCHAR(4000) N Holds a WHERE clause statement that will identify the rows in the LIVE table that were created with dual build.
DM_REFCHG_RTABLE_RESET_ID DOUBLE N Primary Key for table
PK_WHERE VARCHAR(2000) N Holds a string in the form of a WHERE clause that contains the columns that can locate the problematic rows on the $R tables.
RESET_STATUS VARCHAR(20) N Specifies the status that the current row is in
TABLE_NAME VARCHAR(30) N Holds the table name where a dual build occurred
TRIG_TYPE_FLAG DOUBLE N Indicates the type of triggers that identified the dual build problem. 1 - REG_MC trigger violations that block rows based on a unique constraint. This should be used even if it also qualifies as a type 2 (MUI column violation). 2 - REG_MC trigger violations that block rows based on MUI columns. If the MUI columns are supported by a unique constraints, implying that it could be both 1 and 2, it should be labeled as type 1 3 - REG_MD_MC trigger violations are type 3 4 - New REG_V
TRIG_TYPE_INFO VARCHAR(30) Y Holds additional information about the trigger that identified the problem (i.e. index name)
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_SOFT_CONSTRAINTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Management Reference Change Soft Constraints
Definition: This table will store soft constraint information for use within the RDDS dual build detection logic.
Table Type: REFERENCE





Column Detail - DM_REFCHG_SOFT_CONSTRAINTS


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.
BLOCK_WHERE_CLAUSE VARCHAR(2000) Y This will be used to store a CCL version of the where clause already stored in the WHERE_CLAUSE column.
CONSTRAINT_NAME VARCHAR(30) N The name of the soft constraint
DM_REFCHG_SOFT_CONSTRAINTS_ID DOUBLE N Primary Key for table
RESET_STATUS VARCHAR(20) Y Status to assign to rows that violate this constraint.
TABLE_NAME VARCHAR(30) N The table name to apply this constraint to
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.
WHERE_CLAUSE VARCHAR(2000) Y Additional functional constraints to account for (i.e. ¿where cons.active_ind = 1 AND cons.column_name is NULL¿)



Relationship Detail - DM_REFCHG_SOFT_CONSTRAINTS




Parent Column in DM_REFCHG_SOFT_CONSTRAINTS (PK) Child Table Name Child Column Name
Children: DM_REFCHG_SOFT_CONSTRAINTS_ID DM_REFCHG_SOFT_CONS_COLUMNS DM_REFCHG_SOFT_CONSTRAINTS_ID


DM_REFCHG_SOFT_CONS_COLUMNS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Management Reference Change Soft Constraints Columns
Definition: This table will store soft constraint column information for use within the RDDS dual build detection logic.
Table Type: REFERENCE





Column Detail - DM_REFCHG_SOFT_CONS_COLUMNS


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N Name of the Column for which the soft constraint applies
DM_REFCHG_SOFT_CONSTRAINTS_ID DOUBLE N Foreign Key to parent table DM_REFCHG_SOFT_CONSTRAINTS
DM_REFCHG_SOFT_CONS_COLUMNS_ID DOUBLE N Primary Key for table
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 - DM_REFCHG_SOFT_CONS_COLUMNS


Child Column in DM_REFCHG_SOFT_CONS_COLUMNS(FK) Parent Table Name Parent Column Name
Parents: DM_REFCHG_SOFT_CONSTRAINTS_ID DM_REFCHG_SOFT_CONSTRAINTS DM_REFCHG_SOFT_CONSTRAINTS_ID


DM_REFCHG_SQL_OBJ



Column Section Top of Page


Table-level Detail

Description: Dm_refchg_sql_obj
Definition: PL/SQL objects needed for RDDS. Will be loaded via a CSV import process. Will not merge.
Table Type: REFERENCE





Column Detail - DM_REFCHG_SQL_OBJ


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.
CCL_DATA_TYPE VARCHAR(10) Y Used to declare function return data types in CCL
COLUMN_NAME VARCHAR(30) Y Filled out if this object is used for custom translations. It tells whether which column it is used for.
CREATION_LEVEL DOUBLE N Order which object should be created in compared to other objects to be created.
DM_REFCHG_SQL_OBJ_ID DOUBLE N PRIMARY KEY
EXECUTION_FLAG DOUBLE N 1 - If the column being translated is an MUI column use this execution flag 2 - Columns that are not in the MUI and are not the PK should use this execution flag 3 - If the column being translated is the Primary Key, use this execution flag. 4 - Special execution flag for DCP tables. Used for top level columns that are not the PK column. The top level column and PK column are never equal to each other. 5 - Special execution flag for MED. Used as a soft FK in conjuction with another column
OBJECT_NAME VARCHAR(40) N Name of PL/SQL object
OBJECT_TYPE VARCHAR(30) N Type of PL/SQL object - e.g. FUNCTION, PROCEDURE, etc.
TABLE_NAME VARCHAR(30) Y Filled out if this object is used for custom translations. It tells whether which table it is used for.
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.