Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Oracle PeopleSoft - My Advisor

    campusM Logo wh bkg sm1.png

    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 Advisor - Tile.png

    Screenshots

    Advisor - Screenshot - 1.png   Advisor - Screenshot - 2.png

    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
    • Was this article helpful?