...
| Parameter | External Table | Location | Field Name | Description | Example | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| gender | external_person | Main-Details | Gender | Student's gender | M | |||||||||
| marital_status | external_person | Main-Details | Marital Status | Student's marital status. Note that unlike student_type_code, the value in marital_status is expected to be a screen-displayable name. | Separated | |||||||||
| ethnicity | external_person | Main-Details | Ethnicity | Student's ethnicity. Note that unlike student_type_code, the value in ethnicity is expected to be a screen-displayable name. | Other | |||||||||
| race_code | external_person | Main-Details | Race | Student's race. Like student_type_code, the value displayed on-screen is the name of the reference item, which is not necessarily the same as its code (e.g. "White" vs "W"). The external data should contain the code, not the actual value. | ||||||||||
| residency_county | external_persno | Main-Details | Residency | The county of residence | Hamilton | |||||||||
| F1_status | external_person | Main-Dashboard Main-Details MAP-FinancialAid | F1 | Y or N, indicates if the student has an F1 Visa on file | Y | |||||||||
| gradelocal_point_averagegpa | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | GPAThe calculated cumulative GPA value | Custom gpa traditionally used for resident credit only | 1.82 | |||||||||
| program_gpa | external_student_transcript | Main-Details | Program GPA | Custom gpa traditionally used for program/major credit only | 3.00 | |||||||||
| code | career_decision_status | Main-Details | Career Status | A code to represent and match the Career Decision Status configured options | CP | |||||||||
| academic_standing | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | Standing | Current academic standing of the student | Probation | |||||||||
| current_restrictions | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | Restrictions | List of any restrictions or holds on the student record | ie. Dismissed, Hold, Fine | |||||||||
| 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 | |||||||||
| intended_program_at_admit | external_student_academic_program | Main-Details | Intended Program | From the Admissions application, the intended program of student formatted program name used for display in SSP. | Associates of Science in Automotive Technology | |||||||||
| campus_code | external_person | Main-Details | Home Campus | The home campus for the student. The code value must match a configured reference item in Early Alert campus. | DAY | |||||||||
| <Anticipated Start Term> | ||||||||||||||
credit_earned credit_type | external_student_transcript_course | Main-Details | Transfer Hrs | The number of transfer hours the student has completed. | ie. Institutional, Transfer, Proficiency, Placement | |||||||||
| <Plan Program> | ||||||||||||||
| <Plan Catalog Year> | ||||||||||||||
| status | external_person_planning_status | Main-Dashboard Main-Details MAP-MainPage | Plan Status | The status of the active plan. Valid values are On and Off. | Off Plan | |||||||||
<Plan Updated>Name> | ||||||||||||||
| <Plan Ends>Owner> | ||||||||||||||
| <Plan Name><Plan Updated> | ||||||||||||||
| <Plan Owner>Ends> | ||||||||||||||
| 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 Main-Coach | Student's primary email address | demo@testdrivessp.com | ||||||||||
| student_type_code | external_person | Main-Dashboard Main-Details EAL Details | Student Type | The value displayed on-screen is the name of the reference item, which is not necessarily the same as itscode (e.g. "First Time in College" vs "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 | Internal to SSP (not populated from external database table); this field is set implicitly when first adding a student to SSP or explicitly by several buttons in the coach's caseload view. | Active | |||||||||
| financial_aid_gpa | external_student_financial_aid | Main-Details MAP-FinancialAid | 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 | credit_completion_rate | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | Restrictions | List of any restrictions or holds on the student record | ie. Dismissed, Hold, Fine | credit_hours_earned | external_student_transcript | Main-Details MAP-FinancialAid | Hrs Earned | The total value of credit hours successfully completed or earned | 31Comp Rate | Completion rate of hours attempted | 86% |
| credit_hours_attempted | external_student_transcript | Main-Details MAP-FinancialAid | Hrs Attempted | The total value of credit hours attempted whether or not included in the hours for GPA or hours earned. | 36 | |||||||||
| credit_completionhours_rateearned | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | Comp Rate | Completion rate of hours attempted | 86% | credit_typeHrs Earned | The total value of credit hours successfully completed or earned | 31 | ||||||
| grade_point_average | external_student_transcript_course | Main-DetailsDashboard Main-TranscriptDetails MAP-TranscriptFinancialAid | Transfer Hrs | The number of transfer hours the student has completed. | ie. Institutional, Transfer, Proficiency, PlacementGPA | The calculated cumulative GPA value | 1.82 | |||||||
| term_code | external_registration_status_by_term | Main-Dashboard Main-DetailsMAP-FinancialAid | Reg | List of current and future terms for which the student is registered | FA2013 | |||||||||
| tuitioncredit_hours_paidattempted | external_registrationstudent_status_bytranscript_termMain-Dashboard | Main-Details MAP-FinancialAidTranscript | Payment | Y or N, indicates payment status of tuition for the term | FA2013=N | |||||||||
| balance_owed | external_person | Main-Details MAP-FinancialAid | Balance | Student's balance currently owed to the college. Format is XXXXX.XX. | $0.00 | |||||||||
| FAFSA_date | Hrs Attempted | The total value of credit hours attempted | 36 | |||||||||||
| credit_hours_earned | external_student_financialtranscript_aidterm | Main-Details MAP-FinancialAidTranscript | FAFSAHrs Earned | The date the FAFSA was accepted | 08/24/2013 | current_year_financial_aid_awardtotal value of credit hours successfully completed | 31 | |||||||
| grade_point_average | external_student_financialtranscript_aidterm | Main-Dashboard Main-Details MAP-FinancialAid | 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-FinancialAid | FA Amount | The remaining amount of loans available to the student | $809.00 | |||||||||
| original_loan amount | external_student_financial_aid | Main-Details MAP-FinancialAid | Loan Amount | The original amount of loans available to the student | $6,600.00 | |||||||||
| sap_status | external_student_financial_aid | Main-DashboardGPA | The calculated GPA value (not cumulative) | 1.82 | ||||||||||
| tuition_paid | external_registration_status_by_term | Main-Details MAP-FinancialAid | SAPPayment | Y or N, indicates if the student has achieved Satisfactory Academic Progress | N | |||||||||
| 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-Main Page | MAP | The status of the active plan. Valid values are On and Off. | Off Plan | |||||||||
| coach_school_id | external_person | Main-Details Main-Coach EAL Details | Advisor | Coach (first & last name) assigned to student. The value displayed on-screen is the coach actually assigned to the student when the screen is rendered, which may or may not be the same as the coach referenced by coach_school_id. Handling of that field is controlled by options set on the Admin -> Administrative Tools -> System Configuration -> Configuration Options screen. See coachSetFromExternalData and coachUnsetFromExternalData | 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 Technologypayment status of tuition for the term | FA2013=N |