WM_DATE_MON_LVW

(SQL View)
 Index Back

Date Dimension


SELECT DISTINCT B.LANGUAGE_CD , B.WM_FISCAL_PERIOD , B.WM_FISCAL_QTR FROM PS_WM_DATE_DIM A , PS_WM_DATE_DIM_LG B WHERE A.TRANS_DATE = B.TRANS_DATE

  • Related Language Record for WM_DATE_MON_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 WM_FISCAL_PERIOD Character(20) VARCHAR2(20) NOT NULL Period
    3 WM_FISCAL_QTR Character(20) VARCHAR2(20) NOT NULL Fiscal Quarter