Context School Rankings is compiled using two inputs: Precisely boundary polygons and commuter score data inputs. Boundary polygons and commuter score data inputs are both refreshed on a quarterly basis.
The structure of the Context School Rankings data schema workbook changed in this release. Changes include renaming and re-ordering existing columns, as well as the addition of several new columns. Additionally, all CHAR and VARCHAR data types are now represented as TEXT, and data type and field length are represented in two separate columns.
The following columns were added to the schema workbook:
- product_table_name
- index
- primary_key
- type_code
- table_name
- grouping
Refer to the Notices tab in the schema workbook for additional information.
The following column name changes were made in the schema workbook:
| Former Column Name | New Column Name |
| Table Name | table_friendly_name |
| Seq. | sequence_number |
| Field Name | field_name |
| Field Value Key Reference | field_value_key_reference |
| Description | description |