Editing Field Properties

Use the Edit Field Properties page (QRY_FIELDS_SEC) to format the query output; for example, to change column headings or display translate table values in place of codes.

Navigation:

To access the Edit Field Properties page:

1. Select Reporting Tools, and then Query, and then Query Manager.

2. Create a new query or search for an existing one.

3. Select the Fields tab, and then click an appropriate Edit button.

This example illustrates the fields and controls on the Edit Field Properties page. Definitions for the fields and controls appear following the example.

Field or Control	Description
Field Name	The name of the field for which you are editing properties.
Heading	Select a column heading from the following options: No Heading: The column does not have a heading. Text: Select this option and enter the column heading text in the Heading Text box. RFT Short: The column heading is the short name from the record definition. RFT Long: The column heading is the long name from the record definition.
Unique Field Name	Used for translations. There is no need to change the default value, which is the alias for the record followed by the record field name (for example, A.NAME or B.EMPLID).
Aggregate	If you are using aggregate values, select the aggregate function value for this field. An aggregate function is a special type of operator that returns a single value based on multiple rows of data. When your query includes one or more aggregate functions, PeopleSoft Query collects related rows and displays a single row that summarizes their contents. None: query is not using aggregate functions. Sum: Adds the values from each row and displays the total. Count: Counts the number of rows. Min (minimum): Checks the value from each row and returns the lowest one. Max (maximum): Checks the value from each row and returns the highest one. Average: Adds the values from each row and divides the result by the number of rows.