GRADE_TBL_OF_VW

(SQL View)
 Index Back

Grade Table View

In this Grade Table View, Grading Basis and Course Grade Input have been renamed to Grading Basis Enrl and Course Grade Off, respectively, to allow Include In GPA, In Progress and Earn Credit in Student Enrollment to default properly.

select a.setid, a.grading_scheme, a.effdt, a.grading_basis , a.crse_grade_input, a.grade_points, a.earn_credit, a.include_in_gpa, a.in_progress_grd, b.eff_status, a.valid_attempt, a.grade_category, a.exclude_prgrss_unt from PS_GRADE_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: GRADE_BASIS_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
    5 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    6 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    7 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit

    Y/N Table Edit

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

    Y/N Table Edit

    9 IN_PROGRESS_GRD Character(1) VARCHAR2(1) NOT NULL In Progress Grade

    Y/N Table Edit

    10 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    11 VALID_ATTEMPT Character(1) VARCHAR2(1) NOT NULL Valid Attempted Grade
    12 GRADE_CATEGORY Character(4) VARCHAR2(4) NOT NULL The default value of NONE is delivered with the system and should not be deleted.
    TXFR=Transfer Pass (Sample)
    13 EXCLUDE_PRGRSS_UNT Character(1) VARCHAR2(1) NOT NULL Exclude Progress Units