SSR_IAM_RSLMXVW

(SQL View)
 Index Back

IAM Results


SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_RSLT_SEQ , A.SSR_RSLT_TYPE , A.SSR_IAM_RSLT_STAT , A.SSR_INCL_IN_CALC , A.SSR_IAM_RECALC_REQ , A.SCC_ROW_UPD_OPRID , A.SCC_ROW_UPD_DTTM FROM PS_SSR_IAM_RESULT A WHERE 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_ACT_ID_SEQ_NBR = A.SSR_ACT_ID_SEQ_NBR AND A2.SSR_RSLT_TYPE = A.SSR_RSLT_TYPE AND A2.SSR_IAM_RSLT_STAT <> '00' AND A2.SSR_INCL_IN_CALC = 'Y')

  • 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
    5 SSR_RSLT_SEQ Number(3,0) SMALLINT NOT NULL Result Sequence Nbr
    6 SSR_RSLT_TYPE Character(20) VARCHAR2(20) NOT NULL Result Type
    7 SSR_IAM_RSLT_STAT Character(2) VARCHAR2(2) NOT NULL Result Status
    00=00-Undetermined
    05=05-Manual
    07=07-Imported
    10=10-Calculated
    20=20-Awaiting Approval
    30=30-Approved
    40=40-Overridden
    50=50-Final

    Default Value: 10

    8 SSR_INCL_IN_CALC Character(1) VARCHAR2(1) NOT NULL Include in Calculation

    Y/N Table Edit

    Default Value: N

    9 SSR_IAM_RECALC_REQ Character(1) VARCHAR2(1) NOT NULL Recalculation Required

    Y/N Table Edit

    Default Value: N

    10 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    11 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time