QUICK LINKS
Support
Issue Tracker
[Services]
Questions
[uAchieve 4.5 Applications]
[uAchieve 5.0 Application]
[uAchieve 5.1 Application]
Transferology
TES
[Training & Conferences]
Accessibility
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
Security
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_9_Oct_2020.pdf
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 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
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
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
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.
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, 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 ...
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 ...
PS_CRSE_CATALOG
SELECT
CRSE_ID,
EFFDT,
COURSE_TITLE_LONG,
DESCR
FROM PS_CRSE_CATALOG
WHERE ...
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 ...
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 ...
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 ...
PS_CRSE_OFFER
SELECT
CRSE_ID,
EFFDT,
SUBJECT,
CATALOG_NBR,
CRSE_OFFER_NBR
FROM PS_CRSE_OFFER
WHERE ...
PS_SCHOOL_CRSE_TBL
SELECT
EXT_ORG_ID,
EFFDT,
SCHOOL_SUBJECT,
SCHOOL_CRSE_NBR,
EFF_STATUS,
DESCR
FROM PS_SCHOOL_CRSE_TBL
WHERE ...
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 ...
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
Overview
Content Tools