TMG_MODUE_LG_VW

(SQL View)
 Index Back

Timing Month Due Lg View


SELECT %Substring(a.fieldvalue,1,2) , a.language_cd , a.xlatlongname , a.xlatshortname FROM psxlatitemlang a WHERE a.fieldname = 'MONTHCD' AND a.effdt = ( SELECT MAX(b.effdt) FROM psxlatitem b WHERE b.fieldname = a.fieldname AND b.fieldvalue = a.fieldvalue AND b.effdt <= %CurrentDateIn AND b.eff_status = 'A') AND a.language_cd <> ( SELECT d.language_cd FROM PSOPTIONS d)

  • Related Language Record for TMG_MO_DUE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TMG_MONTH_DUE_CD Character(2) VARCHAR2(2) NOT NULL Month Due
    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