This page sets expectations around the process of data entry into Peoplesoft.
Course Level Information Excel Format
Class Section Information Excel Format
Class Fees Excel Format
Program schedulers are expected to:
Utilize the university system, CLSS, to update Class Section Information in Peoplesoft.
Use the spreadsheet formats found above for all change requests submitted through the UCL service desk.
Format of the spreadsheets should not be modified.
Include the name of the University term in the title of the spreadsheet.
Submit one term per spreadsheet.
Use the first column of the spreadsheet to indicate the nature of the change.
Update Fee
Move fee to course level
etc.
Highlight cells in green where changes have been made.
Attend training refreshers every term.
Set dates for each term (November for Spring, for example)
Systems & Data team members are expected to:
Review submitted spreadsheets for formatting and clear identification of what is expected to change.
Work with the submitter to clear up any confusion in the update requests.
Provide estimates in completion times for the given spreadsheet updates.
Handle requests that impact student registration ASAP.
Complete larger term requests within 2 business days.
Return the spreadsheet with notes to clearly identify the items that were completed or information about why a request was not able to be completed.
Maintain communication with all of UCL around the current status of our systems including system outages, etc.
Conducting training 3 times a year.
Deliver KPI/reports to directors and schedulers during these trainings.
Measure/KPI
Halli Taukiuvea Create a how to internal document to manage spreadsheets to be able to track the KPI.
Track the number of times a single spreadsheet is returned to the programs due to incorrect or missing information.
Track the time it takes to complete the request. (Salesforce)
Track the number of items included in each spreadsheet.
Questions
Training?
This SLA will be reviewed at the end of each semester.
Typical System Updates Schedule:
This is based on the workaround for CLSS while Courseleaf addresses its issue with Session 4 courses.
Scheduling Office has committed to enter ALL information submitted through CLSS by 4:00 pm by the end of the day which is 5:00 pm.
If information is received after 4:00 pm the Scheduling Office will enter them the following business day and there will be a 24 hour delay in the systems updating below.
Once information is entered into Peoplesoft:
Peoplesoft data is pulled each morning into the operational data store (ODS) by 6:00 am.
Tableau refreshes its data from the operational data store (ODS) between 11:00 am and 12:00 pm. This is where programs will verify changes were made and updated correctly.
CE Web registration system and intranet is refreshed every business day by 10:00 am. This is done manually, so there could be delay depending on staffing.