SSR_IAM_RSLTMAP

(SQL View)
 Index Back

IAM Mapped Result for PE

IAM Mapped Result for PE

SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , B.SSR_RSLT_SEQ , D.EFFDT , B.SSR_RSLT_TYPE , BX.SSR_IAM_RSLTPST_ST , A.SSR_ACT_ID_ROOT , C.SSR_AC_CONTENT_TP , D.SSR_ITEM_TYPE FROM PS_SSR_IAM A , PS_SSR_IAM_RESULT B LEFT OUTER JOIN PS_SSR_IAM_RSLTPST BX ON B.EMPLID = BX.EMPLID AND B.INSTITUTION = BX.INSTITUTION AND B.SSR_ACTIVITY_ID = BX.SSR_ACTIVITY_ID AND B.SSR_ACT_ID_SEQ_NBR = BX.SSR_ACT_ID_SEQ_NBR AND B.SSR_RSLT_SEQ = BX.SSR_RSLT_SEQ AND BX.SSR_IAM_RSLTPST_TP = 'P' , PS_SSR_ACTIVITY C , PS_SSR_AC_RSLTMAP D WHERE A.SSR_ACT_ID_SEQ_NBR = ( SELECT MAX(A2.SSR_ACT_ID_SEQ_NBR) FROM PS_SSR_IAM A2 WHERE A2.EMPLID = A.EMPLID AND A2.INSTITUTION = A.INSTITUTION AND A2.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID) 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 B.SSR_RSLT_SEQ = ( SELECT MAX(B2.SSR_RSLT_SEQ) FROM PS_SSR_IAM_RESULT B2 WHERE B2.EMPLID = B.EMPLID AND B2.INSTITUTION = B.INSTITUTION AND B2.SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID AND B2.SSR_ACT_ID_SEQ_NBR = B.SSR_ACT_ID_SEQ_NBR AND B2.SSR_RSLT_TYPE = B.SSR_RSLT_TYPE) AND B.SSR_IAM_RSLT_STAT <> '00' AND B.SSR_INCL_IN_CALC = 'Y' AND C.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND C.INSTITUTION = A.INSTITUTION AND D.SSR_RSLT_TYPE = B.SSR_RSLT_TYPE AND D.SSR_AC_CONTX_TYPE = C.SSR_AC_CONTX_TYPE AND D.SSR_AC_CONTENT_TP = C.SSR_AC_CONTENT_TP

  • Parent record: SSR_IAM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    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

    Default Value: 1

    5 SSR_RSLT_SEQ Number(3,0) SMALLINT NOT NULL Result Sequence Nbr

    Default Value: 1

    6 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    7 SSR_RSLT_TYPE Character(20) VARCHAR2(20) NOT NULL Result Type
    8 SSR_IAM_RSLTPST_ST Character(1) VARCHAR2(1) NOT NULL Student Enrollment Post Status
    C=Grade Changed
    E=Error
    K=Rejected
    L=Locked APT
    N=Not Applicable
    P=Posted
    U=Updated
    X=Pending
    Z=Not Paired
    9 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    10 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type
    11 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type