About this data
In Illuminate, terms are the foundation of your calendars. They identify the dates that a session starts and ends for each school. You should have terms for each Illuminate site in your installation.
About this import
The terms.txt file is what gets your system going after you load your sites. Sites loads all of the schools in your installation, while the terms file is the basis for your calendars. The terms file identifies when school is in or out of session. Without a successful terms.txt file load, the rest of your data imports that are based on dates (enrollment, master schedules, rosters, programs, etc.) will not work well. If the terms aren’t loaded, then there are no dates that school is in session for students to be active.
Like the sites.txt file, after the initial import this file is no longer imported and data is managed through the user interface via the Term Manager Tool. For ongoing data automation in Illuminate Data and Assessment (DnA) or Illuminate Special Education (ISE) there is no reason to add terms.txt to your automation process since it will not be imported again.
Required fields - field name (column number)
- Site ID (1)
- Term Name (2)
- Term Number (3)
- Term Start Date (4)
- Term End Date (5)
- Term Type (6)
- Academic Year (8)
The first three fields that are listed on the data spec are: Site ID, Term Name, and Term Number. These three fields are the key identifiers for each unique building or site.
The Site ID is a unique identifier that is used by a Student Information System (SIS) to identify a site. The Term Name is the name of the given term being referenced. It is typically something like: Semester 1, Fall, Year long, etc.. The Term Number represents the chronological ordering of the term within the site. So for example, if you have two terms: Semester 1 and Semester 2, the term numbers would be 1 and 2, respectively.
Term Start Date and Term End Date - details forthcoming
Term Type - details forthcoming
Academic Year - details forthcoming
If any of the required fields are not provided or if any of the required fields do not align to the designated field types or values, the entire record will not import. Problems with required fields will generate import errors.
Whether or not a field is required refers to basic, minimal operation of the system. With only the required fields your Illuminate installation will work, however, it may not be configured optimally. Additionally, beyond minimal functionality and basic reporting, in an Illuminate Student Information (ISI) installation as much data as can possibly be provided should be imported. Many non required fields are used in basic reports and compliance reporting.
Non-required but recommended fields
- Session Type ID (7)
Session Type ID - details forthcoming
- Unique Term ID (9)
Unique Term ID - details forthcoming