Versions Compared

Key

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

...

ParameterExternal TableLocationField NameDescriptionExample
nameexternal_programMAPFilter by ProgramName of the degree program 
external_course_tagtag

MAP
MAP-Course Details

Filter by TagIdentifies the code used to identify the tag in SSP admin 
nameexternal_termMAPFilter by Term  
formatted_courseexternal_courseMAP
MAP-Course Details
CourseThe formatted courseAES118
titleexternal_course

MAP
MAP-Course Details

TitleThe full course titleGeneral Aerospace
min_credit_hoursexternal_courseMAPCr.Credit hours earned by the student in the The minimum number of credit hours a student can earn in a course3
external_course_tagtagMAP
MAP-Course Details
TagsIdentifies the code used to identify the tag in SSP adminHON
is_devexternal_courseMAPDAbsence or presence of "D" in this column identifies the course as a developmental education course ("D" present) or not (blank)D
<Plan Title> MAPPlan TitleThis data is populated from an internal SSP database. The name assigned to the plan by the student or coach.Associates in Automotive Technology - Part Time
statusexternal_person_planning_statusMain-Dashboard
Main-Details
MAP
Student is CurrentlyThe status of the active plan. Valid values are On and Off.Off Plan
status_reasonexternal_person_planning_statusMAP?This value is accessible by hovering over the "?" beside "Student is Currently". This value will only display if the student is Off Plan.Is not doing well, needs help
<Current Total Plan Cr Hrs> MAPCurrent Total Plan Cr HrsThis data is populated from an internal SSP database. The minimum credit hours for each course for each term is calculated and displayed in this field.61
<Dev Cr Hrs> MAPDev Cr HrsThis data is populated from an internal SSP database. The total credit hours of "Developmental" courses in a plan. The min_credit_hours of each course where is_dev = Y 
nameexternal_termMAPSpring 2014The name of the academic term 
formatted_courseexternal_courseMAP
MAP-Course Details
AUMT140The formatted course 
min_credit_hoursexternal_courseMAP
MAP-Course Details
4The total value minimum number of credit hours successfully completed or earned.a student can earn in a course 
<Term Cr Hrs> MAPTerm Cr HrsThis data is populated from an internal SSP database. The sum of the course min_credit_hours for the selected term8

...

ParameterExternal TableLocationField NameDescriptionExample
formatted_courseexternal_courseMAP
MAP-Course Details
CourseThe formatted courseAST355
 titleexternal_courseMAP-Course DetailsCourseThe full course titleIndividualized Astronomy
descriptionexternal_courseMAP-Course DetailsCourse DescriptionThe course description as it exists in the course catalogIndividualized Astronomy
max_credit_hoursexternal_courseMAP-Course DetailsMax Credit HoursThe total value maximum number of credit hours successfully completed or earneda student can earn in a course5
min_credit_hoursexternal_courseMAP
MAP-Course Details
Min Credit HoursThe total value minimum number of credit hours successfully completed or earneda student can earn in a course2
department_codeexternal_departmentMAP-Course DetailsDepartmentA unique code of the departmentDEP_AC
division_codeexternal_divisionMAP-Course DetailsDivisionA unique code of the divisionDIV_B
external_course_tagtagMAP
MAP-Course Details
TagsIdentifies the code used to identify the tag in SSP adminHON
required_formatted_courseexternal_course_requisiteMAP-Course DetailsRequisitesThe formatted course value for the required courseAES118
requisite_codeexternal_course_requisiteMAP-Course DetailsRequisitesIdentifies the code used to identify the tag in SSP adminPre
academic_linkexternal_courseMAP-Course DetailsAcademic LinkAn http link to academic information about the course 

...