1. Tables and Views for Sales, Fusion Service, and Field Service
  2. OSS_RATING_CHARGE_DETERMINANTS

OSS_RATING_CHARGE_DETERMINANTS

This table is used to capture rate plan charge determinants.

Details

  • Schema: FUSION

  • Object owner: OSS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

OSS_RATINGCHRG_DETERMINANTS_PK

CHARGE_DETERMINANT_ID

Columns

Name Datatype Length Precision Not-null Comments
CHARGE_DETERMINANT_ID NUMBER 18 Yes This field uniquely identifies the specific rate plan charge determinant associated with each row in the dataset.
CHARGE_DETERMINANT_PUID VARCHAR2 120 This field acts as an alternative identifier for the rate plan charge determinant associated with the row.
RATE_PLAN_DETERMINANT_ID NUMBER 18 This field uniquely identifies the specific rate plan determinant associated with each row in the dataset.
RATE_PLAN_ID NUMBER 18 This field tracks the rate plan ID associated with the rate plan charge determinant. It links each charge determinant to its specific rate plan, ensuring that the correct charges are applied within the framework of the designated plan.
CHARGE_DEFINITION_ID NUMBER 18 This field tracks the charge definition ID associated with the rate plan charge determinant. It links each charge determinant to a specific charge definition, ensuring that the correct rules, rates, and parameters are applied when calculating charges within a rate plan.
PRICING_TIER_ENABLED_FLAG VARCHAR2 1 This field tracks the price tier associated with the rate plan charge determinant. It indicates the specific pricing level or bracket that applies to the charge determinant within the rate plan.
DETERMINANT_GROUP_CRITERIA_ID NUMBER 18 Obsoleted : This field tracks the determinant group criteria ID associated with the rate plan charge determinant. It links each charge determinant to a specific group of criteria used to determine how charges are applied within the rate plan.
UOM VARCHAR2 3 This field tracks the usage unit of measure associated with the rate plan charge determinant.
UOM_CLASS VARCHAR2 10 This field tracks the class of usage unit of measure associated with the rate plan charge determinant.
CHARGE_PERIOD VARCHAR2 30 This field tracks the charge period associated with the rate plan charge determinant.
START_TIME TIMESTAMP The "Usage Charge Start Time" field captures the exact start time for a usage charge within a specific rate plan.
END_TIME TIMESTAMP The "Usage Charge End Time" field records the exact end time of a usage charge within a specific rate plan.
PRICING_ENTITY_NAME VARCHAR2 240 This field tracks the name of the pricing entity like Line, Header
PRICING_QUANTITY_ATTRIBUTE VARCHAR2 240 This field tracks the quantity based attribute of the pricing entity
PRICING_QUANTITY_UOM_ATTRIBUTE VARCHAR2 240 This field tracks the unit of measure based attribute of the pricing entity
REPORTED_QUANTITY_ATTRIBUTE VARCHAR2 240 The "Reported Quantity" field is used to capture the specific quantity value reported for a usage event.
REPORTED_QUANTITY_ATTRIBUTE_ID NUMBER 18 This field tracks the identifier of reported quantity attribute of the pricing entity
REPORTED_UOM_ATTRIBUTE VARCHAR2 240 The "Reported Unit of Measure" field captures the specific unit of measure (UOM) as reported for a usage event.
REPORTED_UOM_ATTRIBUTE_ID NUMBER 18 This field tracks the identifier of reported unit of measure attribute of the pricing entity.
BASE_RATE_TABLE_MATRIX_ID NUMBER 18 The "Pricing Matrix Identifier" field uniquely identifies the specific pricing matrix used by the system to calculate the base price for a usage event.
ADJUSTMENT_MATRIX_ID NUMBER 18 The "Pricing Adjustment Matrix ID" field serves as a foreign key that links to the Pricing Model Header entity.
TIER_HEADER_ID NUMBER 18 The "Tiered Pricing Header ID" field serves as a foreign key that links a record to the Tiered Pricing Header entity
TIER_BASIS_TYPE_CODE VARCHAR2 30 The "Tier Basis Type Code" field tracks the volume attribute of the transaction that is used for tier evaluation within a tiered pricing model.
TIER_BASIS_ID NUMBER 18 The "Tier Basis ID" field indicates the specific charge or set of charges against which the tier basis will be evaluated when the Tier Basis Type is Amount.
TIER_TYPE VARCHAR2 30 The "Tier Type" field tracks the specific tier rules that are applied to either the quantity or the amount during the tiered pricing evaluation.
PARTIAL_BLOCK_ACTION_CODE VARCHAR2 30 The "Partial Block Action Code" field tracks how the pricing is calculated in the tiered pricing model, specifically whether it is based on a per unit or block approach.
PRICE_LIST_CHARGE_ID NUMBER 18 The "Price List Charge ID" field tracks the unique identifier for a specific charge within a price list.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
OSS_RATINGCHRG_DETERMINANTS_N1 Non Unique Default RATE_PLAN_DETERMINANT_ID, CHARGE_DEFINITION_ID, START_TIME, END_TIME
OSS_RATINGCHRG_DETERMINANTS_PK Unique Default CHARGE_DETERMINANT_ID
OSS_RATINGCHRG_DETERMINANTS_U1 Unique Default CHARGE_DETERMINANT_PUID