Data Export: Special Education and Section 504 Data from SIRAS to SIS
Aug 12, 2026
This is the canonical SIRAS → SIS export-file reference. It documents the SIRAS-generated files a district SIS can consume or use locally, including Special Education student/status data, service data, Section 504 data, and the legacy/Aeries file formats.
For the overall non-Aeries implementation process—SFTP, first test files, Training review, Production approval, automation, and the bidirectional handoff—use File-Based SIS Integration: Implementation Guide.
Districts using the SIRAS 504 module need a dependable 504 handoff to the SIS.
The SIS is responsible for the district's Section 504 reporting to CALPADS, including the applicable Program 101 workflow. Where supported, automated use of
The SIS is responsible for the district's Section 504 reporting to CALPADS, including the applicable Program 101 workflow. Where supported, automated use of
504StudentData.csv is preferred. If the SIS cannot automate the exchange, the district still needs a defined manual process so new 504 participation and 504 exits are communicated to the SIS.Using studentData.csv to identify the current Special Education population:
When a district uses
When a district uses
studentData.csv to seed or reconcile current Special Education participation in its SIS, Inactive Reason should be blank. A populated Inactive Reason identifies an inactive/exit condition.
Recommended for new integrations
Use
Use
studentData.csv, serviceData.csv, and 504StudentData.csv. The legacy tableA.csv and tableB.csv files remain available for established processes but are not expanded with new fields.
Contents
Retrieve the Files After SFTP Access Is Working
This article does not repeat the SFTP host, port, username, password, or firewall setup. Use SIRAS SFTP: Secure File Exchange & Connection Settings to establish and manually verify the district account first.
- Confirm which SIRAS export files the district SIS will process.
- Confirm the files are being generated in the district SFTP location.
- Schedule the SIS retrieval after the current nightly files have been created. Use the actual file timestamps when selecting the import time.
- Process the current files in the SIS test/Training workflow.
- Review record counts, matched/unmatched results, rejected rows, and representative students.
- Approve the receiving-SIS behavior before relying on the automated Production job.
| Format | Comma-separated values (CSV) with a header row. |
| Transfer | SFTP using the district-specific account documented in Article 525. |
| Recommended match key | SSID. |
| Processing approach | Map stable header names to the corresponding SIS data points; do not depend on column position. |
Ready to move on when:
The receiving SIS can retrieve the current files, process them without unexpected errors, and the district has reviewed representative results.
The receiving SIS can retrieve the current files, process them without unexpected errors, and the district has reviewed representative results.
File Names and Populations
| File | Population and purpose |
|---|---|
studentData.csv |
All Active Special Education Current records, plus recent Inactive records represented by the most recent archive. Pending records are not included. |
serviceData.csv |
Service, supplemental-service, and ESY data for the Special Education population represented in the student export. |
504StudentData.csv |
All Active Section 504 plan records. |
tableA.csv |
Aeries/legacy Special Education student file. Aeries Special Ed Data Import continues to use this file under the supported SIRAS configuration. |
tableB.csv |
Aeries/legacy service file. Aeries Special Ed Data Import continues to use this file under the supported SIRAS configuration. |
Inactive records require an archive.
A record made Inactive without a matching archived transaction may not appear in the export. Use Inactive Records Requiring Archive to monitor and resolve those records.
A record made Inactive without a matching archived transaction may not appear in the export. Use Inactive Records Requiring Archive to monitor and resolve those records.
Recommended SIS Processing
- Match students by SSID whenever possible.
- Use the header names rather than fixed column positions.
- Treat demographic fields as reference data when the SIS is the authority.
- Display coded values and their label columns together when both are present.
- Process student records before dependent service records.
- Retain the completion log, rejected rows, and record counts.
- Do not treat a successful SFTP transfer as proof that the SIS import completed successfully.
For the complete machine-readable comparison of the recommended student file and the legacy tableA file, use the existing SIRAS Data Transfer File Specification sheet.
studentData.csv Field Specification
How to read this table:
Legacy / related field shows the corresponding established or legacy field when one exists. Notes is reserved for implementation guidance that is not already clear from the Description. For demographic/reference fields, the main SIS remains the data authority; SIRAS values generally should not overwrite those SIS fields when data is imported back.
Legacy / related field shows the corresponding established or legacy field when one exists. Notes is reserved for implementation guidance that is not already clear from the Description. For demographic/reference fields, the main SIS remains the data authority; SIRAS values generally should not overwrite those SIS fields when data is imported back.
| Header | Legacy / related field | Description | Notes |
|---|---|---|---|
Active Status | Active or Inactive SIRAS record status. | ||
FIRST_NAME | Student Legal First Name | Student identifying information. | |
MIDDLE_NAME | Student identifying information. | ||
LAST_NAME | Student Legal Last Name | Student identifying information. | |
BIRTHDATE | Student Birth Date | Student identifying information. | |
SSID | 10-digit CALPADS ID; recommended primary match key. | ||
STUDENT_ID | Local Special Education Student ID | May differ from the SIS identifier according to local practice. | |
LOCAL_ID | Local Student ID | Expected to match the SIS when SIRAS receives SIS data. | |
SELPA_CODE | 4-digit CDE SELPA code. | ||
DIST_CODE | District Attending or Reporting LEA; 7-digit district CDS code (left 7 digits of the 14-digit CDS code). | ||
District Name | District label. | ||
SCH_CODE | School of Attendance / NPS | School Attending; 7-digit school CDS code (right 7 digits of the 14-digit CDS code). Includes NPS/private-school values when applicable. | |
School Name | School label. | ||
SITE_CODE | Optional local site identifier; often the SIS school code. | ||
SCH_TYPE | School type. | ||
DSEA | District of Special Education Accountability | Authoritative special education accountability district. | |
DSEA Name | Name of the District of Special Education Accountability. | ||
DOGR | District of Geographic Residence; non-authoritative reference. | ||
DOGR Name | Name of the District of Geographic Residence. | ||
SCH_RESI | School of Residence; non-authoritative reference. | ||
School of Residence Name | Name of the School of Residence. | ||
ESY | Boolean indicating enrolled in ESY in SIRAS. | ||
GRADE | Reference value; SIRAS is not the demographic authority. | Main SIS is authoritative; use as reference when importing SIRAS data. | |
GENDER | Student Gender Code | Reference value. | Main SIS is authoritative; use as reference when importing SIRAS data. |
RACE1 | CALPADS race-category value; reference only. | Main SIS is authoritative; use as reference when importing SIRAS data. | |
RACE2 | CALPADS race-category value; reference only. | Main SIS is authoritative; use as reference when importing SIRAS data. | |
RACE3 | CALPADS race-category value; reference only. | Main SIS is authoritative; use as reference when importing SIRAS data. | |
EL_TYPE | EO, EL, IFEP, or RFEP. | ||
NATIV_LANG | CALPADS language code. | Main SIS is authoritative; use as reference when importing SIRAS data. | |
ETHNICITY | Student Hispanic Ethnicity Indicator | Reference value. | |
MIGRANT | Migrant indicator. | Main SIS is authoritative; use as reference when importing SIRAS data. | |
REFR_DATE | Special Education Referral Date | Special Education Referral Date. | |
REFR_BY | Referring Party Code | Referring Party Code. | |
REFR_BY.label | Text label for Referring Party Code. | ||
PRNT_CSNT | Initial Evaluation Parental Consent Date | Initial Evaluation Parental Consent Date. | |
PLAN_TYPE | Education Plan Type | Current education plan type code. | |
PLAN_TYPE.label | Text label for Education Plan Type. | ||
IEPDELAY | Meeting Delay Code | Meeting Delay Code. | |
IEPDELAY.label | Text label for Meeting Delay Code. | ||
ENTRY_DATE | Special Education Initial Entry Start Date | Special Education Initial Entry Start Date. | |
INIT_EVAL | Initial Evaluation Date | Initial Evaluation Date. | |
LAST_IEP | Most Recent Plan Review Date | Most Recent Plan Review Date. | |
LAST_EVAL | Most Recent Evaluation/Reevaluation Date | Most Recent Evaluation/Reevaluation Date. | |
RESID_STAT | Primary Residence Category | Primary Residence Category code. | |
RESID_STAT.label | Text label for Primary Residence Category. | ||
DISABILIT1 | Primary Disability | Primary Disability code. | |
DISABILIT1.label | Text label for Primary Disability. | ||
DISABILIT2 | Secondary Disability | Secondary Disability code. | |
DISABILIT2.label | Text label for Secondary Disability. | ||
DISDEGREE1 | Degree of Support | Primary-disability support level when applicable. | |
DISDEGREE2 | Retained legacy field; CALPADS removed the second support-degree field. | ||
FEDSET_SCH | Special Education Program Setting | CALPADS Special Education Program Setting code. | |
PRSLOCATION | Preschool Program Setting Service Location | Preschool Program Setting Service Location. | |
PRSSETTING | Ten or More Weekly Hours in Setting Indicator | Ten or More Weekly Hours in Setting Indicator. | |
IN_REGCLS | General Education Participation Percentage Range | General Education Participation Percentage Range. | |
INFANT_SET | Infant Regional Center Services Eligibility Indicator | Infant Regional Center Services Eligibility Indicator. | |
TRAN_REG1 | Postsecondary transition indicator 1. | ||
TRAN_REG2 | Postsecondary transition indicator 2. | ||
TRAN_REG3 | Postsecondary transition indicator 3. | ||
TRAN_REG4 | Postsecondary transition indicator 4. | ||
TRAN_REG5 | Postsecondary transition indicator 5. | ||
TRAN_REG6 | Postsecondary transition indicator 6. | ||
TRAN_REG7 | Postsecondary transition indicator 7. | ||
TRAN_REG8 | Postsecondary transition indicator 8. | ||
SPEC_TRANS | Special Transportation Indicator | Special Transportation Indicator. | |
PARINPUT | Parental Involvement Facilitation Code | Parental Involvement Facilitation Code. | |
GRAD_PLAN | Graduation Plan | Graduation Plan code. | Main SIS is authoritative; use as reference when importing SIRAS data. |
GRAD_PLAN.label | Text label for Graduation Plan. | ||
Special Education Status Code | Current reportable status. | ||
Inactive Reason | Non-Participation Reason | Non-Participation Reason code. | For SIS integration purposes, SIRAS exports only inactive reasons that qualify as ineligible or no longer eligible for Special Education in this field. |
Inactive Reason.label | Text label for the Non-Participation Reason. | ||
Inactive Date | Special Education Program Exit Date | SIRAS inactive date. | |
PARTI_ELA.label | ELA assessment participation label. | ||
PARTI_MATH.label | Mathematics assessment participation label. | ||
PARTI_SCI.label | Science assessment participation label. | ||
PARTI_EL.label | English language assessment participation label. | ||
Placement | Optional SELPA-specific placement value. | ||
Placement Changed | Optional SELPA-specific placement change date. | ||
Program | Optional SELPA-specific category. | ||
Case Manager | Assigned case manager. | ||
Case Manager Email | Assigned case manager email address. | ||
Plan Effective Date | Effective date from the applicable plan. | ||
MediCal Billing Permission | Y, N, or blank. | ||
MediCal Billing Permission Date | YYYYMMDD effective date. | ||
Classroom Accommodations CSV | Semicolon-delimited subject:description pairs. | ||
Remote Access URL | Short-lived encrypted link for authorized SIS users to access SIRAS information. |
serviceData.csv Field Specification
| Header | Description |
|---|---|
| SSID | Student SSID. |
| STUDENT_ID | Local Special Education Student ID. |
| FIRST_NAME | Student first name. |
| LAST_NAME | Student last name. |
| BIRTHDATE | Student birthdate. |
| DIST_CODE | District Attending or Reporting LEA. |
| SCH_CODE | School Attending. |
| DSEA | District of Special Education Accountability. |
| DOGR | District of Geographic Residence. |
| GRADE | Student grade. |
| SERVICE | CALPADS service code; labels are not currently provided in this file. |
| PROVIDER | Service provider. |
| LOCATION | Service location. |
| FREQUENCY | Service frequency. |
| DURATION | Service duration. |
| Service Additional Info 1 | Custom SELPA-specific field. |
| Service Additional Info 2 | Custom SELPA-specific field. |
| Service Start Date | Start date indicated on the IEP. |
| Service End Date | End date indicated on the IEP. |
| Service ESY | Boolean indicating Extended School Year service. |
| Service Meeting Date | Optional historical export: meeting or amendment date where the service was defined. |
| Service Report Start Date | Optional historical reporting-period start date. |
| Service Report End Date | Optional historical reporting-period end date. |
| Monthly Minutes | Optional historical calculated monthly service minutes. |
| Service Report Months | Optional historical number of report months. |
| Service Report Minutes | Optional historical calculated service minutes. |
| Inactive Date | Student inactive date for optional historical exports. |
Other Uses for Service Data
serviceData.csv is available for local use but is not a primary SIS-integration target. Districts can also use Service Export or request custom service-report extracts for local workflows such as County Office billback/reconciliation. SIRAS service logs can also support the MediCal billing workflow described in MediCal Billing in SIRAS.
504StudentData.csv Field Specification
| Header | Description |
|---|---|
| Active Status | Active 504 record status. |
| FIRST_NAME | Student first name. |
| MIDDLE_NAME | Student middle name. |
| LAST_NAME | Student last name. |
| BIRTHDATE | Student birthdate. |
| SSID | Student SSID. |
| STUDENT_ID | Local Special Education/504 Student ID. |
| LOCAL_ID | Local SIS Student ID. |
| SELPA_CODE | SELPA code. |
| DIST_CODE | District code. |
| District Name | District name. |
| SCH_CODE | School code. |
| School Name | School name. |
| SITE_CODE | Optional local site code. |
| SCH_TYPE | School type. |
| DSEA | District of Special Education Accountability. |
| DSEA Name | Name of the District of Special Education Accountability. |
| DOGR | District of Geographic Residence. |
| DOGR Name | Name of the District of Geographic Residence. |
| SCH_RESI | School of Residence code. |
| SCH_RESI Name | School of Residence name. |
| ESY | Extended School Year indicator. |
| GRADE | Student grade. |
| GENDER | Student gender code. |
| RACE1 | CALPADS race-category value. |
| RACE2 | CALPADS race-category value. |
| RACE3 | CALPADS race-category value. |
| EL_TYPE | English Language Acquisition Status. |
| NATIV_LANG | Primary language code. |
| ETHNICITY | Student Hispanic Ethnicity Indicator. |
| MIGRANT | Migrant indicator. |
| REFR_DATE | 504 referral date. |
| REFR_BY | Referring-party code. |
| REFR_BY.label | Text label for Referring Party. |
| PRNT_CSNT | Parent consent date. |
| INIT_EVAL | Initial 504 evaluation date. |
| Last 504 Review | Most recent annual 504 review date. |
| Last 504 Evaluation | Most recent 504 evaluation/reevaluation date. |
| 504 Impairment | Description of impairment. |
| 504 Major Life Activities | Affected major life activities. |
| PARTI_ELA.label | ELA assessment participation label. |
| PARTI_MATH.label | Mathematics assessment participation label. |
| PARTI_SCI.label | Science assessment participation label. |
| PARTI_EL.label | English language assessment participation label. |
| Placement | Optional district placement value. |
| Placement Changed | Optional placement change date. |
| Program | Optional district category. |
| Classroom Accommodations CSV | Semicolon-delimited subject:description pairs. |
| Remote Access URL | Short-lived link for authorized access to 504 data and documents. |
Aeries / Legacy tableA.csv and tableB.csv
SIRAS continues to generate tableA.csv and tableB.csv for established integrations and for the supported Aeries Special Ed Data Import workflow.
tableA.csv— student/Special Education file.tableB.csv— service file associated with the student records.
Aeries districts:
These files are not merely historical artifacts. They remain the supported files used by the Aeries Special Ed Data Import. Configure the Aeries retrieval, filenames, schedule, recipients, and one-time validation through Aeries–SIRAS Integration: Configure and Test Both Data Directions.
These files are not merely historical artifacts. They remain the supported files used by the Aeries Special Ed Data Import. Configure the Aeries retrieval, filenames, schedule, recipients, and one-time validation through Aeries–SIRAS Integration: Configure and Test Both Data Directions.
For a new non-Aeries integration, use the recommended expanded SIRAS export files where possible. Use tableA.csv/tableB.csv for other systems only when the receiving integration specifically requires the established legacy layout.
Do not build a new integration around the legacy files unless the receiving system requires them.
They remain stable for compatibility but are not updated with the expanded SIRAS fields available in the recommended files.
They remain stable for compatibility but are not updated with the expanded SIRAS fields available in the recommended files.
File Updates
Use this section to track dated changes to the SIRAS-to-SIS export files. Add each future update as a separate month-and-year subsection so districts and SIS vendors can identify when fields or processing behavior changed.
January 2026
The following fields were added to the recommended student export:
- MediCal Billing Permission
- MediCal Billing Permission Date
- Classroom Accommodations CSV
- Remote Access URL
The Remote Access URL contains an encrypted parameter and expires within a short period. Replace it from the new nightly file rather than storing it as a permanent link.
For future updates:
Add a new subsection such as September 2026, followed by a concise description of the affected file, field, format, population, or processing behavior. Keep prior dated subsections in place as the historical update record.
Add a new subsection such as September 2026, followed by a concise description of the affected file, field, format, population, or processing behavior. Keep prior dated subsections in place as the historical update record.
Monitoring, Changes and Troubleshooting
- Confirm nightly file creation and retrieval.
- Compare expected and actual record counts.
- Review the first rejected row or SIS processing error.
- Review filename, delimiter, encoding, leading zeros, and whether the file was modified.
- Reconfirm mappings when a field is added or a school/code changes.
- Use SIRAS SFTP: Secure File Exchange & Connection Settings for connection, folder, authentication, and scheduled-job problems.
- Use SIS Integration Troubleshooting & Ongoing Monitoring for record matching, data authority, and cross-system differences.
After go-live:
The district's primary SIRAS/SPED/SEDS staff should confirm the SIRAS files are current and that the receiving SIS actually completed its import weekly or more often when appropriate. A successful SFTP transfer alone does not prove the SIS processed the records. Use SIS Integration Troubleshooting & Ongoing Monitoring for established-integration problems.
The district's primary SIRAS/SPED/SEDS staff should confirm the SIRAS files are current and that the receiving SIS actually completed its import weekly or more often when appropriate. A successful SFTP transfer alone does not prove the SIS processed the records. Use SIS Integration Troubleshooting & Ongoing Monitoring for established-integration problems.
