SSR_IAM_MPGRDVW

(SQL View)
 Index Back

Scale & Grade View

Scale & Grade View

SELECT DISTINCT A.SETID ,A.SSR_RES_MAP_ID ,A.EFFDT ,A.GRADING_SCHEME ,A.GRADING_BASIS ,A.SEQUENCE_NO ,A.SSR_CW_SCORE ,A.SSR_RES_SCORE_NUM ,A.SSR_CW_MARK ,A.CRSE_GRADE_INPUT ,A.SSR_RESULTS_STATUS ,A.SSR_RES_MARK_EXC ,B.DESCR ,A.SSR_AC_DEFAULT ,A.SSR_RESITS_ALLOWED ,A.SSR_AC_MAND_FAIL ,A.DESCR FROM PS_SSR_RES_MAP_DTL A , PS_GRADE_TBL B WHERE A.CRSE_GRADE_INPUT <> ' ' AND A.SETID = B.SETID AND A.GRADING_SCHEME = B.GRADING_SCHEME AND A.GRADING_BASIS = B.GRADING_BASIS AND A.CRSE_GRADE_INPUT = B.CRSE_GRADE_INPUT AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_GRADE_TBL B2 WHERE B2.SETID = A.SETID AND B2.GRADING_SCHEME = A.GRADING_SCHEME AND B2.GRADING_BASIS = A.GRADING_BASIS AND B2.CRSE_GRADE_INPUT = A.CRSE_GRADE_INPUT AND B2.EFFDT <= A.EFFDT) UNION SELECT DISTINCT A.SETID ,A.SSR_RES_MAP_ID ,A.EFFDT ,A.GRADING_SCHEME ,A.GRADING_BASIS ,A.SEQUENCE_NO ,A.SSR_CW_SCORE ,A.SSR_RES_SCORE_NUM ,A.SSR_CW_MARK ,A.CRSE_GRADE_INPUT ,A.SSR_RESULTS_STATUS ,A.SSR_RES_MARK_EXC ,' ' ,A.SSR_AC_DEFAULT ,A.SSR_RESITS_ALLOWED ,A.SSR_AC_MAND_FAIL ,A.DESCR FROM PS_SSR_RES_MAP_DTL A WHERE A.CRSE_GRADE_INPUT = ' '

  • Related Language Record: SSR_IAM_MPGRVWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    5 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)
    6 SEQUENCE_NO Number(3,0) SMALLINT NOT NULL Sequence #
    7 SSR_CW_SCORE Character(8) VARCHAR2(8) NOT NULL Score
    8 SSR_RES_SCORE_NUM Number(19,9) DECIMAL(18,9) NOT NULL Score
    9 SSR_CW_MARK Number(19,9) DECIMAL(18,9) NOT NULL Mark
    10 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    11 SSR_RESULTS_STATUS Character(1) VARCHAR2(1) NOT NULL Result Status
    A=Audit
    F=Fail
    I=Incomplete
    P=Pass
    W=Withdrawn
    12 SSR_RES_MARK_EXC Character(1) VARCHAR2(1) NOT NULL Exclude Mark

    Y/N Table Edit

    Default Value: N

    13 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
    14 SSR_AC_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Mark

    Y/N Table Edit

    Default Value: N

    15 SSR_RESITS_ALLOWED Character(1) VARCHAR2(1) NOT NULL This field indicates if resits are allowed.

    Y/N Table Edit

    Default Value: N

    16 SSR_AC_MAND_FAIL Character(1) VARCHAR2(1) NOT NULL Use for Mandatory Fail

    Y/N Table Edit

    Default Value: N

    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description