View_Contact_Full

All contacts, including their contact type, location, organizations, and service types

View_Contact_to_Environment

All contacts and their environment (assets)

View_Group

All the groups defined in the database

View_Group_To_Contact

All contacts (including managers) within their group assignments

View_Request

All requests, including their service types, severities, urgencies, categories, assets, impact numbers, assignees by name, customers by name, groups, statuses, and priorities

View_Act_Log

The request activity log information, including activity type and analyst name

View_Request_to_Act_Log

All requests with their activity logs (this view joins View_Request and View_Act_Log)

View_Request_to_Properties

Requests and their properties (this may not include all requests, especially if no properties are assigned to them)

View_Change

All change orders, including their statuses, priorities, categories, organizations, affected end users by name, requesters by name, assignees by name, groups, service types, and impact numbers

View_Change_Act_Log

The change order activity log information

View_Change_to_Change_Act
_Log

All change orders with their activity logs (this view joins View_Change and View_Change_Act_Log)

View_Change_to_Properties

Change orders and their properties (this may not include all change orders, especially if no properties are assigned to them)

View_Change_to_Change_WF

Change orders and their workflow tasks (this may not include all change orders, especially if no workflow tasks are assigned to them)

View_Change_to_Assets

Change orders and their assets (this may not include all change orders, especially if they have no assets)

View_Change_to_Requests

Change orders with basic information about attached requests (this view joins View_Change and the Call_Request table, which may not include all change orders—especially if no requests are attached to them)

View_Issue

All issues, including their statuses, priorities, categories, organizations, affected end users by name, assignees by name, groups, service types, and so on

View_Issue_Act_Log

The issue activity log information

View_Issue_to_Issue_Act_Log

All issues with their activity logs (this view joins View_Issue and View_Issue_Act_Log)

View_Issue_to_Properties

Issues and their properties (this may not include all issues, especially if no properties are assigned to them)

View_Issue_to_Issue_WF

Issues and their workflow tasks (this may not include all issues, especially if no workflow tasks are assigned to them)

View_Issue_to_Assets

Issues and their assets (this may not include all issues, especially if they have no assets)