PA PIMS Safe School Reports - Safety Staff Assignment

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.

Employee Number

The employee number of the staff member.

Integer

2

employee.empl_no

SSN

The employee's social security number.

Char(11)

Formatted with dashes

3

employee.ssn

Assignment Code

The code for the certificated or non-certificated assignment.

For school security staff, use 9998.

Char(4)

4

pa_pims_ssassign.code

Location Code

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

Char(4)

5

pa_pims_ssassign.location

Assignment Date

If the assignment is a continuation from the previous school year, enter July 1 of the current school year.

For staff assignments within the current school year, enter the actual start date of the staff assignment.

For school security staff only, you may use 2009-07-01 if the actual start date during the year is unknown.

The format is MM/DD/YYYY.

Char(10)

6

pa_pims_ssassign.asn_date

FTE

The actual number of hours worked in a position divided by the maximum number of hours the position allows.

An FTE of 90% should be entered as 0.90, not 90.

Decimal (7,6)

7

pa_pims_ssassign.fte