FND710 – Donor Class and Status Update Process

This batch process collects and displays information on customer donation statuses. It will list Customer IDs and Name, label them with a status (e.g., New Donor or Renewal Donor), and display how much they have donated in the current year and all past years.

Parameters

Parameter

Description

Required?

Subtitle

The report subtitle as you want it to print as part of the report header.

No

Organization ID

Read-only. Set to the organization ID of the person running the report.

Read-only

Organization Unit ID

Read-only. Sets to the organization ID of the person running the report.

Read-only

Run Mode

Mode in which the report runs:

·       EDIT – does not update the database, but it will produce a report.

·       PROD – updates the database and generates a report.

Yes

Create Report

Whether or not to create the report.

Yes

Advanced Job Parameters

Primary Sort On

Allows you to sort the FND_CUSTOMER/CUSTOMER table based on any field in that table (SQL).

Yes

Filter Criteria

Can be used to limit updates in the database and what is displayed in the final report. Defaults to "1=1".

Yes

Sample Report