LNAGGRLENDVWLNG

(SQL View)
 Index Back

RelLng-Loan Aggr Lender Vw

LNORIGTERMVWLNG is the language record view related to LNAGGRLENDVWLNG. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT a.ln_dest_nbr , a.descr ,B.LANGUAGE_CD , b.descr FROM PS_LN_DESTPR_LANG a ,PS_LN_DESTPROF_TBL d , PS_LENDER_LANG b WHERE d.lend_unq_id=b.lend_unq_id AND d.institution=a.institution AND d.AID_YEAR=a.AID_YEAR AND d.LOAN_PROGRAM = a.LOAN_PROGRAM AND d.LN_DEST_NBR =a.LN_DEST_NBR

  • Related Language Record for LN_AGGR_LEND_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LN_DEST_NBR Number(3,0) SMALLINT NOT NULL Loan Destination Num
    2 LN_DEST_DESCR Character(30) VARCHAR2(30) NOT NULL Loan Destination Descr
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description