SSR_BCIDX_DT1VL

(SQL View)
 Index Back

Browse Catalog Index Stats

Browse Catalog Index Stats by effective date related language record

SELECT A.CRSE_ID ,A.CRSE_OFFER_NBR ,A.EFFDT ,D.language_cd , D.DESCR , c.xlatlongname , e.descr FROM PS_CRSE_OFFER A , PSXLATITEMlang C ,PS_INSTITUTION_lng D ,PS_SUBJECT_TBL_LNG E WHERE C.FIELDNAME = 'ACAD_CAREER' AND C.FIELDVALUE = A.ACAD_CAREER AND C.LANGUAGE_CD = D.LANGUAGE_CD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PSXLATITEMLANG C1 WHERE C1.FIELDNAME = C.FIELDNAME AND C1.FIELDVALUE = C.FIELDVALUE AND C1.LANGUAGE_CD = C.LANGUAGE_CD AND C1.EFFDT <= %CurrentDateIn) AND D.INSTITUTION = A.INSTITUTION AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_INSTITUTION_LNG D1 WHERE D1.INSTITUTION = D.INSTITUTION AND D1.LANGUAGE_CD = D.LANGUAGE_CD AND D1.EFFDT <= A.EFFDT) AND e.institution = A.INSTITUTION AND e.subject = A.SUBJECT AND E.LANGUAGE_CD = D.LANGUAGE_CD AND E.EFFDT = ( SELECT MAX(E1.EFFDT) FROM PS_SUBJECT_TBL_LNG E1 WHERE E1.INSTITUTION = E.INSTITUTION AND E1.SUBJECT = E.SUBJECT AND E1.LANGUAGE_CD = E.LANGUAGE_CD AND E1.EFFDT <= A.EFFDT)

  • Related Language Record for SSR_BCIDX_DT1VW

    • # 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