STDNT_RST_SRCH

(SQL View)
 Index Back

Student Rstrctd Aid Eval Srch

STDNT_RST_SRCH is the search record for STDNT_RSTRC_COM. It provides the user with a list box of only students that are on the STDNT_RSTRC_COM table for the year selected. The list box will also provide identifying information from the Personal_Data table.

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.RESTRICTED_AID_ID , A.COMMITTEE_ID , A.EVALUATOR_ID , B.NAME_DISPLAY FROM PS_STDNT_RSTRC_MEM A , PS_SCC_PRI_NAME_VW B WHERE A.EMPLID = B.EMPLID AND B.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SCC_PRI_NAME_VW A1 WHERE A1.EMPLID = B.EMPLID)

  • Parent record: STDNT_RSTRC_AID

    • # 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

    Prompt Table: PEOPLE_SRCH_FA

    7 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country