School Annual Data Dictionary

The School Annual database table is annual, meaning that School Annual data is stored in a unique table for each year (school_annual_2025.id, school_annual_2024.id, etc.).

• Column Header Definitions

Table Name	Field Name	Field Description	Default Value	Is Nullable	Data Type	Char Limit
school_annual	created_at	Date and time the school was created		yes	datetime
school_annual	eligibility_rule_id	Unique ID assigned to the eligibility rule for the school		yes	int
school_annual	eligibility_status_indicator	Indicator to show registration eligibility status on guardian dashboard (Yes = 1, No = 0)	1		tinyint
school_annual	enabled	Indicates if school is enabled (Enabled =1, Disabled = 0)	1		tinyint
school_annual	enroll_close_date	School-specific close dates for new student registration		yes	datetime
school_annual	enroll_complete_email_snippet	Confirmation email sent to families upon submitting new student registration		yes	varchar	255
school_annual	enroll_form_process_id	Unique ID assigned to each registration form process for the school		yes	int
school_annual	enroll_open_date	Date and time when new registration window opens (only if school-specific setting is used)		yes	datetime
school_annual	enroll_open_dates	School setting that determines which date option is configured for new registrations (Global Lottery Settings = Default, Custom = School)	default		varchar	15
school_annual	enrollgrades	Grades open for new and returning student registration		yes	json
school_annual	id	Unique ID assigned by the system to each school annually			int
school_annual	legacy_id	Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
school_annual	level_id	Unique ID assigned to the school level for each school	0		int
school_annual	organization_id	Unique ID assigned to each Enroll customer			int
school_annual	polygon_data	Boundary(ies) assigned to the school		yes	json
school_annual	previous_year_id	Unique ID assigned to the previous year for the purposes of rollover		yes	int
school_annual	reenroll_close_date	School-specific close dates for returning student registration		yes	datetime
school_annual	reenroll_complete_email_snippet	Confirmation email sent to families upon submitting returning student registration		yes	varchar	255
school_annual	reenroll_open_date	Date and time when returning re-registration window opens (only if school-specific setting is used)		yes	datetime
school_annual	reenroll_open_dates	School setting that determines which date option is configured for returning re-registrations (Global Lottery Settings = Default, Custom = School)	default		varchar	15
school_annual	school_id	Unique ID assigned by the system to each school			int
school_annual	updated_at	Most recent date and time the school was updated		yes	datetime

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
  • 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