Resource Created/Updated (Oracle Field Service Initiated)
This section describes data mapping for the following:
Resource Created/Updated Mapping
OIC ResourceCreated/Updated Request Message | DVM Mapping | Comments | |||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Utilities Work and Asset Management Column | Oracle Field Service Column | |
notify_POST | Outermosttag | ||||||||
resourceEvent | notify_POST | ||||||||
user | resourceEvent | String | |||||||
applicationId | resourceEvent | String | |||||||
time | resourceEvent | String | |||||||
eventType | resourceEvent | String | |||||||
resourceDetails | resourceEvent | Group | |||||||
resourceInternalId | resourceDetails | String | |||||||
resourceId | resourceDetails | String | |||||||
name | resourceDetails | String | |||||||
resourceType | resourceDetails | String | |||||||
resourceChanges | resourceEvent | Group | |||||||
resourceId | resourceChanges | String | |||||||
organization | resourceChanges | String | |||||||
resourceInternalId | resourceChanges | String | |||||||
parentResourceInternalId | resourceChanges | String | |||||||
status | resourceChanges | String | |||||||
parentResourceId | resourceChanges | String | |||||||
resourceType | resourceChanges | String | |||||||
name | resourceChanges | String | |||||||
email | resourceChanges | String | |||||||
phone | resourceChanges | String | |||||||
language | resourceChanges | String | |||||||
languageISO | resourceChanges | String | |||||||
timeZoneDiff | resourceChanges | Integer | |||||||
timeZone | resourceChanges | String | |||||||
timeZoneIANA | resourceChanges | String | |||||||
dateFormat | resourceChanges | String | |||||||
timeFormat | resourceChanges | String | |||||||
durationStatisticsInitialRatio | resourceChanges | Double | |||||||
durationStatisticsInitialPeriod | resourceChanges | Integer | |||||||
Resource_0x737063_type | resourceChanges | String | |||||||
tech_photo | resourceChanges | Group | |||||||
links | tech_photo | Group | |||||||
rel | links | String | |||||||
href | links | String | |||||||
mediaType | links | String | |||||||
gender | resourceChanges | String | |||||||
credence | resourceChanges | String | |||||||
wam_resource_address | resourceChanges | String | |||||||
wam_resource_source | resourceChanges | String | |||||||
wam_resource_lastUpdateDttm | resourceChanges | String | |||||||
nms_resource | resourceChanges | String | |||||||
common_utilities_resource_code | resourceChanges | String | |||||||
Get OFS Resource Mapping
OIC ResourceCreated/Updated Request Message | OFSC GetActivity Data Request Message | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Utilities Work and Asset Management Column | Oracle Field Service Column | |
OIC ResourceCreated/Updated Request Message | canonical_GET | Outermosttag | GET Resource/Get Resource | ||||||
Element Name | Parent Element | Type | Template Parameters | canonical_GET | Group | ||||
notify_POST | Outermosttag | ||||||||
resourceEvent | notify_POST | ||||||||
user | resourceEvent | String | |||||||
applicationId | resourceEvent | String | |||||||
time | resourceEvent | String | |||||||
eventType | resourceEvent | String | |||||||
resourceDetails | resourceEvent | Group | resourceId | TemplateParameters | String | ||||
resourceInternalId | resourceDetails | String | |||||||
resourceId | resourceDetails | String | |||||||
name | resourceDetails | String | |||||||
resourceType | resourceDetails | String | |||||||
resourceChanges | resourceEvent | Group | |||||||
resourceId | resourceChanges | String | |||||||
organization | resourceChanges | String | |||||||
resourceInternalId | resourceChanges | String | |||||||
parentResourceInternalId | resourceChanges | String | |||||||
status | resourceChanges | String | |||||||
parentResourceId | resourceChanges | String | |||||||
resourceType | resourceChanges | String | |||||||
name | resourceChanges | String | |||||||
email | resourceChanges | String | |||||||
phone | resourceChanges | String | |||||||
language | resourceChanges | String | |||||||
languageISO | resourceChanges | String | |||||||
timeZoneDiff | resourceChanges | Integer | |||||||
timeZone | resourceChanges | String | |||||||
timeZoneIANA | resourceChanges | String | |||||||
dateFormat | resourceChanges | String | |||||||
timeFormat | resourceChanges | String | |||||||
durationStatisticsInitialRatio | resourceChanges | Double | |||||||
durationStatisticsInitialPeriod | resourceChanges | Integer | |||||||
Resource_0x737063_type | resourceChanges | String | |||||||
tech_photo | resourceChanges | Group | |||||||
links | tech_photo | Group | |||||||
rel | links | String | |||||||
href | links | String | |||||||
mediaType | links | String | |||||||
gender | resourceChanges | String | |||||||
credence | resourceChanges | String | |||||||
wam_resource_address | resourceChanges | String | |||||||
wam_resource_source | resourceChanges | String | |||||||
wam_resource_lastUpdateDttm | resourceChanges | String | |||||||
nms_resource | resourceChanges | String | |||||||
common_utilities_resource_code | resourceChanges | String | |||||||
Get OFS Resource Types Mapping
OFS GetResourceType Request Message | DVM Mapping | Comments | ||||
|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | DVM Name | Oracle Utilities Work and Asset Management Column | Oracle Field Service Column | |
canonical_GET | Outermosttag | GET /rest/ofscMetadata/v1/resourceTypes | ||||
TemplateParameters | canonical_GET | Group | ||||
offset | TemplateParameters | If not passed = 0 | ||||
limit | TemplateParameters | If not passed = 100 | ||||
Get NMS Instance URL Mapping
OIC ResourceCreated/Updated Request Message | OIC GetNMSInstanceURL Message | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Property | Value | |
notify_POST | Outermosttag | execute | Outermosttag | ||||||
resourceEvent | notify_POST | QueryParameters | execute | Group | |||||
resourceId | resourceDetails | String | resourceId | QueryParameters | String | ||||
bucketDVM | QueryParameters | String | OUTL-BRT-NMS_OFSC_ConfigProps | findInstance.oic.LookupName | OUTL-BRT-NMS_OFSC_InstanceIDToBucket | ||||
sourceColumn | QueryParameters | String | OUTL-BRT-NMS_OFSC_ConfigProps | findInstance.oic.LookupSourceColumnName | OFSC_BucketID | ||||
targetColumn | QueryParameters | String | OUTL-BRT-NMS_OFSC_ConfigProps | findInstance.oic.LookupTargetColumnName | NMS_ConnectionID | ||||
notFoundValue | QueryParameters | String | OUTL-BRT-NMS_OFSC_ConfigProps | findInstance.oic.LookupNotFoundValue | NotFound | ||||
Get OFS Resource Workskills Mapping
OIC ResourceCreated/Updated Request Message | OFS GetResourceWorkSkills Data Request Message | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Utilities Work and Asset Management Column | Oracle Field Service Column | |
notify_POST | Outermosttag | canonical_GET | Outermosttag | GET ofscCore/v1/resources/{resourceId}/workSkills | |||||
resourceEvent | notify_POST | Template Parameters | canonical_GET | Group | |||||
user | resourceEvent | String | |||||||
applicationId | resourceEvent | String | |||||||
time | resourceEvent | String | |||||||
eventType | resourceEvent | String | |||||||
resourceDetails | resourceEvent | Group | |||||||
resourceInternalId | resourceDetails | String | |||||||
resourceId | resourceDetails | String | resourceId | TemplateParameters | String | ||||
name | resourceDetails | String | |||||||
resourceType | resourceDetails | String | QueryParameters | TemplateParameters | |||||
resourceChanges | resourceEvent | Group | dateFrom | QueryParameters | current-dateTime YYYY-MM-DD - OFSC.timeZoneDiff | ||||
resourceId | resourceChanges | String | |||||||
organization | resourceChanges | String | |||||||
resourceInternalId | resourceChanges | String | |||||||
parentResourceInternalId | resourceChanges | String | |||||||
status | resourceChanges | String | |||||||
parentResourceId | resourceChanges | String | |||||||
resourceType | resourceChanges | String | |||||||
name | resourceChanges | String | |||||||
email | resourceChanges | String | |||||||
phone | resourceChanges | String | |||||||
language | resourceChanges | String | |||||||
languageISO | resourceChanges | String | |||||||
timeZoneDiff | resourceChanges | Integer | |||||||
timeZone | resourceChanges | String | |||||||
timeZoneIANA | resourceChanges | String | |||||||
dateFormat | resourceChanges | String | |||||||
timeFormat | resourceChanges | String | |||||||
durationStatisticsInitialRatio | resourceChanges | Double | |||||||
durationStatisticsInitialPeriod | resourceChanges | Integer | |||||||
Resource_0x737063_type | resourceChanges | String | |||||||
tech_photo | resourceChanges | Group | |||||||
links | tech_photo | Group | |||||||
rel | links | String | |||||||
href | links | String | |||||||
mediaType | links | String | |||||||
gender | resourceChanges | String | |||||||
credence | resourceChanges | String | |||||||
wam_resource_address | resourceChanges | String | |||||||
wam_resource_source | resourceChanges | String | |||||||
wam_resource_lastUpdateDttm | resourceChanges | String | |||||||
nms_resource | resourceChanges | String | |||||||
common_utilities_resource_code | resourceChanges | String | |||||||
Get OFS Workskill Details Mapping
OFSC GetResourceWorkSkills Data Response Message | OFSC GetWorkSkillDetails Data Request Message | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Utilities Work and Asset Management Column | Oracle Field Service Column | |
executeResponse | Outermosttag | execute | Outermosttag | GET /ofscMetadata/v1/workSkills/{ workSkillId } | |||||
response-wrapper | executeResponse | Group | Template Parameters | execute | Group | ||||
items | response-wrapper | Group | |||||||
workSkill | items | String | workSkillId | TemplateParameters | String | See the following figure for logic about which workskillId should be used. | |||
ratio | items | String | |||||||
startDate | items | String | |||||||
totalResults | response-wrapper | Group | |||||||
links | response-wrapper | Group | |||||||
rel | links | String | |||||||
href | links | String | |||||||
Get OFS Resource Work Zones Mapping
OIC Resource Created/Updated Request Message | OFS Get Resource Work Skills Request Message | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Utilities Work and Asset Management Column | Oracle Field Service Column | |
notify_POST | Outermosttag | canonical_GET | Outermosttag | GET Resource/Get Resource Work Zones | |||||
resourceEvent | notify_POST | Template Parameters | canonical_GET | Group | |||||
user | resourceEvent | String | |||||||
applicationId | resourceEvent | String | |||||||
time | resourceEvent | String | |||||||
eventType | resourceEvent | String | |||||||
resourceDetails | resourceEvent | Group | |||||||
resourceInternalId | resourceDetails | String | |||||||
resourceId | resourceDetails | String | resourceId | TemplateParameters | String | ||||
name | resourceDetails | String | |||||||
resourceType | resourceDetails | String | |||||||
resourceChanges | resourceEvent | Group | |||||||
resourceId | resourceChanges | String | |||||||
organization | resourceChanges | String | |||||||
resourceInternalId | resourceChanges | String | |||||||
parentResourceInternalId | resourceChanges | String | QueryParameters | canonical_GET | Group | ||||
timeZoneDiff | resourceChanges | Integer | date | QueryParameters | String | current-dateTime YYYY-MM-DD - OFSC.timeZoneDiff | |||
status | resourceChanges | String | |||||||
parentResourceId | resourceChanges | String | |||||||
resourceType | resourceChanges | String | |||||||
name | resourceChanges | String | |||||||
email | resourceChanges | String | |||||||
phone | resourceChanges | String | |||||||
language | resourceChanges | String | |||||||
languageISO | resourceChanges | String | |||||||
timeZone | resourceChanges | String | |||||||
timeZoneIANA | resourceChanges | String | |||||||
dateFormat | resourceChanges | String | |||||||
timeFormat | resourceChanges | String | |||||||
durationStatisticsInitialRatio | resourceChanges | Double | |||||||
durationStatisticsInitialPeriod | resourceChanges | Integer | |||||||
Resource_0x737063_type | resourceChanges | String | |||||||
tech_photo | resourceChanges | Group | |||||||
links | tech_photo | Group | |||||||
rel | links | String | |||||||
href | links | String | |||||||
mediaType | links | String | |||||||
gender | resourceChanges | String | |||||||
credence | resourceChanges | String | |||||||
wam_resource_address | resourceChanges | String | |||||||
wam_resource_source | resourceChanges | String | |||||||
wam_resource_lastUpdateDttm | resourceChanges | String | |||||||
nms_resource | resourceChanges | String | |||||||
common_utilities_resource_code | resourceChanges | String | |||||||
Get OFS Resource Routes Mapping
OIC ResourceCreated/Updated Request Message | OFSC GetResourceRoute Request Message | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Utilities Work and Asset Management Column | Oracle Field Service Column | |
notify_POST | Outermosttag | canonical_GET | Outermosttag | GET /ofscCore/v1/resources/{resourceId}/routes/{date} | |||||
resourceEvent | notify_POST | Template Parameters | canonical_GET | Group | |||||
user | resourceEvent | String | |||||||
applicationId | resourceEvent | String | |||||||
time | resourceEvent | String | |||||||
eventType | resourceEvent | String | |||||||
resourceDetails | resourceEvent | Group | |||||||
resourceInternalId | resourceDetails | String | |||||||
resourceId | resourceDetails | String | resourceId | TemplateParameters | String | ||||
name | resourceDetails | String | |||||||
resourceType | resourceDetails | String | |||||||
resourceChanges | resourceEvent | Group | |||||||
resourceId | resourceChanges | String | |||||||
organization | resourceChanges | String | |||||||
resourceInternalId | resourceChanges | String | |||||||
parentResource InternalId | resourceChanges | String | QueryParameters | canonical_GET | Group | ||||
timeZoneDiff | resourceChanges | Integer | date | TemplateParameters | String | current-dateTime YYYY-MM-DD - OFSC.timeZoneDiff | |||
status | resourceChanges | String | |||||||
parentResourceId | resourceChanges | String | |||||||
resourceType | resourceChanges | String | |||||||
name | resourceChanges | String | |||||||
email | resourceChanges | String | |||||||
phone | resourceChanges | String | |||||||
language | resourceChanges | String | |||||||
languageISO | resourceChanges | String | |||||||
timeZone | resourceChanges | String | |||||||
timeZoneIANA | resourceChanges | String | |||||||
dateFormat | resourceChanges | String | |||||||
timeFormat | resourceChanges | String | |||||||
durationStatistics InitialRatio | resourceChanges | Double | |||||||
durationStatistics InitialPeriod | resourceChanges | Integer | |||||||
Resource_0x737063_ type | resourceChanges | String | |||||||
tech_photo | resourceChanges | Group | |||||||
links | tech_photo | Group | |||||||
rel | links | String | |||||||
href | links | String | |||||||
mediaType | links | String | |||||||
gender | resourceChanges | String | |||||||
credence | resourceChanges | String | |||||||
wam_resource_ address | resourceChanges | String | |||||||
wam_resource_ source | resourceChanges | String | |||||||
wam_resource_ lastUpdateDttm | resourceChanges | String | |||||||
nms_resource | resourceChanges | String | |||||||
common_utilities_ resource_code | resourceChanges | String | |||||||
Get NMS System Data Mapping
OIC Get Admin Data Request Message | NMS GetAdmin Data Request Message | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Source Column | Target Column | |
execute | Outermosttag | getAdminData | |||||||
ConnectivityProperties | |||||||||
Plugin | Connectivity Properties | ||||||||
ConnectionId | Plugin | OUTL-BRT-NMS_OFSC_InstanceIDToBucket | OFSC_BucketID | NMS_ConnectionID | |||||
OUTL-BRT-NMS_OFSC_ConfigProps | PropertyName | Value | “ofsc.bucket” as source | ||||||
Upsert NMS Crew Mapping
OFSC GetResourceDetail Response Message | NMS UpsertCrew Request Message | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Utilities Work and Asset Management Column | Oracle Field Service Column | |
canonical_GETResponse | Outermosttag | execute | Outermosttag | createUpdate Crew | |||||
resources.definitions.resource | canonical_GETResponse | request_wrapper | execute | Group | |||||
resourceId | String | crewName | request_wrapper | String | |||||
phone | String | mobileNum | request_wrapper | String | |||||
status | String | ||||||||
timeActivated | request_wrapper | String | If status = 'active' then timeActivated = current-dateTime in epoch format. Else, timeDeactivated = current-dateTime in epoch format. | ||||||
timeDeactivated | request_wrapper | String | |||||||
nms_crew_size | Integer | crewSize | request_wrapper | Integer | |||||
OFSC GetWorkSkillDetails Response Message | |||||||||
executeResponse | Outermosttag | ||||||||
response-wrapper | executeResponse | Group | |||||||
name | response-wrapper | String | crewType | request_wrapper | String | If not empty | |||
OFSC GetResourceRoute Response Message | |||||||||
executeResponse | Outermosttag | ||||||||
response-wrapper | executeResponse | Group | |||||||
routeStartTime | response-wrapper | String | timeOnShift | request_wrapper | String | If incoming routeEndTime then timeOffShift = routeEndTime in epoch format. Else, if incoming routeReactivationTime then timeOnShift = routeReactivationTime in epoch format, else if incoming routeStartTime then timeOnShift = routeStartTime in epoch format else timeOffShift = current-dateTime in epoch format. | |||
routeEndTime | response-wrapper | String | timeOnShift | request_wrapper | String | ||||
routeReactivation Time | response-wrapper | String | timeOnShift | request_wrapper | String | ||||
OFSC GetResourceWorkSkills Request Message | |||||||||
workZonesResponse | Outermosttag | ||||||||
getResource WorkZones | workZones Response | Group | |||||||
items | getResourceWork Zones | Array | |||||||
workzone | items | String | zoneHdlIdx | request_wrapper | String | ||||
NMS Get Admin Data Response Message | |||||||||
$Get_AdminData | Outermosttag | ||||||||
response-wrapper | $Get_AdminData | Group | |||||||
controlZones | response-wrapper | Group | |||||||
name | controlZones | String | zoneName | request_wrapper | String | If 'workzone' found | |||
ncg | controlZones | Integer | |||||||
ncgClass | controlZones | Integer | zoneHdlCls | request_wrapper | Integer | If 'workzone' found | |||
outOfRange | request_wrapper | Boolean | OUTL-BRT-NMS_OFSC_ConfigProps | PropertyName = “nms.crew.outOfRange” | Value = “true” | ||||
isAvailForOp | request_wrapper | Boolean | OUTL-BRT-NMS_OFSC_ConfigProps | PropertyName = “nms.crew.isAvailForOp” | Value = “true” | ||||
isMobileIntegrated | request_wrapper | Boolean | OUTL-BRT-NMS_OFSC_ConfigProps | PropertyName = “nms.crew.outOfRange” | Value = “true” | ||||
Connectivity Properties | execute | ||||||||
OIC retrieveNMSinstanceURL Message Response | |||||||||
GETResponse | Outermosttag | Plugin | ConnectivityProperties | ||||||
components.schemas.response-wrapper | GETResponse | Group | |||||||
resourceValue | components.schemas.response-wrapper | String | |||||||
resourceBucket | components.schemas.response-wrapper | String | |||||||
targetValue | components.schemas.response-wrapper | String | ConnectionId | Plugin | $varBucketNMSinstanceURL = NMS_ConnectionId | ||||