XLATTABLE /PSXLATITEM and PSXLATDEFN

XLATTABLE /PSXLATITEM and PSXLATDEFN – are the PeopleSoft translation tables, XLATTABLE is used to store translate values in PeoleTools versions prior to 8.4x,  while PSXLATDEFN and PSXLATITEM contain the same information for the PT verions 8.4x .PSXLATDEFN stores only the fields that have Xlat values, while PSXLATITEM keeps the Xlat fields and their actual translate value.
For example in order to find out the description of the status a specific process has in the PS environment one should issue the following command:
—PT versions<8.4x :
SELECT PRCSINSTANCE Process_Instance, PRCSJOBNAME Process_Jobname,PRCSTYPE Process_Type,RUNCNTLID Run_Control_Id, XLATLONGNAME RunStatus,OPRID UserId
FROM  PSPRCSRQST A
INNER JOIN XLATTABLE B  ON B.FIELDNAME = ‘RUNSTATUS’ AND B. LANGUAGE_CD = ‘ENG’ AND
FIELDVALUE =  A.RUNSTATUS
WHERE PRCSINSTANCE=’xxxxxx’
—8.4x PT versions:
SELECT PRCSINSTANCE Process_Instance, PRCSJOBNAME Process_Jobname,PRCSTYPE Process_Type,B.XLATLONGNAME Run_Status,P.XLATLONGNAME Distribution_Status,OPRID UserId
FROM  PSPRCSRQST A
INNER JOIN PSXLATITEM B  ON B.FIELDNAME = ‘RUNSTATUS’ AND
B.FIELDVALUE =  A.RUNSTATUS
INNER JOIN PSXLATITEM P  ON P.FIELDNAME = ‘DISTSTATUS’ AND
P.FIELDVALUE =  A.DISTSTATUS
WHERE PRCSINSTANCE=’xxxxxx’
Besides the Run Status and Distribution Status (PT 8.4x) the PS XLAT tables contain useful information regarding descriptions of fields from general ledger, currency management, etc.