Home page for the PeopleSoft - Transfer Rule extractor, aka PS 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:
Download the T-Rex Client:
T-Rex Client Installation and Configuration:
T-Rex SELECT SQL Statements:
You can view the Select SQL Statements run by the T-Rex client here: PeopleSoft T-Rex SQL
Installation Process Required Roles:
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:
Java - Supported Versions
The Transfer Rule Extractor is compiled in Java 8. It is able to run in Java 8 and 11 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.
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 >= 22.214.171.124 have a score of 100%.
The PDF report can be viewed here:
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:
T-Rex requires SELECT privilege on the following PeopleSoft tables to load the Standardized Exam Rules (loaded by default):
An older version of T-Rex used the following for loading Standardized Exams, but they are no longer used:
If necessary, please create database synonyms when the T-Rex database user isn’t the owning schema of the PS database tables.
Assumptions about PeopleSoft Transfer Rules
When creating Transferology Transfer Rules from PeopleSoft Transfer Rules, these assumptions are made.
A "Does Not Transfer" Course is created as the Target (Internal Equivalent) Course when:
- The Transfer Component Transfer Course Flag is not Checked (PS_TRNSFR_COMP.TRNSFR_CRSE_FL = 'N').
- No PS_TRNSFR_TO (Internal Equivalent) Record exists in PeopleSoft for the Rule being processed.
- When the Transfer Course Flag is not checked, no Internal Equivalents can be created, but this is to handle bad data.
A PeopleSoft Transfer Rule is not created in Transferology, when:
- The Transfer Component Transfer Course Flag is Checked, PS_TRNSFR_TO (Internal Equivalent) Records exist, but the Course ID on the Internal Equivalent is blank (PS_TRNSFR_TO.CRSE_ID)
- The PS_TRNSFR_TO (Internal Equivalent) Record does not reference a valid PS_CRSE_OFFER Record, based on CRSE_OFFER_NBR and CRSE_ID:
- PS_TRNSFR_TO.CRSE_OFFER_NBR = PS_CRSE_OFFER.CRSE_OFFER_NBR AND PS_TRNSFR_TO.CRSE_ID = PS_CRSE_OFFER.CRSE_ID