Tool: Main
Tab: Details
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 |
|---|---|---|---|---|---|
| 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 |
| grade_point_average | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | GPA | The calculated cumulative GPA value | 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 | 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 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 MAP-FinancialAid | Reg | List of current and future terms for which the student is registered | FA2013 |
| credit_hours_attempted | external_student_transcript_term | Main-Details MAP-FinancialAid | Hrs Attempted | The total value of credit hours attempted | 36 |
| credit_hours_earned | external_student_transcript_term | Main-Details MAP-FinancialAid | 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-Dashboard Main-Details MAP-FinancialAid | Payment | Y or N, indicates payment status of tuition for the term | FA2013=N |