GRADESCHEME_VW

(SQL View)
 Index Back

Grading Scheme Table View

The Grading Scheme Table dieplays the most recent effective dated row for the valid grading options that an institution offers. Used as prompt table in SAP.

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

    • # 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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

    Default Value: GRADESCHEME_TBL.DESCR