Skip to main content
System StatusContact Support
VersionOne Community

Dim.AttachmentCategory

This feature is available in Enterprise and Ultimate editions.

This is a single select list of the values available in the Attachment Category dropdown. This table contains Type 1 data for the attachment category values you have configured in your VersionOne instance. Attachments are not exported. However since you can use this list as a custom fields on other assets we export these values.

Table Description

Column Name Description DataType
AttachmentCategoryKey Data Mart identifier for this data int
AttachmentCategoryOid VersionOne identifier for this data int
AttachmentCategoryName Name varchar
AttachmentCategoryOrder The order this value appears in the VersionOne dropdown list int
AttachmentCategoryAssetState State of the list value (Active or Closed) varchar
AttachmentCategoryCreateDateUTC Date and time this value was created datetime
AttachmentCategoryLastModifiedDateUTC Date and time this value was last modified datetime
AttachmentCategoryCreatedByKey Foreign Key to Dim.Member for the person who created this value int
AttachmentCategoryLastModifiedByKey Foreign Key to Dim.Member for the person who last modified this value int
AttachmentCategoryCreateDateKey Foreign Key to Dim.Date for the Create Date int
AttachmentCategoryLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?