Job History Query Process
This section describes data mapping for the following:
Job History Query Request Message Mapping
The schema details Job History Query Request are as shown in the table below:
Oracle Utilities Customer to Meter Request Message Elements
Oracle Utilities Network Management System Field
 
Element Name
Parent Element
Type
Element Name
DVM Name
Comments
<jobHistoryRequest>
 
OutermostTag
 
 
 
 
spId
Field
CID
 
 
 
premiseId
Field
PREMISEID
 
 
 
accountId
Field
ACCOUNTNUMBER
 
 
 
location
Field
 
 
 
 
cityStreet
Field
CITY
 
 
 
state
Field
STATE
 
 
 
intersection
Field
 
 
 
 
street1
Field
STREET1
 
 
 
street2
Field
STREET2
 
 
 
intersection
Field
 
 
 
 
segment
Field
 
 
 
 
Street
Field
STREET1
 
 
 
Number
Field
BLOCKNUMBER
 
 
 
Segment
Field
 
 
 
 
Location
Field
 
 
 
 
externalId
Field
EXTERNALID
 
 
 
callIdentifierId
Field
CALLID
 
 
 
callerName
Field
CALLERNAME
 
 
 
callerPhoneNumber
Field
CALLERPHONE
 
 
 
 
 
P_CMP_DAYS
 
 
</jobHistoryRequest>
 
 
 
 
 
Job History Query Response Message Mapping
The schema details Job History Query Response are as shown in the table below:
Oracle Utilities Customer to Meter Response Message Elements
Oracle Utilities Network Management System Field
 
Element Name
Parent Element
Type
Element Name
DVM Name
Comments
<jobHistoryRequest>
 
OutermostTag
 
 
 
<jobHistory>
 
 
 
 
 
 
spId
Field
CID
 
 
 
jobStartDateTime
Field
BEGIN_TIME
 
 
 
troubleLocation
Field
TROUBLE_LOCATION
 
 
 
estimatedRestoration
DateTime
Field
EST_REST_TIME
 
 
 
actualRestoration
DateTime
Field
RESTORE_TIME
 
 
 
ertType_Source
Field
EST_SOURCE OUC2M_OUNMS_ETR
 
 
 
eventStatus
Field
STATUS
OUC2M_OUNMS_Status
 
 
alarmState
Field
ALARM_STATE
OUC2M_OUNMS_Alarm_State
 
 
customersAffected
Field
NUM_CUST_OUT
 
 
 
jobId
Field
EVENT_IDX
 
 
 
opearatorComment
Field
OPERATOR_COMMENT
 
 
 
deviceClass
Field
DEVCLS_NAME
 
 
 
troubleDescription
Field
TROUBLE_CODE
 
 
 
feeder
Field
FEEDER_NAME
 
 
 
primaryCause
Field
CAUSE
OUC2M_OUNMS_Cause
 
 
actionTakenDescription
Field
DESCRIPTION
OUC2M_OUNMS_Error_Code
 
 
referralGroup
Field
REFERRAL_GROUP
 
 
 
 
Field
P_ERR_NO
OUC2M_OUNMS_Error_Code
 
 
 
Field
P_ERR_MSG
 
 
 
 
Field
UDF1
 
 
 
 
Field
UDF2
 
 
 
 
Field
UDF3
 
 
 
 
Field
UDF4
 
 
 
 
Field
UDF5
 
 
</jobHistory>
 
Field
 
 
 
<exceptionInfo>
<messageCategory/>
 
 
 
 
 
<messageNumber/>
Field
 
 
 
 
<comments/>
Field
 
 
 
 
<messageParms>
Field
 
 
 
 
<parmSequence/>
Field
 
 
 
 
<messageParmValue/>
Field
 
 
 
 
</messageParms>
Field
 
 
 
</exceptionInfo>
 
 
 
 
 
</jobHistoryResponse>