Table Detail Report

DM_PROPERTY_SET_CTL



Column Section Top of Page


Table-level Detail

Description: Data Management Property Set Control
Definition: Table is used to indicate that any type of change has occurred in DM_PROPERTY_SET, DM_OVERIDE_PROPETIES, or DM_MODEL_PROPERTIES. This table is watched by any code that has cached properties so that they know when to refresh them. This table should be updated in the same transaction as the properties being updated to ensure consistency.
Table Type: REFERENCE





Column Detail - DM_PROPERTY_SET_CTL


Column Name Type Null? Definition
REQUESTER_NAME VARCHAR(64) Y Free text field that holds the name of the last requestor, if known.
REQUESTER_REASON VARCHAR(256) Y Free text field that holds the reason for the last requested cache refresh.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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.


DM_REFCHG_ATTRIBUTE



Column Section Top of Page


Table-level Detail

Description: DM_REFCHG_ATTRIBUTE
Definition: This table will store additional metadata for reference tables that will be used by RDDS
Table Type: REFERENCE





Column Detail - DM_REFCHG_ATTRIBUTE


Column Name Type Null? Definition
ATTRIBUTE_CHAR VARCHAR(2000) Y Contains value of character attributes
ATTRIBUTE_DT_TM DATETIME Y Contains value of date attributes
ATTRIBUTE_NAME VARCHAR(50) N Contains meta-data attribute
ATTRIBUTE_VALUE DOUBLE Y Contains value of numeric attributes
COLUMN_NAME VARCHAR(30) Y Column name the attribute is associated with
DM_REFCHG_ATTRIBUTE_ID DOUBLE N Primary Key for table
TABLE_NAME VARCHAR(30) N Table name the attribute is associated with
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_COMP_GTTD



Column Section Top of Page


Table-level Detail

Description: Database Architecture Reference Comparison Global Temp Table
Definition: Holds information used in reporting the differences between the RDDS temporary tables and LIVE tables
Table Type: ACTIVITY





Column Detail - DM_REFCHG_COMP_GTTD


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) Y Holds Column name of report data
L_COLUMN_VALUE VARCHAR(4000) Y Holds the Live Table/Column value of report data
R_COLUMN_VALUE VARCHAR(4000) Y Holds the $R Table/Column value of report data
R_PTAM_HASH_VALUE DOUBLE Y Holds the RDDS_PTAM_HASH_VALUE from the $R table for the row being audited
R_ROWID VARCHAR(18) Y Holds the ROWID from the $R table that is being audited
STATUS VARCHAR(10) Y Holds the status of the row
TABLE_NAME VARCHAR(30) Y Holds Table name of report data


DM_REFCHG_DML



Column Section Top of Page


Table-level Detail

Description: Data Management Reference Change DML
Definition: Data management reference change DML cutover overrides to use when cutting over in RDDS.
Table Type: REFERENCE





Column Detail - DM_REFCHG_DML


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N Contains the name of the column (if applicable) needing the override.
DATA_TYPE VARCHAR(30) N Contains the data type of the attribute. Valid values are Char, Number, or Date.
DML_ATTRIBUTE VARCHAR(100) N Contains the attribute to override. For example: upd_val_str, versioning_ind, etc.
DML_VALUE VARCHAR(255) N The value to which the attribute is to be set.
TABLE_NAME VARCHAR(30) N Name of the table needing the override.
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_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management reference change filter
Definition: Stores the tables which need special filtering of rows in RDDS.
Table Type: REFERENCE





Column Detail - DM_REFCHG_FILTER


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.
FILTER_TYPE VARCHAR(30) N Type of filtering done - INCLUDE values, EXCLUDE values, or NONE - only a statement exists
FILTER_VERSION_NBR DOUBLE Y A column to hold the version number of the resulting filter object
STATEMENT_IND DOUBLE N Indicates whether a statement (usually a Select) is used as part of the filtering.
TABLE_NAME VARCHAR(30) N Name of the table which has a filter requirement on it.
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_FILTER




Parent Column in DM_REFCHG_FILTER (PK) Child Table Name Child Column Name
Children: TABLE_NAME DM_REFCHG_FILTER_PARM TABLE_NAME
DM_REFCHG_FILTER_TEST TABLE_NAME