Quick Links

FOAPAL Reports

Instructions for logging in to reports and exporting data is available on the Running Web & Crystal Reports page.
Crystal Reports software is not required to run the web report templates.

Submit a Report Request Form to modify an existing report or to request the creation of a new report.


FOAPAL Report Templates

Fund Information WEB Report

Fund_Information CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays all non financial information relating to a Fund. You can only query one Fund at a time. Use the Organization Fund Information or Organization Grant Information Reports to retrieve all Funds/Grants within a Org.

Report Help:
Fund Information [.pdf]

Prompting Query Fields:
- Fund code

View Information [for Crystal Report]
View: FG.Statement.Heading
View Help: Statement Heading [.pdf]

Organization Fund Information WEB Report

Organization Fund Information CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays all non-financial information for all funds (including Grants) within an Organization code. Any Fund with the same default Org code will be displayed.

Report Help:
Organization Fund Information [.pdf]

Prompting Query Fields:
- Org Code

View Information [for Crystal Report]
View: FG.Statement.Heading
View Help: Statement Heading [.pdf]

FOAPAL Verification WEB Report

FOAPAL Verification CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Designed as a look up report for FOAPAL code validation. Will display all matches for the code entered for any part of the FOAPAL string. Ideal for use by service departments that generate feed files to Financial Services.

Report Help:
FOAPAL Code Verification [.pdf]

Prompting Query Fields:
- FOAPAL code

View Information [for Crystal Report]
View: FG.Foapal.Code.Translation
View Help: FOAPAL Code Translation [.pdf]

Fund Listing by Department Org Code WEB Report

Fund_Listing_by_Department_Org_Code CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Lists all funds (including funds linked to Grants) under a specific Department Organization Code. Grouped by Fund Financial Manager’s McGill ID.

Report Help:
Fund Listing by Department Organization [.pdf]

Prompting Query Fields:
- Dept. Org code

View Information [for Crystal Report]
View: FG.Fund.Profile
View Help: Fund Profile [.pdf]