DW_CXS_SUBSCRIPTION_SNAPSHOT_D

subscription aggregation Period dimension

Details

Module: Subscription Management

Key Columns

SNAPSHOT_PERIOD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SNAPSHOT_PERIOD_ID NUMBER 38 0 True Surrogate identifier created for uniquely identifying snapshot periods    
SOURCE_RECORD_ID VARCHAR2 64     Unique key    
PERIOD_START_DATE DATE       Period Start Date of snapshot period    
PERIOD_END_DATE DATE       Period End Date of snapshot period    
PERIOD_TYPE VARCHAR2 16     Period Type. Stores such values as WEEK, MONTH, QUARTER, YEAR.    
PARTIAL_FLAG VARCHAR2 16     Partial Flag Indicator of snapshot period    
WEEK_CODE VARCHAR2 64     Week Code based on period end date DW_WEEK_D CAL_WEEK_CODE
MONTH_CODE VARCHAR2 64     Month Code based on period end date DW_MONTH_D CAL_MONTH_CODE
QUARTER_CODE VARCHAR2 64     Quarter Code based on period end date DW_QUARTER_D CAL_QUARTER_CODE
YEAR_CODE VARCHAR2 32     Year Code based on period end date DW_YEAR_D CAL_YEAR_CODE
PREVIOUS_SNAPSHOT_PERIOD_ID NUMBER 38 0   Identifier for previous snapshot period    
PREVIOUS_PERIOD_START_DATE DATE       Period Start Date of Previous snapshot period    
PREVIOUS_PERIOD_END_DATE DATE       Period End Date of Previous snapshot period    
PREVIOUS_WEEK_CODE VARCHAR2 64     Week Code based on period end date for pervious snapshot period DW_WEEK_D CAL_WEEK_CODE
PREVIOUS_MONTH_CODE VARCHAR2 64     Month Code based on period end date for previous snapshot period DW_MONTH_D CAL_MONTH_CODE
PREVIOUS_QUARTER_CODE VARCHAR2 64     Quarter Code based on period end date for previous snapshot period DW_QUARTER_D CAL_QUARTER_CODE
PREVIOUS_YEAR_CODE VARCHAR2 32     Year Code based on period end date for previous snapshot period DW_YEAR_D CAL_YEAR_CODE