Data Model-Project History

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

• Project Name—The name of the project.
• Project Count—The total count of project from the Project History query subject 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.
• Project Status Updated On—The date a status update was done on the project.
• Summary—The description of the project.
• Start Date—The project start date at the time of the status update.
• End Date—The project end date at the time of the status update.
• Health—The project health at the time of the status update.
• State—The project state at the time of the status update.
• Phase Number—The project phase number at the time of the status update.
• Phase Total—The project phase total at the time of the status update.
• Phase Title—The phase title at the time of the update.
• Project Number—The project number.
• Percent Complete—The percent complete for the project at the time of the update.
• Capacity—If the project capacity was planned or unplanned at the time of the update.
• Approval History Status—The project approval status at the time of update.
• Project History Status—The project status at the time of update.
• Updated On—The date of the update.
• Project Status Updated By Full Name—The name of the user who made the update.
• Update Notes—Any notes added during the update.
• Rich Text Update Notes—Any notes added during the update with text formatting preserved. To use this query subject properly, you need to map it to the Rich Text Tool.
• Created On—The date the project was created.
• Project Financials
  • Budget—The project budget at update.
  • Estimated Expenses—The estimated expenses at update.
  • Total Actual Labor Cost—The total actual labor cost (task internal rate(s) * hours worked) at update.
  • Estimated Labor Cost—The estimated labor cost (resource requirement hours * internal rate(s)) at update.
  • Estimated Labor Revenue—The estimated labor revenue (resource requirement hours * external rate(s)) at update.
  • Total Planned Labor Cost—The total planned labor cost (planned work hours * internal billing rate(s)) at update.
  • Total Planned Labor Revenue—The total planned labor revenue (planned work hours * external rate(s)) at update.
  • Total Estimated Cost—Total estimated cost at update.
• Work Hours
  • Estimated Work Hours—Total of all resource requirement type hours at update.
  • Total Scheduled Work Hours—Total scheduled work hours at update.
  • Total Actual Work Hours—Total actual work hours at update.
  • Minutes
    • Total Scheduled Work Minutes—The total scheduled work, shown in minutes.
    • Total Actual Work Minutes—The total actual work, shown in minutes.

   

• Schedule Data
  • Planned Schedule Start—Planned project start at update, based on task schedule.
  • Planned Schedule Finish—Planned project finish at update, based on task schedule.

  • Actual Schedule Start—Actual project start at update, based on task schedule.

  • Actual Schedule Finish—Actual project finish at update, based on task schedule.
• More Information
  • Health (numeric)—Health at update.
  • Priority (numeric)—Priority at update.
  • State (numeric)—Project state at update.
  • Approval Status (numeric)—Project approval status at update.
  • Schedule Lock Type (numeric)—Project schedule lock type at update.
  • 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.

  • WorkspaceHistoryID
  • WorkspaceID
  • OwnerID
  • ManagerID
  • EnterpriseID
  • ParentWorkspaceID
  • WorkspacePhaseID
  • WorkspaceTypeID
  • WorkspaceProposalID
  • WorkspaceCloseID
  • SummaryTaskID
  • UpdatedBy
  • WorkspaceStatusUpdateId
  • WorkspaceStatusUpdate WorkspaceID
  • WorkspaceStatusUpdate UpdatedBy
  • WorkspaceRequestTypeID
  • ScheduleLockedByID
• 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.
  • Project Status Updated On (UTC)—The date the status of the project was updated.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved