Home page for the PeopleSoft - Transfer Rule extractor aka PS 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:
SecurityThe 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 |
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
T-Rex requires SELECT privilege on the following PeopleSoft tables: PS_EXT_ORG_TBL 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: PS_SA_TEST_TBL If necessary, please create database synonyms when the T-Rex database user isn’t the owning schema of the PS database tables. |
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 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 ... |
/** * 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 ... |
/** * 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 ... |
SELECT CRSE_ID, EFFDT, COURSE_TITLE_LONG, DESCR FROM PS_CRSE_CATALOG WHERE ... |
SELECT INSTITUTION, TRNSFR_EQVLNCY_CMP, TRNSFR_SRC_ID, CRSE_ID, EFFDT, COMP_SUBJECT_AREA, CRSE_OFFER_NBR FROM PS_TRNSFR_TO WHERE ... |
SELECT INSTITUTION, TRNSFR_EQVLNCY_CMP, TRNSFR_SRC_ID, CRSE_ID, EFFDT, COMP_SUBJECT_AREA, CRSE_OFFER_NBR FROM PS_TRNSFR_TO_XS WHERE ... |
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 ... |
SELECT CRSE_ID, EFFDT, SUBJECT, CATALOG_NBR, CRSE_OFFER_NBR FROM PS_CRSE_OFFER WHERE ... |
SELECT EXT_ORG_ID, EFFDT, SCHOOL_SUBJECT, SCHOOL_CRSE_NBR, EFF_STATUS, DESCR FROM PS_SCHOOL_CRSE_TBL WHERE ... |
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 ... |
When creating Transferology Transfer Rules from PeopleSoft Transfer Rules, these assumptions are made.