GRADE_LAPSE_LV

(SQL View)
 Index Back

Lapse To Grade Rel Lang View

This Grade Table view is used as the prompt table for Lapse To Grade in the Academic Program Table. In Progress Grades are excluded.

SELECT DISTINCT a.setid , a.grading_scheme , a.effdt , a.crse_grade_input , a.language_cd , a.descr FROM PS_GRADE_TBL_LANG a

  • Related Language Record for GRADE_LAPSE_VW

  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description