Versions Compared

Key

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

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.

 

Image Added

Attachments:

MAP Diagram.jpg

MAP Diagram.pdf

MAP Diagram.vsd

 

MAP - Main Page

tagStudent is Currently
ParameterExternal TableLocationField NameDescriptionExample
nameexternal_programMAP-MainPageFilter by ProgramName of the degree program. Filter by Program
tagexternal_course_tag

MAP-MainPage
MAP-Course DetailsCourseDetails

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
nameexternal_termMAP-MainPageFilter by Term;
  
formatted_courseexternal_courseMAP
MAP-Course Details
CourseThe formatted courseAES118
titleSpring 2014Name of academic term.Filter by Term
title

 

external_course

MAP-MainPage
MAP- Course Details

TitleThe full course titleGeneral Aerospace
min_credit_hoursexternal_courseMAPCr.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> MAP-MainPagePlan 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
-MainPagePlan StatusThe 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> MAP-MainPageCurrent 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> MAP-MainPageDev 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 
0
formatted_courseexternal_courseMAP-MainPage
MAP-CourseDetails
Course DetailsAUMT140The formatted course AES118
min_credit_hoursexternal_courseMAP-MainPage
MAP-Course Details4CourseDetails
Min Credit HoursThe minimum number of credit hours a student can earn in a course3
is_devexternal_courseMAP- MainPage The course is a "dev ed" courseY
<Term Cr Hrs> MAP-MainPageTerm Cr HrsThis data is populated from an internal SSP database. The This value is the sum of the course min_credit_hours for the selected term.8


MAP - Course Details

tag
ParameterExternal TableLocationField NameDescriptionExample
formatted_courseexternal_courseMAP-MainPage
MAP-Course DetailsCourseDetails
CourseThe formatted courseAST355AES118
 titleexternal_courseMAP-MainPage
MAP-Course DetailsCourseDetails
CourseThe full course titleIndividualized AstronomyGeneral Aerospace
descriptionexternal_courseMAP-Course DetailsCourseDetailsCourse DescriptionThe course description as it exists in the course catalogIndividualized AstronomyGeneral Aerospace
max_credit_hoursexternal_courseMAP-Course DetailsCourseDetailsMax Credit HoursThe maximum number of credit hours a student can earn in a course58
min_credit_hoursexternal_courseMAP-MainPage
MAP-Course DetailsCourseDetails
Min Credit HoursThe minimum number of credit hours a student can earn in a course23
department_codeexternal_departmentcourseMAP-Course DetailsCourseDetailsDepartmentA unique code of the department. The value is the matching value for external_course and external_department.DEP_AC
division_codeexternal_divisioncourseMAP-Course DetailsCourseDetailsDivisionA unique code of the division. The value is the matching value for external_course and external_division.DIV_B
tagexternal_course_tagMAP-MainPage
MAP-Course DetailsCourseDetails
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_requisite. 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_linkexternal_courseMAP-Course DetailsRequisitesIdentifies the code used to identify the tag in SSP adminPreMaster SyllabusAn http link to the course syllabus. This link will only display when a value is defined in the database.N/A
academic_linkexternal_courseMAP-Course DetailsCourseDetailsAcademic LinkAn 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.)

ParameterExternal TableLocationField NameDescriptionExample
term_codeexternal_student_transcript_courseMain-Schedule
Main-Transcript
MAP-Transcript
TermSpecifies what term the course was taken by the student and taught by the faculty member.FA2013
formatted_courseexternal_student_transcript_course

Main-Schedule
Main-Transcript
MAP-Transcript

CourseThe formatted courseAUMT246
titleexternal_student_transcript_courseMain-Schedule
Main-Transcript
MAP-Transcript
Course TitleThe full course titleCollege Writing II
credit_hours_earnedexternal_student_transcript_courseMain-Schedule
Main-Transcript
MAP-Transcript
Cr HrsCredit hours earned by the student in the course.3
gradeexternal_student_transcript_courseMain-Transcript
MAP-Transcript
GradeGrade earned in the course by the student.F
credit_typeexternal_student_transcript_courseMain-Details
Main-Transcript
MAP-Transcript
Credit TypeIndicates the type of credit earned by the student

The number of transfer hours the student has completed.
Including or excluding this value from the Hrs Earned Value is optional.

Institutional


MAP - Financial Aid (many of these values are also found in Main tool, Details tab; those not found there are mapped above)

Down
ParameterExternal TableLocationField NameDescriptionExample
grade_point_averageexternal_student_transcript_termMain-Dashboard
Main-Details
MAP-Financial AidFinancialAid
GPAThe calculated cumulative GPA value1.82
gpaacademic_trend_indicatorstandingexternal_student_transcript

Main-Dashboard

GPADescribes the trend of the GPA from the previous term

Main-Details MAP-FinancialAid

Standing (Student Indicator)Current academic standing of the studentGOOD
current_restrictionsexternal_student_transcriptMain-Dashboard
Main-Details
MAP-Financial AidFinancialAid
RestrictionsList of any restrictions or holds on the student recordie. Dismissed, Hold, Fine
financial_aid_gpaexternal_student_financial_aid

Main-

Details; MAP-Financial Aid

FinancialAid Map- FinancialAid

FA GPAThe GPA calculated for financial aid eligibility1.82
gpa_20_a_hrs_neededexternal_student_financial_aidMAP-Financial AidFinancialAidHours needed to earn a 2.0 GPA with all A gradesThe number of earned hours at an A level required to achieve an overall 2.0 GPA9
gpa_20_b_hrs_neededexternal_student_financial_aidMAP-Financial AidFinancialAidHours needed to earn a 2.0 GPA with all B gradesThe number of earned hours at a B level required to achieve an overall 2.0 GPA9
credit_hours_earnedexternal_student_transcript_termMain-Details
MAP-Financial AidFinancialAid
Hrs EarnedThe total value of credit hours successfully completed or earned31
credit_hours_attemptedexternal_student_transcript_termMain-Details
MAP-Financial AidFinancialAid
Hrs AttemptedThe total value of credit hours attempted whether or not included in the hours for GPA or hours earned36
credit_completion_rateexternal_student_transcriptMain-Dashboard
Main-Details
MAP-Financial AidFinancialAid
Comp RateCompletion rate of hours attempted86%
needed_for_67ptc_completionexternal_student_financial_aidMAP-Financial AdFinancialAidHours needed to earn a 67% completion rateThe number of hours needed to reach a 67% completion rate required for financial aid (earned/attempted=completion rate)9
term_codeexternal_registration_status_by_termMain-Dashboard
Main-Details
MAP-Financial AidFinancialAid
RegSpecifies what term the course was taken. Equivalent to external_term.code valueList of current and future terms for which the student is registeredFA2013
tuition_paidexternal_registration_status_by_termMain-DashboardMain-Details
MAP-Financial AidFinancialAid
PaymentY or N, indicates payment status of tuition for the termFA2013=N
balance_owedexternal_personMain-DetailsFinancialAid
MAP-Financial AidFinancialAid
BalanceStudent's balance currently owed to the college. Format is XXXXX.XX.$0.00
sap_statusexternal_student_financial_aidMain-Dashboard
Main-Details
MAP-Financial AidFinancialAid
SAPY or N, indicates if the student has achieved Satisfactory Academic ProgressN
F1_statusexternal_personMain-Dashboard
Main-Details
MAP-Financial AidFinancialAid
F1Y or N, indicates if the student has an F1 Visa on fileY
FAFSA_dateexternal_student_financial_aidMain-DetailsFinancialAid
MAP-Financial AidFinancialAid
FAFSAThe date the FAFSA was accepted08/24/2013
current_year_financial_aid_awardexternal_student_financial_aidMain-Dashboard
Main-Details
MAP-Financial AidFinancialAid
FA AwardY or N, indicates if the student received financial aid for the current academic yearY
remaining_loan_amount external_student_financial_aidMain-DetailsFinancialAid
MAP-Financial AidFinancialAid
FA Amount RemainingThe remaining amount of loans available to the student$809.00
term_codeexternal_student_financial_aid_award_termMain-FinancialAid MAP-FinancialAidFA AwardedSpecifies what term financial aid was offered to the student. Equivalent to external_term.code value.FA12
acceptedexternal_student_financial_aid_award_termMain-FinancialAid MAP-FinancialAidFA AwardedIndicates the acceptance status of financial aid for the term. Acceptable values are Y or NY
institutional_loan_amountexternal_student_financial_aidMain-FinancialAid MAP-FinancialAidInstitutional Loan AmountThe remaining amount of financial aid available to the student$1,300.00
original_loan amount external_student_financial_aidMain-DetailsFinancialAid
MAP-Financial AidFinancialAid
Loan AmountThe original amount of loans available to the student$6,600.00
terms_leftexternal_student_financial_aidMain-FinancialAid
MAP-FinancialAid
Remaining FA TermsThe number of remaining eligible terms to receive financial aid3.00
sap_status_codeexternal_student_financial_aidMain-FinancialAid
MAP-FinancialAid
SAPThe SAP status code as determined by the institution. This value must match a configuration item for SAP status code in SSP administrationSAP-SAT
file_statusexternal_student_financial_aid_fileMain-FinancialAid
MAP-FinancialAid
FA FileThe appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDINGCOMPLETE