Oracle PeopleSoft - Class Schedule (Timetable)
Overview and Prerequisites
Prior to reviewing this page, please review the Oracle PeopleSoft Integration Directory page, including prerequisites found here as well as the Timetable overview. The class schedule services allows students to view their class schedule by month (on web), weekly (on app), allows student to view details for a specific class.
User Experience
The class schedule (timetable) service allows student to view their class schedule by month (on web), weekly (on app) and allows student to view details for a specific class
| Property | Live Tile | |
|---|---|---|
| Default Size | 1x2 | 1x1 |
| Minimum Size | 1x2 | 1x1 |
| Suggested Design |  |
 |
Screenshots
Sample Requests
The PeopleSoft Class schedule integration service is delivered by a QAS query. Please see PeopleSoft Product Integration Directory (Prerequisites) for additional information on QAS queries. All events should be individual, meaning that there is a row for each occurrence of the class. As opposed to “every Tuesday from 8:00 am – 9:00 am”.
The institution must develop a query that returns the following fields:
| Required Field | Type | Example |
|---|---|---|
| Student ID | Mandatory | 1234567 |
| Term | Mandatory | 20178 |
| Term Description | Mandatory | Fall 2017 |
| Start Date/Time | Mandatory | 2017-09-05 08:00:00Z05:00 |
| End Date/Time | Mandatory | 2017-09-05 09:00:00Z05:00 |
| Instructor Name (principal instructor) | Mandatory | Dr. Indiana Jones |
| Course Description | Mandatory | Archeology 101 |
| Day of the week | Mandatory | Tuesday |
| Facility Description | Mandatory | Main Hall Room 100 |
| Location Code | Mandatory | Main |
| Lecturer email address | Optional | i.jones@university.edu |
| Additional description fields (e.g. module code, etc.) | Optional | |
| Additional location fields | Optional | Upstairs on the right |
Optional fields will only be displayed if they are included in the QAS query response.
| Sample Request |
|---|
<soapenv:Envelope xmlns:qas="http://xmlns.oracle.com/Enterprise/Tools/schemas/QAS_EXEQRY_SYNC_REQ_MSG.VERSION_1" xmlns:qas1="http://xmlns.oracle.com/Enterprise/Tools/schemas/QAS_EXEQRY_SYNC_REQ.VERSION_1" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Header>
<wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:INST="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
<wsse:UsernameToken INST:Id="UsernameToken-F4C9E7AA3FD757983114993318546673">
<wsse:Username>usr</wsse:Username>
<wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">campusm</wsse:Password>
</wsse:UsernameToken>
</wsse:Security>
</soapenv:Header>
<soapenv:Body>
<qas:QAS_EXEQRY_SYNC_REQ_MSG>
<qas1:QAS_EXEQRY_SYNC_REQ>
<QueryName>INST_CAMPUSM_COURSE_SCHED</QueryName>
<isConnectedQuery>N</isConnectedQuery>
<OwnerType>PUBLIC</OwnerType>
<BlockSizeKB>0</BlockSizeKB>
<MaxRow>1000</MaxRow>
<OutResultType>XMLP</OutResultType>
<OutResultFormat>NONFILE</OutResultFormat>
<Prompts>
<!--Zero or more repetitions:-->
<PROMPT>
<PSQueryName/>
<UniquePromptName>BIND1</UniquePromptName>
<FieldValue>1243731</FieldValue>
</PROMPT>
<PROMPT>
<PSQueryName/>
<UniquePromptName>BIND2</UniquePromptName>
<FieldValue>2179</FieldValue>
</PROMPT>
</Prompts>
</qas1:QAS_EXEQRY_SYNC_REQ>
</qas:QAS_EXEQRY_SYNC_REQ_MSG>
</soapenv:Body>
</soapenv:Envelope>
|
| Sample Response |
|---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<QAS_GETQUERYRESULTS_RESP_MSG xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/QAS_GETQUERYRESULTS_RESP_MSG.VERSION_1">
<query numrows="4" queryname="INST_CAMPUSM_COURSE_SCHED" xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/QAS_QUERYRESULTS_XMLP_RESP.VERSION_1">
<row rownumber="1">
<A.EMPLID>123</A.EMPLID>
<A.STRM>321</A.STRM>
<A.TERM_DESCR30>Fall 2017</A.TERM_DESCR30>
<A.INSTRUCTOR_ID>321</A.INSTRUCTOR_ID>
<A.NAME>Joe Bloggs</A.NAME>
<A.EMAIL_ADDR>xyz@gmail.com</A.EMAIL_ADDR>
<A.DESCR3>BIOLOGY</A.DESCR3>
<A.DESCR>Humanity/Biol Un</A.DESCR>
<EXPR14_14>05:45PM</EXPR14_14>
<EXPR15_15>08:25PM</EXPR15_15>
<A.DAY_OF_WEEK>Tu</A.DAY_OF_WEEK>
<A.FACILITY_DESCR>Building 1</A.FACILITY_DESCR>
<A.LOCATION>OW</A.LOCATION>
<A.START_DT>2017-09-06</A.START_DT>
<A.END_DT>2017-12-23</A.END_DT>
</row>
<row rownumber="2">
<A.EMPLID>1243731</A.EMPLID>
<A.STRM>2179</A.STRM>
<A.TERM_DESCR30>Fall 2017</A.TERM_DESCR30>
<A.INSTRUCTOR_ID>123</A.INSTRUCTOR_ID>
<A.NAME>Kotter,Gabe</A.NAME>
<A.EMAIL_ADDR/>
<A.DESCR3>BIOLOGY</A.DESCR3>
<A.DESCR>Humanity/Biol Un</A.DESCR>
<EXPR14_14>05:45PM</EXPR14_14>
<EXPR15_15>08:25PM</EXPR15_15>
<A.DAY_OF_WEEK>Tu</A.DAY_OF_WEEK>
<A.FACILITY_DESCR>500 Building, Rm. 505</A.FACILITY_DESCR>
<A.LOCATION>OW</A.LOCATION>
<A.START_DT>2017-09-06</A.START_DT>
<A.END_DT>2017-12-23</A.END_DT>
</row>
</query>
</QAS_GETQUERYRESULTS_RESP_MSG>
</soapenv:Body>
</soapenv:Envelope>
|
Offline Functionality
Class events are cached on the device and can be viewed offline.
Configuration Options
| Configuration Item | Options |
|---|---|
| Add to Calendar | Add timetable event to the device calendar |
| Tile size | Increase the tile size from the 1x1 default size |
Labels
| Label | Default Value |
|---|---|
| Tile name on home screen | Class Schedule |
| Tile name screen title | Class Schedule |
| Monthly/Weekly schedule screen title | Click here for your course schedule |
| Course detail screen title | Details |
Suggested Testing Guidelines
The following acceptance criteria is recommend to be used as part of the testing and approval process:
- User can access the Timetable Tile and see their current class schedule
- User can navigate to view their class schedule
- Course information is displayed correctly
- Instructor email link connects to email
- User can add agenda items to their device calendar