Resources Route (Oracle Field Service Initiated)

This section describes data mapping for the following:

Resource Created/Updated Mapping

OIC Resource Created/Updated Request Message			DVM Mapping
Element Name	Parent Element	Type	DVM Name	Oracle Utilities Work and Asset Management Column	Oracle Field Service Column
notify_POST		Outermosttag
routeEvent	notify_POST
user	routeEvent	String
applicationId	routeEvent	String
eventType	routeEvent	String
routeDetails	routeEvent	Group
resourceId	resourceDetails	String
date	resourceDetails	String
routeChanges	resourceEvent	Group
activated	routeChanges	String
deactivated	routeChanges	String
reactivated	routeChanges	String
travelingTime	routeChanges	String
calendarTimeFrom	routeChanges	String
calendarTimeTo	routeChanges	String
calendarPoints	routeChanges	String
timeZone	routeChanges	String

Get OFS Resource Mapping

OIC Resource Created/Updated Request Message			OFSC GetResourceDetail Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	Oracle Utilities Work and Asset Management	Oracle Field Service Column
notify_POST		Outermosttag	canonical_GET		Outermosttag				GET Resource/Get Resource
resourceEvent	notify_POST		Template Parameters	canonical_GET	Group
user	resourceEvent	String
applicationId	resourceEvent	String
time	resourceEvent	String
eventType	resourceEvent	String
resourceDetails	resourceEvent	Group
resourceInternalId	resourceDetails	String
resourceId	resourceDetails	String	resourceId	TemplateParameters	String
name	resourceDetails	String
resourceType	resourceDetails	String
resourceChanges	resourceEvent	Group
resourceId	resourceChanges	String
organization	resourceChanges	String
resourceInternalId	resourceChanges	String
parentResource InternalId	resourceChanges	String
status	resourceChanges	String
parentResourceId	resourceChanges	String
resourceType	resourceChanges	String
name	resourceChanges	String
email	resourceChanges	String
phone	resourceChanges	String
language	resourceChanges	String
languageISO	resourceChanges	String
timeZoneDiff	resourceChanges	Integer
timeZone	resourceChanges	String
timeZoneIANA	resourceChanges	String
dateFormat	resourceChanges	String
timeFormat	resourceChanges	String
durationStatistics InitialRatio	resourceChanges	Double
durationStatistics InitialPeriod	resourceChanges	Integer
Resource_0x737063_type	resourceChanges	String
tech_photo	resourceChanges	Group
links	tech_photo	Group
rel	links	String
href	links	String
mediaType	links	String
gender	resourceChanges	String
credence	resourceChanges	String
wam_resource_ address	resourceChanges	String
wam_resource_ source	resourceChanges	String
wam_resource_ lastUpdateDttm	resourceChanges	String
nms_resource	resourceChanges	String
common_utilities_ resource_code	resourceChanges	String

Get NMS Instance URL Mapping

OFSC GetResourceDetail Response Message			OIC GetNMSInstanceURL Message			DVM Mapping
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	Property	Value
canonical_GETResponse		Outermosttag	execute		Outermosttag
resources.definitions.resource	canonical_GETResponse		QueryParameters	execute	Group
resourceId	resources.definitions.resource	String	resourceId	QueryParameters	String
			bucketDVM	QueryParameters	String	OUTL-BRT-NMS_OFSC_ConfigProps	findInstance.oic.LookupName	OUTL-BRT-NMS_OFSC_InstanceIDToBucket
			sourceColumn	QueryParameters	String	OUTL-BRT-NMS_OFSC_ConfigProps	findInstance.oic.LookupSourceColumnName	OFSC_ BucketID
			targetColumn	QueryParameters	String	OUTL-BRT-NMS_OFSC_ConfigProps	findInstance.oic.LookupTargetColumnName	NMS_ConnectionID
			notFoundValue	QueryParameters	String	OUTL-BRT-NMS_OFSC_ConfigProps	findInstance.oic.LookupNotFoundValue	NotFound

Put NMS Crew Shift Mapping

OIC Resource Created/Updated Request Message			NMS UpsertCrew Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	Oracle Utilities Work and Asset Management	Oracle Field Service Column
notify_POST		Outermosttag	execute		Outermosttag				setCrewOnShift
routeEvent	notify_POST		TemplateParameters	execute	Group
user	routeEvent	String	crewId	TemplateParameters	String
applicationId	routeEvent	String	request_wrapper	execute
eventType	routeEvent	String	onShift	request_wrapper	Boolean				true if routeEvent = 'routeActivated'
routeDetails	routeEvent	Group	when	request_wrapper	String				activated or deactivated datetime converted with timeZoneOffset to 'Z'
resourceId	resourceDetails	String
date	resourceDetails	String
routeChanges	resourceEvent	Group
activated	routeChanges	String
deactivated	routeChanges	String
reactivated	routeChanges	String
travelingTime	routeChanges	String
calendarTimeFrom	routeChanges	String
calendarTimeTo	routeChanges	String
calendarPoints	routeChanges	String
timeZone	routeChanges	String
OIC retrieveNMSinstanceURL Message Response
			ConnectivityProperties	execute
GETResponse		Outermosttag	Plugin	ConnectivityProperties
components.schemas.response-wrapper	GETResponse	Group
resourceValue	components.schemas.response-wrapper	String
resourceBucket	components.schemas.response-wrapper	String
targetValue	components.schemas.response-wrapper	String	ConnectionId	Plugin		OUTL-BRT-NMS_OFSC_InstanceIDToBucket	NMS_Instance URL		Retrieve NMS instanceId