BC 1701 SLDC Extract
Introduction
This report creates a fixed column text file to be sent to the ministry. The file contains student demographic data, information on program enrolments, and a count of courses enrolled. The data is submitted up to 4 times a year depending on the type of school. Each submission is performed as of a snapshot date set each year by the ministry.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
School Selection
The extract can be run either for the currently selected school or for all schools in the district by selecting the appropriate option on the report input page.
Student Selection
One record appears in the 1701 SLDC Extract file for each student that is enrolled and active in an included school as of the snapshot date specified by the user when the report is run.
Report Input
For help with navigation and running the report, seeHow to Find and Generate a Report.
Field | Description |
---|---|
Use | Select one of the following options:
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:
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. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
The extract creates a single file containing header, detail, and trailer records. The file name has the format DDDNNNNN.STD where DDD is the 3 character ministry district number and NNNNN is the 5 character ministry school number for the currently selected school; if the district office is currently selected a school number of 00000 is used.
The number of header and trailer records is determined by whether the extract is run district wide or for the currently selected school (as specified by the Use report parameter above) and whether schools are consolidated (as specified by the Consolidate All Schools report parameter above):
If the report is run district wide and schools are not consolidated, a header and trailer is present for each school that has at least one enrolled student, and the detail records for students at each school appear between the header and trailer records for the school.
If the report is run district wide and schools are consolidated, a single header and trailer record identifying the district are present, and all student detail records appear between the header and trailer without regard for the school at which students are enrolled.
If the report is run for the currently selected school, a single header and trailer record identifying the school are present and all student detail records for the school appear between the header and trailer.
Header Record
Data Element | Description | [Table]FieldName | Field Length | Field Offset |
---|---|---|---|---|
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:
| [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 |
Detail Record
Data Element | Description | [Table]FieldName | Field Length | Field Offset |
---|---|---|---|---|
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; | 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. | [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 |
Trailer Record
Data Element | Description | [Table]FieldName | Field Length | Field Offset |
---|---|---|---|---|
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 |