This table requires activation of Subscription Management Snapshot functional area. subscription aggregation Period dimension
Module: Subscription Management
SNAPSHOT_PERIOD_ID
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 | ||
CURRENT_PERIOD_FLAG | VARCHAR2 | 16 | Current Flag Indicator of snapshot period |
Copyright © 2019, 2023, Oracle and/or its affiliates.