CA APM/ITAM Integration Data Dictionary
AssetTrack to CA APM/ITAM Field Mappings
AssetTrack's out-of-box field mappings are shown below. In most cases, you can use AssetTrack with CA in this configuration. You can add additional extended fields to CA and create corresponding custom fields in AssetTrack to extend this list.
If you have heavily customized CA APM or Service Desk or require field mappings that aren't included in the default field list below, see Manually Configuring CA Integration using Dynamic Field Mapping for instructions on customizing the field mappings.
AssetTrack Field | AssetTrack Label | Connect API Property | UAPM MDB DB Field Name for Display to User | UAPM MDB DB Field Updated by AssetTrack |
|---|---|---|---|---|
Asset.AssetId | (Not shown) | ca_location.own_resource_uuid | ca_location.own_resource_uuid | |
Asset.Asset Tag | Asset Tag | Asset.AltAssetId | ca_owned_resource.resource_tag | ca_owned_resource.resource_tag |
Asset.SerialNumber | Serial Number | Asset.SerialNumber | ca_owned_resource.serial_number | ca_owned_resource.serial_number |
Asset.MacAddress | MAC | ca_owned_resource.mac_address | ca_owned_resource.mac_address | |
Asset.ServiceStatus | ServiceStatus | ca_resource_status.name | ca_resource_status.name | |
Asset.Status | Status | ca_resource_status.name | arg_assetver.avstatus | |
Asset.Location | Location | Asset.LocationID | ca_location.location_name | ca_owned_resource.locationid |
Asset.CAFloorLocation | Floor | ca_location.floor_location | ca_location.floor_location | |
Asset.CARoomLocation | Room | ca_location.room_location | ca_location.room_location | |
Asset.CACabinetLocation | Cabinet | ca_location.cabinet_location | ca_location.cabinet_location | |
Asset.CAShelfLocation | Shelf | ca_location.shelf_location | ca_location.shelf_location | |
Asset.CAShelfSlotLocation | Slot | ca_location.shelf_location | ca_location.shelf_location | |
Asset.Product.Name | Model | Item.Name | ca_model_def.name | ca_owned_resource.model_id |
Asset.Product.Manufacturer | Manufacturer | Asset.ManufacturersID | ca_company.name | ca_owned_resource.manufacturer_uuid |
Asset.Product.AssetType (Level 1) | Asset Type | Item.ItemType | ca_resource_family.name | ca_owned_resource.resource_family |
Asset.Product.AssetType (Level 2) | Asset Type | Item.ClassValue | ca_resource_class.name | ca_owned_resource.resource_class |
Asset.Organization | Organization | ca_resource_department.name | ca_owned_resource.maintenance_org_uuid OR ca_owned_resource.org_bought_for_uuid OR ca_owned_resource.responsible_org_uuid OR | |
Asset.PONumber | PO Number | Asset.Purchase Order | ca_owned_resource.purchase_order_id | ca_owned_resource.purchase_order_id |
Asset.AssetStatus | Status | AssetVersion.Status | ca_resource_status.name | arg_assetver.avstatus |
Asset.Assignee.FirstName | Contact | Asset.Contact | ca_contact.first_name | ca_owned_resource.contact_id |
Asset.Assignee.LastName | Contact | Asset.Contact | ca_contact.last_name | ca_owned_resource.contact_id |
Asset.Assignee.Code | Contact | Asset.Contact | ca_contact.alternate_identifier | ca_owned_resource.contact_id |
Asset.CostCenter | CostCenter | ca_resource_cost_center.cost_center_id | ca_resource_cost_center.name | |
Asset.GLCode | GLCode | ca_resource_gl_code.gl_code | ca_resource_gl_code.id |