Skip to main content
Skip table of contents

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
ID7.1.1Number(19)Unique sequential number generated by the application. Required.
RoleDefID7.1.1Number(19)Internal number for the associated RoleDef record. Required. Indexed.

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. 

IsEnabled7.1.1Number(3,0)1 indicates the role is available for the teacher. Required.
SchoolID7.1.1Number(10,0)This ID is linked to the School_Number from the School table. Not used for records where IsDistrict value is 1.
TeachersDCID7.1.1Number(19)The DCID of the teacher in the associated Users table (Users.DCID). Required.
WhenCreated7.1.1Timestamp(6)The date and time the record was created. Defaults to system date. Required.
WhenModified7.1.1Timestamp(6)The date and time the record was last modified. Defaults to system date. Required.
WhoCreated7.1.1Varchar2(100)The name of the person who created the record. Defaults to database user. Required.
WhoModified7.1.1Varchar2(100)The name of person who last modified the record. Defaults to database user. Required.
JavaScript errors detected

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

If this problem persists, please contact our support.