GRADE_BASE_C_VW

(SQL View)
 Index Back

Grading Basis Convert Table

This Grade Basis Table view is used to default Student Enrollment Include In GPA and Audit Grading Basis if the Grading Basis for a given course is converted.

select a.setid, a.grading_scheme, a.effdt, a.grading_basis, a.elect_grade_basis, a.grade_basis_choice, 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_CONV Character(3) VARCHAR2(3) NOT NULL Grading Basis Convert
    5 ELECT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Elective Grading Basis
    6 GRADE_BASIS_CHOICE Character(3) VARCHAR2(3) NOT NULL Grading Basis Choice
    AUD=Audited
    GRD=Graded
    NOG=No Grade Associated
    SUO=S/U Exclusive
    SUS=Satisfactory/Unsatisfactory
    7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive