Date: Fri, 29 Mar 2024 03:29:28 -0400 (EDT) Message-ID: <272873927.2134.1711697368028@ip-10-22-30-100.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_2133_933689696.1711697368022" ------=_Part_2133_933689696.1711697368022 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
PeopleSoft T-Rex i= s a java client program that you will install on a server of your choice. <= strong>PS T-Rex is NOT installed into PeopleSoft.
It queries several PeopleSoft transfer rule da= tabase tables and sends the data to Transferology via Transferology web ser= vices.
Once the data has been received by Transferology, it is transforme= d into Transferology's transfer rule representation and loaded into Tr= ansferology later that night.
PeopleSoft schools are able to load their transfer ru= les into Transferology once a week and no longer need to use the EQ<= span> flat file import process.
It is provided for download in zip and tar.g= z file formats which contain the following:
Download, Install, and Configure
To download PS T-Rex, you must log in with a CollegeSource support cente= r account.
If you don't have a CollegeSource support center accou= nt, please use the following link to request one:
https://clients.collegesourc= e.com/myprofile/RequestAccountServlet
= PeopleSoft Extractor Downloads
PeopleSoft Extractor Install and Configure
You can view the Select SQL Statements run by the T-Rex client here: PeopleSoft T-Rex SQ= L
This process doesn=E2=80=99t take very long if we get the right people i= nvolved.
Typically, we will need the involvement of 4 roles:
Upgrade T-Rex Client
Upgrading the T-Rex Client is straightforward - it is almost always cont= ained in the lib folder. Occasionally, changes will occur in other folders.=
Instruction for upgrading are here:
Supported Java
The Transfer Rule Extractor is compiled in Java 8. It i=
s able to run in Java 8 and 11 environments.
This has been tested in the=
following Java environments:
I have provided a Java 11 compiled version of the Trans=
fer Rule Extractor on the downloads page for anyone who would like to use t=
hat version.
It is only compatible with Java 11 and tested in the follow=
ing environments:
The T-Rex client is run through a Veracode static security scan to l= ook for any vulnerabilities in its code or referenced code in third-party l= ibraries.
T-Rex client versions >=3D 1.0.3.2 have a score of 100%.
The PDF report can be viewed here:
Sending Courses
Currently, T-Rex uses the sending course (department ab= breviation and course code) specified in the transfer rule as is without pe= rforming any conversion or translation.
PeopleSoft Table Access
T-Rex requires SELECT privilege on the following PeopleSoft tables:=
PS_EXT_ORG_TBL
PS_EXT_ORG_TBL_ADM (If PeopleSoft Version 9)
PS_E= XT_ORG_PRI_VW (If PeopleSoft Version 9)
PS_EXT_TRNSFR_EQ
PS_TRNSFR_RU= LE
PS_TRNSFR_RSUB
PS_TRNSFR_SUBJ
PS_TRNSFR_COMP
PS_CRSE_CATALOG=
PS_TRNSFR_TO
PS_TRNSFR_TO_XS
PS_TRNSFR_FROM
PS_CRSE_OFFER
P= S_SCHOOL_CRSE_TBL
PS_SUBJECT_TBL
PS_CRSE_ATTRIBUTES
PS_CRSE_ATTR_T= BL
PS_CRSE_ATTR_VALUE
T-Rex requires SELECT privilege on the following PeopleSoft tables to = load the Standardized Exam Rules (loaded by default):
PS_TST_CREDIT_RULE=
PS_TST_CREDIT_COMP
PS_TST_CREDIT_CRSE
PS_SA_TEST_TBL
PS_SA_TCMP_REL_TBL
If necessary, please create database synonyms when the T-Rex dat= abase user isn=E2=80=99t the owning schema of the PS database tables.
When creating Transferology Transfer Rules from PeopleSoft Transfer Rule= s, these assumptions are made.