CUSTOMERS

0 rows


Description

Customers’ details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACTIVE_HUB_KEY int identity 4 null

The Hub record ID

CUSTOMER_ID int 4 null
ACCOUNT_CREDIT_HISTORY.CUSTOMER_ID Defined in XML R
ACTIVITY_ENROLLMENTS.CUSTOMER_ID Defined in XML R
ACTIVITY_PRIVATE_LESSONS.CUSTOMER_ID Defined in XML R
AR_SCHEDULED_DETAILS.PAYER_CUSTOMER_ID Defined in XML R
AR_SCHEDULED_DETAILS.TRANSACTION_CUSTOMER_ID Defined in XML R
AR_SCHEDULED_HEADERS.PAYER_CUSTOMER_ID Defined in XML R
CHILD_WATCH_REGISTRATIONS.CUSTOMER_ID Defined in XML R
CHILD_WATCH_REGISTRATIONS.DROP_OFF_CUSTOMER_ID Defined in XML R
CHILD_WATCH_REGISTRATIONS.PICK_UP_CUSTOMER_ID Defined in XML R
COMPANY_AUTHORIZED_AGENTS.CUSTOMER_ID Defined in XML R
COUPON_QUALIFICATIONS.CUSTOMER_ID Defined in XML R
COUPON_USAGE.CUSTOMER_ID Defined in XML R
CREDIT_CARD_PROCESSING_LOG.CUSTOMER_ID Defined in XML R
CUSTOM_QUESTION_ANSWERS.CUSTOMER_ID Defined in XML R
CUSTOMER_ALTERNATE_KEYS.CUSTOMER_ID Defined in XML R
CUSTOMER_MERGE_LOG.CUSTOMER_ID Defined in XML R
CUSTOMER_NOTES.CUSTOMER_ID Defined in XML R
CUSTOMER_PHOTOS.CUSTOMER_ID Defined in XML R
CUSTOMER_SCHOLARSHIP_QUALIFICATIONS.CUSTOMER_ID Defined in XML R
CUSTOMER_SCHOLARSHIPS.CUSTOMER_ID Defined in XML R
CUSTOMER_SIGNED_WAIVERS.CUSTOMER_ID Defined in XML R
CUSTOMER_SIGNED_WAIVERS.SIGNED_BY_CUSTOMER_ID Defined in XML R
CUSTOMER_THIRD_PARTY_BILLING_LINKS.TRANSACTION_CUSTOMER_ID Defined in XML R
CUSTOMER_THIRD_PARTY_BILLINGS.CUSTOMER_ID Defined in XML R
DCPICKUPAUTHORIZATIONS.CHILDCUSTOMER_ID Defined in XML R
DCPICKUPAUTHORIZATIONS.PICKUPCUSTOMER_ID Defined in XML R
DEFERRED_REVENUE_PROJECTIONS.CUSTOMER_ID Defined in XML R
FACILITY_RESERVATION.CUSTOMER_ID Defined in XML R
FAMILY_MEMBERS.CUSTOMER_ID Defined in XML R
GIFT_CARDS.CUSTOMER_ID Defined in XML R
INSTRUCTORS.CUSTOMER_ID Defined in XML R
INTEREST_LISTS.CUSTOMER_ID Defined in XML R
LEAGUE_CONTACTS.CUSTOMER_ID Defined in XML R
MEMBERSHIP_AUDIT_LOG.PRIMARYMEMBERCUSTOMER_ID Defined in XML R
MEMBERSHIP_USAGE.CUSTOMER_ID Defined in XML R
MEMBERSHIPS.CUSTOMER_ID Defined in XML R
MEMBERSHIPS.PRIMARY_MEMBER_CUSTOMER_ID Defined in XML R
OFFICIALS.CUSTOMER_ID Defined in XML R
PERMITS.CUSTOMER_ID Defined in XML R
POS_SALES_DETAILS.CUSTOMER_ID Defined in XML R
PRELIMINARY_DRAFTS.PAYER_CUSTOMER_ID Defined in XML R
PROGRAM_ATTENDANCE_HISTORY.DROP_OFF_CUSTOMER_ID Defined in XML R
PROGRAM_ATTENDANCE_HISTORY.PICK_UP_CUSTOMER_ID Defined in XML R
PROGRAM_REGISTRATIONS.CUSTOMER_ID Defined in XML R
PROGRAM_REGISTRATIONS.DROP_OFF_CUSTOMER_ID Defined in XML R
PROGRAM_REGISTRATIONS.PICK_UP_CUSTOMER_ID Defined in XML R
RECEIPT_HEADERS.ONLINE_CUSTOMER_ID Defined in XML R
RECEIPT_PAYMENTS.CUSTOMER_ID Defined in XML R
SAVED_CREDIT_CARD_HISTORY.CUSTOMER_ID Defined in XML R
SAVED_CREDIT_CARDS.CUSTOMER_ID Defined in XML R
SUPERVISORS.CUSTOMER_ID Defined in XML R
SYSTEM_USAGE_LOG.CUSTOMER_ID Defined in XML R
SYSTEM_USERS.CUSTOMER_ID Defined in XML R
TEAM_CONTACTS.CUSTOMER_ID Defined in XML R
TEAM_PLAYERS.CUSTOMER_ID Defined in XML R
TRANSACTIONS.CUSTOMER_ID Defined in XML R
UPLOADED_FILES.CUSTOMER_ID Defined in XML R
WISHLISTS.CUSTOMER_ID Defined in XML R
WISHLISTS.PARTICIPANT_CUSTOMER_ID Defined in XML R

Customer’s ID

LAST_PAYEE_ID int 4 null

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

CUSTOMER_FIRST_NAME varchar 255 null

Customer’s first name

CUSTOMER_LAST_NAME varchar 255 null

Customer’s last name

CUSTOMER_ADDRESS1 varchar 255 null

Customer’s address 1

CUSTOMER_ADDRESS2 varchar 255 null

Customer’s address 2

CITY varchar 255 null

Customer’s residential address city

STATE_PROVINCE varchar 255 null

Customer’s residential address province

ZIP_POSTALCODE varchar 255 null

Customer’s zip code

LATITUDE_NB numeric 11,6 null

The latitude of the customer’s address.

LONGITUDE_NB numeric 11,6 null

The longitude of the customer’s address.

HOMEPHONE varchar 255 null

Customer’s home phone

WORKPHONE varchar 255 null

Customer’s work phone

CELLPHONE varchar 255 null

Customer’s cell phone

FAXPHONE varchar 255 null

Customer’s fax phone

PAGERPHONE varchar 255 null

Customer’s pager phone

OTHERPHONE varchar 255 null

Customer’s other phone

CUSTOMER_EMAIL varchar 255 null

Customers email address

ENTRY_DATE datetime 16,3 null

The customer record creation date

CUSTOMER_GENDER varchar 255 null

Customer Gender (Male, Female, Other)

HEADOFHOUSEHOLD varchar 255 null

Whether the customer is the head of household

LAST_WAIVER_DATE datetime 16,3 null

The most recent date of sign a waiver

MAILING_ADDRESS1 varchar 255 null

Customers mailing address 1

MAILING_ADDRESS2 varchar 255 null

Customers mailing address 2

MAILING_CITY varchar 255 null

The city of the customer’s mailing address

MAILING_STATE_PROVINCE varchar 255 null

The state of the customer’s mailing address

MAILING_ZIP_POSTALCODE varchar 255 null

The zip code of the customer’s mailing address

MAILING_COUNTRY varchar 255 null

The country of the customer’s mailing address

MAILING_NAME varchar 255 null

The mailing name used on mail-outs and statements

RESIDENT_STATUS varchar 255 null

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

SPECIAL_HANDLING varchar 255 null

Whether the customer needs special handling (Yes or No)

EMERGENCY_CONTACT1_FIRST_NAME varchar 255 null

The first name of the customers emergency contact1

EMERGENCY_CONTACT1_LAST_NAME varchar 255 null

The last name of the customers emergency contact1

EMERGENCY_CONTACT1_PHONE_NO varchar 255 null

The phone number of the customers emergency contact1

EMERGENCY_CONTACT1_RELATION varchar 255 null

The customers relation to their emergency contact1

EMERGENCY_OTHER_PHONE1 varchar 255 null

The other phone number of the customers emergency contact1

EMERGENCY_CONTACT2_FIRST_NAME varchar 255 null

The first name of the customers emergency contact2

EMERGENCY_CONTACT2_LAST_NAME varchar 255 null

The last name of the customers emergency contact2

EMERGENCY_CONTACT2_PHONE_NO varchar 255 null

The phone number of the customers emergency contact2

EMERGENCY_CONTACT2_RELATION varchar 255 null

The customers relation to their emergency contact2

EMERGENCY_OTHER_PHONE2 varchar 255 null

The other phone number of the customers emergency contact2

DATE_MODIFIED datetime 16,3 null

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

RETIRED_STATUS varchar 255 null

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

NOT_ONLINE_ACTIVATED varchar 255 null

Whether the customer is activated on the CUI

LOGIN_CREATED datetime 16,3 null

Customers CUI account creation time and date

LOGIN_USED datetime 16,3 null

Customers most recent CUI login time and date

INTEREST_DATE datetime 16,3 null

The date on which the customers interest charge is calculated

COUNTY varchar 255 null

Customers county

CAN_BE_SCHEDULED varchar 255 null

Displays Yes or No

MIDDLE_NAME varchar 255 null

Customers middle name

RESIDENCY_EXPIRES_DATE datetime 16,3 null

Customers residency expiration date

LEGAL_NAME varchar 255 null

Customers legal name

ADDITIONAL_EMAIL varchar 255 null

Customers additional email address

LATE_FEE_DATE datetime 16,3 null

The date on which the customers late fee is calculated.

AGREE_RECEIVE_TEXT_MESSAGE varchar 255 null

Whether the customer agreed to receive text messages

CREATED_ON varchar 255 null

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

LAST_SYNC_TIME datetime 16,3 (getdate())

Date and time Hub record was last modified

ACTIVE_HUB_PROCESS_ID bigint 8 null

The Hub sync process ID

AGREE_RECEIVE_EMAIL varchar 5 null

Whether the customer agreed to receive emails

AGREE_RECEIVE_POSTAL_MAIL varchar 5 null

Whether the customer agreed to receive postal mail

MODIFIED_DATE_ONLY date 20 null

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

ENTRY_DATE_ONLY date 20 null

The customer record creation date

INTEREST_DATE_ONLY date 20 null

The date on which the customers interest charge is calculated

LAST_WAIVER_DATE_ONLY date 20 null

The most recent date of sign a waiver

LATE_FEE_DATE_ONLY date 20 null

The date on which the customers late fee is calculated.

LOGIN_CREATED_DATE_ONLY date 20 null

Customers CUI account creation time and date

LOGIN_USED_DATE_ONLY date 20 null

Customers most recent CUI login time and date

RESIDENCY_EXPIRES_DATE_ONLY date 20 null

Customers residency expiration date

CUSTOMER_GENERAL_ALERT varchar 2147483647 null

General alert text for this customer.

DATE_OF_BIRTH datetime 16,3 null

Customer’s date of birth.

ORG_ID int 4 null

Your organization’s unique identifier in the Active Net system

CUSTOMER_NOTES varchar 2147483647 null

General notes for this customer.

EXTERNALIDTEXT varchar 255 null

Customer’s external ID text.

COUNTRY varchar 255 null

Customer’s country of residence.

GRADEAGEDELTA int 4 null

Customer’s grade to age delta.

LOGIN_NAME varchar 255 null

Customer’s CUI login name.

BALANCE_DUE money 21,4 null

The current balance due for this customer.

PREFERRED_LANGUAGE varchar 20 null

The customer’s preferred language.

AGE_CATEGORY_ID int 4 null
AGE_CATEGORIES.AGE_CATEGORY_ID Defined in XML R

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

CUSTOMER_TITLE_ID int 4 null
CUSTOMER_TITLES.CUSTOMER_TITLE_ID Defined in XML R

The ID of the customer’s salutation.

CUSTOMER_TYPE_ID int 4 null
CUSTOMER_TYPES.CUSTOMER_TYPE_ID Defined in XML R

The ID of the customer’s type

GEOGRAPHIC_AREA_ID int 4 null
GEOGRAPHIC_AREAS.GEOGRAPHIC_AREA_ID Defined in XML R

The ID of the customer’s geographic area

GRADE_ID int 4 null
GRADES.GRADE_ID Defined in XML R

The ID of the customer’s current school grade.

OCCUPATION_ID int 4 null
OCCUPATIONS.OCCUPATION_ID Defined in XML R

The ID of the customer’s occupation

SITE_ID int 4 null
SITES.SITE_ID Defined in XML R

The ID of the site to which the customer belongs

HAS_ACTIVE_QUALIFIED_MEMBERSHIP varchar 5 null

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

ROW_VERSION binary 8 null

System timestamp (for internal use)

IS_PROSPECT varchar 5 null

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

IS_DROP_IN varchar 5 null

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

DROP_IN_EMAIL varchar 100 null

The email address of the drop-in customer if entered

LOGIN_FIRST_USED datetime 16,3 null

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

GENDER smallint 2 null

Indexes

Constraint Name Type Sort Column(s)
CUSTOMERS_PK Primary key Asc ACTIVE_HUB_KEY
CUSTOMERS_AGE_CATEGORY_ID_IX Performance Asc AGE_CATEGORY_ID
CUSTOMERS_CUSTOMER_GENDER_ZIP_POSTALCODE_IX Performance Asc/Asc CUSTOMER_GENDER + ZIP_POSTALCODE
CUSTOMERS_CUSTOMER_ID_ORG_ID_UQ Must be unique Asc/Asc CUSTOMER_ID + ORG_ID
CUSTOMERS_CUSTOMER_TITLE_ID_IX Performance Asc CUSTOMER_TITLE_ID
CUSTOMERS_CUSTOMER_TYPE_ID_IX Performance Asc CUSTOMER_TYPE_ID
CUSTOMERS_GEOGRAPHIC_AREA_ID_IX Performance Asc GEOGRAPHIC_AREA_ID
CUSTOMERS_GRADE_ID_IX Performance Asc GRADE_ID
CUSTOMERS_OCCUPATION_ID_IX Performance Asc OCCUPATION_ID
CUSTOMERS_ROW_VERSION_IX Performance Asc ROW_VERSION
CUSTOMERS_SITE_ID_IX Performance Asc SITE_ID

Relationships