Oracle Utilities Responsys CCB Contact Create (Child Flow)
The mapping details for Oracle Utilities Responsys CCB Contact Create (Child Flow) are as shown in the table below:
Responsys CED (EMAIL SENT)
CCB Create Customer Contact API
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
 
 
CUSTOMER_ID
 
Field
externalCCId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe “|” symbol. GUID is mapped to this field.
 
For example: The highlighted value is mapped: “2d343934353135363230323936303338||UNPLN_ERT|0172421206”
CUSTOMER_ID
 
Field
ccId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe “|” symbol. CCid is mapped to this field.
 
For example: The highlighted value is mapped: “2d343934353135363230323936303338|1312312|UNPLN_ERT|0172421206”
CUSTOMER_ID
 
Field
personId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe “|” symbol. Personid is mapped to this field.
 
For example: The highlighted value is mapped: “2d343934353135363230323936303338||UNPLN_ERT|0172421206”
CUSTOMER_ID
 
Field
notificationType
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. NotificationType is mapped to this field.
 
For example: The highlighted value is mapped: “2d343934353135363230323936303338||UNPLN_ERT|0172421206”
 
 
Field
status
 
Field
OUTL-BRT-NOTIFHUB_CustContactStatus
 
EVENT_CAPTURED_DT
 
Field
eventCapturedDateTime
 
Field
 
 
 
 
 
 
customerContactIdentifier
List
 
customerContactIdentifier may contain the key value pair.
RIID
 
 
externalRefId
 
 
 
 
C1NS
 
Value
identifierType
 
 
 
IdentifierType contains C1NS
 
 
 
 
customerContactIdentifier
List
 
CUSTOMER_ID or externalCCid
CUSTOMER_ID
 
 
externalRefId
 
 
 
 
C1EX
 
Value
identifierType
 
 
 
IdentifierType contains C1EX
 
 
Responsys CED (SMS SENT)
CCB Create Customer Contact API
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
 
 
CUSTOMER_ID
 
Field
externalCCId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. GUID is mapped to this field.
 
Example: The highlighted value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
ccId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. CCid is mapped to this field.
 
Example: The highlighted value is mapped: "2d343934353135363230323936303338|1312312|UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
personId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Personid is mapped to this field.
 
Example: The highlighted value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
notificationType
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. NotificationType is mapped to this field.
 
Example: The highlighted value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
 
 
Field
status
 
Field
OUTL-BRT-NOTIFHUB_CustContactStatus
 
EVENT_
CAPTURED_DT
 
Field
eventCapturedDateTime
 
Field
 
 
 
 
 
 
customerContactIdentifier
List
 
customerContactIdentifier may contain the key value pair.
RIID
 
 
externalRefId
 
 
 
 
C1NS
 
Value
identifierType
 
 
 
IdentifierType contains C1NS
 
 
 
 
customerContactIdentifier
List
 
CUSTOMER_ID or externalCCid
CUSTOMER_ID
 
 
externalRefId
 
 
 
 
C1EX
 
Value
identifierType
 
 
 
IdentifierType contains C1EX
 
 
Responsys CED (EMAIL FAILED)
CCB Create Customer Contact API
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
 
 
CUSTOMER_ID
 
Field
externalCCId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. GUID is mapped to this field.
 
Example: The highlighted value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
ccId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. CCid is mapped to this field.
 
Example: The highlighted value is mapped: "2d343934353135363230323936303338|1312312|UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
personId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Personid is mapped to this field.
 
Example: The highlighted value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
notificationType
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. NotificationType is mapped to this field.
 
Example: The highlighted value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
REASON
 
 
reason
 
Field
 
 
 
 
Field
status
 
Field
OUTL-BRT-NOTIFHUB_CustContactStatus
 
EVENT_CAPTURED_DT
 
Field
eventCapturedDateTime
 
Field
 
 
 
 
 
 
customerContactIdentifier
List
 
customerContactIdentifier may contain the key value pair.
RIID
 
 
externalRefId
 
 
 
 
C1NS
 
Value
identifierType
 
 
 
IdentifierType contains C1NS
 
 
 
 
customerContactIdentifier
List
 
CUSTOMER_ID or externalCCid
CUSTOMER_ID
 
 
externalRefId
 
 
 
 
C1EX
 
Value
identifierType
 
 
 
IdentifierType contains C1EX
 
 
Responsys CED (EMAIL SKIPPED)
CCB Create Customer Contact API
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
 
 
CUSTOMER_ID
 
Field
externalCCId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Guid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
ccId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. CCid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338|1312312|UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
personId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Personid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
notificationType
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. NotificationType is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
REASON
 
 
reason
 
Field
 
 
 
 
Field
status
 
Field
OUTL-BRT-NOTIFHUB_CustContactStatus
 
EVENT_CAPTURED_DT
 
Field
eventCapturedDateTime
 
Field
 
 
 
 
 
 
customerContactIdentifier
List
 
 
RIID
 
 
externalRefId
 
 
 
customerContactIdentifier may contain the key value pair.
C1NS
 
Value
identifierType
 
 
 
 
 
 
 
 
customerContactIdentifier
List
 
IdentifierType contains C1NS
 
 
 
 
 
 
 
CUSTOMER_ID or externalCCid
CUSTOMER_ID
 
 
externalRefId
 
 
 
 
C1EX
 
Value
identifierType
 
 
 
IdentifierType contains C1EX
 
 
Responsys CED (SMS SKIPPED)
CCB Create Customer Contact API
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
 
 
CUSTOMER_ID
 
Field
externalCCId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Guid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
ccId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. CCid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338|1312312|UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
personId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Personid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
notificationType
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. NotificationType is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
 
 
Field
status
 
Field
OUTL-BRT-NOTIFHUB_CustContactStatus
 
EVENT_CAPTURED_DT
 
Field
eventCapturedDateTime
 
Field
 
 
 
 
 
 
customerContactIdentifier
List
 
customerContactIdentifier may contain the key value pair.
RIID
 
 
externalRefId
 
 
 
 
C1NS
 
Value
identifierType
 
 
 
IdentifierType contains C1NS
 
 
 
 
customerContactIdentifier
List
 
CUSTOMER_ID or externalCCid
CUSTOMER_ID
 
 
externalRefId
 
 
 
 
C1EX
 
Value
identifierType
 
 
 
IdentifierType contains C1EX
 
 
Pending File (xml )
CCB Create Customer Contact API
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
 
 
messageId
 
Field
externalCCId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Guid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
notifEventInstanceId
 
 
notificationInstanceId
 
 
 
 
CCId
 
Field
ccId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. CCid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338|1312312|UNPLN_ERT|0172421206"
 
 
 
origin
 
 
OUTL-BRT-NOTIFHUB_OriginSystem
 
accountId
 
 
accountId
 
 
 
 
contactId
 
 
contactId
 
 
 
 
CUSTOMER_ID
 
Field
personId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Personid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
notifPreferenceId
 
 
notificationPreferenceId
 
 
 
 
deliveryChannel
 
 
deliveryChannel
 
 
 
 
deliveryValue
 
 
deliveryValue
 
 
 
 
notificationType
 
Field
notificationType
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. NotificationType is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
 
 
Field
status
 
Field
OUTL-BRT-NOTIFHUB_CustContactStatus
 
emailSubject
 
 
emailSubject
 
 
 
 
eventCapturedDateTime
 
Field
eventCapturedDateTime
 
Field
 
This is the datetime in UTC timezone of when the message was dropped in TargetNotificationStream
 
 
 
 
customerContactIdentifier
List
 
customerContactIdentifier may contain the key value pair.
messageId
 
Field
externalRefId
 
 
 
 
 
data
List
 
data
List
 
CUSTOMER_ID or externalCCid
key
 
Field
key
 
 
 
 
value
 
Field
value
 
 
 
IdentifierType contains C1EX
 
 
 
 
customerContactIdentifier
List
 
customerContactIdentifier may contain the key value pair.
sourceMessageId
 
Field
externalRefId
 
 
 
This contains the NMS voilation id that is the system Originating id. This is applicable for NMS notification only.
C1OS
 
Value
identifierType
 
 
 
Originating System Identifier
 
 
Responsys CED (SMS FAILED)
CCB Create Customer Contact API
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
 
 
CUSTOMER_ID
 
Field
externalCCId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Guid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
ccId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. CCid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338|1312312|UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
personId
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. Personid is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
CUSTOMER_ID
 
Field
notificationType
 
Field
 
CUSTOMER_ID contains multiple values delimited by pipe "|" symbol. NotificationType is mapped to this field. For eg the highlited value is mapped: "2d343934353135363230323936303338||UNPLN_ERT|0172421206"
REASON
 
 
reason
 
Field
 
 
 
 
Field
status
 
Field
OUTL-BRT-NOTIFHUB_CustContactStatus
 
EVENT_CAPTURED_DT
 
Field
eventCapturedDateTime
 
Field
 
 
 
 
 
 
 
 
 
 
 
 
 
 
customerContactIdentifier
List
 
customerContactIdentifier may contain the key value pair.
RIID
 
 
externalRefId
 
 
 
 
C1NS
 
Value
identifierType
 
 
 
IdentifierType contains C1NS
 
 
 
 
customerContactIdentifier
List
 
CUSTOMER_ID or externalCCid
CUSTOMER_ID
 
 
externalRefId
 
 
 
 
C1EX
 
Value
identifierType
 
 
 
IdentifierType contains C1EX