Managing Relational-Formatted Documents
This section provides an overview of managing relational-formatted documents and discusses how to:
Map PeopleSoft records to documents.
Map document elements to PeopleSoft record fields.
You can use the Document Builder to map PeopleSoft records and fields to documents. Doing so enables you to populate a rowset with a document.
Use the Document Builder - Relational page (IB_RELATSCHEMA) to map a PeopleSoft record to a document. To access the page, select
and click the Relational tab.When you first access the page, the Relational Details section is collapsed. The Relational Details section is where you select the PeopleSoft record to map to the document. Click the arrow icon next to the Relational Details label to expand the section.
To map a PeopleSoft record to a document:
Access the Document Builder - Relational page (
and click the Relational tab).Expand the Relational Details section.
In the Record field, enter the name of the PeopleSoft record to map to the document or use the Lookup button to select one.
Before you save the record, you should map the record fields to the document elements. If you attempt to save the definition before mapping the document elements to the fields in the record you specified, the system displays an error message. You can save the record without defining all of the field maps and return to the definition at a later time to specify the remaining maps. However, the document will fail validation until you define all maps.
The procedure for mapping elements to record fields is described in the next section.
After you map a PeopleSoft record to a document, you must map the document elements to the record fields.
After you map a record to a document, when you select an element in the document tree, a properties section displays to the right of the document tree, where you can map the element to a record field.
In the properties section, you can enter a field name or use the Lookup button to select from all fields in the record. You also have the option of specifying the field as a key field.
To map document elements to PeopleSoft record fields
In the document tree, click the name of an element.
The relational elements properties section appears on the right side of the page.
In the Field field, enter the name of the field to map to the element, or use the Lookup button to select one.
Select the Key check box if the field to define the field as a key field.
Repeat steps 1 through 3 to map each element in the document tree.
Click the Save button.