USRXLATTBLE_LVW

index back

User Optn-Translate Value View


SELECT C.USEROPTN , A.FIELDNAME , A.FIELDVALUE , A.LANGUAGE_CD , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEMLANG A , PSUSEROPTNDEFN B , PSUSEROPTNLANG C WHERE A.FIELDNAME = B.FIELDNAME AND C.OPTN_CATEGORY_LVL = B.OPTN_CATEGORY_LVL AND C.USEROPTN = B.USEROPTN AND A.LANGUAGE_CD = C.LANGUAGE_CD

  • Related language record for USRXLATTABLE_VW
  • Parent record: PSUSEROPTNDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    USEROPTN Character(12) VARCHAR2(12) NOT NULL User Option
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19