All Dean's Office QDB Programs

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.

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
(Medical Enterprise Users)

Use Dean's Office Dashboard

This replaces the doaddins

Alan x40775

Nov 19, 2013

6220

ARRA Instructions

 

 

 

 

 

QDB/GLPPP FPM ADHOC
(for Non-Medical Enterprise Users)

Qdbgpfpm.exe
Help
Excel 2007 work around

ODBC not needed

Alan x40775

Oct 02, 2015

1.4K

Non-Medical Dashboard

NonMedDash.exe

Used to fix issues with Excel not closing, etc.

Alan x40775

Aug 18, 2015

1.5K

EDB Excel

QDBEDB.exe

ODBC not needed

Alan x40775

Nov 29, 10

946

R-Net Excel 

QDBCG.exe

ODBC not needed

Alan x40775

Nov 19, 2012

933

PAC Excel

QDBPAC.exe

ODBC not needed

Alan x40775

Oct 6, 11

1706

Financial Reporting Application

 finapp.exe

This application is now part of the QDB/GLPPP FPM Excel Add-In.

Alan x40775

Jan 9,04

 3640

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)