student:lms_export
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help This is an old revision of the document!
Schoology LMS Export
The LMS Export will export three files: Users, Courses, and Enrollment. It is currently being used for Schoology.
Notes:
- This extract is used by clients who use Student applications.
- This is an external process set up by technician that is run nightly.
Users
This file contains and updates Schoology users. Students and teachers are included.
Note: Either the User Name or the Email are required for this file. You may include both.
| Column Name | Data Type | Required | Column Width | Notes |
|---|---|---|---|---|
| First Name | Char | Y | char(17) | First 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. |
| Char | Y | varchar(45) Teacher varchar(64) Student | Teacher/Administrator email. Students 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. |
| 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'. |
| Building | Char | Y | char(3) | Campus ID for teachers from the instructors table. Campus ID for students from the student enrollment table. |
| Grad Year | Char | Y | blank Teacher char(4) Student | Proposed Graduating Date of the student. |
| Additional Schools | Char | Y | char(3) each campus | Campus ID of any other campuses associated with a teacher. Separated with pipes (|). |
Example file including headers:
| Firs tName | Last Name | User Name | User Unique ID | Role | Building | Grad Year | Additional Schools | |
|---|---|---|---|---|---|---|---|---|
| Jenny | Brown | jbrown28 | jenny_brown15@district.edu | S_805860 | Student | 001 | 2022 | ' ' |
| Katie | Stevens | katie_stevens | katie_stevens14@district.edu8 | S_82606 | Student | 041 | 2026 | ' ' |
| Patrick | Black | pblack88 | patrick_black15@district.edu | S_789568 | Student | 001 | 2023 | ' ' |
| James | Smith | 21jamsmith | james_smith@district.edu | E_T156279 | Teacher | 001 | ' ' | 002|003 |
| Susie | Murphy | susie_murphy | susie_murphy@district.edu | E_867457 | Teacher | 004 | ' ' |
Courses
This file contains course sections.
Note: The courses file does not create course content. Content will need to be either created in or migrated to the course section from a Legacy LMS.
| Column Name | Data Type | Required | Column Width | Notes |
|---|---|---|---|---|
| Course Name | Char | Y | char(15) | Title of the course. |
| Course Code | Char | Y | char(11) | Campus ID and Course Code combined. This is a unique identifier and cannot be used across multiple schools. |
| Section Name | Char | Y | char(2) | Section Number. |
| Section School Code | Char | Y | char(19) | School Year, Campus ID, Course Number, Section Number, and Semester Code combined. |
| Grading Periods | Char | Y | char(11) or char(17) | Standard “term.” Multiple grading periods are separated with pipes (|). Derived based on the Number of Semesters and the Number of Cycles per Semester. |
| Building | Char | Y | char(3) | Campus ID. |
Example file including headers:
| Course Name | Course Code | Section Name | Section School Code | Grading Periods | Building |
|---|---|---|---|---|---|
| English 101 | 0010050 | 01 | 20210010050-011 | C1|C2|C3|C4 | 001 |
| English 101 | 0010061 | 02 | 20210010061-021 | C1|C2|C3|C4 | 001 |
| English 101 | 0010083 | 03 | 20210010083-031 | C1|C2|C3|C4 | 001 |
| English 101 | 0010104 | 04 | 20210010104-041 | C1|C2|C3|C4|C5|C6 | 001 |
| English 201 | 0010214 | 01 | 20210010214-012 | C1|C2|C3|C4 | 001 |
| English 201 | 0010335 | 02 | 20210010335-022 | C1|C2|C3|C4 | 001 |
Enrollments
This file contains users in course sections (associates teachers and students to course sections).
| Column Name | Data Type | Required | Column Width | Notes |
|---|---|---|---|---|
| Course Code | Char | Y | char(11) | Campus ID and Course Number combined. |
| Section School Code | Char | Y | char(19) | Must be unique. School Year, Campus ID, Course Number, Section Number, and Semester Code combined. |
| 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', 'Student' | Staff with FSP Salary Class Code 'T' or 'A' are extracted as 'Teacher'. Students are coded as 'Student'. |
| Grading Periods | Char | Y | char(11) or char(17) | Standard “term.” Multiple grading periods will be separated with pipes (|). Derived based on the Number of Semesters and the Number of Cycles per Semester. |
Example file with headers:
| Course Code | Section School Code | User Unique ID | Role | Grading Periods |
|---|---|---|---|---|
| 0010050 | 20210010050-01-1 | E_203584 | Teacher | C1|C2|C3|C4 |
| 0010061 | 20210010061-02-1 | E_489267 | Teacher | C1|C2|C3|C4 |
| 0010083 | 20210010083-03-1 | E_737792 | Teacher | C1|C2|C3|C4 |
| 0010104 | 20210010104-04-1 | S_389277 | Student | C1|C2|C3|C4 |
| 0010214 | 20210010214-01-2 | S_927763 | Student | C1|C2|C3|C4|C5|C6 |
student/lms_export.1602603161.txt.gz · Last modified: 2020/10/13 10:32 (external edit)