This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
student:lms_export [2020/10/13 16:49] – lrosdahl | student: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.\\ | | User Name | Char | Y | char(25) Teacher\\ char(30) Student | TeacherPortal User ID for teachers.\\ | ||
- | | Email | Char | Y | varchar(45) Teacher\\ varchar(64) Student | Teacher/ | + | | Email | Char | Y | varchar(45) Teacher\\ varchar(64) Student | Teacher/ |
| 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 | ' | | Role | Char | Y | ' |