RoleDefTeachersMap (ver7.1.1)
This table is used to assign roles to an administrator or teacher, for example mapping PowerSchool users to Schoolnet roles.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| ID | 7.1.1 | Number(19) | Unique sequential number generated by the application. Required. |
| RoleDefID | 7.1.1 | Number(19) | Internal number for the associated RoleDef record. Required. Indexed. |
| IsDistrict | 7.1.1 | Number(3,0) | This field is only used when SchoolID is null or empty. 1 indicates the role applies at the District Office. 0 indicates accessibility of the role in all schools for the teacher. Indicated as External Systems in the User Interface. Defaults to 0. Required. |
| IsEnabled | 7.1.1 | Number(3,0) | 1 indicates the role is available for the teacher. Required. |
| SchoolID | 7.1.1 | Number(10,0) | This ID is linked to the School_Number from the School table. Not used for records where IsDistrict value is 1. |
| TeachersDCID | 7.1.1 | Number(19) | The DCID of the teacher in the associated Users table (Users.DCID). Required. |
| WhenCreated | 7.1.1 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 7.1.1 | Timestamp(6) | The date and time the record was last modified. Defaults to system date. Required. |
| WhoCreated | 7.1.1 | Varchar2(100) | The name of the person who created the record. Defaults to database user. Required. |
| WhoModified | 7.1.1 | Varchar2(100) | The name of person who last modified the record. Defaults to database user. Required. |