CODEWITHSUNDEEP
peoplesoftpeoplecode
Phlegon_of_Tralles
Phlegon_of_Tralles

Reputation: 181

PeopleSoft Query Manager Table Name

I cannot for the life of me figure out the table name that would enable me to see the approval queue.

There is time pending approval in the approval process "TLReportedTime" and I'm looking for a table to build a report so that I can see who the approval is pending with...

Upvotes: 0

Views: 1161

Answers (2)

JL Peyret
JL Peyret

Reputation: 12154

To elaborate on my comment, in the more generic case, rather than @Robin's correct answer, you want to check the HTML input name via Inspect Element in Browser.

Taking a screen I am currently looking at and using right-click Inspect in browser, you get my screenshot.

The field and table names are concatenated and separated with a _ which is perhaps not the best choice as underscores are widely used in names.

TL_RUN_CTRL_GRP and EMPLID are table and field names, respectively.

enter image description here

Take note: depending on specific PeopleSoft page, table names can sometimes be those of in-memory-only work tables, which is going to be of limited use for writing queries.

Upvotes: 1

Robin Debruyne
Robin Debruyne

Reputation: 438

(PS_)EOAW_USERINST is the table that stores the information with who a step's approval is pending with.

Upvotes: 2

Related Questions