Skip to main content
Skip table of contents

S_MA_USR_StaffRoster_X (ver 14.6.0)

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

Column Name

Version

Data Type

Description

UsersDCID

14.6.0

Number(10,0)

Primary key that relates the extended table to the [Users] table.

BeginningEducator15.8.0Varchar2(2)Indicates if the staff member is in their first year of experience in their primary job classification. 00 = No, 01 = Yes.
DateOfHire15.11.0DateThe date of the employee's most recent hire in the district. Migrates from [Teachers]MA_Date_Of_Hire.
DegreeInstitution115.11.0Varchar2(4)The educational institution from which the employee earned the degree or certification as specified in DegreeType1. Migrates from [Teachers]MA_Degree_Inst_1.
DegreeInstitution215.11.0Varchar2(4)The educational institution from which the employee earned the degree or certification as specified in DegreeType2. Migrates from [Teachers]MA_Degree_Inst_2.
DegreeInstitution315.11.0Varchar2(4)The educational institution from which the employee earned the degree or certification as specified in DegreeType3. Migrates from [Teachers]MA_Degree_Inst_3.
DegreeSubject115.11.0Varchar2(2)The major subject area in which the corresponding degree or certification specified in DegreeType1 was achieved. Migrates from [Teachers]MA_Degree_Subj_1.
DegreeSubject215.11.0Varchar2(2)The major subject area in which the corresponding degree or certification specified in DegreeType2 was achieved. Migrates from [Teachers]MA_Degree_Subj_2.
DegreeSubject315.11.0Varchar2(2)The major subject area in which the corresponding degree or certification specified in DegreeType3 was achieved. Migrates from [Teachers]MA_Degree_Subj_3.
DegreeType115.11.0Varchar2(3)Code describing the type of degree or credential earned by the Non-ELAR certified employee. Migrates from [Teachers]MA_Degree_Type_1.
DegreeType215.11.0Varchar2(3)Code describing the type of degree or credential earned by the Non-ELAR certified employee. Migrates from [Teachers]MA_Degree_Type_2.
DegreeType315.11.0Varchar2(3)Code describing the type of degree or credential earned by the Non-ELAR certified employee. Migrates from [Teachers]MA_Degree_Type_3.
DistLvlEducProfTeacherStatus15.11.0Varchar2(2)The educator’s current professional teacher status as determined by district policies. Migrates from [Teachers]MA_SR28.
EmployStatusCollTime15.11.0Varchar2(2)A two digit code that describes the employee's employment status at the time of the collection. Migrates from [Teachers]MA_Employment_Status.

EvaluationDate

14.8.0

Date

The date the performance evaluation was conducted for this educator.

EvaluatorMEPID

14.8.0

Varchar2(8)

The Massachusetts Education Personnel Identifier assigned to the person evaluating this educator's performance.

FedSalarySource115.11.0Varchar2(3)Code defining the source of the federal funding that pays part of the employee's salary, if applicable. Migrates from [Teachers]MA_Fed_Salary_Source_1.
FedSalarySource215.11.0Varchar2(3)Code defining the source of the federal funding that pays part of the employee's salary, if applicable. Migrates from [Teachers]MA_Fed_Salary_Source_2.
FedSalarySource315.11.0Varchar2(3)Code defining the source of the federal funding that pays part of the employee's salary, if applicable. Migrates from [Teachers]MA_Fed_Salary_Source_3.
ImpStudLearnGrowthAchRating15.11.0Varchar2(2)The educator’s current school year rating indicating the educator's impact on student learning growth and achievement. Migrates from [Teachers]MA_SR34.
PercentFedSalarySource115.11.0Varchar2(5)The percentage of the employee's salary that is paid by Federal salary source 1. Migrates from [Teachers]MA_Pct_Fed_Salary_Source_1.
PercentFedSalarySource215.11.0Varchar2(5)The percentage of the employee's salary that is paid by Federal salary source 2. Migrates from [Teachers]MA_Pct_Fed_Salary_Source_2.
PercentFedSalarySource315.11.0Varchar2(5)The percentage of the employee's salary that is paid by Federal salary source 3. Migrates from [Teachers]MA_Pct_Fed_Salary_Source_3.
ReasonForExit15.11.0Varchar2(2)A two digit code that describes the employee's reason for no longer being employed by the district. Migrates from [Teachers]MA_Reason_For_Exit.

StaffActualAttendDays

14.6.0

Varchar2(3)

The number of days the staff member was physically at the district or school.

StaffExitDate15.11.0DateThe month, day, and year the employee ended employment with the district. Migrates from [Teachers]MA_SR27.

StaffExpectedAttendDays

14.6.0

Varchar2(3)

The number of days the staff member was scheduled to be at the district or school.

StdEvalRating2916.7.0Varchar2(2)Migrated from: [Teachers]MA_sr29_new
StdEvalRating3016.7.0Varchar2(2)Migrated from: [Teachers]MA_sr30_new
StdEvalRating3116.7.0Varchar2(2)Migrated from: [Teachers]MA_sr31_new
StdEvalRating3216.7.0Varchar2(2)Migrated from: [Teachers]MA_sr32_new
StdEvalRating3316.7.0Varchar2(2)Migrated from: [Teachers]MA_sr33_new
JavaScript errors detected

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

If this problem persists, please contact our support.