...
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| name | external_program | MAP-MainPage | Filter by Program | Name of the degree program. A distinct list of program_names in external_course_program, and does not include all external_program rows. | Filter by Program |
| tag | external_course_tag | MAP-MainPage | Filter by Tag Tags | Identifies the code used to identify the tag in SSP admin. The tag code is displayed for rows in external_course_tag for each matching course_code in external_course. Multiple tags can be displayed in this field. | Filter by Tag |
| name | external_term | MAP-MainPage | Filter by Term; Spring 2014 | Name of the academic term. A distinct list of term_codes in external_course_term for each external_course_term row. | Filter by Term |
| title
| external_course | MAP-MainPage | Title | The full course title | General Aerospace |
| <Plan Title> | MAP-MainPage | Plan Title | This 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 | |
| status | external_person_planning_status | Main-Dashboard Main-Details MAP-MainPage | Student is CurrentlyPlan Status | The status of the active plan. Valid values are On and Off. | Off Plan |
| status_reason | external_person_planning_status | MAP-MainPage | ? | 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> | MAP-MainPage | Current Total Plan Cr Hrs | This 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> | MAP-MainPage | Dev Cr Hrs | This 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 | 0 | |
| formatted_course | external_course | MAP-MainPage MAP-CourseDetails | Course | The formatted course | AES118 |
| min_credit_hours | external_course | MAP-MainPage MAP-CourseDetails | Min Credit Hours | The minimum number of credit hours a student can earn in a course | 3 |
| is_dev | external_course | MAP- MainPage | The course is a "dev ed" course | Y | |
| <Term Cr Hrs> | MAP-MainPage | Term Cr Hrs | This data is populated from an internal SSP database. This value is the sum of the course min_credit_hours for the selected term. | 8 |
...