...
| Parameter | External Table | Location | Field Name | Description | Example | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| name | external_program | MAP | 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 | 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 | 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 | ||||||
| formatted_course | external_course | MAP MAP-Course Details | Course; AUMT140 | The formatted course | AES118 | ||||||
| title | external_course | MAP | Title | The full course title | General Aerospace | ||||||
| min_credit_hours | external_course | MAP | Cr.; 4 | The minimum number of credit hours a student can earn in a course | 3 | tag | external_course_tag | MAP MAP-Course Details | 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. | HON |
| is_dev | external_course | MAP | D | Absence or presence of "D" in this column identifies the course as a developmental education course ("D" present) or not (blank) | D | ||||||
| <Plan Title> | MAP | 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 | Student is Currently | The status of the active plan. Valid values are On and Off. | Off Plan | ||||||
| status_reason | external_person_planning_status | MAP | ? | 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 | 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 | 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 | |||||||
| name | external_term | MAP | Spring 2014 | The name of the academic term | Spring 2014 | ||||||
| formatted_course | external_course | MAP MAP-Course Details | AUMT140 | The formatted course | AUMT140 | ||||||
| min_credit_hours | external_course | MAP MAP-Course Details | 4 | The minimum number of credit hours a student can earn in a course | 4 | ||||||
| <Term Cr Hrs> | MAP | 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 |
...