DROP_PEN_GRD_VW

(SQL View)
 Index Back

Drop with Penalty Grade

This view of the Grade Table contains valid values of Grades for each the Drop with Penalty Grading Basis.

select a.setid, a.grading_scheme, a.effdt, a.grading_basis, a.crse_grade_input, a.descr, a.descrshort, a.grade_convert, a.grade_points, a.earn_credit, a.include_in_gpa, a.in_progress_grd, b.eff_status from PS_GRADE_TBL a, ps_gradescheme_tbl b where a.grade_convert = ' ' and a.setid = b.setid and a.grading_scheme = b.grading_scheme and a.effdt = b.effdt

  • Related Language Record: DROP_PEN_GRD_LV

  • 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
    4 DROP_PEN_GRD_BAS Character(3) VARCHAR2(3) NOT NULL Drop with Penalty Grade Basis
    5 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: GRADE_TBL.DESCR

    8 GRADE_CONVERT Character(3) VARCHAR2(3) NOT NULL Convert To Grade

    Prompt Table: GRADE_TBL

    9 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    10 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: GRADE_BASIS_TBL.INCLUDE_IN_GPA

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

    Y/N Table Edit

    Default Value: N

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