Skip to main content
Skip table of contents

B01 - School Level

Introduction

The B01 - School Level report extracts school level PowerSchool data. One record is transmitted for each school in the system.

Selection Criteria

Selection criteria determine which database records are used in the report.

This report extracts data that is manually entered on the Edit School page for each school.

Back to Top

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Select Schools

If run at the district level, choose one of the following:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report
  • All Schools – Run the report for the entire district.

If run at the school level, the report includes all 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.

Current Selection Students

Run the report for the current selection of students or all students.

File Path and File Suffix

The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix.

For example a report run at district 999 on August 1, 2014 at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201408010915_AAA.txt in the provided location. If no path is given, or if PowerSchool is unable to write to the given folder, the report will run but will not be saved to the server.

SFTP Connections

Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically.

Please refer to Setting Up a SFTP Connection for details on how to create a SFTP connection.

Back to Top

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.

ID

Data Element

Description

 [Table]FieldName

Length

B001

Fiscal Year

The fiscal year of the record.

The report extracts the year based on the last day in the current school calendar.

[Terms]LastDay

4

B002

Period

The reporting period.

Always 1.

N/A

1

B003

System Code

The school system code. This is the district number in PowerSchool.

[Prefs]Value

[Prefs]Name=districtnumber

3

B004

School Code

The school code.

Note: The alternate school number is extracted, if populated. Otherwise, the school number is extracted.

[Schools]Alternate_School_Number

[Schools]School_Number

4

B005

Record Type

Identifies the record layout.

Always B01.

N/A

3

B006

Filler

Filler

N/A

66

B007

Title I School Code

Indicates the type of Title I program this school year.

[S_GA_SCH_X]T1SC 

1

B008

STEAM/STEM School

Valid values:

  • blank
  • S - State-certified STEAM/STEM school
  • P - STEAM/STEM Program at school (some students participate)
  • N - Not a STEAM/STEM school (no STEAM/STEM Program at School)

Note: The report extracts blank when blank is selected.

[S_SCH_X]SteamStem

1

B009

Aggravated Battery

Number of Incidents of Aggravated Battery.

[S_GA_SCH_X]NCLB_AB

2

B010

Aggravated Child Molestation

Number of Incidents of Aggravated Child Molestation.

[S_GA_SCH_X]NCLB_ACM

2

B011

Aggravated Sexual Battery

Number of Incidents of Aggravated Sexual Battery.

[S_GA_SCH_X]NCLB_ASB

2

B012

Aggravated Sodomy

Number of Incidents of Aggravated Sodomy.

[S_GA_SCH_X]NCLB_AS

2

B013

Armed Robbery

Number of Incidents of Armed Robbery.

[S_GA_SCH_X]NCLB_AR

2

B014

First Degree Arson

Number of Incidents of First Degree Arson.

[S_GA_SCH_X]NCLB_FDA

2

B015

Kidnapping

Number of Incidents of Kidnapping.

[S_GA_SCH_X]NCLB_K

2

B016

Murder

Number of Incidents of Murder.

[S_GA_SCH_X]NCLB_M

2

B017

Rape

Number of Incidents of Rape.

[S_GA_SCH_X]NCLB_R

2

B018

Voluntary Manslaughter

Number of Incidents of Voluntary Manslaughter.

[S_GA_SCH_X]NCLB_VM

2

B019

Non-Felony Drugs

Number of Incidents of Non-Felony Drugs.

[S_GA_SCH_X]NCLB_NFD

2

B020

Felony Drug

Number of Incidents of Felony Drug.

[S_GA_SCH_X]NCLB_FD

2

B021

Felony Weapons

Number of Incidents of Felony Weapons.

[S_GA_SCH_X]NCLB_FW

2

B022

Terrorist Threats

Number of Incidents of Terrorist threats.

[S_GA_SCH_X]NCLB_TT

2

B023Dual Enrollment Awareness 8th GradeIndicates that eighth graders were made aware of Dual Enrollment opportunities.[S_GA_SCH_X]DualEnrollAware_Grade81
B024Dual Enrollment Awareness 9th GradeIndicates that ninth graders were made aware of Dual Enrollment opportunities. [S_GA_SCH_X]DualEnrollAware_Grade91
B025Dual Enrollment Awareness 10th GradeIndicates that tenth graders were made aware of Dual Enrollment opportunities. [S_GA_SCH_X]DualEnrollAware_Grade101
B026Dual Enrollment Awareness 11th GradeIndicates that eleventh graders were made aware of Dual Enrollment opportunities. [S_GA_SCH_X]DualEnrollAware_Grade111
B027-B079FillerFillerN/A228

B080

SOCIAL WORK SERVICES/INTERVENTIONS: Student Interventions - Individual and Group

Total number of single contacts in person, by phone, or mail with students by social workers this school year.

[S_GA_SCH_X]SWS_CWS

6

B081

SOCIAL WORK SERVICES/INTERVENTIONS: Conferences with Parents Or Guardians

Total number of single contacts in person, by phone, or mail with parent or family by social workers this school year.

[S_GA_SCH_X]SWS_CWPF

6

B082

SOCIAL WORK SERVICES/INTERVENTIONS: Consults with School Staff

Total number of single contacts in person, by phone, or mail with others by social workers this school year.

[S_GA_SCH_X]SWS_CWO

6

B083

SOCIAL WORK SERVICES/INTERVENTIONS: Consults with Agencies

Total number of agency consultations in order to improve student/family outcomes.

[S_GA_SCH_X]SWS_CACR

6

B084

SOCIAL WORK SERVICES/INTERVENTIONS: Economic Aid Sessions

Total number of sessions by social workers this school year which result in providing direct services such as clothing, glasses, etc.

[S_GA_SCH_X]SWS_EAS

6

B085

SOCIAL WORK SERVICES/INTERVENTIONS: Home/Agency Visits

Total number of trips made by social workers this school year to homes or agencies to impart or gather information.

[S_GA_SCH_X]SWS_HAV

6

B086

SOCIAL WORK/INTERVENTIONS: Mediation SessionsFiller beginning 2016-2017

6

B087

SOCIAL WORK CASES/CONSULTS: Child Abuse and Neglect Services (Formerly Abuse Services)

Total number of cases/consultations regarding physical, sexual, or emotional abuse handled by social workers this school year.

[S_GA_SCH_X]SWC_AS

6

B088

SOCIAL WORK CASES/CONSULTS: Academic Support (Formerly Academic Services)

Total number of cases/consults regarding underachievement, inattention, poor classroom work, or poor homework including IEP or RTI cases handled by social workers this school year.

[S_GA_SCH_X]SWC_ADS

6

B089

SOCIAL WORK CASES/CONSULTS: Attendance/Dropout Prevention Services (Formerly Attendance Services Including Dropouts)

Total number of cases/consults regarding unexcused absences or truancy, and cases/ consults involving students who have

been identified at-risk for dropping out of school handled by social workers this school year.

[S_GA_SCH_X]SWC_ASID

6

B090

SOCIAL WORK CASES/CONSULTS: School Safety Services

Total number of cases/consults involving discipline, bullying, alcohol/drugs, gangs and custody issues handled by social workers this school year.

[S_GA_SCH_X]SWC_DS

6

B091

SOCIAL WORK CASES/CONSULTS: Family/Health/Social Services/Homeless Services

Total number of cases/consults with parents and/or students for discipline problems, communication problems, and other problems such as parent drug abuse, divorce, mental illness, vision, immunizations, hearing, medications, hygiene, illness, etc. handled by social workers this school year.

[S_GA_SCH_X]SWC_FHPSS

6

B092

SOCIAL WORK CASES: Special Education

Total number of cases involving special Education students handled by social workers this school year.

[S_GA_SCH_X]SWC_SE


6

B093

SOCIAL WORK REFERRALS: Department of Family and Children Services (DFCS) (Formerly DFCS)

Total number of reports made by the SSW to the Department of Family and Child Services this school year.

[S_GA_SCH_X]SWR_DFCS

6

B094

SOCIAL WORK REFERRALS: Juvenile and Other Court

Total number of complaints/petitions filed by the SSW to juvenile, state, and other courts this school year.

[S_GA_SCH_X]SWR_JC

6

B095

SOCIAL WORK REFERRALS: Mental Health Services

Total number of direct referrals made by the SSW to mental health agencies this school year.

[S_GA_SCH_X]SWR_MH

6

B096

SOCIAL WORK REFERRALS: Health Services

Total number of direct referrals to health agencies or physicians other than mental health made by social workers this school year.

[S_GA_SCH_X]SWR_PH

6

B097

SOCIAL WORK REFERRALS: Community Agencies

Total number of direct referrals made by the SSW to Community Agencies other than DFACS, Courts, Mental Health, or Health providers this school year.

[S_GA_SCH_X]SWR_Other

6

B098

CPR_AED

Indicates whether a school with GRADE LEVEL ’09’ –‘12’ provided instruction in CPR and the use of AED in PE courses. Required for schools with GRADE LEVEL ‘09’ – ‘12’.

[S_GA_SCH_X]CPR_AED

1

B099

Online School

Indicates that the school offers only instruction in which students and teachers are separated by time and/or location, and that interaction occurs via computers and /or telecommunication technologies. A ‘virtual classroom’ generally does not have a physical facility that allows students to attend classes on site.

[S_GA_SCH_X]OnlineSchool


On the Schools/School Info page when the Online School Only box is checked, the report will have a value of ‘Y’. When unchecked the report value will be a default ‘N’. Blank or null is not allowed.

1

B100SOCIAL WORK CASES/CONSULTS: Suicide ReferralsTotal number of referrals received for children exhibiting signs of suicidal ideation.[S_GA_SCH_X]SWCC_SuicRef6
B101SOCIAL WORK CASES/CONSULTS: Homeless ServicesTotal number of cases involving homeless students and families handled by social workers this school year.[S_GA_SCH_X]SWCC_Homeless6
B102SOCIAL WORK CASES/CONSULTS: Special Programs

Number of assemblies, lunch and learn, parent night presentations, etc., where the social worker facilitated a presentation.

Note: This reflects the number of programs, not the number of participants.

[S_GA_SCH_X]SWCC_SpecProg6
B103SOCIAL WORK CASES/INTERVENTIONS: Group InterventionsTotal number of groups led or co-led by social workers this year, e.g. conflict resolution, self-esteem, grief, etc.[S_GA_SCH_X]SWCC_GrpInterv6
B104SOCIAL WORK CASES/INTERVENTIONS: Crisis InterventionsTotal number of single contacts in person, by phone, or mail involving life-threatening issues with students or staff (suicide, homicide, other death, or traumatic event).[S_GA_SCH_X]SWCC_CrisisInterv6
B105SOCIAL WORK CASES/INTERVENTIONS: Agency VisitsTotal number of trips made by social workers this school year to agencies to impact or gather information, e.g. juvenile court, DFCS, MDT, or other agency on behalf of students or families.[S_GA_SCH_X]SWCC_AgencyVisits6

Filler

Filler

Filler

N/A

16

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.