Structure of a Rowset-Based Message
The SQL below will return the structure of your message if it is rowset based (uses PeopleSoft record definitions to define the structure).
select RF.FIELDNAME
from PSRECFIELD RF
where
RF.RECNAME = 'MESSAGE_RECNAME'
and not exists (
select 1
from PSMSGFLDOVR MFO
where MFO.MSGNAME = 'MSGNAME'
and MFO.APMSGVER = 'VERSION_N'
and MFO.RECNAME = RF.RECNAME
and MFO.FIELDNAME = RF.FIELDNAME
and MFO.DONOTPUBLISH = 1
)
order by RF.FIELDNUM;
No Comments