Maintenance Program

The Maintenance Program view object contains information about the maintenance program names that are used to define the work definitions, operations, operation items, and resources needed for a maintenance program or repair process.

Data Store Key : FscmTopModelAM.ScmExtractAM.MntBiccExtractAM.MntProgramExtractPVO

Primary Keys : MaintenanceProgramTranslatio1Language, MaintenanceProgramTranslatio1ProgramId, ProgramId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
ActiveEndDate The active date and time when the user ended the maintenance program record.
ActiveStartDate The active start date and time when the user created the maintenance program record.
AttributeCategory Context name for the maintenance program descriptive flexfield.
AttributeChar1 Character segment for the maintenance program descriptive flexfield.
AttributeChar10 Character segment for the maintenance program descriptive flexfield.
AttributeChar11 Character segment for the maintenance program descriptive flexfield.
AttributeChar12 Character segment for the maintenance program descriptive flexfield.
AttributeChar13 Character segment for the maintenance program descriptive flexfield.
AttributeChar14 Character segment for the maintenance program descriptive flexfield.
AttributeChar15 Character segment for the maintenance program descriptive flexfield.
AttributeChar16 Character segment for the maintenance program descriptive flexfield.
AttributeChar17 Character segment for the maintenance program descriptive flexfield.
AttributeChar18 Character segment for the maintenance program descriptive flexfield.
AttributeChar19 Character segment for the maintenance program descriptive flexfield.
AttributeChar2 Character segment for the maintenance program descriptive flexfield.
AttributeChar20 Character segment for the maintenance program descriptive flexfield.
AttributeChar3 Character segment for the maintenance program descriptive flexfield.
AttributeChar4 Character segment for the maintenance program descriptive flexfield.
AttributeChar5 Character segment for the maintenance program descriptive flexfield.
AttributeChar6 Character segment for the maintenance program descriptive flexfield.
AttributeChar7 Character segment for the maintenance program descriptive flexfield.
AttributeChar8 Character segment for the maintenance program descriptive flexfield.
AttributeChar9 Character segment for the maintenance program descriptive flexfield.
AttributeDate1 Date segment for the maintenance program descriptive flexfield.
AttributeDate2 Date segment for the maintenance program descriptive flexfield.
AttributeDate3 Date segment for the maintenance program descriptive flexfield.
AttributeDate4 Date segment for the maintenance program descriptive flexfield.
AttributeDate5 Date segment for the maintenance program descriptive flexfield.
AttributeNumber1 Number segment for the maintenance program descriptive flexfield.
AttributeNumber10 Number segment for the maintenance program descriptive flexfield.
AttributeNumber2 Number segment for the maintenance program descriptive flexfield.
AttributeNumber3 Number segment for the maintenance program descriptive flexfield.
AttributeNumber4 Number segment for the maintenance program descriptive flexfield.
AttributeNumber5 Number segment for the maintenance program descriptive flexfield.
AttributeNumber6 Number segment for the maintenance program descriptive flexfield.
AttributeNumber7 Number segment for the maintenance program descriptive flexfield.
AttributeNumber8 Number segment for the maintenance program descriptive flexfield.
AttributeNumber9 Number segment for the maintenance program descriptive flexfield.
AttributeTimestamp1 Date and time segment for the maintenance program descriptive flexfield.
AttributeTimestamp2 Date and time segment for the maintenance program descriptive flexfield.
AttributeTimestamp3 Date and time segment for the maintenance program descriptive flexfield.
AttributeTimestamp4 Date and time segment for the maintenance program descriptive flexfield.
AttributeTimestamp5 Date and time segment for the maintenance program descriptive flexfield.
CreatedBy User who created the maintenance program record.
CreationDate Date when the user created the maintenance program record.
InProcessFlag Indicates if the maintenance program is in process.
JobDefinitionName The work definition name associated to the maintenance program.
JobDefinitionPackage The work definition package description associated to the maintenance program.
LastForecastDate Date and time when the user last forecasted the maintenance program record.
LastUpdateDate Date and time when the user last updated the maintenance program record.
LastUpdateLogin Session login associated with the user who last updated the maintenance program record.
LastUpdatedBy User who last updated the maintenance program record for the asset.
MaintenanceProgramTranslatio1CreatedBy User who created the maintenance program translation record.
MaintenanceProgramTranslatio1CreationDate Date and time when the user created the maintenance program translation record.
MaintenanceProgramTranslatio1Language Indicates the code of the language into which the contents of the maintenance program translatable columns are translated.
MaintenanceProgramTranslatio1LastUpdateDate Date and time when the user last updated the maintenance program translation record.
MaintenanceProgramTranslatio1LastUpdateLogin Session login associated with the user who last updated the maintenance program translation record.
MaintenanceProgramTranslatio1LastUpdatedBy User who last updated the maintenance program translation record.
MaintenanceProgramTranslatio1ObjectVersionNumber Number of times the object row was updated for translation. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
MaintenanceProgramTranslatio1ProgramDescription The maintenance program description that identifies the maintenance program record.
MaintenanceProgramTranslatio1ProgramId Value that uniquely identifies the maintenance program identifier. This is the primary key of the Maintenance Program view object.
MaintenanceProgramTranslatio1ProgramName The maintenance program that identifies the maintenance program translation.
MaintenanceProgramTranslatio1SourceLang Indicates the source language into which the contents of the maintenance program translatable columns are translated.
ModifiedFlag Indicates if the maintenance program is modified.
ObjectVersionNumber Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
OrganizationId Value that uniquely identifies the inventory organization that the application has enabled for maintenance.
ProgramCode User-defined maintenance program code that uniquely identifies the maintenance program record.
ProgramId Value that uniquely identifies the maintenance program identifier. This is the primary key of the Maintenance Program view object.
RequestId Indicates the request identifier of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
ReviewComments Indicates the maintenance program review comments
ReviewDate Indicates the maintenance program review date
ReviewedBy User who last reviewed the maintenance program record.
SuppressMergeCode User-defined suppress merge description code for maintenance program.