PA PIMS Safe School Reports - Safety Staff

Load Date

Reporting date for the PIMS Safe Schools reporting submission.

The format is MM/DD/YYYY.

Char(10)

1

The date entered in the Report Date field on the PA PIMS Safe School Reports page.

Location Code

The PDE-defined four-digit code identifying the school where the staff member is assigned.

Char(4)

2

pa_pims_ssassign. location

Employee Number

The employee number of the staff member.

Integer

3

employee.empl_no

SSN

The employee's social security number.

Char(11)

Formatted with dashes

4

employee.ssn

Last Name

The employee’s last name.

Char(15)

5

employee.lname

First Name

The employee’s first name.

Char(15)

6

employee.fname

Staff Qualification Status Code

The type of school security staff.

Required for school security staff. You should not use this field for other staff.

Valid values:

• SSO – School Security Officer

• SRO – School Resource Officer

• SPO – School Police Officer

Char(20)

7

pa_pims_ssstaff.qualcode

Weapon Flag

Indicates whether the school security staff member is allowed to carry a weapon.

Valid values:

• Y – Yes

• N – No

Char(1)

8

pa_pims_ssstaff.weapflag