ADVISER 2025-2026 Certification Tests NebSIS.xlsx

	A	B	C	D	E	F	G
1	IR Ref	Resource	Test	Result	Notes / Response	Unsupported Feature?	Known Issue?
2	-	-	Demonstrate how the 25-26 ADVISER connection is set up (with new URL)	ok
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	ok
8	3.4	GradingPeriod	Verify the expected grading period records are published for each school	ok	Updated primary key
9	3.3	Session	Verify the expected session records are published for each school	ok	Updated grading period key
10	4.1	CourseOffering	Verify that the course offerings are published, including instructional time planned	ok	Updated instructional time planned validation
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
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	ok
17			Check for orphaned records after changing a student's state ID in the SIS	ok
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	Removed language codes
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	New core format crisis events
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	New core format for dual credit
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	N/A
30	10.2	StudentDisciplineIncident BehaviorAssociation	Associate a student as a perpetrator participant type to an incident submitted above	ok	New behavior code
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	New weapon formatting
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	N/A
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	10.5	RestraintEvent	Submit a restraint event for a student including multiple Restraint Categories	ok
36	12.1	Grade	Submit a Final grade for a student enrolled in a section for its full length	ok	Updated grading period key
37	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
38			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	Updated setting codes, removed placement type
39			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
40			Submit a SPED program record with multiple disabilities, and that the disability orders are correct	ok
41	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	Updated service descriptors
42	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
43			Submit a Head Start EC program record for a student that includes the EarlyLearningSetting descriptor	ok
44	13.5	Student Homeless Program Association	Verify that a Homeless program record can be submitted including the PrimaryNightTimeResidence and UnaccompaniedYouth fields	ok
45	13.6	Student SchoolFoodService Program Association	Submit a Food Program record for an enrolled student including the SchoolFoodServiceProgramService descriptor	ok
46	13.7	Student LanguageInstruction Program Association	Submit a language program record for a student that include the EL Participation, LanguageInstructionProgram services, RedesignatedEnglishFluent, and DismissedViaIEPReview fields	ok
47		Program	Verify that existing programs are not altered	ok	No program syncing needed
48	13.1	StudentProgramAssociation	Submit a Rule 18 Interim program record for a student	ok
49			Verify that the proper EdOrg (School or LEA level) and ProgramEdOrg (LEA) references were submitted for each type of program	ok
50	14.1	StudentAcademicRecord	[Optional] Submit a record for a high school student	N/A
51	14.2	CourseTranscript	[Optional] Submit course transcript records for a 12th grader, which includes multiple years of course history (9th-12th grades)	N/A
52	7.1	Staff EdOrg Assignment Association	Verify that these records are published for all teachers	ok
53	7.2	StaffSchoolAssociation	Verify these records are published for all teachers at their assigned schools	ok
54	7.3	StaffSectionAssociation	Verify that primary instructor records are published for all teachers connected to a section	ok	Updated primary key
55	5.1	Contact	Verify a contact record can be published, including address and properly formatted unique ID	ok
56	5.2	StudentContactAssociation	Verify that enrolled students can be associated with their contact records	ok
57		StudentAssessment	[Optional] If needed by your districts, verify that assessment results can be uploaded for one of the existing test Assessments	N/A	NAI assessment results if any district is not using NWEA MAP
58	PRIOR YEAR API
59	-	-	Demonstrate how the 25-26 ADVISER connection with the new URL is maintained separately from the 24-25 connection and how users publish this data	ok	by request
60	11.2	Prior Year StudentSchoolAssociation	Verify that enrollment records can be added and updated for students	ok
61			Verify that exit dates and exit withdraw codes can be updated, especially dropouts, completers, and inter-district transfers	ok
62	6.1	Prior Year PostGraduateActivity	Verify a PostGraduateActivity record can be submitted for a 24-25 senior student (due in June 2026)	ok
63	11.1	Prior Year Student EdOrg Association	Verify all fields in the demographics record can be updated for an enrolled student, including the student address (due in April 2026)	ok
64
65
66
67
68
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