Running PeopleTools Cross-Reference Reports

Appendix: Running PeopleTools Cross-Reference Reports

This chapter provides an overview of cross-reference reports and discusses how to run a sample Crystal report.

Understanding Cross-Reference Reports

By using PeopleTools, you can create new applications by defining menus and pages that you use to enter data and database tables. PeopleTools includes a variety of cross-reference reports (similar to blueprints) that guide you through the definitions (such as menus, pages, and records) that are delivered with the system and those that you create or adapt with PeopleTools.

PeopleTools cross-reference reports are predefined Crystal reports, not unlike the standard reports that are delivered with the PeopleSoft application. Like other standard reports, you can identify cross-reference reports by the three-character prefix XRF. The reports provide several views of the application, ranging from high-level lists of the windows, menus, and pages to the detailed database attributes of fields.

You should already be familiar with the types of definitions that are delivered with the PeopleSoft application, as well as with PeopleTools and relational databases.

The cross-reference reports include:

Report	ID	Description
Fields and Pages	XRFFLPN	Lists all fields in alphabetical order. It includes the names of all record and page definitions in which the fields occur and lists the field long names.
Fields and Records	XRFRCFL	Lists all fields in alphabetical order by the associated record definition name. It details the field long name, type, length, and formatting.
Records and Fields	XRFFLRC	Lists all fields in alphabetical order. It includes the field long name, type, length, and formatting, as well as the names of all record definitions that contain the field.
Applications and Fields	XRFAPFL	Lists all menus, such as general tables, in alphabetical order, including the fields in each menu. For each field, it lists the field name, type, length, and format, as well as all record and page definitions that contain the field (in the window).
Fields Referenced by PeopleCode Programs	XRFFLPC	Lists all PeopleCode programs in alphabetical order by the associated record definition and field. It includes the types of fields that are referenced in the PeopleCode program.
Field Listing	XRFIELDS	Lists all fields in alphabetical order. It includes field type, length, format, long name, and short name.
Menu Listing	XRFMENU	Lists all menus in alphabetical order, including all page definitions in each menu. It includes the associated search record definition name and detail page definition name.
Page Listing	XRFPAGE	Lists all page definitions in alphabetical order.
PeopleCode Programs and Field References	XRFPCFL	Lists record definitions that contain fields with PeopleCode program attributes. It includes the field name, as well as the associated record definitions and fields that are referenced in the PeopleCode program.
Pages with PeopleCode	XRFPNPC	Lists all pages that contain fields with PeopleCode attributes. For each page, it includes the name of the record definitions that contain the field, as well as the field name and type
Records and Pages	XRFRCPN	Lists all record definitions in alphabetical order. It includes the menu and page definitions that are associated with each record definition.
Window Listing	XRFWIN	Lists all application menu windows in alphabetical order.

Note. In addition to standard cross-reference reports, if you are familiar with the PeopleSoft database, you can generate additional ad hoc reports to extract the exact combination of information that you need.

Running a Crystal Report

Run cross-reference reports on the Process Scheduler Request page.

The following example explains how to generate the Field Cross Reference (XRFIELDS) report.

To create a Field Cross Reference report:

Select PeopleTools, Process Scheduler , System Process Requests.

The Sample Processes search page appears.
Click Add a New Value.
Enter CrystalClient for the run control ID.
Click Add.
Click Run.

The Process Scheduler Request page appears.
Select the Field Cross Reference, XRFIELDS, and Crystal by clicking the Select check box next to each of these values in the Process List grid.
Click OK to generate a formatted display of this Crystal report in HTML.