GRADE_BASIS_VW1

(SQL View)
Index Back

Grading Basis Table

This table contains the valid values for Grading basis and its corresponding properties.

SELECT a.SETID , a.GRADING_SCHEME , a.EFFDT , 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

  • Related Language Record: GRADE_BASIS_V1L
  • Parent record: GRADESCHEME_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID_CAREER

    Prompt Table: SETID_TBL

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

    Prompt Table: GRADESCHEME_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: GRADE_BASE_D_VW

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

    Y/N Table Edit

    Default Value: N

    10 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

    11 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y