BI/Query Data Models

Click on the model you wish to download. You will be prompted to save the self-extracting file to disk.  Please be sure to note where you have saved the file.  After saving the file, locate it on your hard drive, and double-click on the file to run it.  Save the models to the default directory for your Hummingbird BI/Query software.  If you're not sure which directory this is, check with your CSC or LAN manager.

Note: Please be sure to choose the model(s) appropriate for the type of QDB data you need and have access to. If you attempt to use a model for data which you do not have access to, you will not be able to log in.

If you have any questions, please contact the QDB Team at support@qdb.ucla.edu. We will be glad to help you.

BDG QDB BI/Query Model
Last updated: February, 2006
Comments: Addition of the open_prov table and new columns added to budget_summary and budget_detail.

BAR QDB BI/Query Model
Last updated: May 2008
Comments: New enhancements have been made to table br_subcode, br_cp_bd_reconcile, and br_stu_hold

CBIG QDB BI/Query Model
Last updated: April 15, 2005
Comments: New

DACSS QDB BI/Query Model
Last updated: July 12, 2005
Comments: mndtry_rvwr_fl has been added to da_audit_reviewer and da_reviewer.

FAM QDB "C" BI/Query Model (for users with access to central-level Financial Aid data)
Last updated: April 2011
Comments: New enhancements have been made.

FAM QDB "D" BI/Query Model (for users with access only to departmental-level Financial Aid data)
Last updated: April 2011
Comments: New enhancements have been made.

FS QDB BI/Query Model
Last updated: November 23, 2009
Comments: Enhancements have been made to account, fund, fs_ucop_acct_grp_range, and overhead_rate.  A new table, fs_overhead_range, has been added.

FS QDB History BI/Query Model
Last updated: November 23, 2009
Comments: Enhancements have been made to account_h, fund_h, fs_ucop_acct_grp_range_h, and overhead_rate_h.  A new table, fs_overhead_range_h, has been added.

PAC QDB BI/Query Model
Last updated: June, 2005
Comments: cntl_entity has been added to most tables.

PP QDB "C" BI/Query Model (for users with access to campus-wide Payroll/Personnel data)
Effective date: August 2011
Comments: New enhancements have been made.

PP QDB "D" BI/Query Model (for users with access only to department-level Payroll/Personnel data)
Effective date: August 2011
Comments: New enhancements have been made.