GRD_BASE_CH2_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 of a course is converted and the converted grading basis is elective.

select a.setid, a.grading_scheme, a.effdt, a.grading_basis, a.grade_basis_choice from PS_GRD_BASE_CHOICE a

  • 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 CRSE_GRD_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)
    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