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

Architecture of the PeopleSoft Transfer Rule Extractor Image Added

Tip

title	What is PeopleSoft T-Rex?

PeopleSoft T-Rex is

an installable client program which

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 rules 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.

Image Removed

...

It is provided for download in zip and tar.gz file formats which contain

...

Tip
the following:
Security java libraries A Linux shell script and Windows batch file to call the java program A trex.properties file for school specific configuration

...

Installation instructions

Download, Install, and Configure

Info

title	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

Download the T-Rex Client:

PeopleSoft Extractor Downloads

T-Rex Client Installation and Configuration:

PeopleSoft Extractor Install and Configure

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:

An IT person who can install, execute, and schedule the T-Rex Client on a Linux or Windows machine.
A Security person to create a Firewall rule to allow outgoing data from the T-Rex Client to our Receiver.
A DBA to create the T-Rex database user and grant SELECT access on the 21 tables required.
An Equivalency specialist to confirm the source schools and equivalencies within Transferology after your equivalencies are loaded.

Upgrade T-Rex Client

Info

title	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:

T-Rex Client Upgrade

Java - Supported Versions

Info

title	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:

Corretto java-8.322.06.2-amzn
Corretto java-11.0.16-amzn
OpenJDK java-11.0.2-open

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:

Corretto java-11.0.16-amzn
OpenJDK java-11.0.2-open

Security

Tip

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:SummaryReport_Transferology

Note

title	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

...

To download PS T-Rex, you must log in 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

Note

title	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

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

Code Block

language	sql
title	Standardized Exam Query: PS_TST_CREDIT_RULE, PS_TST_CREDIT_COMP, PS_TST_CREDIT_CRSE, PS_CRSE_CATALOG, PS_CRSE_OFFER

SELECT A.INSTITUTION, A.TST_EQVLNCY, A.EFFDT, A.DESCR AS EQV_DESCR, B.TEST_ID, B.TEST_COMPONENT, B.TRNSFR_EQVLNCY_CMP, B.DESCR AS TST_DESCR, B.MIN_SCORE, B.MAX_SCORE, C.CRSE_ID, C.CRSE_OFFER_NBR, C.UNT_TAKEN, D.DESCR AS CRSE_DESCR, E.SUBJECT, E.CATALOG_NBR FROM PS_TST_CREDIT_RULE A, PS_TST_CREDIT_COMP B, PS_TST_CREDIT_CRSE C, PS_CRSE_CATALOG D, PS_CRSE_OFFER E WHERE ..

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

The selected equivalencies must have child rows in the PS_TRNSFR_COMP and PS_TRNSFR_SUBJ tables.

Code Block

language	sql
title	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 ...

Code Block

language	sql
title	PS_EXT_ORG_TBL, PS_EXT_ORG_TBL_ADM, PS_EXT_ORG_PRI_VW

/**
 * Where clause specifies: MAX(PS_EXT_ORG_TBL.EFFDT)
 */
SELECT
    EXT.EXT_ORG_ID,
    EXT.EFFDT,
    EXT.DESCR50,
    A.IPEDS_CD,
    A.FICE_CD,
    A.ACT_CD,
    A.ATP_CD,
    A.LS_SCHOOL_TYPE,
    A.OFFERS_COURSES,
    A.CATALOG_ORG,
    VW.CITY,
    VW.STATE,
    VW.COUNTRY 
FROM PS_EXT_ORG_TBL EXT,
    PS_EXT_ORG_TBL_ADM A,
    PS_EXT_ORG_PRI_VW VW 
WHERE ...

Code Block

language	sql
title	PS_TRNSFR_COMP

/**
 * Where clause specifies: MAX(PS_TRNSFR_COMP.EFFDT)
 */

SELECT
    COMP.INSTITUTION,
    COMP.TRNSFR_SRC_ID,
    COMP.COMP_SUBJECT_AREA,
    CAST(COMP.EFFDT AS DATE) AS EFFDT,
    COMP.TRNSFR_EQVLNCY_CMP,
    COMP.DESCR,
    COMP.TRNSFR_PRIORITY,
    COMP.EXT_TERM_TYPE,
    COMP.TRNSFR_CRSE_FL,
    COMP.CNTNGNT_CRDT_FL,
    COMP.INP_CRSE_CNT,
    COMP.XS_CRSE_FL 
FROM PS_TRNSFR_COMP COMP
WHERE ...

Code Block

language	sql
title	PS_CRSE_CATALOG

SELECT
    CRSE_ID,
    EFFDT,
    COURSE_TITLE_LONG,
    DESCR
FROM PS_CRSE_CATALOG
WHERE ...

Code Block

language	sql
title	PS_TRNSFR_TO

SELECT
    INSTITUTION,
    TRNSFR_EQVLNCY_CMP,
    TRNSFR_SRC_ID,
    CRSE_ID,
    EFFDT,
    COMP_SUBJECT_AREA,
    CRSE_OFFER_NBR
FROM PS_TRNSFR_TO
WHERE ...

Code Block

language	sql
title	PS_TRNSFR_TO_XS

SELECT
    INSTITUTION,
    TRNSFR_EQVLNCY_CMP,
    TRNSFR_SRC_ID,
    CRSE_ID,
    EFFDT,
    COMP_SUBJECT_AREA,
    CRSE_OFFER_NBR
FROM PS_TRNSFR_TO_XS
WHERE ...

Code Block

language	sql
title	PS_TRNSFR_FROM

SELECT
    INSTITUTION,
    TRNSFR_CMP_SEQ,
    TRNSFR_SRC_ID,
    COMP_SUBJECT_AREA,
    EFFDT,
    TRNSFR_EQVLNCY_CMP,
    SCHOOL_SUBJECT,
    SCHOOL_CRSE_NBR,
    BEGIN_DT,
    END_DT
FROM PS_TRNSFR_FROM
WHERE ...

Code Block

language	sql
title	PS_CRSE_OFFER

SELECT
    CRSE_ID,
    EFFDT,
    SUBJECT,
    CATALOG_NBR,
    CRSE_OFFER_NBR
FROM PS_CRSE_OFFER
WHERE ...

Code Block

language	sql
title	PS_SCHOOL_CRSE_TBL

SELECT
    EXT_ORG_ID,
    EFFDT,
    SCHOOL_SUBJECT,
    SCHOOL_CRSE_NBR,
    EFF_STATUS,
    DESCR
FROM PS_SCHOOL_CRSE_TBL
WHERE ...

.

Assumptions about PeopleSoft Transfer Rules

...

QUICK LINKS

Page tree

Versions Compared

Old Version 53

New Version Current

Key

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

Download, Install, and Configure

Download the T-Rex Client:

T-Rex Client Installation and Configuration:

T-Rex SELECT SQL Statements:

Installation Process Required Roles:

Upgrade T-Rex Client

Java - Supported Versions

Security

Note

PeopleSoft

PeopleSoft Table Access

SQL Select Statements

Assumptions about PeopleSoft Transfer Rules

QUICK LINKS

Page tree

Page History

Versions Compared

Old Version 53

New Version Current

Key

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

Download, Install, and Configure

Download the T-Rex Client:

T-Rex Client Installation and Configuration:

T-Rex SELECT SQL Statements:

Installation Process Required Roles:

Upgrade T-Rex Client

Java - Supported Versions

Security

Note

PeopleSoft

PeopleSoft Table Access

SQL Select Statements

Assumptions about PeopleSoft Transfer Rules