Student Demographic Data files may be uploaded to the SIRAS SFTP to enable nightly update of non-Special Ed specific data, and possibly creation of new records. SIRAS also supports API-based integration with AERIES SIS (and potentially other Student Information Systems which might offer an API data connection).  Documentation for AERIES API-based integration

 

Process Overview:

A directory and credentials will be created for your district on the SIRAS SFTP.

From the Student Information System (SIS), export/Generate and Upload to the SFTP a file containing Student Demographic data including as many fields as possible from the list below.

 

The demographics file must meet the following specifications:

Column Headers are required to identify each data element.  Alternate headers are supported - SIRAS will review the initial file provided and map headers to the appropriate fields as necessary.

 

File name:    Flexible but recommend as follows {7 digit CDE district code}_demographics.csv

File content:  Rows representing students.  Column data with headers, refer to the table for detailed specifications. 
File type:       CSV, XLS, or XLSX    
Date Format    YYYYMMDD or DD/MM/YYYY

 

Designation (Special Ed. and/or 504):

Siras is able to update records that already exist in the Siras database, without any designation specified in the import process. However if your district is interested in creating new records, Siras will need to be provided with a file indicating the program:

• Enrolled in or being evaluated for Special Ed
• 504 Program
• SST Program

If the SIS is able to identify which students are enrolled or being evaluated in Special Ed. and/or 504 or SST programs, and can provide that information, Siras will be able to create new records with those designations.  This could be by including a column for "Designation", or by separating the students into different files.

 

 

Initial Deployment:

Initially, provide this file to SIRAS Systems so we can evaluate if any headers or code mappings need to be altered.

Once the file has been approved, have the SIS generate and upload the file nightly.

 

Scheduled Process:

Siras will import data nightly between the hours of 2AM-7AM, if it is detected that a new file has been uploaded.  This process is disabled over the summer to avoid issues that occur when SIS systems update for the next academic year.  Over the summer season each year, all import processes will pause operations.  Exception to adjust these dates for specific districts can be made- please contact Siras if necessary.  Siras will not process the file and no log will be created, if the Last Modified date on the uploaded file is prior to the most recent Log file (the timestamp of when this same file was previously processed), or older than 1 week.  In either case, to trigger a new update a new file is expected to be uploaded.

 

Error/Process Logs:

Each district's data import process will generate a log file when it is run, available for download in the SIRAS Admin area.

 

Optional Features:
Option: Creation of New Records

Siras will be able to create new records only if the file exclusively contains students who are actively enrolled or in the process of being referred for Special Ed.  If your district is able to produce a file that is limited to only Special Ed records, we will enable this option.

Option: 504 Plan Records

If you wish to create new 504 Plan records via this integration, we prefer the 504 Plan students to be provided in a separate file.
Reommended file name:  #######_demographics_504.csv
Alternatively, demographics for 504 Plan students could be combined with Special Ed students in the same file, if the Designation column is populated .
If unable to generate a file which identifies SPED or 504, we will update existing Siras records but not create new ones.

 

Option: Update Identifying Data

By default we will not update Student ID, SSID, First or Last names.  Optionally we can enable a loose matching ability, to allow these important fields to be updated, if the rest of the record is a close enough match.  Note: it is not generally expected to have an SSID update in the SIS pass that change along to Siras.  If a SSID is changed in the SIS, the SSID should be updated manually in SIRAS as well.

 

Known problem areas:

 

    Kindergarten, Transitional Kindergarten, Preschool, Infant  , and Ungraded grade codes.
    Various SIS will code these differently, and we will need to have the correct mapping specified.
    EL/EO/IFEP/RFEP/TBD are the default accepted values for EL aka English Language Learner aka EL Type.

 

School of Attendance Code (SCH_CODE) for School Programs with no official CDE code:

• For this field, the expected value is a 7 digit code matching the entity in Siras to be assigned as the School of Attendance.  For some school programs, this will not be the same as the Home School in CALPADS.
• Often Siras will have several different school-level entities sharing the same 7 digit code, (often identical to the district code) where those entities are school programs with no official CDE code.  In such cases the code sent in the data transfer file is expected to be that same code shared by those entities in Siras. 
• When the process encounters the same code in the data transfer file that is already assigned to a student, there will not be any update.
• When the code in the data transfer file is one that is shared by multiple entities in the Siras database, Siras will need to have one of the same-coded entities assigned as the "default".  In this case, users will often need to manually select the correct school entity in Siras post-update.
• "Site Code" may be included in the file to help distinguish between school entities sharing the same CDE code.  In this case, Siras will need to have the school entities updated with a unique code for each site which is additionally included in the data transfer file.

 

Field Specification:  Note, we will map different headers to support the default label used by various SIS. Order is unimportant.

 

Field Name/Header	Alternate Headers	Required?	Notes
SSID		Yes	Primary identifier used to locate the record in SIRAS
Local Student ID	LOCAL_ID, STUDENT_ID	Recommended	The record ID from the SIS. Optionally may update the Student ID field in SIRAS.
Last Name	FIRST_NAME	Yes
First Name	LAST_NAME	Yes
Birthdate	BIRTHDATE, DOB	Yes
Middle Name	MIDDLE_NAME	No
Name Suffix	GENERATION	No
School of Attendance	SCH_CODE	No	7 digit CDE school code.  NPS/Private school codes should be included here
Site Code School Type	SITE_CODE SCH_TYPE	No No	* optional to distinguish same-coded schools, see notes CALPADS code value
District of Geographic Residence	DIST_RESI, DOGR	No	7 digit CDE district code
School of Residence	SCH_RESI	No	7 digit CDE school code
Grade Level	GRADE	No	CALPADS code value
Gender	GENDER	No	CALPADS code value
Federal Ethnicity	ETHNICITY	No	CALPADS code value
Race1	RACE1	No	CALPADS code value
Race2	RACE2	No	CALPADS code value
Race3	RACE3	No	CALPADS code value
English Language Acquisition Status Code	EL_TYPE	No	Must be one of: EL, EO, RFEP, IFEP, TBD
RFEP Date	RFEP_DATE	No
Primary Language Code	NATIV_LANG	No	CALPADS code value
Migrant	MIGRANT	No	Y/N
Residential Status	RESID_STAT	No	CALPADS code value
Designation		No	SPED/504
PreferredFirstName		No	SIRAS requires a specific checkbox to be enabled to use alternate names on IEP forms
PreferredLastName		No