PSXITMMNT_VW

index back

Translate Value Items View


SELECT FIELDNAME , FIELDVALUE , EFFDT , EFF_STATUS , XLATLONGNAME , XLATSHORTNAME , LASTUPDDTTM , LASTUPDOPRID , SYNCID FROM PSXLATITEM

  • Related language record: PSXITMMNTLN_VW
  • Parent record: PSXLATDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    DATE_FROM Date(10) DATE Date From

    Default: %date

    EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default: A

    XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19