Oracle PeopleSoft - Grades - Ex Libris Knowledge Center

Overview and Prerequisites

Prior to reviewing this page, please review the Oracle PeopleSoft Integration Directory page, including prerequisites found here.

User Experience

The grades service allows student to view their grade details for an institution and semester. This data includes:

Cumulative GPA
Term GPA
Subject
Course Name
Course Grade

Property	Static Tile
Default Size	1x1
Minimum Size	1x1
Suggested Design

Screenshots

Sample Requests

The PeopleSoft enrollment web service provides the following SOAP and REST services.

Service Type	Service	Service	Parameters
SOAP	SSR_ENROLLMENT	SSR_GET_ENROLLMENT_REQ	EMPLID Academic Career (ACAD_CAREER) Institution Term (STRM)
REST	SSR_ENROLLMENT	SSR_GET_ENROLLMENT_R_POST	EMPLID Academic Career (ACAD_CAREER) Institution Term (STRM)

Sample Request
https://{HOST} /PSIGW/RESTListeningConnector/PSFT_CS/SSR_GET_ENROLLMENT_R.v1/ Institution will provide HOST. Please see prerequisites. enroll/getEnrollments?type={type}&languageCd={languageCd} enroll/getEnrollments?SCC_PROFILE_ID={SCC_PROFILE_ID}&languageCd={languageCd}
<?xml version="1.0"?> <SSR_GET_ENROLLMENT_REQ xmlns="http://xmlns.oracle.com/Enterprise/HCM/services"> <SCC_ENTITY_INST_ID>ITEM ROW 1</SCC_ENTITY_INST_ID> <EMPLID>SR13454</EMPLID> <ACAD_CAREER>UGRD</ACAD_CAREER> <INSTITUTION>PSUNV</INSTITUTION> <STRM>0530</STRM> </SSR_GET_ENROLLMENT_REQ>

Sample Request

https://{HOST} /PSIGW/RESTListeningConnector/PSFT_CS/SSR_GET_ENROLLMENT_R.v1/

Institution will provide HOST. Please see prerequisites.

enroll/getEnrollments?type={type}&languageCd={languageCd}
enroll/getEnrollments?SCC_PROFILE_ID={SCC_PROFILE_ID}&languageCd={languageCd}

<?xml version="1.0"?>
<SSR_GET_ENROLLMENT_REQ xmlns="http://xmlns.oracle.com/Enterprise/HCM/services">
 <SCC_ENTITY_INST_ID>ITEM ROW 1</SCC_ENTITY_INST_ID>
 <EMPLID>SR13454</EMPLID>
 <ACAD_CAREER>UGRD</ACAD_CAREER>
 <INSTITUTION>PSUNV</INSTITUTION>
 <STRM>0530</STRM>
</SSR_GET_ENROLLMENT_REQ>

Sample Response
<?xml version="1.0"?> <SSR_GET_ENROLLMENT_RESP xmlns = "http://xmlns.oracle.com/Enterprise/HCM/services"> <SSR_ENRL_STUDYLIST> <EMPLID>SR13424</EMPLID> <ACAD_CAREER>UGRD</ACAD_CAREER> <INSTITUTION>PSUNV</INSTITUTION> <STRM>0620</STRM> <SS_MESSAGE_LONG></SS_MESSAGE_LONG> <ENROLLMENT_DETAILS> <ENROLLMENT_DETAIL> <SUBJECT>ART</SUBJECT> <CATALOG_NBR>113</CATALOG_NBR> <ASSOCIATED_CLASS>1</ASSOCIATED_CLASS> <STDNT_ENRL_STATUS>E</STDNT_ENRL_STATUS> <ENROLL_STATUS_DESCR>Enrolled</ENROLL_STATUS_DESCR> <CLASS_DESCRIPTION>ART 113 - History of World Art</CLASS_DESCRIPTION> <WAITLIST_POS>0</WAITLIST_POS> <UNT_TAKEN>3</UNT_TAKEN> <GRADING_SCHEME_ENR>UGD</GRADING_SCHEME_ENR> <CRSE_GRADE_OFF></CRSE_GRADE_OFF> <GRADING_BASIS_ENRL>GRD</GRADING_BASIS_ENRL> <GRADE_BASIS_DESCRFORMAL>Graded</GRADE_BASIS_DESCRFORMAL> <RQMNT_DESIGNTN>DSGN</RQMNT_DESIGNTN> <RQMT_DESG_DESCRFORMAL>Design Course (Taken)</RQMT_DESG_DESCRFORMAL><ACAD_PROG>LAU</ACAD_PROG> <ACAD_PROG_DESCR>Liberal Arts Undergraduate</ACAD_PROG_DESCR> <ACAD_PROG_DESCR_VISIBLE>Undergraduate Grading Scheme</ACAD_PROG_DESCR_VISIBLE> <CLASS_SECTIONS> <CLASS_SECTION> <CLASS_NBR>1008</CLASS_NBR> <CLASS_SECTION>1</CLASS_SECTION> <SSR_COMPONENT>Lecture</SSR_COMPONENT> <LMS_LINK></LMS_LINK> <LINK_GRADEBOOK_VISIBLE>N</LINK_GRADEBOOK_VISIBLE> <LMS_LINK_VISIBLE>N</LMS_LINK_VISIBLE> <CRSE_ID>001205</CRSE_ID> <CRSE_OFFER_NBR>1</CRSE_OFFER_NBR> <SESSION_CODE>1</SESSION_CODE> <SESSION_CODE_DESCR>Regular</SESSION_CODE_DESCR> </CLASS_SECTION> </CLASS_SECTIONS> </ENROLLMENT_DETAIL> <ENROLLMENT_DETAIL> <SUBJECT>ENGLLIT</SUBJECT> <CATALOG_NBR>415</CATALOG_NBR> <ASSOCIATED_CLASS>1</ASSOCIATED_CLASS> <STDNT_ENRL_STATUS>E</STDNT_ENRL_STATUS> <ENROLL_STATUS_DESCR>Enrolled</ENROLL_STATUS_DESCR> <CLASS_DESCRIPTION>ENGLLIT 415 - Crit Theor</CLASS_DESCRIPTION> <WAITLIST_POS>0</WAITLIST_POS> <UNT_TAKEN>3</UNT_TAKEN> <GRADING_SCHEME_ENR>UGD</GRADING_SCHEME_ENR> <CRSE_GRADE_OFF>B</CRSE_GRADE_OFF> <GRADING_BASIS_ENRL>GRD</GRADING_BASIS_ENRL> <GRADE_BASIS_DESCRFORMAL>Graded</GRADE_BASIS_DESCRFORMAL> <RQMNT_DESIGNTN></RQMNT_DESIGNTN> <RQMT_DESG_DESCRFORMAL></RQMT_DESG_DESCRFORMAL> <ACAD_PROG>LAU</ACAD_PROG> <ACAD_PROG_DESCR>Liberal Arts Undergraduate</ACAD_PROG_DESCR> <ACAD_PROG_DESCR_VISIBLE>Undergraduate Grading Scheme</ACAD_PROG_DESCR_VISIBLE> <CLASS_SECTIONS> <CLASS_SECTION> <CLASS_NBR>1196</CLASS_NBR> <CLASS_SECTION>1</CLASS_SECTION> <SSR_COMPONENT>Lecture</SSR_COMPONENT> <LMS_LINK></LMS_LINK> <LINK_GRADEBOOK_VISIBLE>N</LINK_GRADEBOOK_VISIBLE> <LMS_LINK_VISIBLE>N</LMS_LINK_VISIBLE> <CRSE_ID>003318</CRSE_ID> <CRSE_OFFER_NBR>1</CRSE_OFFER_NBR> <SESSION_CODE>1</SESSION_CODE> <SESSION_CODE_DESCR>Regular</SESSION_CODE_DESCR> </CLASS_SECTION> </CLASS_SECTIONS> </ENROLLMENT_DETAIL> <ENROLLMENT_DETAIL> <SUBJECT>ENGLLIT</SUBJECT> <CATALOG_NBR>468</CATALOG_NBR> <ASSOCIATED_CLASS>1</ASSOCIATED_CLASS> <STDNT_ENRL_STATUS>E</STDNT_ENRL_STATUS> <ENROLL_STATUS_DESCR>Enrolled</ENROLL_STATUS_DESCR> <CLASS_DESCRIPTION>ENGLLIT 468 - Memoir</CLASS_DESCRIPTION> <WAITLIST_POS>0</WAITLIST_POS> <UNT_TAKEN>3</UNT_TAKEN> <GRADING_SCHEME_ENR>UGD</GRADING_SCHEME_ENR><CRSE_GRADE_OFF>A</CRSE_GRADE_OFF> <GRADING_BASIS_ENRL>GRD</GRADING_BASIS_ENRL> <GRADE_BASIS_DESCRFORMAL>Graded</GRADE_BASIS_DESCRFORMAL> <RQMNT_DESIGNTN></RQMNT_DESIGNTN> <RQMT_DESG_DESCRFORMAL></RQMT_DESG_DESCRFORMAL> <ACAD_PROG>LAU</ACAD_PROG> <ACAD_PROG_DESCR>Liberal Arts Undergraduate</ACAD_PROG_DESCR> <ACAD_PROG_DESCR_VISIBLE>Undergraduate Grading Scheme</ACAD_PROG_DESCR_VISIBLE> <CLASS_SECTIONS> <CLASS_SECTION> <CLASS_NBR>1202</CLASS_NBR> <CLASS_SECTION>1</CLASS_SECTION> <SSR_COMPONENT>Lecture</SSR_COMPONENT> <LMS_LINK></LMS_LINK> <LINK_GRADEBOOK_VISIBLE>N</LINK_GRADEBOOK_VISIBLE> <LMS_LINK_VISIBLE>N</LMS_LINK_VISIBLE> <CRSE_ID>003326</CRSE_ID> <CRSE_OFFER_NBR>1</CRSE_OFFER_NBR> <SESSION_CODE>1</SESSION_CODE> <SESSION_CODE_DESCR>Regular</SESSION_CODE_DESCR> </CLASS_SECTION> </CLASS_SECTIONS> </ENROLLMENT_DETAIL> <ENROLLMENT_DETAIL> <SUBJECT>MATH</SUBJECT> <CATALOG_NBR>435</CATALOG_NBR> <ASSOCIATED_CLASS>1</ASSOCIATED_CLASS> <STDNT_ENRL_STATUS>E</STDNT_ENRL_STATUS> <ENROLL_STATUS_DESCR>Enrolled</ENROLL_STATUS_DESCR> <CLASS_DESCRIPTION>MATH 435 - Topics in Math</CLASS_DESCRIPTION> <WAITLIST_POS>0</WAITLIST_POS> <UNT_TAKEN>3</UNT_TAKEN> <GRADING_SCHEME_ENR>UGD</GRADING_SCHEME_ENR> <CRSE_GRADE_OFF></CRSE_GRADE_OFF> <GRADING_BASIS_ENRL>GRD</GRADING_BASIS_ENRL> <GRADE_BASIS_DESCRFORMAL>Graded</GRADE_BASIS_DESCRFORMAL> <RQMNT_DESIGNTN></RQMNT_DESIGNTN> <RQMT_DESG_DESCRFORMAL></RQMT_DESG_DESCRFORMAL> <ACAD_PROG>LAU</ACAD_PROG> <ACAD_PROG_DESCR>Liberal Arts Undergraduate</ACAD_PROG_DESCR> <ACAD_PROG_DESCR_VISIBLE>Undergraduate Grading Scheme</ACAD_PROG_DESCR_VISIBLE> <CLASS_SECTIONS> <CLASS_SECTION> <CLASS_NBR>1326</CLASS_NBR> <CLASS_SECTION>1</CLASS_SECTION> <SSR_COMPONENT>Lecture</SSR_COMPONENT> <LMS_LINK></LMS_LINK> <LINK_GRADEBOOK_VISIBLE>N</LINK_GRADEBOOK_VISIBLE> <LMS_LINK_VISIBLE>N</LMS_LINK_VISIBLE> <CRSE_ID>003552</CRSE_ID> <CRSE_OFFER_NBR>1</CRSE_OFFER_NBR> <SESSION_CODE>1</SESSION_CODE> <SESSION_CODE_DESCR>Regular</SESSION_CODE_DESCR> </CLASS_SECTION> </CLASS_SECTIONS> </ENROLLMENT_DETAIL> </ENROLLMENT_DETAILS> </SSR_ENRL_STUDYLIST> </SSR_GET_ENROLLMENT_RESP>

Sample Response

<?xml version="1.0"?>
<SSR_GET_ENROLLMENT_RESP xmlns = "http://xmlns.oracle.com/Enterprise/HCM/services">
 <SSR_ENRL_STUDYLIST>
 <EMPLID>SR13424</EMPLID>
 <ACAD_CAREER>UGRD</ACAD_CAREER>
 <INSTITUTION>PSUNV</INSTITUTION>
 <STRM>0620</STRM>
 <SS_MESSAGE_LONG></SS_MESSAGE_LONG>
 <ENROLLMENT_DETAILS>
 <ENROLLMENT_DETAIL>
 <SUBJECT>ART</SUBJECT>
 <CATALOG_NBR>113</CATALOG_NBR>
 <ASSOCIATED_CLASS>1</ASSOCIATED_CLASS>
 <STDNT_ENRL_STATUS>E</STDNT_ENRL_STATUS>
 <ENROLL_STATUS_DESCR>Enrolled</ENROLL_STATUS_DESCR>
 <CLASS_DESCRIPTION>ART 113 - History of World Art</CLASS_DESCRIPTION>
 <WAITLIST_POS>0</WAITLIST_POS>
 <UNT_TAKEN>3</UNT_TAKEN>
 <GRADING_SCHEME_ENR>UGD</GRADING_SCHEME_ENR>
 <CRSE_GRADE_OFF></CRSE_GRADE_OFF>
 <GRADING_BASIS_ENRL>GRD</GRADING_BASIS_ENRL>
 <GRADE_BASIS_DESCRFORMAL>Graded</GRADE_BASIS_DESCRFORMAL>
 <RQMNT_DESIGNTN>DSGN</RQMNT_DESIGNTN>
 <RQMT_DESG_DESCRFORMAL>Design Course (Taken)</RQMT_DESG_DESCRFORMAL><ACAD_PROG>LAU</ACAD_PROG>
 <ACAD_PROG_DESCR>Liberal Arts Undergraduate</ACAD_PROG_DESCR>
 <ACAD_PROG_DESCR_VISIBLE>Undergraduate Grading Scheme</ACAD_PROG_DESCR_VISIBLE>
 <CLASS_SECTIONS>
 <CLASS_SECTION>
 <CLASS_NBR>1008</CLASS_NBR>
 <CLASS_SECTION>1</CLASS_SECTION>
 <SSR_COMPONENT>Lecture</SSR_COMPONENT>
 <LMS_LINK></LMS_LINK>
 <LINK_GRADEBOOK_VISIBLE>N</LINK_GRADEBOOK_VISIBLE>
 <LMS_LINK_VISIBLE>N</LMS_LINK_VISIBLE>
 <CRSE_ID>001205</CRSE_ID>
 <CRSE_OFFER_NBR>1</CRSE_OFFER_NBR>
 <SESSION_CODE>1</SESSION_CODE>
 <SESSION_CODE_DESCR>Regular</SESSION_CODE_DESCR>
 </CLASS_SECTION>
 </CLASS_SECTIONS>
 </ENROLLMENT_DETAIL>
 <ENROLLMENT_DETAIL>
 <SUBJECT>ENGLLIT</SUBJECT>
 <CATALOG_NBR>415</CATALOG_NBR>
 <ASSOCIATED_CLASS>1</ASSOCIATED_CLASS>
 <STDNT_ENRL_STATUS>E</STDNT_ENRL_STATUS>
 <ENROLL_STATUS_DESCR>Enrolled</ENROLL_STATUS_DESCR>
 <CLASS_DESCRIPTION>ENGLLIT 415 - Crit Theor</CLASS_DESCRIPTION>
 <WAITLIST_POS>0</WAITLIST_POS>
 <UNT_TAKEN>3</UNT_TAKEN>
 <GRADING_SCHEME_ENR>UGD</GRADING_SCHEME_ENR>
 <CRSE_GRADE_OFF>B</CRSE_GRADE_OFF>
 <GRADING_BASIS_ENRL>GRD</GRADING_BASIS_ENRL>
 <GRADE_BASIS_DESCRFORMAL>Graded</GRADE_BASIS_DESCRFORMAL>
 <RQMNT_DESIGNTN></RQMNT_DESIGNTN>
 <RQMT_DESG_DESCRFORMAL></RQMT_DESG_DESCRFORMAL>
 <ACAD_PROG>LAU</ACAD_PROG>
 <ACAD_PROG_DESCR>Liberal Arts Undergraduate</ACAD_PROG_DESCR>
 <ACAD_PROG_DESCR_VISIBLE>Undergraduate Grading Scheme</ACAD_PROG_DESCR_VISIBLE>
 <CLASS_SECTIONS>
 <CLASS_SECTION>
 <CLASS_NBR>1196</CLASS_NBR>
 <CLASS_SECTION>1</CLASS_SECTION>
 <SSR_COMPONENT>Lecture</SSR_COMPONENT>
 <LMS_LINK></LMS_LINK>
 <LINK_GRADEBOOK_VISIBLE>N</LINK_GRADEBOOK_VISIBLE>
 <LMS_LINK_VISIBLE>N</LMS_LINK_VISIBLE>
 <CRSE_ID>003318</CRSE_ID>
 <CRSE_OFFER_NBR>1</CRSE_OFFER_NBR>
 <SESSION_CODE>1</SESSION_CODE>
 <SESSION_CODE_DESCR>Regular</SESSION_CODE_DESCR>
 </CLASS_SECTION>
 </CLASS_SECTIONS>
 </ENROLLMENT_DETAIL>
 <ENROLLMENT_DETAIL>
 <SUBJECT>ENGLLIT</SUBJECT>
 <CATALOG_NBR>468</CATALOG_NBR>
 <ASSOCIATED_CLASS>1</ASSOCIATED_CLASS>
 <STDNT_ENRL_STATUS>E</STDNT_ENRL_STATUS>
 <ENROLL_STATUS_DESCR>Enrolled</ENROLL_STATUS_DESCR>
 <CLASS_DESCRIPTION>ENGLLIT 468 - Memoir</CLASS_DESCRIPTION>
 <WAITLIST_POS>0</WAITLIST_POS>
 <UNT_TAKEN>3</UNT_TAKEN>
 <GRADING_SCHEME_ENR>UGD</GRADING_SCHEME_ENR><CRSE_GRADE_OFF>A</CRSE_GRADE_OFF>
 <GRADING_BASIS_ENRL>GRD</GRADING_BASIS_ENRL>
 <GRADE_BASIS_DESCRFORMAL>Graded</GRADE_BASIS_DESCRFORMAL>
 <RQMNT_DESIGNTN></RQMNT_DESIGNTN>
 <RQMT_DESG_DESCRFORMAL></RQMT_DESG_DESCRFORMAL>
 <ACAD_PROG>LAU</ACAD_PROG>
 <ACAD_PROG_DESCR>Liberal Arts Undergraduate</ACAD_PROG_DESCR>
 <ACAD_PROG_DESCR_VISIBLE>Undergraduate Grading Scheme</ACAD_PROG_DESCR_VISIBLE>
 <CLASS_SECTIONS>
 <CLASS_SECTION>
 <CLASS_NBR>1202</CLASS_NBR>
 <CLASS_SECTION>1</CLASS_SECTION>
 <SSR_COMPONENT>Lecture</SSR_COMPONENT>
 <LMS_LINK></LMS_LINK>
 <LINK_GRADEBOOK_VISIBLE>N</LINK_GRADEBOOK_VISIBLE>
 <LMS_LINK_VISIBLE>N</LMS_LINK_VISIBLE>
 <CRSE_ID>003326</CRSE_ID>
 <CRSE_OFFER_NBR>1</CRSE_OFFER_NBR>
 <SESSION_CODE>1</SESSION_CODE>
 <SESSION_CODE_DESCR>Regular</SESSION_CODE_DESCR>
 </CLASS_SECTION>
 </CLASS_SECTIONS>
 </ENROLLMENT_DETAIL>
 <ENROLLMENT_DETAIL>
 <SUBJECT>MATH</SUBJECT>
 <CATALOG_NBR>435</CATALOG_NBR>
 <ASSOCIATED_CLASS>1</ASSOCIATED_CLASS>
 <STDNT_ENRL_STATUS>E</STDNT_ENRL_STATUS>
 <ENROLL_STATUS_DESCR>Enrolled</ENROLL_STATUS_DESCR>
 <CLASS_DESCRIPTION>MATH 435 - Topics in Math</CLASS_DESCRIPTION>
 <WAITLIST_POS>0</WAITLIST_POS>
 <UNT_TAKEN>3</UNT_TAKEN>
 <GRADING_SCHEME_ENR>UGD</GRADING_SCHEME_ENR>
 <CRSE_GRADE_OFF></CRSE_GRADE_OFF>
 <GRADING_BASIS_ENRL>GRD</GRADING_BASIS_ENRL>
 <GRADE_BASIS_DESCRFORMAL>Graded</GRADE_BASIS_DESCRFORMAL>
 <RQMNT_DESIGNTN></RQMNT_DESIGNTN>
 <RQMT_DESG_DESCRFORMAL></RQMT_DESG_DESCRFORMAL>
 <ACAD_PROG>LAU</ACAD_PROG>
 <ACAD_PROG_DESCR>Liberal Arts Undergraduate</ACAD_PROG_DESCR>
 <ACAD_PROG_DESCR_VISIBLE>Undergraduate Grading Scheme</ACAD_PROG_DESCR_VISIBLE>
 <CLASS_SECTIONS>
 <CLASS_SECTION>
 <CLASS_NBR>1326</CLASS_NBR>
 <CLASS_SECTION>1</CLASS_SECTION>
 <SSR_COMPONENT>Lecture</SSR_COMPONENT>
 <LMS_LINK></LMS_LINK>
 <LINK_GRADEBOOK_VISIBLE>N</LINK_GRADEBOOK_VISIBLE>
 <LMS_LINK_VISIBLE>N</LMS_LINK_VISIBLE>
 <CRSE_ID>003552</CRSE_ID>
 <CRSE_OFFER_NBR>1</CRSE_OFFER_NBR>
 <SESSION_CODE>1</SESSION_CODE>
 <SESSION_CODE_DESCR>Regular</SESSION_CODE_DESCR>
 </CLASS_SECTION>
 </CLASS_SECTIONS>
 </ENROLLMENT_DETAIL>
 </ENROLLMENT_DETAILS>
 </SSR_ENRL_STUDYLIST>
</SSR_GET_ENROLLMENT_RESP>

Offline Functionality

Not supported.

Configuration Options

The following elements are available for configuration as part of the campusM-PeopleSoft Grades integration. Please note that some configuration options are set within PeopleSoft. These options are used to control which data are displayed and how it is organized based on existing Campus Solutions Installation and Student Records configuration options.

Configuration Item	Options	Default Value
Default screen	Allow institutions to choose which screen the Grades tile will open to: Current semester grades Terms list	Terms list
Academic Career	Allow institutions to organize the grades display by academic career. This option can be used in combination with the default screen options. Current semester grades Terms list	Terms list
Display fields	The following fields are available to be displayed: Academic program Associated class Class description Class number Class section Grading basis Grading scheme Institution Institution description Requirement designation Session code Student enrollment status Term Term begin date Term end date Unit taken

Labels

Label	Default Value
Tile name on home screen	My Grades
Page title	Grades
Link to terms	Terms
Terms header	Please select a term:
Career	Academic Career
GPA	Term GPA Cumulative GPA

Suggested Testing Guidelines

The following acceptance criteria is recommend to be used as part of the testing and approval process:

User can access the Grades Tile and see their final grades for the current term
User can navigate to view their terms
User can select a term a see their final grades for that term