Recommendations Data Dictionary

The Recommendations database table is annual, meaning that Recommendations data is stored in a unique table for each year (recommendations_2025.id, recommendations_2024.id, etc.).

• Column Header Definitions

Table Name	Field Name	Description	Default Value	Is Nullable	Data Type	Char Limit
recommendations	comments	"Comments" question on Recommendation form		yes	varchar	512
recommendations	created_at	Date and time the recommendation was created		yes	timestamp
recommendations	entity_ids	Programs associated with the Recommendation		yes	json
recommendations	form_process_id	Unique ID assigned to the application form process used for this recommendation	0		int
recommendations	form_step_id	Unique ID assigned to the step in the application that contains the Recommendations field type	0		int
recommendations	id	Unique ID assigned by the system to each recommendation			bigint
recommendations	organization_id	Unique ID assigned to each Enroll customer			int
recommendations	previous_year_id	Unique ID assigned to the previous year for the purposes of rollover		yes	int
recommendations	recommendation_form_process_id	Unique ID assigned to the recommendation form process	0		int
recommendations	recommended	"Overall Recommendation" question on Recommendation form		yes	text	65535
recommendations	recommender_email	Email of requested recommender		yes	text	65535
recommendations	recommender_message	Message given by family to the requested recommender		yes	text	65535
recommendations	recommender_name	Name of requested recommender		yes	text	65535
recommendations	requested_timestamp	Date/time recommendation was submitted by family (same as the application submission timestamp)		yes	datetime
recommendations	sent	Indicator that an email request was sent to the Recommender (Notified = 1, Not Notified = 0)	0		tinyint
recommendations	status	Recommendation Status (Declined = -2, Pending = -1, Complete = 1, Past Due = 0)	-1		tinyint
recommendations	student_id	Unique ID assigned to each student	0		int
recommendations	submitted	Submission Status (Not Submitted = 0, Submitted = 1)	0		tinyint
recommendations	submitted_timestamp	Date/time recommendation was submitted by recommender		yes	datetime
recommendations	token_id	Token linked to this recommendation record	0		int
recommendations	updated_at	Most recent date and time the recommendation is 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