Versions Compared

Key

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

...

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
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. 

Matching criteria

Different schools may have their course/transcript data organized differently.  This means they may want different criteria to drive the matching logic between plan and transcript.  We will assume that three criteria are non-negotiable and static; term_code, formatted_course, and course_code.  In addition to the static matching criteria, 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.  


Implementation Concerns for Phase 1

...