LOAN_DLPN_SRCH

(SQL View)
 Index Back

DL Prom Note Search REC

This is the search record for the Master Promissory Note(s) / PLUS notes

SELECT C.OPRCLASS , A.EMPLID , A.DL_PNOTE_ID , B.NAME , C.NATIONAL_ID , C.NATIONAL_ID_MSK , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH FROM PS_LN_DL_PNOTE A , PS_SCC_PRI_NAME_VW B , PS_FA_NID_VW C WHERE B.EMPLID = A.EMPLID AND A.EMPLID = C.EMPLID AND B.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PS_SCC_PRI_NAME_VW X1 WHERE X1.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 DL_PNOTE_ID Character(21) VARCHAR2(21) NOT NULL DL Pnote Unique ID
    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    6 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
    7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    8 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name