Lottery Runs Data Dictionary

The Lottery Runs database table is annual, meaning that Lottery Runs data is stored in a unique table for each year (lottery_runs_2025.id, lottery_runs_2024.id, etc.).

• Column Header Definitions

Table Name	Field Name	Field Description	Default Value	Is Nullable	Data Type	Char Limit
lottery_runs	active	Numerical value indicating if the corresponding lottery pool is active (Active = 1, Inactive = 0)	1		tinyint
lottery_runs	batch	Unique alphanumeric ID assigned to the programs included in the lottery run		yes	varchar	100
lottery_runs	created_at	Date and time the lottery run was executed		yes	datetime
lottery_runs	cutoffs	Cutoff numbers, by grade, used at the time of the most recent lottery run		yes	json
lottery_runs	cutoffs_original	Cutoff numbers, by grade, used at the time of lottery run for each pool		yes	json
lottery_runs	datetime_run	Date/time this lottery run occurred		yes	datetime
lottery_runs	finished	Indicator that a lottery run is finished (Finished = 1)	0		tinyint
lottery_runs	grades	Grades included in this lottery run		yes	json
lottery_runs	user_id	User ID of the individual who clicked the Run Lottery button	0		int
lottery_runs	id	Unique ID assigned to each lottery run			int
lottery_runs	legacy_id	Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
lottery_runs	organization_id	Unique ID assigned to each Enroll customer			int
lottery_runs	pool	A batch of applications run through a lottery		yes	int
lottery_runs	previous_year_id	Unique ID assigned to the previous year for the purposes of rollover		yes	int
lottery_runs	program_id	Unique ID assigned to each program	0		int
lottery_runs	run_settings	Settings used at the time of lottery execution for the most recent pool		yes	json
lottery_runs	updated_at	Most recent date and time that lottery pools are run		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