SSF_STD_LN_VW2

(SQL View)
 Index Back

Run Cntl - ANZ Loan Processing

Run Control for ANZ Student Loan Processing - Programs

SELECT DISTINCT H.EMPLID , P.NAME FROM PS_SSF_STDNT_LNHDR H , PS_SCC_PRI_NAME_VW P WHERE H.EMPLID = P.EMPLID AND P.EFFDT = ( SELECT MAX(P1.EFFDT) FROM PS_SCC_PRI_NAME_VW P1 WHERE P1.EMPLID = P.EMPLID AND P1.EFFDT <= %CurrentDateIn)

  • Parent record: SSF_RUN_LN_ANZ

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

    Prompt Table: SSF_STDNT_LNHDR

    2 NAME Character(50) VARCHAR2(50) NOT NULL Name