Billing Processes

Batch Bill Determinants Synchronization Process Mapping Details

This section provides data mapping details for the following:

• Batch Bill Determinants Request Mapping Details

• Batch Bill Determinants Response Mapping Details

Refer to the Batch Bill Determinants Integration Process description for processing details on this integration point.

Batch Bill Determinants Request Mapping Details

CCB Batch BD Request Message			MDM Batch BD Request Message			DVM Mapping
Element	Parent Element	Type	Element	Parent Element	Type	DVM
sendDetails		Outermost Tag	D2-UsageTransactionRequestInbound		Outermost Tag
usageId	sendDetails	Field	externalId	D2-UsageTransactionRequest Inbound	Field
previousUsageId	sendDetails	Field	previousUsageId	D2-UsageTransactionRequest Inbound	Field
saId	sendDetails	Field	usExternalId	D2-UsageTransactionRequest Inbound	Field
			usageId	D2-UsageTransactionRequest Inbound	Field
			bo	D2-UsageTransactionRequest Inbound	Field
			boStatus	D2-UsageTransactionRequest Inbound	Field
			statusReason	D2-UsageTransactionRequest Inbound
			createDateTime	D2-UsageTransactionRequest Inbound	Field
			updateStatusDateTime	D2-UsageTransactionRequest Inbound	Field
			usId	D2-UsageTransactionRequest Inbound	Field
			usageGroup	D2-UsageTransactionRequest Inbound	Field
bo	sendDetails	Field
boStatus	sendDetails	Field
createDateTime	sendDetails	Field
statusDateTime	sendDetails	Field
			comments	D2-UsageTransactionRequest Inbound	Field
			measurementCycle	D2-UsageTransactionRequest Inbound	Field
			measurementCycleRoute	D2-UsageTransactionRequest Inbound	Field
			scheduledSelectionDate	D2-UsageTransactionRequest Inbound	Field
			isTraceOn	D2-UsageTransactionRequest Inbound	Field
intervalProcessing	sendDetails	Group	intervalMC	D2-UsageTransactionRequest Inbound	Group
startDateTime	intervalProcessing	Field	startDateTime	intervalMC	Field
endDateTimeFrom	intervalProcessing	Field	endDateTimeFrom	intervalMC	Field
endDateTimeTo	intervalProcessing	Field	endDateTimeTo	intervalMC	Field
customElements	intervalProcessing	Field
scalarProcessing	sendDetails	Group	scalarMC	D2-UsageTransactionRequest Inbound	Group
startDateTime	scalarProcessing	Field	startDateTime	scalarMC	Field
endDateTime	scalarProcessing	Field	endDateTimeFrom	scalarMC	Field
endDateTime	scalarProcessing	Field	endDateTimeTo	scalarMC	Field
billingOption	scalarProcessing	Field	endRangeOption	scalarMC	Field	OUCCB2_OUMDM2_BillingOption
minDaysOffset	scalarProcessing	Field	minDaysOffset	scalarMC	Field
maxDaysOffset	scalarProcessing	Field	maxDaysOffset	scalarMC	Field
allowEstimate	scalarProcessing	Field	allowEstimate	scalarMC	Field	OUCCB2_OUMDM2_AllowEstimat
estimateDate	scalarProcessing	Field	estimateDate	scalarMC	Field
customElements	scalarProcessing	Field
billSegmentId	sendDetails	Field
version	sendDetails	Field	version	D2-UsageTransactionRequest Inbound
			dateBreaks	D2-UsageTransactionRequest Inbound	Group
dateBreaks	sendDetails	List	dateBreaksList	dateBreaks	List
breakDateTime	dateBreaks	Field	dateBreak	dateBreaksList	Field
billCondition	sendDetails	Field	billCondition	D2-UsageTransactionRequest Inbound	Field	OUCCB2_OUMDM2_BillConditio
retryInfo	sendDetails	Group
automatedretry	retryInfo	Field	automatedretry	D2-UsageTransactionRequest Inbound	Field	OUCCB2_OUMDM2_AutomatedRetry
retryUntilDateTime	retryInfo	Field	retryUntilDateTime	D2-UsageTransactionRequest Inbound	Field
billCycle	sendDetails	Field
windowStartDate	sendDetails	Field
billModeInfo	sendDetails	Group
billMode	billModeInfo	Field	requestMode	D2-UsageTransactionRequest Inbound	Field	OUCCB2_OUMDM2_BillMode
billMode	billModeInfo	Field	deferCalculation	D2-UsageTransactionRequest Inbound	Field	OUCCB2_OUMDM2_BillMode
customElements	sendDetails	Group	customElements	D2-UsageTransactionRequest Inbound	Group

Batch Bill Determinants Response Mapping Details

MDM Batch BD Response Message			CCB Batch BD Response Message			DVM Mapping
Element	Parent Element	Type	Element	Parent Element	Type	DVM
sendDetails		Outermost Tag	C1UpdateUsageRequest		Outermost Tag
usId	sendDetails	Field
usageGroup	sendDetails	Field
externalId	sendDetails	Field	usageId	C1UpdateUsageRequest	Field
usageId	sendDetails	Field	externalReferenceId	C1UpdateUsageRequest	Field
			usageperiod	C1UpdateUsageRequest	Group
startDateTime	sendDetails	Field	startDateTime	usageperiod	Field
endDateTime	sendDetails	Field	endDateTime	usageperiod	Field
			customElements	usageperiod	Group
scalarMC	sendDetails	Group	scalarProcessing	C1UpdateUsageRequest	Group
isEstimate	scalarMC	Field	isEstimate	scalarProcessing	Field	OUMDM2_OUCCB2_IsEstimate
startDateTime	scalarMC	Field
endDateTimeFrom	scalarMC	Field
endDateTimeTo	scalarMC	Field
endRangeOption	scalarMC	Field
minDaysOffset	scalarMC	Field
maxDaysOffset	scalarMC	Field
allowEstimate	scalarMC	Field
estimateDate	scalarMC	Field
summaryUsagePeriods	sendDetails	Group
summaryUsagePeriodsList	summaryUsagePeriods	List	spUsagePeriod	C1UpdateUsageRequest	List
startDateTime	summaryUsagePeriodsList	Field	startDateTime	spUsagePeriod	Field
endDateTime	summaryUsagePeriodsList	Field	endDateTime	spUsagePeriod	Field
spSQs	summaryUsagePeriodsList	Group
spSQsList	spSQs	List	serviceQty	spUsagePeriod	List
spSQsequence	spSQsList	Field	seq	serviceQty	Field
spId	spSQsList	Field	spId	serviceQty	Field
uom	spSQsList	Field	uom	serviceQty	Field	OUMDM2_OUCCB2_UOM
tou	spSQsList	Field	tou	serviceQty	Field	OUMDM2_OUCCB2_TOU
sqi	spSQsList	Field	sqi	serviceQty	Field	OUMDM2_OUCCB2_SQI
quantity	spSQsList	Field	qty	serviceQty	Field
estimationIndicator	spSQsList	Field	estimationIndicator	serviceQty	Field	OUMDM2_OUCCB2_EstimationIndicator
highlightDateTimes	spSQsList	Group	highlightDateTimes	serviceQty	Group
highlightDateTimesList	highlightDateTimes	List	highlightDateTimesList	highlightDateTimes	List
sequence	highlightDateTimesList	Field	seq	highlightDateTimesList	Field
highlightDateTime	highlightDateTimesList	Field	highlightDateTime	highlightDateTimesList	Field
highlightType	highlightDateTimesList	Field	highlightType	highlightDateTimesList	Field	OUMDM2_OUCCB2_HighlightType
highlightEstimationIndicator	highlightDateTimesList	Field	highlightEstimationIndicator	highlightDateTimesList	Field	OUMDM2_OUCCB2_EstimationIndicator
highlightCondition	highlightDateTimesList	Field
highlightDerivedCondition	highlightDateTimesList	Field
			customElements	spUsagePeriod	Group
			usagePeriods	C1UpdateUsageRequest	List
startDateTime	summaryUsagePeriodsList	Field	startDateTime	usagePeriods	Field
endDateTime	summaryUsagePeriodsList	Field	endDateTime	usagePeriods	Field
standardStartDateTime	summaryUsagePeriodsList	Field	standardStartDateTime	usagePeriods	Field
standardEndtDateTime	summaryUsagePeriodsList	Field	standardEndtDateTime	usagePeriods	Field
usageType	summaryUsagePeriodsList	Field	usageRequestType	usagePeriods	Field	OUMDM2_OUCCB2_UsageType
SQs	summaryUsagePeriodsList	Group
SQsList	SQs	List	serviceQty	usagePeriods	List
sqSequence	SQsList	Field	seq	serviceQty	Field
uom	SQsList	Field	uom	serviceQty	Field	OUMDM2_OUCCB2_UOM
tou	SQsList	Field	tou	serviceQty	Field	OUMDM2_OUCCB2_TOU
sqi	SQsList	Field	sqi	serviceQty	Field	OUMDM2_OUCCB2_SQI
quantity	SQsList	Field	qty	serviceQty	Field
secondsPerInterval	SQsList	Field	spi	serviceQty	Field
intervals	SQsList	Group	intervals	serviceQty	Group
mL	intervals	List	iL	intervals	List
s	mL	Field	s	iL	Field
dt	mL	Field
q	mL	Field	q	iL	Field
c	mL	Field	c	iL	Field
highlightDateTimes	SQsList	Group	highlightDateTimes	serviceQty	Group
highlightDateTimesList	highlightDateTimes	List	highlightDateTimesList	highlightDateTimes	List
sequence	highlightDateTimesList	Field	seq	highlightDateTimesList	Field
highlightDateTime	highlightDateTimesList	Field	highlightDateTime	highlightDateTimesList	Field
highlightType	highlightDateTimesList	Field	highlightType	highlightDateTimesList	Field	OUMDM2_OUCCB2_HighlightType
highlightEstimationIndicator	highlightDateTimesList	Field	highlightEstimationIndicator	highlightDateTimesList	Field	OUMDM2_OUCCB2_EstimationIndicator
highlightCondition	highlightDateTimesList	Field
highlightDerivedCondition	highlightDateTimesList	Field
items	summaryUsagePeriodsList	Group	itemDetails	usagePeriods	Group
itemsList	items	List	itemDetailsList	itemDetails	List
itemSeq	itemsList	Field	seq	itemDetailsList	Field
itemId	itemsList	Field	itemId	itemDetailsList
itemType	itemsList	Field	itemType	itemDetailsList	Field	OUMDM2_OUCCB2_ ItemType
itemCount	itemsList	Field	itemCount	itemDetailsList	Field
startDateTime	itemsList	Field	startDateTime	itemDetailsList	Field
endDateTime	itemsList	Field	endDateTime	itemDetailsList	Field
dailyServiceQuantity	itemsList	Field	qty	itemDetailsList	Field
uom	itemsList	Field	uom	itemDetailsList	Field
			customElements	usagePeriods	Group
spItems	summaryUsagePeriodsList	Group	spItemsPeriod	C1UpdateUsageRequest	Group
spItemsList	spItems	List	spItemsList	spItemsPeriod	List
itemSeq	spItemsList	Field	itemSeq	spItemsList
			itemId	spItemsList
itemType	spItemsList	Field	itemType	spItemsList		OUMDM2_OUCCB2_ ItemType
itemCount	spItemsList	Field	itemCount	spItemsList
startDateTime	spItemsList	Field	startDateTime	spItemsList
endDateTime	spItemsList	Field	endDateTime	spItemsList
quantity	spItemsList	Field	quantity	spItemsList
uom	spItemsList	Field	uom	spItemsList
spId	spItemsList	Field	spId	spItemsList
customElements	summaryUsagePeriodsList	Group	customElements	spItemsList
SPs	summaryUsagePeriodsList	Group	SPs		Group
SPsList	SPs	List	SPsList	SPs	List
spId	SPsList	Field	spId	SPsList	Field
externalPremiseId	SPsList	Field	premId	SPsList	Field
market	SPsList	Field	market	SPsList	Field
device	SPsList	Group	deviceGroup	SPsList	Group
deviceList	deviceGroup	List	deviceList	deviceGroup	List
sequence	deviceList	Field	seq	deviceList	Field
badgeNumber	deviceList	Field	badgeNumber	deviceList	Field
serialNumber	deviceList	Field	serialNumber	deviceList	Field
fromDateTime	deviceList	Field	fromDateTime	deviceList	Field
toDateTime	deviceList	Field	toDateTime	deviceList	Field
scalarDetailsList	scalarDetails	List	reads		List
sequence	scalarDetailsList	Field	readSeq	reads	Field
spId	scalarDetailsList	Field	spId	reads	Field
uom	scalarDetailsList	Field	uom	reads	Field	OUMDM2_OUCCB2_UOM
tou	scalarDetailsList	Field	tou	reads	Field	OUMDM2_OUCCB2_TOU
sqi	scalarDetailsList	Field	sqi	reads	Field	OUMDM2_OUCCB2_SQI
measuringComponentId	scalarDetailsList	Field
startDateTime	scalarDetailsList	Field	startDateTime	reads	Field
startMeasurement	scalarDetailsList	Field	startReading	reads	Field
endDateTime	scalarDetailsList	Field	endDateTime	reads	Field
endMeasurement	scalarDetailsList	Field	endReading	reads	Field
quantity	scalarDetailsList	Field	measuredQty	reads	Field
finalUom	scalarDetailsList	Field	finalUom	reads	Field	OUMDM2_OUCCB2_UOM
finalTou	scalarDetailsList	Field	finalTou	reads	Field	OUMDM2_OUCCB2_TOU
finalSqi	scalarDetailsList	Field	finalSqi	reads	Field	OUMDM2_OUCCB2_SQI
finalQuantity	scalarDetailsList	Field	finalQty	reads	Field
spHowToUse	scalarDetailsList	Field	spHowToUse	reads	Field
mcHowToUse	scalarDetailsList	Field	regHowToUse	reads	Field
measuresPeakQuantity	scalarDetailsList	Field	measuresPeakQuantity	reads	Field
appliedMultiplier	scalarDetailsList	Field	constant	reads	Field
usePercent	scalarDetailsList	Field	usePercent	reads	Field
badgeNumber	scalarDetailsList	Field	badgeNumber	reads	Field
serialNumber	scalarDetailsList	Field	serialNumber	reads	Field
startEstimationIndicator	scalarDetailsList	Field	startReadEstimationIndicator	reads	Field	OUMDM2_OUCCB2_EstimationIndicator
endEstimationIndicator	scalarDetailsList	Field	endReadEstimationIndicator	reads	Field	OUMDM2_OUCCB2_EstimationIndicator
usageGroup	scalarDetailsList	Field
usageRule	scalarDetailsList	Field
customElements	scalarDetailsList	Group	customElements	reads	Group
exceptions	sendDetails	Group
exceptionsList	exceptions	List	exceptionInfo	C1UpdateUsageRequest	List
sequence	exceptionsList	Field	sequence	exceptionInfo	Field
usageGroup	exceptionsList	Field
usageRule	exceptionsList	Field
exceptionType	exceptionsList	Field
exceptionSeverity	exceptionsList	Field
toDoType	exceptionsList	Field
toDoRole	exceptionsList	Field
messageCategory	exceptionsList	Field	messageCategory	exceptionInfo	Field
messageNumber	exceptionsList	Field	messageNumber	exceptionInfo	Field
comments	exceptionsList	Field	comments	exceptionInfo	Field
messageParameters	exceptionsList	Group
messageParametersList	messageParameters	List	messageParameters	exceptionInfo	List
sequence	messageParametersList	Field	parameterSequence	messageParametersList	Field
parameter	messageParametersList	Field	messageParameterValue	messageParametersList	Field
parameterType	messageParametersList	Field
skipDetails	sendDetails	Group	saSkipInfo	C1UpdateUsageRequest	Group
skip	skipDetails	Field	skipSA	saSkipInfo	Field	OUMDM2_OUCCB2_SkipSA
skipReason	skipDetails	Field	skipReason	saSkipInfo	Field	OUMDM2_OUCCB2_SkipReason
nextScheduledReadDate	skipDetails	Field	nextScheduledReadDate	saSkipInfo	Field
usagePeriods	sendDetails	Group
usagePeriodsList	usagePeriods	List
sequence	usagePeriodsList	Field
startDateTime	usagePeriodsList	Field
endDateTime	usagePeriodsList	Field
usageType	usagePeriodsList	Field
SQs	usagePeriodsList	List
SQsList	SQs	Field
sqSequence	SQsList	Field
sqType	SQsList	Field
uom	SQsList	Field
tou	SQsList	Field
sqi	SQsList	Field
quantity	SQsList	Field
spId	SQsList	Field
measuringComponentId	SQsList	Field
touMapId	SQsList	Field
factor	SQsList	Field
characteristicType	SQsList	Field
characteristicValue	SQsList	Field
usageGroup	SQsList	Field
usageRule	SQsList	Field
intervalData	SQsList	Field
secondPerInterval	SQsList	Field
shouldExtractIntervalData	SQsList	Field
dataQualityAssessment	SQsList	Field
sourceMeasurementQuality	SQsList	Group
sourceMeasurementQuality List	sourceMeasurementQuality	List
s	sourceMeasurementQuality List	Field
fc	sourceMeasurementQuality List	Field
count	sourceMeasurementQuality List	Field
summarizedQuantity	sourceMeasurementQuality List	Field
highlightDateTimes	SQsList	Group
highlightDateTimesList	highlightDateTimes	List
sequence	highlightDateTimesList	Field
highlightDateTime	highlightDateTimesList	Field
highlightType	highlightDateTimesList	Field
highlightCondition	highlightDateTimesList	Field
highlightDerivedCondition	highlightDateTimesList	Field
highlightEstimationIndicator	highlightDateTimesList	Field
itemDetails	usagePeriodsList	Group
itemDetailsList	itemDetails	List
itemDetailsSeq	itemDetailsList	Field
itemId	itemDetailsList
itemType	itemDetailsList	Field
itemCount	itemDetailsList	Field
startDateTime	itemDetailsList	Field
endDateTime	itemDetailsList	Field
quantity	itemDetailsList	Field
uom	itemDetailsList	Field
customElements	sendDetails	Group	customElements	C1UpdateUsageRequest	Group

Bill Cycle Synchronization Process Mapping Details

This section provides data mapping details for the following:

• Bill Cycle Synchronization Request Mapping Details

• Bill Cycle Synchronization Response Mapping Details

• Bill Cycle Change Notification Mapping Details

Refer to the Bill Cycle Synchronization Related Processes description for processing details on this integration point.

Bill Cycle Synchronization Request Mapping Details

Data area that determines the fields inside the CCB formatted elements.

CCB Snapshot data area: C1-MDM2BillCycleBasedSnapshot

MDM Snapshot data area: D2-BillCycleSnapshot

CCB Bill Cycle Sync Request Message			MDM Bill Cycle Sync Request Message			Comments
Element	Parent Element	Type	Element	Parent Element	Type
sendDetails		Outermost Tag	D2-InboundBillCycleSyncRequest		Outermost Tag
			syncRequestId	D2-InboundBillCycleSyncRequest	Field
			bo	D2-InboundBillCycleSyncRequest	Field
			boStatus	D2-InboundBillCycleSyncRequest	Field
			createDateTime	D2-InboundBillCycleSyncRequest	Field
			statusDateTime	D2-InboundBillCycleSyncRequest	Field
syncRequestId	sendDetails	Field	externalReferenceId	D2-InboundBillCycleSyncRequest	Field
bo	sendDetails	Field
boStatus	sendDetails	Field
createDateTime	sendDetails	Field
statusDateTime	sendDetails	Field
syncRequired	sendDetails	Field
forceSync	sendDetails	Field
initialLoad	sendDetails	Field	initialLoad	D2-InboundBillCycleSyncRequest	Field
mo	sendDetails	Field	targetMo	D2-InboundBillCycleSyncRequest	Field	DVM: OUCCB2_OUMDM2_MO CCB Column: OUCCB2_MO MDM Column: OUMDM2_MO
pkValue1	sendDetails	Field	externalPkValue1	D2-InboundBillCycleSyncRequest	Field
pkValue2	sendDetails	Field	externalPkValue2	D2-InboundBillCycleSyncRequest	Field
pkValue3	sendDetails	Field	externalPkValue3	D2-InboundBillCycleSyncRequest	Field
pkValue4	sendDetails	Field	externalPkValue4	D2-InboundBillCycleSyncRequest	Field
pkValue5	sendDetails	Field	externalPkValue5	D2-InboundBillCycleSyncRequest	Field
			productionPkValue	D2-InboundBillCycleSyncRequest	Field
			exceptionInformation	D2-InboundBillCycleSyncRequest	Field
			toDoRetry	D2-InboundBillCycleSyncRequest	Field
			changeDateTime	D2-InboundBillCycleSyncRequest	Field
			version	D2-InboundBillCycleSyncRequest	Field
			targetBo	D2-InboundBillCycleSyncRequest	Field
			clearExceptions	D2-InboundBillCycleSyncRequest	Field
			relatedCompositeSyncId	D2-InboundBillCycleSyncRequest	Field
			compositeSyncRequest	D2-InboundBillCycleSyncRequest	Field
			processData	D2-InboundBillCycleSyncRequest	Field
snapshotDA	sendDetails	Field		D2-InboundBillCycleSyncRequest
postScript	sendDetails	Field
discardReason	sendDetails	Field
cancelReason	sendDetails	Field
sourceSystem	sendDetails	Field	externalSystem	D2-InboundBillCycleSyncRequest	Field
version	sendDetails	Field
externalSytem	sendDetails	Field
externalIds	sendDetails	Group
exceptionInfo	sendDetails	List
billCycleBO	sendDetails	Field
syncRequestDetails	sendDetails	Group	syncRequestDetails	D2-InboundBillCycleSyncRequest	Group

initialSnapshot	syncRequestDetails	Group
formattedElements	initialSnapshot	Group
finalSnapshot	syncRequestDetails	Group
formattedElements	finalSnapshot	Group	formattedElements	syncRequestDetails		Group move the formatted elements from CCB to MDM. Do not move field by field.
billCycle			billCycle
description			description			These fields will not be seen in the schema.
billCycleSchedules			billCycleSchedules			They are defined in the respective CCB and MDM DAs.
billCycleScheduleList			billCycleScheduleList
action			action
windowStartDate			windowStartDate
windowEndDate			windowEndDate
estimateDate			estimateDate

Bill Cycle Synchronization Response Mapping Details

MDM Bill Cycle Sync Response Message			CCB Dynamic Option Sync Response Message			Comments
Element	Parent Element	Type	Element	Parent Element	Type
sendDetails		Outermost Tag	F1-UpdateAndTransitionSyncRequest		Outermost Tag
syncRequestId	sendDetails	Field
externalReferenceId	sendDetails	Field	syncRequestId	F1-UpdateAndTransitionSyncRequest	Field
exceptionInformation	sendDetails	Group
exceptionInformationList	exceptionInformation	List	exceptionInfo	F1-UpdateAndTransitionSyncRequest	List
messageCategory	exceptionInformationList	Field	messageCategory	F1-UpdateAndTransitionSyncRequest	Field
messageNumber	exceptionInformationList	Field	messageNumber	F1-UpdateAndTransitionSyncRequest	Field	DVM: OUCCB2_OUMDM2_ErrorCode MDM Column: OUMDM2_ErrorCode CCB Column: OUCCB2_ErrorCode
sequence	exceptionInformationList	Field	sequence	F1-UpdateAndTransitionSyncRequest	Field	Incremental number populated by Integration
comments	exceptionInformationList	Field	comments	F1-UpdateAndTransitionSyncRequest	Field
messageParameters	exceptionInformationList	List	messageParameters	exceptionInfo	List
parameterSequence	messageParameters	Field	parameterSequence	messageParameters	Field
messageParameterType	messageParameters	Field
messageParameterValue	messageParameters	Field	messageParameterValue	messageParameters	Field
customElements	sendDetails	Field	customElements	F1-UpdateAndTransitionSyncRequest	Field

Bill Cycle Change Notification Mapping Details

Refer to the Bill Cycle Change Notification Integration Process description for processing details on this integration point.

MDM Outbound Message BO : D2-SPMsrmtCycleChangeOutMsg			CCB Message Service C1-BillCycleUpdateNotification			Comments
Element	Parent Element	Type	Element	Parent Element	Type
			C1-BillCycleUpdateNotification		Outermost Tag
sendDetails		Outermost Tag	messageDetails	C1-BillCycleUpdateNotification	Group	Group move MDM sendDetails to CCB messageDetails. Do not move field by field.
externalSPId	sendDetails	Field	externalSPId	messageDetails	Field
externalBillCycle	sendDetails	Field	externalBillCycle	messageDetails	Field

SA Activation Bill Cycle Synchronization Mapping Details

This section provides data mapping details for the following:

• SA Activation Bill Cycle Synchronization Request Mapping Details

• SA Activation Bill Cycle Synchronization Response Mapping Details

Refer to the SA Activation Bill Cycle Request Integration Process description for processing details on this integration point.

SA Activation Bill Cycle Synchronization Request Mapping Details

CCB Outbound Message BO C1-DetSPBillCycleOutMsg			MDM Message Service D2-DetermineBillCycleForSP			Comments
Element	Parent	Type	Element	Parent Element	Type
Element			D2-DetermineBillCycleForSP		Outermost Tag
sendDetails		Outermost Tag	messageDetails	D2-DetermineBillCycleForSP	Group	Group move CCB sendDetails to MDM messageDetails. Do not move field by field.
externalSPId		Field	externalSPId	messageDetails	Field
sourceSystem		Field	sourceSystem	messageDetails	Field
externalBillCycle		Field	externalBillCycle	messageDetails	Field
remarks		Field	remarks	messageDetails	Field

SA Activation Bill Cycle Synchronization Response Mapping Details

MDM Message Service D2-DetermineBillCycleForSP			CCB Outbound Message BO C1-DetSPBillCycleOutMsg			Comments
Element	Parent Element	Type	Element	Parent Element	Type
D2-DetermineBillCycleForSP		Outermost Tag
messageDetails	D2-DetermineBillCycleForSP	Group	sendDetails		Outermost Tag	Group move MDM messageDetails to CCB sendDetails. Do not move field by field.
externalSPId	messageDetails	Field	externalSPId		Field
sourceSystem	messageDetails	Field	sourceSystem		Field
externalBillCycle	messageDetails	Field	externalBillCycle		Field
remarks	messageDetails	Field	remarks		Field

Online Bill Determinants Synchronization Process Mapping Details

This section provides data mapping details for the following:

• Online Bill Determinants Request Mapping Details

• Online Bill Determinants Response Mapping Details

Refer to the Online Bill Determinants Integration Process description for processing details on this integration point.

Online Bill Determinants Request Mapping Details

CCB Online BD Request Message			MDM Online BD Request Message			DVM Mapping
Element	Parent Element	Type	Element	Parent Element	Type	DVM
sendDetails		Outermost Tag	D2-UsageTransactionRequest Inbound		Outermost Tag
usageId	sendDetails	Field	externalId	D2-UsageTransactionRequest Inbound	Field
previousUsageId	sendDetails	Field	previousUsageId	D2-UsageTransactionRequest Inbound	Field
saId	sendDetails	Field	usExternalId	D2-UsageTransactionRequest Inbound	Field
			usageId	D2-UsageTransactionRequest Inbound	Field
			bo	D2-UsageTransactionRequest Inbound	Field
			boStatus	D2-UsageTransactionRequest Inbound	Field
			statusReason	D2-UsageTransactionRequest Inbound
			createDateTime	D2-UsageTransactionRequest Inbound	Field
			updateStatusDateTime	D2-UsageTransactionRequest Inbound	Field
			usId	D2-UsageTransactionRequest Inbound	Field
			usageGroup	D2-UsageTransactionRequest Inbound	Field
bo	sendDetails	Field
boStatus	sendDetails	Field
createDateTime	sendDetails	Field
statusDateTime	sendDetails	Field
			comments	D2-UsageTransactionRequest Inbound	Field
			measurementCycle	D2-UsageTransactionRequest Inbound	Field
			measurementCycleRoute	D2-UsageTransactionRequest Inbound	Field
			scheduledSelectionDate	D2-UsageTransactionRequest Inbound	Field
			isTraceOn	D2-UsageTransactionRequest Inbound	Field
intervalProcessing	sendDetails	Group	intervalMC	D2-UsageTransactionRequest Inbound	Group
startDateTime	intervalProcessing	Field	startDateTime	intervalMC	Field
endDateTimeFrom	intervalProcessing	Field	endDateTimeFrom	intervalMC	Field
endDateTimeTo	intervalProcessing	Field	endDateTimeTo	intervalMC	Field
customElements	intervalProcessing	Field
scalarProcessing	sendDetails	Group	scalarMC	D2-UsageTransactionRequest Inbound	Group
startDateTime	scalarProcessing	Field	startDateTime	scalarMC	Field
endDateTime	scalarProcessing	Field	endDateTimeFrom	scalarMC	Field
endDateTime	scalarProcessing	Field	endDateTimeTo	scalarMC	Field
billingOption	scalarProcessing	Field	endRangeOption	scalarMC	Field	OUCCB2_OUMDM2 _BillingOption
minDaysOffset	scalarProcessing	Field	minDaysOffset	scalarMC	Field
maxDaysOffset	scalarProcessing	Field	maxDaysOffset	scalarMC	Field
allowEstimate	scalarProcessing	Field	allowEstimate	scalarMC	Field	OUCCB2_OUMDM2 _AllowEstimate
estimateDate	scalarProcessing	Field	estimateDate	scalarMC	Field
customElements	scalarProcessing	Field
billSegmentId	sendDetails	Field
version	sendDetails	Field	version	D2-UsageTransactionRequest Inbound
			dateBreaks	D2-UsageTransactionRequest Inbound	Group
dateBreaks	sendDetails	List	dateBreaksList	dateBreaks	List
breakDateTime	dateBreaks	Field	dateBreak	dateBreaksList	Field
billCondition	sendDetails	Field	billCondition	D2-UsageTransactionRequest Inbound	Field	OUCCB2_OUMDM2 _BillConditio
retryInfo	sendDetails	Group
automatedretry	retryInfo	Field	automatedretry	D2-UsageTransactionRequest Inbound	Field	OUCCB2_OUMDM2 _AutomatedRetry
retryUntilDateTime	retryInfo	Field	retryUntilDateTime	D2-UsageTransactionRequest Inbound	Field
customElements	sendDetails	Group	customElements	D2-UsageTransactionRequest Inbound	Group
billModeInfo	sendDetails	Group
billMode	billModeInfo	Field	requestMode	D2-UsageTransactionRequest Inbound	Field	OUCCB2_OUMDM2 _BillMode
customElements	sendDetails	Group

Online Bill Determinants Response Mapping Details

MDM Online BD Response Message			CCB Online BD Response Message			DVM Mapping
Element	Parent Element	Type	Element	Parent Element	Type	DVM
sendDetails		Outermost Tag	C1UpdateUsageRequest		Outermost Tag
usId	sendDetails	Field
usageGroup	sendDetails	Field
externalId	sendDetails	Field	usageId	C1UpdateUsageRequest	Field
usageId	sendDetails	Field	externalReferenceId	C1UpdateUsageRequest	Field
			usageperiod	C1UpdateUsageRequest	Group
startDateTime	sendDetails	Field	startDateTime	usageperiod	Field
endDateTime	sendDetails	Field	endDateTime	usageperiod	Field
			customElements	usageperiod	Group
scalarMC	sendDetails	Group	scalarProcessing	C1UpdateUsageRequest	Group
isEstimate	scalarMC	Field	isEstimate	scalarProcessing	Field	OUMDM2_OUCCB2_ IsEstimate
startDateTime	scalarMC	Field
endDateTimeFrom	scalarMC	Field
endDateTimeTo	scalarMC	Field
endRangeOption	scalarMC	Field
minDaysOffset	scalarMC	Field
maxDaysOffset	scalarMC	Field
allowEstimate	scalarMC	Field
estimateDate	scalarMC	Field
summaryUsagePeriods	sendDetails	Group
summaryUsagePeriodsList	summaryUsagePeriods	List	spUsagePeriod	C1UpdateUsageRequest	List
startDateTime	summaryUsagePeriodsList	Field	startDateTime	spUsagePeriod	Field
endDateTime	summaryUsagePeriodsList	Field	endDateTime	spUsagePeriod	Field
spSQs	summaryUsagePeriodsList	Group
spSQsList	spSQs	List	serviceQty	spUsagePeriod	List
spSQsequence	spSQsList	Field	seq	serviceQty	Field
spId	spSQsList	Field	spId	serviceQty	Field
uom	spSQsList	Field	uom	serviceQty	Field	OUMDM2_OUCCB2_ UOM
tou	spSQsList	Field	tou	serviceQty	Field	OUMDM2_OUCCB2_ TOU
sqi	spSQsList	Field	sqi	serviceQty	Field	OUMDM2_OUCCB2_ SQI
quantity	spSQsList	Field	qty	serviceQty	Field
estimationIndicator	spSQsList	Field	estimationIndicator	serviceQty	Field	OUMDM2_OUCCB2_ EstimationIndicator
highlightDateTimes	spSQsList	Group	highlightDateTimes	serviceQty	Group
highlightDateTimesList	highlightDateTimes	List	highlightDateTimesList	highlightDateTimes	List
sequence	highlightDateTimesList	Field	seq	highlightDateTimesList	Field
highlightDateTime	highlightDateTimesList	Field	highlightDateTime	highlightDateTimesList	Field
highlightType	highlightDateTimesList	Field	highlightType	highlightDateTimesList	Field	OUMDM2_OUCCB2_ HighlightType
highlightEstimationIndicator	highlightDateTimesList	Field	highlightEstimationIndicator	highlightDateTimesList	Field	OUMDM2_OUCCB2_ EstimationIndicator
highlightCondition	highlightDateTimesList	Field
highlightDerivedCondition	highlightDateTimesList	Field
			customElements	spUsagePeriod	Group
			usagePeriods	C1UpdateUsageRequest	List
startDateTime	summaryUsagePeriodsList		startDateTime	usagePeriods	Field
endDateTime	summaryUsagePeriodsList		endDateTime	usagePeriods	Field
usageType	summaryUsagePeriodsList		usageRequestType	usagePeriods	Field	OUMDM2_OUCCB2_ UsageType
standardStartDateTime	summaryUsagePeriodsList	Field	standardStartDateTime	usagePeriods	Field
standardEndtDateTime	summaryUsagePeriodsList	Field	standardEndtDateTime	usagePeriods	Field
SQs	summaryUsagePeriodsList	Group
SQsList	SQs	List	serviceQty	usagePeriods	List
sqSequence	SQsList	Field	seq	serviceQty	Field
uom	SQsList	Field	uom	serviceQty	Field	OUMDM2_OUCCB2_ UOM
tou	SQsList	Field	tou	serviceQty	Field	OUMDM2_OUCCB2_ TOU
sqi	SQsList	Field	sqi	serviceQty	Field	OUMDM2_OUCCB2_ SQI
quantity	SQsList		qty	serviceQty	Field
secondsPerInterval	SQsList	Field	spi	serviceQty	Field
intervals	SQsList	Group	intervals	serviceQty	Group
mL	intervals	List	iL	intervals	List
s	mL	Field	s	iL	Field
dt	mL	Field
q	mL	Field	q	iL	Field
c	mL	Field	c	iL	Field
highlightDateTimes	SQsList	Group	highlightDateTimes	serviceQty	Group
highlightDateTimesList	highlightDateTimes	List	highlightDateTimesList	highlightDateTimes	List
sequence	highlightDateTimesList	Field	seq	highlightDateTimesList	Field
highlightDateTime	highlightDateTimesList	Field	highlightDateTime	highlightDateTimesList	Field
highlightType	highlightDateTimesList	Field	highlightType	highlightDateTimesList	Field	OUMDM2_OUCCB2_ HighlightType
highlightEstimationIndicator	highlightDateTimesList	Field	highlightEstimationIndicator	highlightDateTimesList	Field	OUMDM2_OUCCB2_ EstimationIndicator
highlightCondition	highlightDateTimesList	Field
highlightDerivedCondition	highlightDateTimesList	Field
items	summaryUsagePeriodsList	Group	itemDetails	usagePeriods	Group
itemsList	items	List	itemDetailsList	itemDetails	List
itemSeq	itemsList	Field	seq	itemDetailsList	Field
itemId	itemsList		itemId	itemDetailsList
itemType	itemsList	Field	itemType	itemDetailsList	Field	OUMDM2_OUCCB2_ ItemType
itemCount	itemsList	Field	itemCount	itemDetailsList	Field
startDateTime	itemsList	Field	startDateTime	itemDetailsList	Field
endDateTime	itemsList	Field	endDateTime	itemDetailsList	Field
dailyServiceQuantity	itemsList	Field	qty	itemDetailsList	Field
uom	itemsList	Field	uom	itemDetailsList	Field
			customElements	usagePeriods	Group
spItems	summaryUsagePeriodsList	Group	spItemsPeriod	C1UpdateUsageRequest	Group
spItemsList	spItems	List	spItemsList	spItemsPeriod	List
itemSeq	spItemsList	Field	itemSeq	spItemsList
			itemId	spItemsList
itemType	spItemsList	Field	itemType	spItemsList		OUMDM2_OUCCB2_ ItemType
itemCount	spItemsList	Field	itemCount	spItemsList
startDateTime	spItemsList	Field	startDateTime	spItemsList
endDateTime	spItemsList	Field	endDateTime	spItemsList
quantity	spItemsList	Field	quantity	spItemsList
uom	spItemsList	Field	uom	spItemsList
spId	spItemsList	Field	spId	spItemsList
customElements	summaryUsagePeriodsList	Group	customElements	spItemsList
SPs	summaryUsagePeriodsList	Group	SPs		Group
SPsList	SPs	List	SPsList	SPs	List
spId	SPsList	Field	spId	SPsList	Field
externalPremiseId	SPsList	Field	premId	SPsList	Field
market	SPsList	Field	market	SPsList	Field
device	SPsList	Group	deviceGroup	SPsList	Group
deviceList	deviceGroup	List	deviceList	deviceGroup	List
sequence	deviceList	Field	seq	deviceList	Field
badgeNumber	deviceList	Field	badgeNumber	deviceList	Field
serialNumber	deviceList	Field	serialNumber	deviceList	Field
fromDateTime	deviceList	Field	fromDateTime	deviceList	Field
toDateTime	deviceList	Field	toDateTime	deviceList	Field
scalarDetails	sendDetails	Group
scalarDetailsList	scalarDetails	List	reads		List
sequence	scalarDetailsList	Field	readSeq	reads	Field
spId	scalarDetailsList	Field	spId	reads	Field
uom	scalarDetailsList	Field	uom	reads	Field	OUMDM2_OUCCB2_UOM
tou	scalarDetailsList	Field	tou	reads	Field	OUMDM2_OUCCB2_TOU
sqi	scalarDetailsList	Field	sqi	reads	Field	OUMDM2_OUCCB2_SQI
measuringComponentId	scalarDetailsList	Field
startDateTime	scalarDetailsList	Field	startDateTime	reads	Field
startMeasurement	scalarDetailsList	Field	startReading	reads	Field
endDateTime	scalarDetailsList	Field	endDateTime	reads	Field
endMeasurement	scalarDetailsList	Field	endReading	reads	Field
quantity	scalarDetailsList	Field	measuredQty	reads	Field
finalUom	scalarDetailsList	Field	finalUom	reads	Field	OUMDM2_OUCCB2_UOM
finalTou	scalarDetailsList	Field	finalTou	reads	Field	OUMDM2_OUCCB2_TOU
finalSqi	scalarDetailsList	Field	finalSqi	reads	Field	OUMDM2_OUCCB2_SQI
finalQuantity	scalarDetailsList	Field	finalQty	reads	Field
spHowToUse	scalarDetailsList	Field	spHowToUse	reads	Field
mcHowToUse	scalarDetailsList	Field	regHowToUse	reads	Field
measuresPeakQuantity	scalarDetailsList	Field	measuresPeakQuantity	reads	Field
appliedMultiplier	scalarDetailsList	Field	constant	reads	Field
usePercent	scalarDetailsList	Field	usePercent	reads	Field
badgeNumber	scalarDetailsList	Field	badgeNumber	reads	Field
serialNumber	scalarDetailsList	Field	serialNumber	reads	Field
startEstimationIndicator	scalarDetailsList	Field	startReadEstimationIndicator	reads	Field	OUMDM2_OUCCB2_ EstimationIndicator
endEstimationIndicator	scalarDetailsList	Field	endReadEstimationIndicator	reads	Field	OUMDM2_OUCCB2_ EstimationIndicator
usageGroup	scalarDetailsList	Field
usageRule	scalarDetailsList	Field
customElements	scalarDetailsList	Group	customElements	reads	Group
exceptions	sendDetails	Group
exceptionsList	exceptions	List	exceptionInfo	C1UpdateUsageRequest	List
sequence	exceptionsList	Field	sequence	exceptionInfo	Field
usageGroup	exceptionsList	Field
usageRule	exceptionsList	Field
exceptionType	exceptionsList	Field
exceptionSeverity	exceptionsList	Field
toDoType	exceptionsList	Field
toDoRole	exceptionsList	Field
messageCategory	exceptionsList	Field	messageCategory	exceptionInfo	Field
messageNumber	exceptionsList	Field	messageNumber	exceptionInfo	Field
comments	exceptionsList	Field	comments	exceptionInfo	Field
messageParameters	exceptionsList	Group
messageParametersList	messageParameters	List	messageParameters	exceptionInfo	List
sequence	messageParametersList	Field	parameterSequence	messageParametersList	Field
parameter	messageParametersList	Field	messageParameterValue	messageParametersList	Field
parameterType	messageParametersList	Field
skipDetails	sendDetails	Group	saSkipInfo	C1UpdateUsageRequest	Group
skip	skipDetails	Field	skipSA	saSkipInfo	Field	OUMDM2_OUCCB2_ SkipSA
skipReason	skipDetails	Field	skipReason	saSkipInfo	Field	OUMDM2_OUCCB2_ SkipReason
nextScheduledReadDate	skipDetails	Field	nextScheduledReadDate	saSkipInfo	Field
usagePeriods	sendDetails	Group
usagePeriodsList	usagePeriods	List
sequence	usagePeriodsList	Field
startDateTime	usagePeriodsList	Field
endDateTime	usagePeriodsList	Field
usageType	usagePeriodsList	Field
SQs	usagePeriodsList	List
SQsList	SQs	Field
sqSequence	SQsList	Field
sqType	SQsList	Field
uom	SQsList	Field
tou	SQsList	Field
sqi	SQsList	Field
quantity	SQsList	Field
spId	SQsList	Field
measuringComponentId	SQsList	Field
touMapId	SQsList	Field
factor	SQsList	Field
characteristicType	SQsList	Field
characteristicValue	SQsList	Field
usageGroup	SQsList	Field
usageRule	SQsList	Field
intervalData	SQsList	Field
secondPerInterval	SQsList	Field
shouldExtractIntervalData	SQsList	Field
dataQualityAssessment	SQsList	Field
sourceMeasurementQuality	SQsList	Group
sourceMeasurementQualityList	sourceMeasurementQuality	List
s	sourceMeasurementQualityList	Field
fc	sourceMeasurementQualityList	Field
count	sourceMeasurementQualityList	Field
summarizedQuantity	sourceMeasurementQualityList	Field
highlightDateTimes	SQsList	Group
highlightDateTimesList	highlightDateTimes	List
sequence	highlightDateTimesList	Field
highlightDateTime	highlightDateTimesList	Field
highlightType	highlightDateTimesList	Field
highlightCondition	highlightDateTimesList	Field
highlightDerivedCondition	highlightDateTimesList	Field
highlightEstimationIndicator	highlightDateTimesList	Field
itemDetails	usagePeriodsList	Group
itemDetailsList	itemDetails	List
itemDetailsSeq	itemDetailsList	Field
itemId	itemDetailsList
itemType	itemDetailsList	Field
itemCount	itemDetailsList	Field
startDateTime	itemDetailsList	Field
endDateTime	itemDetailsList	Field
quantity	itemDetailsList	Field
uom	itemDetailsList	Field
customElements	sendDetails	Group	customElements	C1UpdateUsageRequest	Group

Replacement Reads Synchronization Process Mapping Details

This section provides data mapping details for the following:

• Replacement Reads Request Mapping Details

Refer to the Replacement Reads Integration Process description for processing details on this integration point.

Replacement Reads Request Mapping Details

MDM Replacement Read Request Message			CCB Replacement Read Request Message
Element	Parent Element	Type	Element	Parent Element	Type
sendDetails		Outermost Tag	C1-DetAcctCreateCorrectedReadOCBG		Outermost Tag
			replacementRead	C1-DetAcctCreateCorrectedReadOCBG	Group
usageId			usageId	replacementRead	Field
externalId	sendDetails	Field	externalReferenceId	replacementRead	Field
customElements	sendDetails	Group	customElements	replacementRead	Group

Get Register Read High-Low Boundary Message Mapping Details

Refer to the Get Register Read High-Low Boundaries Integration Process description for processing details on this integration point.

CCB Message			MDM Message
Element	Parent Element	Type	Element	Parent Element	Type
		Outermost Tag	D2-DetermineEstimatedAndHighLowScalarReadings		Outermost Tag
sendDetails		Group	input	D2-DetermineEstimatedAndHighLowScalarReadings	Group
registerId	sendDetails	Field	externalMeasuringComponentId	input	Field
			measuringComponentId	input	Field
readDateTime	sendDetails	Field	msrmtDateTime	input	Field
customElements	sendDetails		customElements	input	Field
responseDetails		Group	output	D2-DetermineEstimatedAndHighLowScalarReadings	Group
estimatedRegisterReading	responseDetails	Field	estimatedReading	output	Field
lowBoundaryRegisterReading	responseDetails	Field	lowBoundaryReading	output	Field
highBoundaryRegisterReading	responseDetails	Field	highBoundaryReading	output	Field
			previousReadingDttm	output	Field
			previousReading	output	Field
			estimatedConsumption	output	Field
			lowBoundaryConsumption	output	Field
			highBoundaryConsumption	output	Field
			exceptions	output	Group
exceptionInfo	responseDetails	List	exceptionsList	exceptions	List
sequence	exceptions	Field	sequence	exceptionsList	Field
messageCategory	exceptions	Field	messageCategory	exceptionsList	Field
messageNumber	exceptions	Field	messageNumber	exceptionsList	Field
comments	exceptions	Field	messageInfo	exceptionsList	Field
			messageParameters	exceptionsList	Group
messageParameters	exceptions	List	messageParametersList	messageParameters	List
parameterSequence	messageParameters	Field	Sequence	messageParametersList	Field
messageParameterValue	messageParameters	Field	Parameter	messageParametersList	Field
			parameterType	messageParametersList	Field
customElements	responseDetails	Group	customElements	output	Group