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 on Jan 28, 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 40 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


PeopleSoft Table Access

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_TRNSFR_EQ
PS_TRNSFR_RULE

PS_TRNSFR_RSUB
PS_TRNSFR_SUBJ
PS_TRNSFR_COMP

PS_CRSE_CATALOG
PS_TRNSFR_TO

PS_TRNSFR_FROM

PS_CRSE_OFFER

PS_SCHOOL_CRSE_TBL

And if you want to enable the loading of Standardized Exam Rules:
PS_TST_CREDIT_RULE
PS_TST_CREDIT_COMP
PS_TST_CREDIT_CRSE

An older version of T-Rex used the following for loading Standardized Exams, but they are no longer used:
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.


SQL Select Statements

PS_EXT_TRNSFR_EQ, PS_TRNSFR_RULE, PS_TRNSFR_RSUB, PS_TRNSFR_SUBJ
PS_EXT_TRNSFR_EQ, PS_TRNSFR_RULE, PS_TRNSFR_RSUB, PS_TRNSFR_SUBJ
SELECT DISTINCT
    A.INSTITUTION,
    A.TRNSFR_SRC_ID,
    A.DEF_RULE_SRC_ID
FROM
    PS_EXT_TRNSFR_EQ A,
    PS_TRNSFR_RULE B,
    PS_TRNSFR_RSUB C,
    PS_TRNSFR_SUBJ D
WHERE ...


PS_EXT_ORG_TBL, PS_EXT_ORG_TBL_ADM
SELECT
    EXT.EXT_ORG_ID,
    EXT.EFFDT,
    A.IPEDS_CD,
    A.FICE_CD,
    A.ACT_CD,
    A.ATP_CD,
    A.CATALOG_ORG,
    EXT.DESCR50
FROM PS_EXT_ORG_TBL EXT,
    PS_EXT_ORG_TBL_ADM A
WHERE ...


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