LNORIGTERMVWLNG

(SQL View)
 Index Back

Rel lang Loan Orig Term lanVW

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

SELECT a.emplid , a.institution , a.strm , C.LANGUAGE_CD , b.descr FROM PS_STDNT_FA_TERM a , ps_term_val_tbl b ,ps_term_val_lang c WHERE a.strm=b.strm AND b.strm=c.strm AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_STDNT_FA_TERM B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.STRM = A.STRM AND B.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(B1.EFFSEQ) FROM PS_STDNT_FA_TERM B1 WHERE B1.EMPLID = A.EMPLID AND B1.INSTITUTION = A.INSTITUTION AND B1.AID_YEAR = A.AID_YEAR AND B1.STRM = A.STRM AND B1.EFFDT = A.EFFDT) AND A.EFF_STATUS = 'A'

  • Related Language Record for LN_ORIG_TERM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 STRM Character(4) VARCHAR2(4) NOT NULL Term
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description