The Schools database table is global, meaning that Schools data is stored in a singular table for all years. Changes to global fields in one year will carry across all years.
| Table Name | Field Name | Description | Default Value | Is Nullable | Data Type | Char Limit |
|---|---|---|---|---|---|---|
| schools | abbr | Abbreviation assigned by the organization for each school | yes | varchar | 100 | |
| schools | address | School street address | yes | varchar | 100 | |
| schools | address2 | School street address line 2 | yes | varchar | 50 | |
| schools | city | School city | yes | varchar | 50 | |
| schools | created_at | Date and time the school record was created | yes | datetime | ||
| schools | description | School information displayed during application and registration processes | yes | text | 65535 | |
| schools | id | Unique ID assigned by the system to each school | int | |||
| schools | lat | School address latitude assigned by the Geocode service | yes | decimal | ||
| schools | legacy_id | Unique ID from the legacy system that corresponds to the same field in Enroll | yes | int | ||
| schools | lng | School address longitude assigned by the Geocode service | yes | decimal | ||
| schools | organization_id | Unique ID assigned to each Enroll customer | int | |||
| schools | phone | School phone | yes | varchar | 25 | |
| schools | school_code | Unique ID assigned by the organization for each school (SIS School ID) | yes | varchar | 20 | |
| schools | school_group_id | Unique ID assigned to each School Group | 0 | |||
| schools | school_name | Name assigned by the organization for each school | yes | varchar | 255 | |
| schools | state | School state | yes | varchar | 50 | |
| schools | sync_connection_id | Unique ID assigned to a sync connection for each school | yes | |||
| schools | updated_at | Most recent date and time the school record was updated | yes | |||
| schools | website | School's external website | yes | varchar | 255 | |
| schools | zip | School zip | yes | varchar | 50 |
Column Header Definitions
- Table Name: Name of database table displayed in Enroll when selecting fields
- Field Name: Name of field displayed in Enroll when selecting fields
- Description: What data is stored in the field
- Default Value: Value automatically assigned by the system as a starting value
- Is Nullable: Field is permitted to have a NULL value
- Data Type:
- datetime: stores date and time as YYYY-MM-DD HH:MM:SS using 24 hour clock
- decimal: stores numerical data and performs calculations with precise decimal values
- double: a way to store decimal numbers with a higher degree of precision
- enum: enumerated, a set of named values (ex: offered, waiting)
- int: integer, whole numbers like 155, 0, -20, supports a large range
- json: text based format that stores/transmits data to be displayed on a web page
- text: variable length data that supports a large maximum length
- time: stores time of day as HH:MM:SS using 24 hour clock
- timestamp: stores date and time as YYYY-MM-DD HH:MM:SS using 24 hour clock
- tinyint: small range of integers
- varchar: variable length character that supports alphanumeric values
- Char Limit: Character limit on the field that cannot be exceeded
Comments
0 comments
Article is closed for comments.