Data Model-Project Information, Documents

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

• Documents
  • Document Title—The file name of the document.
  • Extension—The extension type of the document. For example, EXE or TXT.
  • Document Description—The text description of the document.
  • Version—The PPM version of the document.
  • Document Folder Name—The folder in which the document is stored.
  • Document Count—A count of the number of documents in the current report. This number changes dynamically as you add or remove query items.
  • Size—The size of the document in bytes.
  • Document Status—The status of the document. Options are Draft (the default) and Final.
  • Last Modified On—The date the document was last modified.
  • Expiration Date—The date on which the document expires (if applicable).
  • Mime Type—The mime type of the document.
  • Is Locked—Whether or not the document is locked. If a document is locked only the creator has access to it. Options are No (the default) and Yes.
  • Last Event—The last event related to the document. For example, Document Added (when the document is first added to PPM), Document Item Edit (when an edit is made to some aspect of the document in PPM such as updating the document description), and Approval Submitted (when a document is submitted for approval).
  • Last Uploaded By—The PPM user who last uploaded the document.
  • Last Uploaded Date—The date the document was last uploaded.
  • Last Access Date—The date the document was last accessed within PPM.
  • Is Restricted—Whether or not the document is restricted. Options are No (the default) and Yes.
  • Owner—The owner of the document.
  • Created On—The date the document was created.
  • Check in/out Information
    • Last Checked Out By—The name of the user who checked out the document (if applicable).
    • Last Checked Out On—The date the document was checked out.
    • Expected Return Date—The expected date the document will be checked in.
    • Check In Comments—Any comments added when the document was checked in.
    • Check Out Comments—Any comments added when the document was checked out.

     

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

    • DocumentItemID
    • CurrentVersionID
    • CheckoutVersionID
    • LastCheckedOutBy
    • LastUploadedBy
    • OwnerID
    • ParentWorkspaceID
    • ParentAppInstanceID
    • ParentFolderID
    • ParentItemID
    • ParentItemTypeID
    • EnterpriseDocumentID
  • UTC Dates

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

    • Last Modified On (UTC)—The date the document was last modified.
    • Last Accessed On (UTC)—The date the document was last accessed.
    • Expiration Date (UTC)—
    • Last Uploaded On (UTC)—The date the document was last uploaded to PPM.
    • Created On (UTC)—The date the document was added to PPM.
    • Last Checked Out On (UTC)—The date the document was last checked out in PPM.

   

• Document History 
  
  • Document Title—The name of the document.
  • Extension—The extension of the document file. For example, xls, txt or doc.
  • Document Description—The description of the document.
  • Version—The PPM version of the document.
  • Folder—The folder in which the document exists. The default folder is Documents.
  • Document Count—A count of the number of documents in the current report. This number changes dynamically as you add or remove query items to your report.
  • Size—The size of the document in bytes.
  • Document Status—The status of the document. Possible values include Draft (the default) and Final.
  • Modified On—The date the document was modified.
  • Mime Type—The mime type of the document.
  • Event—The event that caused the creation of a document history record. For example, when a document is added to PPM, the event is Document Added. When a document is submitted for approval, the event is Approval Submitted.
  • Uploaded By—The name of the PPM user who uploaded the document.
  • Uploaded Date—The date the document was uploaded.
  • Access Date—The date the document was accessed.
  • Is Restricted—Whether or not access to the document is restricted. Options are No (the default) and Yes.
  • Approval Status—The approval status of the document. Options are Pending, Approved, Rejected, Not Required, and Overridden.
  • Owner—The owner of the document.
  • Created On—The date the document was added to PPM.
  • History Update Comments—Update comments added when the document was updated.
  • Check in/out Information
    • Checked Out By—User who checked out the document.
    • Checked Out On—Date the document was checked out.
    • Check In Comments—Comments added when the document was checked in.
    • Check Out Comments—Comments added when the document was checked out.

     

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

    • DocumentItemID
    • CurrentVersionID
    • CheckoutVersionID
    • LastCheckedOutBy
    • LastUploadedBy
    • OwnerID
    • ParentWorkspaceID
    • ParentAppInstanceID
    • ParentFolderID
    • ParentItemID
    • ParentItemTypeID
    • EnterpriseDocumentID
    • Expiration Date

     

  • UTC Dates

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

    • Last Modified On (UTC)—
    • Last Accessed On (UTC)—
    • Expiration Date (UTC)—
    • Last Uploaded On (UTC)—
    • Created On (UTC)—
    • Last Checked Out On (UTC)—

     

   

• Documents Last Updated this Week—A filter that limits the report to documents with that Last Updated date that falls within the current week.
• Documents Last Updated (prompt)—A filter that allows the user to select a beginning and an end date. The filter prompts for the date range at run-time and limits the report to documents that were last updated between the dates selected.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved