SSR_SRCHCRSE_VL

(SQL View)
 Index Back

Adv SRch Subjects Rel Lang

List of Subjects for Fluid SR Browse Catalog Advanced Search. Related Language record.

SELECT A.INSTITUTION , A.SUBJECT , BL.LANGUAGE_CD , BL.DESCRFORMAL FROM PS_CRSE_OFFER A , PS_SUBJECT_TBL_LNG BL , PS_CRSE_CATALOG C WHERE ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_CRSE_OFFER A_ED WHERE A.CRSE_ID = A_ED.CRSE_ID AND A_ED.EFFDT <= %CurrentDateIn) AND BL.INSTITUTION = A.INSTITUTION AND BL.SUBJECT = A.SUBJECT AND BL.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_SUBJECT_TBL_LNG B_ED WHERE BL.INSTITUTION = B_ED.INSTITUTION AND BL.SUBJECT = B_ED.SUBJECT AND BL.LANGUAGE_CD = B_ED.LANGUAGE_CD AND B_ED.EFFDT <= %CurrentDateIn) AND A.CRSE_ID = C.CRSE_ID AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_CRSE_CATALOG C_ED WHERE C.CRSE_ID = C_ED.CRSE_ID AND C_ED.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A')

  • Related Language Record for SSR_SRCHCRSE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field