Previous Topic: View_Contact_Full

Next Topic: View_Group

View_Contact_to_Environment

The following list of fields is a basic view of contacts and their environment (assets). This view is a view of the contact table (ca_contact), but is also joined with the owned resource table (ca_owned_resource) to get a list of all assets associated with a contact. This view may be joined with the View_Contact_Full view to get the contact type, service type, organizations and location of each contact. Or, this view may be joined with the individual tables to get that same information.

Field

Remarks

ca_contact.*

The ca_contact fields that are defined in the View_Contact_Full view definition.

asset_uuid

ca_owned_resource.own_resource_uuid: A binary-unique identifier for an asset in the ca_owned_resource table.

asset_name

ca_owned_resource.resource_name: The designated network name of this asset.