STDNT_GRADE_HDR

(SQL Table)
 Index Back

Student Grade

Gradebook - Student header for gradebook. Cumulative grades and general data.

  • Parent Record Of LAMGRDNOTEVWLNG LAM_GRADE_NOTE LAM_GRD_NOTE_LN LAM_GRD_NOTE_VW SSR_ASGNOTE_VW SSR_ASGNOTVW_LN SSR_ASGN_NT_LN SSR_ASSIGN_NOTE STDNT_GRADE_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    2 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 MID_TERM_AVG_CURR Number(6,2) DECIMAL(5,2) NOT NULL Current Mid-Term Grade
    5 MID_TERM_GRADE_CAL Character(3) VARCHAR2(3) NOT NULL Mid Term Grade
    6 MID_TERM_GRADE Character(3) VARCHAR2(3) NOT NULL Mid Term Grade

    Prompt Table: SSR_GRDLAM_VW

    7 GRADE_AVG_CURRENT Number(6,2) DECIMAL(5,2) NOT NULL - - Current Grade - -
    8 COURSE_GRADE_CALC Character(3) VARCHAR2(3) NOT NULL Grade
    9 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A

    Prompt Table: SSR_GRDLAM_VW

    10 RQMNT_DESIGNTN_GRD Character(1) VARCHAR2(1) NOT NULL Requirement Designation Grade
    N=Not Satisfied
    S=Satisfied