Data Model-Project Information, Issues

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

• Issue Name—The name of the issue.
• Description—The text description of the issue.
• Start Date—The issue start date.
• Deadline—The issue deadline.
• Issue Current Status—The current status of the issue.
• Priority—The priority of the issue. Options are High, Medium and Low.
• Issue Count—The count of issues included in the report. This value only counts issues in the report, so it changes as you add/remove items that impact how many issues are included in the report.
• Budget Impact—The budget impact of the issue.
• Issue Percent Complete—The percent complete of the issue.
• Issue Folder Name—The name of the folder in which the issue is stored.
• Assigned To Name—The name of the person to whom the issue is assigned.
• Is Restricted—Whether or not view of the issue is restricted. Options are Yes and No.
• Issue Created By—The name of the user who created the issue.
• Issue Created On—The date the issue was created.
• Last Update Date—The date the last update was made to the issue.
• Update History 
  • Update By—The name of the user who updated the issue.
  • Update Notes—Notes added during the update.
  • Status at Update—The issue status at the time of the update.
  • Percent Complete—The issue percent complete at the time of the update.
  • Entry On—The date of the issue update.

   

• 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.

  • IssueItemID
  • CategoryID
  • OwnerID
  • ParentWorkspaceID
  • ParentAppInstanceID
  • ParentFolderID
  • ParentItemID
  • ParentItemTypeID
  • ResponseOwnerID

   

• UTC Dates

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

  • Issue Created On (UTC)—The date the issue was created.
  • Response Created On (UTC)—The date the issue response was created.

   

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved