Work Order Type Mappings

The WoTypeMapExtractPVO view object provides details about work order types for each work order integration.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.WoTypeMapExtractPVO

Primary Keys : WoTypeId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
AllowNonScheduledFlag Identifies whether work orders of this type can be created with only a resolution due.
AllowRescheduleFlag Identifies whether work orders of this type can be rescheduled for another date.
CreatedBy The user who created the row.
CreationDate The date and time when the row was created.
DefaultDuration The default duration in minutes it's expected to take to complete a work order of this type.
DeletedFlag Indicates whether the record is logically deleted.
EnableReminderFlag Identifies whether the reminder time can be included on work orders of this type.
FsTypeCd The work order type code of the corresponding work order type code from the integrating application.
LastUpdateDate The date and time when the row was last updated.
LastUpdateLogin The session login of the user who last updated the row.
LastUpdatedBy The user who last updated the row.
MultiDayFlag Identifies whether work orders of this type will take multiple days to complete.
ObjectVersionNumber The number of times the row has been updated.
SourceCd Identifies the work order type owning application updated during the synchronization process. The work order type can only be updated by the owning application.
SuppInventoryFlag Identifies whether inventory can be used on work orders of this type.
SuppLinksFlag Identifies whether the linking of predecessor and successor activity relationships is allowed on work orders of this type.
SuppPreferredResourcesFlag Identifies whether resource preferences can be defined on work orders of this type.
SuppRequiredInventoryFlag Identifies whether required inventory can be used on work orders of this type. The assigned field technician is then notified.
WoIntegrationCd Identifies the integration this type is associated with.
WoTypeCd Identifies the work order type.
WoTypeId The unique identifier of the record. This is the primary key for the view object.
WoTypeLookupType Identifies the integration application work order type lookup type.
WoTypeLookupTypeCd Identifies the integration application work order type lookup type code. Required for elastic search.