Note: Technical Talk being moved to:
www.nazimcricket.com/wiki


Wednesday, 16 July 2008

PeopleSoft Status Lookups

Some useful queries joining the PSXLATITEM table to look up Process Monitor:

Run Status:

SELECT XLATSHORTNAME
     , FIELDVALUE
  FROM PSXLATITEM
 WHERE FIELDNAME='RUNSTATUS'
ORDER BY TO_CHAR(FIELDVALUE,'00');
Distribution Status:
SELECT XLATSHORTNAME
     , FIELDVALUE
  FROM PSXLATITEM
 WHERE FIELDNAME='DISTSTATUS'
ORDER BY TO_CHAR(FIELDVALUE,'00');
Output Destination Type:
SELECT XLATLONGNAME
     , FIELDVALUE
  FROM PSXLATITEM
 WHERE FIELDNAME='OUTDESTTYPE'
ORDER BY TO_CHAR(FIELDVALUE,'00');
Output Destination Format:
SELECT XLATLONGNAME
     , FIELDVALUE
  FROM PSXLATITEM
 WHERE FIELDNAME='OUTDESTFORMAT'
ORDER BY TO_CHAR(FIELDVALUE,'00');

No comments: