GRADE_TBL_IN_VW

(SQL View)
 Index Back

Grade Table View

In this Grade Table View, Grading Basis and Course Grade Input have been renamed to Grading Basis Enrl and Course Grade Off, respectively, to allow Include In GPA, In Progress and Earn Credit in Student Enrollment to default properly. This view selectd the most recent effective dated row. Effdt is not a key on this view. Used as prompt table in SAP.

SELECT A.SETID , A.GRADING_SCHEME , A.GRADING_BASIS , A.CRSE_GRADE_INPUT , A.DESCR , A.DESCRSHORT , A.GRADE_POINTS , A.EARN_CREDIT , A.INCLUDE_IN_GPA , A.IN_PROGRESS_GRD , A.VALID_ATTEMPT , A.GRADE_CATEGORY , A.EXCLUDE_PRGRSS_UNT FROM PS_GRADE_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GRADE_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 AND A1.CRSE_GRADE_INPUT = A.CRSE_GRADE_INPUT )

  • Related Language Record: GRADE_TBL_IN_VL

  • 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 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 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A

    Prompt Table: GRADE_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    8 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit

    Y/N Table Edit

    9 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA

    Y/N Table Edit

    10 IN_PROGRESS_GRD Character(1) VARCHAR2(1) NOT NULL In Progress Grade

    Y/N Table Edit

    11 VALID_ATTEMPT Character(1) VARCHAR2(1) NOT NULL Valid Attempted Grade
    12 GRADE_CATEGORY Character(4) VARCHAR2(4) NOT NULL The default value of NONE is delivered with the system and should not be deleted.
    TXFR=Transfer Pass (Sample)
    13 EXCLUDE_PRGRSS_UNT Character(1) VARCHAR2(1) NOT NULL Exclude Progress Units