Description
School information. The data grain is school level information within a business.
Columns
| Column Name | Description |
|---|---|
school_id |
Unique identifier for the school |
business_id |
Unique identifier for the business |
school |
The name of the school |
school_country |
The country where the school is located |
school_state |
The state where the school is located |
school_city |
The city where the school is located |
school_postal_code |
The postal code of the school's address |
school_address |
The first line of the school's address |
school_timezone |
The time zone that the school is located in |
school_phone_number |
The phone number of the school |
school_email |
The email address of the school |
is_school_deactivated |
Indicates whether the school is currently deactivated; enumerated: 'Yes' or 'No' |
school_external_id |
The external ID associated with the school, typically assigned by the business |
school_tax_id |
The taxpayer identification number associated with the school |
business |
The name of the business |
school_key_int |
Surrogate key integer corresponding to school_id (not unique) |
school_tags |
The school tags assigned to the school |
business_unit_id |
The business unit identifier assigned to the school |