Applications Data Dictionary

The Applications database table is annual, meaning that Application data is stored in a unique table for each year (applications_2025.id, applications_2024.id, etc.).

• Column Header Definitions

Table Name	Field Name	Description	Default Value	Is Nullable	Data Type	Char Limit
applications	admin_added	Application added by admin (Yes = 1, No = 0)	0		tinyint
applications	choice_rank	Ranking of this application across a student's program choices	0		int
applications	created_at	Date and time the application record was created		yes	datetime
applications	id	Unique ID assigned to each application			int
applications	last_saved	Date/time application was last saved, not necessarily updated		yes	datetime
applications	legacy_id	INTERNAL ONLY: Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
applications	lottery_entries	Number of entries in a tiered lottery associated with the highest priority assigned to the application before the lottery run	1		int
applications	lottery_group	Numerical ID for the lottery group where application will be placed	0	yes	varchar	100
applications	lottery_number	Pre-assigned lottery number per application to be used in the lottery run		yes	int
applications	lottery_subgroup	Numerical ID for the lottery subgroup where application will be placed	0	yes	varchar	100
applications	lottery_sublottery	Numerical value associated with the sub-lottery for the highest priority assigned to the application before the lottery run		yes	int
applications	lottery_weight	Numerical value associated with the weight for the highest priority assigned to the application before the lottery run	1		int
applications	organization_id	Unique ID assigned to each Enroll customer			int
applications	previous_year_id	Unique ID assigned to the previous year for the purposes of rollover		yes	int
applications	program_id	Unique ID assigned to each program		yes	int
applications	status	Eligibility Status (Eligible = 1, Ineligible = 0, In Processing = -1)	-1		int
applications	status_timestamp	Date/time application eligibility status was last changed by admin		yes	datetime
applications	student_id	Unique ID assign to each student by Enroll system (not SIS student id)	0		int
applications	submitted	Submission Status (Not Submitted = 0, Submitted = 1)	0		tinyint
applications	submitted_timestamp	Date/time application was submitted		yes	datetime
applications	updated_at	Most recent date and time the application record was updated		yes	datetime
applications	withdrawn	Withdrawn Status (Withdrawn = 1, Not Withdrawn = 0)	0		tinyint
applications	withdrawn_reason	Reason provided by guardian or admin why application was withdrawn		yes	text	65535

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