I’ve had this SQL snippet laying around for a while, so, before I lose it, I thought I would post it for future reference. Below is SQL to lookup a XLAT values, in case you don’t want to or cannot go through PeopleSoft Application Designer.
XLAT Lookup SQL
FROM PSXLATITEM XLAT
WHERE XLAT.FIELDNAME = ‘<<FieldName>>’
AND XLAT.EFF_STATUS = ‘A’
AND XLAT.EFFDT = ( SELECT MAX(XLAT1.EFFDT)
FROM PSXLATITEM XLAT1
WHERE XLATFIELDNAME =XLAT1.FIELDNAME
AND XLATFIELDVALUE = XLAT1.FIELDVALUE)
ODER BY XLAT.FIELDVALUE
- PS Query Timestamp to Date Logic
- PS Query Migration Validation SQLs
- How to Verify PeopleSoft Record Build in Oracle
- How to Add User Identification to a PeopleSoft Query?