The security permissions for Flex Scheduling can be set up through the Security page by the System Admin. Generally those in charge of scheduling are the typical users who will need access to these tables. The tables designated with an *asterisk are specific to Flex.


Security  

Scheduling Tables
Permission
Description
Master Schedule (MST)
Read
Insert
Update
Delete
Necessary to view FTF, CCL, SSE
Add new record
Update records
Delete Records
Section Staff Members (SSE)*Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
See Master Schedule for more info.
Scheduling Master (SMS)Read
Insert
Update
Delete
Necessary to view FTF, CCL, SSM
Add new record
Update records
Delete Records
Staff Scheduling Master (SSM)*Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
See Scheduling Master for more info.
Staff (STF)Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
Courses (CRS)ReadUsed in all scheduling functions. Requires Read only.
Course Requests (SSS)
Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
See Course Requests for more info.



NOTE: In order to display the Flex Periods (FTF)Class Calendars (CCL) and Section Staff Members (SSE and SSM) data on a section, users will need Read permission to MST and SMS. 


Attendance Tables
Permission
Description
Flex Periods (FTF)*Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
*Full permissions are necessary to setup Flex Periods
See Flex Period for more info. 
Flex Period Times (FTT)*N/A
Security is mirrored using FTF and will not be listed on the Security page)
Bell Schedule Definitions (BSD)Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
Used in conjunction with Flex Period Times (FTT)
See Bell Scheduler for more info.
Class Calendars (CCL)*Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
*Full permissions are necessary to setup Class Calendars
See Class Calendar for more info.
Class Calendar Dates (CCD)*
N/A
Security is mirrored using CCL and will not be listed on the Security page)
Calendar (DAY)Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
See Calendar for details.
Class Attendance (CAT)*
(Student Attendance)
Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
See Student Attendance for more info.
Attendance Notes (ATN)Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records
Course Attendance (CAR)Read
Insert
Update
Delete
View page
Add new record
Update records
Delete Records