This table stores mass data access level overrides for mass data tools. An entry in this table overrides the default capabilities defined for a data source on a single user access role.
This value overrides a role's default edit capability. Valid values: 0 = Cannot Edit,1 = Can Edit. Defaults to 0. Required.
Note: Currently this flag is only applicable to extension data sources. For any non-extension data sources, this value will be set to 0.
A value of 1 indicates the user can export values from any data source in the DEM module (as shown on the Export/Edit tab of the Edit User Access Role page in PowerSchool). Valid values: 0 = Cannot Export,1 = Can Export. Defaults to 0. Required.
The name of the export module indicating the table name, such as Students, or legacy module or PowerQuery name, such as Name-Enq-Powerschool. If table name, it could be white listed or are extensions.
Internal number for the associated RoleDef record. Indexed.
Sequential number generated by the application, but uniqueness in the table is guaranteed. Indexed. Required.
|WhenCreated||9.2.0||Timestamp(6)||Date and time the record was created. Defaults to system date. Required.|
|WhenModified||9.2.0||Timestamp(6)||Date and time the record was modified. Defaults to system date. Required.|
|WhoCreated||9.2.0||Varchar2(100)||The user login that created the record. Defaults to database user. Required.|
|WhoModified||9.2.0||Varchar2(100)||The user login that modified the record. Defaults to database user. Required.|