SCCPU_EQUTN_BND

(SQL View)
 Index Back

Bind for STDNT_EQUTN_VAR

This table hosts required fields for STDNT_EQUTN_VAR Population Update.

SELECT DISTINCT A.EMPLID ,B.NAME FROM PS_STDNT_CAR_TERM 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