Customer Data Synchronization Process

This section provides mapping details for the following:

• Customer Data Synchronization Process Mapping

• Customer Data Synchronization Request Message Mapping

• Customer Data Synchronization Response Mapping

Refer to the Customer Data Synchronization Process description for processing details on this integration point.

Customer Data Synchronization Process Mapping

Oracle Utilities Network Management System Field	Oracle Utilities Customer Care and Billing Element Name	Notes
Device ID device_ID	deviceId	• Device ID provide must exist in the NMS supply nodes table. • From CCB, obtain from geo value that matches with Geo Type set up for Device ID in CCB Feature configuration schema constants • From CCB SP Geo Table (CI_SP_GEO).
Account Type account_type	serviceType	• Account Type provide must exist in the Account Type Table in NMS. • Use DVM OUCCB_OUNMS_ AccountType.
Creation Timestamp creation_time		• Timestamp for the record's creation. NMS stored proc will put the current date time on for new records inserted. • Not mapped by the integration.
Active Flag active	Y or N (populated by the integration)	• Flag identifying currently active records. Y - For Current Customers N - For Inactive customers • If the customer ID is not populated in the message, the integration set it to N, otherwise it is always Y.
Customer ID cust_ID	accountId	• Unique external system generated primary key. • CCB Account must be linked to a metered service point via active service agreement. • From CCB Account Table (CI_ACCT)
Customer Account Number cust_account_number	accountId	From CCB Account Table (CI_ACCT)
Customer Name cust_name	Name	• This is the primary person linked to the account. • If it is a Person, it contains the concatenation of last, first and middle names. • If it is a business, contains the business name. • From CCB Person Name Table (CI_PER_NAME).
Customer Home Phone Area Code cust_home_area_code	First 3 number of homePhone	• Get Area Code from CCB homePhone element. • homePhone retrieved from CCB depends on the home phone type defined in CCB feature configuration schema constants. • From CCB Person Phone Table (CI_PER_PHONE).
Customer Home Phone cust_home_phone	From fourth to tenth number of homePhone	• Get Phone Number from CCB homePhone element. • homePhone retrieved from CCB depends on the home phone type defined in CCB feature configuration schema constants. • From CCB Person Phone Table (CI_PER_PHONE).
Customer Day Phone Area Code cust_day_area_code	First 3 number of businessPhone	• Get Area Code from CCB businessPhone. • businessPhone retrieved from CCB depends on the home phone type defined in CCB feature configuration schema constants. • From CCB Person Phone Table (CI_PER_PHONE)
Customer Day Phone cust_day_phone	From fourth to tenth number of businessPhone	• Get Phone Number from CCB businessPhone. • businessPhone retrieved from CCB depends on the home phone type defined in CCB feature configuration schema constants. • From CCB Person Phone Table (CI_PER_PHONE).
Customer Day Phone Extension cust_day_phone_ext	Extension	• This is the extension for the CCB businessPhone. • From CCB Person Phone Table (CI_PER_PHONE).
Customer Address 1 cust_address1	address 1	From CCB Premise Table (CI_PREM)
Customer Address 2 cust_address2	address 2	From CCB Premise Table (CI_PREM)
Customer Address 3 cust_address3	address 3	From CCB Premise Table (CI_PREM)
Customer Address 4 cust_address4	address 4	From CCB Premise Table (CI_PREM)
Customer City cust_city	City	From CCB Premise Table (CI_PREM)
Customer State cust_state	State	From CCB Premise Table (CI_PREM)
Customer Postcode 1 cust_postcode1	Postal	From CCB Premise Table (CI_PREM)
Premise ID serv_premise_ID	premiseId	• Unique external system generated primary key. • From CCB Premise Table (CI_PREM)
Service Account Number serv_account_number	accounted	• Account number linked to the premise ID. • From CCB Account Table (CI_ACCT)
Service Life Support serv_life_support	lifeSupport	• If the CCB premise or person life support/sensitive load flag is true, this will also be set to true. • Use DVM OUCCB_OUNMS_ LifeSupportInd
Service Address 1 serv_address1	address 1	From CCB Premise Table (CI_PREM)
Service Address 2 serv_address2	address 2	From CCB Premise Table (CI_PREM)
Service Address 3 serv_address3	address 3	From CCB Premise Table (CI_PREM)
Service Address 4 serv_address4	address 4	From CCB Premise Table (CI_PREM)
Service City serv_city	City	From CCB Premise Table (CI_PREM)
Service State serv_state	State	From CCB Premise Table (CI_PREM)
Service City State serv_city_state	Concatenate city, state	The delimiter that the integration uses for concatenation will always be (,) comma.
Service Postal serv_postcode1	Postal	From CCB Premise Table (CI_PREM)
Service D Priority serv_d_priority	medicalPriority	• D (critical) customers flag values in NMS, 0 or 1. • D Priority retrieved from premise characteristics depends on the char type defined from CCB feature configuration schema constants. • From Premise Characteristic Table (CI_PREM_CHAR). • Use DVM OUCCB_OUNMS_Serv_D_Priority.
Service C Priority serv_c_priority	criticalPriority	• C customers flag values in NMS, 0 or 1. • C Priority retrieved from premise characteristics depends on the char type defined from CCB feature configuration. • From Premise Characteristic Table (CI_PREM_CHAR). • Use DVM OUCCB_OUNMS_Serv_C_Priority.
Service K Priority serv_k_priority	keyPriority	• K customers flag values in NMS, 0 or 1. • K Priority retrieved from premise characteristics depends on the char type defined from CCB feature configuration. • From Premise Characteristic Table (CI_PREM_CHAR). • Use DVM OUCCB_OUNMS_Serv_K_Priority.
Meter ID meter_ID	meterId	From CCB Meter Table (CI_MTR)
Meter Number meter_number	badgeNumber	From CCB Meter Table (CI_MTR)
Meter Type meter_type	meterType	• From CCB Meter Table (CI_MTR) • Use DVM OUCCB_OUNMS_ MeterType.
Meter Manufacturer meter_manufacturer	Manufacturer	From CCB Meter Table (CI_MTR)

Customer Data Synchronization Request Message Mapping

Oracle Utilities Customer Care and Billing SP Sync Request Message			Oracle Utilities Network Management System Stored Procedure Inputs
Element Name	Parent Element	Type	Element Name	DVM Mapping
C1-NMSSPSyncRequest		Outermost Tag
syncRequestId	C1-NMSSPSyncRequest	Field
bo	C1-NMSSPSyncRequest	Field
boStatus	C1-NMSSPSyncRequest	Field
createDateTime	C1-NMSSPSyncRequest	Field
statusDateTime	C1-NMSSPSyncRequest	Field
version	C1-NMSSPSyncRequest	Field
syncRequired	C1-NMSSPSyncRequest	Field
forceSync	C1-NMSSPSyncRequest	Field
discardReason	C1-NMSSPSyncRequest	Field
cancelReason	C1-NMSSPSyncRequest	Field
message	C1-NMSSPSyncRequest	List
sequence	message	Field
messageCategory	message	Field
messageNumber	message	Field
comment	message	Field
messageParameters	message	List
parameterSequence	messageParameters	Field
messageParameterValue	messageParameters	Field
mo	C1-NMSSPSyncRequest	Field
pkValue1	C1-NMSSPSyncRequest	Field
pkValue2	C1-NMSSPSyncRequest	Field
pkValue3	C1-NMSSPSyncRequest	Field
pkValue4	C1-NMSSPSyncRequest	Field
pkValue5	C1-NMSSPSyncRequest	Field
personBO	C1-NMSSPSyncRequest	Field
accountBO	C1-NMSSPSyncRequest	Field
saBO	C1-NMSSPSyncRequest	Field
spBO	C1-NMSSPSyncRequest	Field
premiseBO	C1-NMSSPSyncRequest	Field
meterBO	C1-NMSSPSyncRequest	Field
itemBO	C1-NMSSPSyncRequest	Field
spTypeBO	C1-NMSSPSyncRequest	Field
snapshotDA	C1-MDM1SPSyncRequest	Field
postScript	C1-MDM1SPSyncRequest	Field
syncRequestDetails	C1-MDM1SPSyncRequest	Group
initialSnapshot	syncRequestDetails	Group
personInfo	initialSnapshot	Group
personId	personInfo	Field
name	personInfo	Field
homePhone	personInfo	Field
businessPhone	personInfo	Field
extension	personInfo	Field
lifeSupport	personInfo	Group
customElements	personInfo	Group
accountInfo	initialSnapshot	Group
accountId	accountInfo	Field
mainPerson	accountInfo	Field
customElements	accountInfo	Group
saInfo	initialSnapshot	Group
saId	saInfo	Field
accountId	saInfo	Field
customElements	saInfo	Group
spInfo	initialSnapshot	Group
spId	spInfo	Field
premiseId	spInfo	Field
spType	spInfo	Field
deviceId	spInfo	Field
serviceType	spInfo	Field
customElements	spInfo	Group
premiseInfo	initialSnapshot	Group
premiseId	premiseInfo	Field
country	premiseInfo	Field
address1	premiseInfo	Field
address2	premiseInfo	Field
address3	premiseInfo	Field
address4	premiseInfo	Field
houseType	premiseInfo	Field
number1	premiseInfo	Field
number2	premiseInfo	Field
inCityLimit	premiseInfo	Field
city	premiseInfo	Field
geographic	premiseInfo	Field
county	premiseInfo	Field
state	premiseInfo	Field
postal	premiseInfo	Field
criticalPriority	premiseInfo	Field
medicalPriority	premiseInfo	Field
keyPriority	premiseInfo	Field
lifeSuport	premiseInfo	Field
customElements	premiseInfo	Group
meterInfo	initialSnapshot	Group
meterId	meterInfo	Field
badgeNumber	meterInfo	Field
meterType	meterInfo	Field
manufacturer	meterInfo	Field
customElements	meterInfo	Group
itemInfo	initialSnapshot	Group
itemId	itemInfo	Field
badgeNumber	itemInfo	Field
itemType	itemInfo	Field
manufacturer	itemInfo	Field
customElements	itemInfo	Group
customElements	initialSnapshot	Group
finalSnapshot	syncRequestDetails	Group
personInfo	finalSnapshot	Group
personId	personInfo	Field
name	personInfo	Field	cust_name
homePhone	personInfo	Field	cust_home_area_code, cust_home_phone
businessPhone	personInfo	Field	cust_day_area_code, cust_day_phone
extension	personInfo	Field	cust_day_phone_ext
lifeSupport	personInfo	Group	serv_life_support	OUCCB_OUNMS_ LifeSupportIndicator
customElements	personInfo	Group
accountInfo	finalSnapshot	Group
accountId	accountInfo	Field
mainPerson	accountInfo	Field
customElements	accountInfo	Group
saInfo	finalSnapshot	Group
saId	saInfo	Field
accountId	saInfo	Field	cust_ID , cust_account_number, serv_account_number
customElements	saInfo	Group
spInfo	finalSnapshot	Group
spId	spInfo	Field	service_point_ID
premiseId	spInfo	Field
spType	spInfo	Field
deviceId	spInfo	Field	device_ID
serviceType	spInfo	Field	account_type	OUCCB_OUNMS_ AccountType
customElements	spInfo	Group
premiseInfo	finalSnapshot	Group
premiseId	premiseInfo	Field	serv_premise_ID
country	premiseInfo	Field
address1	premiseInfo	Field	cust_address1, serv_address1
address2	premiseInfo	Field	cust_address2, serv_address2
address3	premiseInfo	Field	cust_address3, serv_address3
address4	premiseInfo	Field	cust_address4, serv_address4
houseType	premiseInfo	Field
number1	premiseInfo	Field
number2	premiseInfo	Field
inCityLimit	premiseInfo	Field
city	premiseInfo	Field	cust_city, serv_city, serv_city_state
geographic	premiseInfo	Field
county	premiseInfo	Field
state	premiseInfo	Field	cust_state, serv_state, serv_city_state
postal	premiseInfo	Field	cust_postcode1
criticalPriority	premiseInfo	Field	serv_c_priority	OUCCB_OUNMS_Serv_C_Priority
medicalPriority	premiseInfo	Field	serv_d_priority	OUCCB_OUNMS_Serv_D_Priority
keyPriority	premiseInfo	Field	serv_k_priority	OUCCB_OUNMS_Serv_K_Priority
lifeSuport	premiseInfo	Field	serv_life_support
customElements	premiseInfo	Group
meterInfo	finalSnapshot	Group
meterId	meterInfo	Field	meter_ID
badgeNumber	meterInfo	Field	meter_number
meterType	meterInfo	Field	meter_type	OUCCB_OUNMS_ MeterType
manufacturer	meterInfo	Field	meter_manufacturer
customElements	meterInfo	Group
itemInfo	finalSnapshot	Group
itemId	itemInfo	Field
badgeNumber	itemInfo	Field
itemType	itemInfo	Field
manufacturer	itemInfo	Field
customElements	itemInfo	Group
customElements	finalSnapshot	Group

Customer Data Synchronization Response Mapping

Mapping details for Customer Data Synchronization Response are shown in the table below:

OUCCB Customer SP Sync Request Message OUNMS Create/Update Customer Stored Procedure Output			OUCCB F1-UpdateAndTransitionSyncRequest Message
Element Name	Parent Element	Type	Element Name	DVM Name	Comments
sendDetails		OuterMost Tag	F1- UpdateAndTransitionSync Request
syncRequestId	sendDetails	Field	syncRequestId
OutputParameters	C1-NMSSPSyncRequest	Outermost Tag
P_ERR_NO	OutputParameters	Field
			exceptionInfo
			messageCategory		Send CCB.Generic.MessageCategory property value defined in OUCCBOUNMSConfigurationProperties.xml file.
			messageNumber		Send CCB.Generic.MessageCategory property value defined in OUCCBOUNMSConfigurationProperties.xml file.
P_ERR_MSG	OutputParameters	Field	comments
			messageParameters
			parameterSequence		'1'
P_ERR_MSG	OutputParameters	Field	messageParameterValue