Tool: Main
Tab: Details
Description: (needs imrovement, clarification, detail) Notes from any system can be saved in the table for display in SSP. Notes can originate from any system and will be displayed to the user in chronological order.
Any other information that is necessary - put it here.
The Main Tool displays academic information about the student normally stored in the student information system (SIS).
The Details tab from the Main Tool displays information maintained in the SIS that is vital to coaching a student.
The information includes full demographics, academic information and attributes added in Caseload Assignment.
Attachments:
| Parameter | External Table | Location | Field Name | Description | Example | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| photo_urlgender | external_person | Main-Dashboard, Details | <photo>Gender | Student's photographgender | M | |||||||||
| firstmarital_namestatus | external_person | Main-Dashboard, Details | NameMarital Status | 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 | |||||||||
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-Dashboard, Details | Student IDEthnicity | 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 | |||||||||
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-Dashboard, Details, Contact | EmailRace | Student's primary email address | demo@testdrivessp.com | race. Like 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, 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 | Gender | Student's gender | M | maritalResidency | The county of residence | Hamilton | ||||||
| F1_status | external_person | Main-Details | Marital Status | Student's marital status | Separated | ethnicity | external_personDashboard Main-Details MAP-FinancialAid | Ethnicity | Student's ethnicity | Other | race_code | external_personF1 | Y or N, indicates if the student has an F1 Visa on file | Y |
| local_gpa | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | Race | Student's race | grade_point_average | GPA | Custom gpa traditionally used for resident credit only | 1.82 | ||||||
| program_gpa | external_student_transcript_term | Main-Details | Program GPA | The calculated cumulative GPA value | 1.82 | financial_aid_gpa | external_student_financial_aidCustom gpa traditionally used for program/major credit only | 3.00 | ||||||
| code | career_decision_status | Main-Details | FA GPA | The GPA calculated for financial aid eligibility | 1.82Career Status | A code to represent and match the Career Decision Status configured options | CP | |||||||
| academic_standing | external_student_transcript | Main-Dashboard, Details Main-Details MAP-FinancialAid | Standing | Current academic standing of the student | Probation | |||||||||
| current_restrictions | external_student_transcript | Main-Dashboard, Details Main-Details MAP-FinancialAid | Restrictions | List of any restictions restrictions or holds on the student record | ie. Dismissed, Hold, Fine | |||||||||
| creditprogram_hours_earnedname | external_student_transcript_termacademic_program | Main-Dashboard Main-Details | Hrs Earned | The total value of credit hours successfully completed or earned | 31 | credit_hours_attemptedAcademic Program | Formatted program name used for display in SSP | Associates of Science in Automotive Technology | ||||||
| intended_program_at_admit | external_student_transcriptacademic_termprogram | 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, Details | Comp Rate | Completion rate of hours attempted | 86%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 | Indicates the type of credit earned by the student The number of transfer hours the student has completed. | ie. Institutional, Transfer, Proficiency, Placement | term_code | external_registration_status_by_term | |||||||
| <Plan Program> | ||||||||||||||
| <Plan Catalog Year> | ||||||||||||||
| status | external_person_planning_status | Main-Dashboard, Details | 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 | Payment | Y or N, indicates payment status of tuition for the term | FA2013=N | |||||||||
| balance_owed | external_person | Main-Details | Balance | Student's balance currently owed to the college. Format is XXXXX.XX. | $0.00 | |||||||||
| FAFSA_date | external_student_financial_aid | Main-Details | FAFSA | The date the FAFSA was accepted | 08/24/2013 | |||||||||
| current_year_financial_aid_award | external_student_financial_aid | Main-Dashboard, Details | 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 | FA Amount | The remaining amount of loans available to the student | $809.00 | |||||||||
| original_loan amount | external_student_financial_aid | Main-Details | Loan Amount | The original amount of loans available to the student | $6,600.00 | |||||||||
| sap_status | external_student_financial_aid | Main-Dashboard, Details | SAP | Y or N, indicates if the student has achieved Satisfactory Academic Progress | N | |||||||||
| F1_status | external_person | Main-Dashboard, Details | 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-Dashboard, Details | 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 Main-Details MAP-MainPage | Plan Status | The status of the active plan. Valid values are On and Off. | Off Plan | ||||||
<Plan Name> | ||||||||||||||
| <Plan Owner> | ||||||||||||||
| <Plan Updated> | ||||||||||||||
| <Plan Ends> | ||||||||||||||
| credit_completion_rate | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | Comp 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_hours_earned | external_student_transcript | Main-Details MAP-FinancialAid | Hrs Earned | The total value of credit hours successfully completed or earned | 31 | |||||||||
| grade_point_average | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | GPA | The calculated cumulative GPA value | 1.82 | |||||||||
| term_code | external_registration_status_by_term | Main-Dashboard Main-Details | Reg | List of current and future terms for which the student is registered | FA2013 | |||||||||
| credit_hours_attempted | external_student_transcript_term | Main-Details MAP-Transcript | Hrs Attempted | The total value of credit hours attempted | 36 | |||||||||
| credit_hours_earned | external_student_transcript_term | Main-Details MAP-Transcript | Hrs Earned | The total value of credit hours successfully completed | 31 | |||||||||
| grade_point_average | external_student_transcript_term | Main-Dashboard Main-Details MAP-FinancialAid | GPA | The calculated GPA value (not cumulative) | 1.82 | |||||||||
| tuition_paid | external_registration_status_by_term | Main-Details MAP-FinancialAid | Payment | Y or N, indicates payment status of tuition for the term | FA2013=N |