Setting Up User-Definable Fields

Use PeopleSoft Application Designer to use the delivered fields, as well as to modify them or add new fields to the delivered subrecords.

You can add the fields to the pages and display them in the PeopleSoft Purchasing browser pages, or use them only behind the scenes. You can also populate the fields behind the scenes and then display them on the browser pages.

Note: If you choose to insert new fields into any of the subrecords, you must alter the tables to avoid losing application data that already exists in the tables.

Only those with technical knowledge of PeopleSoft Application Designer and PeopleCode should modify or add to the delivered subrecords.

To compile a list of tables that must be altered by a data base administrator, you can use this sample SQL statement, altering the criteria "A.FIELDNAME =" to reference the subrecord modified. This SQL lists the tables and views for the Header subrecord, PUR_USR_HDR_SBR:

SELECT A.RECNAME, A.FIELDNAME, B.RECTYPE, B.OBJECTOWNERID 
FROM PSRECFIELD A, PSRECDEFN B
WHERE A.RECNAME = B.RECNAME 
AND A.FIELDNAME = 'PUR_USR_HDR_SBR'  
AND B.RECTYPE IN (0, 1, 7) 
ORDER BY B.RECTYPE, A.RECNAME

See the product documentation for PeopleTools: PeopleCode Developer's Guide