|
| ||
|
||
The QDB Programs are user-friendly computer programs that retrieve data from the Query Database (QDB) . In order to use these programs, you must have a QDB Login ID and password. If you need a pssword, please contact your departmental DSA to assist you. If you need access to only FS data, request only FS QDB access. If you are interested in PP QDB data, you must specify access to both FS AND PP QDB. |
Note: You need to log into the following web site ONLY ONCE before using any or all of the QDB programs. http://www.qdb.ucla.edu/sqlserver/default.asp |
| QDB Programs Attention network
administrators:
If you need to install any of the following programs on your network and have not done this before, please get in touch with the contact person indecated below . For GL/PPP program only: If you have Excel 97 and 2000 and place the GL/PPP addins on your network, please place each version of the addin in a separate directory. This is important because addins have the same name. |
GL/PPP FPM AD HOC Reporting This program is updated each time you open your Excel. Doaddins.exe is the program that performs the auto-update. If you work from home or cannot get the auto-update to work for you, you can download the Qdbgpfpm.exe. See the help if you need assistance. Caution: you need to check for updates yourself. This program is updated often. |
| Program Descriptions & Manuals | Files to Download | Remarks |
Contact | Version Date | Size KB |
| QDB/GLPPP FPM ADHOC | doaddins.exe Help | ODBC not needed | Mike 40772 | Jul 1, 08 | 3021 |
| QDB/GLPPP FPM ADHOC (off campus) | Qdbgpfpm.exe Help | ODBC not needed | Mike 40772 | Jul 1, 08 | 3021 |
| EDB Excel 97 or 2000 | QDBEDB.exe | ODBC not needed | Mike 40772 | Mar 16, 05 | 815 |
| R-Net Excel 97 or 2000 | QDBCG.exe | ODBC not needed | Mike 40772 | Nov 1, 04 | 868 |
| PAC Excel 97 or 2000 | QDBPAC.exe | ODBC not needed | Mike 40772 | Jun 16, 05 | 1706 |
| Financial Reporting Application | finapp.exe | Mike 40772 | Jan 9,04 | 3640 |
|
| DFS Download Program | Dfs.exe | Mike 40772 | May 15,01 | 3362 |
Saved Queries
First time users, please download the saved queries to
your C: drive so that you can use these as a starting point for building your
own library of queries.
CAUTION: IF YOU HAVE PREVIOUSLY DOWNLOADED THE QUERIES,
DOWNLOADING AGAIN WILL OVERWRITE ALL EXISTING QUERIES INCLUDING THOSE THAT YOU
MAY HAVE CREATED FOR SPECIALIZED PURPOSES.
| Queries | Files to Download | Version Date | Size KB |
| AD HOC | ADHOCQueries.exe | Nov 28, 01 | 6.98 |
| EDB | EDBQueries.exe | May 8, 01 | 3.96 |
| R-Net | RnetQueries.exe | July 11, 02 | 17.2 |
| PAC | PACQueries.exe | May 8, 01 | 11 |
| Templates We are also distributing some templates for use with the data downloaded through the QDB GL/PPP addin. These templates originated in the division of Hematology/Oncology within the Department of Medicine so we would like to extend our thanks to their department for creating these templates and allowing us to distribute them on our web site. |
| Templates | Files to Download | Version Date | Size KB |
| Summary by Sub. | TEMPLATE.EXE | May 1997 | 258 |
| Sales & Service Summary | SSTEMPL.EXE | Aug 1, 98 | 44 |
Manuals & Instructions
| Files to Download |
| Excel Pivot Table |
| Online Financial Journal Adjustment (FJA) |
