BC 1701 SLDC Extract

Use

Select one of the following options:

• District Wide – Includes all student records on the PowerSchool server that meet the selection criteria.

• Current School Only (default value) – Includes all student records associated with the current school that meet the selection criteria.

To change the current school, click School at the top of the page and choose the appropriate school from the list.

Consolidate All Schools

This parameter applies only if the District Wide option above is selected for the Use parameter. If selected, the extract file contains only one header record and one trailer record and all student detail records are grouped with that header. If not selected, the extract file contains a header and a trailer record for each school that has included students, and each student detail record is grouped with the appropriate header record.

Current Selection Students

Indicate which students to include in the report by selecting one of the following options:

• The selected [number] students only – Run the report for students in the current selection that meet the selection criteria.

• All students (default value) – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Select Snapshot Date

Select a date from the date picker or enter a date using the format mm/dd/yyyy or mm-dd-yyyy. Only students enrolled in a school on this date are included in the extract.

Transaction Code

Identifies the record as a header record.

Always 'FFI'

3

0

Ministry School Code

The 8-character ministry assigned school code identifying the school for which the following student detail records are associated.

First 3 characters of [Prefs]Value (for [Prefs]Name = districtnumber) followed by first 5 characters of [Schools]Alternate_School_Number for the currently selected school.

If alternate school number is not defined [Schools]School_Number is used.

If the district office is currently selected a school number value of 00000 is used.

8

3

School Name

The school name identifying the school for which the following student detail records are associated.

District name is used if either of the following is true:

• The district office is currently selected.

• The Consolidate All Schools is option is selected when running district wide.

[Schools]Name.

Or

[Prefs]Value (where [Prefs]Name = districtname).

40

11

Report Date

Snapshot date in YYYYMMDD format.

Snapshot date specified on report input page.

8

51

Transaction Code

Identifies the record as a student detail record.

Always 'SRM'

3

0

Local Student ID

Local PowerSchool student number.

[Students]Student_Number

12

3

Student ID (PEN)

Ministry assigned personal education number.

[Students]State_StudentNumber

10

15

Legal Surname

Legal last name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

25

25

Legal Given Name

Legal first name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

25

50

Legal Middle Name

Legal middle name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Middle_Name

[Students]Middle_Name

25

75

Usual Surname

Preferred last name.

[S_BC_STU_Students_X]Preferred_LastName

25

100

Usual Given Name

Preferred first name.

[S_BC_STU_Students_X]Preferred_FirstName

25

125

Usual Middle Name

Preferred middle name.

[S_BC_STU_Students_X]Preferred_MiddleName

25

150

Birth Date

Date of birth in YYYYMMDD format.

[Students]DOB

8

175

Gender

Gender (M of F).

Note: If populated, the student's legal gender overrides the student's preferred gender.

[ StudentCoreFields]PSCore_Gender

[Students]Gender

1

183

Special Ed Category

Special education category.

[S_BC_STU_Students_X]Special_Ed_Cat

1

184

Unused

Filler.

Spaces

3

185

School Funding Code

School funding code.

[S_BC_STU_Students_X] School_Funding_Code

2

188

Native Indian Ancestry Indicator

Native Indian ancestry flag (Y or N).

[S_BC_STU_Students_X] Native_Indian_Ancestry;
'Y' if database value is 1, 'N' otherwise.

1

190

Home Language Spoken Code

Home language spoken code.

[S_BC_STU_Students_X] Home_Lang_Spoken

3

191

Unused

Filler.

Spaces

4

194

Other Courses

Count of courses enrolled that are not required for graduation or a college certificate.

[S_BC_STU_Students_X]Other_Courses

1

198

Support Blocks

Count of courses identified as support blocks (XSPBK ministry course codes).

[S_BC_STU_Students_X]College_Courses

1

199

Enrolled Grade Code

Enrolled grade level code.

[S_BC_STU_Students_X]Grade_Override if a value is defined.

If an override value is not defined, the zero-filled value of [Students]Grade_Level is used.

2

200

Enrolled Program Code

This field contains eight 2-character values indicating the programs in which the student is enrolled.

Concatenation of [S_BC_STU_Students_X] Program_Enrolled_Program_Code1 through _Code8.

If a program code is undefined, a value of '00' is used.

16

202

Career Program Code

Career program code.

[S_BC_STU_Students_X]Career_Program

2

218

Number Of Courses

Count of courses enrolled in current school year.
Format is 99v99.

[S_BC_STU_Students_X] Number_Of_Courses if a value is defined.

If a value is not defined, the number of CC records for the student with a term that falls in the current school year and for which the associated [Sections]Exclude_State_Rpt_YN is 'N' is used.

4

220

Band Code

Indian band code.

[S_BC_STU_Students_X]Band_Code

4

224

Postal Code

Home postal code in X9X9X9 format.

[Students]Zip

6

228

Transaction Code

Identifies the record as a trailer record.

Always 'BTR'

3

0

Student Transaction Count

Count of student detail records associated with the preceding header record

Zero filled.

Count of SRM records

6

3

Software Vendor Name

Name of software vendor supplying software to generate the extract file.

Always 'PowerSchool Group LLC'

100

9

Software Product Name

Name of software product used to generate the extract file.

Always 'PowerSchool'

100

109

Software Product ID

The Software Product ID is the software version in which YY is the year, M is the month, and R is the sequential build number, starting with "0".

Example: Ver 18.1.0, Ver 18.1.1, etc.

Ver YY.M.R

15

209