MNT_SCHEDULE_PATTERNS_INT
The open interface entity that holds all the maintenance program schedule pattern information.
Details
-
Schema: FUSION
-
Object owner: MNT
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
MNT_SCHEDULE_PATTERNS_INT_PK |
INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Interface Row Identifier. The primary key column of this table. | |
| INTERFACE_STATUS_CODE | VARCHAR2 | 30 | The status of the interface row. The processor heavily relies on this column to persist interim status of the row upon processing data in bulk. | ||
| INTERFACE_BATCH_ID | NUMBER | 18 | Interface Batch Identifier. This is the foreign key to the Interface Batch entity. | ||
| INTERFACE_BATCH_CODE | VARCHAR2 | 30 | The interface batch code. The user key to the interface batch entity. | ||
| PARTITION_NUMBER | NUMBER | 18 | For parallel processing, the internal logic uses this column to stripe a set of schedule patterns in to a partition. | ||
| HEADER_NUMBER | VARCHAR2 | 18 | Interface Record Number. This is the user key to link the child interface entities together. | ||
| ACTION_CODE | VARCHAR2 | 30 | The various actions that can be performed via the import functionality at the schedule pattern level. | ||
| SCHEDULE_PATTERN_ID | NUMBER | 18 | Unique system identifier for the schedule pattern. | ||
| SCHEDULE_PATTERN_NAME | VARCHAR2 | 120 | The name of the schedule pattern. | ||
| SCHEDULE_PATTERN_DESC | VARCHAR2 | 240 | The description of the scheduled 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 | The type of the schedule pattern. It could be either "Daily', 'Weekly', 'Monthly', or 'Yearly'. | ||
| CYCLE_INTERVAL | NUMBER | 3 | 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. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Load Request Identifier. This is to support the loading of the interface records from the data files using the cloud framework. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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_INT_N01 | Non Unique | Default | PARTITION_NUMBER |
| MNT_SCHEDULE_PATTERNS_INT_N02 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE, HEADER_NUMBER |
| MNT_SCHEDULE_PATTERNS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |