Schedule a demo

Delivering data you can trust

1 min read

Up-To-Date List of Skyward Connect Rules for State Reporting

July 19, 2022 at 1:46 PM

Level Data performed a service update starting after 3:30 PM EST on Thursday, October 06, 2022. No downtime was associated with this update.

We make updates to this list regularly as reporting modules are modified. Be sure to check back regularly for up-to-date information.

Complete List of Skyward Connect Rules

Listed below are our current Connect Validation and RealTime Rules for states:

Michigan

Connect Validation Rules

Demographics

  • Invalid First Name
  • Invalid Home Email Address
  • Invalid Legal First Name
  • Invalid Legal Middle Name
  • Invalid Middle Name
  • Legal Name Should Not Match Name on Student Profile
  • Missing/Invalid Date of Birth
  • Missing/Invalid Gender
  • Missing/Invalid UIC

Enrollment

  • District Entry Date/School Entry Date Mismatch
  • Full/Part Time-Percent Enrolled Mismatch
  • Invalid Entry Date
  • Invalid Exit Code for Early College
  • Invalid Home Address County
  • Invalid Lunch Status For Homeless Status
  • Invalid Resident County
  • Missing Status End Code
  • Missing/Invalid Additional Graduation Award
  • Missing/Invalid State Aid Code
  • Resident/State Aid Mismatch

Reports/Lists

  • Kindergarten Students Younger Than Five Years Old

Staff

  • Missing/Invalid Staff Gender
  • Missing/Invalid Teacher PIC Number

Miscellaneous

  • Print Report Card Set to No

Connect Validation Rules Currently in Development

Scheduling

  • Class Meets Excluded from TSDL
  • Dual Enrollment Course with College Credit of 0.00
  • Invalid State Course Code
  • Missing State Course Code
  • Missing/Invalid College Credit
  • Missing/Invalid PSN for Vocational Course
  • Virtual Delivery/Mentor Teacher Mismatch

Demographics

  • Duplicate Unique Identification Code (UIC)
  • Guardians with Missing Relationship Code
  • Invalid Last Name
  • Invalid Legal Last Name
  • Missing/Invalid Address Information

Enrollment

  • Concurrent Enrollment with Invalid Status End
  • Exit Date Prior to Entry Date
  • Invalid FTE For Out-of-State Resident
  • Invalid Grade for Early/Middle College Student
  • Invalid Grade for Military Connected Student
  • Invalid Status End Code
  • Residency Code/Resident District Mismatch
  • Student Status and Entry/Withdrawal Record Mismatch

Discipline

  • Invalid Total Time for Action
  • Missing Follow Up for Expulsion
  • Missing Follow Up for Special Ed Student

Reports/Lists

  • Age Outside of Expected Range for Grade Level
  • Inactive Prior Year Senior Flagged As Current Year Member
  • Staff Flagged as Mentor Teacher
  • Students with Homeless Status

Config

  • Calendar Days With a 'Count As' Value Other Than 0.00 or 1.00

Special Education

  • Invalid Age For Educational Setting And Grade - Students Not 3-5 Years of Age
  • Invalid Age For Educational Setting And Grade - Students Not 5+ Years of Age
  • Invalid Age For Educational Setting And Grade - Students Not Less Than 3 Years of Age
  • Invalid Educational Setting For State Aid Code (09)
  • Invalid Educational Setting For State Aid Codes (04, 07, 08 or 15)
  • Invalid Educational Setting For Students 3 through 5 Years of Age
  • Invalid Educational Setting For Students At Least 5 Years of Age and In Kindergarten or Higher
  • Invalid Educational Setting For Students Less Than 3 Years of Age
  • Invalid Grade For Educational Setting - Students 3 through 5 Years of Age
  • Invalid Grade For Educational Setting - Students At Least 5 Years of Age
  • Invalid Grade For Educational Setting - Students Less Than 3 Years of Age
  • Missing Support Service or Program Service Code
  • Missing/Invalid Date of Parental Consent
  • Missing/Invalid Initial IEP Completion Date
  • Plan Date Out of Compliance
  • Special Education Students with Discipline
  • Timeliness of Initial IEP/Days Beyond Timeline Mismatch
  • Timeliness of Initial IEP/Result of Initial IEP Mismatch

Staff

  • Missing Staff Entity Building

Connect RealTime Rules

  • Entry/With tab: Entry Record: State Aid
  • Entry/With tab: Withdrawal Record: Status End
  • Entry/Withdrawal: Withdraw: Additional Graduation Award
  • General: Address: +4 Zip Code
  • General: Address: Street Name
  • General: Address: Street Number
  • General: Address: Zip Code
  • General: Identity: Legal First Name
  • General: Identity: Legal Last Name
  • General: Identity: Legal Middle Name
  • General: Profile: Grade and General Information: First Name
  • General: Profile: Grade and General Information: Last Name
  • General: Profile: Grade and General Information: Middle Name
  • MI/NCLB: Resident County
  • MI/NCLB: Unique Identification Code (UIC)
  • Missing Graduation Date
  • Missing Graduation Date
  • Office: Curriculum & Assessment: Curriculum: Curriculum Master: State Course Code
  • Profile: Grade and General Information: Gender
  • Special Programs: Early Childhood: Federal Poverty Level Quintile
  • Special Programs: Homeless: Begin Sts: Primary Nighttime Residence
  • Staff: Staff Entity: Building
  • Staff: Staff: Edit Staff Member: Teacher PIC Number
  • Student Management: Students: Students: Student Profile: Discipline: Offense: Action: Total Time
  • Student Management: Students: Students: Student Profile: Family: Edit Guardian: Relationship
  • Student Management: Students: Students: Student Profile: Family: Home Email
  • Student Management: Students: Students: Student Profile: General: Profile: Advance
  • Student Management: Students: Students: Student Profile: General: Profile: Home Email Address
  • Student Management: Students: Students: Student Profile: General: Profile: School Email
  • Student Management: Students: Students: Student Profile: MI/NCLB: International Student

Connect RealTime Rules Currently In Development

  • Special Programs: Restraint: Date of Restraint Event
  • Special Programs: Seclusion: Date of Seclusion Event
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: District Received Date
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Days Beyond Timeline
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Initial IEP Completion Date
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Part C Transition Timeliness
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Result
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Timeliness
  • Student Management: Students: Students: Student Profile: Entry/With: Alternative ED
  • Student Management: Students: Students: Student Profile: Entry/With: Developmental KG
  • Student Management: Students: Students: Student Profile: MI/NCLB: Student ID Nbr
  • Student Management: Students: Students: Student Profile: Special Programs: Early Childhood: Delivery Method
  • Student Management: Students: Students: Student Profile: Special Programs: Early Childhood: Delivery Schedule
  • Student Management: Students: Students: Student Profile: Special Programs: Early On: Referral Date
  • Student Profile: Special Programs: Ltd Eng Prof: End Date
  • Student Profile: Special Programs: Ltd Eng Prof: Start Date
  • Total Days for Susp/Exp

Texas

Connect Validation Rules

Courses

  • Courses With Missing Service ID
  • Service ID Expiring Next Year Connected to Course
  • Service ID must not begin with "SA", "SE", "SR", "SS".

Demographics

  • Age/Grade Level Mismatch
  • Invalid Campus ID when Student Attribution Code is 10
  • Invalid Legal First Name
  • Invalid Legal Middle Name
  • Invalid Middle Name
  • Missing Primary (Home) Language Code
  • Missing/Invalid Campus ID of Residence for ADA Eligibility Code 3 or 6
  • Missing/Invalid Campus ID of Residence for Student Attribution
  • Missing/Invalid Campus ID of Residence for Student Attribution '02'
  • Missing/Invalid First Name
  • Missing/Invalid Home Language Survey Date

Enrollment

  • Invalid Legal Last Name
  • Invalid PK Primary Funding Source

Special Education

  • Instructional Setting/ADA Eligibility Mismatch
  • Missing/Invalid Child Count Funding Type
  • Student Age/Special Education Indicator/ADA Code Mismatch

Special Programs

  • Invalid Military Connected Student
  • Students with Military Connected code 4
  • Unaccompanied Youth Status/Homeless Mismatch

Staff

  • Invalid Staff Middle Name
  • Missing/Invalid Staff First Name
  • Missing/Invalid Staff Last Name

State Submission

  • List of Students Excluded from State Reporting

Connect Validation Rules Currently in Development

Courses

  • "AP Computer Science A - Math" and "AP Computer Science A - LOTE" Must be Reported together for a Student.
  • Active Courses with No Attached Sections
  • Active Sections with No Attached Meets.
  • If Non Campus Based Instruction Code is "10", then Service ID must be "PES00008" or "PES00011".

Demographics

  • Missing/Invalid Date of Birth
  • Missing/Invalid Last Name
  • PK Student Must Have Active PK Program Type Code
  • PK Students With Entry/ADA Codes of 1,2,3,6 Must Have Additional Data.

Enrollment

  • Exit (Leaver) Code of 01 with Missing or Invalid Graduation Date
  • FHSP Graduation Type Code / FHSP Distinguished Level Mismatch
  • If Exit (Leaver) Code is not 01 then Grad Date, Grad Type Code, and IGC Must be Blank.
  • Missing Fields for Graduate Student
  • Student Attribution Code 12 with SpEd/ADA Mismatch
  • Withdrawal Code of "01" for Student less than 9th Grade
  • Withdrawal Code of "01" for Students in grade 9 or 10

LEP/EL

  • Invalid Alternative Language Program

Special Education

  • Missing/Invalid Preschool Program Children with Disability Indicator
  • Special Ed. Students Missing Instructional Setting and/or Primary Disability
  • Students Listed as Receiving Speech Therapy Only Must Have an Instructional Setting of 00.
  • Students Listed as Receiving Speech Therapy Only Must Have an Instructional Setting of 00.

Special Programs

  • If Foster Care Indicator Code is 02 or 03, Student Grade Must Be PK.
  • Missing Dyslexia Risk for Grade KG or 01
  • Restraint Staff Type/Restraint Reason Mismatch

Staff

  • Missing/Invalid Staff Federal Race
  • Staff Responsibility Role ID/Instructional Service ID Mismatch
  • Staff TSDS ID Must Be Unique

State Submission

  • Graduation Type Code (07 or 57) / Age Mismatch
  • Missing/Invalid Early Reading Indicator
  • Student TSDS ID Must Be Unique

Connect RealTime Rules

  • Missing Ed-Fi Country of Birth
  • Missing Ed-Fi Country of Birth
  • Missing/Invalid Primary (Home) Language Code
  • PK students with Program Type Code of 00, 02, 04, 05 Must have a PK Funding Source value.
  • Preschool Program for Children with Disabilities must have PPCD Location Code Other than 0.
  • Preschool Program for Children with Disabilities must have PPCD Location Code Other than 0.
  • Print Report Card Set to No
  • Student Management: Office: Current Scheduling: Build Course Master: Course Master: Section Details: Edit: TX State Specific: Non Campus Based Instruction:
  • Student Management: Staff: Gender:
  • Student Management: Students: Students : Student Profile: General: Address: Census Block Group:
  • Student Management: Students: Students: Student Profile: Special Programs: Child Restraint
  • Student Management: Students: Students: Student Profile: Discipline: Offenses: Action Summary and Detail: Suspension Type
  • Student Management: Students: Students: Student Profile: General: Identity: Edit:
  • Student Management: Students: Students: Student Profile: Special Programs: Dyslexia Risk: Dyslexia Screening Exception Reason:
  • Student Management: Students: Students: Student Profile: Special Programs: Homeless: Unaccompanied Youth:
  • Student Management: Students: Students: Student Profile: TX/NCLB: Grad Info: Graduation Type Code:
  • Students: Student Profile: General: Profile: First:
  • Web Student : Students: Student Profile: General: Profile: Graduation Date:
  • Web Student: Student Services: Child Restraint
  • Web Student: Students: Students: Student Profile: Survey Lang Date:

Connect RealTime Rules Currently In Development

  • Student Management: Students: Students: Student Profile: Discipline: Offenses: Action Summary and Detail: Action
  • Student Management: Students: Students: Student Profile: Special Programs: Dyslexia Risk: Dyslexia Screening Exception Reason
Al Momrik
Written by Al Momrik

Al Momrik works at Level Data as a Data Quality Analyst, arriving in 2013. He works primarily with the State Data Validation Suite, a series of services which help PowerSchool users to find errors in their data and correct them in a shorter amount of time. Before coming to Level Data, Al worked in a school district in Michigan for 23 years. He was a Technology Director, a SysAdmin for PowerSchool, and was responsible for all State data submissions. He has worked with PowerSchool since 2007. Al also is a presenter at 6-8 PowerSchool conferences around the country annually.

Post a Comment

Featured