GRADE_RSTR_TYPE

(SQL Table)
 Index Back

Grade Roster Type

The Grade Roster Type table contains aggregate information specific to a grade roster.

  • Related Language Record: GRADE_RSTR_LANG

  • Parent Record Of GRADE_ROSTER GRADE_RSTR2_VW GRADE_RSTR_VW GRDE_RSTR_FWRK SSR_GRTYP_VW_LN SSR_GR_TYPE_VW SSR_MIDTRM_VW SSR_MLS_EMP_VW SS_GRADE_CHG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term
    2 CLASS_NBR 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 GRADING_STATUS Character(4) VARCHAR2(4) NOT NULL Grading Status
    ERR=Error
    GRD=Grade Input Allowed
    POST=Posted
    RDY=Ready to Post

    Default Value: GRD

    6 GR_APPROVAL_STATUS Character(4) VARCHAR2(4) NOT NULL Approval Status
    APPR=Approved
    NRVW=Not Reviewed
    RDY=Ready for Review

    Default Value: NRVW

    7 APPROVAL_DATE Date(10) DATE Approval Date
    8 POSTING_DATE Date(10) DATE Posting Date
    9 PARTIAL_POST Character(1) VARCHAR2(1) NOT NULL Partial Post

    Y/N Table Edit

    Default Value: N

    10 OVRD_GRADE_ROSTER Character(1) VARCHAR2(1) NOT NULL Override Grade Roster

    Y/N Table Edit

    Default Value: N

    11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description