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     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    

Copyright © 2019, 2022, Oracle and/or its affiliates.