Device Verification (Oracle Utilities Field Service Initiated)

This section describes data mapping for the following:

• Meter Request Mappings

• Meter Response Mappings

•

• Item Response Mappings

• ERT Request Mappings

• ERT Response Mappings

Meter Request Mappings

Request mapping for Meter details for each integration point are as shown in the table below.

Oracle Field Service Request Message			Oracle Utilities Service Order Management Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Management Column	Oracle Field Service Column
QueryParameters		outermosttag	D1-DeviceVerificationService		outermosttag
			requestMessage	D1-DeviceVerificationService
c2m_meter2_number	QueryParameters	string	badgeNumber	requestMessage					If c2m_meter2_number!=null else if c2m_new_item_nbr!=null, badgenumber mapped to c2m_new_item_nbr
c2m_service_pt_id	QueryParameters	string	servicePointId	requestMessage
			deviceVerificationType	requestMessage					Defaults to D1MR
c2m_SerialNumber	QueryParameters	string	serialNumber	requestMessage

Meter Response Mappings

Response mapping for Meter details for each integration point are as shown in the table below.

Oracle Utilities Service Order Management Response Message			Oracle Field Service Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Management Column	Oracle Field Service Column
D1-DeviceVerificationService		outermosttag	response-wrapper		outermosttag
responseMessage	D1-DeviceVerificationService	Group
verificationStatus
meterConfigurationType	responseMessage	string	c2m_meter1_type	response-wrapper	Enumeration	SOMOFSC_MeterConfigurationType	SOM_MeterConfigurationType	OFSC_MeterConfigurationType
deviceTypeDescription	responseMessage		c2m_newmeter_devicetypedescription	response-wrapper
errorCode	responseMessage	string
errorText	responseMessage	string	c2m_verifyStatusFlag	response-wrapper	String				When errorText!="" else c2m_verifyStatusFlag="VerificationSuccessful"
readingDetails	responseMessage	Group
readingDetailsList	readingDetails	List
meterConfigurationType	responseMessage	string	c2m_new_item_type	response-wrapper	Enumeration
readSequence	readingDetailsList[1]	string	c2m_meter1_read_seq	response-wrapper	Enumeration	OFSCSOM_ReadSequence	SOM_ReadSequence	OFSC_ReadSequence
unitOfMeasure	readingDetailsList[1]	string	c2m_meter1_uom	response-wrapper	Enumeration	OFSCSOM_UOM	SOM_UOM	OFSC_UOM
numberOfDials	readingDetailsList[1]	string	c2m_meter1_dials	response-wrapper	Enumeration	OFSCSOM_Dials	SOM_Dials	OFSC_Dials
lowerLimit	readingDetailsList[1]	string	c2m_meter1_lower_limit	response-wrapper	Integer				If lowerLimit!="" else c2m_meter1_lower_limit=0
upperLimit	readingDetailsList[1]	string	c2m_meter1_upper_limit	response-wrapper	Integer				If upperLimit!="" else c2m_meter1_upper_limit=0
timeOfUse	readingDetailsList[1]	string	c2m_meter1_TOU1	response-wrapper	Enumeration	OFSCSOM_TOU	SOM_TOU	OFSC_TOU
sqi	readingDetailsList[1]	string	c2m_meter1_sqi	response-wrapper	Enumeration	OFSCSOM_SQI	SOM_SQI	OFSC_SQI
numberOfDecimals	readingDetailsList[1]	string	c2m_meter1_numberofDecimals	response-wrapper	Enumeration	OFSCSOM_Decimals	SOM_Decimals	OFSC_Decimals
readSequence	readingDetailsList[2]	string	c2m_meter1_read_seq2	response-wrapper	Enumeration	OFSCSOM_ReadSequence	SOM_ReadSequence	OFSC_ReadSequence
unitOfMeasure	readingDetailsList[2]	string	c2m_meter1_uom2	response-wrapper	Enumeration	OFSCSOM_UOM	SOM_UOM	OFSC_UOM
numberOfDials	readingDetailsList[2]	string	c2m_meter1_dials2	response-wrapper	Enumeration	OFSCSOM_Dials	SOM_Dials	OFSC_Dials
lowerLimit	readingDetailsList[2]	string	c2m_meter1_lower_limit2	response-wrapper	Integer				If lowerLimit!="" else c2m_meter1_lower_limit=0
upperLimit	readingDetailsList[2]	string	c2m_meter1_upper_limit2	response-wrapper	Integer				If upperLimit!="" else c2m_meter1_upper_limit=0
timeOfUse	readingDetailsList[2]	string	c2m_meter1_TOU2	response-wrapper	Enumeration	OFSCSOM_TOU	SOM_TOU	OFSC_TOU
sqi	readingDetailsList[2]	string	c2m_meter1_sqi2	response-wrapper	Enumeration	OFSCSOM_SQI	SOM_SQI	OFSC_SQI
numberOfDecimals	readingDetailsList[2]	string	c2m_meter1_numberofDecimals2	response-wrapper	Enumeration	OFSCSOM_Decimals	SOM_Decimals	OFSC_Decimals
readSequence	readingDetailsList[3]	string	c2m_meter1_read_seq3	response-wrapper	Enumeration	OFSCSOM_ReadSequence	SOM_ReadSequence	OFSC_ReadSequence
unitOfMeasure	readingDetailsList[3]	string	c2m_meter1_uom3	response-wrapper	Enumeration	OFSCSOM_UOM	SOM_UOM	OFSC_UOM
numberOfDials	readingDetailsList[3]	string	c2m_meter1_dials3	response-wrapper	Enumeration	OFSCSOM_Dials	SOM_Dials	OFSC_Dials
lowerLimit	readingDetailsList[3]	string	c2m_meter1_lower_limit3	response-wrapper	Integer
upperLimit	readingDetailsList[3]	string	c2m_meter1_upper_limit3	response-wrapper	Integer
timeOfUse	readingDetailsList[3]	string	c2m_meter1_TOU3	response-wrapper	Enumeration	OFSCSOM_TOU	SOM_TOU	OFSC_TOU
sqi	readingDetailsList[3]	string	c2m_meter1_sqi3	response-wrapper	Enumeration	OFSCSOM_SQI	SOM_SQI	OFSC_SQI
numberOfDecimals	readingDetailsList[3]	string	c2m_meter1_numberofDecimals3	response-wrapper	Enumeration	OFSCSOM_Decimals	SOM_Decimals	OFSC_Decimals
readSequence	readingDetailsList[4]	string	c2m_meter1_read_seq4	response-wrapper	Enumeration	OFSCSOM_ReadSequence	SOM_ReadSequence	OFSC_ReadSequence
unitOfMeasure	readingDetailsList[4]	string	c2m_meter1_uom4	response-wrapper	Enumeration	OFSCSOM_UOM	SOM_UOM	OFSC_UOM
numberOfDials	readingDetailsList[4]	string	c2m_meter1_dials4	response-wrapper	Enumeration	OFSCSOM_Dials	SOM_Dials	SOM_Dials
lowerLimit	readingDetailsList[4]	string	c2m_meter1_lower_limit4	response-wrapper	Integer
upperLimit	readingDetailsList[4]	string	c2m_meter1_upper_limit4	response-wrapper	Integer
timeOfUse	readingDetailsList[4]	string	c2m_meter1_TOU4	response-wrapper	Enumeration	OFSCSOM_TOU	SOM_TOU	OFSC_TOU
sqi	readingDetailsList[4]	string	c2m_meter1_sqi4	response-wrapper	Enumeration	OFSCSOM_SQI	SOM_SQI	OFSC_SQI
numberOfDecimals	readingDetailsList[4]	string	c2m_meter1_numberofDecimals4	response-wrapper	Enumeration	OFSCSOM_Decimals	SOM_Decimals	OFSC_Decimals
readSequence	readingDetailsList[5]	string	c2m_meter1_read_seq5	response-wrapper	Enumeration	OFSCSOM_ReadSequence	SOM_ReadSequence	OFSC_ReadSequence
unitOfMeasure	readingDetailsList[5]	string	c2m_meter1_uom5	response-wrapper	Enumeration	OFSCSOM_UOM	SOM_UOM	OFSC_UOM
numberOfDials	readingDetailsList[5]	string	c2m_meter1_dials5	response-wrapper	Enumeration	OFSCSOM_Dials	SOM_Dials	SOM_Dials
lowerLimit	readingDetailsList[5]	string	c2m_meter1_lower_limit5	response-wrapper	Integer
upperLimit	readingDetailsList[5]	string	c2m_meter1_upper_limit5	response-wrapper	Integer
timeOfUse	readingDetailsList[5]	string	c2m_meter1_TOU5	response-wrapper	Enumeration	OFSCSOM_TOU	SOM_TOU	OFSC_TOU
sqi	readingDetailsList[5]	string	c2m_meter1_sqi5	response-wrapper	Enumeration	OFSCSOM_SQI	SOM_SQI	OFSC_SQI
numberOfDecimals	readingDetailsList[5]	string	c2m_meter1_numberofDecimals5	response-wrapper	Enumeration	OFSCSOM_Decimals	SOM_Decimals	OFSC_Decimals
readingDetailsList	readingDetails		c2m_enable_register	response-wrapper					Count of readingdetailslist
manufacturer	responseMessage	string	c2m_newmeter_manufacturer	response-wrapper	Enumeration
deviceId	responseMessage		c2m_new_meter_serial	response-wrapper
model	responseMessage	string	c2m_newmeter_model	response-wrapper	Enumeration
ODM Activities Support
validServiceHistoryTypes	deviceDetails		c2m_dev_valid_service_history_types	response-wrapper	String
serviceHistoryTypes	responseMessage		c2m_dev_service_history_types1	response-wrapper	String

Item Request Mappings

Request mapping for Item details for each integration point are as shown in the table below:

Oracle Field Service Request Message			Oracle Utilities Service Order Management Request			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Column	Oracle Field Service Column
QueryParameters		outermosttag	D1-ItemVerificationService		outermosttag
			requestMessage	D1-ItemVerificationService
c2m_new_item_nbr	QueryParameters	string	badgeNumber	requestMessage	string				If c2m_new_item_nbr!=null, badgenumber mapped with c2m_new_item_nbr and item flow is called
c2m_service_pt_id	QueryParameters	string	servicePointId	requestMessage	string
c2m_SerialNumber	QueryParameters	string	serialNumber	requestMessage	string				Serial number is a conditional mapping and it will be mapped only if it is received from OFSC.

Item Response Mappings

Response mapping for Item details for each integration point are as shown in the table below:

Oracle Utilities Service Order Management Response Message			Oracle Field Service Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Column	Oracle Field Service Column
D1-ItemVerificationService		outermosttag	response-wrapper		outermosttag
responseMessage	D1-ItemVerificationService	Group
verificationStatus
errorCode
errorText	responseMessage	string	c2m_verifyStatusFlag	response-wrapper	string				When errorText!="" else map c2m_verifyStatusFlag='Verification Successful'
meterConfigurationType	responseMessage		c2m_new_item_type	response-wrapper
manufacturer	responseMessage	string	c2m_newitem_manufacturer		string				Maps the SOM manufacturer information to OFSC manufacturer
model	responseMessage	string	c2m_newitem_model		string				Maps the SOM model information to OFSC model
itemId	responseMessage		c2m_new_item_id	response-wrapper
Oracle Utilities Operational Device Management Activities Support
validServiceHistoryTypes	deviceDetails		c2m_dev_valid_service_history_types	response-wrapper	String
serviceHistoryTypes	responseMessage		c2m_dev_service_history_types1	response-wrapper	String

ERT Request Mappings

Request mapping for ERT details for each integration point are as shown in the table below:

Oracle Field Service Request Message			Oracle Utilities Service Order Management Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Column	Oracle Field Service Column
QueryParameters		outermosttag	D1-DeviceVerificationService		outermosttag
			requestMessage	D1-DeviceVerificationService
c2m_ert_badgeNumber	QueryParameters	string	badgeNumber	requestMessage					If c2m_meter2_number!=null else if c2m_new_item_nbr!=null, badgenumber mapped to c2m_new_item_nbr
c2m_ert_serialNumber	QueryParameters	string	serialNumber	requestMessage
verificationType	QueryParameters	string	deviceVerificationType	requestMessage
ertAttachedTo	QueryParameters	string	attachedTo	requestMessage

ERT Response Mappings

Request mapping for ERT details for each integration point are as shown in the table below:

Oracle Utilities Service Order Management Response Message			Oracle Field Service Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Column	Oracle Field Service Column
D1-DeviceVerificationService		outermosttag	response-wrapper		outermosttag
responseMessage	D1-DeviceVerificationService	Group
verificationStatus
errorCode	responseMessage	string
errorText	responseMessage	string	c2m_verifyStatusFlag	response-wrapper	String				When errorText!="" else c2m_verifyStatusFlag="VerificationSuccessful"
readingDetails	responseMessage	Group
equipmentId	responseMessage		c2m_ert_equipmentId	response-wrapper	String
badgeNumber	responseMessage	string	c2m_ert_badgeNumber	response-wrapper	String
serialNumber	responseMessage	string	c2m_ert_serialNumber	response-wrapper	String
deviceTypeDescription	responseMessage	string	c2m_ert_dev_description	response-wrapper	String
Oracle Utilities Operational Device Management Activities Support
validServiceHistoryTypes	deviceDetails		c2m_equip_valid_service_history_types	response-wrapper	String
serviceHistoryTypes	responseMessage		c2m_equip_service_history_types1	response-wrapper	String