Process Activity (Oracle Utilities Service Order Management Initiated)
This section describes data mapping for the following:
Request Mappings
The request mapping details in the Process Activity integration point are shown in the table below.
Oracle Utilities Service Order Management Request Message
Oracle Field Service Request Message
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Oracle Utilities Service Order Management Column
Oracle Field Service Column
 
sendDetail
D1-FieldActivityOBComm
OutermostTag
bulkUpdate_POST
 
OutermostTag
 
 
 
 
 
 
 
activities.definitions.customActionActivityBulkUpdateSchema
bulkUpdate_POST
Group
 
 
 
 
 
 
 
updateParameters
activities.definitions.customActionActivityBulkUpdateSchema
Group
 
 
 
 
 
 
 
activities
activities.definitions.customActionActivityBulkUpdateSchema
List
 
 
 
 
 
 
 
identifyActivityBy
updateParameters
string
 
 
 
Set to "apptNumber"
 
 
 
ifInFinalStatusThen
updateParameters
string
 
 
 
Set to "doNothing"
 
 
 
ifExistsThenDoNotUpdateFields
updateParameters
string
 
 
 
 
 
 
 
resourceId
activities
string
SOMOFSC_ConfigProps
PropertyName=ofsc.bucket
Value
hostAction!=D1UP
 
 
 
accessSchedule
activities
string
 
 
 
 
 
 
 
resourceInternalId
activities
integer
 
 
 
 
startDateTime
D1-FieldActivityOBComm/sendDetail/activities/activity/timeWindows/timeWindowsList
 
date
activities
string
SOMOFSC_ConfigProps
PropertyName
Value
If timeslot!=' ' substring-before(ICS_OFSC_ProcessActivity/sendDetail/activities/activity/timeWindows/timeWindowsList/startDateTime,'T') otherwise: configure slawindowstart, slawindowend and timezone
startDateTime
timeWindowsList
 
slaWindowStart
activities
 
 
 
 
 
endDateTime
timeWindowsList
 
slaWindowEnd
activities
 
 
 
 
 
timeZone
location
 
timeZone
activities
 
 
 
 
 
hostExternalId
D1-FieldActivityOBComm/sendDetail/activities/activity
Field
apptNumber
activities
string
 
 
 
 
taskType
D1-FieldActivityOBComm/sendDetail/activities/activity
 
activityType
activities
string
SOMOFSC_ActivityType.dvm
SOM_ActivityType
OFSC_ActivityType
 
estimatedDuration
D1-FieldActivityOBComm/sendDetail/activities/activity
Field
duration
activities
integer
 
 
 
Map this element only when the source element is present
 
 
 
timeDeliveredStart
activities
string
 
 
 
 
 
 
 
timeDeliveredEnd
activities
string
 
 
 
 
 
 
 
timeSlot
activities
string
OFSCSOM_Appt_Timeslots
SOM_Timeslots
OFSC_Timeslots;Duration_InSeconds
 
queue
D1-FieldActivityOBComm/sendDetail/activities/activity
Field
timeSlot
activities
string
OFSCSOM_Appt_Timeslots
 
 
 
customerName
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation
Field
customerName
activities
string
 
 
 
 
accountId
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation
Field
customerNumber
activities
string
 
 
 
 
mainPhone
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation
Field
customerPhone
activities
string
 
 
 
 
email
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation
Field
c2m_email
activities
string
 
 
 
 
cellPhone
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation
Field
customerCell
activities
string
 
 
 
 
address1
D1-FieldActivityOBComm/sendDetail/activities/activity/location/siteAddress
Field
streetAddress
 
 
 
 
 
 
address2
D1-FieldActivityOBComm/sendDetail/activities/activity/location/siteAddress
Field
streetAddress
 
 
 
 
 
 
address3
D1-FieldActivityOBComm/sendDetail/activities/activity/location/siteAddress
Field
streetAddress
 
 
 
 
 
 
address4
D1-FieldActivityOBComm/sendDetail/activities/activity/location/siteAddress
Field
streetAddress
 
 
 
 
 
 
 
 
 
streetAddress
activities
string
 
 
 
Concatenates address1, address2, address3 and address4 values
city
D1-FieldActivityOBComm/sendDetail/activities/activity/location/siteAddress
Field
city
activities
string
 
 
 
 
postal
D1-FieldActivityOBComm/sendDetail/activities/activity/location/siteAddress
Field
postalCode
activities
string
 
 
 
 
state
D1-FieldActivityOBComm/sendDetail/activities/activity/location/siteAddress
Field
stateProvince
activities
string
 
 
 
 
 
 
 
language
activities
string
 
 
 
 
 
 
 
reminderTime
activities
integer
 
 
 
 
timeZone
D1-FieldActivityOBComm/sendDetail/activities/activity/location
Field
timeZone
activities
string
SOMOFSC_TimeZone.dvm
SOM_TimeZone
OFSC_TimeZone
Map this element only when the source element is present
geocodeLongitude
D1-FieldActivityOBComm/sendDetail/activities/activity/location/siteAddress
Field
longitude
activities
double
 
 
 
 
geocodeLatitude
D1-FieldActivityOBComm/sendDetail/activities/activity/location/siteAddress
Field
latitude
activities
double
 
 
 
 
 
 
 
slaWindowStart
activities
string
 
 
 
 
 
 
 
slaWindowEnd
activities
string
 
 
 
 
 
 
 
deliveryWindowStart
activities
string
 
 
 
 
 
 
 
deliveryWindowEnd
activities
string
 
 
 
 
 
 
 
serviceWindowStart
activities
string
 
 
 
 
 
 
 
serviceWindowEnd
activities
string
 
 
 
 
 
 
 
startTime
activities
string
 
 
 
 
 
 
 
endTime
activities
string
 
 
 
 
 
 
 
teamResourceId
activities
string
 
 
 
 
 
 
 
points
activities
integer
 
 
 
 
 
 
 
timeOfBooking
activities
string
 
 
 
 
 
 
 
timeOfAssignment
activities
string
 
 
 
 
 
 
 
firstManualOperation
activities
string
 
 
 
 
 
 
 
firstManualOperationUser
activities
string
 
 
 
 
 
 
 
multidayTimeToComplete
activities
integer
 
 
 
 
 
 
 
ACTIVITY_TYPE
activities
string
 
 
 
 
 
 
 
WO_TYPE
activities
string
 
 
 
 
 
 
 
WO_CLASS
activities
string
 
 
 
 
 
 
 
JOB_NUMBER
activities
string
 
 
 
 
 
 
 
COD
activities
string
 
 
 
 
 
 
 
WO_COMMENTS
activities
string
 
 
 
 
 
 
 
DISPATCHER_COMMENTS
activities
string
 
 
 
 
 
 
 
PROBLEM_CODE
activities
string
 
 
 
 
 
 
 
MAP_GRID
activities
string
 
 
 
 
 
 
 
NODE_ID
activities
string
 
 
 
 
 
 
 
TAG_NUMBER
activities
string
 
 
 
 
 
 
 
SERVICES
activities
string
 
 
 
 
 
 
 
ICOMS_ETA_STATUS
activities
string
 
 
 
 
 
 
 
ICOMS_MANUAL_ETA_STATUS
activities
string
 
 
 
 
 
 
 
FINDING_CODE
activities
string
 
 
 
 
 
 
 
SOLUTION_CODE
activities
string
 
 
 
 
 
 
 
FAULT_CODE
activities
string
 
 
 
 
 
 
 
CLOSURE_NOTES
activities
string
 
 
 
 
 
 
 
CANCEL_REASON
activities
string
 
 
 
 
 
 
 
CANCEL_HOUSING_TYPE
activities
string
 
 
 
 
 
 
 
CANCEL_HOUSE_COLOR
activities
string
 
 
 
 
 
 
 
CANCEL_DOOR_COLOR
activities
string
 
 
 
 
 
 
 
ASRO_REPLACE_OUTLET
activities
string
 
 
 
 
 
 
 
ASRO_DEDICATE_RR_OUTLET
activities
string
 
 
 
 
 
 
 
ASRO_REPLACE_BURY_FOOTAGE
activities
string
 
 
 
 
 
 
 
ASRO_REPLACE_CABLE
activities
string
 
 
 
 
 
 
 
ASRO_REPLACE_AERIAL_FOOTAGE
activities
string
 
 
 
 
 
 
 
ASRO_REPLACE_AERIAL_CABLE
activities
string
 
 
 
 
 
 
 
ASRO_REPLACE_HR_2_SPLITTER
activities
string
 
 
 
 
 
 
 
ASRO_DRIVEWAY_BORE_NEEDED
activities
integer
 
 
 
 
 
 
 
ASRO_SIDEWALK_BORE_NEEDED
activities
integer
 
 
 
 
 
 
 
ASRO_TMP_CABLE_4_CONTRACT
activities
integer
 
 
 
 
 
 
 
ASRO_DROP_BONDED_TO_POWER
activities
integer
 
 
 
 
 
 
 
ASRO_COMMENTS
activities
string
 
 
 
 
 
 
 
NOT_DONE_CODE
activities
string
 
 
 
 
 
 
 
ACTIVITY_NOTES
activities
string
 
 
 
 
 
 
 
Points
activities
integer
 
 
 
 
 
 
 
cdaybefore_flag
activities
integer
 
 
 
 
 
 
 
cconfirmed
activities
integer
 
 
 
 
 
 
 
PAS1
activities
string
 
 
 
 
 
 
 
PAS2
activities
string
 
 
 
 
 
 
 
PAS3a
activities
string
 
 
 
 
 
 
 
PAS4
activities
string
 
 
 
 
 
 
 
PAS5
activities
string
 
 
 
 
 
 
 
PAS6
activities
string
 
 
 
 
 
 
 
PAS3b
activities
string
 
 
 
 
 
 
 
PAS_Recording_CSR_Notes
activities
string
 
 
 
 
 
 
 
pricer
activities
string
 
 
 
 
 
 
 
service_codes
activities
string
 
 
 
 
 
 
 
notification_email
activities
string
 
 
 
 
 
 
 
notifications_phone
activities
string
 
 
 
 
 
 
 
Place_of_activity
activities
string
 
 
 
 
 
 
 
I_wear_special_safety_belt
activities
integer
 
 
 
 
 
 
 
I_used_colleague_assistance
activities
integer
 
 
 
 
 
 
 
Made_sure_the_electricity_is_off
activities
integer
 
 
 
 
 
 
 
Authorized_for_high_altitude_work
activities
integer
 
 
 
 
 
 
 
The_weather_is_suitable
activities
integer
 
 
 
 
 
 
 
I_know_the_risks
activities
integer
 
 
 
 
 
 
 
Equipment_description
activities
string
 
 
 
 
 
 
 
Issue_reason
activities
string
 
 
 
 
 
 
 
Installation_failures
activities
string
 
 
 
 
 
 
 
Source_of_damage
activities
string
 
 
 
 
 
 
 
Damaged_equipment_description
activities
string
 
 
 
 
 
 
 
What_was_done
activities
string
 
 
 
 
 
 
 
Cable_length
activities
string
 
 
 
 
 
 
 
email_notifications_status
activities
integer
 
 
 
 
 
 
 
phone_notifications_status
activities
integer
 
 
 
 
 
 
 
job_hazards
activities
string
 
 
 
 
 
 
 
hazard_1
activities
string
 
 
 
 
 
 
 
hazard_2
activities
string
 
 
 
 
 
 
 
hazard_3
activities
string
 
 
 
 
 
 
 
complete_code
activities
string
 
 
 
 
 
 
 
plant_code
activities
string
 
 
 
 
 
 
 
snr
activities
string
 
 
 
 
 
 
 
low_ch
activities
string
 
 
 
 
 
 
 
mid_ch
activities
string
 
 
 
 
 
 
 
upper_ch
activities
string
 
 
 
 
 
 
 
no_ports
activities
integer
 
 
 
 
 
 
 
tap_value
activities
integer
 
 
 
 
 
 
 
find_code_1
activities
string
 
 
 
 
 
 
 
find_code_2
activities
string
 
 
 
 
 
 
 
find_code_3
activities
string
 
 
 
 
 
 
 
solution_code_1a
activities
string
 
 
 
 
 
 
 
solution_code_1b
activities
string
 
 
 
 
 
 
 
solution_code_1c
activities
string
 
 
 
 
 
 
 
solution_code_1d
activities
string
 
 
 
 
 
 
 
solution_code_1e
activities
string
 
 
 
 
 
 
 
solution_code_2a
activities
string
 
 
 
 
 
 
 
solution_code_2b
activities
string
 
 
 
 
 
 
 
solution_code_2c
activities
string
 
 
 
 
 
 
 
solution_code_2d
activities
string
 
 
 
 
 
 
 
solution_code_2e
activities
string
 
 
 
 
 
 
 
solution_code_3a
activities
string
 
 
 
 
 
 
 
solution_code_3b
activities
string
 
 
 
 
 
 
 
solution_code_3c
activities
string
 
 
 
 
 
 
 
solution_code_3d
activities
string
 
 
 
 
 
 
 
solution_code_3e
activities
string
 
 
 
 
 
 
 
Animal_secured
activities
integer
 
 
 
 
 
 
 
High_winds
activities
integer
 
 
 
 
 
 
 
Ladder_secured
activities
integer
 
 
 
 
 
 
 
Safety_gear
activities
integer
 
 
 
 
 
 
 
Ventillation
activities
integer
 
 
 
 
 
 
 
Electric_line
activities
integer
 
 
 
 
 
 
 
Alternative_route
activities
integer
 
 
 
 
 
 
 
sub_type
activities
string
 
 
 
 
 
 
 
last_tech_out
activities
string
 
 
 
 
 
 
 
XA_SITE_ID
activities
string
 
 
 
 
 
 
 
XA_CAND_NAME
activities
string
 
 
 
 
 
 
 
XA_MODEL_SITE_TYPE
activities
string
 
 
 
 
 
 
 
XA_SHARING_ID
activities
string
 
 
 
 
 
 
 
XA_COLLOCATION
activities
string
 
 
 
 
 
 
 
XA_CN
activities
string
 
 
 
 
 
 
 
XA_NOMINAL_PLAN
activities
string
 
 
 
 
 
 
 
XA_SALES_REP
activities
string
 
 
 
 
 
 
 
XA_UNIT_MODEL
activities
string
 
 
 
 
 
 
 
XA_BRAND
activities
string
 
 
 
 
 
 
 
XA_SERIAL_NUMBER
activities
string
 
 
 
 
 
 
 
XA_CONTRACT_COVERAGE
activities
string
 
 
 
 
 
 
 
XA_PROBLEM_SUMMARY
activities
string
 
 
 
 
 
 
 
XA_ODOMETER
activities
string
 
 
 
 
 
 
 
XA_GAS_PRESSURE
activities
string
 
 
 
 
 
 
 
XA_PHYSICAL_DAMAGE
activities
integer
 
 
 
 
 
 
 
XA_SAFETY_CHECK
activities
string
 
 
 
 
 
 
 
XA_WORK_ORDER
activities
string
 
 
 
 
 
 
 
XA_SERVICE_LEVEL
activities
string
 
 
 
 
 
 
 
XA_RESTOCK_NEEDED
activities
integer
 
 
 
 
 
 
 
XA_PART_NUMBER
activities
string
 
 
 
 
 
 
 
XA_PART_QUANTITY
activities
string
 
 
 
 
 
 
 
XA_SHIPPING_METHOD
activities
string
 
 
 
 
 
 
 
XA_PART_COST
activities
string
 
 
 
 
 
 
 
XA_LABOR_COST
activities
string
 
 
 
 
 
 
 
XA_TAX
activities
string
 
 
 
 
 
 
 
XA_TOTAL_COST
activities
string
 
 
 
 
 
 
 
XA_TASK_TYPE
activities
string
 
 
 
 
 
 
 
XA_CASE_CONTACT
activities
string
 
 
 
 
 
 
 
XA_CASE_TYPE
activities
string
 
 
 
 
 
 
 
XA_CASE_ACCOUNT
activities
string
 
 
 
 
 
 
 
XA_CASE_REASON
activities
string
 
 
 
 
 
 
 
XA_CASE_PRIORITY
activities
string
 
 
 
 
 
 
 
XA_CASE_SUBJECT
activities
string
 
 
 
 
 
 
 
XA_PRODUCT
activities
string
 
 
 
 
 
 
 
XA_CASE_DESCRIPTION
activities
string
 
 
 
 
 
 
 
XA_CASE_NOTES
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_NAME
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_OWNER
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_AMOUNT
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_STAGE
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_TYPE
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_LEAD_SOURCE
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_NEXT_STEP
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_DESCRIPTION
activities
string
 
 
 
 
 
 
 
XA_LIQUID_PRESSURE
activities
string
 
 
 
 
 
 
 
XA_TEMPERATURE
activities
string
 
 
 
 
 
 
 
XA_RESTOCK_SHIPPING
activities
string
 
 
 
 
 
 
 
XA_RESTOCK_PART_NUMBER
activities
string
 
 
 
 
 
 
 
XA_PART_NEEDED
activities
integer
 
 
 
 
 
 
 
XA_MISC_PART_TYPE
activities
string
 
 
 
 
 
 
 
XA_PART_ORDER_BRAND
activities
string
 
 
 
 
 
 
 
XA_PART_ORDER_NOTES
activities
string
 
 
 
 
 
 
 
XA_ACKNOWLEDGEMENT
activities
integer
 
 
 
 
 
 
 
XA_SAFETY_NOTES
activities
string
 
 
 
 
 
 
 
XA_PART_TYPE
activities
string
 
 
 
 
 
 
 
XA_AC_BRAND
activities
string
 
 
 
 
 
 
 
XA_AH_BRAND
activities
string
 
 
 
 
 
 
 
XA_FURN_BRAND
activities
string
 
 
 
 
 
 
 
XA_TANK_WH_BRAND
activities
string
 
 
 
 
 
 
 
XA_COMP_BRAND
activities
string
 
 
 
 
 
 
 
XA_WH_TYPE
activities
string
 
 
 
 
 
 
 
XA_TNKL_WH_BRAND
activities
string
 
 
 
 
 
 
 
XA_CPL_COMP
activities
string
 
 
 
 
 
 
 
XA_GOODMAN_COMP
activities
string
 
 
 
 
 
 
 
XA_RHM_COMP
activities
string
 
 
 
 
 
 
 
XA_GDM_AH
activities
string
 
 
 
 
 
 
 
XA_LENNOX_AH
activities
string
 
 
 
 
 
 
 
XA_RHM_AH
activities
string
 
 
 
 
 
 
 
XA_TRANE_AH
activities
string
 
 
 
 
 
 
 
XA_GE_TANK_WH
activities
string
 
 
 
 
 
 
 
XA_KENMORE_TNK_WH
activities
string
 
 
 
 
 
 
 
XA_RHM_TNK_WH
activities
string
 
 
 
 
 
 
 
XA_BOSCH_TL_WH
activities
string
 
 
 
 
 
 
 
XA_MAX_TL_WH
activities
string
 
 
 
 
 
 
 
XA_RHM_TL_WH
activities
string
 
 
 
 
 
 
 
XA_GDM_AC
activities
string
 
 
 
 
 
 
 
XA_RHM_AC
activities
string
 
 
 
 
 
 
 
XA_TRANE_AC
activities
string
 
 
 
 
 
 
 
XA_GDM_FURN
activities
string
 
 
 
 
 
 
 
XA_RHM_FURN
activities
string
 
 
 
 
 
 
 
XA_WIL_FURN
activities
string
 
 
 
 
 
 
 
XA_YORK_FURN
activities
string
 
 
 
 
 
 
 
XA_SAFE_DEBRIS
activities
integer
 
 
 
 
 
 
 
XA_SAFE_WIRES
activities
integer
 
 
 
 
 
 
 
XA_SAFE_WATER
activities
integer
 
 
 
 
 
 
 
XA_SAFE_EQUIP
activities
integer
 
 
 
 
 
 
 
XA_CASE_NUMBER
activities
string
 
 
 
 
 
 
 
XA_CASE_ASSET
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_PROBABILITY
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_EXPECTED_REVENUE
activities
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_CLOSE_DATE
activities
string
 
 
 
 
country
D1-FieldActivityOBComm/sendDetail/activities/activity/location/serviceAddress
Field
country_code
activities
string
SOMOFSC_Country_code.dvm
SOM_CountryCode
OFSC_CountryCode
Map this element only when source is present
deviceId
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails
Field
c2m_meter1_serial
activities
string
 
 
 
 
badgeNumber
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails
Field
c2m_meter1_number
activities
string
 
 
 
 
meterLocation
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails
Field
c2m_meter1_location
activities
string
SOMOFSC_MeterLocation.dvm
SOM_MeterLocation
OFSC_MeterLocation
 
meterConfigurationType
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails
Field
c2m_meter1_type
activities
string
SOMOFSC_MeterConfigurationType.dvm
SOM_MeterConfigurationType
OFSC_MeterConfigurationType
 
unitOfMeasure
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_uom
activities
string
 
 
 
 
 
 
 
UOM
activities
string
 
 
 
 
 
 
 
row4
activities
integer
 
 
 
 
 
 
 
Add_Row_sw
activities
integer
 
 
 
 
 
 
 
readHistory
activities
string
 
 
 
 
 
 
 
payHistory
activities
string
 
 
 
 
 
 
 
orderHistory
activities
string
 
 
 
 
payoffAmount
D1-FieldActivityOBComm/sendDetail/activities/activity/collectionDataDetails
Field
payOffAmount
activities
string
 
 
 
 
currentAmount
D1-FieldActivityOBComm/sendDetail/activities/activity/collectionDataDetails
Field
currentAmount
activities
string
 
 
 
 
lessThanThirtyDaysAmount
D1-FieldActivityOBComm/sendDetail/activities/activity/collectionDataDetails/arrearsDataDetails
Field
lessThan30
activities
string
 
 
 
 
thirtyDaysAmount
D1-FieldActivityOBComm/sendDetail/activities/activity/collectionDataDetails/arrearsDataDetails
Field
thirtyDaysAmount
activities
string
 
 
 
 
overSixtyDaysAmount
D1-FieldActivityOBComm/sendDetail/activities/activity/collectionDataDetails/arrearsDataDetails
Field
over60DaysAmt
activities
string
 
 
 
 
 
 
 
actionTaken
activities
string
 
 
 
 
 
 
 
payment
activities
string
 
 
 
 
 
 
 
trComments
activities
string
 
 
 
 
 
 
 
trEventId
activities
string
 
 
 
 
 
 
 
tr_outageBeginDateTime
activities
string
 
 
 
 
 
 
 
tr_firstCallDateTime
activities
string
 
 
 
 
 
 
 
tr_estimatedRestorationDateTime
activities
string
 
 
 
 
 
 
 
tr_caseNotes
activities
string
 
 
 
 
 
 
 
tr_clues
activities
string
 
 
 
 
 
 
 
tr_numberOfCalls
activities
string
 
 
 
 
 
 
 
tr_numberOfCustomersOut
activities
string
 
 
 
 
 
 
 
tr_numberOfKeyCustomers
activities
string
 
 
 
 
 
 
 
tr_numberOfEmergencyCustomers
activities
string
 
 
 
 
 
 
 
tr_numberOfMedicalCustomers
activities
string
 
 
 
 
 
 
 
tr_deviceId
activities
string
 
 
 
 
 
 
 
tr_phase
activities
string
 
 
 
 
 
 
 
tr_feeder
activities
string
 
 
 
 
 
 
 
tr_deviceLocation
activities
string
 
 
 
 
 
 
 
tr_callList
activities
string
 
 
 
 
 
 
 
tr_outageType
activities
string
 
 
 
 
 
 
 
tr_eventNotes
activities
string
 
 
 
 
 
 
 
tr_deviceConfirm
activities
string
 
 
 
 
 
 
 
tr_eventOutcome
activities
string
 
 
 
 
 
 
 
tr_actualRestoration
activities
string
 
 
 
 
 
 
 
tr_excludeFromOutage
activities
integer
 
 
 
 
 
 
 
tr_reasonForExclusion
activities
string
 
 
 
 
 
 
 
tr_cancelationReason
activities
string
 
 
 
 
 
 
 
tr_system
activities
string
 
 
 
 
 
 
 
tr_subsystem
activities
string
 
 
 
 
 
 
 
tr_failure
activities
string
 
 
 
 
 
 
 
tr_weather
activities
string
 
 
 
 
 
 
 
tr_frInterference
activities
string
 
 
 
 
 
 
 
tr_remedy
activities
string
 
 
 
 
 
 
 
tr_failedEquipment
activities
integer
 
 
 
 
 
 
 
tr_serialNumber
activities
string
 
 
 
 
 
 
 
tr_primaryVoltage
activities
string
 
 
 
 
 
 
 
tr_secondaryVoltage
activities
string
 
 
 
 
 
 
 
tr_rating
activities
string
 
 
 
 
 
 
 
tr_units
activities
string
 
 
 
 
 
 
 
tr_phase2
activities
string
 
 
 
 
 
 
 
Status_Found
activities
string
 
 
 
 
 
 
 
Status_Left
activities
string
 
 
 
 
 
 
 
FA_Comments
activities
string
 
 
 
 
 
 
 
w_requestedBy
activities
string
 
 
 
 
 
 
 
w_meetingPlace
activities
string
 
 
 
 
 
 
 
w_flowHydMainSize
activities
string
 
 
 
 
 
 
 
w_maintType
activities
string
 
 
 
 
 
 
 
w_PressHydMainSize
activities
string
 
 
 
 
 
 
 
w_mainType
activities
string
 
 
 
 
 
 
 
w_hydrantLocation
activities
string
 
 
 
 
 
 
 
w_flowHydrantNumber
activities
string
 
 
 
 
 
 
 
w_nozzles
activities
string
 
 
 
 
 
 
 
w_size
activities
string
 
 
 
 
 
 
 
w_testTimeStart
activities
string
 
 
 
 
 
 
 
w_testTimeEnd
activities
string
 
 
 
 
 
 
 
w_totalTime
activities
string
 
 
 
 
 
 
 
w_pitotPressure
activities
integer
 
 
 
 
 
 
 
w_flowRate
activities
integer
 
 
 
 
 
 
 
w_flowTotal
activities
integer
 
 
 
 
 
 
 
w_staticPressue
activities
integer
 
 
 
 
 
 
 
w_residualPressue
activities
integer
 
 
 
 
 
 
 
w_estFlowRate
activities
integer
 
 
 
 
 
 
 
Boroughs
activities
string
 
 
 
 
 
 
 
Block
activities
string
 
 
 
 
 
 
 
Lot
activities
string
 
 
 
 
 
 
 
BBL
activities
string
 
 
 
 
 
 
 
Add2
activities
string
 
 
 
 
 
 
 
City2
activities
string
 
 
 
 
 
 
 
State2
activities
string
 
 
 
 
 
 
 
Zip2
activities
string
 
 
 
 
 
 
 
NYC2
activities
integer
 
 
 
 
 
 
 
g_APTYPE1
activities
string
 
 
 
 
 
 
 
GL_APTYPE2
activities
string
 
 
 
 
 
 
 
GL_LeakDet
activities
integer
 
 
 
 
 
 
 
GL_RedTag1
activities
integer
 
 
 
 
 
 
 
GL_Location
activities
string
 
 
 
 
 
 
 
Outside_Leak_Causes
activities
string
 
 
 
 
 
 
 
GL_OUT_LEAK_TYPE
activities
string
 
 
 
 
 
 
 
GL_OUT_Source
activities
string
 
 
 
 
 
 
 
GL_OUT_LEL-ARRIVAL
activities
integer
 
 
 
 
 
 
 
GL_CGI_DEV_NO
activities
string
 
 
 
 
 
 
 
Reason_Tag_1
activities
string
 
 
 
 
 
 
 
GL_RE_TAG2_Reason
activities
string
 
 
 
 
 
 
 
GL_ACTION_TAKEN
activities
string
 
 
 
 
 
 
 
Leak_Log_Nbr
activities
string
 
 
 
 
 
 
 
Time_Made_Safe
activities
string
 
 
 
 
 
 
 
OUTSIDE_EQUIPMENT
activities
string
 
 
 
 
 
 
 
Building_Evacuated
activities
string
 
 
 
 
 
 
 
Time_made_safe_HHMM
activities
string
 
 
 
 
 
 
 
GL_LEAK_DETECTED
activities
string
 
 
 
 
 
 
 
GL_IN_COMMENTS
activities
string
 
 
 
 
 
 
 
GL_OUT_COMMENTS
activities
string
 
 
 
 
 
 
 
GL_IN_REPAIRS
activities
string
 
 
 
 
 
 
 
GL_IN_REPAIR1
activities
string
 
 
 
 
 
 
 
GL_IN_REPAIR2
activities
string
 
 
 
 
 
 
 
GL_RED_TAGS
activities
string
 
 
 
 
 
 
 
GL_IN_REPAIRS2
activities
integer
 
 
 
 
 
 
 
GL_RECHECK_IND
activities
string
 
 
 
 
 
 
 
GL_RECHECK_DATE
activities
string
 
 
 
 
 
 
 
GL_METER_STATUS
activities
string
 
 
 
 
 
 
 
GL_BILLABLE_IND
activities
string
 
 
 
 
 
 
 
GL_BILLABLE_PARTY
activities
string
 
 
 
 
 
 
 
GL_BILLABLE_ADDR_IND
activities
string
 
 
 
 
 
 
 
GL_BILLABLE_ADDR
activities
string
 
 
 
 
 
 
 
GL_GAS_STATUS
activities
string
 
 
 
 
 
 
 
GL_COMPLETION_COMMENTS
activities
string
 
 
 
 
 
 
 
GL_PPM_ARRIVAL
activities
integer
 
 
 
 
 
 
 
GL_FLAME_PACK_NO
activities
string
 
 
 
 
 
 
 
GL_BAR_HOLE_1
activities
integer
 
 
 
 
 
 
 
GL_BAR_CODE_2
activities
integer
 
 
 
 
 
 
 
GL_BAR_HOLE_2
activities
integer
 
 
 
 
 
 
 
GL_BAR_HOLE_3
activities
integer
 
 
 
 
 
 
 
v_tires
activities
integer
 
 
 
 
 
 
 
v_water
activities
integer
 
 
 
 
 
 
 
v_lights
activities
integer
 
 
 
 
 
 
 
v_comments
activities
string
 
 
 
 
 
 
 
Order_Type
activities
string
 
 
 
 
 
 
 
GL_BUILDING_EVAC_TIME2
activities
string
 
 
 
 
 
 
 
GL_PX_SIZE_FRACTIONS
activities
string
 
 
 
 
 
 
 
GL_PX_SIZE_INCH
activities
string
 
 
 
 
 
 
 
GL_PX_MATERIAL
activities
string
 
 
 
 
 
 
 
GL_PX_EXPOSED
activities
string
 
 
 
 
 
 
 
GL_PX_ANNODE
activities
string
 
 
 
 
 
 
 
GL_ANNODE_SIZE
activities
string
 
 
 
 
 
 
 
GL_PX_SEDIMENT
activities
string
 
 
 
 
 
 
 
GL_PX_COATING_TYPE
activities
string
 
 
 
 
 
 
 
GL_PX_COATING_COND
activities
string
 
 
 
 
 
 
 
GL_PX_CORR_EXT
activities
string
 
 
 
 
 
 
 
GL_PX_EXT_CORR_EXTENT
activities
string
 
 
 
 
 
 
 
GL_IN_PPM_ARRV
activities
string
 
 
 
 
 
 
 
GL_LEL_PCT_ARRV
activities
string
 
 
 
 
 
 
 
GL_BAR1_PCT
activities
string
 
 
 
 
 
 
 
GL_BAR2_PCT
activities
string
 
 
 
 
 
 
 
GL_BAR3_PCT
activities
string
 
 
 
 
 
 
 
Surface
activities
string
 
 
 
 
 
 
 
Probable_Pressure
activities
string
 
 
 
 
 
 
 
Repair_Type
activities
string
 
 
 
 
 
 
 
Leak_Cause
activities
string
 
 
 
 
 
 
 
Actual_Pipe_Material
activities
string
 
 
 
 
 
 
 
Actual_Pressure
activities
string
 
 
 
 
 
 
 
Odorant_Detected
activities
string
 
 
 
 
 
 
 
Test_Medium
activities
string
 
 
 
 
 
 
 
Test_Device
activities
string
 
 
 
 
 
 
 
Pressure_Test_PSIG
activities
string
 
 
 
 
 
 
 
Test_Duration_Hours
activities
string
 
 
 
 
 
 
 
Test_Duration_Mins
activities
string
 
 
 
 
 
 
 
Test_Duration_Secs
activities
string
 
 
 
 
 
 
 
Technician_Name
activities
string
 
 
 
 
 
 
 
Leak_Class
activities
string
 
 
 
 
 
 
 
GL_CaseReviewed
activities
integer
 
 
 
 
 
 
 
GLR_ReferCM
activities
integer
 
 
 
 
 
 
 
Appointment
activities
integer
 
 
 
 
criteria
D1-FieldActivityOBComm/sendDetail/activities/activity
Field
c2m_service_pt_type
activities
string
 
 
 
 
servicePointId
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails
Field
c2m_service_pt_id
activities
string
 
 
 
 
disconnectLocation
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails
Field
c2m_disconnect_location
activities
string
SOMOFSC_DisconnectLocation
SOM_DiscLoc
OFSC_DiscLoc
 
 
 
 
newMtr_status_left
activities
string
 
 
 
 
newCharges
D1-FieldActivityOBComm/sendDetail/activities/activity/collectionDataDetails/arrearsDataDetails
Field
c2m_new_charges
activities
string
 
 
 
 
badgeNumber
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails
Field
c2m_item_nbr
activities
string
 
 
 
 
deviceId
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails
Field
c2m_item_id
activities
string
SOMOFSC_Manufacturer.dvm
 
 
 
deviceManufacturer
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails
Field
c2m_item_manufacturer
activities
string
SOMOFSC_Manufacturer
SOM_Manufacturer
OFSC_Manufacturer
 
deviceModel
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails
Field
c2m_item_model
activities
string
SOMOFSC_Model
SOM_Model
OFSC_Model
 
 
 
 
lessThirtyDaysAmount
activities
string
 
 
 
 
disputedAmount
D1-FieldActivityOBComm/sendDetail/activities/activity/collectionDataDetails/arrearsDataDetails
Field
disputedAmount
activities
string
 
 
 
 
 
 
 
sixtyDaysAmount
activities
string
 
 
 
 
activityComments
D1-FieldActivityOBComm/sendDetail/activities/activity
Field
c2m_activity_comments
activities
string
 
 
 
 
siteInstructions
D1-FieldActivityOBComm/sendDetail/activities/activity/location
Field
c2m_site_instructions
activities
string
 
 
 
 
instructionDetails
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails
Field
c2m_SP_instruction_details
activities
string
 
 
 
 
serviceWarnings
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails
Field
c2m_SP_warnings
activities
string
SOMOFSC_ServiceWarnings.dvm
SOM_ServiceWarnings
OFSC_ServiceWarnings
 
premiseId
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails
Field
c2m_premise_id
activities
string
 
 
 
 
serviceInstructions
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails
Field
c2m_SP_instructions
activities
string
SOMOFSC_ServiceInstructions.dvm
SOM_ServiceInstructions
OFSC_ServiceInstructions
 
deviceManufacturer
D1-FieldActivityOBComm//sendDetail/activities/activity/meterDataDetails
Field
c2m_meter1_mfg
activities
string
SOMOFSC_Manufacturer
SOM_Manufacturer
OFSC_Manufacturer
 
meterLocation
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails
Field
c2m_meter1_loc
activities
string
SOMOFSC_MeterLocation
SOM_MeterLocation
OFSC_MeterLocation
 
deviceModel
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails
Field
c2m_meter1_model
activities
string
SOMOFSC_Model
SOM_Model
OFSC_Model
Map this element only when source element is present
numberOfDecimals
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_numberofDecimals
activities
integer
 
 
 
Map this element only when source element is present
upperLimit
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_upper_limit
activities
string
 
 
 
Map this element only when source element is present
lowerLimit
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_lower_limit
activities
string
 
 
 
Map this element only when source element is present
unitOfMeasure
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_uom
activities
string
 
 
 
 
timeOfUse
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_TOU
activities
string
 
 
 
 
overrideReading
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_override_reading
activities
enum
 
 
 
 
numberOfDials
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_dials
activities
Integer
 
 
 
 
reading
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_current_index
activities
string
 
 
 
 
sqi
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_sqi
activities
string
 
 
 
Map this element only when source element is present
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_read_seq
activities
integer
 
 
 
 
 
 
 
status
activities
string
 
 
 
 
 
 
 
linkedActivities
activities
Group
 
 
 
 
 
 
 
inventories
activities
Group
 
 
 
 
 
 
 
requiredInventories
activities
Group
 
 
 
 
 
 
 
resourcePreferences
activities
Group
 
 
 
 
 
 
 
items
linkedActivities
List
 
 
 
 
 
 
 
fromActivity
items
Group
 
 
 
 
 
 
 
toActivity
items
Group
 
 
 
 
 
 
 
apptNumber
fromActivity
string
 
 
 
 
 
 
 
customerNumber
fromActivity
string
 
 
 
 
 
 
 
linkType
fromActivity
string
 
 
 
 
 
 
 
minInterval
fromActivity
integer
 
 
 
 
 
 
 
maxInterval
fromActivity
integer
 
 
 
 
 
 
 
apptNumber
toActivity
string
 
 
 
 
 
 
 
customerNumber
toActivity
string
 
 
 
 
 
 
 
linkType
toActivity
string
 
 
 
 
 
 
 
minInterval
toActivity
integer
 
 
 
 
 
 
 
maxInterval
toActivity
integer
 
 
 
 
 
 
 
items
inventories
List
 
 
 
 
 
 
 
totalResults
inventories
integer
 
 
 
 
 
 
 
offset
inventories
integer
 
 
 
 
 
 
 
limit
inventories
integer
 
 
 
 
 
 
 
inventoryId
items
integer
 
 
 
 
 
 
 
status
items
string
 
 
 
 
 
 
 
inventoryType
items
string
 
 
 
 
 
 
 
serialNumber
items
string
 
 
 
 
 
 
 
quantity
items
integer
 
 
 
 
 
 
 
exchangedInventoryId
items
integer
 
 
 
 
 
 
 
resourceId
items
string
 
 
 
 
 
 
 
resourceInternalId
items
integer
 
 
 
 
 
 
 
activityId
items
integer
 
 
 
 
 
 
 
ITEM_NUMBER
items
string
 
 
 
 
 
 
 
EQUIPMENT_ROOM_CODE
items
string
 
 
 
 
 
 
 
PORT_INFO
items
string
 
 
 
 
 
 
 
EQUIPMENT_ETHERNET
items
string
 
 
 
 
 
 
 
EQUIPMENT_PHONENUMBER
items
string
 
 
 
 
 
 
 
EQUIPMENT_WARRANTY
items
string
 
 
 
 
 
 
 
EQUIPMENT_RF_ENABLED
items
string
 
 
 
 
 
 
 
EQUIPMENT_BANDWIDTH
items
string
 
 
 
 
 
 
 
inventory_model
items
string
 
 
 
 
 
 
 
Transformers
items
string
 
 
 
 
 
 
 
Conductor
items
integer
 
 
 
 
 
 
 
items
requiredInventories
List
 
 
 
 
 
 
 
totalResults
requiredInventories
integer
 
 
 
 
 
 
 
offset
requiredInventories
integer
 
 
 
 
 
 
 
limit
requiredInventories
integer
 
 
 
 
 
 
 
model
items
string
 
 
 
 
 
 
 
quantity
items
double
 
 
 
 
 
 
 
inventoryType
items
string
 
 
 
 
 
 
 
items
resourcePreferences
list
 
 
 
 
 
 
 
resourceId
items
string
 
 
 
 
 
 
 
resourceInternalId
items
integer
 
 
 
 
 
 
 
preferenceType
items
string
 
 
 
Added these mappings to suppor only 5 Reading resgisters in OFSC
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_read_seq2
 
integer
 
 
 
 
timeOfUse
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_TOU2
 
string
 
 
 
 
overrideReading
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_override_reading2
activities
enum
 
 
 
 
unitOfMeasure
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_uom2
activities
string
 
 
 
 
numberOfDials
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_dials2
activities
integer
 
 
 
 
lowerLimit
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_lower_limit2
activities
string
 
 
 
 
upperLimit
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_upper_limit2
activities
string
 
 
 
 
reading
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_current_index2
activities
string
 
 
 
 
sqi
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_sqi2
activities
string
 
 
 
 
timeOfUse
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_TOU2
activities
string
 
 
 
 
numberOfDecimals
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_numberofDecimals2
activities
integer
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_read_seq3
activities
integer
 
 
 
 
unitOfMeasure
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_uom3
activities
string
 
 
 
 
numberOfDials
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_dials3
activities
integer
 
 
 
 
sqi
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_sqi3
activities
string
 
 
 
 
lowerLimit
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_lower_limit3
activities
string
 
 
 
 
upperLimit
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_upper_limit3
activities
string
 
 
 
 
reading
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_current_index3
activities
string
 
 
 
 
timeOfUse
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_TOU3
activities
string
 
 
 
 
numberOfDecimals
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_numberofDecimals3
activities
integer
 
 
 
 
overrideReading
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_override_reading3
activities
enum
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_read_seq4
activities
integer
 
 
 
 
unitOfMeasure
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_uom4
activities
string
 
 
 
 
numberOfDials
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_dials4
activities
integer
 
 
 
 
sqi
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_sqi4
activities
string
 
 
 
 
lowerLimit
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_lower_limit4
activities
string
 
 
 
 
upperLimit
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_upper_limit4
activities
string
 
 
 
 
reading
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_current_index4
activities
string
 
 
 
 
timeOfUse
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_TOU4
activities
string
 
 
 
 
numberOfDecimals
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_numberofDecimals4
activities
integer
 
 
 
 
overrideReading
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_override_reading4
activities
enum
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_read_seq5
activities
integer
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_uom5
activities
string
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_dials5
activities
integer
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_lower_limit5
activities
string
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_upper_limit5
activities
string
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_current_index5
activities
string
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_TOU5
activities
string
 
 
 
 
sqi
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_sqi5
activities
string
 
 
 
 
overrideReading
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_override_reading5
activities
enum
 
 
 
 
readSequence
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_existing_meter_numberofDecimals5
activities
integer
 
 
 
 
lifeSupport
D1-FieldActivityOBComm/sendDetail/activities/activityutilityCommonActivityDetails
Field
c2m_life_support
SOMOFSC_LifeSupport
SOM_LifeSupport
OFSC_LifeSupport
 
 
 
hostExternalSystem
D1-FieldActivityOBComm/sendDetail/hostExternalSystem
Field
c2m_xa_product
SOMOFSC_ConfigProps
SOM_ConfigProps
OFSC_ConfigProps
 
 
 
servicePointTypeCode
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_SP_type_code
activities
string
 
 
 
 
servicePointTypeDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_SP_type_description
activities
string
 
 
 
 
servicePointStatus
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_SP_status
activities
string
 
 
 
 
serviceType
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_Service_type
activities
string
 
 
 
 
serviceTypeDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_Service_type_description
activities
string
 
 
 
 
deviceLocation
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_dev_location
SOMOFSC_DeviceLocation
SOM_DeviceLocation
OFSC_DeviceLocation
 
 
 
deviceLocationDetails
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_device_location_details
activities
string
 
 
 
 
measurementCycle
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_measurement_cycle
activities
string
 
 
 
 
measurementCycleRoute
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_measurement_cycle_route
activities
string
 
 
 
 
key
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_key
activities
string
 
 
 
 
keyId
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_key_id
activities
string
 
 
 
 
servicePointUDF1
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_SP_UDF1
activities
string
 
 
 
 
servicePointUDF2
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_SP_UDF2
activities
string
 
 
 
 
servicePointUDF3
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_SP_UDF3
activities
string
 
 
 
 
servicePointUDF4
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_SP_UDF4
activities
string
 
 
 
 
servicePointUDF5
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_SP_UDF5
activities
string
 
 
 
 
premiseType
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_premise_type
activities
string
 
 
 
 
premiseTypeDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_premise_type_description
activities
string
 
 
 
 
premiseUDF1
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_premise_UDF1
activities
string
 
 
 
 
premiseUDF2
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_premise_UDF2
activities
string
 
 
 
 
premiseUDF3
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_premise_UDF3
activities
string
 
 
 
 
premiseUDF4
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_premise_UDF4
activities
string
 
 
 
 
premiseUDF5
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_premise_UDF5
activities
string
 
 
 
 
serviceAgreementId
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_id
activities
string
 
 
 
 
serviceAgreementStatus
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_status
activities
string
 
 
 
 
cisDivision
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_cis_division
activities
string
 
 
 
 
serviceAgreementType
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_type
activities
string
 
 
 
 
serviceAgreementTypeDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_type_description
activities
string
 
 
 
 
serviceAgreementStartDate
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_start_date
activities
string
 
 
 
 
serviceAgreementEndDate
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_end_date
activities
string
 
 
 
 
rateSchedule
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_rate_schedule
activities
string
 
 
 
 
rateScheduleDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_rate_schedule_description
activities
string
 
 
 
 
serviceAgreementUDF1
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_UDF1
activities
string
 
 
 
 
serviceAgreementUDF2
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_UDF2
activities
string
 
 
 
 
serviceAgreementUDF3
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_UDF3
activities
string
 
 
 
 
serviceAgreementUDF4
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_UDF4
activities
string
 
 
 
 
serviceAgreementUDF5
D1-FieldActivityOBComm/sendDetail/activities/activity/servicePointDataDetails/
Field
c2m_service_agreement_UDF5
activities
string
 
 
 
 
email
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_email
activities
string
 
 
 
 
personUDF1
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_personUDF1
activities
string
 
 
 
 
personUDF2
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_personUDF2
activities
string
 
 
 
 
personUDF3
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_personUDF3
activities
string
 
 
 
 
personUDF4
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_personUDF4
activities
string
 
 
 
 
personUDF5
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_personUDF5
activities
string
 
 
 
 
billCycle
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_billCycle
activities
string
 
 
 
 
collectionClass
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_collectionClass
activities
string
 
 
 
 
billAmount
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_billAmount
activities
string
SOMOFSC_ConfigProps
PropertyName='ofsc.currency'
Value
Concatenates the bill amount with the currency value
billDate
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_billDate
activities
string
 
 
 
 
accountUDF1
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_accountUDF1
activities
string
 
 
 
 
accountUDF2
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_accountUDF2
activities
string
 
 
 
 
accountUDF3
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_accountUDF3
activities
string
 
 
 
 
accountUDF4
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_accountUDF4
activities
string
 
 
 
 
accountUDF5
D1-FieldActivityOBComm/sendDetail/activities/activity/customerInformation/
Field
c2m_accountUDF5
activities
string
 
 
 
 
measurementCondition
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_1
SOMOFSC_MeasurementCondition
SOM_MeasurementCondition
OFSC_MeasurementCondition
 
 
 
measurementConditionDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_description
activities
string
 
 
 
 
measurementCondition
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_2
SOMOFSC_MeasurementCondition
SOM_MeasurementCondition
OFSC_MeasurementCondition
 
 
 
measurementConditionDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_description2
activities
string
 
 
 
 
measurementCondition
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_3
SOMOFSC_MeasurementCondition
SOM_MeasurementCondition
OFSC_MeasurementCondition
 
 
 
measurementConditionDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_description3
activities
string
 
 
 
 
measurementCondition
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_4
SOMOFSC_MeasurementCondition
SOM_MeasurementCondition
OFSC_MeasurementCondition
 
 
 
measurementConditionDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_description4
activities
string
 
 
 
 
measurementCondition
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_5
SOMOFSC_MeasurementCondition
SOM_MeasurementCondition
OFSC_MeasurementCondition
 
 
 
measurementConditionDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/readingDetails/readingDetailsList
Field
c2m_measurement_condition_description5
activities
string
 
 
 
 
deviceType
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_deviceType
activities
string
 
 
 
 
deviceTypeDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_deviceTypeDescription
activities
string
 
 
 
 
specification
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_specification
activities
string
 
 
 
 
specificationDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_specificationDescription
activities
string
 
 
 
 
configuration
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_configuration
activities
string
 
 
 
 
headendSystem
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_headendSystem
activities
string
 
 
 
 
headendSystemDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_headendSystemDescription
activities
string
 
 
 
 
deviceUDF1
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_deviceUDF1
activities
string
 
 
 
 
deviceUDF2
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_deviceUDF2
activities
string
 
 
 
 
deviceUDF3
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_deviceUDF3
activities
string
 
 
 
 
deviceUDF4
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_deviceUDF4
activities
string
 
 
 
 
deviceUDF5
D1-FieldActivityOBComm/sendDetail/activities/activity/meterDataDetails/
Field
c2m_deviceUDF5
activities
string
 
 
 
 
deviceType
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails/
Field
c2m_item_device_type
activities
string
 
 
 
 
deviceTypeDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails/
Field
c2m_item_device_type_description
activities
string
 
 
 
 
specification
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails/
Field
c2m_item_specification
activities
string
 
 
 
 
specificationDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails/
Field
c2m_item_specification_description
activities
string
 
 
 
 
configuration
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails/
Field
c2m_item_configuration
activities
string
 
 
 
 
headendSystem
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails/
Field
c2m_item_headendsystem
activities
string
 
 
 
 
headendSystemDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/itemDataDetails/
Field
c2m_item_headendsystem_description
activities
string
 
 
 
 
lifeSupportSensitiveLoadDescription
D1-FieldActivityOBComm/sendDetail/activities/activity/utilityCommonActivityDetails/
Field
c2m_life_support_description
activities
string
 
 
 
 
 
 
Group
inventories
inventory
 
 
 
 
 
 
D1-FieldActivityOBComm/sendDetail/activities/servicePointDataDetails/servicePointEquipmentDetails/equipmentList
List
items
inventory
 
 
 
 
 
 
 
field
inventoryType
inventory
String
 
 
 
Hard code this value with "SERT" in case the equipment details are coming under servicePointEquipmentDetails element from the SOM
equipmentId
D1-FieldActivityOBComm/sendDetail/activities/servicePointDataDetails/servicePointEquipmentDetails/equipmentList
field
serialNumber
inventory
String
 
 
 
 
badgeNumber
D1-FieldActivityOBComm/sendDetail/activities/servicePointDataDetails/servicePointEquipmentDetails/equipmentList
field
c2m_ert_badgeNumber
inventory
String
 
 
 
 
serialNumber
D1-FieldActivityOBComm/sendDetail/activities/servicePointDataDetails/servicePointEquipmentDetails/equipmentList
field
c2m_ert_serialNumber
inventory
String
 
 
 
 
attachDateTime
D1-FieldActivityOBComm/sendDetail/activities/servicePointDataDetails/servicePointEquipmentDetails/equipmentList
field
c2m_ert_attachDateTime
inventory
String
 
 
 
Takes the sub string from (0,20) and translates T to " "
 
D1-FieldActivityOBComm/sendDetail/activities/meterDataDetails/meterEquipmentDetail/equipmentList
List
items
inventory
 
 
 
 
 
 
 
field
inventoryType
inventory
String
 
 
 
Hard code with CERT when uom value is not empty otherwise hard code with MERT
equipmentId
D1-FieldActivityOBComm/sendDetail/activities/meterDataDetails/meterEquipmentDetail/equipmentList
field
serialNumber
inventory
String
 
 
 
 
badgeNumber
D1-FieldActivityOBComm/sendDetail/activities/meterDataDetails/meterEquipmentDetail/equipmentList
field
c2m_ert_badgeNumber
inventory
String
 
 
 
 
serialNumber
D1-FieldActivityOBComm/sendDetail/activities/meterDataDetails/meterEquipmentDetail/equipmentList
field
c2m_ert_serialNumber
inventory
String
 
 
 
 
attachDateTime
D1-FieldActivityOBComm/sendDetail/activities/meterDataDetails/meterEquipmentDetail/equipmentList
field
c2m_ert_attachDateTime
inventory
String
 
 
 
Takes the sub string from (0,20) and translate T to " "
uom
D1-FieldActivityOBComm/sendDetail/activities/meterDataDetails/meterEquipmentDetail/equipmentList
field
c2m_ert_uom
inventory
String
 
 
 
 
tou
D1-FieldActivityOBComm/sendDetail/activities/meterDataDetails/meterEquipmentDetail/equipmentList
field
c2m_ert_tou
inventory
String
 
 
 
 
sqi
D1-FieldActivityOBComm/sendDetail/activities/meterDataDetails/meterEquipmentDetail/equipmentList
field
c2m_ert_sqi
inventory
String
 
 
 
 
Oracle Utilities Operational Device Management Activities Support
 
validServiceHistoryTypes
D1-FieldActivityOBComm/sendDetail
group
c2m_act_valid_service_history_types
activities
 
 
 
 
 
validServiceHistoryTypes
D1-FieldActivityOBComm/sendDetail/deviceDetails
group
c2m_dev_valid_service_history_types
activities
 
 
 
 
 
serviceHistoryTypes
D1-FieldActivityOBComm/sendDetail
group
c2m_act_service_history_types1
activities
 
 
 
 
 
deviceDetails
sendDetail
group
 
 
 
 
 
 
 
validServiceHistoryTypes
deviceDetails
group
c2m_dev_valid_service_history_types
activities
 
 
 
 
Gets content as string and maps it to OFSC field
serviceHistoryTypeList
validServiceHistoryTypes
list
 
 
 
 
 
 
 
serviceHistoryType
serviceHistoryTypeList
string
 
 
 
 
 
 
 
assetSpecific
serviceHistoryTypeList
string
 
 
 
 
 
 
 
 
Response Mappings
The response mapping details in the Process Activity integration point are shown in the table below.
Oracle Field Service Process Activity Response Message
Oracle Utilities Service Order Management Activity Response
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Oracle Field Service Column
Oracle Utilities Service Order Management Column
 
bulkUpdate_POSTResponse
 
OutermostTag
responseDetail
 
OutermostTag
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
dispatcherNotified
responseDetail
 
 
 
 
 
 
 
 
failedCancellation
responseDetail
Group
 
 
 
 
 
 
 
tasks
responseDetail/failedCancellation
List
 
 
 
 
activityId
activityKeys
String
taskId
responseDetail/failedCancellation/tasks
Field
 
 
 
 
 
 
 
messageId
responseDetail
Field
 
 
 
 
operationsPerformed
results
String
messageStatus
responseDetail
Field
 
 
 
If operationsPerformed ='changeActivityStatus' then messageStaus=Y
activityId
results
String
messageText
responseDetail
Field
 
 
 
If operationsPerformed ='createActivity' then messageText=concat('OFSC Activity ID ','activityId')
 
 
 
 
 
 
 
 
 
 
 
 
 
messageData
responseDetail
Group
 
 
 
 
 
 
 
messageCategory
responseDetail/messageData
Field
 
 
 
 
 
 
 
messageNumber
responseDetail/messageData
Field
 
 
 
 
 
 
 
messageParameters
responseDetail/messageData
Group
 
 
 
 
 
 
 
parameters
responseDetail/messageData/messageParameters
List
 
 
 
 
 
 
 
parameterType
responseDetail/messageData/messageParameters/parameters
Field
 
 
 
 
 
 
 
parameterValue
responseDetail/messageData/messageParameters/parameters
Field
 
 
 
 
 
 
 
fault
responseDetail
 
 
 
 
 
operationsFailed
results
String
faultCode
responseDetail/fault
 
 
 
 
 
errorDetail
errors
String
faultString
responseDetail/fault
 
 
 
 
 
 
 
 
faultActor
responseDetail/fault
 
 
 
 
 
 
 
 
detail
responseDetail/fault
RAW
 
 
 
 
 
 
 
 
 
 
 
 
 
 
activities.definitions.customActionActivityBulkUpdateSchemaResponse
bulkUpdate_POSTResponse
Group
 
 
 
 
 
 
 
results
activities.definitions.customActionActivityBulkUpdateSchemaResponse
List
 
 
 
 
 
 
 
errors
results
List
 
 
 
 
 
 
 
activityKeys
results
Group
 
 
 
 
 
 
 
operation
errors
String
 
 
 
 
 
 
 
apptNumber
activityKeys
String
 
 
 
 
 
 
 
customerNumber
activityKeys
String
 
 
 
 
 
 
 
 
Cancel Activity Mappings
The cancel activity mapping details in the Process Activity integration point are shown in the table below.
Oracle Utilities Service Order Management Request Message
Oracle Field Service Request Message
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Oracle Utilities Service Order Management Column
Oracle Field Service Column
 
 
sendDetail
D1-FieldActivityOBComm
OutermostTag
bulkUpdate_POST
 
OutermostTag
 
 
 
 
 
 
 
activities.definitions.customActionActivityBulkUpdateSchema
bulkUpdate_POST
Group
 
 
 
 
 
 
 
updateParameters
activities.definitions.customActionActivityBulkUpdateSchema
Group
 
 
 
 
 
 
 
activities
activities.definitions.customActionActivityBulkUpdateSchema
List
 
 
 
 
 
 
 
identifyActivityBy
updateParameters
string
 
 
 
apptNumber
 
 
 
ifInFinalStatusThen
updateParameters
string
 
 
 
doNothing
 
 
 
ifExistsThenDoNotUpdateFields
updateParameters
string
 
 
 
 
 
 
 
resourceId
activities
string
 
 
 
 
 
 
 
accessSchedule
activities
string
 
 
 
 
 
 
 
resourceInternalId
activities
integer
 
 
 
 
 
 
 
date
activities
string
 
 
 
 
hostExternalId
D1-FieldActivityOBComm/sendDetail/activities/activity
Field
apptNumber
activities
string
 
 
 
 
 
 
 
status
activities
string
 
 
 
cancelled
 
 
 
c2m_xa_cn
activities
string
 
 
 
SOM_Cancelled
Cancel Response
The cancel activity mapping details in the Process Activity integration point are shown in the table below.
Oracle Field Service Process Activity Response Message
Oracle Utilities Service Order Management Activity Response Message
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Oracle Field Service Column
Oracle Utilities Service Order Management Column
 
bulkUpdate_POSTResponse
 
OutermostTag
responseDetail
 
OutermostTag
 
 
 
 
operationsPerformed
results
String
dispatcherNotified
responseDetail
 
 
 
 
If operationsPerformed ='changeActivityStatus' then dispatcherNotified=N
 
 
 
failedCancellation
responseDetail
Group
 
 
 
 
 
 
 
tasks
responseDetail/failedCancellation
List
 
 
 
 
activityId
activityKeys
String
taskId
responseDetail/failedCancellation/tasks
Field
 
 
 
 
 
 
 
messageId
responseDetail
Field
 
 
 
 
operationsPerformed
results
String
messageStatus
responseDetail
Field
 
 
 
If operationsPerformed ='changeActivityStatus' then messageStatus=Y
operationsPerformed
results
String
messageText
responseDetail
Field
 
 
 
If operationsPerformed ='changeActivityStatus' then messageText=Cancelled
 
 
 
messageData
responseDetail
Group
 
 
 
 
 
 
 
messageCategory
responseDetail/messageData
Field
 
 
 
 
 
 
 
messageNumber
responseDetail/messageData
Field
 
 
 
 
 
 
 
messageParameters
responseDetail/messageData
Group
 
 
 
 
 
 
 
parameters
responseDetail/messageData/messageParameters
List
 
 
 
 
 
 
 
parameterType
responseDetail/messageData/messageParameters/parameters
Field
 
 
 
 
 
 
 
parameterValue
responseDetail/messageData/messageParameters/parameters
Field
 
 
 
 
 
 
 
fault
responseDetail
 
 
 
 
 
operationsFailed
results
String
faultCode
responseDetail/fault
 
 
 
 
 
errorDetail
errors
String
faultString
responseDetail/fault
 
 
 
 
 
 
 
 
faultActor
responseDetail/fault
 
 
 
 
 
 
 
 
detail
responseDetail/fault
RAW
 
 
 
 
activities.definitions.customActionActivityBulkUpdateSchemaResponse
bulkUpdate_POSTResponse
Group
 
 
 
 
 
 
 
results
activities.definitions.customActionActivityBulkUpdateSchemaResponse
List
 
 
 
 
 
 
 
errors
results
List
 
 
 
 
 
 
 
activityKeys
results
Group
 
 
 
 
 
 
 
operation
errors
String
 
 
 
 
 
 
 
apptNumber
activityKeys
String
 
 
 
 
 
 
 
customerNumber
activityKeys
String
 
 
 
 
 
 
 
 
Remote Fault
The remote fault mapping details in the Process Activity integration point are shown in the table below.
Oracle Integration Cloud Global Fault
Oracle Utilities Service Order Management Activity Response Message
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Oracle Field Service Column
Oracle Utilities Service Order Management Column
 
fault
 
OutermostTag
responseDetail
 
OutermostTag
 
 
 
 
 
 
 
dispatcherNotified
responseDetail
 
 
 
 
If operationsPerformed ='changeActivityStatus' then dispatcherNotified=N
details
fault
String
 
 
 
 
 
 
 
 
 
 
failedCancellation
responseDetail
Group
 
 
 
 
 
 
 
tasks
responseDetail/failedCancellation
List
 
 
 
 
 
 
 
taskId
responseDetail/failedCancellation/tasks
Field
 
 
 
 
 
 
 
messageId
responseDetail
Field
 
 
 
 
 
 
 
messageStatus
responseDetail
Field
 
 
 
If operationsPerformed ='changeActivityStatus' then messageStatus=Y
reason
fault
String
messageText
responseDetail
Field
 
 
 
If operationsPerformed ='changeActivityStatus' then messageText=Cancelled
 
 
 
messageData
responseDetail
Group
 
 
 
 
 
 
 
messageCategory
responseDetail/messageData
Field
 
 
 
 
 
 
 
messageNumber
responseDetail/messageData
Field
 
 
 
 
 
 
 
messageParameters
responseDetail/messageData
Group
 
 
 
 
details
fault
String
parameters
responseDetail/messageData/messageParameters
List
 
 
 
 
 
 
 
parameterType
responseDetail/messageData/messageParameters/parameters
Field
 
 
 
 
 
 
 
parameterValue
responseDetail/messageData/messageParameters/parameters
Field
 
 
 
 
 
 
 
fault
responseDetail
 
 
 
 
 
errorCode
fault
Sring
faultCode
responseDetail/fault
 
 
 
 
 
 
 
 
faultString
responseDetail/fault
 
 
 
 
 
 
 
 
faultActor
responseDetail/fault
 
 
 
 
 
 
 
 
detail
responseDetail/fault
RAW
 
 
 
 
 
Technical Fault
The technical fault mapping details in the Process Activity integration point are shown in the table below.
Oracle Integration Cloud Global Fault
Oracle Utilities Service Order Management Activity Response Message
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Oracle Field Service Column
Oracle Utilities Service Order Management Column
 
fault
 
OutermostTag
responseDetail
 
OutermostTag
 
 
 
 
 
 
 
dispatcherNotified
responseDetail
 
 
 
 
If operationsPerformed ='changeActivityStatus' then dispatcherNotified=N
details
fault
String
 
 
 
 
 
 
 
 
 
 
failedCancellation
responseDetail
Group
 
 
 
 
 
 
 
tasks
responseDetail/failedCancellation
List
 
 
 
 
 
 
 
taskId
responseDetail/failedCancellation/tasks
Field
 
 
 
 
 
 
 
messageId
responseDetail
Field
 
 
 
 
 
 
 
messageStatus
responseDetail
Field
 
 
 
If operationsPerformed ='changeActivityStatus' then messageStatus=Y
reason
fault
String
messageText
responseDetail
Field
 
 
 
If operationsPerformed ='changeActivityStatus' then messageText=Cancelled
 
 
 
messageData
responseDetail
Group
 
 
 
 
 
 
 
messageCategory
responseDetail/messageData
Field
 
 
 
 
 
 
 
messageNumber
responseDetail/messageData
Field
 
 
 
 
 
 
 
messageParameters
responseDetail/messageData
Group
 
 
 
 
details
fault
String
parameters
responseDetail/messageData/messageParameters
List
 
 
 
 
 
 
 
parameterType
responseDetail/messageData/messageParameters/parameters
Field
 
 
 
 
 
 
 
parameterValue
responseDetail/messageData/messageParameters/parameters
Field
 
 
 
 
 
 
 
fault
responseDetail
 
 
 
 
 
errorCode
fault
Sring
faultCode
responseDetail/fault
 
 
 
 
 
 
 
 
faultString
responseDetail/fault
 
 
 
 
 
 
 
 
faultActor
responseDetail/fault
 
 
 
 
 
 
 
 
detail
responseDetail/fault
RAW