...
Any other information that is necessary - put it here.
Attachments:
MAP - Main Page
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| name | external_program | MAP | Filter by Program | Name of the degree program | Filter by Program |
| external_course_tag | tag | MAP | Filter by Tag | Identifies the code used to identify the tag in SSP admin | Filter by Tag |
| name | external_term | MAP | Filter by Term | Filter by Term | |
| formatted_course | external_course | MAP MAP-Course Details | Course | The formatted course | AES118 |
| title | external_course | MAP | Title | The full course title | General Aerospace |
| min_credit_hours | external_course | MAP | Cr. | The minimum number of credit hours a student can earn in a course | 3 |
| external_course_tag | tag | MAP MAP-Course Details | Tags | Identifies the code used to identify the tag in SSP admin | 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. The sum of the course min_credit_hours for the selected term | 8 |
MAP - Course Details
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| formatted_course | external_course | MAP MAP-Course Details | Course | The formatted course | AST355 |
| title | external_course | MAP-Course Details | Course | The full course title | Individualized Astronomy |
| description | external_course | MAP-Course Details | Course Description | The course description as it exists in the course catalog | Individualized Astronomy |
| max_credit_hours | external_course | MAP-Course Details | Max Credit Hours | The maximum number of credit hours a student can earn in a course | 5 |
| min_credit_hours | external_course | MAP MAP-Course Details | Min Credit Hours | The minimum number of credit hours a student can earn in a course | 2 |
| department_code | external_department | MAP-Course Details | Department | A unique code of the department | DEP_AC |
| division_code | external_division | MAP-Course Details | Division | A unique code of the division | DIV_B |
| external_course_tag | tag | MAP MAP-Course Details | Tags | Identifies the code used to identify the tag in SSP admin | HON |
| required_formatted_course | external_course_requisite | MAP-Course Details | Requisites | The formatted course value for the required course | AES118 |
| requisite_code | external_course_requisite | MAP-Course Details | Requisites | Identifies the code used to identify the tag in SSP admin | Pre |
| academic_link | external_course | MAP-Course Details | Academic Link | An http link to academic information about the course |
MAP - Transcript (these values are also found in the Main-Transcript tool. See that page for mapping.)
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| term_code | external_student_transcript_course | Main-Schedule Main-Transcript MAP-Transcript | Term | Specifies what term the course was taken by the student and taught by the faculty member. | FA2013 |
| formatted_course | external_student_transcript_course | Main-Schedule | Course | The formatted course | AUMT246 |
| title | external_student_transcript_course | Main-Schedule Main-Transcript MAP-Transcript | Course Title | The full course title | College Writing II |
| credit_earned | external_student_transcript_course | Main-Schedule Main-Transcript MAP-Transcript | Cr Hrs | Credit hours earned by the student in the course. | 3 |
| grade | external_student_transcript_course | Main-Transcript MAP-Transcript | Grade | Grade earned in the course by the student. | F |
| credit_type | external_student_transcript_course | Main-Details Main-Transcript MAP-Transcript | Credit Type | Indicates the type of credit earned by the student | Institutional |
MAP - Financial Aid (many of these values are also found in Main tool, Details tab; those not found there are mapped above)
...