Illuminate DnA Export
Overview
This task exports data for Illuminate DnA. It will create up to nine csv files: Sites, Terms, Courses, Users, Studemo, Enrollment, Mastschd, Roster and StudentPortalAccounts.
Options
The export can be configured to save locally, be sent in an email, or have the files sent to another machine using (S)FTP.
Individual files can be selected to be included.
Individual schools can be selected to be included.
Output
Sites |
Column |
Site ID |
Site Name |
State Site ID |
Start Grade Level ID |
End Grade Level ID |
Site Type ID |
Address |
City |
State |
Zip |
Local Site Code |
Annual Hours of Instruction |
| Annual Weeks of Instruction |
| Parent Site ID |
Terms |
Column |
Site ID |
Term Name |
Term Number |
Term Start Date |
Term End Date |
Term Type |
Session Type ID |
Academic Year |
Courses |
Column |
Course ID |
Full Name |
Short Name |
Department Name |
Low Level Grade ID |
High Level Grade ID |
Site ID List |
Active |
AG Requirement Category |
Course Weight |
Course Description |
Credits Possible |
| Variable Credit |
| Maximum Credits |
| Special Education Course |
| Maximum Capacity |
| Intervention Course |
| NCLB Instructional Level |
| Course Content |
| Education Service |
| Instructional Strategy |
| Program Funding Source |
| CTE Funding Provider |
| Tech Prep |
| State Course ID |
| Is Non-Academic |
| Non-Standard Instructional Level |
| Language of Instruction |
| Variable Credits Low |
| Variable Credits High |
| State Course Name |
| Course Designation |
| Course Applicable Grades |
Users |
Column |
User ID |
Last Name |
First Name |
Middle Name |
Birth Date |
Gender |
Email Address |
Username |
Password |
State ID |
Suffix |
Former First Name |
| Former Middle Name |
| Former Last Name |
| Primary Race Code |
| Is Hispanic |
| Address |
| City |
| State |
| Zip |
| Job Title |
| Education Level |
| Hire Date |
| Exit Date |
| Is Active |
| Position Status |
| Total Years Educational |
| Total Years in District |
| Email Address 2 |
| Phone 1 |
| Phone 2 |
Studemo |
Column |
Import Student ID |
State Student ID |
Student Last Name |
Student First Name |
Student Middle Name |
Birth Date |
Gender |
Race Code 1 |
Race Code 2 |
Race Code 3 |
Is Hispanic |
Primary Language Code |
| Correspondence Language Code |
| English Proficiency Code |
| Redesignation Date |
| Primary Disability Code |
| Migrant Ed Student ID |
| English Learner/LEP Date |
| US Entry Date |
| School Entry Date |
| District Entry Date |
| Parent/Guardian Highest Education |
| Residential Status |
| Special Needs Status |
| SST Date |
| 504 Accommodations |
| 504 Annual Review date |
| Special Ed Exit Date |
| Birth City |
| Birth State |
| Birth Country |
| Lunch ID |
| Academic Year |
| Student Name Suffix |
| Student Last Name Alias |
| Student First Name Alias |
| Student Middle Name Alias |
| Student Name Suffix Alias |
| Lunch Balance |
| ISE Operating District ID |
| ISE Operating Site ID |
| ISE Resident LEA Code |
| Birthdate Verification Method |
| Homeless Dwelling Type |
| Photo Release |
| Military Recruitment |
| Internet Use Release |
| Graduation Date |
| Graduation Status |
| Graduation Service Learning Hours |
| US Citizen Born Abroad |
| Military Family |
| Home Address Verification Date |
| Special Ed Enter Date |
| Secondary Disability Code |
| State School Entry Date |
| US School Entry Date |
| District Student ID |
| Deprecated |
| Deprecated |
| Graduation Requirement Year |
| Next School |
| Prior District |
| Prior School |
Enrollment |
Column |
Import Student ID |
State Student ID |
Student Last Name |
Student First Name |
Student Middle Name |
Birth Date |
Site ID |
Enrollment Start |
| Enrollment End |
| Grade Level ID |
| Academic Year |
| Is Primary ADA |
| Enrollment Category |
| Enrollment Exit Code |
| Session Type ID |
| Enrollment Entry Code |
Mastschd |
Column |
Section ID |
Site ID |
Term Name |
Course ID |
User ID |
Period |
Academic Year |
Room Number |
| Session Type ID |
| Deprecated |
| Quarter Number |
| User Start Date |
| User End Date |
| Primary User |
| Teacher Competency |
| Is Attendance Enabled |
Roster |
Column |
Import Student ID |
State Student ID |
Student Last Name |
Student First Name |
Student Middle Name |
Birth Date |
Section ID |
Site ID |
| Course ID |
| User ID |
| Entry Date |
| Exit Date |
| Student Grade Level |
| Academic Year |
| Session Type ID |
StudentPortalAccounts |
Column |
Import Student ID |
Portal Username |
Student Email |
Portal Enabled |
Temporary |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article