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