QUICK LINKS
Support
Issue Tracker
[Services]
Questions
[uAchieve 4.5 Applications]
[uAchieve 5.0 Applications]
Transferology
TES
[Training & Conferences]
Accessibility
What is PeopleSoft T-Rex?
PeopleSoft T-Rex is a java client program that you will install on a server of your choice. PS T-Rex is NOT installed into PeopleSoft.
It queries several PeopleSoft transfer rule database tables and sends the data to Transferology via Transferology web services.
Once the data has been received by Transferology, it is transformed into Transferology's transfer rule representation and loaded into Transferology later that night.
PeopleSoft schools are able to load their transfer rules into Transferology once a week and no longer need to use the EQ flat file import process.
It is provided for download in zip and tar.gz file formats which contain the following:
Download, Install, and Configure
To download PS T-Rex, you must log in with a CollegeSource support center account.
If you don't have a CollegeSource support center account, please use the following link to request one:
https://clients.collegesource.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 SQL
This process doesn’t take very long if we get the right people involved.
Typically, we will need the involvement of 4 roles:
Upgrade T-Rex Client
Upgrading the T-Rex Client is straightforward - it is almost always contained 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 is 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 Transfer Rule Extractor on the downloads page for anyone who would like to use that version.
It is only compatible with Java 11 and tested in the following environments:
The T-Rex client is run through a Veracode static security scan to look for any vulnerabilities in its code or referenced code in third-party libraries.
T-Rex client versions >= 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 abbreviation and course code) specified in the transfer rule as is without performing 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_EXT_ORG_PRI_VW (If PeopleSoft Version 9)
PS_EXT_TRNSFR_EQ
PS_TRNSFR_RULE
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
PS_SCHOOL_CRSE_TBL
PS_SUBJECT_TBL
PS_CRSE_ATTRIBUTES
PS_CRSE_ATTR_TBL
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 database user isn’t the owning schema of the PS database tables.
When creating Transferology Transfer Rules from PeopleSoft Transfer Rules, these assumptions are made.