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 |