Skip to main content
System StatusContact Support
VersionOne Community

Dim.NoteCategory

This feature is available in Enterprise and Ultimate editions.

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

Table Description

Column Name Description DataType
NoteCategoryKey Data Mart identifier for this data int
NoteCategoryOid VersionOne identifier for this data int
NoteCategoryName Name varchar
NoteCategoryOrder The order this value appears in the VersionOne dropdown list int
NoteCategoryAssetState State of the list value (Active or Closed) varchar
NoteCategoryCreateDateUTC Date and time this value was created datetime
NoteCategoryLastModifiedDateUTC Date and time this value was last modified datetime
NoteCategoryCreatedByKey Data Mart identifier of the Member who created this value int
NoteCategoryLastModifiedByKey Data Mart identifier of the Member who last modified this value int
NoteCategoryCreateDateKey Foreign Key to Dim.Date for the Create Date int
NoteCategoryLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?