ASTEP New Cert Steps

Modified on Tue, 24 Mar at 9:06 AM

Add Tables
1. EquivalentCourses
2. EquivalentCourseGroups
Update Table
1. [UserProgress] ->[EquivalentCourseGroupID] (Int, Allow Nulls)
Add Stored Procedures
1. GetEquivalentCourseByEquivalentCourseGroupID
2. GetEquivalentCourseByCourseID
Update Stored Procedures
1. PullProgramSectionCourseDisplayData
2. InsertUpdateUserProgress
Insert Products
Insert Programs
Insert Program Sections
Duplicate Courses from APP
1. Run DuplicateCourses Code Snippet
Insert Courses for PEDS
Insert CourseContent for PEDS
Insert EquivalentCourseGroups
Insert EquivalentCourses
Insert EventCategories
Insert MetaCategories PEDS=552
Insert Events/Credits/CourseEvents
1. Use InsertEventsCreditsCourseEvents
Insert EventEvaluations (Eval ID 32)