Translate Values Table Name in Peoplesoft

Translate Values Table Name in Peoplesoft

Select translate values data in sql for Translate Values Table Name in Peoplesoft

select * from PSXLATITEM

/*–Translate Value Lanquage –*/

select * from PSXLATITEMLANG

 

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’;