DW_PERF_TEMPLATE_PERIOD_D
It stores the time periods for the template
Details
Module: Performance Management
Key Columns
BUSINESS_GROUP_ID, TEMPLATE_PERIOD_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TEMPLATE_PERIOD_ID | NUMBER | 38 | 0 | True | Business Key for Template Period | ||
| BUSINESS_GROUP_ID | NUMBER | 38 | 0 | True | Business Group identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Key consisting of TEMPLATE_PERIOD_ID, BUSINESS_GROUP_ID | ||||
| TEMPLATE_DEFINITION_ID | NUMBER | 38 | 0 | Template Definition identifier | DW_PERF_TEMPLATE_DEF_D | TEMPLATE_DEFINITION_ID | |
| VALID_FROM_DATE | DATE | Indicates the start date of the document period | |||||
| VALID_TO_DATE | DATE | Indicates the end date of the document period |