PowerSchool ERP Indiana

Staff Injury Report - File Layout and Data Mapping

The default file name for the IN Staff Injury report is IN Staff Injury Report_<Snapshot Date>.csv.

The electronic file is generated in a survey format with four rows, each representing a question and its aggregated response count.

Column

Field Name

Description

Data source and Valid values

1

SurveyIdentifier

The survey identifier.

The valid value is StaffInjurySurvey.

2

SchoolId

The school/division location code.


3

QuestionCode

A unique code identifying the survey question.

Valid values:

  • StaffInjuryQ0

  • StaffInjuryQ1

  • StaffInjuryQ2

  • StaffInjuryQ3

4

Question

The full text of the survey question.

Refer to Survey Questions.

5

Response

The computed count (response) for the corresponding question.

Refer to Survey Questions.

Survey Questions

The electronic file contains exactly four data rows:

Question Code

Question Text

Valid Value

StaffInjuryQ0

How many staff injury incidents occurred while on the job involving one or more below questions?

The total count of all staff injury incident records.

StaffInjuryQ1

How many incidents happened where staff's injury was required to be reported to the public schools' worker's compensation carrier

The count of records where Injury Reported to Compensation Carrier = Y.

StaffInjuryQ2

How many incidents happened where staff's injury caused them to miss all or part of one (1) or more work days

The count of records where Missed One or More Workdays = Y.

StaffInjuryQ3

How many incidents happened where staff's injury was required to be reported to the public school's reporting policy

The count of records where Injury Reported Publicly = Y.