User:Adbuckne/sandbox

=LFP Schedule=

How to generate the CALS Large format Printing Schedule, control who has access, and how to do the reporting.

Archive
Go into CALS-SQL and move all of the old appointments to the Archive versions.
 * 1) Connect to CALS-SQL.cals.ncsu.edu (.admin account)
 * 2) Databases > CALS_Main > Tables
 * 3) Move dbo.tblCALS_LFP_Appointments > dbo.tblCALS_LFP_Appointments_all_archive
 * 4) * dbo.tblCALS_LFP_Appointments needs to be wiped afterwards
 * 5) Move dbo.tblCALS_LFPscheduledAppts > dbo.tblCALSschdeuledAppts_all_archive
 * 6) * dbo.tblCALS_LFPscheduledAppts needs to be wiped afterwards

Access

 * 1) Connect to CALS-SQL.cals.ncsu.edu
 * 2) Databases > CALS_Main > Tables > dbo.tblCALS_LFPAdmin
 * 3) Add a new entry with users Unity ID
 * 4) * Engineering - Set ActiveCal, UberUser3, and Engineering_check to True(1)
 * 5) * Lab Assistants - Set ActiveCal, UberUser, and CALS_check to True(1)