GP_FFMT_LANG_VW

(SQL View)
Index Back

RelLang for FLD FMT in XLATtbl

Global Payroll Field Format (Xlat table) Related Language Record

SELECT %Substring(FIELDVALUE, 1, 1) ,LANGUAGE_CD ,EFFDT ,XLATSHORTNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'FLD_FMT'

  • Related Language Record for GP_FIELDFMT1_VW GP_FIELDFMT2_VW GP_FIELDFMT3_VW GP_FIELDFMT4_VW GP_FIELDFMT6_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FLD_FMT Character(1) VARCHAR2(1) NOT NULL Field format for Global Payroll elements
    1=Character
    2=Date
    3=Monetary
    4=Decimal
    5=Element Pointer
    6=Not Applicable
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date
    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name