Versions Compared

Old Version 19

changes.mady.by.user Anthony Arland (Deactivated)

Saved on

compared with

New Version 20

changes.mady.by.user Jason Elwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleComments
  • course_code: This may or may not be applicable here.  We are seeing more and more schools loading data into external_course with the same formatted_course but different course_id values.  This represents different versions of the course and is completely legitimate in the field.  Many schools start with this concept because the SIS table structures require different course ids for each term the course is offered.  However, different course ids in MAP are important when the course has a different definition (title, course hours, etc).  

 

 

Excerpt

New Configurations for Phase 1

namepossible valuespurpose
calculate_map_plan_statustrue, falseturns on/off cron job that will drive the calculation
map_plan_status_passing_gradesschool specific but something like (A,B,C)In cases where a plan course and taken course line up, the student must have passed the class in order to not cause a anomaly
map_plan_status_cutoff_term_codeterm_code (EXTERNAL_TERM.CODE)

The calculation cutoff term is the latest future term to be included in the matching logic.  The term range for a given calculation will start with the oldest term for the student transcripted courses up to the cutoff term.  The term must be a valid term from external_term.  

      • If no term is configured, all future terms are considered.
      • If the configured term is a past term (user forgot to update), then all terms will be used 
task_scheduler_map_plan_status_calculation_triggercron expression (i.e., 0 0 1 * * *)drives the frequency of the cron job that will calculate status
map_plan_status_addition_course_matching_criteriaavailable options are (COURSE_TITLE,CREDIT_HOURS) or blankIn addition to the static matching criteria (term_code, formatted_course, and course_code), implementors have the option to add additional criteria. COURSE_TITLE will match PLAN_COURSE.COURSE_TITLE to EXTERNAL_STUDENT_TRANSCRIPT_COURSE.TITLE and CREDIT_HOURS will match PLAN_COURSE.CREDIT_HOURS with EXTERNAL_STUDENT_TRANSCRIPT_COURSE.CREDIT_EARNED
map_plan_status_use_current_term_gradestrue,falseSome schools definitely want the ability to use current term grades in plan status calculation but it's also conceivable that school may not want to consider grades when looking at the current term. If set to false, current terms would be handled as a future term where simply a transcript match (regardless of the grade) will only be considered.

 

 

Info
titleComments

 passing_grades: Dan also questioned the need for more complexity.  Maybe I'm missing something that you both are seeing.  The basic functionality is to check to see if the grade the student was awarded on their transcript is a passing grade. 

...