Table Detail Report

DM_TRANSACTION_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM TRANSACTION ACTIVITY
Definition: One row per row affected by this transaction.
Table Type: ACTIVITY





Column Detail - DM_TRANSACTION_ACTIVITY


Column Name Type Null? Definition
ENTITY_NAME VARCHAR(32) Y This is the name of the entity being modified by this transaction.
TRANSACTION_ACTIVITY_ID DOUBLE N unique identifier for each row
TRANSACTION_ID DOUBLE N foreign key to dm_transactions.
TRANSACTION_TYPE VARCHAR(6) Y INSERT,SELECT,DELETE,UPDATE
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_TRANSACTION_ACTIVITY


Child Column in DM_TRANSACTION_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: TRANSACTION_ID DM_TRANSACTIONS TRANSACTION_ID




Parent Column in DM_TRANSACTION_ACTIVITY (PK) Child Table Name Child Column Name
Children: TRANSACTION_ACTIVITY_ID DM_TRANSACTION_DATA TRANSACTION_ACTIVITY_ID
DM_TRANSACTION_KEY TRANSACTION_ACTIVITY_ID


DM_TRANSACTION_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the data that was modified.
Definition: 1 row per field modified for each transactions
Table Type: ACTIVITY





Column Detail - DM_TRANSACTION_DATA


Column Name Type Null? Definition
FIELD_CHAR_VALUE VARCHAR(255) Y Contains the data value if field modified is VARCHAR, CHAR or VARCHAR2.
FIELD_DATE_VALUE DATETIME Y Contains the data value if field modified is DATE.
FIELD_LONGRAW_ID DOUBLE N Contains the id for the long raw data modified.
FIELD_LONG_ID DOUBLE N ID of LONG data field that was modified
FIELD_NAME VARCHAR(32) N The name of the column modified by this transaction
FIELD_NUM_VALUE DOUBLE Y The data value for the field modified by this transaction if the field is of type NUMBER or FLOAT.
TRANSACTION_ACTIVITY_ID DOUBLE N Parent record for this transaction.
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_TRANSACTION_DATA


Child Column in DM_TRANSACTION_DATA(FK) Parent Table Name Parent Column Name
Parents: TRANSACTION_ACTIVITY_ID DM_TRANSACTION_ACTIVITY TRANSACTION_ACTIVITY_ID


DM_TRANSACTION_KEY



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM TRANSACTION KEY
Definition: Primary key information for the row that was modified.
Table Type: ACTIVITY





Column Detail - DM_TRANSACTION_KEY


Column Name Type Null? Definition
FIELD_CHAR_VALUE VARCHAR(255) Y Data value for the primary key for the row being modified.
FIELD_DATE_VALUE DATETIME Y Data value for the primary key for the row being modified.
FIELD_NAME VARCHAR(32) N Column name for the primary key for the row being modified.
FIELD_NUM_VALUE DOUBLE Y Data value for the primary key for the row being modified.
TRANSACTION_ACTIVITY_ID DOUBLE N Parent record for this transaction.
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_TRANSACTION_KEY


Child Column in DM_TRANSACTION_KEY(FK) Parent Table Name Parent Column Name
Parents: TRANSACTION_ACTIVITY_ID DM_TRANSACTION_ACTIVITY TRANSACTION_ACTIVITY_ID


DM_USER_CONSTRAINTS



Column Section Top of Page


Table-level Detail

Description: DM USER CONSTRAINTS
Definition: Similar to the user constraints table
Table Type: ACTIVITY





Column Detail - DM_USER_CONSTRAINTS


Column Name Type Null? Definition
CONSTRAINT_NAME VARCHAR(30) N Name of the constraint
CONSTRAINT_TYPE VARCHAR(1) Y The type of the constraint definition
DELETE_RULE VARCHAR(9) Y The Delete rule for a referential constraint; CASCADE, NO ACTION
OWNER VARCHAR(30) N Owner of the constrained definition
R_CONSTRAINT_NAME VARCHAR(30) Y Name of unique constraint definition for referenced table
R_OWNER VARCHAR(30) Y Owner of table used in referential constraint
STATUS VARCHAR(8) Y Status of constraint: ENABLED,DISABLED
TABLE_NAME VARCHAR(30) N Name associated with table for constraint definition


DM_USER_CONS_COLUMNS



Column Section Top of Page


Table-level Detail

Description: Contains information from USER_CONSTRAINTS and USER_CONS_COLUMNS
Definition: Contains information from USER_CONSTRAINTS and USER_CONS_COLUMNS -- used in the refresh tools
Table Type: ACTIVITY





Column Detail - DM_USER_CONS_COLUMNS


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) Y column name
CONSTRAINT_NAME VARCHAR(30) Y constraint name
CONSTRAINT_TYPE CHAR(1) Y constraint type
OWNER VARCHAR(30) Y table owner (oracle)
PARENT_TABLE_NAME VARCHAR(30) Y parent table name for the constraint
POSITION DOUBLE Y position of the column in the constraint
R_CONSTRAINT_NAME VARCHAR(30) Y parent constraint name
R_OWNER VARCHAR(30) Y owner of the parent constraint
STATUS CHAR(8) Y constraint status
STATUS_IND DOUBLE Y status indicator
TABLE_NAME VARCHAR(30) Y TABLE NAME