GRADE_RSTR_LAM

(SQL View)
 Index Back

Grade Roster - Grade Book View

This view works as the prompt table for the grade roster to update from the grade book.

SELECT STRM ,CLASS_NBR ,GRD_RSTR_TYPE_SEQ ,GRADE_ROSTER_TYPE ,DESCR ,GRADING_STATUS FROM PS_GRADE_RSTR_TYPE WHERE GRADING_STATUS = 'GRD' OR GRADING_STATUS = 'RDY' OR GRADING_STATUS = 'POST'

  • Related Language Record: GRD_RSTR_LAMLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term
    2 CLASS_NBR_WRK Number(5,0) INTEGER NOT NULL Class Nbr
    3 GRD_RSTR_TYPE_SEQ Number(3,0) SMALLINT NOT NULL Grade Roster Type Sequence Nbr
    4 GRADE_ROSTER_TYPE Character(4) VARCHAR2(4) NOT NULL Grade Roster
    FIN=Final Grade
    MID=Mid-Term Grade
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 GRADING_STATUS Character(4) VARCHAR2(4) NOT NULL Grading Status
    ERR=Error
    GRD=Grade Input Allowed
    POST=Posted
    RDY=Ready to Post