View Field Descriptions › View_Change_to_Assets

Previous Topic: View_Change

Next Topic: View_Change_to_Change_Act_Log

View_Change_to_Assets

The following list of fields is a basic view of change orders and their assets. The change request table (chg) is indirectly joined with the network resource table (ca_owned_resource) to get a list of each change order’s assets. This view may not list all change orders, particularly those that have no assets.

Field

Remarks

View_Change.*

All fields listed in the View_Change view defined earlier in this document.

assetID

ca_owned_resource.own_resource_uuid: The binary field which serves as the internal, unchanging unique identifier for an asset record.

asset_serial_num

ca_owned_resource.serial_number: The serial number for an asset record.

asset_class

ca_resource_class.name: A short description of the class to which an asset belongs.
ca_owned_resource.resource_class = ca_resource_class.id

asset_family

ca_resource_family.name: The family of assets to which this asset belongs.
ca_owned_resource.resource_class = ca_resource_class.id AND ca_resource_class.family_id = ca_resource_family.id

asset_name

ca_owned_resource.resource_name: The network name by which this asset is known.