SS_FA_AID_SRCH

(SQL View)
 Index Back

FA Self-Service Search Record

SS_FA_AID_SRCH is the search record for FA Self-Service. It lists EMPLIDs from PERSONAL_DATA.

SELECT A.EMPLID , B.OPRID FROM PS_SCC_PRI_NAME_VW A , PSOPRDEFN B WHERE A.EMPLID = B.EMPLID

  • Parent record: STUDENT_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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).