Warehouse Reports

WAREHOUSE REPORTS

New and/or Updated Databases

The following databases have been updated and revised for automatic linking to the warehouse. These databases do not require use of the CreateAcctInfoTbl database, as these databases link to the Current Header and the History Header warehouse tables. When you select a database below, choose "Open" and the database will be automatically saved into your C:\AccessReports folder on your PC. If you do not have an AccessReports folder currently in your C drive, you should create it before opening these databases.

(Note: If you have a "D" drive partitioned on your PC for file storage, please change the directory location to match your current configuration.)

PCard Reports database.
Provides Purchasing Card reports:
- Fiscal Year for all transactions for an individual reconciler/cardholder or for all reconcilers/cardholders;
- Transaction Date range for all transactions for an individual reconciler/cardholder or for all reconcilers/cardholders;
- Status reports for New, Viewed, or Autopost transactions for all cardholders or for an individual cardholder; and
- Administrative reports for inactive cardholders with transactions, for cardholders with a suspended card, for inactive cardholders with an active purchasing card, and the SIC exceptions report.
  (Updated February 2006)
Deferred Student Billing
This report provides a list of students with defrred payment plans and the balances they still owe, by Location (i.e., UP, BD, NK, etc.).
(Created April 2008)
ObjectCodesSummary database.
This database provides an object code summary report by Administrative Area for a specified fiscal year. Various reports are provided for general accounts and/or restricted accounts. Summarized reports for equipment purchases (capital and non-capital) and travel (professional development and business travel) are provided.
(Revised May 2004)
ObjectCodeSummaryRptMnth database.
This database provides summarized object code expense reports based on your selection of a begin and end month. Various reports are provided for general accounts and/or restricted accounts. Summarized reports for equipment purchases (capital and non-capital) and travel (professional development and business) are provided.
(Created September 2005)
ObjectCodeSummary-4-Yr. Comparison database.
This database provides summarized object code expenses for four years (based upon your selection of fiscal year and report month). You may also choose to view various reports for general and/or restricted funds. Reports can be displayed in account order or by mnemonic order.
(Updated June 2005 -- Note that data from 20012002 and prior years cannot be obtained from this report)
One Object Code database.
This database provides a listing of all details for one object code. You may view reports for current or previous fiscal years. You may also choose to view x-coded amounts on your reports.
(Updated September 2003)
Annual X-Code Review database (for University Park and Hershey locations).
This database reports expense details for those accounts applicable to overhead accounting review. All expense details are listed, and those portions that were x-coded are listed in a separate column.
(Updated August 2003)
General Funds Comparison -- Two Years database.
This database provides a two-year comparison of general funds. Comparisons may be done for any report month (1-12). Data can also be summarized by account or by mnemonic.
(Updated September 2003)
General Funds Comparison -- Four Years database.
This database provides a four-year comparison of general funds. Comparisons may be done for any report month (1-12). Data can also be summarized by account or by mnemonic.
(Updated October 2004)
GIA (Grant-in-Aid) Reports database.
This database was developed by Larry Bell (Eberly College of Science) and provides various reports on GIA and stipend by semester and cost center. It also allows for comparisons of IBIS GIA to Pay-and-Effort GIA.
(October 2005)
Graduate Assistantship/Tuition database.
This database provides a listing of stipend and tuition expenses for your administrative area. You may choose to report by department, by employee name, or by account.
(Updated March 2004)
Pay and Effort database.
This database provides a listing of salary distributions for your administrative area. You can obtain distribution reports for monthly and bi-weekly employees. Reports can be obtained by all accounts, by one account, or by one employee.
(November 2003)
Cost Sharing.
This database contains two queries to obtain a list of all accounts with cost sharing requirements (as indicated in the AURA form). Current and prior year cost share information can be obtained.
(March 2005)

Existing Databases

NOTE: With any database you download that is connected to the warehouse you should refresh the links. For existing databases, both Access 97 and Access 2000 have a "Linked Table Manager" wizard which makes this process very easy - this keeps you from having to delete each table and re-connect each one.
You can find the wizard as follows:
For Access 97: On the toolbar select TOOLS, ADD-INS, LINKED TABLE MANAGER.
For Access 2000: On the toolbar select TOOLS, DATABASE UTILITIES, LINKED TABLE MANAGER.
Select the files to re-link and click OK. You will get a message that the selected linked tables were refreshed.
Download (updated on 7/7/08) I retitled Rebecca Woomer's report database and called it Generic Reports. This is a zipped file. You will also have to download the CreateAccountInfoTbl database. You need to run the CreateAcctInfo query, then link that table to the GenericReports
Download the CreateAcctInfoTbl database to create the tblAcctInfo which is used in many of the database you will be using. This file is NOT zipped - it is ready to run - just save it in the folder where you keep your other files. This version is 97 - 2000 users will need to convert it. You will need to run the query to create the table so you can link it to other databases.
Download the JTDPBrowse database. Use this database to browse your JTDP transactions. You can select to look at your details sorted by the JNumber for the entire Administrative Area, or sorted by the Mnemonic. You can also make a selection to look at an account or a mnemonic. NOTE: This database also requires you to have the CreateAcctInfoTbl database. You will need to link the tblAcctInfo. This database is NOT zipped. I created it in Access 97 - if you have Access 2000, you can convert it. If you have any question, please contact Don Breon at (814) 865-0140. THIS DATABASE ALSO HAS A SWITCHBOARD! You need to hold down the SHIFT key to open the database so you can link to the tblAcctInfo.
Download the BudgetAmendmentsDesc database. This database uses the Budget Number from the Description Field from OAS. If the budget amendment is from outside your area, it will have a "01" or a "99" number and not your budget amendment number. You can look at budget amendments with or without the IOB amounts. You can also look at budget amendments for the entire Administrative Area or by Account. There is also a Allocation Fund Report. NOTE: This database also requires you to link the tblAcctInfo table from the CreateAcctInfoTbl database. THIS DATABASE ALSO HAS A SWITCHBOARD! Initially, you need to hold down the SHIFT key to open the database so you can link to the tblAcctInfo.
Download the BudgetAmendmentsDesc97 database. This database for Access 97 uses the Budget Number from the Description Field from OAS. If the budget amendment is from outside your area, it will have a "01" or a "99" number and not your budget amendment number. You can look at budget amendments with or without the IOB amounts. You can also look at budget amendments for the entire Administrative Area or by Account. There is also a Allocation Fund Report. NOTE: This database also requires you to link the tblAcctInfo table from the CreateAcctInfoTbl database. THIS DATABASE ALSO HAS A SWITCHBOARD! Initially, you need to hold down the SHIFT key to open the database so you can link to the tblAcctInfo.
Download the BudgetAmendmentsFreeSpace database. This database uses the Budget Number from the Free Space which you need to enter. You can look at budget amendments with or without the IOB amounts. You can also look at budget amendments for the entire Administrative Area or by Account. There is also an Allocation Fund Report. NOTE: This database also requires you to link the tblAcctInfo table from the CreateAcctInfoTbl database. THIS DATABASE ALSO HAS A SWITCHBOARD! Initially, you need to hold down the SHIFT key to open the database so you can link to the tblAcctInfo.
Download the BudgetAmendmentsFreeSpace97 database. This database for Access 97 uses the Budget Number from the Free Space which you need to enter. You can look at budget amendments with or without the IOB amounts. You can also look at budget amendments for the entire Administrative Area or by Account. There is also an Allocation Fund Report. NOTE: This database also requires you to link the tblAcctInfo table from the CreateAcctInfoTbl database. THIS DATABASE ALSO HAS A SWITCHBOARD! Initially, you need to hold down the SHIFT key to open the database so you can link to the tblAcctInfo.
Download the AdminAreaName database. This database is used in numerous databases to allow the name of the Administrative Area to be printed on the report.