S_MA_USR_X (ver 15.11.0)
This table is an extension of the [Users] table, which maintains additional user details.
Column Name | Version | Data Type | Description |
|---|---|---|---|
UsersDCID | 15.11.0 | Number(10,0) | Primary key that relates the extended table to the [Users] table. |
| EthnicityRaceCode | 15.11.0 | Varchar2(20) | The Massachusetts proprietary race code calculated from the checked federal race codes and the Hispanic/Latino indicator. Migrates from [Teachers]MA_ERCode. |
| LicenseCertificationNum | 15.11.0 | Varchar2(20) | The number assigned to the teaching license by the state at the time the teacher received their license. Migrates from [Teachers]MA_License_Cert_Num. |
| LocalEmpNum | 15.11.0 | Varchar2(20) | The identifying number assigned by the district or school to the employee. Migrates from [Teachers]MA_Local_Employee_Num. |
| MEPID | 15.11.0 | Varchar2(8) | The unique identifying number assigned by the state to the employee. Migrates from [Teachers]MA_Mepid. |
| State_ExcludeFromReporting | 15.11.0 | Number(1,0) | Indicates whether or not the employee should be excluded from state reporting. Migrates from [Teachers]MA_Exclude_From_EPIMS. |
| State_Middle_Name | 17.4.0 | Varchar2(30) | Migrated from: [Teachers]MA_middle_name. |