Dim.ClassOfService
Story assets in Agility have an attribute called Class of Service. This is a single select list used to indicate the Class of Service. This table contains Type 1 data for the Class of Service list values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| ClassOfServiceKey | Data Mart identifier for this data | int |
| ClassOfServiceOid | VersionOne identifier for this data | int |
| ClassOfServiceName | Name | nvarchar |
| ClassOfServiceOrder | The order this value appears in the VersionOne drop-down list | int |
| ClassOfServiceAssetState | State of the list value | varchar |
| ClassOfServiceCreateDateUTC | Date and time this value was created | datetime |
| ClassOfServiceLastModifiedDateUTC | Date and time this value was last modified | datetime |
| ClassOfServiceCreatedByKey | Data Mart identifier of the Member that created this value | int |
| ClassOfServiceLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| ClassOfServiceCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| ClassOfServiceLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |