Source of Voyager ITEM_VW view's Item Type and Location fields
- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
Question
In the ITEM_VW view in Voyager Access Reports, where are the item type fields and the location fields (i.e., the gov_item_type and gov_location fields) sourced?
Answer
The gov_item_type fields are the item record’s current type, in other words, the temporary item type, if there is one, otherwise the permanent item type. Similarly, the gov_location fields are the item record’s temporary location, if there is one, otherwise the permanent location
Additional Information
The gov_item_type and gov_location fields appear in many tables. Their definitions are always the same:
- The gov_item_type fields are the item’s current type, in other words, the temp item type, if there is one, otherwise the item type.
- The gov_location fields are the item’s temp location, if there is one, otherwise the perm location.
- Article last edited: 12-Oct-2020