Comparing Project Status, Award Status, and Expenditure Inquiry
Project Status Inquiry (PSI)
PSI gives the user the ability to view actual and commitment transactions by Project. There are three components that PSI uses to view the transactions: Project, Task, and Resource. The information in PSI is updated every day at 5 a.m.
A Project is a specific activity that is funded by an Award.
A Task is used to further define the activity on a project. Currently there are two Tasks on each Project: Task 1 and Task 88. Task 1 is used for all expenditures except payroll accruals. Task 88 is used only for payroll accruals.
Resources are budgeting components used in the creation of a budget. At OHSU, the budget is created at the Project level. Examples of resources are: Personnel, Fringe Benefits, Supplies, etc.
PSI allows the user to view summary information for a Project, or by drilling down to the Task level, you can view the detail for each transaction. If the expenditure class is "supplier invoice," you can drill down to the AP Invoice by clicking on the "AP Invoice" button.
PSI also allows the user to see detailed payroll information, depending on the user's role on the Project. Department Staff is able to view detailed payroll information, while Project Staff cannot view the detail for the payroll transaction.
Award Status Inquiry (ASI)
ASI allows the user to view actual and commitment transactions and financial data at the award level and drilldown to the project level. The user can view budget vs. costs data for all projects funded by an award. If multiple awards fund a project, ASI will only display activity for that portion of the project that is funded by the award queried in ASI. The information in ASI is updated real-time. Detailed payroll information is not available in ASI. No name is displayed associated with the expenditure type.
Expenditure Inquiry (EI)
EI allows the user to view details about actual expenditure items for a project. EI is an inquiry/maintenance tool for reviewing project expenditures. EI should not be interpreted as a tool to look up project and award balances, since EI shows actual transactions in various states. EI will display many transactions that cannot be viewed in either ASI or PSI. For example, EI will display items that are not cost distributed (posted to the project). In ASI and PSI these transactions are excluded from view. Items that fail the costing process and/or funds checking can be viewed in EI. Again, in ASI and PSI these transactions are excluded. EI allows the user to view items that are not validated costs whereas ASI and PSI are tools that view only validated costs.
ASI and PSI contain budgetary information while EI does not. The primary selection parameter for the expenditure item query is Project. Other parameters can be used to refine the query.Transactions that come in from the IBS system can be viewed in more detail through EI. Select the transaction you wish to view, and click on the "zoom" icon on the menu bar. Or, select the transaction you wish to view and select "Zoom" from the drop down menu under "View" on the menu bar. The information in EI is updated real-time.
Functional Overview for ASI, PSI, and EI
|Functionality||Project Status Inquiry
||Award Status Inquiry
|Actuals Item Details
|Funds Check Failure
|Funds Check Passed
Commitment Reporting Differences in ASI and PSIThere is a difference between the selection criteria that ASI and PSI use for commitment reporting. This means that the commitment total and detail between ASI and PSI may differ since PSI selects commitments that ASI will not and vice versa. See the following table for a breakdown of the differences.
|Requisition||Approve Reserved Item
||Approved Reserved PO
||Full Match Approved PO to Saved Invoice
||Full Match PO to Approved Invoice
||Final Match PO to Approved Invoice
|Planned Purchase Order
|Invoice||Save then put on Hold
|Invoice||Cancel Saved Invoice
|Invoice||Cancel Approved Invoice