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_personMain-Dashboard | Main-Details | <photo>Gender | Student's photographgender | M | ||||||||
| firstmarital_namestatus | external_personMain-Dashboard | Main-Details | NameMarital Status | Student's first name | Robert | ||||||||
| middle_name | external_person | Main-Dashboard Main-Details | Name | Student's middle name | Bradley | ||||||||
| last_name | external_person | Main-Dashboardmarital 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 | NameEthnicity | 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-Dashboardethnicity. Note that unlike student_type_code, the value in ethnicity is expected to be a screen-displayable name. | Other | ||||||||||
| race_code | external_person | Main-DetailsMain-Contact | DOBRace | 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 | |||||||||
race. Like student_type_code | external_person | Main-Dashboard Main-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 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 | ||||||||
| , 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-Details | Marital Status | Student's marital status | Separated | ethnicity | external_personDashboard Main-Details | Ethnicity | Student's ethnicity | Other | |||
| race_code | external_person | Main-Details | Race | Student's race | |||||||||
| MAP-FinancialAid | F1 | Y or N, indicates if the student has an F1 Visa on file | Y | ||||||||||
| local_gpa | external_student_transcript_term | Main-Dashboard Main-Details MAP-Financial AidFinancialAid | GPAThe calculated cumulative GPA value | Custom gpa traditionally used for resident credit only | 1.82 | ||||||||
| program_gpa | external_student_ | financial_aidtranscript | Main-DetailsMAP-Financial Aid | FA Program GPA | The GPA calculated for financial aid eligibility | 1.82Custom 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-Financial AidFinancialAid | Restrictions | List of any restrictions or holds on the student record | ie. Dismissed, Hold, Fine | ||||||||
| creditprogram_hours_earnedname | external_student_transcript_termacademic_program | Main-Dashboard Main-DetailsMAP-Financial Aid | 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-DetailsMAP-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%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 Main-Details MAP-Financial AidMainPage | 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 | ||||||||
| 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_aidPlan 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-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_aidFinancialAid | Comp Rate | Completion rate of hours attempted | 86% | |||
| credit_hours_attempted | external_student_transcript | Main-Details MAP-Financial AidFA AmountFinancialAid | Hrs Attempted | The remaining amount of loans available to the student | $809.00 | original_loan amount | external_student_financial_aidtotal 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-Financial AidLoan AmountFinancialAid | Hrs Earned | The original amount of loans available to the student | $6,600.00 | sap_status | external_student_financial_aidtotal value of credit hours successfully completed or earned | 31 | |||||
| grade_point_average | external_student_transcript | Main-Dashboard Main-Details MAP-Financial AidFinancialAid | SAP | Y or N, indicates if the student has achieved Satisfactory Academic Progress | N | F1_status | external_personGPA | The calculated cumulative GPA value | 1.82 | ||||
| term_code | external_registration_status_by_term | Main-Dashboard Main-DetailsMAP-Financial Aid | F1 | Y or N, indicates if the student has an F1 Visa on file | Y | program_nameReg | List of current and future terms for which the student is registered | FA2013 | |||||
| credit_hours_attempted | external_student_academictranscript_programterm | Main-DashboardDetails MainMAP-DetailsTranscript | Academic Program | Formatted program name used for display in SSP | Associates of Science in Automotive Technology | status | external_person_planning_status | Main-DashboardHrs Attempted | The total value of credit hours attempted | 36 | |||
| credit_hours_earned | external_student_transcript_term | Main-Details MAP-TranscriptMAP | Hrs Earned | 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 assigned to student | Demo Coach23 | ||||||||
| <Last Updated> | map_plantotal value of credit hours successfully completed | 31 | |||||||||||
| grade_point_average | external_student_transcript_term | Main-Dashboard Main-DetailsLast 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-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 |