Dim.RequestStatus
Request assets in have an attribute called Status. This is a single select list used to indicate the Request Status (Reviewed, Approved). This table contains Type 1 data for the Request Status values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| RequestStatusKey | Data Mart identifier for this data | int |
| RequestStatusOid | Identifier for this data | int |
| RequestStatusName | Name | varchar |
| RequestStatusOrder | The order this value appears in the list | int |
| RequestStatusAssetState | State of the list value (Active or Closed) | varchar |
| RequestStatusCreateDateUTC | Date and time this value was created | datetime |
| RequestStatusLastModifiedDateUTC | Date and time this value was last modified | datetime |
| RequestStatusCreatedByKey | Data Mart identifier of the Member that created this value | int |
| RequestStatusLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| RequestStatusCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| RequestStatusLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |