SSR_CRS_ATTR_VL

(SQL View)
 Index Back

Course Attribute Rel Lang

Course Attribute Related Language Record

SELECT A.CRSE_ID , A.EFFDT , A.CRSE_OFFER_NBR , A.INSTITUTION , B.CRSE_ATTR , B.CRSE_ATTR_VALUE , C.SSR_CLSCFG_ATTRVAL , DL.LANGUAGE_CD , DL.DESCR , EL.DESCR FROM PS_CRSE_OFFER A , PS_CRSE_ATTRIBUTES B , PS_SSR_BC_GEN_OPTS C , PS_CRSE_ATTR_LANG DL , PS_CRSE_ATR_VL_LNG EL 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 A.CRSE_ID = B.CRSE_ID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_CRSE_ATTRIBUTES B_ED WHERE B.CRSE_ID = B_ED.CRSE_ID AND B_ED.EFFDT <= %CurrentDateIn) AND B.CRSE_ATTR = DL.CRSE_ATTR AND DL.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_CRSE_ATTR_LANG D_ED WHERE DL.CRSE_ATTR = D_ED.CRSE_ATTR AND DL.LANGUAGE_CD = D_ED.LANGUAGE_CD AND D_ED.EFFDT <= %CurrentDateIn) AND B.CRSE_ATTR = EL.CRSE_ATTR AND B.CRSE_ATTR_VALUE = EL.CRSE_ATTR_VALUE AND EL.EFFDT = ( SELECT MAX(E_ED.EFFDT) FROM PS_CRSE_ATR_VL_LNG E_ED WHERE EL.CRSE_ATTR = E_ED.CRSE_ATTR AND E_ED.EFFDT <= %CurrentDateIn))

  • Related Language Record for SSR_CRS_ATTR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    5 CRSE_ATTR Character(4) VARCHAR2(4) NOT NULL Course Attribute
    6 CRSE_ATTR_VALUE Character(10) VARCHAR2(10) NOT NULL Course Attribute Value
    7 SSR_CLSCFG_ATTRVAL Character(1) VARCHAR2(1) NOT NULL Course Attribute Value
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    10 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2