SSR_IAMRTRSLTVW

(SQL View)
 Index Back

IAM Results View by Root

IAM Results View by Root

SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACT_ID_ROOTXRF , 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_IAM_RSLT_OVRBY , A.SSR_IAM_RSLT_OVRDG , A.SSR_RESITS_ALLOWED , A.SSR_Ac_EXTN_CODE , A.SSR_IAM_SUB_DT , A.SSR_IAM_REcALC_REQ , A.SSR_RSLT_RANK , 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

  • Parent record: SSR_IAM_ROOTVW

    • # 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_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    4 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    5 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number

    Default Value: 1

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

    Default Value: 1

    7 SSR_RSLT_TYPE Character(20) VARCHAR2(20) NOT NULL Result Type

    Prompt Table: SSR_IAM_RTYPVW1

    8 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
    9 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: 00

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

    Y/N Table Edit

    Default Value: N

    11 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale

    Prompt Table: SSR_IAM_RESVW1

    12 SSR_RES_SCORE_TYPE Character(1) VARCHAR2(1) NOT NULL Score Value Field Type
    C=Character
    N=Numeric
    13 SSR_IAM_SCORE_CHAR Character(8) VARCHAR2(8) NOT NULL Character Score

    Prompt Table: %EDITTABLE

    14 SSR_IAM_SCORE_NUM Number(19,9) DECIMAL(18,9) NOT NULL Numeric Score
    15 SSR_IAM_MARK Number(19,9) DECIMAL(18,9) NOT NULL Mark
    16 SSR_IAM_GRADE Character(3) VARCHAR2(3) NOT NULL IAM Grade

    Prompt Table: SSR_IAM_GRDVW1

    17 SSR_IAM_OUTCOME Character(1) VARCHAR2(1) NOT NULL Outcome
    A=Audit
    F=Fail
    I=Incomplete
    P=Pass
    W=Withdrawn
    18 SSR_IAM_RSLT_OVRBY Number(3,0) SMALLINT NOT NULL Overriden by
    19 SSR_IAM_RSLT_OVRDG Number(3,0) SMALLINT NOT NULL Overrides Result NBR
    20 SSR_RESITS_ALLOWED Character(1) VARCHAR2(1) NOT NULL This field indicates if resits are allowed.

    Y/N Table Edit

    Default Value: N

    21 SSR_AC_EXTN_CODE Character(12) VARCHAR2(12) NOT NULL Extenuating Circumstances

    Prompt Table: SSR_AC_EXTNDVW1

    22 SSR_IAM_SUB_DT Date(10) DATE Submission Date
    23 SSR_IAM_RECALC_REQ Character(1) VARCHAR2(1) NOT NULL Recalculation Required

    Y/N Table Edit

    Default Value: N

    24 SSR_RSLT_RANK Number(5,0) INTEGER NOT NULL Result Rank
    25 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    26 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    27 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    28 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time