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

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

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)