TMG_DAYDUE30_VW

(SQL View)
 Index Back

Timing Day Due 1-30 View


SELECT a.tmg_month_due_cd , %Substring(b.fieldvalue,1,2) , b.xlatlongname , b.xlatshortname FROM ps_tmg_mo_due_vw a , PSXLATITEM b WHERE a.tmg_month_due_cd IN ('04','06','09','11') AND b.fieldname = 'DAYS_OF_MONTH_CD' AND b.fieldvalue <= '30' 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')

  • Related Language Record: TMG_DAY30_RL_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description