Identifying PeopleSoft toolbar actions used in a component

How can we identify list of PeopleSoft components that have one particular toolbar action (Save, Cancel, Spell Check etc) enabled in it ?

People Tools record PSPNLGROUP has a field TBARBTNS which has this information.But this information is captured in 2^n (2 power of n) logic.


Value Button Name
------ --------------------------
1 save
2 return to list
4 next page in component
8 previous page in component
16 add
32 update/display
64 update/display all
128 correction
256 next in list
512 previous in list
1024 ?
2048 refresh
4096 view worklist
8192 next in worklist
16384 previous in worklist
32768 notify
65536 cancel
131072 spell check

If we have used the buttons save and cancel then TBARBTNS will have the value as 65537 (65536 +1).65537 is the sum of the values specified for ave and Cancel buttons in the above table.

To check whether a component has “notify” tool bar action below is the query.

Select PNLGRPNAME from PSPNLGRPDEFN where bitand (TBARBTNS, 32768) = 32768

Number 32768 will be the toolbar number from the above table. As we have taken “notify” as example it is 32768 in the above query.