QDB Data Dictionary

The Data Dictionary application is currently being redeveloped. But in order to assist you with your queries, we have provided a PDF for each different QDB system. The Data Dictionary files provide detail definitions for tables and columns. If you have any questions, please contact the QDB Team at support@qdb.ucla.edu.

BAR QDB Data Dictionary
Last updated: May 2008
Comments: New enhancements have been made to br_subcode, br_cp_bd_reconcile and br_stu_hold.

Budget QDB Data Dictionary
Last updated: May 1, 2004
Comments: Addition of the open_prov table and new columns  added to budget_summary and budget_detail.

Cashiering QDB Data Dictionary
Last updated: November 2011
Comments: New enhancements have been made.

DACSS QDB Data Dictionary
Last updated: May 6, 2009
Comments:

FAM QDB Data Dictionary
Last updated: July 2017
Comments: New enhancements have been made.

FS QDB Data Dictionary
Last updated: October 2017
Comments: New enhancements have been made.

PAC QDB Data Dictionary
Last updated: June, 2005
Comments: cntl_entity has been added to most tables.

PP QDB Data Dictionary
Last updated: May 2017
Comments: Updated to include the supp_2016_amt and dc_2016_amt fields.

RNet QDB Data Dictionary
Last updated: June 2015
Comments: ctao_fl has been added to the rn_award table.