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 42

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

Saved on

compared with

New Version 43

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

Saved on

Key

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

...

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

...