The Pega Foundation for Communications (formerly Communications Industry Foundation) application database structure is updated with each subsequent release to address newly added features and to improve general application usability.

For more information about the Pega Foundation for Communications data model, see Information Framework (SID) in the TM Forum knowledge base.

• Pega Foundation for Communications 8.4
• Pega Foundation for Communications 8.3
• Pega Foundation for Communications 8.1
• Pega Foundation for Communications 7.4
• Pega Foundation for Communications 7.31
• Communications Industry Foundation 7.21.1
• Communications Industry Foundation 7.21

Pega Foundation for Communications 8.4

Added tables

The following table has been added in this release:

• Comms_account_config_map
• Comms_tax_fee_master
• Comms_account_tax_details
• Comms_sales_order_ref

Updated tables

The following previously existing tables have been updated in this release:

• Comms_cust_account_billing
  • Added new column
    • Is_estimate(Y/N)
• Comms_product_usage
  • Added new column
    • Start_date
    • End_date
    • Is_prorated(Y/N)
• Comms_product_master
  • Added new column
    • Service_type
    • Service_category
    • Entity_type
    • Specification_type
    • Is_location_based          
    • Is_serviceable
• Comms_account_offer_map
  • Added new column
    • Parent_account_offer_map_key
    • Created_in                                                         
    • Offer_type

Pega Foundation for Communications 8.3

Added tables

The following table has been added in this release:

• Comms_account_offer_map

Updated tables

The following previously existing tables have been updated in this release:

• Comms_account_product_map
  • Added new column
    • Account_offer_map_key
• Comms_product_usage
  • Added new column
    • Billing_ref_num
• Comms_service_usage_charge
  • Added new column
    • Billing_ref_number
• Comms_cust_account_billing
  • ​​​​​​​Added new column
    • Discountid
• Comms_product_usage
  • ​​​​​​​Added new column
    • Otc

Pega Foundation for Communications 8.1

There are no structural changes to the database in this release.

Pega Foundation for Communications 7.4

Added tables

The following table has been added in this release:

• Comms-bill-payments

Updated tables

The following previously existing tables have been updated in this release:

• Comms_cust_account_billing
  • Added new column
    • Total_payment_rcvd
• Comms_customer_courtesycredit
  • Added new columns
    • Account_number
    • Billing_ref_number
    • Status

Pega Foundation for Communications 7.31

There are no structural changes to the database in this release.

Communications Industry Foundation 7.21.1

Added tables

The following tables have been added in this release:

• Comms-prospect_master
• Comms_prospect_addresses

Updated tables

The following previously existing tables have been updated in this release:

• Comms_company_master
  • Added new columns
    • Customer_segment
    • Business_operation
    • Employee_range
    • Relationship_start_date
    • Incorporation_date
• Comms_account_master
  • Added new columns
    • Bill_mode
    • Billing_type

Communications Industry Foundation 7.21

Added tables

The following tables have been added in this release:

• Comms_acc_prod_map_history
• Comms_acc_prod_status
• Comms_acc_prod_status_reason
• Comms_balance_type
• Comms_bank_master
• Comms_bilng_agrmnt_acc_map
• Comms_cust_contact_details
• Comms_identifier_type
• Comms_margin_types
• Comms_plan_description
• Comms_product_agreement_map
• Comms_product_category
• Comms_product_identifier_map
• Comms_product_recharges
• Comms_recharge_balances
• Comms_usage_type

Updated tables

The following previously existing tables have been updated in this release:

• Comms_account_master
  • Added new columns
    • Auto_payment_date
    • Billed_to_account
• Comms_account_product_map
  • Added new columns
    • Account_product_key (Primary key for this table)
    • Alias
    • Billing_account_no
    • Billing_type
    • Is_primary
    • Parent_product_key
    • Plan_id
    • Product_category
    • Status_id
• Comms_clv_details
  • Added new columns
    • Margin_id
    • Margin_value
  • Removed previously existing columns
    • Contact_length
    • Coa_sales
    • Coa_device
    • Coc
    • Data_marging
    • Data_oob_margin
    • Messaging_margin
    • Messaging_oob_margin
    • Total_addon_margin
    • Total_otc
    • Voice_margin
    • Voice_oob_margin

• Comms_company_master
  • Added new columns
    • Company_rating
    • Company_rating_date
• Comms_cust_account_billing
  • Added new columns
    • Adjustment_amount
    • Last_payment_amount
• Comms_customer_master
  • Added new columns
    • Credit_score
    • Credit_score_date
• Comms_plan_description
  • Added new column
    • Plan_cost
• Comms_product_usage
  • Added new column
    • Account_product_key
• Comms_service_other_charge
  • Added new column
    • Account_product_key
• Comms_service_usage_charge
  • Added new columns
    • Account_product_key
    • Balance_deducted
    • Balance_id
    • Billed
    • Call_id
    • Is_prepaid
    • Original_balance_deducted
    • Original_cost
    • Usage_type

Updated column names

The following previously existing tables include columns that have been renamed in this release:

• Comms_account_equipment_map
  • Previous column name: product_type_num
  • New column name: product_type_id
• Comms_account_product_map
  • Previous column name: product_type_num
  • New column name: product_type_id
• Comms_product_master
  • Previous column name: producttype
  • New column name: product_type_id