...
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| photo_url | external_person | Main-Dashboard, Details | <photo> | Student's photograph | |
| first_name | external_person | Main-Dashboard, Details | Name | Student's first name | Robert |
| middle_name | external_person | Main-Dashboard, Details | Name | Student's middle name | Bradley |
| last_name | external_person | Main-Dashboard, Details | Name | Student's last name | Jones |
| school_id | external_person | Main-Dashboard, 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, Details, Contact | DOB | Student's birthdate | 10/24/86 |
| home_phone | external_person | Main-Dashboard, Details, Contact | Phone | Student's home phone number | (555) 555-1212 |
| primary_email_address | external_person | Main-Dashboard, Details, Contact | Student's primary email address | demo@testdrivessp.com | |
| student_type_code | external_person | Main-Dashboard, Details | Student Type | The Student Type is a primary characteristic of the student in SSP. This value must match an existing row in student_type code. | First Time in College |
| <SSP Status> | person_program_status | Main-Dashboard, 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_term | Main-Details; MAP-Financial Aid | 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, Details | Standing | Current academic standing of the student | Probation |
| current_restrictions | external_student_transcript | Main-Dashboard, Details; MAP-Financial Aid | Restrictions | List of any restictions restrictions or holds on the student record | ie. Dismissed, Hold, Fine |
| 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, Details; MAP-Financial Aid | Comp Rate | Completion rate of hours attempted | 86% |
| credit_type | external_student_transcript_course | Main-Details, Transcript | Transfer Hrs | Indicates the type of credit earned by the student | ie. Institutional, Transfer, Proficiency, Placement |
| term_code | external_registration_status_by_term | Main-Dashboard, 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, 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, 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, Details; MAP-Financial Aid | SAP | Y or N, indicates if the student has achieved Satisfactory Academic Progress | N |
| F1_status | external_person | Main-Dashboard, 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, Details | Academic Program | Formatted program name used for display in SSP | Associates of Science in Automotive Technology |
| status | external_person_planning_status | Main-Dashboard, Details | MAP | The status of the active plan. Valid values are On and Off. | Off Plan |
| coach_school_id | external_person | Main-Details, Coach | Advisor | Coach assigned to student | Demo Coach23 |
| <Last Updated> | map_plan | Main-Dashboard, Details | 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, 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 |
...