Calix Cloud Data Field Mappings

Jennifer Trower Updated by Jennifer Trower

Read Time: 4 mins

Below, we provide you with a table to better understand the relationship between the Sonar and Calix Cloud Data Fields which are leveraged by the API integration.

Sonar Field

Sonar Object

Calix Cloud Field

Calix Cloud Object

Notes

ID

Account

Account

Subscriber

Name

Account

Account

Subscriber

Name

Contact

First Name & Last Name

Subscriber

Account’s Primary Contact is used.

Number

Phone Number

Phone

Subscriber

Primary Contact’s Lowest ID Phone Number is used.

Email Address

Contact

Email

Subscriber

Primary Contact’s Email Address is used.

Type

Account Type

Customer Sub-Type

Subscriber

Type of the Account’s associated Account Type is used.

Total Balance

Account

Overdue Balance

Subscriber

Account Custom Field Data

Custom Field

Field 1

Subscriber

Optionally and manually mapped in Integration Settings.

Account Custom Field Data

Custom Field

Field 2

Subscriber

Optionally and manually mapped in Integration Settings.

Account Custom Field Data

Custom Field

Field 3

Subscriber

Optionally and manually mapped in Integration Settings.

Account Custom Field Data

Custom Field

Field 4

Subscriber

Optionally and manually mapped in Integration Settings.

Account Custom Field Data

Custom Field

Field 5

Subscriber

Optionally and manually mapped in Integration Settings.

ID

Account

Subscriber ID

Service Location

ID

Address

Subscriber Location ID

Service Location

ID of Serviceable Address connected to Account is used.

Line 1, Line 2, City, Subdivision, Country, Zip

Address

Service Address

Service Location

Listed fields from Serviceable Address connected to Account are concatenated together to pass full address into Calix Cloud, including country.

Line 1

Address

Service Address Line 1

Service Location

Line 1 of Serviceable Address connected to Account is used.

Line 2

Address

Service Address Line 2

Service Location

Line 2 of Serviceable Address connected to Account is used.

City

Address

Service Address City

Service Location

City of Serviceable Address connected to Account is used.

Subdivision

Address

Service State

Service Location

Subdivision of Serviceable Address connected to Account is used.

Country

Address

Service Country

Service Location

Country of Serviceable Address connected to Account is used.

Zip

Address

Service Post Code

Service Location

Zip of Serviceable Address connected to Account is used.

Latitude

Address

Service Latitude

Service Location

Latitude of Serviceable Address connected to Account is used.

Longitude

Address

Service Longitude

Service Location

Longitude of Serviceable Address connected to Account is used.

See Note

Address

Attainable Rate

Service Location

Attainable Download Speed of Data Service connected to Account is used. Value converted to Mbps for Calix.

ID

Account

Subscriber ID

Billing Address

Line 1, Line 2, City, Subdivision, Country, Zip

Address

Billing Address

Billing Address

Listed fields from Account’s billing Address are concatenated together to pass full address into Calix Cloud. If the Account does not have a Mailing Address set these fields are not populated.

Line 1

Address

Billing Street Address Line 1

Billing Address

If the Account does not have a Mailing Address set, these fields are left unpopulated.

Line 2

Address

Billing Street Address Line 2

Billing Address

If the Account does not have a Mailing Address set, these fields are left unpopulated.

City

Address

Billing City

Billing Address

If the Account does not have a Mailing Address set, these fields are left unpopulated.

Subdivision

Address

Billing State

Billing Address

If the Account does not have a Mailing Address set, these fields are left unpopulated.

Country

Address

Billing Country

Billing Address

If the Account does not have a Mailing Address set, these fields are left unpopulated.

Zip

Address

Billing Post Code

Billing Address

If the Account does not have a Mailing Address set, these fields are left unpopulated.

ID

Account

Subscriber ID

Subscriber Profile

Activation Date

Account

Signup Date

Subscriber Profile

Print Invoice

Account Billing Parameter

Electronic Communications Consent

Subscriber Profile

Accounts that receive their invoice electronically are set as having provided electronic communications consent.

See Note

Account

Autopay?

Subscriber Profile

Whether or not there is a Payment Method on Account that is set to Auto.

Next Recurring Charge

Account

Total Revenue Per Subscriber Per Month

Subscriber Profile

FIPS

Address

Census Tract

Subscriber Profile

FIPS for the Serviceable Address connected to the Account.

Activation Date

Account

Service Start Date

Account Status/Details

ID

Account

Subscriber ID

Devices

Device ID

Devices

A comma separated list of the devices associated with the account that are mapped in the Calix Cloud settings.

ID

Account

Subscriber ID

Flow Endpoint Matching Options

See Note

Account

Endpoint Matching Option 1

Flow Endpoint Matching Options

If you have mapped any Inventory Model(s) that have a Model Category of RG, the Account’s corresponding Inventory Item’s mapped Device ID field will be used.

See Note

Account

Endpoint Matching Option 2

Flow Endpoint Matching Options

If you have mapped any Inventory Model(s) that have a Model Category of ONT, the Account’s corresponding Inventory Item’s mapped Device ID field will be used.

See Note

Account

Endpoint Matching Option 3

Flow Endpoint Matching Options

If you have mapped any Inventory Model(s) that have a Model Category set to anything besides RG or ONT, the Account’s corresponding Inventory Item’s mapped Device ID field will be used.

ID

Service

Service USOC

Global Service Definition

Type

Service

Service Type

Global Service Definition

Name

Service

Service Description

Global Service Definition

Data Service Download

Service

Download Speed

Global Service Definition

The Download Speed of the Data Service, converted to Mbps.

Data Service Upload

Service

Upload Speed

Global Service Definition

The Upload Speed of the Data Service, converted to Mbps.

Data Service Technology Code

Service

Technology Type

Global Service Definition

Amount

Service

Service Fee

Global Service Definition

The Amount of the Data Service is used.

How did we do?

Contact