Table: dim_account

Type: Dimension Columns: 11

Description

Account information. The data grain is individual accounts within a school.

Columns

Column Name Description
account_id

Unique identifier for the account

business_id

Unique identifier for the business

school_id

Unique identifier for the school

account

The name of the account assigned by the school or business

enrollment_status

The current enrollment status for the account; 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)

auto_pay_status

Indicates whether auto-pay is currently enabled for the account; enumerated: 'Enabled' or 'Not Enabled'

primary_payment_method_status

Indicates whether the account currently has primary payment method set up; enumerated: 'Set' or 'Not Set'

billing_history_url

Billing history URL for the account

enrollment_url

Enrollment URL for the account

business_unit_id

Unique identifier for the latest business unit the account is associated with.

primary_contacts

Contact information list for primary contacts for the account