9 Storable Class Changes

Learn about new and modified storable classes in Oracle Communications Billing and Revenue Management (BRM).

Topics in this document:

New Storable Classes

Table 9-1 lists the storable classes that have been introduced in BRM.

Table 9-1 New Storable Classes

New Storable Class Description

/acc_mgmt

Generic class to allow customers to augment the account with information easily without extending the account object. There may be many profile objects associated with each account.

/acc_mgmt/profile

Generic class to allow customers to augment the account with arbitrary information easily without extending the account object. There may be many profile objects associated with each account.

/agreement

Stores the agreements associated with accounts.

/agreement_association

Stores the agreement associated with an account.

/agreement_characteristic

Stores the key-value pairs linked with an agreement.

/agreement_override_values

Stores the overrides for agreement charge values for a certain period of time.

/billing_simulation

Stores simulated bill data, including bill information, item charges, the total amount, the simulated bill object, and the offer object used to simulate the new charges.

/config/agreement_state_map

Stores agreement status and lifecycle status mapping.

/event/agreement

Stores agreement-related events.

/event/agreement/association

Stores details about agreement associations.

/event/agreement/attribute_change

Generated when an agreement resource changes in the database.

/event/agreement/post

Generated when an agreement is created.

/event/agreement/state_change

Stores details about agreement state changes.

/event/audit/customer/payinfo/cash

Categorizes all changes to a customer's cash information.

/event/audit/customer/payinfo/check

Categorizes all changes to a customer's check information.

/external_event/payment_method

Stores event-tracking information for TMF 670 payment-method operations received from an external master system.

/external_event/profile

Stores event-tracking information for profiles received from an external master system.

/external_event/sharing_group

Stores event-tracking information for sharing group data received from an external master system.

/job/simulation

Stores information about a billing simulation job.

/payinfo/cash

Stores cash payment-method information.

/payinfo/check

Stores check payment-method information.

/payment_method

Stores information about payment methods.

/payment_method/resources

Stores array and substruct data types for the /payment_method class.

/price_tag

Stores serialized price-tag metadata for a product or discount usage map.

/rule

Stores the content of Drools rules.

/simulated_event

Stores data about the events that are generated as part of the simulation.

Changed Storable Classes

Table 9-2 lists the storable classes that have been modified in BRM.

Table 9-2 Changed Storable Classes

Changed Storable Class Description

/event/billing/deal

/event/billing/discount/action

/event/billing/product/action

/event/customer/contract

/event/notification/plan/transition/post_deal_cancel

/history_subscriber_contract

/purchased_discount

/purchased_product

/revenue_distribution

/revenue_product

/subscriber_contract

The PIN_FLD_PACKAGE_ID field changed from an integer to a 64-bit integer data type:

  • PIN_FLD_PACKAGE_ID identifies the package associated with the listed storable classes.

/config/product_state_map

Contains the following new field:

  • PIN_FLD_DELETE_STATUS: Specifies whether deletion is allowed for this lifecycle status. Valid values are 0 (not allowed) and 1 (allowed).

/discount

Contains the following new field:

  • PIN_FLD_PRICE_TAG_OBJ: Specifies the POID of the /price_tag object for this usage map.

/event/billing/charge/cc

Contains the following new fields:

  • PIN_FLD_CARD_BRAND_TYPE: Specifies the card brand type. Values are Visa (1), Mastercard (2), American Express (3), Optima (4), Discover Card (5), Diners Club (6), Carte Blanche (7), JCB (8), Switch (9), China UnionPay (10), and Unknown type (11).

  • PIN_FLD_BANK_CARD_TYPE: Specifies the bank card type. Values are credit (1), debit (2), and unknown type (3).

  • PIN_FLD_TOKEN_TYPE: Specifies the token type.

  • PIN_FLD_ISSUER: Specifies the card issuer.

  • PIN_FLD_LAST_FOUR_DIGITS: Specifies the last four digits of the card.

  • PIN_FLD_BANK_NAME: Specifies the bank name.

/event/billing/charge/dd

Contains the following new field:

  • PIN_FLD_BANK_NAME: Specifies the bank name.

/event/billing/payment

Contains the following new field:

  • PIN_FLD_PAYINFO_OBJ: Specifies the /payinfo object associated with this payment.

/event/billing/product/action

Contains the following new fields:

  • PIN_FLD_INDICATOR: Identifies the purchased product type using the PIN_PURCHASED_PRODUCT_TYPE_ERA (0x1) and PIN_PURCHASED_PRODUCT_TYPE_SERVICE_BUNDLE (0x2) flags.

  • PIN_FLD_PAYINFO_OBJ: Specifies the payment method /payinfo object associated with this payment.

/event/billing/validate/cc

Contains the following new fields:

  • PIN_FLD_CARD_BRAND_TYPE: Specifies the card brand type. Values are Visa (1), Mastercard (2), American Express (3), Optima (4), Discover Card (5), Diners Club (6), Carte Blanche (7), JCB (8), Switch (9), China UnionPay (10), and Unknown type (11).

  • PIN_FLD_BANK_CARD_TYPE: Specifies the bank card type. Values are credit (1), debit (2), and unknown type (3).

  • PIN_FLD_TOKEN_TYPE: Specifies the token type.

  • PIN_FLD_ISSUER: Specifies the card issuer.

  • PIN_FLD_LAST_FOUR_DIGITS: Specifies the last four digits of the card.

  • PIN_FLD_BANK_NAME: Specifies the bank name.

/event/billing/validate/dd

Contains the following new field:

  • PIN_FLD_BANK_NAME: Specifies the bank name.

/event/group/sharing/charges

Contains the following new field:

  • PIN_FLD_CODE: Specifies the unique identification code for the sponsor object.

/event/group/sharing/discounts

Contains the following new field:

  • PIN_FLD_IDENTIFICATION_CODE: References a discount object.

/event/group/sharing/products

Contains the following new field:

  • PIN_FLD_IDENTIFICATION_CODE: References a product object.

/event/group/sharing/profiles

Contains the following new field:

  • PIN_FLD_IDENTIFICATION_CODE: References a profile object.

/group

Contains the following new field:

  • PIN_FLD_IDENTIFICATION_CODE: References a group object.

/group/sharing/charges

Contains the following new field:

  • PIN_FLD_CODE: Specifies the unique identification code for the sponsor object.

/group/sharing/discounts

Contains the following new field:

  • PIN_FLD_IDENTIFICATION_CODE: References a discount object.

/group/sharing/products

Contains the following new field:

  • PIN_FLD_IDENTIFICATION_CODE: Provides a link to one profile object.

/group/sharing/profiles

Contains the following new field:

  • PIN_FLD_IDENTIFICATION_CODE: References a profile object.

/offering_override_values

The following field was modified:

  • PIN_FLD_OFFERING_OBJ: Changed from required to optional when creating the object.

/payinfo

Contains the following new fields:

  • PIN_FLD_DESCR: Specifies the description of the /payinfo object.

  • PIN_FLD_IDENTIFICATION_CODE: Provides a link to one profile object.

  • PIN_FLD_IS_PREFERRED: Specifies whether this /payinfo object is preferred. Valid values are PIN_BOOLEAN_FALSE (0) and PIN_BOOLEAN_TRUE (1).

  • PIN_FLD_STATUS: Specifies the status of the payment information: inactive (0) or active (1).

  • PIN_FLD_STATUS_DATE: Specifies the date when the payment information status was set.

  • PIN_FLD_VALID_FROM: Specifies the start date of the payment information's validity period.

  • PIN_FLD_VALID_TO: Specifies the end date of the payment information's validity period.

The following field was removed:

  • PIN_FLD_AUTH_CODE

/payinfo/cc

Contains the following new fields:

  • PIN_FLD_CARD_BRAND_TYPE: Specifies the card brand type. Values are Visa (1), Mastercard (2), American Express (3), Optima (4), Discover Card (5), Diners Club (6), Carte Blanche (7), JCB (8), Switch (9), China UnionPay (10), and Unknown type (11).

  • PIN_FLD_BANK_CARD_TYPE: Specifies the bank card type. Values are credit (1), debit (2), and unknown type (3).

  • PIN_FLD_TOKEN_TYPE: Specifies the token type.

  • PIN_FLD_ISSUER: Specifies the card issuer.

  • PIN_FLD_LAST_FOUR_DIGITS: Specifies the last four digits of the card.

  • PIN_FLD_BANK_NAME: Specifies the bank name.

/payinfo/dd

Contains the following new field:

  • PIN_FLD_BANK_NAME: Specifies the bank name.

/product

Contains the following new field:

  • PIN_FLD_PRICE_TAG_OBJ: Specifies the POID of the /price_tag object for this usage map.

/product_inventory

Contains the following new fields:

  • PIN_FLD_CYCLE_START_T: Specifies the date to start charging cycle fees for the product.

  • PIN_FLD_CYCLE_END_T: Specifies the date to stop charging cycle fees for the product.

  • PIN_FLD_PURCHASE_START_T: Specifies the date when the product is valid for use.

  • PIN_FLD_PURCHASE_END_T: Specifies the date when the product is no longer valid.

  • PIN_FLD_USAGE_START_T: Specifies the date when usage event rating starts for this product.

  • PIN_FLD_USAGE_END_T: Specifies the date when usage event rating stops for this product.

/profile

Contains the following new fields:

  • PIN_FLD_AGREEMENT_OBJ: References the associated agreement object.

  • PIN_FLD_IDENTIFICATION_CODE: References a profile object.

  • PIN_FLD_OFFERING_OBJ: References the /purchased_product object associated with this profile.

  • PIN_FLD_PRODUCT_OBJ: References the associated product or discount object.

/purchased_product

Contains the following new field:

  • PIN_FLD_INDICATOR: Indicates the type of purchased product using the PIN_PURCHASED_PRODUCT_TYPE_ERA (0x1) and PIN_PURCHASED_PRODUCT_TYPE_SERVICE_BUNDLE (0x2) flags.

/rate_change

Contains the following new field:

  • PIN_FLD_AGREEMENT_OBJ: References the associated agreement object.

/service

Contains the following new field:

  • PIN_FLD_OFFERING_OBJ: References the /purchased_product object associated with the creation of this service.