B01 - School Level

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.

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.

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 USCO Incidents of Aggravated Battery.

[S_GA_SCH_X]NCLB_AB

2

B010

Aggravated Child Molestation

Number of USCO Incidents of Aggravated Child Molestation.

[S_GA_SCH_X]NCLB_ACM

2

B011

Aggravated Sexual Battery

Number of USCO Incidents of Aggravated Sexual Battery.

[S_GA_SCH_X]NCLB_ASB

2

B012

Aggravated Sodomy

Number of USCO Incidents of Aggravated Sodomy.

[S_GA_SCH_X]NCLB_AS

2

B013

Armed Robbery

Number of USCO Incidents of Armed Robbery.

[S_GA_SCH_X]NCLB_AR

2

B014

First Degree Arson

Number of USCO Incidents of First-Degree Arson.

[S_GA_SCH_X]NCLB_FDA

2

B015

Kidnapping

Number of USCO Incidents of Kidnapping.

[S_GA_SCH_X]NCLB_K

2

B016

Murder

Number of USCO Incidents of Murder.

[S_GA_SCH_X]NCLB_M

2

B017

Rape

Number of USCO Incidents of Rape.

[S_GA_SCH_X]NCLB_R

2

B018

Voluntary Manslaughter

Number of USCO Incidents of Voluntary Manslaughter.

[S_GA_SCH_X]NCLB_VM

2

B019

Non-Felony Drugs

Number of USCO Incidents of Non-Felony Drugs.

[S_GA_SCH_X]NCLB_NFD

2

B020

Felony Drug

Number of USCO Incidents of Felony Drug.

[S_GA_SCH_X]NCLB_FD

2

B021

Felony Weapons

Number of USCO Incidents of Felony Weapons.

[S_GA_SCH_X]NCLB_FW

2

B022

Terrorist Threats

Number of USCO Incidents of Terrorist Threats.

[S_GA_SCH_X]NCLB_TT

2

Total number of cases regarding health services, such as hearing, dental, vision,
immunizations, medications, illness, and so on handled by school social workers this school year.

Total number of cases involving students in foster care (e.g., Trauma-Informed
Education Support (TIES) meetings) handled by the school social worker this school year.

Unduplicated number of individual students served by the school social worker per school year. Each student counts once, even with multiple case/intervention/referral categories.

Total number of crisis response team deployments during or following a traumatic event (e.g., death, school lock-down, emergency that causes school disruption, etc.) by the school social worker.

Total number of contacts with other professionals and/or interns to provide supervision,
mentorship, or guidance by a school social worker.

Total number of community meetings attended by a school social worker, as a school district representative.

B080

SOCIAL WORK SERVICES/INTERVENTIONS: Student Interventions - Conferences with Students

Total number of single contacts in person, by phone, or by 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 by 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 by mail with others by social workers this school year.

[S_GA_SCH_X]SWS_CWO

6

B084

SOCIAL WORK SERVICES/INTERVENTIONS: Economic Aid Support

Total number of sessions by social workers this school year which resulted 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

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)

The total number of cases regarding academic challenges (e.g., underachievement, inattention, incomplete assignments, etc.) including Response to Intervention (RTI) and Student Support Team (SST) cases, handled by the school social worker this school year. Exclude Individual Education Plans (IEP) and Students with Disabilities (SWD); see B092.

[S_GA_SCH_X]SWC_ADS

6

B089

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

Total number of cases 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: Behavior/Discipline Services

The 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: Family Services

Total number of cases with parent/guardian problems (e.g., parent/guardian distress,
substance abuse, poverty, economic aid, divorce/custody, parenting skills, etc.) handled by the school social worker this school year.

[S_GA_SCH_X]SWC_FHPSS

6

B092

SOCIAL WORK CASES: Special Education Services

The 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

The total number of special programs (e.g., assemblies, lunch and learns, parent night presentations, etc.) where the school social worker shared information or facilitated a
presentation. This should reflect the number of programs, not the number of participants.

Filler

Filler

Filler

N/A

10