Early Alert Portlet
Explanation Use, etc.
Attachments:
...
| Parameter | External Table | Location | Field Name | Description | Example | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| first_name | external_facultyformatted_course | _rosterEAL-Course RosterEAL-Details | First Name | Student's first name | Michael | middle_name | external_faculty_course_roster | EAL-Course Roster EAL-Details | Middle Name | Student's middle name | Mumford |
| last_name | external_faculty_course_roster | EAL-Course Roster EAL-Details | Last Name | Student's last name | Anderson | ||||||
| status_code | external_faculty_course_roster | EAL-Course Roster EAL-Details | Status | The student's enrollment status in the course | Enrolled |
Early Alert Details
| Parameter | External Table | Location | Field Name | Description | Example | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| formatted_course | EAL-Response | Course | The formatted course | CHM451 | |||||||
| title | external_faculty_course | EAL-Details | Course | The formatted course | CHM451 | title | external_faculty_course | EAL-DetailsCourse Roster EAL-Response | Course | The title of the course | Higher Chemistry |
| term_code | external_faculty_course_roster | EAL-Course Roster EAL-Details | Term | Specifies what term the course was taught by the faculty member | FA12 | ||||||
| firstschool_nameid | external_faculty_course_roster | EAL-DetailsCourse Roster | Student ID | Student's school ID | manderson1 | ||||||
| first_name | external_faculty_course_roster | EAL-Course Roster | StudentFirst Name | Student's first name | PatriciaMichael | ||||||
| middle_name | external_faculty_course_rosterEAL-Details | EAL-Course Roster | StudentMiddle Name | Student's middle name | N/AMumford | ||||||
| last_name | external_faculty_course_rosterEAL-Details | EAL-Course Roster | StudentLast Name | Student's last name | DavisAnderson | ||||||
| status_code | external_faculty_course_roster | EAL-Details EAL-Course 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 | EAL-Details | Student Email | Student's primary email address. Typically the institution-assigned email address. | 4@unicon.net | student_type_Course Name | The formatted course | CHM451 | |
| campus_code | external_person | EAL-DetailsMain-Dashboard Main-Details | Student Type | The student_type is a primary characteristic of the student in SSP | EAL | coach_school_id | external_personCampus | The home campus for the student | DAY |
| <Created By> | EAL-DetailsMain | Created By | |||||||
| <Status> | EAL-DetailsMain-Coach | Assigned Counselor/Coach | The coach assigned to the student | Garcia, Chris | <Office> | Status | |||
| <Created Date> | EAL-Details | Office | This data is populated from an internal SSP database | N/A | <Phone>Created Date | ||||
| <Closed By> | EAL-Details | Phone | This data is populated from an internal SSP database | N/A | <Department>Closed By | ||||
| <Closed Date> | EAL-Details | Department | This data is populated from an internal SSP database | N/A | <Email cc>Closed Date | ||||
| <Email CC> | EAL-Details | Email ccCC | This data is populated from an internal SSP databasefield is specified by the end user | N/A | |||||
| <Campus><Reasons> | EAL-Details | CampusReferral 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 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- DetailsResponse | Referral Reason | This data is populated from an internal SSP database | N/AOutcome |