This is a courtesy extract that we can provide to your district. Please ask your Implementation Manager or a Product Specialist to install the Custom Report(s).
This extract provides data for student schedules and attendance for Harris Computer Systems.
The following minimum requires must be met before we begin. If you did not meet all the requirements, contact our help desk at [email protected] or call our help desk at (949)-242-0343 to get more information.
When requesting this extract, you will need to provide the following information to implement it and for any subsequent years we rollover the extract for use.
Below are the specifications for the files we provide. These file specifications have been created based on standard requirements from the vendor. If you would like to use this standard extract and your district has a custom setup that differs from what Illuminate provides, please work with the vendor to make adjustments to the import. If you believe our specifications are out of date, please be ready to provide the latest specifications from the vendor.
Header Name | Supported? | Other Notes |
---|---|---|
ROW_ID | Y | CONCAT using a dash (-) delimiter, the student's state ID, the section ID, the timeblock shortname and the term name |
DISTRICT_ID | Y | Please provide this value upon request |
AC_CODE | Y | Filled down with "C" |
CONC_HS_SITE_ID | Y | SUBSTRING 8 characters of state school ID, set in Site Management |
CSIS_NUMBER | Y | State student ID |
HIGH_SCHOOL_STUDENT_NUMBER | Y | Local student ID |
LAST_NAME | Y | |
FIRST_NAME | Y | |
MIDDLE_NAME | Y | |
BIRTHDATE | Y | |
BIRTHPLACE | Y | |
GENDER | Y | |
ETHNICITY_ID | Y | |
LANGUAGE_ID | Y | |
STREET | Y | Primary Household's dwelling address's address 1 and address 2 fields |
CITY | Y | Primary Household's dwelling address's city field |
STATE | Y | Primary Household's dwelling address's state field |
ZIP | Y | Primary Household's dwelling address's zip field |
HOME_PHONE | Y | Primary contacts primary phone number |
EMER_PHONE | Y | First available emergency contact's phone number. |
EMER_PHONE_EXT | N | |
EMER_CONTACT | Y | |
GRADE_LEVEL | Y | |
ENROLL_DATE | Y | |
EXIT_DATE | Y | |
FISCAL_YEAR | Y | |
FY_TERM | Y | |
COURSE_TITLE | Y | |
SECTION_ID_1 | Y | Teacher's name |
SECTION_ID_2 | Y | Timeblock name |
SECTION_ID_3 | Y | School course ID |
SECTION_ID_4 | Y | Section ID |
SECTION_ID_5 | Y | Student course grade |
Header Name | Supported? | Other Notes |
---|---|---|
ROW_ID | Y | CONCAT using a dash (-) delimiter, the student's state ID, the section ID, the timeblock shortname and the term name |
DISTRICT_ID | Y | Please provide this value upon request |