Summary: Tip of the Week: Creating Pell Queries
Author: CPS - Central Processing System (CPS)
Posted on May 24, 1999
TO: All Destination Points
FROM: CPS Customer Service
RE: Tip of the Week: Creating Pell Queries
This week's tip highlights a functionality in the Pell module of the 1999-2000
EDExpress: Creating Pell Queries.
Pell Query functionality has been added to the 1999-2000 EDExpress with Version
5.2. As you begin using the Pell module to complete processes such as ISIR
import and origination record entry, you may need to define queries to
produce reports on specific Pell students.
As with the other EDExpress modules, Pell Query offers several pre-defined
queries that will be automatically available when you install Version 5.2,
including parameter queries that prompt you for value ranges at the time you
execute the query. You can also define additional queries via
Tools/Query/Pell. You can then select these queries for use when clicking on
the Selection Criteria button for functions like ISIR import or Pell Reports/Origination List.
Some Pell queries you create or use will not work successfully unless you
zero-fill the value field. For example, if you wish to use the pre-defined
parameter EFC range query to import ISIR data only for students with an EFC
between 1000 and 2000, you would need to enter 01000 and 02000 as the EFC
start and end range, respectively, when you execute the query.
Other Pell field values you will need to pad with leading zeroes when
defining or running queries are COA (Cost of Attendance), Secondary EFC,
Award Amount for Entire School Year, Weeks Used to Calculate Payment, Weeks
in Academic Program Year, Credit/Clock Hours Expected to Complete School
Year, and Credit/Clock Hours in Program's Academic Year.
If you do not zero-fill values for these fields, the queries will not work
successfully and you will not get the results you seek.
If you have any questions, please contact CPS Customer Service at
800-330-5947, option 4, or via email at CPS@NCS.COM.