Oracle Field Service Activity Created Event Message | Oracle Utilities Service Order Management Inbound Field Activity Request Message | DVM Mapping | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Field Service Column | Oracle Utilities Service Order Management Column | |
notify_POST | OutermostTag | D1-FARequestSynchronous | OutermostTag | ||||||
request | Group | ||||||||
events.definitions.activityEvent | notify_POST | Group | |||||||
applicationId | events.definitions.activityEvent | string | |||||||
time | events.definitions.activityEvent | string | |||||||
eventType | events.definitions.activityEvent | string | |||||||
activityDetails | events.definitions.activityEvent | Group | |||||||
resourceId | activityDetails | string | |||||||
date | activityDetails | string | |||||||
apptNumber | activityDetails | string | |||||||
customerNumber | activityDetails | string | |||||||
activityChanges | events.definitions.activityEvent | Group | |||||||
sourceSystem | request | string | SOMOFSC_ConfigProps.dvm | PropertyName=som.externalsystem | value= OFSC | ||||
externalActTypeIdentifier | request | string | |||||||
fieldTaskType | request | string | |||||||
activityType | activityChanges | string | taskType | request | string | SOMOFSC_ActivityType.dvm | OFSC_ActivityType | SOM_TaskType | |
c2m_service_pt_id | activityChanges | string | spId | request | string | ||||
somStatus | request | string | |||||||
activityId | activityDetails | integer | relatedActivityId | request | string | ||||
externalReferenceId | request | string | |||||||
externalSPType | request | string | |||||||
custDvcCompatibilityOverride | request | string | |||||||
externalActivityElement | request | List | |||||||
activityId | activityDetails | integer | requesterTransactionId | externalActivityElement | string | ||||
faType | externalActivityElement | string | |||||||
faStatus | externalActivityElement | string | |||||||
servicePointExternalId | externalActivityElement | string | |||||||
timeOfBooking | activityChanges | string | startDateTime | externalActivityElement | string | SOMOFSC_ConfigProp.dvm OFSCSOM_TimeZone | PropertyName=som.offset | Value=true | Use SOMOFSC_DateTimeZoneConversion extension library function to convert the datetime based on the timezone & offset |
user | events.definitions.activityEvent | string | requesterUserId | externalActivityElement | string | ||||
ACTIVITY_NOTES | activityChanges | string | comments | externalActivityElement | string | ||||
instructions | externalActivityElement | string | |||||||
customElements | externalActivityElement | anytype | |||||||
addressConstituents | request | group | |||||||
country_code | activityChanges | string | country | addressConstituents | string | OFSCSOM_Country_code.dvm | OFSC_CountryCode | SOM_CountryCode | |
postalCode | activityChanges | string | postal | addressConstituents | string | ||||
streetAddress | activityChanges | string | address1 | addressConstituents | string | Need to split ofsc street address value on delimeter ',' basis and map to som address1,2,3,4 values; Use "SOMOFSC_NoOfOccurances" extension library function to count the delimeters in the string | |||
address2 | addressConstituents | string | |||||||
address3 | addressConstituents | string | |||||||
address4 | addressConstituents | string | |||||||
city | activityChanges | string | city | addressConstituents | string | ||||
number1 | addressConstituents | string | |||||||
number2 | addressConstituents | string | |||||||
county | addressConstituents | string | |||||||
houseType | addressConstituents | string | |||||||
geographic | addressConstituents | string | |||||||
inCityLimit | addressConstituents | string | |||||||
stateProvince | activityChanges | string | state | addressConstituents | string | ||||
latitude | activityChanges | double | geocodeLatitude | addressConstituents | string | ||||
longitude | activityChanges | double | geocodeLongitude | addressConstituents | string | ||||
saList | request | list | |||||||
eventType | saList | string | |||||||
saId | saList | string | |||||||
contactDetails | request | group | |||||||
customerInformation | contactDetails | group | |||||||
customerName | activityChanges | string | customerName | customerInformation | string | ||||
contactName | customerInformation | string | |||||||
customerPhone | activityChanges | string | mainPhone | customerInformation | string | ||||
customerCell | activityChanges | string | cellPhone | customerInformation | string | ||||
accountId | customerInformation | string | |||||||
personId | customerInformation | string | |||||||
isAppointmentNecessary | customerInformation | string | SOMOFSC_ConfigProps.dvm | PropertyName=pickuporder.apptneeded | Value=N | ||||
cancelReasonCode | customerInformation | string | |||||||
cancelReasonDesc | customerInformation | string | |||||||
activityId | activityChanges | integer | |||||||
masterActivityId | activityChanges | integer | |||||||
resourceId | activityChanges | string | |||||||
accessSchedule | activityChanges | string | |||||||
resourceInternalId | activityChanges | integer | |||||||
date | activityChanges | string | |||||||
apptNumber | activityChanges | string | |||||||
recordType | activityChanges | string | |||||||
status | activityChanges | string | |||||||
workZone | activityChanges | string | |||||||
duration | activityChanges | integer | |||||||
timeDeliveredStart | activityChanges | string | |||||||
timeDeliveredEnd | activityChanges | string | |||||||
travelTime | activityChanges | integer | |||||||
timeSlot | activityChanges | string | |||||||
customerNumber | activityChanges | string | |||||||
customerEmail | activityChanges | string | |||||||
language | activityChanges | string | |||||||
languageISO | activityChanges | string | |||||||
reminderTime | activityChanges | integer | |||||||
timeZone | activityChanges | string | |||||||
timeZoneIANA | activityChanges | string | |||||||
slaWindowStart | activityChanges | string | |||||||
slaWindowEnd | activityChanges | string | |||||||
deliveryWindowStart | activityChanges | string | |||||||
deliveryWindowEnd | activityChanges | string | |||||||
serviceWindowStart | activityChanges | string | |||||||
serviceWindowEnd | activityChanges | string | |||||||
endTime | activityChanges | string | |||||||
positionInRoute | activityChanges | integer | |||||||
teamResourceId | activityChanges | string | |||||||
points | activityChanges | integer | |||||||
timeOfAssignment | activityChanges | string | |||||||
firstManualOperation | activityChanges | string | |||||||
firstManualOperationUser | activityChanges | string | |||||||
resourceTimeZone | activityChanges | string | |||||||
resourceTimeZoneIANA | activityChanges | string | |||||||
resourceTimeZoneDiff | activityChanges | integer | |||||||
multidayTimeToComplete | activityChanges | integer | |||||||
ACTIVITY_TYPE | activityChanges | string | |||||||
WO_TYPE | activityChanges | string | |||||||
WO_CLASS | activityChanges | string | |||||||
JOB_NUMBER | activityChanges | string | |||||||
COD | activityChanges | string | |||||||
WO_COMMENTS | activityChanges | string | |||||||
DISPATCHER_COMMENTS | activityChanges | string | |||||||
PROBLEM_CODE | activityChanges | string | |||||||
MAP_GRID | activityChanges | string | |||||||
NODE_ID | activityChanges | string | |||||||
TAG_NUMBER | activityChanges | string | |||||||
SERVICES | activityChanges | string | |||||||
ICOMS_ETA_STATUS | activityChanges | string | |||||||
ICOMS_MANUAL_ETA_STATUS | activityChanges | string | |||||||
FINDING_CODE | activityChanges | string | |||||||
SOLUTION_CODE | activityChanges | string | |||||||
FAULT_CODE | activityChanges | string | |||||||
CLOSURE_NOTES | activityChanges | string | |||||||
CANCEL_REASON | activityChanges | string | |||||||
CANCEL_HOUSING_TYPE | activityChanges | string | |||||||
CANCEL_HOUSE_COLOR | activityChanges | string | |||||||
CANCEL_DOOR_COLOR | activityChanges | string | |||||||
ASRO_REPLACE_OUTLET | activityChanges | string | |||||||
ASRO_DEDICATE_RR_OUTLET | activityChanges | string | |||||||
ASRO_REPLACE_BURY_FOOTAGE | activityChanges | string | |||||||
ASRO_REPLACE_CABLE | activityChanges | string | |||||||
ASRO_REPLACE_AERIAL_FOOTAGE | activityChanges | string | |||||||
ASRO_REPLACE_AERIAL_CABLE | activityChanges | string | |||||||
ASRO_REPLACE_HR_2_SPLITTER | activityChanges | string | |||||||
ASRO_DRIVEWAY_BORE_NEEDED | activityChanges | integer | |||||||
ASRO_SIDEWALK_BORE_NEEDED | activityChanges | integer | |||||||
ASRO_TMP_CABLE_4_CONTRACT | activityChanges | integer | |||||||
ASRO_DROP_BONDED_TO_POWER | activityChanges | integer | |||||||
ASRO_COMMENTS | activityChanges | string | |||||||
NOT_DONE_CODE | activityChanges | string | |||||||
Points | activityChanges | integer | |||||||
cdaybefore_flag | activityChanges | integer | |||||||
cconfirmed | activityChanges | integer | |||||||
csign | activityChanges | events.definitions.activityChanges.csign | |||||||
PAS1 | activityChanges | string | |||||||
PAS2 | activityChanges | string | |||||||
PAS3a | activityChanges | string | |||||||
PAS4 | activityChanges | string | |||||||
PAS5 | activityChanges | string | |||||||
PAS6 | activityChanges | string | |||||||
PAS_Recorded_Message | activityChanges | events.definitions.activityChanges.PAS_Recorded_Message | |||||||
PAS3b | activityChanges | string | |||||||
PAS_Recording_CSR_Notes | activityChanges | string | |||||||
pricer | activityChanges | string | |||||||
service_codes | activityChanges | string | |||||||
work_agreement_sign | activityChanges | events.definitions.activityChanges.work_agreement_sign | |||||||
notification_email | activityChanges | string | |||||||
notifications_phone | activityChanges | string | |||||||
Place_of_activity | activityChanges | string | |||||||
I_wear_special_safety_belt | activityChanges | integer | |||||||
I_used_colleague_assistance | activityChanges | integer | |||||||
Made_sure_the_electricity_is_off | activityChanges | integer | |||||||
Authorized_for_high_altitude_work | activityChanges | integer | |||||||
The_weather_is_suitable | activityChanges | integer | |||||||
I_know_the_risks | activityChanges | integer | |||||||
House_or_Door_photo | activityChanges | events.definitions.activityChanges.House_or_Door_photo | |||||||
Dog_photo | activityChanges | events.definitions.activityChanges.Dog_photo | |||||||
Equipment_description | activityChanges | string | |||||||
Issue_reason | activityChanges | string | |||||||
Installation_failures | activityChanges | string | |||||||
Source_of_damage | activityChanges | string | |||||||
Damaged_equipment_description | activityChanges | string | |||||||
What_was_done | activityChanges | string | |||||||
Cable_length | activityChanges | string | |||||||
email_notifications_status | activityChanges | integer | |||||||
phone_notifications_status | activityChanges | integer | |||||||
job_hazards | activityChanges | string | |||||||
hazard_1 | activityChanges | string | |||||||
hazard_2 | activityChanges | string | |||||||
hazard_3 | activityChanges | string | |||||||
complete_code | activityChanges | string | |||||||
plant_code | activityChanges | string | |||||||
snr | activityChanges | string | |||||||
low_ch | activityChanges | string | |||||||
mid_ch | activityChanges | string | |||||||
upper_ch | activityChanges | string | |||||||
no_ports | activityChanges | integer | |||||||
tap_value | activityChanges | integer | |||||||
find_code_1 | activityChanges | string | |||||||
find_code_2 | activityChanges | string | |||||||
find_code_3 | activityChanges | string | |||||||
solution_code_1a | activityChanges | string | |||||||
solution_code_1b | activityChanges | string | |||||||
solution_code_1c | activityChanges | string | |||||||
solution_code_1d | activityChanges | string | |||||||
solution_code_1e | activityChanges | string | |||||||
solution_code_2a | activityChanges | string | |||||||
solution_code_2b | activityChanges | string | |||||||
solution_code_2c | activityChanges | string | |||||||
solution_code_2d | activityChanges | string | |||||||
solution_code_2e | activityChanges | string | |||||||
solution_code_3a | activityChanges | string | |||||||
solution_code_3b | activityChanges | string | |||||||
solution_code_3c | activityChanges | string | |||||||
solution_code_3d | activityChanges | string | |||||||
solution_code_3e | activityChanges | string | |||||||
tech_signature | activityChanges | events.definitions.activityChanges.tech_signature | |||||||
Animal_secured | activityChanges | integer | |||||||
High_winds | activityChanges | integer | |||||||
Ladder_secured | activityChanges | integer | |||||||
Safety_gear | activityChanges | integer | |||||||
Ventillation | activityChanges | integer | |||||||
Electric_line | activityChanges | integer | |||||||
Alternative_route | activityChanges | integer | |||||||
sub_type | activityChanges | string | |||||||
last_tech_out | activityChanges | string | |||||||
XA_CAND_NAME | activityChanges | string | |||||||
XA_MODEL_SITE_TYPE | activityChanges | string | |||||||
XA_SHARING_ID | activityChanges | string | |||||||
XA_COLLOCATION | activityChanges | string | |||||||
XA_CN | activityChanges | string | |||||||
XA_NOMINAL_PLAN | activityChanges | string | |||||||
XA_SALES_REP | activityChanges | string | |||||||
XA_UNIT_MODEL | activityChanges | string | |||||||
XA_BRAND | activityChanges | string | |||||||
XA_SERIAL_NUMBER | activityChanges | string | |||||||
XA_CONTRACT_COVERAGE | activityChanges | string | |||||||
XA_PROBLEM_SUMMARY | activityChanges | string | |||||||
XA_ODOMETER | activityChanges | string | |||||||
XA_GAS_PRESSURE | activityChanges | string | |||||||
XA_PHYSICAL_DAMAGE | activityChanges | integer | |||||||
XA_SAFETY_CHECK | activityChanges | string | |||||||
XA_WORK_ORDER | activityChanges | string | |||||||
XA_SERVICE_LEVEL | activityChanges | string | |||||||
XA_RESTOCK_NEEDED | activityChanges | integer | |||||||
XA_PART_NUMBER | activityChanges | string | |||||||
XA_PART_QUANTITY | activityChanges | string | |||||||
XA_SHIPPING_METHOD | activityChanges | string | |||||||
XA_PART_COST | activityChanges | string | |||||||
XA_LABOR_COST | activityChanges | string | |||||||
XA_TAX | activityChanges | string | |||||||
XA_TOTAL_COST | activityChanges | string | |||||||
XA_TASK_TYPE | activityChanges | string | |||||||
XA_CASE_CONTACT | activityChanges | string | |||||||
XA_CASE_TYPE | activityChanges | string | |||||||
XA_CASE_ACCOUNT | activityChanges | string | |||||||
XA_CASE_REASON | activityChanges | string | |||||||
XA_CASE_PRIORITY | activityChanges | string | |||||||
XA_CASE_SUBJECT | activityChanges | string | |||||||
XA_PRODUCT | activityChanges | string | |||||||
XA_CASE_DESCRIPTION | activityChanges | string | |||||||
XA_CASE_NOTES | activityChanges | string | |||||||
XA_OPPORTUNITY_NAME | activityChanges | string | |||||||
XA_OPPORTUNITY_OWNER | activityChanges | string | |||||||
XA_OPPORTUNITY_AMOUNT | activityChanges | string | |||||||
XA_OPPORTUNITY_STAGE | activityChanges | string | |||||||
XA_OPPORTUNITY_TYPE | activityChanges | string | |||||||
XA_OPPORTUNITY_LEAD_SOURCE | activityChanges | string | |||||||
XA_OPPORTUNITY_NEXT_STEP | activityChanges | string | |||||||
XA_OPPORTUNITY_DESCRIPTION | activityChanges | string | |||||||
XA_LIQUID_PRESSURE | activityChanges | string | |||||||
XA_TEMPERATURE | activityChanges | string | |||||||
XA_RESTOCK_SHIPPING | activityChanges | string | |||||||
XA_RESTOCK_PART_NUMBER | activityChanges | string | |||||||
XA_PART_NEEDED | activityChanges | integer | |||||||
XA_MISC_PART_TYPE | activityChanges | string | |||||||
XA_PART_ORDER_BRAND | activityChanges | string | |||||||
XA_PART_ORDER_NOTES | activityChanges | string | |||||||
XA_DMG_ACK | activityChanges | events.definitions.activityChanges.XA_DMG_ACK | |||||||
XA_DMG_PIC | activityChanges | events.definitions.activityChanges.XA_DMG_PIC | |||||||
XA_ACKNOWLEDGEMENT | activityChanges | integer | |||||||
XA_SAFETY_NOTES | activityChanges | string | |||||||
XA_PART_TYPE | activityChanges | string | |||||||
XA_AC_BRAND | activityChanges | string | |||||||
XA_AH_BRAND | activityChanges | string | |||||||
XA_FURN_BRAND | activityChanges | string | |||||||
XA_TANK_WH_BRAND | activityChanges | string | |||||||
XA_COMP_BRAND | activityChanges | string | |||||||
XA_WH_TYPE | activityChanges | string | |||||||
XA_TNKL_WH_BRAND | activityChanges | string | |||||||
XA_CPL_COMP | activityChanges | string | |||||||
XA_GOODMAN_COMP | activityChanges | string | |||||||
XA_RHM_COMP | activityChanges | string | |||||||
XA_GDM_AH | activityChanges | string | |||||||
XA_LENNOX_AH | activityChanges | string | |||||||
XA_RHM_AH | activityChanges | string | |||||||
XA_TRANE_AH | activityChanges | string | |||||||
XA_GE_TANK_WH | activityChanges | string | |||||||
XA_KENMORE_TNK_WH | activityChanges | string | |||||||
XA_RHM_TNK_WH | activityChanges | string | |||||||
XA_BOSCH_TL_WH | activityChanges | string | |||||||
XA_MAX_TL_WH | activityChanges | string | |||||||
XA_RHM_TL_WH | activityChanges | string | |||||||
XA_GDM_AC | activityChanges | string | |||||||
XA_RHM_AC | activityChanges | string | |||||||
XA_TRANE_AC | activityChanges | string | |||||||
XA_GDM_FURN | activityChanges | string | |||||||
XA_RHM_FURN | activityChanges | string | |||||||
XA_WIL_FURN | activityChanges | string | |||||||
XA_YORK_FURN | activityChanges | string | |||||||
XA_SAFETY_SIG | activityChanges | events.definitions.activityChanges.XA_SAFETY_SIG | |||||||
XA_SAFE_DEBRIS | activityChanges | integer | |||||||
XA_SAFE_WIRES | activityChanges | integer | |||||||
XA_SAFE_WATER | activityChanges | integer | |||||||
XA_SAFE_EQUIP | activityChanges | integer | |||||||
XA_CASE_NUMBER | activityChanges | string | |||||||
XA_CASE_ASSET | activityChanges | string | |||||||
XA_OPPORTUNITY_PROBABILITY | activityChanges | string | |||||||
XA_OPPORTUNITY_EXPECTED_REVENUE | activityChanges | string | |||||||
XA_OPPORTUNITY_CLOSE_DATE | activityChanges | string | |||||||
Junk5 | activityChanges | string | |||||||
Impacted | activityChanges | string | |||||||
Site_Plan | activityChanges | events.definitions.activityChanges.Site_Plan | |||||||
Attachment | activityChanges | events.definitions.activityChanges.Attachment | |||||||
Work_Status | activityChanges | string | |||||||
Finish_Date | activityChanges | string | |||||||
Failure_Code | activityChanges | string | |||||||
Failure_Mode | activityChanges | string | |||||||
Root_Cause | activityChanges | string | |||||||
Repair_Code | activityChanges | string | |||||||
Component_Code | activityChanges | string | |||||||
Next_Action | activityChanges | string | |||||||
Emp_Name | activityChanges | string | |||||||
Regular_Shift | activityChanges | string | |||||||
Craft | activityChanges | string | |||||||
Regular_Type | activityChanges | string | |||||||
Regular_Hours_HHMM | activityChanges | integer | |||||||
Followup_Description | activityChanges | string | |||||||
WAM_Priority | activityChanges | string | |||||||
Due_Date | activityChanges | string | |||||||
Start_Date | activityChanges | string | |||||||
xa_link | activityChanges | string | |||||||
xa_Adequate_rearview_mirrors_sw | activityChanges | string | |||||||
xa_Safety_belts_sw | activityChanges | string | |||||||
xa_Windshield_wiper_blades_and_fluid_sw | activityChanges | string | |||||||
xa_Is_all_seating_in_the_vehicle_secured | activityChanges | string | |||||||
xa_knowledgelibrary | activityChanges | string | |||||||
xa_field_assessment | activityChanges | string | |||||||
on_hold | activityChanges | integer | |||||||
on_hold_comments | activityChanges | string | |||||||
Activity_Priority | activityChanges | string | |||||||
material_not_ready | activityChanges | integer | |||||||
indoor | activityChanges | integer | |||||||
Materials_Quantity | activityChanges | string | |||||||
Materials_Cost | activityChanges | string | |||||||
Person | activityChanges | string | |||||||
Material_Date_Checked_Out | activityChanges | string | |||||||
Transformer_Number | activityChanges | string | |||||||
Buss | activityChanges | string | |||||||
Relay_Number | activityChanges | string | |||||||
Outage_Cause | activityChanges | string | |||||||
Snake_Fence_Operating | activityChanges | string | |||||||
xa_Did_you_complete_vehicle_checklist_sw | activityChanges | string | |||||||
xa_materials_list | activityChanges | string | |||||||
xa_materials_taken | activityChanges | string | |||||||
A_MATERIAL_TRACKING | activityChanges | string | |||||||
xa_incidentinformation | activityChanges | string | |||||||
xa_assign_to_Routing_Bucket_sw | activityChanges | integer | |||||||
Transformer | activityChanges | string | |||||||
Schedule_Lock | activityChanges | integer | |||||||
Entrance_Requirements | activityChanges | string | |||||||
prem_warning | activityChanges | string | |||||||
Unit_of_Measure | activityChanges | string | |||||||
UOM | activityChanges | string | |||||||
row4 | activityChanges | integer | |||||||
Add_Row_sw | activityChanges | integer | |||||||
readHistory | activityChanges | string | |||||||
payHistory | activityChanges | string | |||||||
orderHistory | activityChanges | string | |||||||
payOffAmount | activityChanges | string | |||||||
currentAmount | activityChanges | string | |||||||
lessThan30 | activityChanges | string | |||||||
thirtyDaysAmount | activityChanges | string | |||||||
over60DaysAmt | activityChanges | string | |||||||
actionTaken | activityChanges | string | |||||||
payment | activityChanges | string | |||||||
trComments | activityChanges | string | |||||||
trEventId | activityChanges | string | |||||||
tr_outageBeginDateTime | activityChanges | string | |||||||
tr_firstCallDateTime | activityChanges | string | |||||||
tr_estimatedRestorationDateTime | activityChanges | string | |||||||
tr_caseNotes | activityChanges | string | |||||||
tr_clues | activityChanges | string | |||||||
tr_numberOfCalls | activityChanges | string | |||||||
tr_numberOfCustomersOut | activityChanges | string | |||||||
tr_numberOfKeyCustomers | activityChanges | string | |||||||
tr_numberOfEmergencyCustomers | activityChanges | string | |||||||
tr_numberOfMedicalCustomers | activityChanges | string | |||||||
tr_deviceId | activityChanges | string | |||||||
tr_phase | activityChanges | string | |||||||
tr_feeder | activityChanges | string | |||||||
tr_deviceLocation | activityChanges | string | |||||||
tr_callList | activityChanges | string | |||||||
tr_outageType | activityChanges | string | |||||||
tr_eventNotes | activityChanges | string | |||||||
tr_deviceConfirm | activityChanges | string | |||||||
tr_eventOutcome | activityChanges | string | |||||||
tr_actualRestoration | activityChanges | string | |||||||
tr_excludeFromOutage | activityChanges | integer | |||||||
tr_reasonForExclusion | activityChanges | string | |||||||
tr_cancelationReason | activityChanges | string | |||||||
tr_system | activityChanges | string | |||||||
tr_subsystem | activityChanges | string | |||||||
tr_failure | activityChanges | string | |||||||
tr_weather | activityChanges | string | |||||||
tr_frInterference | activityChanges | string | |||||||
tr_remedy | activityChanges | string | |||||||
tr_failedEquipment | activityChanges | integer | |||||||
tr_serialNumber | activityChanges | string | |||||||
tr_primaryVoltage | activityChanges | string | |||||||
tr_secondaryVoltage | activityChanges | string | |||||||
tr_rating | activityChanges | string | |||||||
tr_units | activityChanges | string | |||||||
tr_phase2 | activityChanges | string | |||||||
Status_Found | activityChanges | string | |||||||
Status_Left | activityChanges | string | |||||||
FA_Comments | activityChanges | string | |||||||
w_requestedBy | activityChanges | string | |||||||
w_meetingPlace | activityChanges | string | |||||||
w_flowHydMainSize | activityChanges | string | |||||||
w_maintType | activityChanges | string | |||||||
w_PressHydMainSize | activityChanges | string | |||||||
w_mainType | activityChanges | string | |||||||
w_hydrantLocation | activityChanges | string | |||||||
w_flowHydrantNumber | activityChanges | string | |||||||
w_nozzles | activityChanges | string | |||||||
w_size | activityChanges | string | |||||||
w_testTimeStart | activityChanges | string | |||||||
w_testTimeEnd | activityChanges | string | |||||||
w_totalTime | activityChanges | string | |||||||
w_pitotPressure | activityChanges | integer | |||||||
w_flowRate | activityChanges | integer | |||||||
w_flowTotal | activityChanges | integer | |||||||
w_staticPressue | activityChanges | integer | |||||||
w_residualPressue | activityChanges | integer | |||||||
w_estFlowRate | activityChanges | integer | |||||||
Boroughs | activityChanges | string | |||||||
Block | activityChanges | string | |||||||
Lot | activityChanges | string | |||||||
BBL | activityChanges | string | |||||||
Add2 | activityChanges | string | |||||||
City2 | activityChanges | string | |||||||
State2 | activityChanges | string | |||||||
Zip2 | activityChanges | string | |||||||
NYC2 | activityChanges | integer | |||||||
g_APTYPE1 | activityChanges | string | |||||||
GL_APTYPE2 | activityChanges | string | |||||||
GL_LeakDet | activityChanges | integer | |||||||
GL_RedTag1 | activityChanges | integer | |||||||
GL_TagApl_Pic_2 | activityChanges | events.definitions.activityChanges.GL_TagApl_Pic_2 | |||||||
GL_Location | activityChanges | string | |||||||
Outside_Leak_Causes | activityChanges | string | |||||||
GL_OUT_LEAK_TYPE | activityChanges | string | |||||||
GL_OUT_Source | activityChanges | string | |||||||
GL_OUT_LEL-ARRIVAL | activityChanges | integer | |||||||
GL_CGI_DEV_NO | activityChanges | string | |||||||
GL_tag_appl_Pic1 | activityChanges | events.definitions.activityChanges.GL_tag_appl_Pic1 | |||||||
GL_OUT_PIC_1 | activityChanges | events.definitions.activityChanges.GL_OUT_PIC_1 | |||||||
Reason_Tag_1 | activityChanges | string | |||||||
GL_RE_TAG2_Reason | activityChanges | string | |||||||
GL_ACTION_TAKEN | activityChanges | string | |||||||
Leak_Log_Nbr | activityChanges | string | |||||||
Time_Made_Safe | activityChanges | string | |||||||
OUTSIDE_EQUIPMENT | activityChanges | string | |||||||
Building_Evacuated | activityChanges | string | |||||||
Time_made_safe_HHMM | activityChanges | string | |||||||
GL_LEAK_DETECTED | activityChanges | string | |||||||
GL_IN_COMMENTS | activityChanges | string | |||||||
GL_OUT_COMMENTS | activityChanges | string | |||||||
GL_IN_REPAIRS | activityChanges | string | |||||||
GL_IN_REPAIR1 | activityChanges | string | |||||||
GL_IN_REPAIR2 | activityChanges | string | |||||||
GL_RED_TAGS | activityChanges | string | |||||||
GL_IN_REPAIRS2 | activityChanges | integer | |||||||
GL_RECHECK_IND | activityChanges | string | |||||||
GL_RECHECK_DATE | activityChanges | string | |||||||
GL_METER_STATUS | activityChanges | string | |||||||
GL_BILLABLE_IND | activityChanges | string | |||||||
GL_BILLABLE_PARTY | activityChanges | string | |||||||
GL_BILLABLE_ADDR_IND | activityChanges | string | |||||||
GL_BILLABLE_ADDR | activityChanges | string | |||||||
GL_GAS_STATUS | activityChanges | string | |||||||
GL_COMPLETION_COMMENTS | activityChanges | string | |||||||
GL_PPM_ARRIVAL | activityChanges | integer | |||||||
GL_FLAME_PACK_NO | activityChanges | string | |||||||
GL_BAR_HOLE_1 | activityChanges | integer | |||||||
GL_BAR_CODE_2 | activityChanges | integer | |||||||
GL_BAR_HOLE_2 | activityChanges | integer | |||||||
GL_BAR_HOLE_3 | activityChanges | integer | |||||||
v_tires | activityChanges | integer | |||||||
v_water | activityChanges | integer | |||||||
v_lights | activityChanges | integer | |||||||
v_comments | activityChanges | string | |||||||
Order_Type | activityChanges | string | |||||||
GL_BUILDING_EVAC_TIME2 | activityChanges | string | |||||||
GL_PX_SIZE_FRACTIONS | activityChanges | string | |||||||
GL_PX_SIZE_INCH | activityChanges | string | |||||||
GL_PX_MATERIAL | activityChanges | string | |||||||
GL_PX_EXPOSED | activityChanges | string | |||||||
GL_PX_ANNODE | activityChanges | string | |||||||
GL_ANNODE_SIZE | activityChanges | string | |||||||
GL_PX_SEDIMENT | activityChanges | string | |||||||
GL_PX_COATING_TYPE | activityChanges | string | |||||||
GL_PX_COATING_COND | activityChanges | string | |||||||
GL_PX_CORR_EXT | activityChanges | string | |||||||
GL_PX_EXT_CORR_EXTENT | activityChanges | string | |||||||
GL_IN_PPM_ARRV | activityChanges | string | |||||||
GL_LEL_PCT_ARRV | activityChanges | string | |||||||
GL_BAR1_PCT | activityChanges | string | |||||||
GL_BAR2_PCT | activityChanges | string | |||||||
GL_BAR3_PCT | activityChanges | string | |||||||
Surface | activityChanges | string | |||||||
Probable_Pressure | activityChanges | string | |||||||
Repair_Type | activityChanges | string | |||||||
Leak_Cause | activityChanges | string | |||||||
Actual_Pipe_Material | activityChanges | string | |||||||
Actual_Pressure | activityChanges | string | |||||||
Odorant_Detected | activityChanges | string | |||||||
Test_Medium | activityChanges | string | |||||||
Test_Device | activityChanges | string | |||||||
Pressure_Test_PSIG | activityChanges | string | |||||||
Test_Duration_Hours | activityChanges | string | |||||||
Test_Duration_Mins | activityChanges | string | |||||||
Test_Duration_Secs | activityChanges | string | |||||||
Repaired_By | activityChanges | events.definitions.activityChanges.Repaired_By | |||||||
Technician_Name | activityChanges | string | |||||||
Leak_Class | activityChanges | string | |||||||
GL_CaseReviewed | activityChanges | integer | |||||||
GLR_RepairPhoto | activityChanges | events.definitions.activityChanges.GLR_RepairPhoto | |||||||
GLR_ReferCM | activityChanges | integer | |||||||
Appointment | activityChanges | integer | |||||||
newMtr_status_left | activityChanges | string | |||||||
lessThirtyDaysAmount | activityChanges | string | |||||||
disputedAmount | activityChanges | string | |||||||
sixtyDaysAmount | activityChanges | string |
Oracle Utilities Service Order Management Inbound Field Activity Response Message | Oracle Field Service Activity Completed Event Message | DVM Mapping | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Field Service Column | Oracle Utilities Service Order Management Column | |
D1-FARequestSynchronousResponse | outermosttag | update_PATCH | outermosttag | ||||||
D1-FARequestSynchronous | D1-FARequestSynchronousResponse | ||||||||
TemplateParameters | update_PATCH | Group | |||||||
activities.definitions.updateActivitySchema | update_PATCH | Group | |||||||
request | D1-FARequestSynchronous | Group | |||||||
relatedActivityId | request | string | activityId | TemplateParameters | string | If referenceId!="" | |||
response | D1-FARequestSynchronous | Group | |||||||
referenceId | response | string | apptNumber | activities.definitions.updateActivitySchema | string | ||||
common_utilities_product_code | activities.definitions.updateActivitySchema | string | Hard code to 'OFSC' |
Oracle Field Service Activity Created Event Message | Oracle Utilities Service Order Management Inbound Field Activity Resquest Message | DVM Mapping | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Field Service Column | Oracle Utilities Service Order Management Column | |
notify_POST | OutermostTag | canonical_GET | OutermostTag | ||||||
events.definitions.activityEvent | notify_POST | ||||||||
TemplateParameters | canonical_GET | ||||||||
activityId | activityDetails | activityId | TemplateParameters |