TMG_DAY31_RL_VW

(SQL View)
 Index Back

Timing Day Due 1-31 Rl View


SELECT a.tmg_month_due_cd , %Substring(b.fieldvalue,1,2) , b.language_cd , b.xlatlongname , b.xlatshortname FROM ps_tmg_mo_due_vw a , psxlatitemlang b WHERE a.tmg_month_due_cd IN ('01','03','05','07','08','10','12') AND b.fieldname = 'DAYS_OF_MONTH_CD' AND b.fieldvalue <= '31' AND b.effdt = ( SELECT MAX(c.effdt) FROM psxlatitem c WHERE c.fieldname = b.fieldname AND c.fieldvalue = b.fieldvalue AND c.effdt <= %CurrentDateIn AND c.eff_status = 'A') AND b.language_cd <> ( SELECT d.language_cd FROM PSOPTIONS d)

  • Related Language Record for TMG_DAYDUE31_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 TMG_DAY_DUE_CD Character(2) VARCHAR2(2) NOT NULL Day Due
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description