This is an old revision of the document!
The LMS Export will export three files: Users, Courses, and Enrollment. It is currently being used for Schoology.
Notes:
This file contains and updates Schoology users. Students and teachers are included.
Column Name | Data Type | Required | Column Width | Notes |
---|---|---|---|---|
First Name | Char | Y | char(17) | First Name (BHR_EMP_DEMO, SR_STU_ENROLL). |
Last Name | Char | Y | char(25) | Last Name (BHR_EMP_DEMO, SR_STU_ENROLL). |
User Name | Char | Y | char(25) Teacher char(30) Student | TeacherPortal User ID for teachers (SR_GRADBK_LOGIN). StudentPortal User Name for students (SR_SP_USER_LOGIN). |
Char | Y | varchar(45) Teacher varchar(64) Student | Teacher/Administrator email (BHR_EMP_DEMO). Students email (SR_STU_DEMO). | |
User Unique ID | Char | Y | char(8) | 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 | Teacher, Administrator, or Student | 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 | char(3) | Campus ID (CR_INSTR_CYR) for teachers. Campus ID (SR_STU_ENROLL) for students. |
Grad Year | Char | Y | blank Teacher char(4) Student | Proposed Graduating Date of the student (SR_STU_DEMO_PEIMS). |
Additional Schools | Char | Y | char(3) each campus | Campus ID (CR_INSTR_CYR) of any other campuses associated with a teacher. Separated with pipes (|). |
Example file including headers:
FirstName | LastName | UserName | UserUniqID | Role | Building | GradYear | 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 | ' ' |
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 (DR_CRS_OFFERED_CYR). |
Course Code | Char | Y | char(11) | 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 | char(2) | Section Number (CR_MET_CYR). |
Section School Code | Char | Y | char(19) | School Year, Campus ID, Course Number, Section Number, and Semester Code combined (CR_SEC_OFFERED_CYR, CR_MET_CYR). |
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 (CR_GRD_RPTNG_INFO). |
Building | Char | Y | char(3) | 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 |
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 (CR_CRS_OFFERED_CYR). |
Section School Code | Char | Y | char(19) | 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 | char(8) | 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 | Teacher or Student | 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 | 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 (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 |