SSR_CRS_ATTR_VW

(SQL View)
 Index Back

Course Attribute View


SELECT A.CRSE_ID , A.EFFDT , A.CRSE_OFFER_NBR , A.INSTITUTION , B.CRSE_ATTR , B.CRSE_ATTR_VALUE , E.SSR_CLSCFG_ATTRVAL , C.DESCR , D.DESCR FROM PS_CRSE_OFFER A , PS_CRSE_ATTRIBUTES B , PS_CRSE_ATTR_TBL C , PS_CRSE_ATTR_VALUE D , PS_SSR_BC_GEN_OPTS E WHERE ( A.CRSE_ID = B.CRSE_ID AND A.EFFDT = B.EFFDT AND B.CRSE_ATTR = C.CRSE_ATTR AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_CRSE_ATTR_TBL C_ED WHERE C.CRSE_ATTR = C_ED.CRSE_ATTR AND C_ED.EFFDT <= %CurrentDateIn) AND B.CRSE_ATTR = D.CRSE_ATTR AND B.CRSE_ATTR_VALUE = D.CRSE_ATTR_VALUE AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_CRSE_ATTR_VALUE D_ED WHERE D.CRSE_ATTR = D_ED.CRSE_ATTR AND D_ED.EFFDT <= %CurrentDateIn))

  • Related Language Record: SSR_CRS_ATTR_VL

    • # 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 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    9 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2