GRADESCHEME_V2

(SQL View)
 Index Back

Grading Scheme Table View

This view of the Grading Scheme Table displays the most recent effective dated row for the valid grading options that an institution offers. EFFDT is not a key on this table. Used as prompt table in SAP.

SELECT A.SETID ,A.GRADING_SCHEME ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT FROM PS_GRADESCHEME_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GRADESCHEME_TBL A1 WHERE A1.SETID = A.SETID AND A1.GRADING_SCHEME = A.GRADING_SCHEME AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: GRADESCHEME_V2L

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: GRADESCHEME_TBL.DESCR