psxlatitem in peoplesoft
psxlatitem in peoplesoft is a table for store value of translate value of the field. psxlatitem has related language record is PSXLATITEMLANG and parent record is PSXLATDEFN.
You can select a value of translate value by using below code of PeopleCode.
SELECT XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME =’TYPE’ AND FIELDVALUE= ‘1’;
SELECT XLATLONGNAME FROM PSXLATITEMLANG WHERE FIELDNAME =’TYPE’ AND FIELDVALUE= ‘1’;
Using the Translate Table
This section provides an overview of the Translate table and discusses how to:
-
Add values to the Translate table.
-
Change translate values.
-
Delete translate values.
-
Save the Translate table.
Understanding the Translate Table
- Field type is Character.
- Field length is 1 to 4 characters.
- Field values consist of a relatively small, static set of values that are not maintained by the user.
- No other fields relate to this field.
Reference: https://docs.oracle.com/cd/E57990_01/pt853pbh2/eng/pt/tapd/task_UsingtheTranslateTable-077674.html#topofpage