GRD_BASE_CH3_VW

(SQL View)
 Index Back

Grade Basis Choice Table View

This Grade Basis Choice view is used as an edit table for Student Enrollment Grading Basis Enrl if the Grading Basis for a given course is elective.

select a.setid, a.grading_scheme, a.effdt, a.grading_basis, a.grade_basis_choice, b.eff_status from PS_GRD_BASE_CHOICE a, ps_gradescheme_tbl b where a.setid = b.setid and a.grading_scheme = b.grading_scheme and a.effdt = b.effdt

  • Parent record: GRADE_BASIS_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

    Prompt Table: GRADE_BASIS_TBL

    5 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

    Prompt Table: GRADE_BASE_E_VW

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