DW_REVIEW_PERIOD_D

This dimension captures the Review Period Details

Details

Module:

Key Columns

REVIEW_PERIOD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REVIEW_PERIOD_ID NUMBER 38 0 True Review Period Identifier
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. unique key
BUSINESS_GROUP_ID NUMBER 38 0 Reference to Business Group
START_DATE DATE Review period begin date
END_DATE DATE Review period end date
STATUS_CODE VARCHAR2 32 Review period status code DW_ACTIVE_INACTIVE_D_TL STATUS_CODE