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

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