Lottery Rankings Data Dictionary

The Lottery Rankings database table is annual, meaning that Lottery Rankings data is stored in a unique table for each year (lottery_rankings_2025.id, lottery_rankings_2024.id, etc.).

• Column Header Definitions

Table Name	Field Name	Field Description	Default Value	Is Nullable	Data Type	Char Limit
lottery_rankings	accepted	Lottery Status (Accepted = 1, Declined = 0, Pending = -1)	-1		tinyint
lottery_rankings	accepted_declined_by	Who accepts or declines a lottery seat: (Parent = P, Admin = A, System = S)		yes	enum	1
lottery_rankings	active	If lottery run is active (Yes = 1, No = 0)	0		tinyint
lottery_rankings	application_id	Unique ID assigned to each application		yes	int
lottery_rankings	created_at	Date and time the lottery list (or pool) is created		yes	datetime
lottery_rankings	cutoff	Number of seats per program/grade to be filled in a lottery run		yes	int
lottery_rankings	grade	Grade student is applying to		yes	varchar	25
lottery_rankings	group	Numerical ID for the lottery group where application is placed as a result of the lottery run		yes	int
lottery_rankings	subgroup	Numerical ID for the lottery subgroup where application is placed as a result of the lottery run		yes	int
lottery_rankings	id	Unique ID assigned to each application during each lottery run			int
lottery_rankings	legacy_id	Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
lottery_rankings	rank_adjusted	Current Waiting List number		yes	int
lottery_rankings	lottery_entries	Number of entries in a tiered lottery associated with the highest priority assigned to the application after the lottery run		yes	int
lottery_rankings	lottery_list	Offered list or Waiting list. Blank value is a Not Placed application (not yet run through a lottery)		yes	enum	7
lottery_rankings	lottery_run_id	Unique ID assigned to each lottery run		yes	int
lottery_rankings	manual_addition	Indicates if an application has been added to the lottery list as a result of the auto-add post lottery setting (Yes = 1, No = 0)	0		tinyint
lottery_rankings	manual_indicator	Indicator set when an Admin manually adjusts the placement of a student on the lottery list (Manually Moved = 1, Not Manually Moved = 0)	0		tinyint
lottery_rankings	notified	Indicator that an email notification was sent to Guardian with lottery result (Notified = 1, Not Notified = 0)	0		tinyint
lottery_rankings	notified_offered	Indicator that an email notification was sent to Guardian that student is placed on Offered list (Notified = 1, Not Notified = 0)	0		tinyint
lottery_rankings	organization_id	Unique ID assigned to each Enroll customer			int
lottery_rankings	pool	Numerical value assigned to the batch of applications run together in a lottery		yes	int
lottery_rankings	previous_year_id	Unique ID assigned to the previous year for the purposes of rollover		yes	int
lottery_rankings	previous_accepted	Lottery status visible to guardians that does not reflect update made by admin who selected "Do Not Notify Guardians" (Accepted = 1, Declined = 0, Pending = -1). Value is blank when lottery or recent update is published to guardians.		yes	tinyint
lottery_rankings	previous_lottery_list	Lottery list (Offered or Waiting) visible to guardians that does not reflect update made by admin who selected "Do Not Notify Guardians". Value is blank when lottery or recent update is published to guardians.		yes	enum
lottery_rankings	previous_rank	Position on the waiting list visible to guardians that does not reflect a recent update made by admin who selected "Do Not Notify Guardians". Value is blank when lottery or recent update is published to guardians.		yes	int
lottery_rankings	published	Indicator that the lottery result was published to Guardians (Published = 1, Not Published = 0)	0		tinyint
lottery_rankings	rank	Dynamic number representing student's overall position on the lottery list (incl. offered + waiting)		yes	int
lottery_rankings	rank_original	Original lottery ranking at lottery execution		yes	int
lottery_rankings	reason_auto_decline	Reason saved when system auto-declines a lottery seat		yes	varchar	255
lottery_rankings	reg_timestamp_expire	Date and time that the system will enforce Registration Submitted expiration deadline and auto decline the seat		yes	datetime
lottery_rankings	score	In a score-based lottery, the sequential number that drives lottery placement		yes	double
lottery_rankings	sublottery	Numerical value associated with the sub-lottery for the highest priority assigned to the application after the lottery run		yes	int
lottery_rankings	sublottery_original	Numerical value associated with the sub-lottery for the highest priority assigned to the application during the lottery run		yes	int
lottery_rankings	timestamp_accepted	Date and time when application is moved to the Offered list		yes	datetime
lottery_rankings	timestamp_accepted_declined	Date and time when guardian or admin accepts or declines a lottery seat		yes	datetime
lottery_rankings	timestamp_expire	Date and time that the system will enforce offer expiration deadline and auto decline the seat		yes	datetime
lottery_rankings	timestamp_notified	Date and time that email notification was sent to Guardian with lottery result		yes	datetime
lottery_rankings	timestamp_notified_offered	Date and time that email notification was sent to Guardian with Offered placement		yes	datetime
lottery_rankings	timestamp_placed	Date/time application was initially placed on the lottery list (offered or waiting)		yes	datetime
lottery_rankings	updated_at	Most recent date and time subsequent lottery pools are run		yes	datetime
lottery_rankings	weight	Numerical value associated with the weight for the highest priority assigned to the application in a weighted lottery after the lottery run	1		int
lottery_rankings	weight_original	Numerical value associated with the weight for the highest priority assigned to the application in a weighted lottery during the lottery run	1		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
  • 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