SSR_IAMRSLTTPVW

(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_RSLT_SUB_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 , A.SSR_IAMRSL_LASTCAL , A.SCC_ROW_ADD_OPRID , A.SCC_ROW_ADD_DTTM , 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)

  • 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_RSLT_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Result Sub-Type
    C=Capped
    F=Mandatory Fail
    I=Insufficient Mark
    L=Late Penalty
    M=Multiple Scales
    R=Resit Calculation
    8 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

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

    Y/N Table Edit

    Default Value: N

    10 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale
    11 SSR_RES_SCORE_TYPE Character(1) VARCHAR2(1) NOT NULL Score Value Field Type
    C=Character
    N=Numeric
    12 SSR_IAM_SCORE_CHAR Character(8) VARCHAR2(8) NOT NULL Score
    13 SSR_IAM_SCORE_NUM Number(19,9) DECIMAL(18,9) NOT NULL Score
    14 SSR_IAM_MARK Number(19,9) DECIMAL(18,9) NOT NULL Mark
    15 SSR_IAM_GRADE Character(3) VARCHAR2(3) NOT NULL IAM Grade
    16 SSR_IAM_OUTCOME Character(1) VARCHAR2(1) NOT NULL Result Status
    A=Audit
    F=Fail
    I=Incomplete
    P=Pass
    W=Withdrawn
    17 SSR_RESITS_ALLOWED Character(1) VARCHAR2(1) NOT NULL This field indicates if resits are allowed.
    18 SSR_IAMRSL_LASTCAL DateTime(26) TIMESTAMP Last Calculate
    19 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    20 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    21 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    22 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time