Dim.NoteCategory
This is a single select list of the values available in the Note Category drop-down. This table contains Type 1 data for the note category values you have configured in your 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 drop-down 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 |