hi can guide with
We need to see if an employee has any pending transactions from a manager of his (like an approval or something,
the manger can be direct/ indirect reports)…and show this on a portal page…the transaction can be a promotion, transfer or any other self service transaction. However, i am not sure if there is any table which stores all pending transactions for employees in peoplesoft.
i did some research on this and found SS_STAT_INDICAtor flag which has this info for at employee level..

Thanks for posting your question

PSWORKLIST will store all the transactions including completed ones and the field INSTSTATUS will decide whether it is worked or not. A value of 0 and 1 in the INSTSTATUS is unworked items, 0 is not opened, 1 is opened but not worked.
If you have not configured Worklist then you need to select the data from all the SS Staging tables that end with STA, for eg Promotion will have HR_PROMOTE_STA, likewise you need to select all the staging tables for all the SS process you use.

Thanks

Senthil Theagarajan

————————————-

Can I Use Digital Signature in SQR report?

Thanks in advance,
Rahul

Thanks for posting your question

Yes see the below example code
print-image office-signature (50, 20)
print-image (50, 20)
type = eps-file
source = ‘sherman.eps’
image-size = (10, 3)

Thanks

Senthil Theagarajan

Posted by Nitin Pai
Comments (0)
April 4th, 2009

Comments (0)