Students Data Dictionary

The Students database table is global, meaning that Students 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
students	created_at	Date and time the student record was created		yes	datetime
students	dob	Student's birthdate		yes	date
students	fname	Student's first name		yes	varchar	100
students	gender	Student's gender		yes	varchar	50
students	id	Unique ID assigned by the system to each student			int
students	last_import	Most recent date and time a student record was imported through sync service or the migration script		yes	date
students	legacy_id	Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
students	lname	Student's last name		yes	varchar	100
students	mname	Student's middle name		yes	varchar	100
students	organization_id	Unique ID assigned to each Enroll customer			int
students	race	Student's race		yes	json
students	race_other	Student's race in "Other" field		yes	varchar	100
students	sis_missing	Value assigned to student when imported via sync service (Yes=1, No=0)	0		tinyint
students	sis_school_year	School year based on the sis_entry_date		yes	int
students	sis_unique_key	Optional unique ID used as an additional identifier for a student in Sync Service		yes	varchar	50
students	ssn	Student's social security number		yes	varchar	50
students	state_unique_key	Unique ID assigned to a student by some SIS providers		yes	varchar	50
students	student_district_id	Unique ID assigned by the district for each student		yes	varchar	50
students	sync_connection_id	Unique ID assigned to sync connection that was used in the most recent import of this student		yes	int
students	updated_at	Most recent date and time that the student record 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
  • 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