Table: dim_account

Type: Dimension Columns: 13

Description

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

Columns

Column Name Type Description
account_id string

Unique identifier for the account

business_id string

Unique identifier for the business

school_id string

Unique identifier for the school

account string

The name of the account assigned by the school or business

enrollment_status string

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 string

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

primary_payment_method_status string

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

billing_history_url string

Billing history URL for the account

enrollment_url string

Enrollment URL for the account

business_unit_id string

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

primary_contacts string

Contact information list for primary contacts for the account

data_current_as_of_utc timestamp[ns] No description provided.
source_type string No description provided.