GRADE_BASIS_V2

(SQL View)
 Index Back

Grading Basis View

This view contains the most recent effectitve dated row values for Grading basis and its corresponding properties. EFFDT is not a key on this table. Used as prompot table in SAP.

SELECT A.SETID , A.GRADING_SCHEME , A.GRADING_BASIS , A.DESCRFORMAL , A.INCLUDE_IN_GPA , A.PRINT_ON_XCRIPT , A.GRADING_BASIS_CONV , A.ELECT_GRADE_BASIS , A.GRADE_BASIS_CHOICE , A.PRINT_GRD_DESCR , A.AUDIT_GRADE_BASIS , A.GRADE_REQUIRED FROM PS_GRADE_BASIS_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GRADE_BASIS_TBL A1 WHERE A1.SETID = A.SETID AND A1.GRADING_SCHEME = A.GRADING_SCHEME AND A1.EFFDT <= %CurrentDateIn AND A1.GRADING_BASIS = A.GRADING_BASIS)

  • Related Language Record: GRADE_BASIS_V2L

  • Parent record: GRADESCHEME_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

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

    Prompt Table: GRADESCHEME_TBL

    3 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)
    4 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field
    5 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA

    Y/N Table Edit

    Default Value: Y

    6 PRINT_ON_XCRIPT Character(1) VARCHAR2(1) NOT NULL Print On Transcript

    Y/N Table Edit

    Default Value: Y

    7 GRADING_BASIS_CONV Character(3) VARCHAR2(3) NOT NULL Grading Basis Convert

    Prompt Table: GRADE_BASE_D_VW

    8 ELECT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Elective Grading Basis

    Y/N Table Edit

    Default Value: N

    9 GRADE_BASIS_CHOICE Character(3) VARCHAR2(3) NOT NULL Grading Basis Choice
    AUD=Audited
    GRD=Graded
    NOG=No Grade Associated
    SUO=S/U Exclusive
    SUS=Satisfactory/Unsatisfactory

    Prompt Table: GRD_BASE_CHOICE

    10 PRINT_GRD_DESCR Character(1) VARCHAR2(1) NOT NULL Print Grade Basis Desc
    N=Do not print Grade Basis Descr
    Y=Print Grade Basis Description

    Y/N Table Edit

    Default Value: Y

    11 AUDIT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Audit Grading Basis

    Y/N Table Edit

    Default Value: N

    12 GRADE_REQUIRED Character(1) VARCHAR2(1) NOT NULL Grade Required

    Y/N Table Edit

    Default Value: Y