Peoplesoft translate table name. The developer (on the record definition) will sometim...
Peoplesoft translate table name. The developer (on the record definition) will sometimes store the prompt table. These meta tables are integral to the configuration and customization of the PeopleSoft applications, enabling administrators and developers to tailor the system to organizational needs. To translate values from the Translate table in PeopleSoft Application Designer: Change the PeopleSoft Configuration Manager language preference to the target language. Trick #1 A lot of times, the values you are searching for are in a table called Translates (PSXLATITEM). Most of these are delivered by PeopleSoft. Pimpalshende PeopleSoft delivers a a PTLOOKUP service and a REST-based PTLOOKUP_REST service that enables integration partners to retrieve lists of valid/allowable values for prompt and translate (XLAT) fields from PeopleSoft components on which component interfaces are based, allowing them to validate their client application data against PeopleSoft data. Step 2: Create one Work Record include 4 fields so that user can enter values which are not available in the ‘state’ translate field,Work record fields are (one check box,Stateshort name ,Longname and City) Step 3: Now Include All fields from Empl_tbl and Work record fields in to a panel. If you know of any other important tables which are not present in above list, please do share with us in comment section below. The below SQL lets you see what is on the App Designer (without having to log into App Designer). Apr 19, 2007 ยท Subject: RE: [peoplesoft-hr-l] How to get translate values (long descriptions) from translate table in SQR Only way is to insert “stdapi. tjrcbldykucwiwsdljqkoaghakgrdrroilpirwlekgrecgsb