Where do I find a specific field in the Report Data Warehouse?
- Autotask PSA
You can use the Autotask Report Data Warehouse Schema to understand where you would find data in the Warehouse. This spreadsheet report provides the View Names, Column Names, and column Data Type for all views in the Report Data Warehouse. The Excel sheet includes column filters so you can sort by column to search alphabetically for views or columns. You can download it from this link.
For more information about how to use this spreadsheet, refer to our Autotask PSA: Using the Report Data Warehouse Schema Spreadsheet article.
NOTE: The Report Data Warehouse draws data directly from your Autotask database. The data returned uses the terminology found in the internal naming conventions used in Autotask code. The language that appears in the Autotask user interface is designed to enhance usability when completing tasks through the interface.
This terminology has changed over time, and sometimes, the language that appears in the user interface is different from that returned by the Report Data Warehouse. To learn more, please refer to our Autotask PSA: Terminology Differences Between Report Data Warehouse And The Autotask UI article.