PowerSchool SIS Oregon

S_OR_USR_X (ver 15.2.0)

This table is an extension of the [Users] table, which maintains demographic and other data for district and school staff.

Column Name

Version

Data Type

Description

UsersDCID

15.2.0

Number(10,0)

Primary key that relates the extended table back to the Users table.

AlternateLicNumber

17.10.0

Varchar2(50)

Other last name on the teacher's license.

QualificationComment

17.10.0

Varchar2(200)

Comment field for explanation of teacher's licensure.

TSPCAccntID

15.2.0

Varchar2(10)

Teacher Standards and Practices Commission Account Identifier.

TSPCLicensed

15.10.3

Number(1,0)

Indicates the user is licensed or registered with TSPC. Migrated from [Users.OR_TSPCLicensed].

UniqueStaffID

15.10.3

Varchar2(10)

Enter the teacher’s ODE Unique Staff Identifier. Migrated from [Users.OR_UniqueStaffIdentifier].