Ever had trouble identifying the runstatus in PSPRCSRQST table with what it meant. Run the following SQL to determine what it means.

SELECT C.FIELDVALUE, C.XLATLONGNAME, C.XLATSHORTNAME,C.FIELDNAME,TO_CHAR(C.EFFDT,’YYYY-MM-DD’)

FROM PSXLATITEM C

WHERE C.EFFDT =

(SELECT MAX(C_ED.EFFDT) FROM PSXLATITEM C_ED

WHERE C.FIELDNAME = C_ED.FIELDNAME

AND C.FIELDVALUE = C_ED.FIELDVALUE

AND C_ED.EFFDT <= SYSDATE)

AND C.FIELDNAME = ‘RUNSTATUS’

AND C.EFF_STATUS = ‘A’

Process_mon_run_status

Posted by Nitin Pai
Comments (1)
July 23rd, 2007

Comments (1)

Alencar - February 26th, 2008

Peoplesoft version 8.1 SELECT TO_NUMBER (c.fieldvalue), c.xlatlongname, c.xlatshortname, c.fieldname, TO_CHAR (c.effdt, 'YYYY-MM-DD') FROM xlattable c WHERE c.effdt = (SELECT MAX (c_ed.effdt) FROM xlattable c_ed WHERE c.fieldname = c_ed.fieldname AND c.fieldvalue = c_ed.fieldvalue AND c_ed.effdt <= SYSDATE) AND c.fieldname = 'RUNSTATUS' AND c.eff_status = 'A' AND c.language_cd = 'POR' ORDER BY TO_NUMBER (c.fieldvalue)