RB_TD_MSGFLD_VW

(SQL View)
 Index Back

All record fields w/ subrec

This view brings up all the fields for a record, including the fields in the subrecords, if any.

SELECT A.MSGNAME , B.FIELDNAME FROM PSMSGREC A , PSRECFIELD B WHERE A.RECNAME = B.RECNAME AND B.SUBRECORD = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RESPONSE_MSG Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition.
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).