Share this page
SOURCE_PRODUCT_CONFIG
This table stores the source product instance configuration information, such as the timezone, product name, and version. This table is under the schema that contains management tables.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Field Name |
Null? |
Field Type |
Description |
|---|---|---|---|
|
SOURCE_INSTANCE_ID |
Not null |
INT |
Unique source product instance ID |
|
SOURCE_INSTANCE_NAME |
Not null |
VARCHAR(100) |
Source product instance name |
|
SOURCE_TIMEZONE_ID |
Not null |
VARCHAR(200) |
Source product instance timezone |
|
SOURCE_PRODUCT_NAME |
Nullable |
VARCHAR(100) |
Source product instance name; the default value is PPM |
|
SOURCE_PRODUCT_VERSION |
Not null |
VARCHAR(100) |
Source product instance version, such as 9.30 |
|
CONNECTION_PROTOCOL |
Nullable |
VARCHAR(100) |
Connection protocol, such as JDBC |
|
CONNECTION_PROTOCOL_VENDOR |
Nullable |
VARCHAR(100) |
Connection protocol vendor; only Oracle is supported |
|
CONNECTION_PROTOCAL_VERSION |
Nullable |
VARCHAR(100) |
Oracle database version |
|
INITIAL_LOAD_DURATION |
Nullable |
INT |
Number of months |
|
MD_CREATETIME |
Nullable |
datetime |
Date when the record is created |
|
MD_LASTMODDDATE |
Nullable |
datetime |
Date when the record is updated |
Projections
This table uses no projections.
Sequences
This table uses no sequences.
