AssetTrack to CA APM 11.3.4 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 |