1 / 62

2018-2019 Business Validation Rule Changes

This presentation highlights the changes made to business validation rules for the 2018-2019 academic year. It covers various areas such as ECDS, organization, staff, and student rules.

kubiak
Download Presentation

2018-2019 Business Validation Rule Changes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Simple Solution. Brighter Futures. 2018-2019 Business Validation Rule Changes July/August 2018 Presented by: Michele Elledge

  2. CONTENTS • Business Validation Rules Introduction • Business Validation Rules - ECDS • Business Validation Rules - Organization • Business Validation Rules - Staff • Business Validation Rules - Student • HB 674 – Out-of-School Suspensions

  3. Business Validation Rules Introduction • Business Validation Rules are added, revised, and/or deleted due to • Legislation, • Quality assurance discoveries, • Support questions, or • Program area requests

  4. Business Validation Rules Introduction The following slides provide a high-level view of miscellaneous validation rule changes that have occurred since spring training. A detailed list of all changes can be found in the 2018-2019 Section 5 / 8.5 Change Logs.

  5. CONTENTS Business Validation Rules Introduction • Business Validation Rules - ECDS Business Validation Rules - Organization Business Validation Rules - Staff Business Validation Rules - Student HB 674 – Out-of-School Suspensions

  6. Business Validation Rules – ECDS • 10010-0016 • For each Local Education Agency’s data submission, if at least one KG student is reported (student school association data with GRADE-LEVEL-CODE "KG"), then there must be Kindergarten Assessment Metadata data reported where REPORT-ASSESSMENT-TYPE is "ECDS – KG".

  7. Business Validation Rules – ECDS • 10020-0035 • If the last three digits of DISTRICT-ID are "960" (Private PK data), then ORGANIZATION-CATEGORY on School data must be "School" and CAMPUS-GRADES-OFFERED must be "Preschool/Prekindergarten".

  8. Business Validation Rules – ECDS • 10020-0039 • For each campus registered with the TEA in the current school year as an active instructional campus that offers GRADE-LEVEL-CODE "KG", if at least one student is reported at that campus (student school association data with GRADE-LEVEL-CODE "KG"), then Campus data must be reported.

  9. Business Validation Rules – ECDS • 10200-0040 • For each campus registered with the TEA in the current school year as an active instructional campus that offers GRADELEVEL-CODE "PK", if at least one student is reported at that campus (student school association data with GRADE-LEVEL-CODE "PK"), then Campus data must be reported.

  10. Business Validation Rules – ECDS • 10020-0045 (Revision) • If the last three digits of DISTRICT-ID are "960" (Private PK data), then there must be data reported for the campus itself.

  11. Business Validation Rules – ECDS • 10020-0046 • If the last three digits of DISTRICT-ID are "960" (Private PK data), then for each campus reported to ECDS, staff data should be reported.

  12. Business Validation Rules – ECDS (Revisions) • 10020-0047 (Revision) • If the last three digits of DISTRICT-ID are "960" (Private PK data), then for each campus reported to ECDS, student data should be reported.

  13. Business Validation Rules – ECDS • 10050-0002 • For this Course Section, if the Course is for SERVICE-ID "01010000" reported for ECDS, then the following fields must not be blank: PK-CURRICULA, HIGH-QUALITY-PK-PROGRAMINDICATOR, STUDENT-INSTRUCTION, PK-SCHOOL-TYPE, and PROGRAM-EVALUATION-TYPE.

  14. Business Validation Rules – ECDS • 30305-0019 • For a given Course Section, if the Course is for the PreKindergarten SERVICE-ID (01010000) or a Kindergarten SERVICE-ID, then there must be at least one teacher section association with CLASS-ROLE of "01".

  15. Business Validation Rules – ECDS • 40100-0101 (New) • For reporting student data, STUDENT-IDENTIFICATION-SYSTEM for STUDENT-ID must be "State".

  16. Business Validation Rules – ECDS • 40100-0159 (Revision) • For each student reported by the LEA, if there is a student assessment reported with REPORT-ASSESSMENT-TYPE of "ECDS - PK" or "ECDS - KG", then there must be student section association data with a matching TX-UNIQUE-STUDENT-ID.

  17. Business Validation Rules – ECDS • 40100-0160 (Revision) • For each student reported by the LEA, if there is a student assessment reported with REPORT-ASSESSMENT-TYPE of "ECDS - PK" or "ECDS - KG", then there must be enrollment (student school association) data with a matching TX-UNIQUE-STUDENT-ID.

  18. Business Validation Rules – ECDS • 40100-0172 (Revision & new number) • If the student assessment REPORT-ASSESSMENT-TYPE is "ECDS - PK", then the student's September 1 age should be at least 4. • 40100-0173 (Revision & new number) • If the student assessment REPORT-ASSESSMENT-TYPE is "ECDS - KG", then the student's September 1 age should be at least 5.

  19. Business Validation Rules – ECDS • 40100-0174 (Revision & new number) • If the last three digits of DISTRICT-ID are "960" (Private PK data), then for each student reported, there must be student cohort (student cohort association) data with a matching TX-UNIQUE-STUDENT-ID.

  20. Business Validation Rules – ECDS • 40110-0133 (Revision) • If the last three digits of DISTRICT-ID are "960" (Private PK data), then the following fields must not be blank: PK-SCHOOL-TYPE, STUDENT-INSTRUCTION, LIMITED-ENGLISH-PROFICIENCY, and ECONOMIC-DISADVANTAGE-CODE.

  21. Business Validation Rules – ECDS • 40110-0173 (Revision) • If the student assessment REPORT-ASSESSMENT-TYPE is "ECDS - PK" or "ECDS - KG", then HOME-ROOM-INDICATOR must not be blank on student section associations.

  22. Business Validation Rules – ECDS • 40110-0174 (Revision) • If the last three digits of DISTRICT-ID are "960" (Private PK data), then ENTRY-GRADE-LEVEL-TYPE must be "Preschool/Prekindergarten", and PK-SCHOOL-TYPE must be "Other", "Non-Public Pre-K Head Start", or "Non-Public Pre-K Licensed Child Care".

  23. Business Validation Rules – ECDS • 40110-0179 (Revision) • If HOME-ROOM-INDICATOR is reported (not blank), then there must be a student assessment with REPORT-ASSESSMENT-TYPE of "ECDS - PK" or "ECDS - KG".

  24. Business Validation Rules – ECDS • 40110-0184 (Revision) • If the student assessment REPORT-ASSESSMENT-TYPE is "ECDS - PK" or "ECDS - KG", for a particular TX-UNIQUES-TUDENT-ID, there must be one and only one student section association where assessment ADMINISTRATION-DATE is greater than or equal to STUDENT-BEGIN-DATE and less than or equal to STUDENT-END-DATE, and HOME-ROOM-INDICATOR is "1".

  25. Business Validation Rules – ECDS • 42400-0027 (New) • If GRADE-LEVEL-CODE is "PK", then PK-PROGRAM-TYPE-CODE must not be blank or "00". • 42400-0028 (New) • If GRADE-LEVEL-CODE is "PK" and PK-PROGRAM-TYPE-CODE is "01" or "03", then PRIMARY-PK-FUNDING-SOURCE-CODE should be blank.

  26. Business Validation Rules – ECDS • 42400-0029 (New) • If GRADE-LEVEL-CODE is "PK", then PK-PROGRAM-TYPE-CODE must not be blank or "00". • 42400-0030 (New) • If GRADE-LEVEL-CODE is "PK" and SECONDARY-PK-FUNDING-SOURCE-CODE is not blank, then PRIMARY-PK-FUNDING-SOURCE-CODE must not be blank.

  27. Business Validation Rules – ECDS • 46010-0005 (Revision) • If REPORT-ASSESSMENT-TYPE is "ECDS - PK" or "ECDS - KG', then for the reported ASSESSMENT-TITLE and ACADEMIC-SUBJECT, if there is a minimum score and maximum score defined in TEDS Section 10, then the SCORE-RESULT must be either -999, or greater than or equal to the score minimum and less than or equal to the score maximum.

  28. Business Validation Rules – ECDS • 46010-0006 (New) • If REPORT-ASSESSMENT-TYPE is "ECDS - PK" or "ECDS – KG”, then there must be student data with a matching TX-UNIQUE-STUDENT-ID.

  29. Business Validation Rules – ECDS • 60010-0003 (Revision) • If REPORT-ASSESSMENT-TYPE is "ECDS - PK" or "ECDS - KG", then for the reported ASSESSMENT-TITLE, the ACADEMIC-SUBJECT must be one of the valid values listed on the assessment reference table (DC154) documented in TEDS Section 10.

  30. Business Validation Rules – ECDS • 60010-0007 (Revision) • If REPORT-ASSESSMENT-TYPE is "ECDS - PK" or "ECDS - KG", then PERFORMANCE-LEVEL-DESCRIPTOR-DESCRIPTION must be "ECDS".

  31. Business Validation Rules – ECDS • 60010-0008 (Revision) • If REPORT-ASSESSMENT-TYPE is "ECDS - PK" or "ECDS - KG", then for the reported ASSESSMENT-TITLE, the ASSESSMENT-IDENTIFICATION-CODE must match the value listed on the assessment reference table (DC154) documented in TEDS Section 10.

  32. 2018-2019 Business Validation Rules - ECDS • Please note the following Validation Rule deletions pertaining to ECDS:

  33. CONTENTS Business Validation Rules Introduction • Business Validation Rules - ECDS • Business Validation Rules - Organization Business Validation Rules - Staff Business Validation Rules - Student HB 674 – Out-of-School Suspensions

  34. Business Validation Rules - Organization • 10200-0016 (Revision) • If CALENDAR-WAIVER-EVENT-TYPE is "02" (Missed School Waiver Day), then SCHOOL-DAY-WAIVER-MINUTES should generally be 1-480.

  35. Business Validation Rules - Organization • 10200-0035 (Revision) • If SCHOOL-DAY-EVENT-CODE is "02" (Waiver Day), then CALENDAR-WAIVER-EVENT-TYPE must be "01", "02", "04", "05", or "99".

  36. Business Validation Rules - Organization • 10200-0021 (Revision) • REPORTING-PERIOD-END-DATE must be greater than or equal to REPORTING-PERIOD-BEGIN-DATE. • 10200-0056 (New) • REPORTING-PERIOD-END-DATE should be greater than REPORTING-PERIOD-BEGIN-DATE.

  37. Business Validation Rules - Organization • 10200-0057 (New) • For a particular Reporting Period (CAMPUS-ID, SCHOOL-YEAR, REPORTING-PERIOD-INDICATOR-CODE, and INSTRUCTIONALTRACK-INDICATOR-CODE), each CALENDAR-DATE referenced must be on or after the REPORTING-PERIOD-BEGIN-DATE and on or before the REPORTING-PERIOD-END-DATE.

  38. CONTENTS Business Validation Rules Introduction • Business Validation Rules - ECDS Business Validation Rules - Organization • Business Validation Rules - Staff Business Validation Rules - Student HB 674 – Out-of-School Suspensions

  39. Business Validation Rules – Staff • 30090-0117(New) • If ROLE-ID is a value other than "033" or "036", then there must be at least one staff payroll with a matching TX-UNIQUE-STAFF-ID where OBJECT-CODE is "6119" or "6112".

  40. Business Validation Rules – Staff • 30305-0023(New) • If SERVICE-ID is not a high school course, then COURSE-SEQUENCE-CODE must be "A".

  41. CONTENTS Business Validation Rules Introduction • Business Validation Rules - ECDS Business Validation Rules - Organization Business Validation Rules - Staff • Business Validation Rules - Student HB 674 – Out-of-School Suspensions

  42. Business Validation Rules – Student • 40100-0167 (New) • For a particular TX-UNIQUE-STUDENT-ID, there must be one and only one Enrollment (Student School Association).

  43. Business Validation Rules – Student • 40110-0190 (Revision & new number) • For each student school association, there must be Attendance or Flexible Attendance data reported with a matching TX-UNIQUE-STUDENT-ID and GRADE-LEVEL-CODE.

  44. Business Validation Rules – Student • 42401-0005 (Revision; 2018-2019 Only) • For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT is greater than 0, then LEP-INDICATOR-CODE should be "1". • For 2018-2019, TELPAS scores will not be available until August 15, 2018. For this year only, a student who is not marked as LEP may report bilingual/ESL attendance.

  45. Business Validation Rules – Student • 44425-0002 (Revision) • If PRIMARY-DISABILITY-CODE is not "00" or blank, and STUDENT-ATTRIBUTION-CODE is not "07", then there should be Special Education Attendance or Special Education Flexible Attendance with a matching TX-UNIQUE-STUDENT-ID, or Attendance with a matching TX-UNIQUE-STUDENT-ID where TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is greater than 0, or Flexible Attendance with a matching TX-UNIQUE-STUDENT-ID where FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE is greater than 0.

  46. Business Validation Rules – Student • 44425-0003 (Revision) • If DISCIPLINARY-ACTION-CODE is "27", and STUDENT-ATTRIBUTION-CODE is not “07”, then there should be Special Education Attendance or Special Education Flexible Attendance with a matching TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, or Attendance with a matching TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE where TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is greater than 0, or Flexible Attendance with a matching TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE where FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE is greater than 0.

  47. Business Validation Rules – Student • 48011-0023(Revision) • If GRADE-LEVEL-CODE is "09"-"11", then FHSP-PARTICIPANT-CODE should be "1" on the student’s graduation program intention data.

  48. Business Validation Rules – Student • 48011-0029(Revision) • If GRADE-LEVEL-CODE is "12", then FHSP-PARTICIPANT-CODE should be "2" on the student’s graduation program intention data.

  49. Business Validation Rules – Student • 48011-0027(Revision) • CAMPUS-ID should match a CAMPUS-ID-OF-ENROLLMENT on the student’s highest REPORTING-PERIOD-INDICATOR-CODE on Attendance or Flexible Attendance data.

  50. Business Validation Rules – Student • 43415-0070 (New) • If SERVICE-ID is not a high school course, then COURSE-SEQUENCE-CODE must be "A". • 50300-0013 (New) • If SERVICE-ID is not a high school course, then COURSE-SEQUENCE-CODE must be "A".

More Related