Tool: Early Alert Portlet
Explanation of Tool, Use, etc.
...
| 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 | externalexternal_faculty_course_roster | Early Alert - Course Roster Early Alert - Details | Status | The student's enrollment status in the course | Enrolled |
Early Alert Details
| Parameter | External Table | Location | Field Name | Description | Example | ||||
|---|---|---|---|---|---|---|---|---|---|
| formatted_course | external_faculty_course | Early Alert - Details | Course | The formatted course | CHM451 | ||||
| title | external_faculty_course | Early Alert - Details | Course | The title of the course | Higher Chemistry | ||||
| term_code | external_faculty_course | Early Alert - Details | Term | FA12 | external_course_facultySpecifies what term the course was taught by the faculty member | FA12 | |||
| first_name | external_faculty_course_roster | Early Alert - Details | Student | Student's first name | Patricia | ||||
| middle_name | external_faculty_course_roster | Early Alert - Details | Student | Student's middle name | N/A | ||||
| last_name | external_faculty_course_roster | Early Alert - Details | Student | Michael Anderson | Student's last name | Davis | |||
| status_code | external_faculty_course_roster | Early Alert - Details | Enrollment Status | The student's enrollment status in the course | Enrolled | ||||
| school_id | external_faculty_course_faculty_roster | Early Alert - Details | Net ID | manderson16Student's school ID | pdavis13 | ||||
| primary_email_address | external_faculty_course_faculty_roster | Early Alert - Details | Student Email | 7@uniconStudent's primary email address. Typically the institution-assigned email address. | 4@unicon.net | <Student Type> | |||
| student_type_code | external_person | Early Alert - Details | Student Type | N/A | 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 | Campus | This data is populated from an internal SSP database | N/A | |||||
| <Referral Reason> | Early Alert - Details | Referral Reason | This data is populated from an internal SSP database | N/A |