This section of the website contains information about reporting from the Student Information System. If you do not find the information you need here, please call 4-HELP, followed by 3, then 1, or write 4Help@virginia.edu.TABLE OF CONTENTS
- General Information
- Reporting Q and A Sessions
- Reporting Roles
- Data Catalog
- Discoverer Plus
- Other Reporting Tools
- Password Changes
September 16, 2013
The SIS Reporting team, working with representatives of several graduate schools, has created a Class Enrollment Datamart which is now available to SIS reporting users with access to sensitive Student Records data (UV SR Acad User Reporting). The datamart was created primarily to help administrators answer questions about which schools the students in their classes come from. It is designed in a star schema, which performs much more quickly than standard reporting views.
Click here for a document explaining the purpose and usage of the datamart: Class Enrollment Datamart.docx
Detailed information on the data in the datamart is available in the Data Catalog. The Catalog has also been enhanced to display information about the various SIS team Discoverer reports available in the SIS Reporting database.
Also, check out a new Discoverer report based on the datamart: SR_Sources of Enrollment.
A demonstration of the datamart will take place this afternoon at 4:00 in Newcomb Hall 389. Additional sessions will be scheduled and announced when available.
New Hardware Instructions
October 15, 2012
As has been previously noted, SIS and the Reporting Database will be moving to new hardware over the weekend of October 26-28. Most Discoverer Plus users will not have to make any changes. Because Discoverer will be located at a different URL, anyone who has created a short-cut or browser favorite to the Discoverer login screen will need to recreate their short-cut. Otherwise Discoverer should be the same except for having the SIS logo on the login screen. Any scheduled workbooks may have to be rescheduled.
If you use query tools other than Discoverer to access the Reporting Database, you will have to update your tnsnames.ora file with the new server information in order to continue to access the database. This should be done after 6PM on October 26. If you do it sooner, you will not have access to the Reporting Database again until after the upgrade.
The changes can be made in one of two ways:
- Make a back-up copy of your current tnsnames.ora file and then replace it with the new tnsnames.ora file. If the software was installed by the Integrated System Oracle Client Installer, the tnsnames.ora file will be located in the c:\program files\integrated system\instant_client_11_2\Network\Admin folder. Your computer may have multiple tnsnames.ora files; if you are uncertain of the correct file to replace, we recommend searching and replacing all of your tnsnames.ora files after making a backup copies. If you are running a 64-bit operating system, use these instructions. We do not currently have an installer for 64-bit machines.
- The second option is to uninstall the Integrated System Oracle Client software, and then reinstall the new version. To uninstall, go to the Control Panel on your PC and go to Add or Remove Programs on Windows XP, or Programs and Features on Windows 7, and remove the existing IS_Oracle_Client software. Then, go to the Client Installation Instructions and follow the directions to reinstall.
New Hardware is Coming
October 1, 2012
Updated October 9, 2012
The SIS team is in the process of moving the Student Information System, the SIS Reporting Database, and Discoverer Plus to new hardware. This move was scheduled for the weekend of October 12-14, but has now been rescheduled to October 26-28. The system will go down at 6 PM on Friday, and become available again by 7 AM Monday.
Most Discoverer Plus users will not have to make any changes. Because Discoverer will be located at a different URL, anyone who has created a short-cut to the Discoverer login screen will need to recreate their short-cut. Otherwise Discoverer should be the same except for having the SIS logo on the login screen.
Users who access the Reporting Database using tools other than Discoverer will have to make minor changes to continue to access the database. We'll be sending out additional information about this in the near future.
The SIS Team Has Moved
August 13, 2012
The SIS team has moved from its previous location on Hydraulic Road to Carruthers Hall. All the Reporting Q&A sessions have been rescheduled to Conference Room 240A in Carruthers Hall. For directions, click here.
Information Warehouse Bursar and Financial Aid Data Added to SIS Reporting Database
February 1, 2012
The ISIS Bursar and Financial Aid data formerly located in the Information Warehouse is now available through the SIS Reporting Database. Student Financial Systems reviewed the users who had access to this data and determined who should continue to have access going forward. If you were given access, you were sent a separate email with instructions. If no account was created for you and you still need access to this data, you will need to request SIS Access. You will need to request one or both of the following SIS roles:
- UV SF ISIS Warehouse Reporting - for ISIS Bursar data
- UV FA ISIS Warehouse Reporting - for ISIS Financial Aid data
The Bursar and Financial Aid Pre-Defined Reports will now be available via the following link:
If you normally access this data using ODBC or other access methods other than the Pre-Defined Reports, you may continue to do so. You will need to modify your Data Source or other logic to connect to database CSRPT rather than IWP01. See the information on Other Reporting Tools below for additional details on connecting to CSRPT.
The names and structure of the views are the same as they were in the Information Warehouse:
This data is not available through Discoverer Plus.
This copy is completely refreshed each night. Thus, each morning the data should be completely up to date, and (aside from unplanned downtimes) it should never be more than 24 hours out of date.
Each night the production SIS database is backed up beginning at 1:00 AM. When this backup completes, generally around 1:30 AM, the Reporting Database refresh begins. While the refresh is in progress, the Reporting Database is unavailable. The refresh is normally complete before 6:00 AM.
A UVa Identity Token connected to the JointVPN profile is required for all access to CSRPT.
The Reporting Database should not be confused with the Integrated System's Operational Data Store (ODS), which contains Financial and Human Resources Data.
Do you need assistance with a reporting task? Weekly times have been scheduled when the SIS reporting team will be available to answer your questions and assist you with any reporting problems you may have. There is no agenda, simply bring your questions and we will do our best to help you. Note: if you wish the reports team to look at a Discoverer workbook you have created, please share the workbook with user HD_USER prior to the Q and A session.
Please note this will not be a training session, but is intended for those who have already been through Reports training and have additional questions.
All sessions are on Wednesdays and are in the afternoon unless noted with an AM below. Morning sessions are scheduled from 8 to 9 AM; afternoon sessions are scheduled from 4 - 5 PM. (These times are chosen to facilitate people dropping by on their way to work or home.) It is not necessary to come for the whole time; feel free to drop in any time during that period and leave whenever you like.
Beginning April 24, 2013, the Q&As will be held in Michie North Conference Room 201.
There is a visitor parking lot available between Carruthers Hall and Michie North.
Michie North Conference Room 201: From the visitor lot, walk around to the other side of Michie North and enter through the main door (facing Michie South). Walk straight ahead and you will see an elevator. Take it or the adjacent stairs up one floor to the second floor. Turn left. The last two doors on the left-hand side of the hall are for Conference Room 201.
The currently scheduled dates are:
- July 09, 2014
- July 16, 2014 AM - Cancelled
- July 23, 2014
- July 30, 2014
- August 06, 2014 AM
- August 13, 2014
- August 20, 2014
- August 27, 2014 AM
- September 03, 2014
- September 10, 2014
- September 17, 2014 AM
- September 24, 2014
- October 01, 2014
- October 08, 2014 AM
- October 15, 2014
- October 22, 2014
- October 29, 2014 AM
- November 05, 2014
- November 12, 2014
- November 19, 2014 AM
- December 03, 2014
- December 10, 2014 AM
- December 17, 2014
If you need assistance with reporting at other times, please contact your Local Expert, if available, or contact the SIS Help Desk at 4-HELP, followed by 3, then 1, or 4Help@virginia.edu.
Student Information System (SIS) Toolkits. Reporting role names all end in the word Reporting.) You may also refer to the SIS Data Catalog for detailed information on the data elements contained by each role.
The SIS Data Catalog contains information about all the data available in the SIS Reporting Database. The Data Catalog has two modes: the Discoverer mode (the default) and the Database mode. The Discoverer mode shows the data as it appears in Discoverer, with business areas, folders and item names as they appear in Discoverer. In the Database mode, the views and columns appear as they do through tools other than Discoverer. (Many roles and views are not defined in Discoverer, and therefore only appear in the Database mode.)
In either format you can see all the available security roles, and click on them to see the data that is contained within that role. Likewise (in the Discoverer mode) you can select a Business Area to see what it contains. Selecting a view (folder) will display the columns (items) it contains and information about them.
By default, the Catalog displays all data available in the Reporting Database. However, you may wish to see only the data that is currently available to you. By entering a computing id in the Single User View box, you will see the reporting roles that person currently has, and only the data that they are able to see.
Roles, views, and columns may also now have descriptions which will display in the Catalog. We will be adding more descriptions over time. However, it is not our goal to necessarily have a description for every column--in some cases the meaning is obvious from the name of the column. If you find that a description is missing that you would find helpful, let us know at RPTSupport@virginia.edu and we will try to add it.
If an item in a view displays as a link, that means that additional information is available by selecting the link. The additional information might be a more extensive description, or a list of all the possible values the item might have.
A nice feature of the Data Catalog is that when new data elements (roles, views, columns) are added to the Reporting Database, the Catalog will update automatically, and so always be up-to-date. (Descriptions have to be added manually.)
In addition, the descriptions we create for folders and items (in the Discoverer view) will also be visible within Discoverer itself, so you will not be required to always go to the Catalog to see them. When you are on the Select Items tab of the Workbook Wizard, and click on a folder or item, the description displays near the bottom of the dialog box. However, Discoverer only displays a limited number of characters, so you may want to go to the Catalog for more information about folders.
There is also a Search feature available in the Catalog. By clicking the Catalog Search at the top or bottom of any Catalog page, you are taken to a Search Page where you can enter your search text. The Catalog will search Role, View and Column names and definitions and return the results to you.
If you find any problems using the Catalog, or have suggestions for its improvement, please let us know at RPTSupport@virginia.edu.
To access the Catalog, you must be logged in to JointVPN using your UVa Identity Token. The Catalog can be accessed directly by creating a shortcut to:
To use Discoverer Plus, you must first login to the VPN profile JointVPN using a UVa Identity Token.
Discoverer Plus is then accessed from the main SIS Page, by clicking the Discoverer SIS icon.
The first time you use Discoverer, software may be downloaded to your PC, and you may need to modify your pop-up blocker settings. See the First Time Login and Java Installation Guide for detailed instructions.
Training on Reporting Database data using Discoverer Plus is managed by the Employee Development division of University Human Resources. For information and additional useful documents, please see the Discoverer for SIS Training Toolkit .
The Discoverer Scheduling Manager provides a convenient way to run reports in the background or during off hours, so that you can do other things while your reports run. For a detailed document explaining how to use the Scheduling Manager, download Using the Scheduling Manager in Discoverer Plus.
Discoverer workbooks that have been created by the SIS Reports team appear in Discoverer Plus owned by user SS. However, Rebecca Garver has also created a large number of workbooks for Student Records users with the UV SR Acad User Reporting role. Her reports are owned by user RFG. A document is available which lists these workbooks and the tabs they contain:
- RFG Workbooks for Student Records Academic Users (Updated 05/09/2011)
- RFG Workbooks for Student Records Non-Academic Users (Updated 02/07/2011)
To use any of these other tools, you will need to have Oracle client software installed. You may already have a client installed from previously using the SIS Reporting Database or other databases; however, because the Reporting Database was upgraded to version 11g on June 4, 2011, we recommend that you install the IS Oracle Client for 11g if you have not already done so. This will also install an up-to-date ODBC driver and create three ODBC System Data Sources for you:
- SIS Oracle 11g Client - for connecting to the SIS Reporting Database
- HrFin ODS Oracle 11g Client - for connecting to the HR/Finance ODS
- HrFin Prod Oracle 11g Client - for connecting to the production instance of HR/Finance, if you have access
Please note that if you access the reporting database from another tool, the names of the reporting objects will differ from what from what you see in Discoverer. Each will be preceded by sysadm.uv_ . So for example, AD_Applicants will appear as sysadm.uv_ad_applicants or SYSADM.UV_AD_APPLICANTS in another tool. The names are not case-sensitive.
Discoverer, it will prompt you to change your password. Or, you can use the Password Change webpage to change your password.
Password should begin with a letter, and be composed of letters and numbers. A minimum of 8 characters are recommended for an adequately secure password.
Because we are also requiring you to use a UVa Identity Token to access the Reporting Database, we will not require you to change this password after the initial login. However, to change your password at any time, you can use the Password Change webpage. You can access the Password Change page directly using the URL http://www.sis.virginia.edu/reports/chpass.
Should you forget your password, call 4-HELP, followed by 3, then 1, and ask to have your Reporting Database password reset. They will give you a new expired password, and you will then be able to change it when you log in to Discoverer, or by using the Password Change page.
Note: Please remember that your Reporting Database password is distinct and separate from your password to the Student Information System itself. Changing your password in the Student Information System will not change your Reporting Database password, and vice versa.