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