GRADE_TBL_TR_VL

(SQL View)
 Index Back

Grade Table View

In this Grade Table View, Course Grade Input has been renamed to Course Grade Off to allow Include In GPA, In Progress and Earn Credit in Transfer Credit to default properly.

SELECT a.setid , a.grading_scheme , a.effdt , a.grading_basis , a.crse_grade_input , c.language_cd , c.descr FROM PS_GRADE_TBL a , ps_gradescheme_tbl b , PS_GRADE_TBL_lang c WHERE a.setid = b.setid AND a.grading_scheme = b.grading_scheme AND a.effdt = b.effdt AND a.setid = c.setid AND a.grading_scheme = c.grading_scheme AND a.effdt = c.effdt AND a.grading_basis = c.grading_basis AND a.crse_grade_input = c.crse_grade_input

  • Related Language Record for GRADE_TBL_TR_VW

  • Parent record: GRADE_BASIS_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective 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 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description