ADVISER 2024-2025 Certification Tests Infinite Campus.xlsx

	A	B	C	D	E	F	G
1	IR Ref	Resource	Test	Result	Notes / Response	Unsupported Feature?	Known Issue?
2	-	-	Demonstrate how the 24-25 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.3	Session	Verify the expected session records are published for each school	ok
9	3.4	GradingPeriod	Verify the expected grading period records are published for each school	ok
10	4.1	CourseOffering	Verify that the course offerings are published, including inst. minutes	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, Female Only, and/or Male Only SectionCharacteristics can be published if needed	n/a
13	12.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			[Optional] Demonstrate ending an enrollment with a 200 exit type for the purposes of changing a student's FTE/etc. and how the following enrollment is generated	ok	users can enter this data manually
15			Upload a summer transfer student that enters and exits without having any in-session days	ok	no calendar attached on these, but this should be ok
16			Verify that the StudentDaysEnrolled calendar override field can be published if available, and is left blank otherwise	ok
17			Check for orphaned records after deleting a student's enrollment from the district completely	ok
18			Check for orphaned records after changing a student's state ID in the SIS	ok
19	12.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, and each of the StudentCharacteristics	ok
20			Submit the new Met State Graduation Requirements student characteristic	ok
21			Submit a demographics record for a 9th grader that sets their graduation CohortYear	ok
22			Verify the "Test" studentCrisisEvent descriptor can be submitted, as well as the DisplacedStudentIndicator	n/a
23			Verify each of the digital access Student Indicators can be published	ok
24			Verify that a student's physical and/or mailing address can be published	ok
25	12.3	StudentSectionAssociation	Submit a record for a high school student that is enrolled for the full length of the course, including the DualCredit field	ok
26			Demonstrate how to update the student section record to indicate a student has failed or withdrew	ok
27	9.1	Student SchoolAttendance Event	Verify that absence records are sent as expected for students, including partial absences	ok
28			After setting up a calendar day as a half instructional day, submit an absence for a student that missed that entire day	ok
29			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
30	9.2	Student SectionAttendance Event	[Optional] Verify section attendance events are published, including partial absences	ok
31	11.1	DisciplineIncident	Submit discipline incidents with all core fields	ok
32			[CRDC] Submit an incident with the HomicideIndicator and ShootingIndicator flags set	n/a
33	11.2	StudentDisciplineIncident BehaviorAssociation	Associate a student as a perpetrator participant type to an incident submitted above	ok
34			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 SeriosBodilyInjury fields	ok
35	11.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
36	11.4	DisciplineAction	Submit a discipline action tied to the student/incident submitted earlier, including the GFSAExpulsionModifiedToLessThanOneYear field	ok
37			Submit a discipline action ties to a SPED student that also features the UnilateralRemoval field	ok
38	14.8	RestraintEvent	Submit a restraint event for a student including multiple Restraint Categories	ok
39	13.1	Grade	Submit a Final grade for a student enrolled in a section for its full length	ok
40			[Optional] Submit a progress, quarter, and/or semester grade for a student in a section	ok
41	14.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
42			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, PlacementType, ToTakeAlternateTest, InitialSpecialEducationEntryDate, IEPBeginDate, PartCtoBTransitionDelayReason, end date, and ReasonExited	ok
43			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
44			Submit a SPED program record with multiple disabilities, and that the disability orders are correct	ok
45	14.3	Student TitleIPartA Program Association	Submit a Title I program record for a student that features multiple services and includes the TitleIPartAParticipant descriptor	ok
46	14.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
47			Submit a Head Start EC program record for a student that includes the EarlyLearningSetting descriptor	ok
48	14.5	Student Homeless Program Association	Verify that a Homeless program record can be submitted including the PrimaryNightTimeResidence and UnaccompaniedYouth fields	ok
49	14.6	Student SchoolFoodService Program Association	Submit a Food Program record for an enrolled student including the SchoolFoodServiceProgramService descriptor	ok
50			Submit multiple Food Program records for an enrolled student who changes their FRL status during the year	ok
51	14.7	Student LanguageInstruction Program Association	Submit a language program record for a student that include the EL Participation, LanguageInstructionProgram services, and RedesignatedEnglishFluent fields	ok
52			Verify the new DismissedViaIEPReview option for the language instruction program can be sent and that the participation flag is set to false	ok
53	2.4	Program	Submit a fulltime remote Learning Modality program	ok
54			Submit a hybrid Learning Modality program	ok
55			Verify that existing programs are not altered	ok
56	14.1	StudentProgramAssociation	Submit a Learning Modality program record for a students for any of the programs created above	ok
57			Alter & remove a student's Learning Modality program record	ok
58			Submit a Rule 18 Interim program record for a student, including a valid Rule 18 Interim Program EdOrg ID on the record	ok	users can set these locations up via an unlocked dictionary
59			Verify that the proper EdOrg (School or LEA level) and ProgramEdOrg (LEA) references were submitted for each type of program	ok
60	15.1	StudentAcademicRecord	[Optional] Submit a record for a high school student	ok
61	15.2	CourseTranscript	[Optional] Submit course transcript records for a 12th grader, which includes multiple years of course history (9th-12th grades)	ok
62	7.1	Staff EdOrg Assignment Association	Verify that these records are published for all teachers	ok
63			[Optional] Verify these records can be published for other users (such as the superintendent)	ok
64	7.2	StaffSchoolAssociation	Verify these records are published for all teachers at their assigned schools	ok
65	7.3	StaffSectionAssociation	Verify that primary instructor records are published for all teachers connected to a section	ok
66	7.5	Staff EdOrg Contact Association	[CRDC] Verify all fields in this resource can be published	n/a
67	5.1	Parent	[Optional] Verify a parent record can be published	ok
68			[Optional] Verify the parent phsyical and/or mailing address is published	ok
69			[Optional] Verify the parent unique ID is generated properly	ok
70	5.2	StudentParentAssociation	[Optional] Verify that enrolled students can be associated with their parent records	ok
71	10.1	Cohort	[Optional] Verify that a manually defined cohort (for assessment rostering purposes) can be published, demonstrate all methods available to create this	n/a
72	10.2	StaffCohortAssociation	[Optional] Verify that a staff member with an existing state staff ID can be assigned to a cohort	n/a
73	10.3	StudentCohortAssication	[Optional] Verify that a student can be assigned to a cohort	n/a
74	PRIOR YEAR API
75	-	-	Demonstrate how the 24-25 ADVISER connection with the new URL is maintained separately from the 23-24 connection and how users publish this data	ok
76	11.2	Prior Year StudentSchoolAssociation	Verify that enrollment records can be added and updated for students	ok
77			Verify that exit dates and exit withdraw codes can be updated, especially dropouts, completers, and inter-district transfers	ok
78	6.1	Prior Year PostGraduateActivity	Verify a PostGraduateActivity record can be submitted for an 23-24 senior student (due in June 2025)	ok
79	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 2025)	ok
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100