ADVISER 2026-2027 Certification Tests v11.0 - Powerschool.xlsx

	A	B	C	D	E	F	G
1	IR Ref	Resource	Test (updated tests for this year highlighted yellow)	Result	Notes / Response	Unsupported Feature?	Known Issue?
2	-	-	Demonstrate how the 26-27 ADVISER connection is set up (with new URL)	Ok	New DEX setup needed using latest version
3	2.1	Location	Verify that locations are published	Ok
4	2.2	ClassPeriod	Verify periods are published	Ok
5	3.1	Calendar	Publish at least one calendar for each school that is being used	Ok
6	3.2	CalendarDate	Dates are published for all of the calendars published above, verify that Instructional event type days are submitted and that the InstructionalDuration is filled out for appropriate dates	Ok
7			After the dates have been published, update the instructional duration for a date as if it was a half snow day
8	3.4	GradingPeriod	Verify the expected grading period records are published for each school	Ok
9	3.3	Session	Verify the expected session records are published for each school	Ok
10	4.1	CourseOffering	Verify that the course offerings are published, including instructional time planned	Ok
11	4.2	Section	Verify that all section records are published, including the career academy and distance learning SectionDelivery fields	Ok
12			[Optional/CRDC] Verify the Block Schedule SectionCharacteristics can be published if needed	N/A
13	11.2	StudentSchoolAssociation	Verify that enrollment records for students are published with all usable fields (Entry Type, grade level, residency status, FTE, reporting school, resident district, resident school)	Ok	Error with leading zero for resident school
14			Upload a summer transfer student that enters and exits without having any in-session days	Ok
15			Verify that the StudentDaysEnrolled calendar override field can be published if available, and is left blank otherwise	Ok
16			Check for orphaned records after deleting a student's enrollment from the district completely
17			Check for orphaned records after changing a student's state ID in the SIS
18	11.1	Student EdOrg Association	Submit a demographics record for a student that contains all usable fields, including the ImmigrantIndicator field, the local ID, multiple race codes, dominant language, and each of the StudentCharacteristics	Ok
19			Submit a demographics record for a 9th grader that sets their graduation CohortYear	Ok
20			Verify a displaced student can be submitted under the "Test Crisis Event" along with the displaced student status descriptor	Ok
21			Verify each of the digital access Student Indicators can be published	Ok
22			Verify that a student's physical and/or mailing address can be published	Ok
23	11.3	StudentSectionAssociation	Submit a record for a high school student that is enrolled for the full length of the course, including the DualCreditIndicator and DualCreditTypeDescriptor	Ok
24			Demonstrate how to update the student section record to indicate a student has failed or withdrew	Ok
25	9.1	Student SchoolAttendance Event	Verify that absence records are sent as expected for students, including partial absences	Ok
26			After setting up a calendar day as a half instructional day, submit an absence for a student that missed that entire day	Ok
27			After setting up a calendar day as a half instructional day, submit an absence for a student that missed half of that half day	Ok
28	10.1	DisciplineIncident	Submit discipline incidents with all core fields	Ok
29			[CRDC] Submit an incident with the HomicideIndicator and ShootingIndicator flags set	Ok
30	10.2	StudentDisciplineIncident BehaviorAssociation	Associate a student as a perpetrator participant type to an incident submitted above	Ok
31			Associate a student as a perpetrator participant type to an incident submitted above that includes all usable fields as well as a gun as a Weapon, plus the GunFreeSchoolViolation, ReferralToLawEnforcement, SchoolRelatedArrestIndicator, and SeriousBodilyInjury fields	Ok
32	10.3	StudentDisciplineIncident NonOffenderAssociation	[CRDC] Associate a student to an incident that features one of the harassment or bullying behavior codes, as a victim participant type	Ok
33	10.4	DisciplineAction	Submit a discipline action tied to the student/incident submitted earlier, including the GFSAExpulsionModifiedToLessThanOneYear field	Ok
34			Submit a discipline action ties to a SPED student that also features the UnilateralRemoval field	Ok
35	15.1	RestraintEvent	Submit a restraint event for a student including multiple Restraint Categories	Need to verify restraint event category bug
36	15.2	EmergencyExclusions	Submit an Emergency Exclusion record for a student with all available elements included	Ok	New resource added during 25-26
37	12.1	Grade	Submit a Final grade for a student enrolled in a section for its full length	Ok
38	13.2	Student SpecialEducation Program Association	Demonstrate how districts would skip publishing this data if they wish to publish SPED data using only NE's SRS	Ok
39			Submit a SPED program record for a student that was in SPED, verify that the StartDate is within the current school year, and that all SPED program fields can be submitted including Service(s), Program, Setting, ToTakeAlternateTest, InitialSpecialEducationEntryDate, IEPBeginDate, PartCtoBTransitionDelayReason, EndDate, and ReasonExited	Ok
40			Submit multiple SPED records for a student that changes their program setting during the school year, verify the end dates and exit code are correct	Ok
41			Submit a SPED program record with multiple disabilities, and that the disability orders are correct	Ok
42	15.3	IDEA Event	Submit multiple IDEA Event records for a student, including those for the Parent Consent, Evaluation, and Eligibility Determination or Non-Eligibility Determination IDEA Event Types	Ok	New resource
43			Demonstrate how districts would skip publishing this data if they wish to publish data using only NE's SRS	Ok	Shut off in Resource Configuration
44	13.3	Student TitleIPartA Program Association	Submit a Title I program record for a student that features multiple services and includes the TitleIPartAParticipant descriptor	Ok
45	13.4	Student EarlyLearning Program Association	Submit a non-Head Start EC program record for a student that includes the EarlyLearningSetting descriptor, make note if multiple EC records can be submitted for student	Ok
46			Submit a Head Start EC program record for a student that includes the EarlyLearningSetting descriptor	Ok
47	13.5	Student Homeless Program Association	Verify that a Homeless program record can be submitted including the PrimaryNightTimeResidence and UnaccompaniedYouth fields	Ok
48	13.6	Student SchoolFoodService Program Association	Submit a Food Program record for an enrolled student including the SchoolFoodServiceProgramService descriptor	Ok
49	13.7	Student LanguageInstruction Program Association	Submit a language program record for a student that include the EL Participation, LanguageInstructionProgram services, RedesignatedEnglishFluent, and TestedProficientOnScreener fields	Ok	Recommend wording change to new flag (16)
50	13.1	StudentProgramAssociation	Submit a Rule 18-Interim Program record for a student	Ok
51			Submit an IRIP program record for a student	Ok	New program type
52			Verify that the proper EdOrg (School or LEA level) and ProgramEdOrg (LEA) references were submitted for each type of program	Ok
53	14.1	StudentAcademicRecord	Submit a record for a high school student, which includes multiple years of course history (starting at 9th grade)	Ok
54	14.2	CourseTranscript	Submit course transcript records for a high school student, which includes multiple years of course history (starting at 9th grade)	Ok
55			Submit a course transcript record that includes all of the supported credit related fields	Ok	Defaults to Classroom credit/General only
56			Submit a course transcript record that includes all of the Alternative/External reference fields	Ok	Supports all
57	7.1	Staff EdOrg Assignment Association	Verify that these records are published for all teachers	Ok
58	7.2	StaffSchoolAssociation	Verify these records are published for all teachers at their assigned schools	Ok
59	7.3	StaffSectionAssociation	Verify that primary instructor records are published for all teachers connected to a section	Ok
60	5.1	Contact	Verify a contact record can be published, including address and properly formatted unique ID	Ok
61	5.2	StudentContactAssociation	Verify that enrolled students can be associated with their contact records	Ok
62		StudentAssessment	[Optional] If needed by your districts, verify that assessment results can be uploaded for one of the existing test Assessments	N/A
63	PRIOR YEAR API
64	-	-	Demonstrate how the 26-27 ADVISER connection with the new URL is maintained separately from the 25-26 connection and how users publish this data	Ok
65	11.2	Prior Year StudentSchoolAssociation	Verify that enrollment records can be added and updated for students	Ok
66			Verify that exit dates and exit withdraw codes can be updated, especially dropouts, completers, and inter-district transfers	Ok
67	6.1	Prior Year PostGraduateActivity	Verify a PostGraduateActivity record can be submitted for a 25-26 senior student (due in June 2027)	Ok
68	11.1	Prior Year Student EdOrg Association	Verify all fields in the student address record can be updated for an enrolled student, (due in April 2027)	Ok
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100