SCCPU_PRSCR_BND

(SQL View)
 Index Back

Bind for ADM_PRSPCT_CAR

Bind for Admission Prospect Careere.

SELECT DISTINCT A.EMPLID , B.NAME FROM PS_ADM_PRSPCT_CAR A , PS_SCC_PRI_NAME_VW B WHERE A.EMPLID = B.EMPLID AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_SCC_PRI_NAME_VW X WHERE X.EMPLID = B.EMPLID AND X.EFFDT <= %CurrentDateIn)

  • 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 NAME Character(50) VARCHAR2(50) NOT NULL Name