Work Order Status Mappings

The WoStatusMapExtractPVO view object provides details about work order statuses for each work order integration.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.WoStatusMapExtractPVO

Primary Keys : WoIntegrationCd, WoStatusCd

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
CreatedBy	The user who created the row.
CreationDate	The date and time when the row was created.
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.
ObjectVersionNumber	The number of times the row has been updated.
SeedDataSource	The source of seed data record. A value of BULK_SEED_DATA_SCRIPT indicates that the record was bulk loaded. Otherwise, specifies the name of the seed data file.
UseCancelProcessFlag	Indicates whether the status should initiate the cancel part process.
WoIntegrationCd	Identifies the integration the status is associated with.
WoStatusCatCd	Identifies the category of the status.
WoStatusCd	Identifies the status of integration application work order.
WoStatusLookupType	Identifies the lookup type of the integration application work order status.
WoStatusLookupTypeCd	Identifies the integration application work order status lookup type code. Required for elastic search.
WoStatusMapId	The unique identifier of the record. This is the primary key for the view object.