Inspire Planner Data Model (ERD)

    Understanding the data model behind Inspire Planner and how the different records (objects) relate to each other, is beneficial when building reports. This will also serve as a guide when choosing the appropriate report type.


    Below is the Inspire Planner Data Model.




    Helpful hints:

    • When creating a report containing tasks and the resources they are assigned to, it would be best to use a report type called "Resource Utilization" as this report type allows you to report on Salesforce Tasks and the related Inspire Planner records.
    • When reporting on Projects, you can also include data from any other object that the Project has a lookup to such as Accounts and Opportunities.
    • If you would like to create a report containing time entries and also include data from Projects and Project Tasks that the time entries are related to, it would be best to use a report type called "Project Time Tracking". Since the Time Entry object has a lookup to the Project Task object, this means that you can include data from the time entry records as well as data from the Project and Project Task records.








    « Previous ArticleNext Article »