Registrations Data Dictionary

The Registrations database table is annual, meaning that Registrations data is stored in a unique table for each year (registrations_2025.id, registrations_2024.id, etc.).

• Column Header Definitions

Table Name	Field Name	Description	Default Value	Is Nullable	Data Type	Char Limit
registrations	created_at	Date and time the registration record was created		yes	timestamp
registrations	id	Unique ID assigned to each registration			int
registrations	is_from_lottery	Indicator that a registration is a result of a lottery (Yes = 1, No = 0)	0		tinyint
registrations	maxstep	Numeric value to indicate maximum step reached in registration form	0		int
registrations	organization_id	Unique ID assigned to each Enroll customer			int
registrations	previous_year_id	Unique ID assigned to the previous year for the purposes of rollover		yes	int
registrations	school_id	Unique ID assigned to each school		yes	int
registrations	sis_error	Reason provided in sync service when error occurs		yes	varchar	512
registrations	sis_export_status	Status of registration record export (Succeeded, Partial Sync, In Progress, Pending, Failed)		yes	enum	17
registrations	sis_export_timestamp	Date/time of most recent registration record export		yes	timestamp
registrations	status	Registration Status (In Processing = -1, Approved = 1, Denied = 0)	-1		tinyint
registrations	status_timestamp	Date/time registration status was last changed		yes	datetime
registrations	steps_metadata	Indicates that a step was completed and will display green checkmark		yes	json
registrations	student_id	Unique ID assign to each student by Enroll system (not SIS student id)	0		int
registrations	submitted	Registration Submitted (Submitted = 1, Not Submitted = 0)	0		tinyint
registrations	submitted_timestamp	Date/time registration was submitted		yes	datetime
registrations	type	Registration type (enroll = new registration, reenroll = returning registration)		yes	enum	8
registrations	updated_at	Most recent date and time the registration record was updated		yes	timestamp
registrations	withdrawn	Withdrawn Status (Withdrawn = 1, Not Withdrawn = 0)	0		tinyint
registrations	withdrawn_reason	Reason registration is withdrawn (provided by Guardian or Admin)		yes	text	65535
registrations	withdrawn_timestamp	Date/time registration was withdrawn		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