Table Detail Report

DM_PK_WHERE



Column Section Top of Page


Table-level Detail

Description: Database Management PK_WHERE
Definition: Stores PK_WHERE forms to be used by RDDS for each table
Table Type: REFERENCE





Column Detail - DM_PK_WHERE


Column Name Type Null? Definition
DELETE_IND DOUBLE N Indicates if template is for Delete PK_WHERE
MERGE_DELETE_IND DOUBLE N Indicates if template is for Merge Delete Table
PK_WHERE VARCHAR(4000) Y Holds PK_WHERE
PK_WHERE_FUNCTION_IND DOUBLE N Indicates whether template column holds function call
PK_WHERE_HASH DOUBLE N Holds Hash value of PK_WHERE
PTAM_MATCH_FUNCTION_IND DOUBLE N Indicates whether template column holds function call
PTAM_MATCH_HASH DOUBLE N Holds PTAM Match Query Hash value
PTAM_MATCH_QUERY VARCHAR(4000) Y Holds PTAM Match Query
TABLE_NAME VARCHAR(30) N Holds table name that uses template
TEMPLATE_ID DOUBLE N Identifier assigned internally for PK_WHERE form
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.
VERSION_ALG VARCHAR(12) Y Indicates type of versioning template
VERSION_IND DOUBLE N Indicates if template is for versioning table


DM_PK_WHERE_LOCAL



Column Section Top of Page


Table-level Detail

Description: Database Management PK where Local
Definition: Stores templates of PK_WHERE forms to be used by RDDS for each table locally
Table Type: REFERENCE





Column Detail - DM_PK_WHERE_LOCAL


Column Name Type Null? Definition
DELETE_IND DOUBLE N Indicates if template is for Delete PK_WHERE
MERGE_DELETE_IND DOUBLE N Indicates if template is for Merge Delete Table
PK_WHERE_FUNCTION_IND DOUBLE N Indicates whether template column holds function call
PK_WHERE_PARM_QUERY VARCHAR(500) Y Holds query used to get parameters for PK_WHERE template
PK_WHERE_TEMPLATE VARCHAR(2000) N Holds PK_WHERE Template
PK_WHERE_WHERE_QUERY VARCHAR(500) Y Holds Query used to create PK_WHERE template
PTAM_MATCH_FUNCTION_IND DOUBLE N Indicates whether template column holds function call
PTAM_MATCH_PARM_QUERY VARCHAR(500) Y Holds query used to get parameters for PTAM Match template
PTAM_MATCH_TEMPLATE VARCHAR(2000) N Holds PTAM Match Template
PTAM_MATCH_WHERE_QUERY VARCHAR(500) Y Holds query used to get PTAM Match template
TABLE_NAME VARCHAR(30) N Holds table name that uses template
TEMPLATE_ID DOUBLE N Identifier assigned internally of PK_WHERE form
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.
VERSION_ALG VARCHAR(12) Y Indicates type of versioning template
VERSION_IND DOUBLE N Indicates if template is for versioning table


DM_PK_WHERE_PARM



Column Section Top of Page


Table-level Detail

Description: Database Management PK_WHERE Parameters
Definition: Stores PK_WHERE parameters to be used by RDDS for each table
Table Type: REFERENCE





Column Detail - DM_PK_WHERE_PARM


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N Column name of parameter
DATA_TYPE VARCHAR(20) N Holds data type of column
DELETE_IND DOUBLE N Indicates if parameters are for delete or not
EXIST_IND DOUBLE N Indicates if column should exist in PTAM_MATCH_RESULT
FUNCTION_TYPE VARCHAR(20) N Differentiates if parameters are for PK_WHERE or PTAM_MATCH
PARM_NBR DOUBLE N Orders parameters
TABLE_NAME VARCHAR(30) N Holds table name that uses template
TRANS_IND DOUBLE N Indicates if column is translatable
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_PLAN



Column Section Top of Page


Table-level Detail

Description: DM PLAN
Definition: Holds the oracle plans for all request objects
Table Type: ACTIVITY





Column Detail - DM_PLAN


Column Name Type Null? Definition
ID DOUBLE N Identification number for this step in the execution plan
OBJECT_INSTANCE DOUBLE Y Numbered position of the object name in the original SQL statement
OBJECT_NAME VARCHAR(30) Y Name of the object
OBJECT_NODE VARCHAR(128) Y Name of the database link used to reference the object
OBJECT_OWNER VARCHAR(30) Y Owner of the object
OBJECT_TYPE VARCHAR(30) Y Descriptive modifier that further describes the type of the object
OPERATION VARCHAR(30) Y Name of the operation performed at this step
OPTIONS VARCHAR(30) Y Options used for the operation performed at this step
PARENT_ID DOUBLE Y ID of the next step that operates on the results of this step
POSITION DOUBLE Y Order of processing for steps with the same parent ID. For cost-based optimization, the value in the first row of the plan is the statement's execution cost. For rule-based optimization, the value is null in the first row
REMARKS VARCHAR(80) Y Place for comments that can be added to the steps of the execution plan
SCHEMA_DATE DATETIME N Rev date from DM_SCHEMA_VERSION
SCRIPT_NAME VARCHAR(80) N The script name of the object that the oracle plan was generated for
SEARCH_COLUMNS DOUBLE Y Not currently used
SQL_STMT_ID DOUBLE N unique number generated in order to make the row unique, holds the sequence of steps of the SQL query
STATEMENT_ID VARCHAR(100) N Optional statement identifier specified in the EXPLAIN PLAN statement
STMT LONGTEXT Y Contains the entire SQL query text that is sent to ORACLE
TIMESTAMP DATETIME Y Date and time that the EXPLAIN PLAN statement was used


DM_PREFS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM PREFS
Definition: This table is used to store user rows and user preferences
Table Type: REFERENCE





Column Detail - DM_PREFS


Column Name Type Null? Definition
APPLICATION_NBR DOUBLE N The number of the application with the init parameters in this row.
PARENT_ENTITY_ID DOUBLE N Used to store the identifier for the parent
PARENT_ENTITY_NAME VARCHAR(32) Y Used to store the name for the parent
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PREF_CD DOUBLE N Used to store the value part of the name value pair when the value portion is code value from the code set
PREF_DOMAIN VARCHAR(255) N The domain for the name value pair.
PREF_DT_TM DATETIME Y Used to store the value part of the name value pair when the value portion is a date.
PREF_ID DOUBLE N To uniquely define a row in the table
PREF_NAME VARCHAR(255) N The name portion of the name value pair
PREF_NBR DOUBLE Y Used to store the value part of the name value pair when the value portion is a number.
PREF_SECTION VARCHAR(255) N The section for the name value pair.
PREF_STR VARCHAR(255) Y Used to store the value part of the name value pair when the value portion is a character string.
REFERENCE_IND DOUBLE Y Specifies if this is row is reference = 1 or activity = 0
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_PREFS


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