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.
- External process set up by technician nightly.
Users
This file contains and updates Schoology users. Students and teachers are included.
| Column Name | Data Type | Required | Notes |
|---|---|---|---|
| First Name | Char | Y | First Name (BHR_EMP_DEMO, SR_STU_ENROLL). |
| Last Name | Char | Y | Last Name (BHR_EMP_DEMO, SR_STU_ENROLL). |
| User Name | Char | Y | TeacherPortal User ID for teachers (SR_GRADBK_LOGIN). StudentPortal User Name for students (SR_SP_USER_LOGIN). |
| Char | Y | Teacher/Administrator email (BHR_EMP_DEMO). Students email (SR_STU_DEMO). | |
| User Unique ID | Char | Y | A unique identifier for the user record. Staff Employee Numbers will have E_ prepended to them (BHR_EMP_DEMO). Student IDs will have S_ prepended to them (SR_STU_ENROLL). |
| Role | Char | Y | FSP Salary Class Code for Teacher and Administrator roles (BTHR_JOB_CD | T = Teacher, A = Administrator) are coded as 'Teacher'. Students are coded as 'Student'. |
| Building | Char | Y | Campus ID (CR_INSTR_CYR). |
| Grad Year | Char | Y | Proposed Graduating Date of the student (SR_STU_DEMO_PEIMS). This will be extracted as an empty string for teachers. |
Example file including headers:
| FirstName | LastName | UserName | UserUniqID | Role | Building | GradYear | |
|---|---|---|---|---|---|---|---|
| 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 | ' ' |
| 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 | Notes |
|---|---|---|---|
| Course Name | Char | Y | Title of the course (DR_CRS_OFFERED_CYR). |
| Course Code | Char | Y | Campus ID and Course Code combined (CR_CRS_OFFERED_CYR). This is a unique identifier and cannot be used across multiple schools. |
| Section Name | Char | Y | Section Number (CR_MET_CYR). |
| Section School Code | Char | Y | Campus ID, Course Number, Section Number, and Semester Code combined (CR_SEC_OFFERED_CYR, CR_MET_CYR). |
| Grading Periods | Char | Y | Standard “term.” Multiple grading periods will be separated with pipes (|). Derived based on the Number of Semesters and the Number of Cycles per Semester (CR_GRD_RPTNG_INFO). |
| Building | Char | Y | Campus ID (CR_CRS_OFFERED_CYR). |
Example file including headers:
| Course Name | Course Code | Section Name | Section School Code | Grading Periods | Building |
|---|---|---|---|---|---|
| English 101 | 0050 | 01 | 0010050-011 | C1|C2|C3|C4 | 001 |
| English 101 | 0061 | 02 | 0010061-021 | C1|C2|C3|C4 | 001 |
| English 101 | 0083 | 03 | 0010083-031 | C1|C2|C3|C4 | 001 |
| English 101 | 0104 | 04 | 0010104-041 | C1|C2|C3|C4|C5|C6 | 001 |
| English 201 | 0214 | 01 | 0010214-012 | C1|C2|C3|C4 | 001 |
| English 201 | 0335 | 02 | 0010335-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 | Notes |
|---|---|---|---|
| Course Code | Char | Y | Campus ID and Course Number combined (CR_CRS_OFFERED_CYR). |
| Section School Code | Char | Y | Must be unique. School Year, Campus ID, Course Number, Section Number, and Semester Code combined (CR_SEC_OFFERED_CYR, CR_MET_CYR). |
| User Unique ID | Char | Y | A unique identifier for the user record. Staff Employee Numbers will have E_ prepended to them (BHR_EMP_DEMO). Student IDs will have S_ prepended to them (SR_STU_ENROLL). |
| Role | Char | Y | FSP Salary Class Code for Teacher and Administrator roles (BTHR_JOB_CD | T = Teacher, A = Administrator) are coded as 'Teacher'. Students are coded as 'Student'. |
| Grading Periods | Char | Y | Standard “term.” Multiple grading periods will be separated with pipes (|). Derived based on the Number of Semesters and the Number of Cycles per Semester (CR_GRD_RPTNG_INFO). |
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 | E_389277 | Teacher | C1|C2|C3|C4 |
| 0010214 | 20210010214-01-2 | E_927763 | Teacher | C1|C2|C3|C4|C5|C6 |
student/lms_export.1601663606.txt.gz · Last modified: 2020/10/02 13:33 (external edit)