RPT_PARAMS

This table holds different parameters for the Full ETL and the incremental ETL to run successfully. For example, the db link name, start and end dates of the etl are all stored in this table.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name	Null?	Data Type	Description
PARAMETER_NAME	NOT NULL	VARCHAR2(50)	A unique string value to represent the parameter name.
PARAMETER_VALUE	NULLABLE	VARCHAR2(100)	String value for the corresponding parameter name. The strings can be converted to any data type as needed. For example, the start date will be converted to date type.
DESCRIPTION	NULLABLE	VARCHAR2(500)	Description about this parameter.

Indexes

Index Name	Index Type	Sequence	Column Name
SYS_C003623112	UNIQUE	1	PARAMETER_NAME

Sequences

This table uses no sequences.