SSR_IAM_CALC_VW

(SQL View)
 Index Back

IAM Data

IAM Data

SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_IAM_ATTMPT_FLG , A.SSR_SEQ_NBR7 , A.SSR_ACO_TREE_LVL , A.SSR_ACTIVTY_ID_ORG , A.SSR_ACT_ORG_SQ_NBR , A.SSR_IAM_ACT_STATUS , A.SSR_IAM_LOCK , A.SSR_ACT_ID_ROOT , H.SSR_AC_CONTENT_TP , CASE WHEN B.SSR_CW_OVRD_GRDMAP = 'Y' AND B.SSR_RES_MAP_ID <> ' ' THEN B.SSR_RES_MAP_ID ELSE B2.SSR_RES_MAP_ID END , B.SSR_CW_OVRD_GRDMAP , B.SSR_CW_WEIGHT , B.ASSESSED , B.SSR_INCL_IN_CALC ,C.SSR_NO_MARK_DEF ,C.SSR_CW_NO_MRKTHRES ,C.SSR_CW_NO_MRK_VAL ,C.SSR_PENALTY_TYPE ,D.SSR_MANDATORY_PASS ,E.SSR_RESITS_ALLOWED ,F.SSR_CW_XTRA_CR , G.SSR_RSLT_SEQ , G.SSR_RSLT_TYPE , G.SSR_RSLT_SUB_TYPE , G.SSR_IAM_RSLT_STAT , G.SSR_INCL_IN_CALC , G.SSR_RES_MAP_ID , G.SSR_RES_SCORE_TYPE , G.SSR_IAM_SCORE_CHAR , G.SSR_IAM_SCORE_NUM , G.SSR_IAM_MARK , G.SSR_IAM_GRADE , G.SSR_IAM_OUTCOME , G.SSR_RESITS_ALLOWED , 'N' , G.SCC_ROW_ADD_OPRID , G.SCC_ROW_ADD_DTTM , G.SCC_ROW_UPD_OPRID , G.SCC_ROW_UPD_DTTM , I.SSR_ACM_EXDUE_DT , I.SSR_ACM_DUE_DT , G.SSR_IAMRSL_LASTCAL FROM PS_SSR_IAM A LEFT OUTER JOIN PS_SSR_IAM_ASGNEXT F ON A.EMPLID = F.EMPLID AND A.INSTITUTION = F.INSTITUTION AND A.SSR_ACTIVITY_ID = F.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = F.SSR_ACT_ID_SEQ_NBR LEFT OUTER JOIN PS_SSR_IAMRSLTTPVW G ON A.EMPLID = G.EMPLID AND A.INSTITUTION = G.INSTITUTION AND A.SSR_ACTIVITY_ID = G.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = G.SSR_ACT_ID_SEQ_NBR LEFT OUTER JOIN PS_SSR_IAM_DATEINC I ON A.EMPLID = I.EMPLID AND A.INSTITUTION = I.INSTITUTION AND A.SSR_ACTIVITY_ID = I.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = I.SSR_ACT_ID_SEQ_NBR , PS_SSR_IAM_CONTITM B , PS_SSR_IAM_CONTITM B2 , PS_SSR_IAM_MAININC C , PS_SSR_ACMCONT_ITM D , PS_SSR_ACMMAIN_INC E , PS_SSR_ACTIVITY H WHERE 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 B2.EMPLID = A.EMPLID AND B2.INSTITUTION = A.INSTITUTION AND B2.SSR_ACTIVITY_ID = A.SSR_ACT_ID_ROOT AND B2.SSR_ACT_ID_SEQ_NBR = 1 AND C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND C.SSR_ACT_ID_SEQ_NBR = A.SSR_ACT_ID_SEQ_NBR AND D.INSTITUTION = A.INSTITUTION AND D.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND E.INSTITUTION = A.INSTITUTION AND E.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND H.INSTITUTION = A.INSTITUTION AND H.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID

  • Parent record: SSR_IAM_ROOTEXT

    • # 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_IAM_ATTMPT_FLG Character(1) VARCHAR2(1) NOT NULL Valid Attempt

    Y/N Table Edit

    Default Value: Y

    6 SSR_SEQ_NBR7 Number(7,0) INTEGER NOT NULL Sequence Number
    7 SSR_ACO_TREE_LVL Number(3,0) SMALLINT NOT NULL Level 1 Row
    8 SSR_ACTIVTY_ID_ORG Character(11) VARCHAR2(11) NOT NULL Original Parent Activity ID
    9 SSR_ACT_ORG_SQ_NBR Number(4,0) SMALLINT NOT NULL Original Activity ID Seq NBR

    Default Value: 1

    10 SSR_IAM_ACT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
    A=Assigned
    AC=Assigned - confirmed
    AX=Assigned - requires confirmtn
    D=Dropped
    E=Enrolled
    EC=Enrolled - Confirmed
    ED=Enrolled by Default
    EE=Enrolled
    EX=Enrolled - Confirmation Req'd
    RA=Resit Allowed
    RC=Resit Candidate
    RD=Resit Delete
    RN=Resit Not Allowed
    RR=Reassessed
    RS=Resit Select
    S=Selected
    SC=Selected - confirmed
    SD=Selected by Default
    SR=Selected as Resit
    SX=Selected - requires confirmatn
    WD=Withdrawn
    WL=Waitlisted
    X=Inactive
    11 SSR_IAM_LOCK Character(1) VARCHAR2(1) NOT NULL Locked

    Y/N Table Edit

    Default Value: N

    12 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    13 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type
    14 SSR_RES_MAP_ID_KEY Character(12) VARCHAR2(12) NOT NULL Result Scale
    15 SSR_CW_OVRD_GRDMAP Character(1) VARCHAR2(1) NOT NULL Override Result ID
    16 SSR_CW_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Weighting Multiplier
    17 ASSESSED Character(1) VARCHAR2(1) NOT NULL Assessed
    18 SSR_CONT_INCL_CALC Character(1) VARCHAR2(1) NOT NULL Include in Calculation
    19 SSR_NO_MARK_DEF Character(1) VARCHAR2(1) NOT NULL No Mark Option
    I=Blank Mark - Include
    T=Below Threshold - Exclude
    X=Blank Mark - Exclude
    20 SSR_CW_NO_MRKTHRES Number(8,3) DECIMAL(7,3) NOT NULL Minimum points for an assignment.
    21 SSR_CW_NO_MRK_VAL Number(8,3) DECIMAL(7,3) NOT NULL Minimum points for an assignment.
    22 SSR_PENALTY_TYPE Character(1) VARCHAR2(1) NOT NULL Late Penalty Type
    C=Capped
    D=Daily Penalty
    F=Fixed
    N=No Penalty
    O=One Time
    W=Weekly
    23 SSR_MANDATORY_PASS Character(1) VARCHAR2(1) NOT NULL Mandatory Pass Required
    24 SSR_MAIN_RSTS_ALLW Character(1) VARCHAR2(1) NOT NULL This field indicates if resits are allowed.
    25 SSR_CW_XTRA_CR Character(1) VARCHAR2(1) NOT NULL Extra Credit
    26 SSR_RSLT_SEQ Number(3,0) SMALLINT NOT NULL Result Sequence Nbr

    Default Value: 1

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

    Prompt Table: SSR_IAM_RTYPVW1

    28 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
    29 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

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

    Y/N Table Edit

    Default Value: N

    31 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale
    32 SSR_RES_SCORE_TYPE Character(1) VARCHAR2(1) NOT NULL Score Value Field Type
    C=Character
    N=Numeric
    33 SSR_IAM_SCORE_CHAR Character(8) VARCHAR2(8) NOT NULL Character Score
    34 SSR_IAM_SCORE_NUM Number(19,9) DECIMAL(18,9) NOT NULL Numeric Score
    35 SSR_IAM_MARK Number(19,9) DECIMAL(18,9) NOT NULL Mark
    36 SSR_IAM_GRADE Character(3) VARCHAR2(3) NOT NULL IAM Grade

    Prompt Table: SSR_IAM_GRDVW1

    37 SSR_IAM_OUTCOME Character(1) VARCHAR2(1) NOT NULL Outcome
    A=Audit
    F=Fail
    I=Incomplete
    P=Pass
    W=Withdrawn
    38 SSR_RESITS_ALLOWED Character(1) VARCHAR2(1) NOT NULL This field indicates if resits are allowed.
    39 SSR_PB_CALC Character(1) VARCHAR2(1) NOT NULL Calculate
    40 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    41 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    42 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    43 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    44 SSR_ACM_EXDUE_DT Date(10) DATE Extended Due Date
    45 SSR_ACM_DUE_DT Date(10) DATE Due Date
    46 SSR_IAMRSL_LASTCAL DateTime(26) TIMESTAMP Last Calculate