Tool: MAP
Description: (needs improvement, clarification, detail)
...
Includes: MAP-Main Page, MAP-Course Details (double-click on course in Course List), MAP-Financial Aid (from Financial Aid button at top of screen), MAP-Transcript (from Transcript button at top of page)
My Academic Plan (MAP) provides a method to record student plans and institution templates related to pathways to degree completion.
Attachments:
MAP - Main Page
| Parameter | External Table | Location | Field Name | Description | Example | |||
|---|---|---|---|---|---|---|---|---|
| name | external_program | MAP-MainPage | Filter by Program | |||||
| <Filter by Tag> | MAP | Filter by Tag | ||||||
| external_term | MAP | Filter by Term | ||||||
| formatted_course | external_course | MAP | Course | The formatted course | AES118 | |||
| title | external_course | Title | The full course title | General Aerospace | ||||
| min_credit_hours | external_course | MAP | Cr. | Credit hours earned by the student in the course | 3 | |||
| <Tags> | MAP | Tags | HON | |||||
| Name of the degree program. | 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 academic term. | Filter by Term | |||
| title
| 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-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 | Student is Currently | Off Plan | ||||
| status_reason | external_person_planning_status | MAP | ? | This value is accessible by hovering over the "?" beside "Student is Currently". It will only display if the student is Off Plan. | Is not doing well, needs help | |||
| -MainPage | Plan Status | The status of the active plan. Valid values are On and Off. | Off Plan | |||||
| <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 | ||||||
| Winter 2013 | ||||||||
| AUMT140 | ||||||||
| 4 | ||||||||
| Term Cr. Hrs | 8 | |||||||
| 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 |
MAP - Course Details
| Parameter | External Table | Location | Field Name | Description | Example | ||
|---|---|---|---|---|---|---|---|
| formatted_course | external_course | MAP-MainPage MAP-CourseDetails | Course | The formatted course | AST355AES118 | ||
| title | external_course | MAP-MainPage MAP-CourseDetails | Course | Individualized AstronomyThe full course title | General Aerospace | ||
| description | external_course | MAP-CourseDetails | Course Description | Individualized AstronomyThe course description as it exists in the course catalog | General Aerospace | ||
| max_credit_hours | external_course | MAP-CourseDetails | Max Credit Hours | 5The maximum number of credit hours a student can earn in a course | 8 | ||
| min_credit_hours | external_course | MAP-MainPage MAP-CourseDetails | Min Credit Hours | 2The minimum number of credit hours a student can earn in a course | 3 | ||
| department_code | external_departmentcourse | MAP-CourseDetails | Department | A unique code of the department. The value is the matching value for external_course and external_department. | DEP_AC | ||
| division_code | external_divisioncourse | MAP-CourseDetails | Division | A unique code of the division. The value is the matching value for external_course and external_division. | DIV_B | ||
| <Tags> | Tags | HON | |||||
| tag | external_course_tag | MAP-MainPage MAP-CourseDetails | 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 | ||
| master_syllabus_link | external_course_requisite | Requisites | AES118: Pre | ||||
| MAP-Course Details | Master Syllabus | An http link to the course syllabus. This link will only display when a value is defined in the database. | N/A | ||||
| academic_link | external_course | MAP-CourseDetails | Academic Link | An http link to academic information about the course. | N/A |
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_hours_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 number of transfer hours the student has completed. | Institutional |
MAP - Financial Aid (many of these values are also found in Main tool, Details tab; those not found there are mapped above)
| Parameter | External Table | Location | Field Name | Description | Example | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| grade_point_average | external_student_transcript_term | Main-Dashboard Main-Details MAP-Financial AidFinancialAid | GPA | The calculated cumulative GPA value | 1.82 | GPA | Down | ||||
| academic_standing | external_student_transcript | Main-Dashboard | Standing (Student Indicator) | Current academic standing of the student | GOOD | ||||||
| current_restrictions | external_student_transcript | Main-Dashboard Main-Details MAP-Financial AidFinancialAid | Restrictions | List of any restrictions or holds on the student record | ie. Dismissed, Hold, Fine | ||||||
| financial_aid_gpa | external_student_financial_aid | Main- Details; MAP-Financial AidFinancialAid Map- FinancialAid | FA GPA | The GPA calculated for financial aid eligibility | 1.82 | ||||||
| gpa_20_a_hrs_needed | external_student_financial_aid | MAP-FinancialAid | Hours needed to earn a 2.0 GPA with all A grades | The number of earned hours at an A level required to achieve an overall 2.0 GPA | 9 | ||||||
| gpa_20_b_hrs_needed | external_student_financial_aid | MAP-FinancialAid | Hours needed to earn a 2.0 GPA with all B grades | The number of earned hours at a B level required to achieve an overall 2.0 GPA | 9 | ||||||
| credit_hours_earned | external_student_transcript_term | Main-Details MAP-Financial AidFinancialAid | Hrs Earned | The total value of credit hours successfully completed or earned | 31 | ||||||
| credit_hours_attempted | external_student_transcript_term | Main-Details MAP-Financial AidFinancialAid | Hrs Attempted | The total value of credit hours attempted whether or not included in the hours for GPA or hours earned | 36 | ||||||
| credit_completion_rate | external_student_transcript | Main-Dashboard Main-Details MAP-Financial AidFinancialAid | Comp Rate | Completion rate of hours attempted | 86% | ||||||
| needed_for_67ptc_completion | external_student_financial_aid | MAP-FinancialAid | Hours needed to earn a 67% completion rate | The number of hours needed to reach a 67% completion rate required for financial aid (earned/attempted=completion rate) | 9 | ||||||
| term_code | external_registration_status_by_term | Main-Dashboard Main-Details MAP-Financial AidFinancialAid | RegSpecifies what term the course was taken. Equivalent to external_term.code value | List of current and future terms for which the student is registered | FA2013 | ||||||
| tuition_paid | external_registration_status_by_termMain-Dashboard | Main-Details MAP-Financial AidFinancialAid | Payment | Y or N, indicates payment status of tuition for the term | FA2013=N | ||||||
| balance_owed | external_person | Main-DetailsFinancialAid MAP-Financial AidFinancialAid | Balance | Student's balance currently owed to the college. Format is XXXXX.XX. | $0.00 | ||||||
| sap_status | external_student_financial_aid | Main-Dashboard Main-Details MAP-Financial AidFinancialAid | SAP | Y or N, indicates if the student has achieved Satisfactory Academic Progress | N | ||||||
| F1_status | external_person | Main-Dashboard Main-Details MAP-Financial AidFinancialAid | F1 | Y or N, indicates if the student has an F1 Visa on file | Y | ||||||
| FAFSA_date | external_student_financial_aid | Main-DetailsFinancialAid MAP-Financial AidFinancialAid | FAFSA | The date the FAFSA was accepted | 08/24/2013 | ||||||
| current_year_financial_aid_award | external_student_financial_aid | Main-Dashboard Main-Details MAP-Financial AidFinancialAid | FA Award | Y or N, indicates if the student received financial aid for the current academic year | Y | ||||||
| remaining_loan_amount | external_student_financial_aid | Main-DetailsFinancialAid MAP-Financial AidFinancialAid | FA Amount Remaining | The remaining amount of loans available to the student | $809.00 | ||||||
| term_code | external_student_financial_aid_award_term | Main-FinancialAid MAP-FinancialAid | FA Awarded | Specifies what term financial aid was offered to the student. Equivalent to external_term.code value. | FA12 | ||||||
| accepted | external_student_financial_aid_award_term | Main-FinancialAid MAP-FinancialAid | FA Awarded | Indicates the acceptance status of financial aid for the term. Acceptable values are Y or N | Y | ||||||
| institutional_loan_amount | external_student_financial_aid | Main-FinancialAid MAP-FinancialAid | Institutional Loan Amount | The remaining amount of financial aid available to the student | $1,300.00 | ||||||
| original_loan amount | external_student_financial_aid | Main-DetailsFinancialAid MAP-Financial AidFinancialAid | Loan Amount | The original amount of loans available to the student | $6,600.00 | ||||||
| terms_left | external_student_financial_aid | Main-FinancialAid MAP-FinancialAid | Remaining FA Terms | The number of remaining eligible terms to receive financial aid | 3.00 | ||||||
| sap_status_code | external_student_financial_aid | Main-FinancialAid MAP-FinancialAid | SAP | The SAP status code as determined by the institution. This value must match a configuration item for SAP status code in SSP administration | SAP-SAT | ||||||
| file_status | external_student_financial_aid_file | Main-FinancialAid MAP-FinancialAid | FA File | The appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDING | COMPLETE |