Pulling Page Labels in Query

Here is the table that table contains the online labels for the pages.

The record that stores this information is PSPNLGROUP. So if you run the following query:

select * 
from PSPNLGROUP 
where PNLGRPNAME = 'JOB_DATA' 

You will see the labels in the ITEMLABEL column. This is what you see when you open the JOB_DATA component in application designer.
One thing that you may not want to see in your queries is the & character used for keyboard shortcuts. To strip these out you can use the REPLACE command in Oracle like so:

select REPLACE(ITEMLABEL, '&', '') as ITEMLABEL 
from PSPNLGROUP 
where PNLGRPNAME = 'JOB_DATA'; 

You will need to create the line REPLACE(ITEMLABEL, '&', '') as ITEMLABEL as an expression in PeopleSoft Query and use it as a field.
By the way pages used to be called panels and components used to be called panel groups which is why the PeopleTools record and field names aren't what you would expect.