PA PIMS Safe School Reports - Safety Staff Development Facts

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

Activity Code

The code identifying the type of qualification or training.

Valid values:

• INITIAL – Initial training date          

• WEAP – Firearms  qualifications (not required for security officers)

• CPR – CPR qualification (not required for security officers)

• FIRSTAID – First aid qualification (not required for security officers)

• MPOETC – MPOETC training       

• NASRO – NASRO training             

• LOCAL – Local training                  

Char(8)

4

pa_pims_ssdevfact.activity_code

Activity Start Date

Date of most recent qualification or training.

• For INITIAL, WEAP, CPR, and FIRST AID, use the actual qualification or training date.

• For MPOETC, NASRO, and LOCAL training, use the School Year Date YYYY-03-30.

The format is MM/DD/YYYY.

Char(10)

5

pa_pims_ssdevfact.activity_startdate

Activity Hours

Number of hours of training within the current year for MPOETC, NASRO, or LOCAL.

Decimal (10,3)

6

pa_pims_ssdevfact.activity_hours