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

Versions Compared

Old Version 41

changes.mady.by.user Unknown User (podnardb)

Saved on

compared with

New Version 42

changes.mady.by.user Unknown User (podnardb)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
titlePeopleSoft 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

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


Code Block
languagesql
titlePS_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
languagesql
titlePS_EXT_ORG_TBL, PS_EXT_ORG_TBL_ADM
/**
 * Where clause specifies: MAX(PS_EXT_ORG_TBL.EFFDT)
 */
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 ...

...

Code Block
languagesql
titlePS_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 ...

...