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. |
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 |