...
| 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-Course 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 |
| school_id | external_faculty_course_roster | EAL-Course Roster | Student ID | Student's school ID | manderson1 |
| first_name | external_faculty_course_roster | EAL-Course Roster EAL-Details | First Name | Student's first name | Michael |
| middle_name | external_faculty_course_roster | EAL-Course RosterEAL-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. 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 |
...
| Parameter | External Table | Location | Field NameN ame | Description | Example | ||||
|---|---|---|---|---|---|---|---|---|---|
| formatted_course | external_faculty_course | EAL-Details | Course Name | The formatted course | CHM451 | ||||
| titlecampus_code | external_faculty_courseperson | EAL-Details | CourseCampus | The title of the course | Higher Chemistry | term_code | external_faculty_coursehome campus for the student | DAY | |
| <Created By> | EAL-Details | Term | Specifies what term the course was taught by the faculty member | FA12 | first_name | external_faculty_course_rosterCreated By | |||
| <Status> | EAL-DetailsEAL-Course Roster | Student | Student's first name | Patricia | middle_name | external_faculty_course_rosterStatus | |||
| <Created Date> | EAL-DetailsEAL-Course Roster | Student | Student's middle name | N/A | last_name | external_faculty_course_rosterCreated Date | |||
| <Closed By> | EAL-DetailsEAL-Course Roster | Student | Student's last name | Davis | status_code | external_faculty_course_rosterClosed By | |||
| <Closed Date> | EAL-DetailsEAL-Course Roster | Enrollment Status | The student's enrollment status in the course | Enrolled | school_id | external_faculty_course_rosterClosed Date | |||
| <Email CC> | EAL-Details | Net ID | Student's school ID | pdavis13 | primary_email_address | external_faculty_course_rosterEmail CC | This field is specified by the end user | N/A | |
| <Reasons> | EAL-Details | Student Email | Student's primary email address. Typically the institution-assigned email address. | 4@unicon.net | |||||
| student_type_code | external_person | EAL-Details Main-Dashboard Main-Details | Student Type | The student_type is a primary characteristic of the student in SSP | EAL | ||||
| coach_school_id | external_person | EAL-Details Main-Details Main-Coach | Assigned Counselor/Coach | The coach assigned to the student. The value displayed on-screen is the coach actually assigned to the student when the screen is rendered, which may or may not be the same as the coach referenced by coach_school_id. Handling of that field is controlled by options set on the Admin -> Administrative Tools -> System Configuration -> Configuration Options screen. See coachSetFromExternalData and coachUnsetFromExternalData | Garcia, Chris | ||||
| <Office> | EAL-Details | Office | This field not supported. | N/A | |||||
| <Phone> | EAL-Details | Phone | This field not supported. | N/A | |||||
| <Department> | EAL-Details | Department | This field not supported. | N/A | |||||
| <Email cc> | EAL-Details | Email cc | This field is specified by the end user | N/A | |||||
| <Campus> | EAL-Details | Campus | This data is populated from an internal SSP database | N/A | |||||
| <Referral Reason> | EAL-Details | Referral Reason | This data is populated from an internal SSP database | N/AReferral Reason | This data is populated from an internal SSP database | N/A |
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- Response | Outcome |