Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

This page sets expectations around the process of data entry into Peoplesoft.

Table of Contents

Course Level Information Excel Format

Download From Tableau

Class Section Information Excel Format

Download From Tableau

Class Fees Excel Format

Download From Tableau

Program Schedulers Expected To:

  • Utilize the university system CLSS to submit Class Section Information to PeopleosftPeoplesoft/Scheduling Office.

  • Submit all other changes to Help/Service Desk (course changes, fee updates, new instructors or information to classes when section in CLSS is locked) to be made Peoplesoft through utilizing the spreadsheet templates above.

  • Spreadsheet column order should remain. Hide columns you don’t need but do not delete them or the content.

  • University Term should be in the title of the spreadsheet (Summer 2020, Spring 2022, etcetc…) : this means for the term you want the changed changes to be made for. One term per spreadsheet.

  • First column should indicate the description of the change to be made (see example above).

  • Cells where there has been a change that changes were made and the data needs to be made updated in Peoplesoft should be highlighted green.

Systems & Data Expected To:

  • If format is not followed above, we will return it to the submitter for them to correct.

  • Complete the The request will be completed within 2 business days. If there is a reason this cannot be done we will notify the submitter/reporter immediately.

  • Once complete the spreadsheet will be sent back to the scheduler with notes such as completed“completed”, could or “could not be completed because ofof…”, etc.

  • Maintain communications with programs about the status of our systems.

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 sent back 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.

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. Information

  • Scheduling Office has committed to enter ALL information submitted through CLSS by 4:00

to the scheduling office: Scheduling will commit to having the information entered into Peoplesoft by
  • pm by the end of the day which is 5:00 pm.

  • If information

sent later than 4:00pm: There
  • 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:

  • Peoplesosft Peoplesoft data Is is pulled each morning Into 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 can verify data entry was completedwill verify changes were made and updated correctly.

  • CE Web registration system and intranet is done refreshed every business day by 10:00 am. This is done manually each day, so there could be delay depending on staffing.