STDNT_RSTRC_RTG

(SQL Table)
 Index Back

Student Restricted Aid Ratings

For each student, this table contains all the rating components for the selected rating scheme, for each member of the committee associated with a particular Restricted Aid ID.

  • Parent record: STDNT_RSTRC_MEM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    4 RESTRICTED_AID_ID Character(10) VARCHAR2(10) NOT NULL Restricted Aid ID

    Prompt Table: RSTRC_AID

    5 COMMITTEE_ID Character(6) VARCHAR2(6) NOT NULL Committee

    Prompt Table: COMMITTEE

    6 EVALUATOR_ID Character(11) VARCHAR2(11) NOT NULL Evaluator ID
    7 RATING_SCHEME Character(10) VARCHAR2(10) NOT NULL Rating Scheme

    Prompt Table: RATING_SCH_TBL

    8 RATING_CMP Character(5) VARCHAR2(5) NOT NULL Rating Component

    Prompt Table: RATING_CMP_TBL

    9 RATING_CMP_TYPE Character(4) VARCHAR2(4) NOT NULL Component Type
    CUML=Cumulative
    INDV=Individual
    10 RATING_VALUE Number(3,0) SMALLINT NOT NULL Rating Value
    11 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description