Skip to end of metadata
Go to start of metadata

Tool: MAP

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 Diagram.jpg

MAP Diagram.pdf

MAP Diagram.vsd

 

MAP - Main Page

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

MAP-MainPage
MAP-CourseDetails

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;
Spring 2014
Name of academic term.Filter by Term
title

 

external_course

MAP-MainPage
MAP- Course Details

TitleThe full course titleGeneral Aerospace
<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-MainPage
Plan StatusThe status of the active plan. Valid values are On and Off.Off Plan
<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 = Y0
formatted_courseexternal_courseMAP-MainPage
MAP-CourseDetails
CourseThe formatted courseAES118
min_credit_hoursexternal_courseMAP-MainPage
MAP-CourseDetails
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. This value is the sum of the course min_credit_hours for the selected term.8


MAP - Course Details

ParameterExternal TableLocationField NameDescriptionExample
formatted_courseexternal_courseMAP-MainPage
MAP-CourseDetails
CourseThe formatted courseAES118
 titleexternal_courseMAP-MainPage
MAP-CourseDetails
CourseThe full course titleGeneral Aerospace
descriptionexternal_courseMAP-CourseDetailsCourse DescriptionThe course description as it exists in the course catalogGeneral Aerospace
max_credit_hoursexternal_courseMAP-CourseDetailsMax Credit HoursThe maximum number of credit hours a student can earn in a course8
min_credit_hoursexternal_courseMAP-MainPage
MAP-CourseDetails
Min Credit HoursThe minimum number of credit hours a student can earn in a course3
department_codeexternal_courseMAP-CourseDetailsDepartmentA unique code of the department. The value is the matching value for external_course and external_department.DEP_AC
division_codeexternal_courseMAP-CourseDetailsDivisionA unique code of the division. The value is the matching value for external_course and external_division.DIV_B
tagexternal_course_tagMAP-MainPage
MAP-CourseDetails
TagsIdentifies 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_linkexternal_courseMAP-Course DetailsMaster 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-CourseDetailsAcademic 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 Type

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)

ParameterExternal TableLocationField NameDescriptionExample
grade_point_averageexternal_student_transcriptMain-Dashboard
Main-Details
MAP-FinancialAid
GPAThe calculated cumulative GPA value1.82
academic_standingexternal_student_transcript

Main-Dashboard
Main-Details MAP-FinancialAid

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

Main-FinancialAid Map- FinancialAid

FA GPAThe GPA calculated for financial aid eligibility1.82
gpa_20_a_hrs_neededexternal_student_financial_aidMAP-FinancialAidHours 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-FinancialAidHours 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_transcriptMain-Details
MAP-FinancialAid
Hrs EarnedThe total value of credit hours successfully completed or earned31
credit_hours_attemptedexternal_student_transcriptMain-Details
MAP-FinancialAid
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-FinancialAid
Comp RateCompletion rate of hours attempted86%
needed_for_67ptc_completionexternal_student_financial_aidMAP-FinancialAidHours 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-FinancialAid
RegList of current and future terms for which the student is registeredFA2013
tuition_paidexternal_registration_status_by_termMain-Details
MAP-FinancialAid
PaymentY or N, indicates payment status of tuition for the termFA2013=N
balance_owedexternal_personMain-FinancialAid
MAP-FinancialAid
BalanceStudent's balance currently owed to the college. Format is XXXXX.XX.$0.00
sap_statusexternal_student_financial_aidMain-Dashboard
Main-Details
MAP-FinancialAid
SAPY or N, indicates if the student has achieved Satisfactory Academic ProgressN
F1_statusexternal_personMain-Dashboard
Main-Details
MAP-FinancialAid
F1Y or N, indicates if the student has an F1 Visa on fileY
FAFSA_dateexternal_student_financial_aidMain-FinancialAid
MAP-FinancialAid
FAFSAThe date the FAFSA was accepted08/24/2013
current_year_financial_aid_awardexternal_student_financial_aidMAP-FinancialAidFA AwardY or N, indicates if the student received financial aid for the current academic yearY
remaining_loan_amount external_student_financial_aidMain-FinancialAid
MAP-FinancialAid
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-FinancialAid
MAP-FinancialAid
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


  • No labels