DL_BTCH_PNT_VW

(SQL View)
 Index Back

DL Batch Pnote Search Rec

DL Batch Pnote Search

SELECT C.OPRCLASS , A.DL_PNOTE_ID , A.EMPLID , B.NAME , C.NATIONAL_ID , C.NATIONAL_ID_MSK , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , A.LN_PNOTE_STATUS , A.LN_PNOTE_TYPE FROM PS_LN_DL_PNOTE A , PS_SCC_PRI_NAME_VW B , PS_PERS_NID_MSK_VW C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND B.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SCC_PRI_NAME_VW A1 WHERE A1.EMPLID = B.EMPLID) AND C.NATIONAL_ID_TYPE = 'PR' AND C.COUNTRY = 'USA'

  • Parent record: LOAN_MPN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 DL_PNOTE_ID Character(21) VARCHAR2(21) NOT NULL DL Pnote Unique ID
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    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
    9 LN_PNOTE_STATUS Character(1) VARCHAR2(1) NOT NULL Loan Pnote Status
    A=Accepted
    C=Closed
    E=Endorser
    I=Inactive
    R=Rejected
    X=Pending
    10 LN_PNOTE_TYPE Character(2) VARCHAR2(2) NOT NULL Loan PNOTE Type
    HP=HEALTH PROFESSIONAL
    MM=MPN
    PK=PERKINS
    PP=PNOTE
    UU=UNIVERSITY