SSR_IAM_ROTVWLN

(SQL View)
 Index Back

Rel Lang for SSR_IAM_RSOTHVW

Rel Lang for SSR_IAM_RSOTHVW

SELECT DISTINCT A.INSTITUTION , A.EMPLID , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_RSLT_TYPE , A.SSR_RSLT_SEQ , EL.LANGUAGE_CD , EL.DESCR FROM PS_SSR_IAM_RESULT A , PS_SSR_IAM B , PS_SSR_ACTIVITY C , PS_SSR_ACT_XREF D , PS_SSR_ACT_XREF DD , PS_CLASS_TBL E , PS_CLASS_TBL_LANG EL , PS_STDNT_ENRL F , PS_STDNT_CAR_TERM G , PS_SSR_IAM_PE_EFF H , PS_ACAD_PROG I , PS_SSR_AC_RSLTMAP J , PS_SSR_RSLT_ITMTYP K , PS_SSR_IAM_APTSQVW L WHERE A.SSR_INCL_IN_CALC = 'Y' AND A.SSR_RSLT_SEQ = ( SELECT MAX(A2.SSR_RSLT_SEQ) FROM PS_SSR_IAM_RESULT A2 WHERE A2.EMPLID = A.EMPLID AND A2.INSTITUTION = A.INSTITUTION AND A2.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND A2.SSR_RSLT_TYPE = A.SSR_RSLT_TYPE) AND A.SSR_RSLT_SEQ NOT IN ( SELECT P.SSR_RSLT_SEQ FROM PS_SSR_IAM_RSLTPST P WHERE P.EMPLID = A.EMPLID AND P.INSTITUTION = A.INSTITUTION AND P.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND P.SSR_ACT_ID_SEQ_NBR = A.SSR_ACT_ID_SEQ_NBR AND P.SSR_RSLT_SEQ = A.SSR_RSLT_SEQ AND (P.SSR_IAM_RSLTPST_ST = 'C' OR P.SSR_IAM_RSLTPST_ST = 'P')) AND B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND B.SSR_ACT_ID_SEQ_NBR = A.SSR_ACT_ID_SEQ_NBR AND C.INSTITUTION = A.INSTITUTION AND C.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND C.SSR_AC_CONTENT_TP <> '1000' AND D.SSR_ACTIVITY_ID = B.SSR_ACT_ID_ROOT AND D.SSR_AC_CONTENT_TP = '1000' AND D.SSR_AC_EXAM_ONLY <> 'Y' AND DD.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND E.CRSE_ID = D.CRSE_ID AND E.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR AND E.STRM = D.STRM AND E.SESSION_CODE = D.SESSION_CODE AND EL.CRSE_ID = E.CRSE_ID AND EL.CRSE_OFFER_NBR = E.CRSE_OFFER_NBR AND EL.STRM = E.STRM AND EL.SESSION_CODE = E.SESSION_CODE AND EL.CLASS_SECTION = E.CLASS_SECTION AND F.EMPLID = A.EMPLID AND F.INSTITUTION = A.INSTITUTION AND F.STRM = D.STRM AND F.CLASS_NBR = E.CLASS_NBR AND F.GRADING_BASIS_ENRL <> 'NON' AND G.EMPLID = A.EMPLID AND G.INSTITUTION = A.INSTITUTION AND G.ACAD_CAREER = F.ACAD_CAREER AND G.STRM = D.STRM AND H.INSTITUTION = A.INSTITUTION AND H.ACAD_CAREER = F.ACAD_CAREER AND H.STRM = D.STRM AND I.EMPLID = A.EMPLID AND I.ACAD_CAREER = F.ACAD_CAREER AND I.EFFDT = ( SELECT MAX(I2.EFFDT) FROM PS_ACAD_PROG I2 WHERE I2.EMPLID = I.EMPLID AND I2.ACAD_CAREER = I.ACAD_CAREER AND I2.STDNT_CAR_NBR = I.STDNT_CAR_NBR AND I2.EFFDT <= H.EFFDT) AND I.EFFSEQ = ( SELECT MAX(I3.EFFSEQ) FROM PS_ACAD_PROG I3 WHERE I3.EMPLID = I.EMPLID AND I3.ACAD_CAREER = I.ACAD_CAREER AND I3.STDNT_CAR_NBR = I.STDNT_CAR_NBR AND I3.EFFDT = I.EFFDT) AND I.SSR_APT_INSTANCE <> 0 AND J.SSR_RSLT_TYPE = A.SSR_RSLT_TYPE AND J.SSR_AC_CONTX_TYPE = C.SSR_AC_CONTX_TYPE AND J.SSR_AC_CONTENT_TP = C.SSR_AC_CONTENT_TP AND J.EFFDT = ( SELECT MAX(J2.EFFDT) FROM PS_SSR_AC_RSLTMAP J2 WHERE J2.SSR_RSLT_TYPE = J.SSR_RSLT_TYPE AND J2.SSR_AC_CONTX_TYPE = J.SSR_AC_CONTX_TYPE AND J2.SSR_AC_CONTENT_TP = J.SSR_AC_CONTENT_TP AND J2.EFFDT <= H.TERM_BEGIN_DT) AND K.SSR_RSLT_TYPE = A.SSR_RSLT_TYPE AND K.SSR_ITEM_TYPE = J.SSR_ITEM_TYPE AND K.SSR_RSLT_PEAM = 'Y' AND K.EFFDT = ( SELECT MAX(K2.EFFDT) FROM PS_SSR_RSLT_ITMTYP K2 WHERE K2.SSR_RSLT_TYPE = K.SSR_RSLT_TYPE AND K2.SSR_ITEM_TYPE = K.SSR_ITEM_TYPE AND K2.EFFDT <= H.TERM_BEGIN_DT) AND L.EMPLID = A.EMPLID AND L.INSTITUTION = A.INSTITUTION AND L.CLASS_NBR = E.CLASS_NBR AND L.SSR_ITEM_TYPE = J.SSR_ITEM_TYPE AND (L.SSR_COMPONENT = DD.SSR_COMPONENT OR L.SSR_COMPONENT IS NULL)

  • Related Language Record for SSR_IAM_RSOTHVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    4 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number
    5 SSR_RSLT_TYPE Character(20) VARCHAR2(20) NOT NULL Result Type
    6 SSR_RSLT_SEQ Number(3,0) SMALLINT NOT NULL Result Sequence Nbr
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description