# DW_NS_usage_F

This fact contains information about subscription usage record that tracks the consumption or usage of a subscription-based product or service over time, such as money, time, software licenses, or internet data.

## Details

Module:

## Key Columns

id

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
id | NUMBER | 38 | 0 | True | Transaction Identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. |  |
customer | NUMBER | 38 | 0 |  | Customer identifier. | DW_NS_customer_D | id
item | NUMBER | 38 | 0 |  | Identifier of the item. | DW_NS_item_D | id
lastmodifieddate | TIMESTAMP |  |  |  | Last Modification Date. |  |
memo | VARCHAR2 | 999 |  |  | Textual description provided by transaction creators. |  |
status | VARCHAR2 | 64 |  |  | Read-only field that indicates the status identifier of the transaction. | DW_NS_UsageStatus_D | key
subscriptionplan | NUMBER | 38 | 0 |  | The subscription plan associated with a subscription. | DW_NS_subscriptionPlan_D | id
usagedate | TIMESTAMP |  |  |  | Date on which the usage occurred. |  |
usagequantity | NUMBER |  |  |  | Quantity of the subscription line item consumed/used. |  |
usagesubscription | NUMBER | 38 | 0 |  | Identifier of the associated subscription for this usage. | DW_NS_SUBSCRIPTIONS_F | id
usagesubscriptionline | NUMBER | 38 | 0 |  | Line Identifier of the associated subscription line for this usage. | DW_NS_SUBSCRIPTION_LINES_F | id

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