School Groups Data Dictionary

The School Groups database table is global, meaning that School Groups data is stored in a singular table for all years. Changes to global fields in one year will carry across all years.

• Column Header Descriptions

Table Name	Field Name	Description	Default Value	Is Nullable	Data Type	Char Limit
school_groups	code	Unique ID assigned by the organization for each school group		yes	varchar	20
school_groups	created_at	Date and time the school group was created		yes	datetime
school_groups	id	Unique ID assigned by the system to each school group			int
school_groups	legacy_id	Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
school_groups	name	Name assigned by the organization for each school group		yes	varchar	255
school_groups	organization_id	Unique ID assigned to each Enroll customer			int
school_groups	polygon_name	Boundary assigned to the school group		yes	varchar	255
school_groups	reenroll_rule_id	Unique ID assigned to the re-registration rule for the school group		yes	int
school_groups	updated_at	Most recent date and time the school group was updated		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