The Program Annual database table is annual, meaning that Program Annual data is stored in a unique table for each year (program_annual_2025.id, program_annual_2024.id, etc.).
| Table Name | Field Name | Field Description | Default Value | Is Nullable | Data Type | Char Limit |
|---|---|---|---|---|---|---|
| program_annual | acceptgrades | The grades served at this program | yes | json | ||
| program_annual | application_eligibility_status_change_email | Email sent to guardian when application eligibility status is changed | yes | varchar | 255 | |
| program_annual | application_submit_status_emails_notification | Email address(s) of admin to receive a notification when application is submitted | yes | json | ||
| program_annual | auto_decline_exclude_weekends | Program-specific setting to exclude weekends when using auto-decline/offer expiration | 0 | tinyint | ||
| program_annual | close_date | Program-specific close dates for application | yes | datetime | ||
| program_annual | complete_email_snippet | Name of notification template to be sent to guardians upon application submission | yes | varchar | 255 | |
| program_annual | created_at | Date and time the program was created | yes | datetime | ||
| program_annual | open_dates | Dates open for this program's application | default | enum | 7 | |
| program_annual | eligibility_rule_id | Unique ID assigned by the system to the eligibility rule for this program | yes | int | ||
| program_annual | eligibility_status_indicator | Setting to indicate if eligibility status on guardian dashboard is enabled (Yes = 1, No = 0) | 1 | tinyint | ||
| program_annual | emailto | Admin email address(es) receiving notification of lottery acceptance or decline | yes | varchar | 255 | |
| program_annual | enabled | Indicates if program is enabled (Enabled =1, Disabled = 0) | 1 | tinyint | ||
| program_annual | form_process_id | Unique ID assigned to the form process used for this program | yes | int | ||
| program_annual | id | Unique ID assigned to the form process used for this program | int | |||
| program_annual | legacy_id | Unique ID from the legacy system that corresponds to the same field in Enroll | yes | int | ||
| program_annual | lottery_auto_decline | Program-specific setting to auto-decline applications if offer is not accepted by a deadline set in the system | default | enum | 7 | |
| program_annual | lottery_auto_decline_accepted | Program-specific setting to auto-decline a student’s other applications on Offered Lists once a seat is accepted | default | enum | 7 | |
| program_annual | lottery_auto_decline_days | Program-specific number of days to accept seat until the auto-decline/offer expiration deadline | 0 | tinyint | ||
| program_annual | lottery_auto_decline_enroll | Program-specific setting to auto-decline applications if registration is not submitted by a deadline set in the system | default | enum | 7 | |
| program_annual | lottery_auto_decline_enroll_days | Program-specific number of days to submit registration until auto-decline/offer expiration deadline | 0 | tinyint | ||
| program_annual | lottery_auto_decline_enroll_on_day | Program-specific date to submit registration until auto-decline/offer expiration deadline | yes | date | ||
| program_annual | lottery_auto_decline_enroll_on_time | Time of day when a lottery placement will be auto-declined due to failure to submit registration | yes | text | 65535 | |
| program_annual | lottery_auto_decline_offered | Program setting that determines how auto-declined is configured for each program (Global Lottery Settings = Default, Custom = Program) | default | enum | 7 | |
| program_annual | lottery_auto_decline_on_day | Program-specific date to accept seat until the auto-decline/offer expiration deadline | yes | date | ||
| program_annual | lottery_auto_decline_on_time | Time of day when a lottery placement will be auto-declined due to failure to accept offer | yes | text | 65535 | |
| program_annual | lottery_auto_decline_remind | Program-specific setting to send a reminder to guardian before the auto-decline/offer expiration deadline | yes | tinyint | ||
| program_annual | lottery_auto_decline_remind_days_before | Program-specific number of days before the auto-decline/offer expiration deadline when a reminder is sent to guardian | yes | text | 65535 | |
| program_annual | lottery_auto_decline_remind_on_time | Time of day when reminder will be sent to warn guardians before auto-decline | yes | text | 65535 | |
| program_annual | lottery_dashboard_notify | Program setting to show lottery results on the Guardian Dashboard | 1 | tinyint | ||
| program_annual | lottery_design_id | Unique ID assigned to a lottery design for the program | yes | int | ||
| program_annual | lottery_email_accepting | Name of accepted lottery email template (sent to guardians) assigned to the program | LOTTERY_PLACEMENT_ACCEPTED_PARENT | yes | varchar | 255 |
| program_annual | lottery_email_declining | Name of decline lottery email template (sent to guardians) assigned to the program | LOTTERY_PLACEMENT_DECLINED_PARENT | yes | varchar | 255 |
| program_annual | lottery_email_offered | Name of offered lottery email template assigned to the program (when sending one email per application) | LOTTERY_RESULTS_OFFERED | yes | varchar | 255 |
| program_annual | lottery_email_waiting | Name of waiting list lottery email template assigned to the program (when sending one email per application) | LOTTERY_RESULTS_WAITING_LIST | yes | varchar | 255 |
| program_annual | lottery_group_design_id | Unique ID assigned to a lottery group design for the program | yes | int | ||
| program_annual | lottery_rollup | Program-specific setting to auto-roll up applications from waiting list to offered list (when another application on offered list is declined) | 1 | tinyint | ||
| program_annual | open_date | Program-specific open dates for application | yes | datetime | ||
| program_annual | open_grades | The grades accepting applications at this program | yes | json | ||
| program_annual | organization_id | Unique ID assigned to each Enroll customer | int | |||
| program_annual | parent_accept_seats | Program-specific setting to allow guardians to accept/decline seats from dashboard | 0 | tinyint | ||
| program_annual | place_multiples_together | Program-specific setting for placing multiples (twins) together on the lottery list | 1 | int | ||
| program_annual | previous_year_id | Unique ID assigned to the previous year for the purposes of rollover | yes | int | ||
| program_annual | program_id | Unique ID assigned by the system to each program | int | |||
| program_annual | rollover_waitlist | Program-specific setting to roll over waiting lists when the school year is rolled over | 1 | tinyint | ||
| program_annual | seat_accepted_decline_all_offered | Auto-decline a student’s other applications on Offered Lists once a seat is accepted | 0 | tinyint | ||
| program_annual | seat_tracker_settings | Program setting that indicates how Seat Tracker is displayed for guardians in application (hide, specific, range) | hide | enum | 8 | |
| program_annual | show_finder | Program setting that indicates if this program is enabled in SchoolFinder (Yes = 1, No = 0) | 1 | tinyint | ||
| program_annual | show_parent_waitlist_number | Program-specific setting to show waiting list number on guardian dashboard | 1 | tinyint | ||
| program_annual | post_lottery_auto_placements | Program setting that indicates if: Auto-add eligible applications to lottery list after initial lottery is run is enabled (Yes = 1, No = 0) | 0 | tinyint | ||
| program_annual | updated_at | Most recent date and time the program was updated | yes | datetime | ||
| program_annual | min_seats_value | Number of seats set to define "No Seats Available", red indicator for Seat Tracker for this program. | 0 | int | ||
| program_annual | max_seats_value | Number of seats set to define "Limited Seats Available", orange indicator for Seat Tracker for this program. | 0 | 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
Comments
0 comments
Article is closed for comments.