SSR_IAM_RSLTVW

(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_RES_MAP_ID , A.SSR_RES_SCORE_TYPE , A.SSR_IAM_SCORE_CHAR , A.SSR_IAM_SCORE_NUM , A.SSR_IAM_MARK , A.SSR_IAM_GRADE , A.SSR_IAM_OUTCOME , A.SSR_RESITS_ALLOWED 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)

  • 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 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_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale
    10 SSR_RES_SCORE_TYPE Character(1) VARCHAR2(1) NOT NULL Score Value Field Type
    C=Character
    N=Numeric
    11 SSR_IAM_SCORE_CHAR Character(8) VARCHAR2(8) NOT NULL Score
    12 SSR_IAM_SCORE_NUM Number(19,9) DECIMAL(18,9) NOT NULL Score
    13 SSR_IAM_MARK Number(19,9) DECIMAL(18,9) NOT NULL Mark
    14 SSR_IAM_GRADE Character(3) VARCHAR2(3) NOT NULL IAM Grade
    15 SSR_IAM_OUTCOME Character(1) VARCHAR2(1) NOT NULL Result Status
    A=Audit
    F=Fail
    I=Incomplete
    P=Pass
    W=Withdrawn
    16 SSR_RESITS_ALLOWED Character(1) VARCHAR2(1) NOT NULL This field indicates if resits are allowed.