Early Alert Portlet
Explanation of Tool, Use, etc.
Course Roster
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| first_name | external_faculty_course_roster | Early Alert - Course Roster Early Alert - Details | First Name | Student's first name | Michael |
| middle_name | external_faculty_course_roster | Early Alert - Course Roster Early Alert - Details | Middle Name | Student's middle name | Mumford |
| last_name | external_faculty_course_roster | Early Alert - Course Roster Early Alert - Details | Last Name | Student's last name | Anderson |
| status_code | external_faculty_course_roster | Early Alert - Course Roster Early Alert - Details | Status | The student's enrollment status in the course | Enrolled |
Early Alert Details
Attachments:
Course Roster
| Parameter | External Table | Location | Field Name | Description | Example | ||
|---|---|---|---|---|---|---|---|
| formatted_course | external_faculty_course | Early Alert EAL-Course Roster EAL-Details EAL-Response | Course | The formatted course | CHM451 | ||
| title | external_faculty_course | Early Alert - DetailsEAL-Course Roster EAL-Response | Course | The title of the course | Higher Chemistry | ||
| term_code | external_faculty_courseEarly Alert _roster | EAL-Course Roster EAL-Details | Term | Specifies what term the course was taught by the faculty member | FA12 | ||
| school_id | external_faculty_course_roster | EAL-Course Roster | Student ID | Student's school ID | manderson1 | ||
| first_name | external_faculty_course_roster | Early Alert EAL- DetailsCourse Roster | StudentFirst Name | Student's first name | PatriciaMichael | ||
| middle_name | external_faculty_course_roster | Early Alert EAL- DetailsCourse Roster | StudentMiddle Name | Student's middle name | N/AMumford | ||
| last_name | external_faculty_course_roster | Early Alert EAL- DetailsCourse Roster | StudentLast Name | Student's last name | DavisAnderson | ||
| status_code | external_faculty_course_roster | Early Alert EAL- DetailsCourse Roster | Enrollment Status | The student's enrollment status in the course | Enrolled | . status_code is often not meaningful to end users. So that value can be mapped to a more human friendly value using the Admin -> Administrative Tools -> System Configuration -> Enrollment Statuses screen. | E |
| faculty_school_id | external_faculty_course_roster | EAL-Course Roster | faculty1 | The school_id used to identify a faculty member | faculty1 |
Early Alert
...
Details
...
| Parameter | External Table | Location | Field N ame | Description | Example | |||
|---|---|---|---|---|---|---|---|---|
| formatted_course | external_faculty_course_roster | Early Alert EAL-Details | Student Email | Student's primary email address. Typically the institution-assigned email address. | 4@unicon.net | student_typeCourse Name | The formatted course | CHM451 |
| campus_code | external_person | Early Alert EAL-Details | Student TypeCampus | The student_type is a primary characteristic of the student in SSP | EAL | |||
| coach_school_id | external_person | Early Alert - Details | Assigned Counselor/Coach | The coach assigned to the student | Garcia, Chris | |||
| <Office> | Early Alert - Details | Office | This data is populated from an internal SSP database | N/A | ||||
| <Phone> | Early Alert - Details | Phone | This data is populated from an internal SSP database | N/A | ||||
| <Department> | Early Alert - Details | Department | This data is populated from an internal SSP database | N/A | ||||
| <Email cc> | Early Alert - Details | Email cc | This data is populated from an internal SSP database | N/A | ||||
| <Campus> | Early Alert - Details | Campushome campus for the student | DAY | |||||
| <Created By> | EAL-Details | Created By | ||||||
| <Status> | EAL-Details | Status | ||||||
| <Created Date> | EAL-Details | Created Date | ||||||
| <Closed By> | EAL-Details | Closed By | ||||||
| <Closed Date> | EAL-Details | Closed Date | ||||||
| <Email CC> | EAL-Details | Email CC | This field is specified by the end user | N/A | ||||
| <Reasons> | EAL-Details | Referral Reason | This data is populated from an internal SSP database | N/A | <Referral Reason> |
Early Alert Response
| Parameter | External Table | Location | Field Name | Description | Example | |||
|---|---|---|---|---|---|---|---|---|
| formatted_course | external_faculty_course | EAL-Course Roster EAL-Details | Referral Reason | This data is populated from an internal SSP database | N/A EAL- Response | Course | The formatted course | CHM451 |
| title | external_faculty_course | EAL-Response | Course | The title of the course | Higher Chemistry | |||
| <Outreach> | EAL- Response | Outreach | ||||||
| <Outcome> | EAL- Response | Outcome |