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 NameField TypeColumn TypeDescription
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    FIELDVALUECharacter(4)VARCHAR2(4) NOT NULLField Value
    DATE_FROMDate(10)DATEDate From

    Default: %date

    EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
    A=Active
    I=Inactive

    Default: A

    XLATLONGNAMECharacter(30)VARCHAR2(30) NOT NULLTranslate Long Name
    XLATSHORTNAMECharacter(10)VARCHAR2(10) NOT NULLTranslate Value Short Name
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    SYNCIDNumber(10,0)DECIMAL(10) NOT NULLThe 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.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19