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. |
|
BeginningEducator |
15.8.0 |
Varchar2(2) |
Indicates if the staff member is in their first year of experience in their primary job classification. 00 = No, 01 = Yes. |
|
DateOfHire |
15.11.0 |
Date |
The date of the employee's most recent hire in the district. Migrates from [Teachers]MA_Date_Of_Hire. |
|
DegreeInstitution1 |
15.11.0 |
Varchar2(4) |
The educational institution from which the employee earned the degree or certification as specified in DegreeType1. Migrates from [Teachers]MA_Degree_Inst_1. |
|
DegreeInstitution2 |
15.11.0 |
Varchar2(4) |
The educational institution from which the employee earned the degree or certification as specified in DegreeType2. Migrates from [Teachers]MA_Degree_Inst_2. |
|
DegreeInstitution3 |
15.11.0 |
Varchar2(4) |
The educational institution from which the employee earned the degree or certification as specified in DegreeType3. Migrates from [Teachers]MA_Degree_Inst_3. |
|
DegreeSubject1 |
15.11.0 |
Varchar2(2) |
The major subject area in which the corresponding degree or certification specified in DegreeType1 was achieved. Migrates from [Teachers]MA_Degree_Subj_1. |
|
DegreeSubject2 |
15.11.0 |
Varchar2(2) |
The major subject area in which the corresponding degree or certification specified in DegreeType2 was achieved. Migrates from [Teachers]MA_Degree_Subj_2. |
|
DegreeSubject3 |
15.11.0 |
Varchar2(2) |
The major subject area in which the corresponding degree or certification specified in DegreeType3 was achieved. Migrates from [Teachers]MA_Degree_Subj_3. |
|
DegreeType1 |
15.11.0 |
Varchar2(3) |
Code describing the type of degree or credential earned by the Non-ELAR certified employee. Migrates from [Teachers]MA_Degree_Type_1. |
|
DegreeType2 |
15.11.0 |
Varchar2(3) |
Code describing the type of degree or credential earned by the Non-ELAR certified employee. Migrates from [Teachers]MA_Degree_Type_2. |
|
DegreeType3 |
15.11.0 |
Varchar2(3) |
Code describing the type of degree or credential earned by the Non-ELAR certified employee. Migrates from [Teachers]MA_Degree_Type_3. |
|
DistLvlEducProfTeacherStatus |
15.11.0 |
Varchar2(2) |
The educator’s current professional teacher status as determined by district policies. Migrates from [Teachers]MA_SR28. |
|
EmployStatusCollTime |
15.11.0 |
Varchar2(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. |
|
FedSalarySource1 |
15.11.0 |
Varchar2(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. |
|
FedSalarySource2 |
15.11.0 |
Varchar2(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. |
|
FedSalarySource3 |
15.11.0 |
Varchar2(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. |
|
ImpStudLearnGrowthAchRating |
15.11.0 |
Varchar2(2) |
The educator’s current school year rating indicating the educator's impact on student learning growth and achievement. Migrates from [Teachers]MA_SR34. |
|
PercentFedSalarySource1 |
15.11.0 |
Varchar2(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. |
|
PercentFedSalarySource2 |
15.11.0 |
Varchar2(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. |
|
PercentFedSalarySource3 |
15.11.0 |
Varchar2(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. |
|
ReasonForExit |
15.11.0 |
Varchar2(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. |
|
StaffExitDate |
15.11.0 |
Date |
The 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. |
|
StdEvalRating29 |
16.7.0 |
Varchar2(2) |
Migrated from: [Teachers]MA_sr29_new |
|
StdEvalRating30 |
16.7.0 |
Varchar2(2) |
Migrated from: [Teachers]MA_sr30_new |
|
StdEvalRating31 |
16.7.0 |
Varchar2(2) |
Migrated from: [Teachers]MA_sr31_new |
|
StdEvalRating32 |
16.7.0 |
Varchar2(2) |
Migrated from: [Teachers]MA_sr32_new |
|
StdEvalRating33 |
16.7.0 |
Varchar2(2) |
Migrated from: [Teachers]MA_sr33_new |
|
BeginnerEducatorMentor |
15.8.0 |
Varchar2(2) |
Indicates if the staff mentor |
|
StaffLeaveDate |
23.9.2.0 |
Date |
Staff leave begin date |
|
StaffLeaveEndDate |
25.9.2.0 |
Date |
Staff leave end date |