Skip to Main Content

Data Model Diagrams

The Entity Relationship (ER) diagram of a database describes graphically the attributes (columns) of the tables as well as the relationships between the tables. It is a valuable reference when querying a database.  Download the latest version of the QDB ER diagrams today.

These documents have been prepared in the Adobe Acrobat (PDF) format for easy viewing and printing. If you do not already have a PDF reader, you can download one from Adobe's website.
If you have any questions, please contact the QDB Team at support@qdb.ucla.edu. We will be glad to help you.

BDG QDB Erwin Data Model
Last updated: January, 2007
Comments:

BAR QDB Erwin Data Model (for users with central access)
Last updated: January 2014
Comments: updated model.

BAR QDB Erwin Data Model (for users with departmental access)
Last updated: January 2014
Comments: updated model.

Cashiering System QDB Erwin Data Model
Last updated: December 2014
Comments: New enhancements have been made.

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

FAM QDB "C" Erwin Data Model (for users with central access Financial Aid data)
Last updated: October 2022
Comments: New enhancements have been made.

FAM QDB "D" Erwin Data Model (for users with departmental-level access)
Last updated: October 2022
Comments: New enhancements have been made.

FS QDB Erwin Data Model
Last updated: May 2021
Comments: New enhancements have been made.

FS QDB History Erwin Data Model
Last updated: May 2021
Comments: New enhancements have been made.

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

PP QDB "C" Erwin Data Model (for users with access to campus-wide Payroll/Personnel data)
Effective date: May 2017
Comments: supp_2016_amt and dc_2016_amt have been added to the TBL_EMP_EXP_DIST, TBL_EMP_EXP_DIST_H, AND TBL_EMP_EXP_DIST_ALL tables

PP QDB "D" Erwin Data Model (for users with access only to department-level Payroll/Personnel data)
Effective date: May 2017
Comments: supp_2016_amt and dc_2016_amt have been added to the EMPLOYEE_EXP_DIST, EMPLOYEE_EXP_DIST_H, AND EMPLOYEE_EXP_DIST_ALL tables

R-Net QDB Erwin Data Model
Last updated: July 2019
Comments: New enhancements have been made.