RoleMassDataAccess (ver9.2.0)
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.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CanEditFlag | 9.2.0 | Number(1) | 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. |
CanExportFlag | 9.2.0 | Number(1) | 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. |
DataSourceName | 9.2.0 | Varchar2(210) | 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. |
RoleDefID | 9.2.0 | Number(19) | Internal number for the associated RoleDef record. Indexed. |
RoleMassDataAccessID | 9.2.0 | Number(19) | 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. |