Svc Schd Request Terr Summary DMO

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

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

• CreatedById has a FOREIGNKEY relationship with the User DMO Id field.
• LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.
• ServiceScheduleRequestId has a FOREIGNKEY relationship with the Service Schedule Request 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
• KQ_CreatedById
• KQ_Id
• KQ_LastModifiedById
• KQ_ServiceScheduleRequestId
• KQ_ServiceTerritoryId
• 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: AvgRespTimeForApptWithWindowAftOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the avg resp time for appt with window aft optim nbr. Do not include currency symbols or commas.

• Field API Name: AvgRespTimeForApptWithWindowBefOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the avg resp time for appt with window bef optim nbr. Do not include currency symbols or commas.

• Field API Name: AvgRespTimeForApptWoWindowAftOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the avg resp time for appt wo window aft optim nbr. Do not include currency symbols or commas.

• Field API Name: AvgRespTimeForApptWoWindowBefOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the avg resp time for appt wo window bef optim nbr. Do not include currency symbols or commas.

• Field API Name: AvgTravelTimeAfterOptimizationNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the avg travel time after optimization number. Do not include currency symbols or commas.

• Field API Name: AvgTravelTimeBeforeOptimizationNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the avg travel time before optimization number. Do not include currency symbols or commas.

• Field API Name: AvgTravelTimeWithoutHomeAfterOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the avg travel time without home after optim nbr. Do not include currency symbols or commas.

• Field API Name: AvgTravelTimeWithoutHomeBeforeOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the avg travel time without home before optim nbr. Do not include currency symbols or commas.

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

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

• Field API Name: CreatedDate__c
• Data Type: DATETIME
• Description: The date and time the record was originally created.

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

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

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

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

• Field API Name: IsDeleted__c
• Data Type: BOOLEAN
• Description: Indicates whether this record is deleted (true) or not (false).

• Field API Name: KQ_CreatedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for CreatedById

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_LastModifiedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for LastModifiedById

• Field API Name: KQ_ServiceScheduleRequestId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ServiceScheduleRequestId

• Field API Name: KQ_ServiceTerritoryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ServiceTerritoryId

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

• Field API Name: LastModifiedDate__c
• Data Type: DATETIME
• Description: The date and time of the last modification to this record.

• Field API Name: NumOfSchdApptToCapacityRsrceAftOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the num of schd appt to capacity rsrce aft optim ct. Do not include currency symbols or commas.

• Field API Name: NumOfSchdApptToCapacityRsrceBefOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the num of schd appt to capacity rsrce bef optim ct. Do not include currency symbols or commas.

• Field API Name: NumOfSchdApptToCrewAfterOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the num of schd appt to crew after optim ct. Do not include currency symbols or commas.

• Field API Name: NumOfSchdApptToCrewBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the num of schd appt to crew before optim ct. Do not include currency symbols or commas.

• Field API Name: NumOfSchdApptToPreferredRsrceAfterCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the num of schd appt to preferred rsrce after ct. Do not include currency symbols or commas.

• Field API Name: NumOfSchdApptToPreferredRsrceBeforeCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the num of schd appt to preferred rsrce before ct. Do not include currency symbols or commas.

• Field API Name: NumOfSchdApptToRglrResourceAfterCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the num of schd appt to rglr resource after ct. Do not include currency symbols or commas.

• Field API Name: NumOfSchdApptToRglrResourceBeforeCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the num of schd appt to rglr resource before ct. Do not include currency symbols or commas.

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

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

• Field API Name: SvcSchdRequestTerrSummaryName__c
• Data Type: TEXT
• Description: Alphanumeric string representing the svc schd request terr summary name.

• Field API Name: SystemModstamp__c
• Data Type: DATETIME
• Description: The date and time of the last system modification.

• Field API Name: TotalCrewWorkCapacityNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the total crew work capacity number. Do not include currency symbols or commas.

• Field API Name: TotalLunchBreakDurationAfterOptimNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the total lunch break duration after optim number. Do not include currency symbols or commas.

• Field API Name: TotalLunchBreakDurationBeforeOptimNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the total lunch break duration before optim number. Do not include currency symbols or commas.

• Field API Name: TotalNonAvlDurationWithGeolcAftOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total non avl duration with geolc aft optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalNonAvlDurationWithGeolcBefOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total non avl duration with geolc bef optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalNonAvlDurationWoGeolcAftOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total non avl duration wo geolc aft optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalNonAvlDurationWoGeolcBefOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total non avl duration wo geolc bef optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalNumberOfCapacityBasedResourcesCount__c
• Data Type: DOUBLE
• Description: The number of total number of capacity based resourceses for this record.

• Field API Name: TotalNumberOfCrewsCount__c
• Data Type: DOUBLE
• Description: The number of total number of crewses for this record.

• Field API Name: TotalNumberOfOptimizableServicesCount__c
• Data Type: DOUBLE
• Description: The number of total number of optimizable serviceses for this record.

• Field API Name: TotalNumberOfPinnedServicesCount__c
• Data Type: DOUBLE
• Description: The number of total number of pinned serviceses for this record.

• Field API Name: TotalNumberOfRegularResourcesCount__c
• Data Type: DOUBLE
• Description: The number of total number of regular resourceses for this record.

• Field API Name: TotalNumberOfSchdServicesAfterOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total number of schd services after optim ct. Do not include currency symbols or commas.

• Field API Name: TotalNumberOfSchdServicesBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total number of schd services before optim ct. Do not include currency symbols or commas.

• Field API Name: TotalNumberOfServicesWithoutWindowCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total number of services without window ct. Do not include currency symbols or commas.

• Field API Name: TotalNumberOfServicesWithWindowCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total number of services with window ct. Do not include currency symbols or commas.

• Field API Name: TotalNumOfSchdApptToPreferredRsrceCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total num of schd appt to preferred rsrce ct. Do not include currency symbols or commas.

• Field API Name: TotalNumOfUnschdCrewAfterOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total num of unschd crew after optim ct. Do not include currency symbols or commas.

• Field API Name: TotalNumOfUnschdCrewBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total num of unschd crew before optim ct. Do not include currency symbols or commas.

• Field API Name: TotalNumOfUnschdRglrRsrceAfterOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total num of unschd rglr rsrce after optim ct. Do not include currency symbols or commas.

• Field API Name: TotalNumOfUnschdRglrRsrceBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total num of unschd rglr rsrce before optim ct. Do not include currency symbols or commas.

• Field API Name: TotalOvertimeForCrewsNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the total overtime for crews number. Do not include currency symbols or commas.

• Field API Name: TotalOvertimeForRegularResourcesNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the total overtime for regular resources number. Do not include currency symbols or commas.

• Field API Name: TotalScheduledTimeOnOvertimeAftOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total scheduled time on overtime aft optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalScheduledTimeOnOvertimeBefOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total scheduled time on overtime bef optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlDistanceFromHomebaseAftOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl distance from homebase aft optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlDistanceFromHomebaseBefOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl distance from homebase bef optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlDistanceToHomebaseAftOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl distance to homebase aft optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlDistanceToHomebaseBefOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl distance to homebase bef optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlDistanceWoHomebaseAftOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl distance wo homebase aft optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlDistanceWoHomebaseBefOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl distance wo homebase bef optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlTimeFromHomebaseAfterOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl time from homebase after optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlTimeFromHomebaseBeforeOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl time from homebase before optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlTimeOnRsrceExpenseAftOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl time on rsrce expense aft optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlTimeOnRsrceExpenseBefOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl time on rsrce expense bef optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlTimeToHomebaseAfterOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl time to homebase after optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlTimeToHomebaseBeforeOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl time to homebase before optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlTimeWoHomeAfterOptimizationNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl time wo home after optimization nbr. Do not include currency symbols or commas.

• Field API Name: TotalTrvlTimeWoHomeBeforeOptimizationNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total trvl time wo home before optimization nbr. Do not include currency symbols or commas.

• Field API Name: TotalWorkCapacityNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the total work capacity number. Do not include currency symbols or commas.

• Field API Name: TotalWorkDurationScheduledAfterOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total work duration scheduled after optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalWorkDurationScheduledBeforeOptimNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the total work duration scheduled before optim nbr. Do not include currency symbols or commas.

• Field API Name: TotalWorkTimeNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the total work time number. Do not include currency symbols or commas.

• Field API Name: TotNumOfUnschdApptBecauseOfLimitedAvlCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the tot num of unschd appt because of limited avl ct. Do not include currency symbols or commas.

• Field API Name: TotNumOfUnschdApptBecauseOfRuleVioCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the tot num of unschd appt because of rule vio ct. Do not include currency symbols or commas.

• Field API Name: TotNumOfUnschdCapacityRsrceAfterOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the tot num of unschd capacity rsrce after optim ct. Do not include currency symbols or commas.

• Field API Name: TotNumOfUnschdCapacityRsrceBeforeOptimCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the tot num of unschd capacity rsrce before optim ct. Do not include currency symbols or commas.