Programs Data Dictionary

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

• Column Header Definitions

Table Name	Field Name	Description	Default Value	Is Nullable	Data Type	Char Limit
programs	abbreviation	Abbreviation assigned by the organization for each program		yes	varchar	25
programs	category_id	Unique ID assigned by the system to each category for this program		yes	int
programs	created_at	Date and time the program record was created		yes	datetime
programs	id	Unique ID assigned by the system to each program			int
programs	legacy_id	Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
programs	organization_id	Unique ID assigned to each Enroll customer			int
programs	ext_auth_group	SSO Program Access Identifier		yes	varchar	100
programs	school_id	Unique ID assigned by the system to each school for this program		yes	int
programs	title	Name assigned by the organization to each program		yes	varchar	255
programs	updated_at	Most recent date and time the program record 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