Skip to main content
Skip table of contents


This table is a stand alone table that stores information used in the School Activity Report Detail view.

Column Name


Data Type


ETH_RACE 13.6.0 Varchar2(20)The ethnicity code for the staff record.
FIRST_NAME 13.6.0 Varchar2(20)The first name of the staff person.
GENDER 13.6.0 VarcharThe gender of the staff person.
LAST_NAME 13.6.0 Varchar2(20)The last name of the staff person.
MIDDLE_NAME 13.6.0 Varchar2(20)The middle name of the staff person.
PRIM_STAFF_ROLE 13.6.0 Varchar2(2)This is not collected.
RPT_RUN_ID 13.6.0 Number(,)Indicates the unique report run ID for this run. This links to the S_NC_RPT_RUN table to identify the LEA, School, Report Type, Instance ID, and Year ID.
SCHOOL_ID 13.6.0 Number(10,0)The school Number for this record.
SSN 13.6.0 Varchar2(11)The staff person's social security Number.
STAFF_UID 13.6.0 Varchar2(20)The state staff id Number.
TEACHER_ID 13.6.0 Number(10,0)The internal teacher id for this staff person.
TEACHER_NUMBER 13.6.0 Varchar2(20)The teacher Number for this staff person.
TEACHER_USERS_DCID 13.6.0 Number(10,0)Foreign key that links to the Users table.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.