GRADE_INCOMP_VW

(SQL View)
 Index Back

Incomplete Grade View

This Grade Table view is used as the prompt table for Incomplete Grade in the Academic Program Table. Only In Progress Grades are selected.

select distinct a.setid, a.grading_scheme, a.effdt, a.crse_grade_input, a.descr, a.in_progress_grd, b.eff_status from PS_GRADE_TBL a, ps_gradescheme_tbl b where a.in_progress_grd = 'Y' and a.setid = b.setid and a.grading_scheme = b.grading_scheme and a.effdt = b.effdt

  • Related Language Record: GRADE_INCOMP_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

    Default Value: %date

    4 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 IN_PROGRESS_GRD Character(1) VARCHAR2(1) NOT NULL In Progress Grade

    Y/N Table Edit

    Default Value: N

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