Special Education PIMS Cognos Reports

Special Education PIMS Cognos Reports

Note: For all reports, data is taken from appropriate Special Education Snapshot and/or Student Snapshot.

Special Education Submission Details (available soon) Currently named without Service Provider

This report lists all pertinent student data elements from a specific snapshot date. Please note that this report ONLY lists student records that are located in both the Student Snapshot AND the Special Education Snapshot for a specific submission date.

Location: Production/Special Education

Criteria: School Year/Snapshot Date

Fields: District Code,District Name,School Year,Special Ed Snapshot Date,Student ID,Student Last Name,Student First Name,Student Middle Name,Student Name Generation Suffix,Birth Date,Gender Code,Address 1,Address 2,City, State Code,Full Zip,Race or Ethnicity Code,ELL Program Participation Code,Current Grade Level,Secondary Disability Code,Residency Code,Educational Environment,Education Environment Pct,Staff Name,Amount of Special Education Services,Type of Support,Neighborhood School Code,Special Ed Exit Date,Exit Reason Code,School Number,District Code of Residence,Funding District Code,Planned Participation in PASA,Service Provider,Service Provider Location,Type of Support,Challenge Type ,Special Education

Special Education Snapshot Summary

This report provides a count of the number of student records submitted in the Special Education Snapshot.

Location: Production/Special Education/Summary Reports

Criteria: School Year/Snapshot Date

Fields: AUN, LEA. Record Count

Special Education Exit Information Summary

This report provides a count of student records in the Special Education.

Location: Production/Special Education/Summary Reports

Criteria: School Year, Snapshot Date

Fields: AUN, LEA, Record Count

Special Education Snapshot Template Details

This report provides a detailed list of all student records in the Special Education Snapshot that were uploaded successfully to the warehouse. Student demographic data pulled from the corresponding Student Snapshot Template.

Location: Verify/Validation Reports

Criteria: School Year, School, Snapshot Date

Fields: LEA,District Code,School Number,School,School Year,Student ID,Student First Name,Student Last Name,Student Middle Name,Staff Name,Primary Disability,Secondary Disability,Amount of Special Education Services,Type of Support,Equitable Participation Services Plan Code,Equitable Participation Services Plan,Special Ed Exit Date,Special Ed Snapshot Date,Residency Code,Residency,Neighborhood School Code,Neighborhood School,LRE Category / Location of Intervention Code,LRE Category / Location of Intervention,Educational,Exit Reason Code,Exit Reason,Educational Environment,Service Provider AUN,Service Provider Location

StudentSnapshot Template Details

This report provides a detailed list of all student records in the Student Snapshot that were uploaded successfully to the warehouse.

Location: Verify/Validation Reports

Criteria: School Year, School, Snapshot Date

Fields: AUN,LEA,School Number,School,Student ID,Modified Date,Student Last Name,Student First Name,Student Middle Name,Student Name Suffix,Current Grade Level,Home Room,Student Birth Date,Student Gender,Student Address City,Student Address State Code,Student Address Full Zip Code,Guardian Relationship Code,Ethnicity Code,Food Program Participation Code,Primary Disability Code,Special Ed Status Code,ELL Program Participation Code,Retained,Graduation Year,Graduation Status,Graduation Status Code,Planned Post Graduate Activity Code,Student Status,Date First Enrolled in an Ell/Bilingual Prog,Plan 504 Indicator,Gifted Participation Code,Economic Disadvantage Status Code,Diploma Type Code,Alternate Student ID,ELL Program Eligibility Code,ELL Program Eligibility,Grade 09 Entry Date,District Entry Date,School Entry Date,State Entry Date,Initial US Entry Date,English Proficiency Code,Ethnic Subgroup Code,District Code of Residence,Student is Single Parent,Home Language Code,Years in US Schools,Food Program Eligibility,Location Code of Residence,Displaced Homemaker,County of Residence,Funding District Code,Assessment Participation Code,Assessment Participation