SPA PI Cognos Reports

Training on these reports is available. Go to http://training.nmsu.edu/business/ to learn more.
(Adobe Reader needed to open documents)
Report NamePurpose of Report
RA-SPA-Account Code Summary by Grant Upon selection of the summary Organization, Principal Investigator or Grant Number, the report provides the budget balance available by index and includes encumbrance for approved requisitions and salaries that are currently being charged to the account.
RA-SPA-Account Code Summary by Index Upon selection of the Summary Organization, Fund Manager or Index Number, the report provides the budget balance available by index and includes encumbrances for approved requisitions and salaries that are currently being charged to the account.
RA-SPA-Award/Contract Billing Summary This report provides a summary of invoices and payments sent to the agency. It also provides a quick look at how much is owed on the grant and how much is unbilled or held for review.
RA-SPA-Expiring FundsThe report provides a list of funds that will expire within the next 90 days as of the day the report is run.
RA-SPA-Grant Activity by Agency The report allows the user to select an agency or several agencies and will list all grants under this agency by organization. The search can be limited to one or all roll-up organizations.
RA-SPA-Grant Activity by Org The report allows the user to select a summary organization or all summary organizations and will provide a listing of total grants by organization in alphabetical order. The search can be limited to one or all roll-up organizations.
RA-SPA-Grant Activity by PI The report allows the user to select a summary organization or all summary organizations and then select the Principle Investigator and will provide a listing of total grants by selected PI. The search can be limited to one or all roll-up organizations.
RA-SPA-Grant Activity by PI-FOAPAL The report allows the user to select a summary organization or all summary organizations and then select the Principle Investigator and will provide a listing of total grants by selected PI and will list FOAPAL. The search can be limited to one or all roll-up organizations.
RA-SPA-Grant Index Lookup The report lists all indices associated with active grants by principal investigator for an organizational unit. The report will not list any grants or indices that have been termed.
RA-SPA-Grant Transaction Detail The report provides a list of transactions that have been charged to the grant for a specific fiscal period. The report allows for the review of expenses monthly for reconciliation purposes.
RA-SPA-AR Aging Report by OrgnReports aging of Accounts Receivable by PI upon selection of the Summary Organization and PI.
To run the reports go to https://cognos-p.nmsu.edu/cognos8/.     Click here to request access to Cognos.