RPT_CALENDAR_DAYS
This table is a single column table that is populated with dates during etl load_data. The dates are in the range of start boundary and end boundary for etl. This table is used during the full etl logic to improve the performance.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
ASSIGNMENT_DATE |
NULLABLE |
DATE |
Date field that falls between the start and the end boundaries of full etl. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
RPT_CALENDAR_DAYS_UI |
UNIQUE |
1 |
ASSIGNMENT_DATE |
Sequences
This table uses no sequences.