Maintenance Schedule Pattern

The Maintenance Schedule Pattern view object contains information about the maintenance schedule patterns that are used to forecast the work definitions, operations, operation items, and resources needed for a maintenance forecast.

Data Store Key : FscmTopModelAM.ScmExtractAM.MntBiccExtractAM.MntSchedulePatternExtractPVO

Primary Keys : MntSchedulePatternTranslatio1Language, MntSchedulePatternTranslatio1SchedulePatternId, SchedulePatternId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AttributeCategory	Context name for the maintenance schedule pattern descriptive flexfield.
AttributeChar1	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar10	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar11	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar12	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar13	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar14	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar15	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar16	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar17	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar18	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar19	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar2	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar20	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar3	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar4	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar5	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar6	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar7	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar8	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeChar9	Character segment for the maintenance schedule pattern descriptive flexfield.
AttributeDate1	Date segment for the maintenance schedule pattern descriptive flexfield.
AttributeDate2	Date segment for the maintenance schedule pattern descriptive flexfield.
AttributeDate3	Date segment for the maintenance schedule pattern descriptive flexfield.
AttributeDate4	Date segment for the maintenance schedule pattern descriptive flexfield.
AttributeDate5	Date segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber1	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber10	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber2	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber3	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber4	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber5	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber6	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber7	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber8	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeNumber9	Number segment for the maintenance schedule pattern descriptive flexfield.
AttributeTimestamp1	Date and Time segment for the maintenance schedule pattern descriptive flexfield.
AttributeTimestamp2	Date and Time segment for the maintenance schedule pattern descriptive flexfield.
AttributeTimestamp3	Date and Time segment for the maintenance schedule pattern descriptive flexfield.
AttributeTimestamp4	Date and Time segment for the maintenance schedule pattern descriptive flexfield.
AttributeTimestamp5	Date and Time segment for the maintenance schedule pattern descriptive flexfield.
CreatedBy	User who created the maintenance schedule pattern record.
CreationDate	Date when the user created the maintenance schedule pattern record.
CycleInterval	User-defined cycle interval for the maintenance schedule pattern record.
DailyEveryWeekdayFlag	Indicates when the maintenance schedule pattern is forecasted. For example, you can choose to forecast a maintenance schedule pattern every Monday of the week. You can also choose multiple days in a week, such as every Sunday and Wednesday.
JobDefinitionName	The work definition name associated to the maintenance schedule pattern for the asset.
JobDefinitionPackage	The work definition package description associated to the maintenance schedule pattern for the asset.
Language	Code of the language into which the contents of the translatable columns are translated for the maintenance schedule pattern record.
LastUpdateDate	Date and time when the user last updated the maintenance schedule pattern record.
LastUpdateLogin	Session login associated with the user who last updated the maintenance schedule pattern record.
LastUpdatedBy	User who last updated the maintenance schedule pattern record.
MntSchedulePatternTranslatio1CreatedBy	User who created the maintenance schedule pattern translation record.
MntSchedulePatternTranslatio1CreationDate	Date and time when the user created the maintenance schedule pattern translation record.
MntSchedulePatternTranslatio1Language	Code of the language into which the contents of the maintenance schedule pattern translatable columns are translated.
MntSchedulePatternTranslatio1LastUpdateDate	Date and time when the user last updated the maintenance schedule pattern translation record.
MntSchedulePatternTranslatio1LastUpdateLogin	Session login associated with the user who last updated the maintenance schedule pattern translation record.
MntSchedulePatternTranslatio1LastUpdatedBy	User who last updated the maintenance schedule pattern translation record.
MntSchedulePatternTranslatio1ObjectVersionNumber	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.
MntSchedulePatternTranslatio1SchedulePatternDesc	User-defined maintenance schedule pattern description that identifies the maintenance schedule pattern.
MntSchedulePatternTranslatio1SchedulePatternId	Value that uniquely identifies the maintenance schedule pattern. This is the primary key of the maintenance schedule pattern view object.
MntSchedulePatternTranslatio1SourceLang	Code of the source language into which the contents of the maintenance schedule pattern translatable columns are translated.
MonthlySpecificDay	Indicates the monthly specific day the maintenance schedule pattern is forecasted.
MonthlyWeekday	Indicates the monthly week day the maintenance schedule pattern is forecasted.
MonthlyWeekdayOrdinal	Indicates the monthly week ordinal day the maintenance schedule pattern is forecasted.
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.
ProgramId	Value that uniquely identifies the maintenance schedule pattern. This is the primary key of the maintenance schedule pattern view object.
RequestId	Value that uniquely identifies the job request that created or last updated the row. This is populated through Enterprise Service Scheduler.
SchedulePatternId	Value that uniquely identifies the maintenance schedule pattern. This is the primary key of the maintenance schedule pattern view object.
SchedulePatternName	Value that identifies the maintenance schedule pattern. This is the primary key of the maintenance schedule pattern view object.
SchedulePatternType	Value that identifies the maintenance schedule pattern Type. This is the primary key of the maintenance schedule pattern view object.
WeeklyDayFridayFlag	Indicates that the maintenance schedule pattern is forecasted every Friday of the week.
WeeklyDayMondayFlag	Indicates that the maintenance schedule pattern is forecasted every Monday of the week.
WeeklyDaySaturdayFlag	Indicates that the maintenance schedule pattern is forecasted every Saturday of the week.
WeeklyDaySundayFlag	Indicates that the maintenance schedule pattern is forecasted every Sunday of the week.
WeeklyDayThursdayFlag	Indicates that the maintenance schedule pattern is forecasted every Thursday of the week.
WeeklyDayTuesdayFlag	Indicates that the maintenance schedule pattern is forecasted every Tuesday of the week.
WeeklyDayWednesdayFlag	Indicates that the maintenance schedule pattern is forecasted every Wednesday of the week.
YearlyMonth	Indicates the yearly month the maintenance schedule pattern is forecasted.
YearlySpecificDay	Indicates the yearly specific day the maintenance schedule pattern is forecasted.
YearlySpecificMonth	Indicates the yearly specific month the maintenance schedule pattern is forecasted.
YearlyWeekday	Indicates the yearly week day the maintenance schedule pattern is forecasted.
YearlyWeekdayOrdinal	Indicates the yearly week ordinal day the maintenance schedule pattern is forecasted.