...
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| photo_url | external_person | Main-Dashboard Main-Details | <photo> | Student's photograph | |
| first_name | external_person | Main-Dashboard | Name | Student's first name | Robert |
| middle_name | external_person | Main-Dashboard Main-Details | Name | Student's middle name | Bradley |
| last_name | external_person | Main-Dashboard | Name | Student's last name | Jones |
| school_id | external_person | Main-Dashboard Main-Details | Student ID | Student's id or other identifier used by the institution to identify students, faculty, or other staff. | rjones330 |
| birth_date | external_person | Main-Dashboard Main-Details Main-Contact | DOB | Student's birthdate | 10/24/86 |
| home_phone | external_person | Main-Dashboard Main-Details Main-Contact | Phone | Student's home phone number | (555) 555-1212 |
| primary_email_address | external_person | Main-Dashboard Main-Details Main-Contact | Student's primary email address | demo@testdrivessp.com | |
| student_type_code | external_person | Main-Dashboard Main-Details | Student Type | The value displayed is the name of the reference item, which is a code (such as FTIC). The external data should contain the code, not the actual value. | First Time in College |
| <SSP Status> | person_program_status | Main-Dashboard Main-Details | SSP Status | This value is derived internally by SSP. This field is set by manually syncing the student. | Active |
| gender | external_person | Main-Details | Gender | Student's gender | M |
| marital_status | external_person | Main-Details | Marital Status | Student's marital status | Separated |
| ethnicity | external_person | Main-Details | Ethnicity | Student's ethnicity | Other |
| race_code | external_person | Main-Details | Race | Student's race | |
| grade_point_average | external_student_transcript | Main-Dashboard Main-Details | GPA | The calculated cumulative GPA value | 1.82 |
| financial_aid_gpa | external_student_financial_aid | Main-Details MAP-Financial Aid | FA GPA | The GPA calculated for financial aid eligibility | 1.82 |
| academic_standing | external_student_transcript | Main-Dashboard Main-Details | Standing | Current academic standing of the student | Probation |
| 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 |
| credit_hours_earned | external_student_transcript | Main-Details | Hrs Earned | The total value of credit hours successfully completed or earned | 31 |
| credit_hours_attempted | external_student_transcript | Main-Details | 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% |
| credit_type | external_student_transcript_course | Main-Details | Transfer Hrs | The number of transfer hours the student has completed. | ie. Institutional, Transfer, Proficiency, Placement |
| term_code | external_registration_status_by_term | Main-Dashboard Main-Details MAP-Financial Aid | Reg | List of current and future terms for which the student is registered | 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 |
| 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 |
| 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 |
| program_name | external_student_academic_program | Main-Dashboard Main-Details | Academic Program | Formatted program name used for display in SSP | Associates of Science in Automotive Technology |
| status | external_person_planning_status | Main-Dashboard Main-Details MAP | MAP | The status of the active plan. Valid values are On and Off. | Off Plan |
| coach_school_id | external_person | Main-Details Main-Coach | Advisor | Coach (first & last name) assigned to student | Demo Coach23 |
| <Last Updated> | map_plan | Main-Dashboard | Last Updated | This date is the last time the MAP was saved or changed. This field is populated from an internal SSP database field. | 05/20/2012 |
| <MAP Projected Grad> | map_plan | Main-Dashboard Main-Details | MAP Projected Grad | This value is derived from the last term on the current MAP that contains courses. This is assumed to be the graduating term. This field is populated from an internal SSP database field. | WN2015 |
| intended_program_at_admit | external_student_academic_program | Main-Details | Intended Program at Admit | From the Admissions application, the intended program of student formatted program name used for display in SSP. | Associates of Science in Automotive Technology |
...