Summary: Tip of the Week: Printing Reports by Pell Disbursement Batch Number
Author: CPS - Central Processing System (CPS)
Posted on November 5, 1999
TO: All Destination Points
FROM: CPS Customer Service
RE: Tip of the Week: Printing Reports by Pell Disbursement Batch
This week's tip features a specific process in the 1999-2000 EDExpress Pell
module: Printing Reports by Pell Disbursement Batch Number
The Pell module of 1999-2000 EDExpress features a parameter query called
"Batch Number," which is available on the selection criteria window for all
Pell reports. However, this parameter query is set up specifically to work
with Pell Origination batch numbers only, and will not work if you are
trying to query on a Pell Disbursement batch number (for a Pell Disbursement
list, for example).
To query on Pell Disbursement Batch Number, you will need to create a new
parameter query. Please follow the steps below:
1) Go to Tools | Query | Pell.
2) Click on Add, then enter a title for your query (we recommend "Pell
Disbursement Batch Number").
3) For Field, choose Disbursement Batch ID.
4) For Operator, choose the equal sign ("=").
5) Leave the Value field blank and mark the checkbox for "Prompt at
6) Click on Append, then click on Save, then click OK.
Once this query is created, you can attach it to a Pell Disbursement List to
restrict the output of the list to records in a designated batch. To do
this, click on the Selection Criteria button on the report print screen,
then click on the ellipses button next to "Query Title" to bring up a list
of available queries. Select the query you created in steps 1-6 above, then
Since this is a parameter query, you will be prompted to enter the Pell
Disbursement batch number you wish to restrict the report output to. If you
are still running Version 5.3, the batch number must be copied (use Control
and C keys) from Tools | Browse | Pell | Batch Activity and then pasted onto
the parameter query entry screen using the Control and V keys.
You will not be able to manually enter a Pell Disbursement batch number on
the parameter query entry screen until you upgrade to Version 5.4, which
will be distributed to all participating destination points by the end of
If you have any questions regarding this message, please contact CPS
Customer Service at 800-330-5947, option 4, or via email at CPS@NCS.COM.