PowerSchool ERP Iowa

Program Record

The following table shows the Iowa field names, data length, data type, state-provided notes, and definitions for the Program record type. The Iowa Department of Education released this information on October 14, 2020.

Field Name

Length (Max)

Type

Notes

Definition

Record Type

1

Character

Always 'P'

Identifies the record as a program record.

Local Staff ID

12

Character

From associated Staff Demographic record

Unique ID assigned by the district

Program

2

Character

-

Code to indicate the assignment is associated with a special program.

Position

3

Character

-

Position of the person on October 1.

FTE

5

Numeric

To 3 decimal places (example: 0.125)

A value between 0.001 and 1.00 that indicates the percentage of time allocated to the position by program. This is calculated by dividing the time a staff member spends in their position by program by the total time in the workweek.