Appeals Data Dictionary

The Appeals database table is annual, meaning that Appeals data is stored in a unique table for each year (appeals_2025.id, appeals_2024.id, etc.). 

• Column Header Definitions

Table Name	Field Name	Description	Default Value	Is Nullable	Data Type	Char Limit
appeals	active	The most recent appeal for an application (Yes = 1, No = 0)	0		tinyint
appeals	appeal_attempt	Number of attempts a guardian has taken to appeal			int
appeals	appeal_form_process_id	Unique ID assigned to each appeal form			int
appeals	appeal_rule	Condition that is met to trigger an appeal (Values: application_ineligible, application_waitlisted, application_autodeclined)		yes	varchar	255
appeals	application_id	Unique ID assigned to each application		yes	int
appeals	approved_timestamp	Date/time appeal was approved by admin		yes	datetime
appeals	created_at	Date and time the appeal record is created		yes	timestamp
appeals	denied_timestamp	Date/time appeal was denied by admin		yes	datetime
appeals	form_process_id	The application form process associated with the appealUnique id assigned to each appeal record			int
appeals	id	Unique id assigned to each appeal record			int
appeals	organization_id	Unique ID assigned to each Enroll customer			int
appeals	status	Appeal Status (Pending = -1, Approved = 1, Denied = 0)	-1		int
appeals	student_id	Unique ID assign to each student by Enroll system (not SIS student id)			int
appeals	submitted	Submission Status (Not Submitted = 0, Submitted = 1)	0		tinyint
appeals	submitted_timestamp	Date/time appeal was submitted by guardian		yes	datetime
appeals	updated_at	Most recent date and time the appeals record was updated		yes	timestamp

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