Data Model: Projects

Note: This is a subtopic for the Data Model Project Information topic.

• Project Name—The name of the project.
• Summary—The description of the project.
• Project Type—The type of the project (defined by the Project Type from which the project was created).
• Project Count—The total count of projects in the report. This also provides subtotals for any groupings you include in the report. This value can change as you add or remove items that impact the number of projects in the report.
  Note: Project Count counts the unique GUID values for projects. This means that if you have 2 projects with identical names, Project Count will be 2 even though your report shows a single project name.
• Phase—The project phase. This is blank unless Phase Settings have been enabled for the project type.
• Phase Number—The phase number. This is blank unless Phase Settings have been enabled for the project type.
• Start Date—The start date of the project as entered when the project was created. This is not based on the task schedule.
• Start Date Groups

  Date group query items are useful for reporting trends over time. If you include a date group item and pivot your report on that item, you can see how something is trending over time.

  • Project Start Week—Lists the start date of the week in which the project start date falls.
  • Project Start Month—Lists the month and year in which the project start date falls.
  • Project Start Quarter—Lists the year and quarter in which the project start date falls.
  • Project Start Year—Lists the year in which the project start date falls.
• End Date—The end date of the project as entered when the project was created. This is not based on the task schedule.
• End Date Groups

  Date group query items are useful for reporting trends over time. If you include a date group item and pivot your report on that item, you can see how something is trending over time.

  • Project End Week——Lists the start date of the week in which the project end date falls.
  • Project End Month—Lists the month and year in which the project end date falls.
  • Project End Quarter—Lists the year and quarter in which the project end date falls.
  • Project End Year—Lists the year in which the project end date falls.
• Priority—The priority of the project. Options are Low, Medium Low, Medium, Medium High and High.
• Health—The health of the project. Options are On Plan, Needs Attention and In Trouble.
• State—The state of the project. Options are Request, Not Started, In Progress, On Hold, Completed and Cancelled.
  
  Note: Reports using the Projects query subject will include project requests (projects with a state of Request) by default. To limit a report to only projects, use a filter to restrict results to projects where State <> Request.
• Project Number—The project number.
• Percent Complete—The percentage complete of the project.
• Owner Full Name—The name of the project owner. This is the user who created the project.
• Manager Full Name—The name of the project manager.
• Approval Status—The approval status of the project. Options are Pending, Approved, Declined, Not Required and Overridden.
• Project Status—The status of the project. Options are Active and Archived.
• Capacity—Whether the capacity of the project is planned or not. Options are Planned and Unplanned.
• Created On—The date the project was created.
• Updated On—The date of the most recent project update.
• Parent Project Name—The name of the parent project (if applicable).
• Last Project Status Updated On—The date of the most recent status update.
• Last Project Status Updated By Full Name—The name of the user who made the most recent status update.
  Note: If the last update was done by the system (for example, as a result of an auto-health setting), Last Project Status Updated By Full Name is blank. This differs from a custom view in PPM which shows System in the same situation.
• Last Project Status Updated Comment—Comments added during the most recent status update.
• Last Rich Text Project Status Update Comment—Comments added during the most recent status update with text formatting preserved. To use this query subject properly, you need to map it to the Rich Text Tool.
• < any custom project fields >
• Project Financials
  • Budget—The project budget. This is an entered amount from the Budget field and is not calculated.
  • Estimated Expenses—The estimated expenses for the project. This is an entered amount from the Estimated Expenses field and is not calculated.
  • Total Actual Labor Cost—The total actual labor cost for the project.
  • Estimated Labor Cost—The estimated labor cost for the project or project request.
  • Estimated Labor Revenue—The estimated labor revenue for the project or project request.
  • Total Planned Labor Cost—The planned labor cost of the project or project request.
  • Total Planned Labor Revenue—The planned labor revenue of the project or project request.
  • Total Estimated Cost—The total estimated project cost.
• Work Hours
  • Estimated Work Hours—The total of all resource requirement type hours.
  • Total Scheduled Work Hours—The total scheduled work hours.
  • Total Actual Work Hours—Total actual work hours.
    Note: Total Actual Work Hours for parent tasks come from child tasks. Parent tasks have no Actual Work Hours themselves. This difference may show up in summation of Actual Work.
  • Minutes
    • Total Scheduled Work Minutes—Total scheduled work, shown in minutes.
    • Total Actual Work Minutes—Total actual work, shown in minutes.
• Schedule Data
  • Scheduled Start—Planned project start date based on tasks.
  • Schedule Start Date Groups

    Date group query items are useful for reporting trends over time. If you include a date group item and pivot your report on that item, you can see how something is trending over time.

    • Schedule Start Week—The start date of the week in which the scheduled start date falls.
    • Schedule Start Month—The month and year in which the scheduled start date falls.
    • Schedule Start Quarter—The year and quarter in which the scheduled start date falls.
    • Schedule Start Year—The year in which the scheduled start date falls.
  • Scheduled Finish—The planned project finish, based on tasks.
  • Schedule Finish Date Groups

    Date group query items are useful for reporting trends over time. If you include a date group item and pivot your report on that item, you can see how something is trending over time.

    • Schedule Finish Week—The start date of the week in which the scheduled finish date falls.
    • Schedule Finish Month—The month and year in which the scheduled finish date falls.
    • Schedule Finish Quarter——The year and quarter in which the scheduled finish date falls.
    • Schedule Finish Year—The year in which the scheduled finish date falls.
  • Scheduled Duration Days—The number of calendar days between the schedule start and scheduled finish dates.
  • Schedule Lock Information

    Note: A project schedule is locked if the project is being synchronized using ProjectTransit.

    • Schedule Locked By Full Name—The name of the user who has locked the project schedule.
    • Schedule Locked On—The date the schedule was locked.
    • Schedule Lock Type—The reason the schedule is locked. Options are Unlocked and Integration.
      
  • Actual Start—The actual project start, based on tasks.
  • Actual Start Date Groups

    Date group query items are useful for reporting trends over time. If you include a date group item and pivot your report on that item, you can see how something is trending over time.

    • Actual Start Week—The start date of the week in which the actual start date falls.
    • Actual Start Month—The month and year in which the actual start date falls.
    • Actual Start Quarter—The year and quarter in which the actual start date falls.
    • Actual Start Year—The year in which the actual start date falls.
      
  • Actual Finish—The actual project finish, based on tasks.
  • Actual Finish Date Groups

  Date group query items are useful for reporting trends over time. If you include a date group item and pivot your report on that item, you can see how something is trending over time.

  • Actual Finish Week—The start date of the week in which the actual finish date falls.
  • Actual Finish Month—The month and year in which the scheduled finish date falls.
  • Actual Finish Quarter—The year and quarter in which the scheduled finish date falls.
  • Actual Finish Year—The year in which the scheduled finish date falls.

• More Information
  • Priority (numeric)—The project priority as a numeric value. Options are 0 (low), 1, 2, 3 and 4 (high).
  • Health (numeric)—The project health as a numeric value. Options are 0 (On Plan), 1 and 2 (In Trouble).
  • State (numeric)—The project state as a numeric value. Options are 0 (Request), 1 (Not Started), 2 (In Progress), 3 (On Hold), 4 (Completed) and 5 (Cancelled).
  • Approval Status (numeric)——The project approval status as a numeric value. Options are 0 (Pending), 1 (Approved), 2 (Declined), 3 (Not Required) and 4 (Overridden).
  • Schedule Lock Type (numeric)—The schedule lock type as a numeric value.
  • Project Request Type—The project request type the project was generated from. This will be blank if a project was not created using the project request process.
  • Auto-Approve Resource Allocation—Whether or not the project is configured for auto-approval of resource requests. Options are No and Yes.
  • Auto-Approve Resource Allocation (numeric)—Whether or not the project is configured for auto-approval of resource requests as a numeric value. Options are 0 (No) and 1 (Yes).
    Note: This numeric data item is designed to make filtering of reports independent of PPM culture setting, as the 0/1 options do not change.
  • External ID—Customer supplied value uniquely identifying the workspace identifier. This field is most often used with Daptiv Connect.
• IDs

  Note: IDs are included in the data model so you can join to other queries. Also, grouping on an ID can help separate different items with identical names.

  • WorkspaceID
  • ManagerID
  • EnterpriseID
  • ParentWorkspaceID
  • WorkspacePhaseID
  • WorkspaceTypeID
  • WorkspaceProposalID
  • WorkspaceCloseID
  • ScheduleLockedByID
  • WorkspaceRequestTypeID
  • SummaryTaskID
  • OwnerID
  • UpdatedBy
• UTC Dates

  Note: UTC dates are shown in Coordinated Universal Time format. UTC is also known as Greenwich Meridian Time (GMT).

  • Created On (UTC)—The date the project was created.
  • Updated On (UTC)—The date the project was updated.
  • Schedule Locked On (UTC)—The date the project schedule was locked (if applicable).

   

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved