Data Warehouse - Data Dictionary

Data Warehouse - Data Dictionary

Information
Data Warehouse has published a Data Dictionary,  sharing all of the State Datawarehouse Tables and Fields.   Some tables have details and joins to use,  where other less commonly used tables simply share the field names.

This should be helpful when creating queries or wondering what fields exist.  

If you have any questions, please send an email to financesupport@utah.gov

    • Related Articles

    • QRG - Using Excel to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1CzcUic3qykVURnFS1yrkN-roU5YvQzJv/view ) Introduction To access State Data Warehouse using excel or other tools, create a DTS helpdesk ticket, they need to install ...

    • QRG - Using Access to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1jcxI35q1Rpz_gLCbOonQaWSgO51duFq7/view ) Introduction Open Database Connectivity (ODBC) database. Similar to the state data warehouse, you’ll need to install an ...

    • Excel Querying Data Warehouse (Microsoft Query)

      It appears recent Office 365 Updates (2024) have impacted the menu choices for those of you who use the Microsoft Query to access State Data Warehouse. If you no longer see the Microsoft Query in the 'Other' query option, please see below for ...

    • Labor Plus Query

      Labor Plus is a link within the Online Accounting Journal query. If you have accesss to the online accounting journal, then you have access to see Labor Plus. For privacy reasons, State Data Warehouse hides many vendor names. If you were to add the ...

    • ODBC Connection Error When Connecting to Data Warehouse via Microsoft Access or EXCEL

      Problem An error is received when trying to access. ODBC call failed  Specified driver could not be loaded due to system error 126: The specified module could not be found. (Adaptive Server Enterprise, C:\Sybase\DataAccess\ODBC\dll\sybdrvo.dll)(#160) ...