RECIPIENT_I_VL

(SQL View)
 Index Back

Individual Recipient View

Individual Recipient View

SELECT A.RECIPIENT_ID ,A.LANGUAGE_CD , A.DESCR FROM PS_RECIPIENT_LNG A , PS_RECIPIENT B WHERE B.RECIPIENT_CATEGORY = 'I' AND A.RECIPIENT_ID=B.RECIPIENT_ID

  • Related Language Record for RECIPIENT_I_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description