Last modified: 06 March 2025
Database Tables
Entity-relationship diagram
Table descriptions
PDR_MONITOR_LATEST_DATA_CNF
The PDR_MONITOR_LATEST_DATA_CNF table contains the configuration of business cycles and end-to-end delivery SLA for specific data model tables.
The primary source of data for this table is SQL (for manual updates).
Primary Key
- DATA_MODEL_TABLE
Table 8 PDR_MONITOR_LATEST_DATA_CNF contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
DATA_MODEL_TABLE |
Varchar2 |
40 |
The data model table to query |
|
COLUMN_NAME |
Varchar2 |
30 |
The column to query in this table, should be of type DATE |
|
DESCRIPTION |
Varchar2 |
60 |
The description of this configuration |
|
BUSINESS_CYCLE_MINS |
Integer |
|
The business cycle for this process in minutes |
|
IS_ACTIVE |
Integer |
|
1 if the configuration is active, 0 otherwise |
|
DISPLAY_PRIORITY |
Integer |
|
The display order for this configuration |
PDR_MONITOR_LOG_MESSAGES
The PDR_MONITOR_LOG_MESSAGES table contains log messages from Data Interchange applications.
This table is populated by the pdrMonitor as log details are retrieved from Data Interchange applications.
Index
- PDR_MONITOR_ID
- TRANSACTION_ID
- EVENT_DATE
- PDR_MONITOR_ID
Table 9 PDR_MONITOR_LOG_MESSAGES contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
PDR_MONITOR_ID |
Integer |
|
The monitor collector identifier |
|
TRANSACTION_ID |
Varchar2 |
40 |
Unique transaction identifier |
|
EVENT_DATE |
Date |
|
The event date time of this log message |
|
THREAD_ID |
Varchar2 |
50 |
The application thread that logged this event |
|
LOG_LEVEL |
Varchar2 |
10 |
The logging level for this message. Valid entries are ERROR and WARNING |
|
LOG_MESSAGE |
Varchar2 |
1000 |
The Log message associated with this record |
PDR_MONITOR_PERFORMANCE
The PDR_MONITOR_PERFORMANCE table contains performance data from Data Interchange applications.
This table is populated by the pdrMonitor as performance details are retrieved from Data Interchange applications.
Index
- PDR_MONITOR_ID
- TRANSACTION_ID
- PDR_MONITOR_ID
- START_DATE
- END_DATE
- PDR_MONITOR_ID
- INTERVAL_END_DATE
- FILE_ID
- PDR_MONITOR_ID
- FILE_NAME
Table 10 PDR_MONITOR_PERFORMANCE contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
PDR_MONITOR_ID |
Integer |
|
The monitor collector identifier |
|
TRANSACTION_ID |
Varchar2 |
40 |
Unique transaction identifier |
|
START_DATE |
Date |
|
The start processing datetime |
|
END_DATE |
Date |
|
The end processing datetime |
|
DATA_SOURCE |
Varchar2 |
20 |
The data source associated with this performance record |
|
CONTENT_CREATION_DATE |
Date |
|
The content creation date time associated with this performance record |
|
INTERVAL_END_DATE |
Date |
|
The interval end date for the performance assessment |
|
THREAD_ID |
Varchar2 |
50 |
The application thread that processed this event |
|
FILE_ID |
Varchar2 |
40 |
The unique file identifier |
|
CONFIDENTIALITY |
Varchar2 |
30 |
The confidentiality of the file, PUBLIC or PRIVATE |
|
FILE_NAME |
Varchar2 |
100 |
The filename associated with this performance record |
|
FILE_EXTENSION |
Varchar2 |
10 |
The type of file, the filename extension |
|
JOB_TYPE |
Varchar2 |
30 |
The type of Job. For pdrBatcher, values are DOWNLOAD, UPLOAD For pdrLoader, values are TRANSACTIONAL. BACKFILL |
|
JOB_SIZE |
Integer |
|
The size of this job. Units of measure are defined in the JOB_SIZE_UNITS column |
|
JOB_SIZE_UNITS |
Varchar2 |
10 |
The size units for this performance record. Valid values are BYTES and ROWS |
|
MESSAGE_ID |
Varchar2 |
40 |
The message identifier |
|
INIT_MESSAGE_ID |
Varchar2 |
40 |
The initiating message identifier to which this message was a response to |
|
PARTICIPANT_ID_FROM |
Varchar2 |
20 |
The participant ID which this message was from |
|
PARTICIPANT_ID_TO |
Varchar2 |
20 |
The participant ID which this message was sent to |
|
EVENT_RECEIVED_DATE |
Date |
10 |
The date time that the process event notification was received |
|
PROCESS_ELEMENT_ID |
Varchar2 |
40 |
The process element identifier associated with transformation of content between source and destination |
|
PROCESS_ELEMENT_PARENT_ID |
Varchar2 |
40 |
The parent process element identifier associated with transformation of content between source and destination. Where NULL this is the first element in the chain |
PDR_MONITOR_PERFORMANCE_CONFIG
The PDR_MONITOR_PERFORMANCE_CONFIG tables contains the configuration for end to end delivery SLA for a range of datasets to be monitored.
The primary source of data for this table is SQL (for manual updates).
Primary Key
- FILE_ID
Table 11 PDR_MONITOR_PERFORMANCE_CONFIG contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
FILE_ID |
Varchar2 |
40 |
The unique file identifier |
|
INTERVAL_ITEM_IN_FILENAME |
Integer |
|
The part of the filename after being split by _ which contains the interval date time for performance assessment |
|
BUSINESS_CYCLE_MINS |
Integer |
|
The business cycle for this process in minutes |
|
END_TO_END_SLA |
Integer |
|
The end to end data replication SLA in seconds |
PDR_MONITOR_PERFORMANCE_FILES
The PDR_MONITOR_PERFORMANCE_FILES table tracks the delivery of specific files for a source and populated automatically. It is used to populate lookups on the browser interface.
Primary Key
- PDR_MONITOR_ID
- FILE_ID
Table 12 PDR_MONITOR_PERFORMANCE_FILES contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
PDR_MONITOR_ID |
Integer |
|
The monitor collector identifier |
|
FILE_ID |
Varchar2 |
40 |
The unique file identifier |
|
LAST_PROCESSED |
Date |
|
The latest datetime at which this content was processsed by the specific monitor source |
PDR_MONITOR_ROLES
The PDR_MONITOR_ROLES table contains the list of roles that can be used for permissioing access in the PDR monitor system.
This table content is managed within the PDR monitor user interface.
Primary Key
- ROLE_ID
Table 13 PDR_MONITOR_ROLES contents
|
Field Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
ROLE_ID |
Varchar2 |
30 |
The unique role identifier |
|
IS_ACTIVE |
Integer |
|
If the role is currently active then 1, otherwise 0 |
PDR_MONITOR_SOURCE
The PDR_MONITOR_SOURCE table contains configuration data for access to the pdrBatcher and pdrLoader applications and associates these instances with a system identifier.
This table content is managed within the PDR monitor user interface.
Primary Key
- PDR_MONITOR_ID
Table 14 PDR_MONITOR_SOURCE contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
PDR_MONITOR_ID |
Integer |
|
The monitor collector identifier |
|
SYSTEM_ID |
Varchar2 |
30 |
The system identifier associated with this application |
|
HOSTNAME |
Varchar2 |
40 |
The hostname on which this application is running |
|
INSTANCE_ID |
Varchar2 |
30 |
The unique instance identifier for this application instance |
|
APP_NAME |
Varchar2 |
30 |
The name of the application associated with this data source |
|
APP_VERSION |
Varchar2 |
30 |
The version of the application associated with this data source |
|
LAST_ACTIVE |
Date |
|
The datetime at which this last source was last active |
|
PORT |
Integer |
|
The port number for web service communication |
|
API_KEY |
Varchar2 |
30 |
The API key for web service communication security |
|
IS_ACTIVE |
Integer |
|
Identifies if this source is currently active and should be polled for updates. Valid entries are: 1 = Active 0 = Inactive |
|
IS_HTTPS |
Integer |
|
Identifies if this source is connected via https protocol. Valid entries are 1 = protocol is https 0 = protocol is http |
|
IS_AUTO_ACTIVE |
Integer |
|
Identifies if this sources active status is automatically managed. Valid entries are: 1 = source active status is automatically managed 0 = source active status is manually managed |
|
APP_LABEL |
Varchar2 |
30 |
The label applied to this application instance used to identify its purpose in monitor reporting |
PDR_MONITOR_SYSTEM
The PDR_MONITOR_SYSTEM table contains a list of Data Interchange system identifiers that are configured for this PDR monitor instance .
This table content is managed within the PDR monitor user interface.
Primary Key
- SYSTEM_ID
Table 15 PDR_MONITOR_SYSTEM contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
SYSTEM_ID |
Varchar2 |
30 |
The unique system identifier |
|
IS_ACTIVE |
Integer |
|
1 if the system is active, 0 otherwise |
PDR_MONITOR_SYSTEM_GRANTS
The PDR_MONITOR_SYSTEM_GRANTS table associates user roles to specific systems.
This table content is managed within the PDR monitor user interface.
Primary Key
- SYSTEM_ID
- ROLE_ID
Table 16 PDR_MONITOR_SYSTEM_GRANTS contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
SYSTEM_ID |
Varchar2 |
30 |
The unique system identifier |
|
ROLE_ID |
Varchar2 |
30 |
The unique role identifier |
|
CAN_VIEW |
Integer |
|
Is set to true (1) if the associated role can view this Data Interchange system, otherwise 0 |
|
CAN_CONFIGURE |
Integer |
|
Is set to true (1) if the associated role can configure this Data Interchange system, otherwise 0 |
PDR_MONITOR_USER_GRANTS
The PDR_MONITOR_USER_GRANTS table assigns the role permissions to users.
This table content is managed within the PDR monitor user interface.
Primary Key
- USER_ID
- ROLE_ID
Table 17 PDR_MONITOR_USER_GRANTS contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
USER_ID |
Varchar2 |
30 |
Unique user identifier |
|
ROLE_ID |
Varchar2 |
30 |
Unique Role identifier |
|
IS_ACTIVE |
Integer |
|
1 if the role grant is active, 0 otherwise |
PDR_MONITOR_USERS
The PDR_MONITOR_USERS table contains the list of users who are configured for access to the PDR monitor system.
This table content is managed within the PDR monitor user interface.
Primary Key
- USER_ID
Table 18 PDR_MONITOR_USERS contents
|
Name |
Data Type |
Length |
Comment |
|---|---|---|---|
|
USER_ID |
Varchar2 |
30 |
The unique user identifier |
|
PASSWORD |
Varchar2 |
80 |
The encrypted password |
|
IS_ACTIVE |
Integer |
|
1 if the user is active, 0 otherwise |
|
CREATION_DATE |
Date |
|
The creation date of this user |
|
PASSWORD_CHANGED_DATE |
Date |
|
The date that the password was last changed |
|
DASHBOARD_LAYOUT |
Varchar2 |
4000 |
Layout preference for the home page dashboard |