Gigantrix

/*
Duluth Public Schools ISD 709
Query: 1 users.sql
Last Modified: 7/16/2015

Desc: Student & Staff 
  Another routine will likely be needed to 
  inactivate (set status = complete or delete) 
  students and staff when necessary (...annual run?).

Gigantrix

/*
Duluth Public Schools ISD 709
Query: 2 accounts.sql
Last Modified: 7/13/2015

Parent account (ISD 709 Duluth PS) created by Canvas 
Leave parent_account_id ‘blank’ in .csv extract 

Import sequence: 2 of 6 .csv files
*/

Gigantrix

/*
Duluth Public Schools ISD 709
Query: 3 terms.sql

Buildings   BldgID
AEO		44
ALC		29
Denfeld	 4
East		 5
Lincoln	51

Gigantrix

/*
Duluth Public Schools ISD 709
Query: 4 courses.sql

Import sequence: 4 of 6 .csv files
*/

USE duluth
GO

Gigantrix

/*
Duluth Public Schools ISD 709
Query: 5 sections.sql

Import sequence: 5 of 6 .csv files		
*/

SELECT DISTINCT 
  s.sectionID AS 'section_ID'
, s.courseID AS 'course_ID'

Gigantrix

/*
Duluth Public Schools IS 709
Query: 6 enrollments.sql
Last Modified: 7/15/2015

Notes: On 7/15/2015 Jim Haarris said, ‘…although  both course_id and section_id are
       labeled as ‘required field’, as long as 1 of the fields is populated, things
       will work.’

Import sequence: 6 of 6 .csv files