DW_CXS_SUBSCRIPTION_WEEKLY_SNAPSHOT_F

This fact table stores the subscription aggregate monthly data

Details

Module: Subscription Management

Key Columns

SUBSCRIPTION_PRODUCT_ID, SNAPSHOT_PERIOD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SUBSCRIPTION_PRODUCT_ID NUMBER 38 0 True Subscription product identifier
SNAPSHOT_PERIOD_ID NUMBER 38 0 True Snapshot Period Identifier DW_CXS_SUBSCRIPTION_SNAPSHOT_D SNAPSHOT_PERIOD_ID
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Key
SUBSCRIPTION_ID NUMBER 38 0 Subscription Header Id
STATUS_CODE VARCHAR2 32 Status DW_CXS_SUBSCRIPTION_STATUS_D_TL CODE
START_DATE DATE Subscription Start Date
END_DATE DATE Subscription End Date
CREATION_OPERATION_CODE VARCHAR2 32 Derived. It will hold the action due to which subscription is created. Such as RENEW, AMEND, SUSPEND DW_CXS_SUBSCRIPTION_OPERATION_D_TL CODE
INVENTORY_ORGANIZATION_ID NUMBER 38 0 Definition Org Identifier DW_INTERNAL_ORG_D_TL ORGANIZATION_ID
INVENTORY_ITEM_ID NUMBER 38 0 Inventory Item Identifier DW_SYSTEM_INVENTORY_ITEM_D_TL INVENTORY_ITEM_ID
BILLING_FREQUENCY_CODE VARCHAR2 32 Frequency in which the subscription product has to be billed Stores values such as DAY, MONTH, QUARTER, WEEK, YEAR DW_UNIT_OF_MEASURE_D_TL UOM_CODE
ITEM_UOM VARCHAR2 16 Unit of measure of the product item Stores value such as YEAR, MONTH, Each DW_UNIT_OF_MEASURE_D_TL UOM_CODE
CURRENCY_CODE VARCHAR2 16 Product transaction currency DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
BUSINESS_UNIT_ID NUMBER 38 0 Business Unit Identifier of the subscription DW_BUSINESS_UNIT_D_TL BUSINESS_UNIT_ID
PRIMARY_PARTY_ID NUMBER 38 0 Customer Party Identifier DW_PARTY_ORGANIZATION_D PARTY_ID
SALES_ACCOUNT_ID NUMBER 38 0 Sales account identifier for the subscription primary party where party has a sales account associated to it DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
SHIP_TO_PARTY_ID NUMBER 38 0 Subscription Product ship-to party identifier DW_PARTY_ORGANIZATION_D PARTY_ID
SHIP_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0 Subscription product ship-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
BILL_TO_PARTY_ID NUMBER 38 0 Subscription product bill-to party identifier DW_PARTY_ORGANIZATION_D PARTY_ID
BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0 Subscription product bill-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
SALES_PRODUCT_TYPE_CODE VARCHAR2 64 Sales Product Type DW_CXS_SALES_PRODUCT_TYPE_D_TL CODE
CUSTOMER_PARTY_TYPE_CODE VARCHAR2 64 Customer Party Type DW_CXS_CUSTOMER_PARTY_TYPE_D_TL CODE
CUSTOMER_FIRST_SUBSCRIPTION_START_DATE DATE First subscription start date of customer
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
PRODUCT_NET_PRICE NUMBER The sum of Product Net Price of active subscriptions at the end of a particular period and the subscriptions that got closed or expired during that period
GLOBAL_CURRENCY_PRODUCT_NET_PRICE NUMBER The sum of Product Net Price of active subscriptions at the end of a particular period and the subscriptions that got closed or expired during that period converted to Global Currency
MONTHLY_RECURRING_REVENUE NUMBER The sum of Monthly Recurring Revenue of active subscriptions at the end of a particular period and the subscriptions that got closed or expired during that period
GLOBAL_CURRNCY_MONTHLY_RECURRING_REVENUE NUMBER The sum of Monthly Recurring Revenue of active subscriptions at the end of a particular period and the subscriptions that got closed or expired during that period converted to Global Currency
DUE_RENEWAL_FLAG VARCHAR2 16 Flag to be used for calculating Due renewal metrics
TERMINATED_FLAG VARCHAR2 16 Flag to be used for calculating Closed subscription metrics
RENEW_CHURN_LAPSE_FLAG VARCHAR2 16 Flag to be used for calculating renew churn lapse metrics
RENEW_LAPSE_FLAG VARCHAR2 16 Flag to be used for calculating renew lapse metrics
RENEW_CHURN_FLAG VARCHAR2 16 Flag to be used for calculating renew churn metrics
PRODUCT_CHURN_FLAG VARCHAR2 16 Flag to be used for calculating product churn metrics
EXPIRED_FLAG VARCHAR2 16 Flag to be used for calculating expired metrics
SOURCE_SUBSCRIPTION_PRODUCT_ID NUMBER 38 0 Source subscription product identifier for subscription created due to Renewal, Amend or Suspend
SOURCE_SUBSCRIPTION_MRR NUMBER MRR for the Source subscription product for subscription created due to Renewal, Amend or Suspend
GLOBAL_CURRENCY_SOURCE_SUBSCRIPTION_MRR NUMBER MRR in global currency for the Source subscription product for subscription created due to Renewal, Amend or Suspend
SOURCE_SUBSCRIPTION_PRODUCT_NET_PRICE NUMBER Product net price for the Source subscription product for subscription created due to Renewal, Amend or Suspend
GLOBAL_CURRENCY_SOURCE_SUBSCRIPTION_PRODUCT_NET_PRICE NUMBER Product net price in global currency for the Source subscription product for subscription created due to Renewal, Amend or Suspend