Student Annual Data Dictionary

The Student Annual database table is annual, meaning that Student Annual data is stored in a unique table for each year (student_annual_2025.id, student_annual_2024.id, etc.).

• Column Header Definitions

Table Name	Field Name	Description	Default Value	Is Nullable	Data Type	Char Limit
student_annual	address	Student's primary street address		yes	varchar	100
student_annual	address_lat	Student address latitude assigned by the Geocode service		yes	decimal
student_annual	address_lng	Student address longitude assigned by the Geocode service		yes	decimal
student_annual	address_status	Geocode service has been run for this student's address. Values: Verified or Unverified	unverified		enum	10
student_annual	address2	Student's primary street address line 2		yes	varchar	100
student_annual	city	Student's primary street address city		yes	varchar	50
student_annual	city_other	Student's city entered in "Other" field		yes	varchar	50
student_annual	confirmation_number	Application confirmation number (rarely used)		yes	varchar	15
student_annual	created_at	Date and time the student record was created		yes	datetime
student_annual	emergency1_contact_id	Emergency Contact #1 SIS Contact ID		yes	int
student_annual	emergency1_name	Emergency Contact #1 Name		yes	varchar	100
student_annual	emergency1_phone	Emergency Contact #1 Phone		yes	varchar	25
student_annual	emergency1_relation	Emergency Contact #1 Relationship		yes	varchar	100
student_annual	emergency2_contact_id	Emergency Contact #2 SIS Contact ID		yes	int
student_annual	emergency2_name	Emergency Contact #2 Name		yes	varchar	100
student_annual	emergency2_phone	Emergency Contact #2 Phone		yes	varchar	25
student_annual	emergency2_relation	Emergency Contact #2 Relationship		yes	varchar	100
student_annual	emergency3_contact_id	Emergency Contact #3 SIS Contact ID		yes	int
student_annual	emergency3_name	Emergency Contact #3 Name		yes	varchar	100
student_annual	emergency3_phone	Emergency Contact #3 Phone		yes	varchar	25
student_annual	emergency3_relation	Emergency Contact #3 Relationship		yes	varchar	100
student_annual	grade	Student's grade applying to		yes	varchar	25
student_annual	grade_previous	Student's grade in the previous school year		yes	varchar	25
student_annual	guardian1_address	Guardian #1 Address		yes	varchar	100
student_annual	guardian1_address2	Guardian #1 Address Line 2		yes	varchar	50
student_annual	guardian1_city	Guardian #1 City		yes	varchar	50
student_annual	guardian1_city_other	Guardian #1 City in "Other" field		yes	varchar	50
student_annual	guardian1_contact_id	Guardian #1 SIS Contact ID		yes	int
student_annual	guardian1_email	Guardian #1 Email		yes	varchar	255
student_annual	guardian1_employer	Guardian #1 Employer		yes	varchar	100
student_annual	guardian1_fname	Guardian #1 First Name		yes	varchar	50
student_annual	guardian1_lname	Guardian #1 Last Name		yes	varchar	50
student_annual	guardian1_phone	Guardian #1 Primary Phone		yes	varchar	25
student_annual	guardian1_phone2	Guardian #1 Phone 2		yes	varchar	25
student_annual	guardian1_state	Guardian #1 State		yes	varchar	50
student_annual	guardian1_work_address	Guardian #1 Work Address		yes	varchar	100
student_annual	guardian1_work_address2	Guardian #1 Work Address Line 2		yes	varchar	50
student_annual	guardian1_work_city	Guardian #1 Work City		yes	varchar	50
student_annual	guardian1_work_phone	Guardian #1 Work Phone		yes	varchar	25
student_annual	guardian1_work_state	Guardian #1 Work Address State		yes	varchar	50
student_annual	guardian1_work_zip	Guardian #1 Work Zip		yes	varchar	15
student_annual	guardian1_zip	Guardian #1 Zip		yes	varchar	15
student_annual	guardian2_address	Guardian #2 Address		yes	varchar	100
student_annual	guardian2_address2	Guardian #2 Address Line 2		yes	varchar	50
student_annual	guardian2_city	Guardian #2 City		yes	varchar	50
student_annual	guardian2_city_other	Guardian #2 City in "Other" field		yes	varchar	50
student_annual	guardian2_contact_id	Guardian #2 SIS Contact ID		yes	int
student_annual	guardian2_email	Guardian #2 Email		yes	varchar	255
student_annual	guardian2_employer	Guardian #2 Employer		yes	varchar	100
student_annual	guardian2_fname	Guardian #2 First Name		yes	varchar	50
student_annual	guardian2_lname	Guardian #2 Last Name		yes	varchar	50
student_annual	guardian2_phone	Guardian #2 Primary Phone		yes	varchar	25
student_annual	guardian2_phone2	Guardian #2 Phone 2		yes	varchar	25
student_annual	guardian2_state	Guardian #2 State		yes	varchar	50
student_annual	guardian2_work_address	Guardian #2 Work Address		yes	varchar	100
student_annual	guardian2_work_address2	Guardian #2 Work Address Line 2		yes	varchar	50
student_annual	guardian2_work_city	Guardian #2 Work City		yes	varchar	50
student_annual	guardian2_work_phone	Guardian #2 Work Phone		yes	varchar	25
student_annual	guardian2_work_state	Guardian #2 Work Address State		yes	varchar	50
student_annual	guardian2_work_zip	Guardian #2 Work State		yes	varchar	15
student_annual	guardian2_zip	Guardian #2 Zip		yes	varchar	15
student_annual	id	Unique ID assigned by the system to each student annually			int
student_annual	last_import	Date record was last updated by SIS import		yes	date
student_annual	legacy_id	Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
student_annual	lottery_number	Pre-assigned lottery number per student to be used in the lottery run		yes	int
student_annual	organization_id	Unique ID assigned to each Enroll customer			int
student_annual	promoted	If the student will skip a grade upon Rollover (Yes = 1, No = 0)	0		tinyint
student_annual	reside	With whom the applicant lives		yes	varchar	50
student_annual	retained	If the student will remain in the same grade upon Rollover (Yes = 1, No = 0)	0		tinyint
student_annual	school_previous_id	ID for the student's school in the previous school year		yes	text	65535
student_annual	school_previous_id_other	Student's school in the previous school year if input as "Other"		yes	text	65535
student_annual	siblings	Indicator if any number of Siblings Attending is entered in the application (Yes = 1, No = 0)		yes	tinyint
student_annual	sis_enroll_status	Enrollment status of student in the SIS (-1 = Pre-registered, 0 = Active, 1 = Inactive, 2 = Transferred Out, 3 = Graduated, 4 = Imported Historical)		yes	varchar	25
student_annual	sis_entry_date	Student's SIS entry date set by organization		yes	date
student_annual	sis_exit_date	Student's SIS exit date set by organization		yes	date
student_annual	state	Student's primary street address state		yes	varchar	25
student_annual	student_id	Unique id assign to each student by Enroll system (not SIS student id)			int
student_annual	type	Attribute that indicates if the student is new or returning to the organization	new		enum	9
student_annual	updated_at	Most recent date and time that the student record was updated		yes	datetime
student_annual	zip	Student's primary street address zip		yes	varchar	15
student_annual	zone_district_id	Student's zoned district based on address and boundary, if in use		yes	int
student_annual	zone_school_id	Student's zoned school based on address and boundary, if in use		yes	int
student_annual	zone2_school_id	Student's second zoned district based on address and boundary, if in use		yes	int

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