Oracle PeopleSoft - My Advisor
Overview and Prerequisites
Prior to reviewing this page, please review the PeopleSoft Integration Directory page, including prerequisites found here.
User Experience
The My Advisor service allows a student to view contact information for their advisor and/or key contacts.
| Property | Static Tile |
|---|---|
| Default Size | 1x1 |
| Minimum Size | 1x1 |
| Suggested Design |  |
Screenshots
Sample Requests
The PeopleSoft My Advisor integration service is delivered by a QAS query. Please see PeopleSoft Product Integration Directory (Prerequisites) for additional information on QAS queries.
The institution needs to develop a query that returns the following fields:
| Required Field | Type | Example |
|---|---|---|
| Student ID | Mandatory | 1234567 |
| Advisor ID | Mandatory | 0620797 |
| Advisor name | Mandatory | Donna King |
| Advisor email address | Mandatory | Donna.King@university.edu |
| Contact type | Optional | Advisor |
| Advisor phone number | Optional | (713) 555-1234 |
| Department | Optional | History |
| School | Optional | Liberal Arts & Social Sciences |
| Advisor office location | Optional | 321 Main Hall |
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_KEY_CONTACTS</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>
</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="2" queryname="INST_CAMPUSM_KEY_CONTACTS" xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/QAS_QUERYRESULTS_XMLP_RESP.VERSION_1">
<row rownumber="1">
<EMPLID>1234567</EMPLID>
<ADVISOR_ID>0620797</ADVISOR_ID>
<NAME>Donna King</NAME>
<EMAIL_ADDR>DONNA.KING@UNIVERSITY.EDU</EMAIL_ADDR>
</row>
<row rownumber="2">
<EMPLID>1236710</EMPLID>
<ADVISOR_ID>0706805</ADVISOR_ID>
<NAME>Cathy Jones</NAME>
<EMAIL_ADDR>CATHY.JONES@UNIVERSITY.EDU</EMAIL_ADDR>
</row>
</query>
</QAS_GETQUERYRESULTS_RESP_MSG>
</soapenv:Body>
</soapenv:Envelope>
|
Offline Functionality
Not supported.
Configuration Options
Labels
| Label | Default Value |
|---|---|
| Tile name on home screen | My Advisor |
| Tile screen title | My Advisor |
Suggested Testing Guidelines
The following acceptance criteria is recommend to be used as part of the testing and approval process:
- User can access the ‘My Advisor’ tile and see their advisor/key contact details