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. |