LNFEETYPEVW2LNG

(SQL View)
 Index Back

Rellang-Awrd Acti Trnsl Vw

View of the table XLATTABLE used to aid in prompting for valid values based on processing year for Loan Fee Type in the Loan Fee setup panel.

SELECT X.FIELDVALUE ,X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PSXLATITEMLANG X ,PSXLATITEM Y WHERE X.FIELDNAME =Y.FIELDNAME AND X.FIELDVALUE=Y.FIELDVALUE AND X. EFFDT = Y.EFFDT AND X.FIELDNAME = 'LN_FEE_TYPE' AND X.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEMLANG X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND Y.EFF_STATUS <> 'I')

  • Related Language Record for LN_FEE_TYPE_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description