- Data Mart Data Dictionaries
- GL Star
- Payroll Star
- Award Certifications
- Award Funding Actions
- Award Investigators
- Award Terms
- Grants Department Contacts
- Project Accounting
- Project Commitments
- Project Investigators
- Regent Summary Report
- UW Project Types
- WISPER Documents
- WISPER Document Investigators
- WISPER Document Personnel
- PS Query
- Other Reporting
WISDM Main Page
- What does the 'Database Status' box mean?
- Besides the 'Database Status' box, what should I know about the main page?
Department 'Search' and 'Rollup'
- What is the difference between the department 'Search' and 'Rollup' features?
- What fields are used in the department 'Search'?
- What is the department 'Rollup' feature?
- In the department 'Rollup' feature, what are the different department trees available? What do I do with those trees?
- In the department 'Rollup' feature, what does the 'Filter by Fund' box do?
- What can I enter in the 'Add Dept' box on the department 'Rollup' feature?
- Why does the tree show up on the bottom of the page on the department 'Rollup' feature?
- What does the 'Locate' button do on the department 'Rollup' feature?
- What do the report options on the summary report do?
- Why do some report summaries have a cash balance section, while others do not?
- I have access to several campuses' information. Why is the cash balance section different for different campuses?
- Why can't I see detail summary information for the project I am searching?
- What are the fields in the 'Project Search' screen?
- What results are returned by the 'Project Search'?
- What are the searches available for Accounts Payable and Purchase Orders?
- What fields are used in the 'PO Search'?
- What results are returned by the 'PO Search'?
- What fields are used in the 'PO Encumbrance Search'?
- What results are returned by the 'PO Encumbrance Search'?
- What fields are used in the 'Voucher Search'?
- What results are returned by the 'Voucher Search'?
- What fields are used in the 'Vendor Search'?
- What results are returned by the 'Vendor Search'?
- What fields are used in the 'Journal Search'?
- What fields are used in the 'Transaction Search'?
- Can I specify which fields I want to see in the results of the queries?
- What is the 'Budget Control Report'?
Other WISDM options
- How do I change my password?
- Can I specify the default tree level for summary reports?
- Can I limit the trees I see in my summary report options?
The web address is: https://wisdm2.doit.wisc.edu/wisdm2/Main.aspx
Contact a campus WISDM administrator. A list of campus WISDM administrators can be found by
The 'Database Status' box states that the financial information loaded into WISDM during the most recent load matches the information in SFS. If the data matches, the Status of Data will state “No errors,” like the following:
Click on the status message to see detailed information on the journals loaded during the previous 5 days. The screen will appear similar to the following: (insert WISDM3 jpg)
If there are problems with the data, the status will state "Errors". If the SFS journal posting process is not completed by the start of the WISDM load, the status message will state “NO DATA LOADED DUE TO POSTING DELAYS".
The black bar across the top of every screen has several functions. Choose the 'Main Menu' dropdown arrow to see navigation options and sub-menus. You can also click the 'Comment' link next to the 'Main Menu' link to send a message to the WISDM development staff. Use this function to convey messages regarding problems, enhancement ideas, or to tell WISDM development staff that you like features available in WISDM.
The far right portion of the black bar is used to change the fiscal year and business unit for the data seen. (If you only have access to one business unit, the business unit dropdown box is not available, it will be hard-coded with your business unit.)
Selecting "Search" will load a search screen. This allows you to limit the Departments returned to a manageable number.
Selecting "Rollup" will load the rollup search. This feature allows the user to combine multiple Departments within one report.
The 'Search' function uses the following fields to query the database. Any combination of the fields can be used to search.
Fund: Enter one complete fund (i.e. 128).
Dept: Enter the department ID. A dropdown list contains:
is exactly- enter the complete 6 character department ID
starts with - enter part of a department ID
Descr: Enter the department description. A dropdown list contains:
is exactly - enter the organization description exactly as it appears in SFS
contains - enter part of an organization description
starts with - enter the beginning of an organization description
Mgr: Enter the department manager name. A dropdown list contains:
is exactly - enter the manager name exactly as it appears in SFS
contains - enter part of a manager name as it appears in SFS
starts with - enter the beginning of a manager name
Records per Page: Select the number of result records to view on each page. The options are 50, 100, and 500.
The department 'Rollup' feature allows you to create one summary report with multiple departments. You only can use one fund in the report. You also have the ability to save queries that are run frequently. The 'Rollup' feature looks like this:
To use the feature, enter one fund, and at least one department. Click the "Add Dept" button to add each department to the query criteria. When you have all the needed departments added, press the “Run Query” button. A summary report will be created.
In the department 'Rollup' feature, what are the different department trees available? What do I do with those trees?
These trees determine what departments will show up in your report. The trees are maintained in SFS. The department used in the rollup must be in the selected tree, or it will not be selected.
The 'Filter by Fund' checkbox will limit the tree to show departments that only have transactions in the fiscal year and fund which you entered. This feature can take a long time to run when using a campus wide fund (100, 101, 128, etc.). For example, if you enter fund 144 and click on the 'Filter by Fund' checkbox, when viewing the tree, only departments that have activity in fund 144 will appear in the tree.
You can enter:
A single organization level (i.e. 201000).
A list of organization levels, separated by commas (i.e. PRESIDENT or GENERAL, ACADEMIC AFFAIRS).
A list of single organizations and ranges separated by commas (i.e. 204000, 201000, 203000).
Instead of entering department ID's using "Add Dept", you can click the levels on the tree to select departments or whole groups of departments to include in your query. Use the triangular menu items to navigate the lists, and the check-boxes to select an item.
In the above example, PRESIDENT was entered in the "Add Dept" box. However, you can select the same tree node from the tree and get the same results. Notice also that the 3 departments under PRESIDENT are grayed out because they have been selected by definition.
The 'Locate' button will expand the tree to the level of the node selected. This feature is useful to make sure the proper department is selected. The 'Remove' button will remove the department from your selection.
The report options will be the same regardless of what department is selected; however, the report may look different. The reports differ for GPR funds and non-GPR funds.
The report options allow the user to select the following options:
Project Option: Select “Only Departments”,“Both Departments and Projects” or "All Projects Summarized". If the department does not have transactions both with and without Project ID’s, these options will not be selectable.
Time Period: Select the accounting periods to view in the summary report. The default value is Year To Date. The “advanced” link will allow selecting specific periods or quarters.
Account Tree: Select the account tree used to build the summary report. The account trees are created in PeopleSoft and are copied over to WISDM. For more information on the trees available for your business unit, contact your WISDM administrator.
Drilldown Level: Select the level of detail for the summary report. The drilldown level coincides with the account tree. The selections go from least detail to most detail. The lowest level of detail usually shows the individual accounts.
Program: Select the programs to view with the report. The only options for Program Code are to view all the program codes in the summary, or select only one program code. The program codes (formerly activity codes) are based upon the expenditure classification published by the National Association of College and University Business Officers (NACUBO). The programs used by UWSA are:
Include Period 998: Check this box if you want to view period 998 adjustments for the selected org. This is only available for non-GPR funds. The period 998 adjustment will appear as a line in the cash balance presentation.
Why do some report summaries have a cash balance section, while others do not?
GPR Funds do not show a cash balance section, since GPR funds do not carry a cash balance. Non-GPR funds show a cash balance section.
I have access to several campuses' information. Why is the cash balance section different for different campuses?
There are two different cash balance presentations available in WISDM, one based on fund balance (account 8700), and the other on cash (account 6100). Each business unit decided which presentation they wanted to use.
Why can't I see detail summary information for the project I am searching?
Either the project may have no activity for the fiscal year searched or you do not have access for the specific project/grant. If the project crosses fiscal years, try to view the project for a previous fiscal year to see if it is visible then. If not, contact your WISDM administrator to see if you have access to the project. A list of campus primary WISDM administrators can be found by
The following fields are used in the 'Project Search'. Any combination of fields may be used to search.
The results returned will match the Project criteria entered from the search screen. There are hyperlinks on the project to see detailed information specific to that project. There are also hyperlinks on the department to filter by projects to that department.
The AP/PO searches are used to retrieve information on Accounts Payable and Vendors. There are four related searches in this section- PO Search, PO Encumbrance Search, Voucher Search and Vendor Search.
The 'PO Search' uses the following fields. You may use any combination of fields to search:
Only one field needs to be completed to perform a search, but the more information entered, the more precise the results will be. Wildcards like % (many characters) and _ (a single character) can be used in the PO, PO Vndr Name and PO Short Vendor Name fields. When using wildcards, be sure to change the search terms dropdown menu from "is exactly" to "starts with".
PO: Enter the entire Purchase Order Number.
PO Date: Enter the date of the Purchase Order in mm/dd/yy format.
PO Vndr ID: Enter the entire 10 character Vendor ID number.
PO Vndr Name: Enter the Vendor Name as it appears in SFS. The dropdown list contains:
is exactly – Enter the entire name
starts with – Enter the beginning of the vendor name
PO Short Vendor Name: Enter the short Vendor Name as it appears in SFS. The dropdown list contains:
is exactly – Enter the entire name
starts with – Enter the beginning of the vendor name
Records Per Page: Select the number of pages to view per page. The options are 50, 100, and 500.
The results returned will match the PO criteria entered from the search screen. The PO field is linked to show the specific Purchase Order information. Clicking on the PO field hyperlink will show the following PO detail, as well as any related Lines, Distribution and Invoices. The Voucher ID in the Invoice section drills to see the specific invoice information. Some of the information found on these panels comes directly from SFS, so the payment information may be more up to date than the PO information.
The 'PO Encumbrance Search' uses the following fields:
The results returned will match the PO Encumbrance criteria entered from the search screen. The PO ID field is linked to show the specific Purchase Order information. Clicking on the PO ID field hyperlink will show PO detail, as well as any related Lines, Distribution and Invoices. The PTD field has a hyperlink to give detailed information about payments to date for that Purchase Order. The 'Open Bal' field gives information on any encumbrances with balances.
The 'Voucher Search' uses the following fields:
Only one field needs to be entered, but the more information entered, the more precise the results will be. Wildcards % (many characters) and _ (one character) can be used in many of the fields. If using wildcards on a field with a dropdown list option, you must change the dropdown list to “starts with”.
The results returned will match the Voucher criteria entered from the search screen. Clicking on the 'Voucher ID' field hyperlink will show PO detail, as well as any related Lines, Distribution and Invoices. The 'Invoice Image' field has a hyperlink to the stored image of the actual invoice.
The 'Vendor Search' uses the following fields:
The results returned will match the Vendor criteria entered from the search screen. You can click the 'POs' or 'Vouchers' links to see detailed information regarding purchase orders or vouchers for that vendor.
The 'Journal Search' uses the following fields. You may use any combination of fields to search:
The following fields are used in the 'Transaction Search':
For performance reasons, this search requires you to enter at least one of fund, organization, program, project, or account among your criteria. The more criteria entered, the faster the results are returned. The wildcards % (many characters) and _ (one character) can be used in the fields that use a “starts with” selection. Clicking in any field provides a pop-up note with expected/example field information.
Sometimes. On several different search results, there is a link called "Pick Custom Columns..." which allows you to specify fields used in the query. On the 'Transaction Search' screen, it is seen at the bottom. You can scroll throughout this view to choose the available fields.Select the fields to view by checking the corresponding box. The fields selected will stay as selected until changed. This feature is also available with other WISDM searches. The fields available will vary based on the search performed.
The Budget Control Report gives a breakdown by funds for all departments specified in the search criteria. The search box looks like the following:
The search requires a selection for the fund, the department, the accounting period and an output option. The default for the accounting period is year to date through the current period. In the result set, the Beginning Cash and Ending Cash Balance columns are only shown for non-GPR funds. The Budget Balance column formula is Expense Budget + (-Sales Credits) – Encumbrances – Expenses.
Fringe benefit expenses are included in the Expenses, so if viewing information for a GPR fund that does not encumber Fringes, the Budget balance may vary what is expected.
From the main menu, choose "My Profile" and click "Change Password". Remember the following password requirements when creating a new password:
- Be at least 5 characters long.
- Contain at least one digit.
- Contain at least one letter.
- Not contain your user name.
- Have a letter as the first character.
Yes. From the main menu, choose "My Profile" and click "Account Tree Levels". The following screen will load:
There are several options on this screen related to trees. The first option is “Default level for unlisted trees”. This option dictates how the summary reports will first appear. The summary report will be shown at either the most detail (specific accounts) or the least detail (Revenue and Expenses).
In addition to this option, you can set specific levels for specific trees used frequently. To choose a specific tree’s default level, select the tree from the “Add Default Tree Level for:” list. The tree will appear below, with a dropdown list of the tree’s levels.
Select the level that you want the tree default level set at by clicking "Change". In the example above, the ACCOUNT tree and the ACCOUNT_NO_FRINGE will have a default level of “Detail Accounts”, which means when these trees are selected from the dropdown list, the Detail Accounts level will open.
Choose a default level from the dropdown menu that appears and click "Update" to save your changes. The tree levels can be changed within the Summary Reports, but this feature saves a couple of clicks.
No. Only the WISDM Business Unit Administrator can limit the trees seen in the dropdown lists. These limits will affect the entire business unit.