Login Instructions
To access a Web Report Templates, click a template link. You will be prompted to:
1) Enter your McGill Username (first.last [at] mcgill.ca) and McGill Password;
2) Below the McGill Password field, Select LDAP in the Authentication ;
3) Click Log On.
The report will load and you will be prompted to enter your data warehouse (Banner) username and password.
An IT Service Description for the new Web reports server is now available on the IT Knowledge Base: Article 3283
Daily Operational Reports
| Report Title | Required System Access | Additional Information |
|---|---|---|
| Loan_Fund_Balances | BSA Data Warehouse and FIS Data Warehouse |
Parameters - Aid Year You must have access to Loan Funds in Finance (FIS) |
| Loan Recipients | BSA Data Warehouse |
Parameters - Ackable, Recipient after Aid Year, Recipients before Aid Year, Lowest Fund, Highest Fund |
| Outstanding_Loan_Offers | BSA Data Warehouse |
Parameters - Aid Year |
| Out_of_Province_Govt_Aid Recipients by Jurisdiction | Student Funding Repository and Student Records Data Warehouse |
Parameters - Province, Earlier Term Code and Later Term Code |
| Student ID Listing in QA (to be refreshed by SSAO systems stff) | BSA QA Data Warehouse |
Parameters - there are no parameters. This report will bring in current term data only You must have access to BSA & QA data warehouse
|
| US Loan Payments by Aid Year | BSA Data Warehouse |
Parameters - Aid Year |
| US Loan SAP Monitoring | BSA Data Warehouse and Student Records Data Warehouse |
Parameters - Aid Year |
| USDL Recipients with Summer Registrations | BSA Data Warehouse |
Parameters - Aid Year |