Schools Data Dictionary

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.

• Column Header Definitions

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