Svc Schd Request Terr Summary DMO

Represents key performance indicators for various service schedule request results at the territory level

Object API Name: std__SvcSchdRequestTerrSummaryDmo__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: Id

• ServiceScheduleRequestId has a FOREIGNKEY relationship with the Service Schedule Request DMO Id field.
• LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.
• CreatedById has a FOREIGNKEY relationship with the User DMO Id field.
• ServiceTerritoryId has a FOREIGNKEY relationship with the Service Territory DMO Id field.

• AvgRespTimeForApptWithWindowAftOptimNbr
• AvgRespTimeForApptWithWindowBefOptimNbr
• AvgRespTimeForApptWoWindowAftOptimNbr
• AvgRespTimeForApptWoWindowBefOptimNbr
• AvgTravelTimeAfterOptimizationNumber
• AvgTravelTimeBeforeOptimizationNumber
• AvgTravelTimeWithoutHomeAfterOptimNbr
• AvgTravelTimeWithoutHomeBeforeOptimNbr
• cdp_sys_record_currency
• CreatedById
• CreatedDate
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• IsDeleted
• LastModifiedById
• LastModifiedDate
• NumOfSchdApptToCapacityRsrceAftOptimCt
• NumOfSchdApptToCapacityRsrceBefOptimCt
• NumOfSchdApptToCrewAfterOptimCt
• NumOfSchdApptToCrewBeforeOptimCt
• NumOfSchdApptToPreferredRsrceAfterCt
• NumOfSchdApptToPreferredRsrceBeforeCt
• NumOfSchdApptToRglrResourceAfterCt
• NumOfSchdApptToRglrResourceBeforeCt
• ServiceScheduleRequestId
• ServiceTerritoryId
• SvcSchdRequestTerrSummaryName
• SystemModstamp
• TotalCrewWorkCapacityNumber
• TotalLunchBreakDurationAfterOptimNumber
• TotalLunchBreakDurationBeforeOptimNumber
• TotalNonAvlDurationWithGeolcAftOptimNbr
• TotalNonAvlDurationWithGeolcBefOptimNbr
• TotalNonAvlDurationWoGeolcAftOptimNbr
• TotalNonAvlDurationWoGeolcBefOptimNbr
• TotalNumberOfCapacityBasedResourcesCount
• TotalNumberOfCrewsCount
• TotalNumberOfOptimizableServicesCount
• TotalNumberOfPinnedServicesCount
• TotalNumberOfRegularResourcesCount
• TotalNumberOfSchdServicesAfterOptimCt
• TotalNumberOfSchdServicesBeforeOptimCt
• TotalNumberOfServicesWithoutWindowCt
• TotalNumberOfServicesWithWindowCt
• TotalNumOfSchdApptToPreferredRsrceCt
• TotalNumOfUnschdCrewAfterOptimCt
• TotalNumOfUnschdCrewBeforeOptimCt
• TotalNumOfUnschdRglrRsrceAfterOptimCt
• TotalNumOfUnschdRglrRsrceBeforeOptimCt
• TotalOvertimeForCrewsNumber
• TotalOvertimeForRegularResourcesNumber
• TotalScheduledTimeOnOvertimeAftOptimNbr
• TotalScheduledTimeOnOvertimeBefOptimNbr
• TotalTrvlDistanceFromHomebaseAftOptimNbr
• TotalTrvlDistanceFromHomebaseBefOptimNbr
• TotalTrvlDistanceToHomebaseAftOptimNbr
• TotalTrvlDistanceToHomebaseBefOptimNbr
• TotalTrvlDistanceWoHomebaseAftOptimNbr
• TotalTrvlDistanceWoHomebaseBefOptimNbr
• TotalTrvlTimeFromHomebaseAfterOptimNbr
• TotalTrvlTimeFromHomebaseBeforeOptimNbr
• TotalTrvlTimeOnRsrceExpenseAftOptimNbr
• TotalTrvlTimeOnRsrceExpenseBefOptimNbr
• TotalTrvlTimeToHomebaseAfterOptimNbr
• TotalTrvlTimeToHomebaseBeforeOptimNbr
• TotalTrvlTimeWoHomeAfterOptimizationNbr
• TotalTrvlTimeWoHomeBeforeOptimizationNbr
• TotalWorkCapacityNumber
• TotalWorkDurationScheduledAfterOptimNbr
• TotalWorkDurationScheduledBeforeOptimNbr
• TotalWorkTimeNumber
• TotNumOfUnschdApptBecauseOfLimitedAvlCt
• TotNumOfUnschdApptBecauseOfRuleVioCt
• TotNumOfUnschdCapacityRsrceAfterOptimCt
• TotNumOfUnschdCapacityRsrceBeforeOptimCt

• Field API Name: std__AvgRespTimeForApptWithWindowAftOptimNbr__c
• Data Type: DOUBLE
• Description: Average response time after optimization (with arrival window).

• Field API Name: std__AvgRespTimeForApptWithWindowBefOptimNbr__c
• Data Type: DOUBLE
• Description: Average response time before optimization (with arrival window).

• Field API Name: std__AvgRespTimeForApptWoWindowAftOptimNbr__c
• Data Type: DOUBLE
• Description: Average response time after optimization (without arrival window).

• Field API Name: std__AvgRespTimeForApptWoWindowBefOptimNbr__c
• Data Type: DOUBLE
• Description: Average response time before optimization (without arrival window).

• Field API Name: std__AvgTravelTimeAfterOptimizationNumber__c
• Data Type: DOUBLE
• Description: The average time for all services with home location after optimization run

• Field API Name: std__AvgTravelTimeBeforeOptimizationNumber__c
• Data Type: DOUBLE
• Description: The average time for all services with home location before optimization run

• Field API Name: std__AvgTravelTimeWithoutHomeAfterOptimNbr__c
• Data Type: DOUBLE
• Description: The average time for all services without home location after optimization run

• Field API Name: std__AvgTravelTimeWithoutHomeBeforeOptimNbr__c
• Data Type: DOUBLE
• Description: The average time for all services without home location before optimization run

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__CreatedById__c
• Data Type: TEXT
• Description: The user who created the record

• Field API Name: std__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time when this record was created

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Primary Key

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__IsDeleted__c
• Data Type: BOOLEAN
• Description: Indicates whether the record has been moved to the Recycle Bin (true) or not (false).

• Field API Name: std__LastModifiedById__c
• Data Type: TEXT
• Description: The user who most recently changed the record

• Field API Name: std__LastModifiedDate__c
• Data Type: DATETIME
• Description: The date and time when a user last modified this record

• Field API Name: std__NumOfSchdApptToCapacityRsrceAftOptimCt__c
• Data Type: DOUBLE
• Description: Appointments assigned to capacity-based resources after optimization.

• Field API Name: std__NumOfSchdApptToCapacityRsrceBefOptimCt__c
• Data Type: DOUBLE
• Description: Appointments assigned to capacity-based resources before optimization.

• Field API Name: std__NumOfSchdApptToCrewAfterOptimCt__c
• Data Type: DOUBLE
• Description: Appointments assigned to crew resources after optimization.

• Field API Name: std__NumOfSchdApptToCrewBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Appointments assigned to crew resources before optimization.

• Field API Name: std__NumOfSchdApptToPreferredRsrceAfterCt__c
• Data Type: DOUBLE
• Description: Appointments assigned to preferred resources after optimization.

• Field API Name: std__NumOfSchdApptToPreferredRsrceBeforeCt__c
• Data Type: DOUBLE
• Description: Appointments assigned to preferred resources before optimization.

• Field API Name: std__NumOfSchdApptToRglrResourceAfterCt__c
• Data Type: DOUBLE
• Description: Appointments assigned to resources after optimization.

• Field API Name: std__NumOfSchdApptToRglrResourceBeforeCt__c
• Data Type: DOUBLE
• Description: Appointments assigned to resources before optimization.

• Field API Name: std__ServiceScheduleRequestId__c
• Data Type: TEXT
• Description: Lookup to the parent optimization request

• Field API Name: std__ServiceTerritoryId__c
• Data Type: TEXT
• Description: Lookup to the service territory which the optimization request was for

• Field API Name: std__SvcSchdRequestTerrSummaryName__c
• Data Type: TEXT
• Description: Name of this record

• Field API Name: std__SystemModstamp__c
• Data Type: DATETIME
• Description: The date and time when this record was last modified by a user or by an automated process

• Field API Name: std__TotalCrewWorkCapacityNumber__c
• Data Type: DOUBLE
• Description: Total availability for all crews

• Field API Name: std__TotalLunchBreakDurationAfterOptimNumber__c
• Data Type: DOUBLE
• Description: Total duration of lunck breaks after optimization.

• Field API Name: std__TotalLunchBreakDurationBeforeOptimNumber__c
• Data Type: DOUBLE
• Description: Total duration of lunck breaks before optimization.

• Field API Name: std__TotalNonAvlDurationWithGeolcAftOptimNbr__c
• Data Type: DOUBLE
• Description: Total duration of non availabilities with travel after optimization.

• Field API Name: std__TotalNonAvlDurationWithGeolcBefOptimNbr__c
• Data Type: DOUBLE
• Description: Total duration of non availabilities with travel before optimization.

• Field API Name: std__TotalNonAvlDurationWoGeolcAftOptimNbr__c
• Data Type: DOUBLE
• Description: Total duration of non availabilities without travel after optimization.

• Field API Name: std__TotalNonAvlDurationWoGeolcBefOptimNbr__c
• Data Type: DOUBLE
• Description: Total duration of non availabilities without travel before optimization.

• Field API Name: std__TotalNumberOfCapacityBasedResourcesCount__c
• Data Type: DOUBLE
• Description: Total number of capcity-based resources

• Field API Name: std__TotalNumberOfCrewsCount__c
• Data Type: DOUBLE
• Description: Total number of crews

• Field API Name: std__TotalNumberOfOptimizableServicesCount__c
• Data Type: DOUBLE
• Description: Total number of service appointments sent to be optimized

• Field API Name: std__TotalNumberOfPinnedServicesCount__c
• Data Type: DOUBLE
• Description: Total number of pinned services

• Field API Name: std__TotalNumberOfRegularResourcesCount__c
• Data Type: DOUBLE
• Description: Total number of regular resources

• Field API Name: std__TotalNumberOfSchdServicesAfterOptimCt__c
• Data Type: DOUBLE
• Description: Number of scheduled services after optimization.

• Field API Name: std__TotalNumberOfSchdServicesBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Number of scheduled services before optimization.

• Field API Name: std__TotalNumberOfServicesWithoutWindowCt__c
• Data Type: DOUBLE
• Description: Total number of services without time window

• Field API Name: std__TotalNumberOfServicesWithWindowCt__c
• Data Type: DOUBLE
• Description: Total number of services with time window

• Field API Name: std__TotalNumOfSchdApptToPreferredRsrceCt__c
• Data Type: DOUBLE
• Description: Total appointments assigned to preferred resources.

• Field API Name: std__TotalNumOfUnschdCrewAfterOptimCt__c
• Data Type: DOUBLE
• Description: Total number of unscheduled crew resource (nothing scheduled to that resources) after optimization.

• Field API Name: std__TotalNumOfUnschdCrewBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Total number of unscheduled crew resource (nothing scheduled to that resources) before optimization.

• Field API Name: std__TotalNumOfUnschdRglrRsrceAfterOptimCt__c
• Data Type: DOUBLE
• Description: Total number of unscheduled regular resource (nothing scheduled to that resources) after optimization.

• Field API Name: std__TotalNumOfUnschdRglrRsrceBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Total number of unscheduled regular resource (nothing scheduled to that resources) before optimization.

• Field API Name: std__TotalOvertimeForCrewsNumber__c
• Data Type: DOUBLE
• Description: Total overtime for all crews

• Field API Name: std__TotalOvertimeForRegularResourcesNumber__c
• Data Type: DOUBLE
• Description: Total overtime for all regular resources

• Field API Name: std__TotalScheduledTimeOnOvertimeAftOptimNbr__c
• Data Type: DOUBLE
• Description: Total overtime after optimization.

• Field API Name: std__TotalScheduledTimeOnOvertimeBefOptimNbr__c
• Data Type: DOUBLE
• Description: Total overtime before optimization.

• Field API Name: std__TotalTrvlDistanceFromHomebaseAftOptimNbr__c
• Data Type: DOUBLE
• Description: Total distance from homebase after optimization.

• Field API Name: std__TotalTrvlDistanceFromHomebaseBefOptimNbr__c
• Data Type: DOUBLE
• Description: Total distance from homebase before optimization.

• Field API Name: std__TotalTrvlDistanceToHomebaseAftOptimNbr__c
• Data Type: DOUBLE
• Description: Total distance to homebase after optimization.

• Field API Name: std__TotalTrvlDistanceToHomebaseBefOptimNbr__c
• Data Type: DOUBLE
• Description: Total distance to homebase before optimization.

• Field API Name: std__TotalTrvlDistanceWoHomebaseAftOptimNbr__c
• Data Type: DOUBLE
• Description: Total distance between service appointments after optimization.

• Field API Name: std__TotalTrvlDistanceWoHomebaseBefOptimNbr__c
• Data Type: DOUBLE
• Description: Total distance between service appointments before optimization.

• Field API Name: std__TotalTrvlTimeFromHomebaseAfterOptimNbr__c
• Data Type: DOUBLE
• Description: Total travel time from homebase after optimization.

• Field API Name: std__TotalTrvlTimeFromHomebaseBeforeOptimNbr__c
• Data Type: DOUBLE
• Description: Total travel time from homebase before optimization.

• Field API Name: std__TotalTrvlTimeOnRsrceExpenseAftOptimNbr__c
• Data Type: DOUBLE
• Description: Total travel on the resource's expense after optimization.

• Field API Name: std__TotalTrvlTimeOnRsrceExpenseBefOptimNbr__c
• Data Type: DOUBLE
• Description: Total travel on the resource's expense before optimization.

• Field API Name: std__TotalTrvlTimeToHomebaseAfterOptimNbr__c
• Data Type: DOUBLE
• Description: Total travel time to homebase after optimization.

• Field API Name: std__TotalTrvlTimeToHomebaseBeforeOptimNbr__c
• Data Type: DOUBLE
• Description: Total travel time to homebase before optimization.

• Field API Name: std__TotalTrvlTimeWoHomeAfterOptimizationNbr__c
• Data Type: DOUBLE
• Description: Total travel time between service appointments after optimization.

• Field API Name: std__TotalTrvlTimeWoHomeBeforeOptimizationNbr__c
• Data Type: DOUBLE
• Description: Total travel time between service appointments before optimization.

• Field API Name: std__TotalWorkCapacityNumber__c
• Data Type: DOUBLE
• Description: Total availability for all regular resources

• Field API Name: std__TotalWorkDurationScheduledAfterOptimNbr__c
• Data Type: DOUBLE
• Description: Total duration of scheduled service appointments after optimization.

• Field API Name: std__TotalWorkDurationScheduledBeforeOptimNbr__c
• Data Type: DOUBLE
• Description: Total duration of scheduled service appointments before optimization.

• Field API Name: std__TotalWorkTimeNumber__c
• Data Type: DOUBLE
• Description: Total duration of all service appointments

• Field API Name: std__TotNumOfUnschdApptBecauseOfLimitedAvlCt__c
• Data Type: DOUBLE
• Description: Number of service appointments unscheduled because of availability.

• Field API Name: std__TotNumOfUnschdApptBecauseOfRuleVioCt__c
• Data Type: DOUBLE
• Description: Number of service appointments unscheduled because of rule violations.

• Field API Name: std__TotNumOfUnschdCapacityRsrceAfterOptimCt__c
• Data Type: DOUBLE
• Description: Total number of unscheduled capacity-based resource (nothing scheduled to that resources) after optimization.

• Field API Name: std__TotNumOfUnschdCapacityRsrceBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Total number of unscheduled capacity-based resource (nothing scheduled to that resources) before optimization.