Transferology Technical Documentation

QUICK LINKS

Support
Issue Tracker
[Services]
Questions
[uAchieve 4.5 Applications]
[uAchieve 5.0 Application]
[uAchieve 5.1 Application]
Transferology
TES
[Training & Conferences]
Accessibility

Page tree
Skip to end of metadata
  • Created by Unknown User (podnardb), last modified by Unknown User (neighborsj) on Jan 23, 2020
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 35 Next »

Home page for the PeopleSoft - Transfer Rule extractor aka PS T-Rex.

What is PeopleSoft T-Rex?

PeopleSoft T-Rex is an installable client program which queries several PeopleSoft transfer rules 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.


PS T-Rex is a java client program, you will install on a server of your choice. PS T-Rex is NOT installed into PeopleSoft. It is provided for download in zip and tar.gz file formats which contain the following:

  • java libraries
  • A linux shell script and Windows batch file to call the java program
  • A trex.properties file for school specific configuration
  • Install instructions


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 Extractor Install and Configure


To download  PS T-Rex, you must login with a CollegeSource support center account:

PeopleSoft Extractor Downloads


If you don't have a CollegeSource support center account, please use the following link to request one:

https://clients.collegesource.com/myprofile/RequestAccountServlet


For the queries used by PS T-Rex see PeopleSoft Extractor SQL Select Statements.



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:

  1. The Transfer Component Transfer Course Flag is not Checked (PS_TRNSFR_COMP.TRNSFR_CRSE_FL = 'N'). 
  2. No PS_TRNSFR_TO (Internal Equivalent) Record exists in PeopleSoft for the Rule being processed.
    1. 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:

  1. 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)
  2. The PS_TRNSFR_TO (Internal Equivalent) Record does not reference a valid PS_CRSE_OFFER Record, based on CRSE_OFFER_NBR and CRSE_ID:
    1. PS_TRNSFR_TO.CRSE_OFFER_NBR = PS_CRSE_OFFER.CRSE_OFFER_NBR AND PS_TRNSFR_TO.CRSE_ID = PS_CRSE_OFFER.CRSE_ID




  • No labels