SSR_BCIDX_DTLVL

(SQL View)
 Index Back

Browse Catalog Index Stats

Browse Catalog Index Stats by effective date related language

SELECT A.CRSE_ID ,A.CRSE_OFFER_NBR ,A.EFFDT ,B.LANGUAGE_CD ,B.SSR_DESCR30_1 ,B.SSR_DESCR30_2 ,B.SSR_DESCR30_3 FROM PS_SSR_CRS_OFFR_ES A LEFT OUTER JOIN PS_SSR_BCIDX_DT1VL B ON B.CRSE_ID = A.CRSE_ID AND B.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR AND B.EFFDT = A.EFFDT , PS_CRSE_CATLG_LNG A1 WHERE A1.CRSE_ID = A.CRSE_ID AND a.effdt = A1.EFFDT

  • Related Language Record for SSR_BCIDX_DTLVW SSR_BCIDX_FULVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 SSR_DESCR30_1 Character(30) VARCHAR2(30) NOT NULL Show Detail View
    6 SSR_DESCR30_2 Character(30) VARCHAR2(30) NOT NULL Show Detail View
    7 SSR_DESCR30_3 Character(30) VARCHAR2(30) NOT NULL Show Detail View