Autotask PSA: Where do I find a specific field in the Report Data Warehouse?

Autotask PSA: Where do I find a specific field in the Report Data Warehouse?

Question

Where do I find a specific field in the Report Data Warehouse?

Environment

Autotask PSA

Answer

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.

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.