B01 - School Level (2018-19) - Legacy

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

Filler

Filler

N/A

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

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

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

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.

Filler

Filler

Filler

N/A

16