Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Tool: MAP

Description: (needs improvement, clarification, detail)

Any other information that is necessary - put it here.



ParameterExternal TableLocationField NameDescriptionExample
 external_programMAPFilter by Program  
<Filter by Tag> MAPFilter by Tag  
 external_termMAPFilter by Term  
formatted_courseexternal_courseMAPCourseThe formatted courseAES118
titleexternal_course TitleThe full course titleGeneral Aerospace
min_credit_hoursexternal_courseMAPCr.Credit hours earned by the student in the course3
<Tags> MAPTags HON
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> MAPPlan TitleThe name assigned to the plan by the student or coachAssociates in Automotive Technology - Part Time
statusexternal_person_planning_statusMain-Dashboard
Main-Details
MAP		Student is Currently Off Plan
status_reasonexternal_person_planning_statusMAP?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
   Current Total Plan Cr Hrs 61
   Dev Cr Hrs  
   Winter 2013  
   AUMT140  
   4  
   Term Cr. Hrs 8


Course Details

ParameterExternal TableLocationField NameDescriptionExample
formatted_courseexternal_course Course AST355
 titleexternal_course Course Individualized Astronomy
descriptionexternal_course Course Description Individualized Astronomy
max_credit_hoursexternal_course Max Credit Hours 5
min_credit_hoursexternal_course Min Credit Hours 2
department_codeexternal_department Department DEP_AC
division_codeexternal_division Division DIV_B
<Tags>  Tags HON
 external_course_requisite Requisites AES118: Pre
      
academic_linkexternal_course Academic Link  


Transcript (these values are also found in the Main-Transcript tool)

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_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 studentInstitutional


Financial Aid

ParameterExternal TableLocationField NameDescriptionExample
grade_point_averageexternal_student_transcript_termMain-Details
MAP-Financial Aid		GPAThe calculated cumulative GPA value1.82
   GPA Down
current_restrictionsexternal_student_transcriptMain-Dashboard
Main-Details
MAP-Financial Aid		RestrictionsList of any restrictions or holds on the student recordie. Dismissed, Hold, Fine
financial_aid_gpaexternal_student_financial_aidMain-Details; MAP-Financial AidFA GPAThe GPA calculated for financial aid eligibility 
   Hours needed to earn a 2.0 GPA with all A grades 9
   Hours needed to earn a 2.0 GPA with all B grades 9
credit_hours_earnedexternal_student_transcript_termMain-Details
MAP-Financial Aid		Hrs EarnedThe total value of credit hours successfully completed or earned31
credit_hours_attemptedexternal_student_transcript_termMain-Details
MAP-Financial Aid		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 Aid		Comp RateCompletion rate of hours attempted86%
   Hours needed to earn a 67% completion rate 9
term_codeexternal_registration_status_by_termMain-Dashboard
Main-Details
MAP-Financial Aid		RegSpecifies what term the course was taken. Equivalent to external_term.code valueFA2013
tuition_paidexternal_registration_status_by_termMain-Dashboard
Main-Details
MAP-Financial Aid		PaymentY or N, indicates payment status of tuition for the termFA2013=N
balance_owedexternal_personMain-Details
MAP-Financial Aid		BalanceStudent's balance currently owed to the college. Format is XXXXX.XX.$0.00
sap_statusexternal_student_financial_aidMain-Dashboard
Main-Details
MAP-Financial Aid		SAPY or N, indicates if the student has achieved Satisfactory Academic ProgressN
F1_statusexternal_personMain-Dashboard
Main-Details
MAP-Financial Aid		F1Y or N, indicates if the student has an F1 Visa on fileY
FAFSA_dateexternal_student_financial_aidMain-Details
MAP-Financial Aid		FAFSAThe date the FAFSA was accepted08/24/2013
current_year_financial_aid_awardexternal_student_financial_aidMain-Dashboard
Main-Details
MAP-Financial Aid		FA AwardY or N, indicates if the student received financial aid for the current academic yearY
remaining_loan_amount external_student_financial_aidMain-Details
MAP-Financial Aid		FA AmountThe remaining amount of loans available to the student$809.00
original_loan amount external_student_financial_aidMain-Details
MAP-Financial Aid		Loan AmountThe original amount of loans available to the student$6,600.00






  • No labels