GRADE_BASIS_VW

(SQL View)
 Index Back

Grading Basis Table

This Grading Basis Table view allows the defaults for Student Enrollment Audit Grading Basis and Include In GPA to be based on the actual Grading Basis Enrollment value chosen.

SELECT A.SETID , A.GRADING_SCHEME , A.EFFDT , A.GRADING_BASIS , A.AUDIT_GRADE_BASIS , A.INCLUDE_IN_GPA , A.GRADING_BASIS_CONV , A.GRADE_REQUIRED , B.EFF_STATUS FROM PS_GRADE_BASIS_TBL A , PS_GRADESCHEME_TBL B WHERE A.SETID = B.SETID AND A.GRADING_SCHEME = B.GRADING_SCHEME AND A.EFFDT = B.EFFDT

  • 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_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
    5 AUDIT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Audit Grading Basis

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    7 GRADING_BASIS_CONV Character(3) VARCHAR2(3) NOT NULL Grading Basis Convert
    8 GRADE_REQUIRED Character(1) VARCHAR2(1) NOT NULL Grade Required
    9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive