Table Detail Report

DM_PROCESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data management process list table
Definition: List of Data Management Processes
Table Type: REFERENCE





Column Detail - DM_PROCESS


Column Name Type Null? Definition
ACTION_TYPE VARCHAR(255) N The type of action being performed in this process by this program.
DM_PROCESS_ID DOUBLE N PRIMARY KEY
PROCESS_NAME VARCHAR(255) N Name of the process being executed
PROGRAM_NAME VARCHAR(255) N The name of the program being run
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_PROCESS




Parent Column in DM_PROCESS (PK) Child Table Name Child Column Name
Children: DM_PROCESS_ID DM_PROCESS_EVENT DM_PROCESS_ID


DM_PROCESS_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management process LOG table
Definition: Log of events
Table Type: ACTIVITY





Column Detail - DM_PROCESS_EVENT


Column Name Type Null? Definition
BEGIN_DT_TM DATETIME N The time that the event began
DM_PROCESS_EVENT_ID DOUBLE N PRIMARY KEY
DM_PROCESS_ID DOUBLE N Foreign key to DM_PROCESS table
END_DT_TM DATETIME Y The time the event ended.
EVENT_STATUS VARCHAR(30) Y The status of the event.
INSTALL_PLAN_ID DOUBLE N This represents the Install_Plan_ID value from Admin table dm_install_plan that this row relates to. A value of 0 means it doesn't relate to an Install_Plan_Id value.
MESSAGE_TXT VARCHAR(2000) Y Error or warning message.
PROGRAM_DETAILS VARCHAR(255) N The parameters/Arguments the program was called with.
PROGRAM_STACK VARCHAR(1000) N The stack of programs which are executing at row log time.
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.
USERNAME VARCHAR(30) Y User executing the command



Relationship Detail - DM_PROCESS_EVENT


Child Column in DM_PROCESS_EVENT(FK) Parent Table Name Parent Column Name
Parents: DM_PROCESS_ID DM_PROCESS DM_PROCESS_ID




Parent Column in DM_PROCESS_EVENT (PK) Child Table Name Child Column Name
Children: DM_PROCESS_EVENT_ID DM_PROCESS_EVENT_DTL DM_PROCESS_EVENT_ID


DM_PROCESS_EVENT_DTL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management process logging details
Definition: Log of details for given events
Table Type: ACTIVITY





Column Detail - DM_PROCESS_EVENT_DTL


Column Name Type Null? Definition
DETAIL_DT_TM DATETIME Y Date Value for Detail_Type
DETAIL_NUMBER DOUBLE N Generic number storage
DETAIL_TEXT VARCHAR(2000) Y Generic text storage
DETAIL_TYPE VARCHAR(30) N What is stored in this detail row
DM_PROCESS_EVENT_DTL_ID DOUBLE N PRIMARY KEY
DM_PROCESS_EVENT_ID DOUBLE N Foreign key to DM_PROCESS_EVENT table
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_PROCESS_EVENT_DTL


Child Column in DM_PROCESS_EVENT_DTL(FK) Parent Table Name Parent Column Name
Parents: DM_PROCESS_EVENT_ID DM_PROCESS_EVENT DM_PROCESS_EVENT_ID


DM_PROCESS_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management Operations Queue
Definition: Commands that need to execute
Table Type: ACTIVITY





Column Detail - DM_PROCESS_QUEUE


Column Name Type Null? Definition
AUDSID VARCHAR(255) Y Unique Identifier for the executing oracle session.
BEGIN_DT_TM DATETIME Y Time the command began executing
DM_PROCESS_QUEUE_ID DOUBLE N PRIMARY KEY
END_DT_TM DATETIME Y Time the command finished executing
GEN_DT_TM DATETIME Y Time the command was generated
MESSAGE_TXT VARCHAR(4000) Y Error or warning message
OBJECT_NAME VARCHAR(30) N Name of the object
OBJECT_TYPE VARCHAR(30) N The type of object
OPERATION_TXT VARCHAR(255) Y Command to be run
OP_METHOD VARCHAR(30) Y How the command will be run
OP_TYPE VARCHAR(255) N The type of operation
OWNER_NAME VARCHAR(30) N The owner of the object
PRIORITY DOUBLE Y The numerical priority of the command
PROCESS_STATUS VARCHAR(30) Y Status of the process
PROCESS_TYPE VARCHAR(255) N The parent process
ROUTINE_TASKS_IND DOUBLE N Indicates that job should only be performed by DM2_ROUTINE_TASKS runner
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_PROCESS_QUEUE




Parent Column in DM_PROCESS_QUEUE (PK) Child Table Name Child Column Name
Children: DM_PROCESS_QUEUE_ID DM_ADS_CONFIG_EXTRACT DM_PROCESS_QUEUE_ID


DM_PROPERTY_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management Property Set
Definition: Used to describe and scope a list of like properties used to configure the system. This table is populated with model data only. A prefix using dotted notation should be used to group like property sets. For example WebServices.Configuration. prefix would group all like webservice configuration.
Table Type: REFERENCE





Column Detail - DM_PROPERTY_SET


Column Name Type Null? Definition
PROPERTY_SET_DESC VARCHAR(256) N Describes the collection of properties.
PROPERTY_SET_NAME VARCHAR(64) N Dotted notation name used to group like configuration.
TTL_SECS DOUBLE N In seconds, how often this property set should be checked for change. -1 means never check, 0 means not to cache the properties associated with the set, minimum value greater than 0 is 60 seconds.
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 Y 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.



Relationship Detail - DM_PROPERTY_SET




Parent Column in DM_PROPERTY_SET (PK) Child Table Name Child Column Name
Children: PROPERTY_SET_NAME DM_MODEL_PROPERTIES PROPERTY_SET_NAME