User Tools

Site Tools


student:lms_export

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
student:lms_export [2020/10/13 16:49] lrosdahlstudent:lms_export [2020/10/13 19:42] (current) lrosdahl
Line 18: Line 18:
 | Last Name | Char  | Y | char(25) | Last Name. | | Last Name | Char  | Y | char(25) | Last Name. |
 | User Name | Char | Y | char(25) Teacher\\ char(30) Student | TeacherPortal User ID for teachers.\\  StudentPortal User Name for students.| | User Name | Char | Y | char(25) Teacher\\ char(30) Student | TeacherPortal User ID for teachers.\\  StudentPortal User Name for students.|
-| Email | Char | Y | varchar(45) Teacher\\ varchar(64) Student | Teacher/Administrator email. Students email.|+| Email | Char | Y | varchar(45) Teacher\\ varchar(64) Student | Teacher/Administrator email.\\ Student email.|
 | User Unique ID | Char | Y | char(8) | A unique identifier for the user record. Staff Employee Numbers will have **E_** prepended to them.\\ Student IDs will have **S_** prepended to them.| | User Unique ID | Char | Y | char(8) | A unique identifier for the user record. Staff Employee Numbers will have **E_** prepended to them.\\ Student IDs will have **S_** prepended to them.|
 | Role | Char  | Y | 'Teacher', 'Administrator', 'Student' | Staff with FSP Salary Class Code 'T' are extracted as 'Teacher', and with 'A' are extracted as 'Administrator'.\\ Students are coded as 'Student'.| | Role | Char  | Y | 'Teacher', 'Administrator', 'Student' | Staff with FSP Salary Class Code 'T' are extracted as 'Teacher', and with 'A' are extracted as 'Administrator'.\\ Students are coded as 'Student'.|
student/lms_export.1602607774.txt.gz · Last modified: 2020/10/13 11:49 (external edit)