SSR_DEEWR_ADTVW

(SQL View)
 Index Back

Admit term view

Dynamic view to display admit terms used in the process

SELECT DISTINCT D.INSTITUTION , D.SSR_REF_YEAR , A.STRM , A.DESCR FROM PS_TERM_TBL A , PS_SSR_DEEWR_ADTRM D WHERE A.INSTITUTION = D.INSTITUTION AND A.STRM = D.ADMIT_TERM

  • Related Language Record: SSR_DEEWR_ATLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SSR_REF_YEAR Character(4) VARCHAR2(4) NOT NULL Australia DEST Processing
    3 STRM Character(4) VARCHAR2(4) NOT NULL Term
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description