Skip to Main Content

QDB Data Models and Data Dictionaries

The Data Model 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. There are two data models for each data type, one for those with central (global) access and one for those with departmental access.

The Data Dictionary is a collection of descriptions of the data objects or items in the database.

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.

 

Central Access Data Model departmental access data model data dictionary
BAR Data Model BAR Data Model BAR Data Dictionary
Budget Data Model Budget Data Model Budget Data Dictionary
Cashiering Data Model Cashiering Data Model Cashiering Data Dictionary
DACSS Data Model DACSS Data Model DACSS Data Dictionary
FAM Data Model FAM Data Model FAM Data Dictionary

FS Data Model

FS Data Model FS Data Dictionary
FS History Data Model FS History Data Model FS Data Dictionary
PAC Data Model PAC Data Model PAC Data Dictionary
PP Data Model PP Data Model PP Data Dictionary
R-Net Data Model R-Net Data Model R-Net Data Dictionary

 

If you have any questions, please contact the QDB Team at support@qdb.ucla.edu.