...
| Parameter | External Table | Location | Field Name | Description | Example | |
|---|---|---|---|---|---|---|
| name | external_program | MAP | Filter by Program | Name of the degree program | ||
| external_course_tag | tag | MAP | Filter by Tag | Identifies the code used to identify the tag in SSP admin | ||
| name | external_term | MAP | 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. | Credit hours earned by the student in the course | 3 | <Tags> |
| external_course_tag | tag | MAP | Tags | This data is populated from an internal SSP database | 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 | |||
| name | external_term | MAP | Winter 2013 | The name of the academic term | ||
| formatted_course | external_course | MAP MAP-Course Details | AUMT140 | The formatted course | ||
| min_credit_hours | external_course | MAP MAP-Course Details | 4 | The total value of credit hours successfully completed or earned. | ||
| <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 |
...
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| grade_point_average | external_student_transcript_term | Main-Details MAP-Financial Aid | GPA | The calculated cumulative GPA value | 1.82 |
| gpa_trend_indicator | external_student_transcript | Main-Dashboard | GPA | Describes the trend of the GPA from the previous term | Down |
| current_restrictions | external_student_transcript | Main-Dashboard Main-Details MAP-Financial Aid | 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 Aid | FA GPA | The GPA calculated for financial aid eligibility | 1.82 |
| gpa_20_a_hrs_needed | external_student_financial_aid | MAP-Financial Aid | Hours needed to earn a 2.0 GPA with all A grades | The number of earned hours at a an A level required to achieve an overall 2.0 GPA | 9 |
| gpa_20_b_hrs_needed | external_student_financial_aid | MAP-Financial Aid | 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 Aid | Hrs Earned | The total value of credit hours successfully completed or earned | 31 |
| credit_hours_attempted | external_student_transcript_term | Main-Details MAP-Financial Aid | 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 Aid | Comp Rate | Completion rate of hours attempted | 86% |
| needed_for_67ptc_completion | external_student_financial_aid | MAP-Financial Ad | 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 Aid | Reg | Specifies what term the course was taken. Equivalent to external_term.code value | FA2013 |
| tuition_paid | external_registration_status_by_term | Main-Dashboard Main-Details MAP-Financial Aid | Payment | Y or N, indicates payment status of tuition for the term | FA2013=N |
| balance_owed | external_person | Main-Details MAP-Financial Aid | 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 Aid | SAP | Y or N, indicates if the student has achieved Satisfactory Academic Progress | N |
| F1_status | external_person | Main-Dashboard Main-Details MAP-Financial Aid | F1 | Y or N, indicates if the student has an F1 Visa on file | Y |
| FAFSA_date | external_student_financial_aid | Main-Details MAP-Financial Aid | 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 Aid | 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-Details MAP-Financial Aid | FA Amount | The remaining amount of loans available to the student | $809.00 |
| original_loan amount | external_student_financial_aid | Main-Details MAP-Financial Aid | Loan Amount | The original amount of loans available to the student | $6,600.00 |
...