SSR_IAM_ACRT2VL

(SQL View)
 Index Back

Rel Lang for SSR_IAM_ACRT2VW

Rel Lang for SSR_IAM_ACRT2VW

SELECT DISTINCT A.EMPLID , A.INSTITUTION , A.SSR_ACTIVITY_ID , B.STRM , B.SSR_PERIOD_ID , L.LANGUAGE_CD , L.DESCR FROM PS_SSR_IAM_ROOTEXT A ,PS_SSR_ACT_XREF B ,PS_CRSE_OFFER C ,PS_TERM_TBL D ,PS_CRSE_CATLG_LNG L WHERE B.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND L.CRSE_ID = B.CRSE_ID AND C.CRSE_ID = B.CRSE_ID AND C.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND C.CRSE_ID = L.CRSE_ID AND C.INSTITUTION = D.INSTITUTION AND C.ACAD_CAREER = D.ACAD_CAREER AND D.STRM = B.STRM AND B.SSR_AC_EXAM_ONLY <> 'Y' AND L.EFFDT = ( SELECT MAX(L1.EFFDT) FROM PS_CRSE_CATALOG L1 WHERE L.CRSE_ID = L1.CRSE_ID AND L1.EFFDT <= D.TERM_BEGIN_DT) AND L.EFFDT = C.EFFDT UNION SELECT DISTINCT A.EMPLID , A.INSTITUTION , A.SSR_ACTIVITY_ID , B.STRM , B.SSR_PERIOD_ID , L.LANGUAGE_CD , L.DESCR FROM PS_SSR_IAM_ROOTEXT A ,PS_SSR_ACT_XREF B ,PS_CRSE_OFFER C ,PS_SSR_PERIOD_TBL D ,PS_CRSE_CATLG_LNG L WHERE B.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND L.CRSE_ID = B.CRSE_ID AND C.CRSE_ID = B.CRSE_ID AND C.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND C.CRSE_ID = L.CRSE_ID AND C.INSTITUTION = D.INSTITUTION AND D.SSR_PERIOD_ID = B.SSR_PERIOD_ID AND B.SSR_AC_EXAM_ONLY = 'Y' AND L.EFFDT = ( SELECT MAX(L1.EFFDT) FROM PS_CRSE_CATALOG L1 WHERE L.CRSE_ID = L1.CRSE_ID AND L1.EFFDT <= D.SSR_PRD_START_DT) AND L.EFFDT = C.EFFDT

  • Related Language Record for SSR_IAM_ACRT2VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID

    Prompt Table: SSR_IAM_ACROTVW

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    5 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID

    Prompt Table: SSR_EXAM_PRDVW2

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description