SFA_ASG_ORDFSRC

(SQL View)
 Index Back

Grant Eligibility Interf View

Search view for Grant Eligibility Interface.

SELECT DISTINCT b.oprclass , a.emplid , b.last_name_srch , b.first_name_srch FROM PS_STUDENT_AID a , PS_PEOPLE_SRCH b WHERE a.emplid = b.emplid

  • Parent record: STUDENT_AID

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

    Prompt Table: PEOPLE_SRCH

    3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name