ADVISER 2022-2023 Certification Tests v7.0 JMC.xlsx

	A	B	C	D	E	F	G
1	IR Ref	Resource	Test	Result	Notes / Response	Unsupported Feature?	Known Issue?
2	-	-	Demonstrate how the 22-23 ADVISER connection is set up	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			Publish a 2nd calendar for one of the schools above	OK
7	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
8			After the dates have been published, update the instructional duration for a date as if it was a half snow day
9	3.3	Session	Verify the expected session records (per the SIS) are published for each school	OK
10	3.4	GradingPeriod	Verify the expected grading period records (per the SIS) are published for each school	OK
11	4.1	CourseOffering	Verify that the course offerings are published	OK
12			Demonstrate how the instructional time planned field is submitted, and how it is calculated if not directly entered by users	OK	Can be either manually entered or automatically calculated
13	4.2	Section	Verify that all section records are published, including career academy and distance learning SectionDelivery fields	OK
14			[Optional] Verify that a CourseStaffIdOverride can be published if needed, and is left blank otherwise	N/A	Not used in JMC
15			[CRDC] Verify the Block Schedule, Female Only, and/or Male Only SectionCharacteristics can be published if needed	N/A
16	12.2	StudentSchoolAssociation	Verify that enrollment records for regular students are published with all usable fields (Entry Type, grade level, residency status, FTE, reporting school, resident district, resident school, expected graduation school). Verify the new FTE format	OK
17			Verify all new Exit Withdraw codes are usable	N/A
18			Update a student to move them into a separate calendar	N/A
19			Upload a contract or option in status student whose resides in another district	OK
20			Upload a summer transfer student that enters and exits without having any in-session days	OK
21			Verify that the StudentDaysEnrolled calendar override field can be published if available, and is left blank otherwise	OK	Not used in JMC
22			[Optional] If needed by districts, demonstrate that multiple enrollment records can be submitted for a student within a district and verify that the FTE, reporting school, and entry/exit date fields align correctly	N/A	Not used in JMC
23			Check for orphaned records after deleting a student's enrollment from the district completely	N/A	No issues
24			Check for orphaned records after changing a student's state ID in the SIS	N/A	No issues
25	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
26			Submit a demographics record for a 9th grader that correctly sets their graduation CohortYear	OK
27			Verify the "Test" studentCrisisEvent descriptor can be submitted, as well as the DisplacedStudentIndicator	OK
28			Verify each of the digital equity Student Indicators can be published and that the text values match the updated 21-22 specs exactly	OK	New feature for importing from previous year
29			Verify that a student's physical or mailing+physical address can be published	OK
30	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
31			Submit a record for a high school student that drops a course before it finishes, including the attempt status	OK	Student grades can be manually marked as W for withdrawn, or can be deleted from section entirely
32			Update an existing record to reflect a failed and/or incomplete attempt status after the course grade has been finalized	OK	Final grades that are set to any unspecified grade mark are defaulted to Fail
33	9.1	Student SchoolAttendance Event	Verify that absence records are sent as expected for students, including partial absences. Verify all new attendance codes are usable.	OK
34			After setting up a calendar day as a half instructional day, submit an absence for a student that missed that entire day	OK
35			After setting up a calendar day as a half instructional day, submit an absence for a student that missed half of that day	OK
36	9.2	Student SectionAttendance Event	[Optional] Verify section attendance events are published, including partial absences	OK	Can activate on a per grade level basis
37	11.1	DisciplineIncident	Submit discipline incidents with all core fields	OK
38			[CRDC] Submit an incident with the HomicideIndicator and ShootingIndicator flags set	N/A
39	11.2	StudentDisciplineIncident Association	Associate a student as a perpetrator to an incident submitted above that includes all usable fields	OK
40			Associate a student as a perpetrator to an incident submitted above that includes the new 22-23 behavior codes (114 – 118)	OK
41			Associate a student as a perpetrator 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
42			[CRDC] Associate a student to an incident that features one of the harassment or bullying behavior codes, as a victim	N/A
43	11.3	DisciplineAction	Submit a discipline action tied to the student/incident submitted earlier, including the GFSAExpulsionModifiedToLessThanOneYear field	OK
44			Submit a discipline action ties to a SPED student that also features the UnilateralRemoval field	OK
45	14.8	RestraintEvent	Submit a restraint event for a student including multiple Restraint Categories	OK
46	13.1	Grade	Submit a Final grade for a student enrolled in a section for its full length	OK
47			[Optional] Submit a progress, quarter, and/or semester grade for a student in a section	N/A
48	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
49			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, and InitialSpecialEducationEntryDate	OK
50			Submit a SPED program record for a student that first enters SPED in October of the current year, and then exits SPED before the end of the year. Verify the start date, end date, and ReasonExited are valid	OK
51			Submit multiple SPED records for a student that changes their program type (Part C to B) or setting during the school year, verify the end dates and exit code are correct	OK
52	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
53	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
54			Submit a Head Start EC program record for a student that includes the EarlyLearningSetting descriptor	OK
55	14.5	Student Homeless Program Association	Verify that a Homeless program record can be submitted including the PrimaryNightTimeResidence and UnaccompaniedYouth fields	OK
56	14.6	Student SchoolFoodService Program Association	Submit a Food Program record for an enrolled student including the SchoolFoodServiceProgramService descriptor	OK
57			Submit multiple Food Program records for an enrolled student who changes their FRL status during the month of October	OK
58	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
59	2.4	Program	Submit a fulltime remote Learning Modality program	OK
60			Submit a hybrid Learning Modality program	OK
61			Verify that existing programs are not altered	OK
62	14.1	StudentProgramAssociation	Submit a Learning Modality program record for a students for each of the programs created above, make note of any methods for assigning multiple students to a learning modality at the same time if any	OK
63			Alter & remove a student's Learning Modality program record	OK
64			Submit a Rule 18 Interim program record for a student	OK
65			Verify that the proper EdOrg (School or LEA level) and ProgramEdOrg (LEA) references were submitted for each type of program	OK
66	15.1	StudentAcademicRecord	[Optional] Submit a record for a high school student	N/A
67	15.2	CourseTranscript	[Optional] Submit course transcript records for a 12th grader, which includes multiple years of course history (9th-12th grades)	N/A
68	7.1	Staff EdOrg Assignment Association	Verify that these records are published for all teachers	OK
69			[Optional] Verify these records can be published for other users that may want access to the dashboard (such as the superintendent)	OK	JMC may look into option to manually set end date on staff, default end date of 9/1 of following year
70			Check for orphaned records after changing a teacher's state ID in the SIS	N/A	No issues
71	7.2	StaffSchoolAssociation	Verify these records are published for all teachers at their assigned schools	OK
72	7.3	StaffSectionAssociation	Verify that primary instructor records are published for all teachers connected to a section	OK
73	7.5	Staff EdOrg Contact Association	[CRDC] Verify all fields in this resource can be publsihed, specifically each of the Civil Rights Coordinator ContactTypeDescriptors	N/A
74	5.1	Parent	[Optional] Verify a parent record can be published, make note of the method used for indicating the primary parent if any	OK
75			[Optional] Verify the parent phsyical or mailing+physical address is published	OK
76			[Optional] Verify the parent unique ID is generated properly	OK
77	5.2	StudentParentAssociation	[Optional] Verify that enrolled students can be associated with their parent records	OK
78	10.1	Cohort	Verify that a manually defined cohort (for assessment rostering purposes) can be published, demonstrate all methods available to create this	N/A
79	10.2	StaffCohortAssociation	Verify that a staff member with an existing state staff ID can be assigned to a cohort	N/A
80	10.3	StudentCohortAssication	Verify that a student can be assigned to a cohort	N/A
81	PRIOR YEAR API
82	-	-	Demonstrate how the 21-22 ADVISER connection is maintained separately from the 22-23 connection	OK	Users can switch to prior year in JMC
83	11.2	Prior Year StudentSchoolAssociation	Verify that enrollment records can be added and updated for students	OK
84			Verify that exit dates and exit withdraw codes can be updated, especially dropouts, completers, and inter-district transfers	OK
85	6.1	Prior Year PostGraduateActivity	Verify a PostGraduateActivity record can be submitted for an 21-22 senior student (due in June 2023)	OK
86	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 June 2023)	OK
87	13.2	Prior Year Student SpecialEducation Program Association	Verify that a SPED program record can be updated for a student that began before 7/1/2022	OK
88	13.3	Prior Year Student TitleIPartA Program Association	Submit a Title I program record for a student that features multiple services and includes the TitleIPartAParticipant descriptor	OK
89	4.1	CourseOffering	Verify that the course offerings are published	OK
90	4.2	Section	Verify that all section records are published, including career academy and distance learning SectionDelivery fields	OK
91	11.3	StudentSectionAssociation	Submit a record for a student	OK
92	7.3	StaffSectionAssociation	Verify that primary instructor records are published for all teachers connected to a section	OK
93
94
95
96
97
98
99
100