Resource Usage (Oracle Utilities Field Service Initiated)

This section describes data mapping for the following:

• Invoke Work and Asset Management Resource

• Map to Receive Request

• Receive Request 2

• Map to Invoke Work and Asset Management Equipment

• Map to Invoke Other Usage Details

• Receive Request 3

Invoke Work and Asset Management Resource

Mapping details for “Invoke Work and Asset Management Resource” activity are as shown in the table below:

Oracle Utilities Work and Asset Cloud Service			Invoke Oracle Utilities Work and Asset Management Equipment Request Message			DVM Mapping
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Work and Asset Management Column	Oracle Field Service Column	Comments
$XmlPayload		Outermosttag	W1-IntTMSDtl		Outermosttag
timeSheetDetails	$XmlPayload	Group	W1-IntTMSDtl	W1-IntTMSDtl	Group
			input	W1-IntTMSDtl	Group
			timeSheetDetails	input	Group
date	timeSheetDetails	Field	date	timeSheetDetails	Date
activityId	timeSheetDetails	Field	activityId	timeSheetDetails	String				Only if (not(contains($XmlPayload/timeSheetDetails/activityId, '-')))
mobileActivityId	timeSheetDetails	Field	mobileActivityId	timeSheetDetails	Field
employeeId	timeSheetDetails	Field	employeeId	timeSheetDetails	String
employeeExternalId	timeSheetDetails	Field	employeeExternalId	timeSheetDetails	String
craft	timeSheetDetails	Field	resourceTypeCode	timeSheetDetails	String
hours	timeSheetDetails	Field	hours	timeSheetDetails	Decimal
regularOvertime	timeSheetDetails	Field	regularOvertime	timeSheetDetails	String
overtimeType	timeSheetDetails	Field	overtimeType	timeSheetDetails	String				Only if ($XmlPayload/timeSheetDetails/overtimeType)
laborEarningType	timeSheetDetails	Field	laborEarningType	timeSheetDetails	String
shiftType	timeSheetDetails	Field	shiftType	timeSheetDetails	String
startDateTime	timeSheetDetails	Field	startDateTime	timeSheetDetails	Datetime
endDateTime	timeSheetDetails	Field	endDateTime	timeSheetDetails	Datetime
			travelTime	timeSheetDetails	Group
travelTime	timeSheetDetails	Field	$HH	travelTime	Field				Function : substring-before($XmlPayload/timeSheetDetails/travelTime,':')
	timeSheetDetails	Field	$MM	travelTime	Field				Function : substring-after($XmlPayload/timeSheetDetails/travelTime,':')
$travelTimeMinutes		Field	$travelTimeMinutes	travelTime	Decimal				Function : (($HH*60)+$MM)

Map to Receive Request

Mapping details for “Map to Receive Request” activity are as shown in the table below:

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
		Outermosttag	executeResponse		Outermosttag
			response-wrapper	executeResponse	Group
			responseCode	response-wrapper	String				Hardcoded as '200'

Receive Request 1

Mapping details for “Receive Request 1” activity are as shown in the table below:

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
		Outermosttag	executeResponse		Outermosttag
			response-wrapper	executeResponse	Group
			responseCode	response-wrapper	String				Hardcoded as '200'

Receive Request 2

Mapping details for “Receive Request 2” activity are as shown in the table below:

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
		Outermosttag	executeResponse		Outermosttag
			response-wrapper	executeResponse	Group
			responseCode	response-wrapper	String				Hardcoded as '400'

Map to Invoke Work and Asset Management Equipment

Mapping details for “Map to Invoke Work and Asset Management Equipment” activity are as shown in the table below:

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
$XmlPayload		Outermosttag	W1-IntODCDtl		Outermosttag
equipmentDetailsl	$XmlPayload	Group	W1-IntODCDtl	W1-IntODCDtl	Group
			input	W1-IntODCDtl	Group
			resourceChargeDetails	input	Group
date	equipementDetails	Field	chargeDate	resourceChargeDetails	Date
activityId	equipementDetails	Field	activityId	resourceChargeDetails	String				Only if (not(contains($XmlPayload/equipmentDetails/activityId, '-')))
mobileActivityId	equipementDetails	Field	mobileActivityId	resourceChargeDetails	Field
employeeExternalId	equipementDetails	Field	employeeExternalId	resourceChargeDetails	String
		Field	resourceClass						Hardcoded as W1EQ
resourceTypeCode	equipementDetails	Field	resourceTypeCode	resourceChargeDetails	String
quantity	equipementDetails	Field	quantity	resourceChargeDetails	Decimal

Map to Invoke Other Usage Details

Mapping details for “Map to Invoke Other Usage Details” activity are as shown in the table below:

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
$XmlPayload		Outermosttag	W1-IntODCDtl		Outermosttag
otherDetails	$XmlPayload	Group	W1-IntODCDtl	W1-IntODCDtl	Group
			input	W1-IntODCDtl	Group
			resourceChargeDetails	input	Group
date	otherDetails	Field	chargeDate	resourceChargeDetails	Date
activityId	otherDetails	Field	activityId	resourceChargeDetails	String				Only if (not(contains($XmlPayload/otherDetails/activityId, '-')))
mobileActivityId	otherDetails	Field	mobileActivityId	resourceChargeDetails	Field
employeeExternalId	otherDetails	Field	employeeExternalId	resourceChargeDetails	String
			resourceClass	resourceChargeDetails	String				Hardcoded as W1OT
resourceTypeCode	otherDetails	Field	resourceTypeCode	resourceChargeDetails	String
quantity	otherDetails	Field	quantity	resourceChargeDetails	Decimal

Receive Request 3

Mapping details for “Receive Request 3” activity are as shown in the table below:

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
		Outermosttag	executeResponse		Outermosttag
			response-wrapper	executeResponse	Group
			responseCode	response-wrapper	String				Hardcoded as '200'