SSR_CRATTAUD_VW

(SQL View)
 Index Back

Course Attribute Audit View

Course Attribute Audit View

SELECT C.CRSE_ID ,C.EFFDT ,C.CRSE_OFFER_NBR ,A.CRSE_ATTR ,A.CRSE_ATTR_VALUE ,AT.DESCR ,AV.DESCR FROM PS_SSR_CAT_AUD_ES C , PS_SSR_ATTR_AUD_ES A , PS_CRSE_ATTR_TBL AT , PS_CRSE_ATTR_VALUE AV WHERE A.CRSE_ID = C.CRSE_ID AND A.EFFDT = C.EFFDT AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND AT.CRSE_ATTR = A.CRSE_ATTR AND AT.EFFDT = ( SELECT MAX(AT2.EFFDT) FROM PS_CRSE_ATTR_TBL AT2 WHERE AT2.CRSE_ATTR = A.CRSE_ATTR AND AT2.EFFDT <= A.EFFDT) AND AT.EFF_STATUS = 'A' AND AV.CRSE_ATTR = A.CRSE_ATTR AND AV.CRSE_ATTR_VALUE = A.CRSE_ATTR_VALUE AND AV.EFFDT = AT.EFFDT

  • Related Language Record: SSR_CRATTAUD_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 CRSE_ATTR Character(4) VARCHAR2(4) NOT NULL Course Attribute
    5 CRSE_ATTR_VALUE Character(10) VARCHAR2(10) NOT NULL Course Attribute Value
    6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    7 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2