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.