SSR_APTAIR_HDVW

(SQL View)
 Index Back

SELECT DISTINCT APT.EMPLID , AIR.INSTITUTION , APT.SSR_APT_INSTANCE , AIR.SSR_ITEM_ID , AIR.SSR_ITEM_TYPE , AIR.DESCR50 FROM PS_SSR_AIR_HDR AIR , PS_SSR_APT_HDR APT , PS_TERM_TBL TERM WHERE TERM.INSTITUTION = APT.INSTITUTION AND TERM.ACAD_CAREER = APT.ACAD_CAREER AND TERM.STRM = APT.REQ_TERM AND AIR.INSTITUTION = APT.INSTITUTION AND AIR.EFFDT = ( SELECT MAX(AIR2.EFFDT) FROM PS_SSR_AIR_HDR AIR2 WHERE AIR2.INSTITUTION = AIR.INSTITUTION AND AIR2.SSR_ITEM_ID = AIR.SSR_ITEM_ID AND AIR2.EFFDT <= TERM.TERM_BEGIN_DT) AND AIR.EFF_STATUS = 'A'

  • Related Language Record: SSR_APTAIR_HVWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number
    4 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID
    5 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type

    Prompt Table: SSR_ITEM_TYPE

    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50