Description
Customer information. The data grain is individual customers within a school.
Columns
| Column Name | Description |
|---|---|
customer_id |
Unique identifier for the customer |
customer |
The name of the account or customer (the later uses email) |
enrollment_status |
The current enrollment status for the customer; enumerated: 'Active Enrollment' (a student on this account has at least one active enrollment), 'Scheduled Future Enrollment' (no student on this account has an active enrollment but has at least one student with a future enrollment), 'Completed Enrollment' (no student on this account has any active or future enrollments but has at least one student with an expired enrollment), 'No Enrollment' (no student on this account has ever been Enrolled) , 'No Enrollment (No Account)' (no student on this account has ever been Enrolled and an account has not been created for this customer)' |
school_id |
Unique identifier for the school |
business_id |
Unique identifier for the business |
itemized_bill_url |
Itemized bill URL associated with the account |
billing_history_url |
Billing history URL associated with the account |
primary_contacts |
Contact information list for primary contacts for the customer |
slicer_customer_key |
A key for grouping customers with the same name together; connects to dim_slicer_customer |