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 | |||||||
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 | |||||||
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 | ||||||
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 | |||||||
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 | |||||||
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 | |||||||