CUSTOMERS

Customer’s ID

Customer type description (For example, Employee, Individual, Non-profit)

Geographic Area description

The ID of the customer who last paid a charge on behalf of this customer

The site to which the customer belongs

Customer’s first name

Customer’s last name

Customer’s address 1

Customer’s address 2

Customer’s residential address city

Customer’s residential address province

Customer’s zip code

The latitude of the customer’s address.

The longitude of the customer’s address.

Customer’s home phone

Customer’s work phone

Customer’s cell phone

Customer’s fax phone

Customer’s pager phone

Customer’s other phone

Customers email address

Customer’s age category, when used as an alternative to entering a birthdate

The customer record creation date

Customer Gender (Male, Female, Other)

The index of this gender for linking to other records

The gender name

The gender short name

The plural form of the gender name

Whether the customer is the head of household

The most recent date of sign a waiver

Customers mailing address 1

Customers mailing address 2

The city of the customer’s mailing address

The state of the customer’s mailing address

The zip code of the customer’s mailing address

The country of the customer’s mailing address

The mailing name used on mail-outs and statements

Customers occupation

Customer’s resident status (“Resident” or “Non-resident”)

Whether the customer needs special handling (Yes or No)

The first name of the customers emergency contact1

The last name of the customers emergency contact1

The phone number of the customers emergency contact1

The customers relation to their emergency contact1

The other phone number of the customers emergency contact1

The first name of the customers emergency contact2

The last name of the customers emergency contact2

The phone number of the customers emergency contact2

The customers relation to their emergency contact2

The other phone number of the customers emergency contact2

The date and time of the last modification to the customer information

Customer’s retired status (“Retired” or “Active”)

Whether the customer is activated on the CUI

Customers CUI account creation time and date

Customers most recent CUI login time and date

The date on which the customers interest charge is calculated

Customers county

Displays Yes or No

Customers middle name

Customers residency expiration date

Customers legal name

Customers additional email address

The date on which the customers late fee is calculated.

Whether the customer agreed to receive text messages

Where the customer account was created (Online / Staff side / Connect / Unknown)

Whether the customer agreed to receive emails

Whether the customer agreed to receive postal mail

The date and time of the last modification to the customer information

The customer record creation date

The date on which the customers interest charge is calculated

The most recent date of sign a waiver

The date on which the customers late fee is calculated.

Customers CUI account creation time and date

Customers most recent CUI login time and date

Customers residency expiration date

General alert text for this customer.

Customer’s date of birth.

Age of the customer (years.months)

General notes for this customer.

Customer’s external ID text.

Customer’s salutation.

Customer’s country of residence.

Customer’s current school grade.

Customer’s grade to age delta.

Customer’s CUI login name.

The current balance due for this customer.

The current credit balance available for this customer.

The customer’s preferred language.

The ID of the customer’s age category, when used as an alternative to entering a birthdate

The ID of the customer’s salutation.

The ID of the customer’s type

The ID of the customer’s geographic area

The ID of the customer’s current school grade.

The ID of the customer’s occupation

The ID of the site to which the customer belongs

Whether the customer currently has an active membership which qualifies them for member fees and discounts (Yes/No)

Whether the customer email address has been provided and is a validly formatted email address (Yes/No)

Whether the additional email address has been provided and is a validly formatted email address (Yes/No)

Whether the customer is a prospect entered via the prospects form (Yes/No)

Whether the customer is a drop-in customer (Yes/No)

The email address of the drop-in customer if entered

Customers first CUI login time and date. NOTE: This value can be guaranteed valid for customers created after November 2024.

The Hub record ID

Date and time Hub record was last modified

The Hub sync process ID

Your organization’s unique identifier in the Active Net system

The ID value from the Active Net system