Job History Query Process
This section provides mapping details for the following:
Refer to the Job History Query Process description for processing details on this integration point.
Job History Query Request Message Mapping
Oracle Utilities Customer Care and Billing Request Message Elements
 
Oracle Utilities Network Management System Field
DVM
<jobHistoryRequest>
spId
CID
premiseId
PREMISEID
accountId
ACCOUNTNUMBER
location
 
cityStreet
CITY
 
state
STATE
 
intersection
 
street1
STREET1
 
street2
STREET2
 
intersection
 
segment
 
Street
STREET1
 
Number
BLOCKNUMBER
 
Segment
 
Location
externalId
EXTERNALID
callIdentifierId
CALLID
callerName
CALLERNAME
callerPhoneNumber
CALLERPHONE
P_CMP_DAYS
</jobHistoryRequest>
 
 
Job History Query Response Message Mapping
Request Message
 
Oracle Utilities Network Management System Field
DVM
<jobHistoryResponse>
<jobHistory>
spId
CID
jobStartDateTime
BEGIN_TIME
troubleLocation
TROUBLE_LOCATION
estimatedRestorationDateTime
EST_REST_TIME
actualRestorationDateTime
RESTORE_TIME
ertType
EST_SOURCE
OUCCB_OUNMS_ETR_Source
eventStatus
STATUS
OUCCB_OUNMS_Status
alarmState
ALARM_STATE
OUCCB_OUNMS_Alarm_State
customersAffected
NUM_CUST_OUT
jobId
EVENT_IDX
opearatorComment
OPERATOR_COMMENT
deviceClass
DEVCLS_NAME
troubleDescription
TROUBLE_CODE
 
feeder
FEEDER_NAME
primaryCause
CAUSE
OUCCB_OUNMS_Cause
actionTakenDescription
DESCRIPTION
referralGroup
REFERRAL_GROUP
P_ERR_NO
OUCCB_OUNMS_Error_Code
P_ERR_MSG
UDF1
UDF2
UDF3
UDF4
UDF5
</jobHistory>
<exceptionInfo>
<messageCategory/>
<messageNumber/>
<comments/>
<messageParms>
<parmSequence/>
<messageParmValue/>
</messageParms>
</exceptionInfo>
</jobHistoryResponse>