MNT_SCHEDULE_PATTERNS_B
This entity defines the pattern to be used in the scheduling of the maintenance plan. A maintenance program uses these schedule patterns to schedule the day where preventive maintenance work is to be performed.
Details
-
Schema: FUSION
-
Object owner: MNT
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCHEDULE_PATTERN_ID | NUMBER | 18 | Yes | Unique system identifier for the schedule pattern. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that 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. | |
| SCHEDULE_PATTERN_NAME | VARCHAR2 | 120 | Yes | The name of the schedule pattern. | |
| PROGRAM_ID | NUMBER | 18 | Foreign key to the maintenance program. All schedule patterns are created for a maintenance program. | ||
| SCHEDULE_PATTERN_TYPE | VARCHAR2 | 30 | Yes | The type of the schedule pattern. It could be either "Daily', 'Weekly', 'Monthly', or 'Yearly'. | |
| CYCLE_INTERVAL | NUMBER | 3 | Yes | Specifies the number of occurances in the pattern type. | |
| DAILY_EVERY_WEEKDAY_FLAG | VARCHAR2 | 1 | When the schedule pattern type is "Daily', this flag indicates wheter the forecast should be scheduled only on the weekdays of the week. Weekends and weekdays are determined based on the calendar that is tied up in the maintenance organization. | ||
| WEEKLY_DAY_SUNDAY_FLAG | VARCHAR2 | 1 | Flag to indicate whether Sunday is to be counted in the scheduling of the work when the schedule pattern type is 'Weekly'. | ||
| WEEKLY_DAY_MONDAY_FLAG | VARCHAR2 | 1 | Flag to indicate whether Monday is to be counted in the scheduling of the work when the schedule pattern type is 'Weekly'. | ||
| WEEKLY_DAY_TUESDAY_FLAG | VARCHAR2 | 1 | Flag to indicate whether Tuesday is to be counted in the scheduling of the work when the schedule pattern type is 'Weekly'. | ||
| WEEKLY_DAY_WEDNESDAY_FLAG | VARCHAR2 | 1 | Flag to indicate whether Wednesday is to be counted in the scheduling of the work when the schedule pattern type is 'Weekly'. | ||
| WEEKLY_DAY_THURSDAY_FLAG | VARCHAR2 | 1 | Flag to indicate whether Thursday is to be counted in the scheduling of the work when the schedule pattern type is 'Weekly'. | ||
| WEEKLY_DAY_FRIDAY_FLAG | VARCHAR2 | 1 | Flag to indicate whether Friday is to be counted in the scheduling of the work when the schedule pattern type is 'Weekly'. | ||
| WEEKLY_DAY_SATURDAY_FLAG | VARCHAR2 | 1 | Flag to indicate whether Saturday is to be counted in the scheduling of the work when the schedule pattern type is 'Weekly'. | ||
| MONTHLY_SPECIFIC_DAY | NUMBER | 2 | A specific day in the month where work is to be scheduled when the schedule pattern type is 'Monthly' | ||
| MONTHLY_WEEKDAY_ORDINAL | VARCHAR2 | 30 | The ordinal to list the first, second, third, fourth or the last weekday of the month. | ||
| MONTHLY_WEEKDAY | VARCHAR2 | 30 | One of the weekday drawn for the lookup. Valid values are 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday' or 'Saturday'. | ||
| YEARLY_SPECIFIC_MONTH | VARCHAR2 | 30 | The specific month in the year where the work is to be scheduled when the schedule pattern type is 'Yearly'. | ||
| YEARLY_SPECIFIC_DAY | NUMBER | 2 | A specific day in the month of the year to schedule work when the schedule pattern type is yearly and when the specific month and day is specified. | ||
| YEARLY_WEEKDAY_ORDINAL | VARCHAR2 | 30 | The ordinal to list the first, second, third, fourth or the last weekday of the month. | ||
| YEARLY_WEEKDAY | VARCHAR2 | 30 | One of the weekday drawn for the lookup. Valid values are 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday' or 'Saturday'. | ||
| YEARLY_MONTH | VARCHAR2 | 30 | The month on which the work is to be scheduled when the schedule type is 'Yearly' and the weekday is specified with an ordinal prefix. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MNT_SCHEDULE_PATTERNS_B_U01 | Unique | Default | SCHEDULE_PATTERN_ID |
| MNT_SCHEDULE_PATTERNS_B_U02 | Unique | Default | SCHEDULE_PATTERN_NAME, PROGRAM_ID |