ZMM_SR_SCHEDULES_B
Table to store Schedule related data.
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZMM_SR_SCHEDULES_B_PK |
SCHEDULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCHEDULE_ID | NUMBER | 18 | Yes | Primary Key attribute to uniquely identify a row. | |
| SCHEDULE_TYPE_CODE | VARCHAR2 | 30 | Yes | A Schedule can have following types - Time, Duration and Elapsed. A Time Schedule can include only Time Patterns, an Elapsed Schedule can incude only Elapsed Patterns and a Duration Schedule can include only Duration Patterns. | |
| EFFECTIVE_FROM_DATE | DATE | Yes | A Schedule is effective from the Effective Start Date to the Effective End Date. The Patterns that are included in the Schedule start from the Efffective From Data and end on Effective End Date. | ||
| EFFECTIVE_TO_DATE | DATE | Yes | A Schedule is effective from the Effective Start Date to the Effective End Date. The Patterns that are included in the Schedule start from the Efffective From Data and end on Effective End Date. | ||
| CATEGORY_CODE | VARCHAR2 | 30 | Category can be used to group Schedules. | ||
| DELETED_FLAG | VARCHAR2 | 1 | Whether the Schedule is still active or not. If value is 'Y' than onle this Schedule can used in assignment. Possible values 'Y' or 'N'. | ||
| QTRLY_TYPE_CODE | VARCHAR2 | 30 | Defines how a quarter is defined for a Schedule. | ||
| ASSIGNMENT_NUM | NUMBER | 18 | Stores number of assignments for this schedule. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition 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. | ||
| 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. | |
| WEEK_START_CODE | VARCHAR2 | 30 | Starting day of the work week. A value of null will use Monday as the start day. A value may be supplied when the patterns in the schedule use a seven day recurrence, or a multiple of seven. | ||
| HCM_SCHEDULE_MAPPED_FLAG | VARCHAR2 | 1 | Contains one of the following values: true or false. If true, then the SCM schedule has been mapped to an HCM schedule generation profile. If false, then the SCM schedule is not mapped to HCM. The default value is false. | ||
| HCM_SCHED_GEN_PROFILE_ID | NUMBER | 18 | Value of the HCM Schedule Generation Profile selected by the user to map to this schedule. Mapped schedules will have identical shift definitions allowing HCM workforce integration to generate the scheduling of smart operations in manufacturing and maintenance. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| zmm_sr_schedules_tl | zmm_sr_schedules_b | SCHEDULE_ID |
| zmm_sr_year_start_dates | zmm_sr_schedules_b | SCHEDULE_ID |
| zmm_sr_schedule_patterns | zmm_sr_schedules_b | SCHEDULE_ID |
| zmm_sr_sched_avl_excps | zmm_sr_schedules_b | SCHEDULE_ID |
| per_schedule_eligibility | zmm_sr_schedules_b | SCHEDULE_ID |
| wis_wc_prod_calendars | zmm_sr_schedules_b | MFG_CALENDAR_ID |
| zmm_sr_available_dates | zmm_sr_schedules_b | SCHEDULE_ID |
| per_schedule_exceptions | zmm_sr_schedules_b | SCHEDULE_ID |
| zmm_sr_schedule_dtls | zmm_sr_schedules_b | SCHEDULE_ID |
| per_schedule_assignments | zmm_sr_schedules_b | SCHEDULE_ID |
| zmm_sr_prd_start_dates | zmm_sr_schedules_b | SCHEDULE_ID |
| zmm_sr_week_start_dates | zmm_sr_schedules_b | SCHEDULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZMM_SR_SCHEDULES_B_N1 | Non Unique | Default | CATEGORY_CODE |
| ZMM_SR_SCHEDULES_B_N2 | Non Unique | ZMM_SR_SCHEDULES_B_N2 | HCM_SCHEDULE_MAPPED_FLAG |
| ZMM_SR_SCHEDULES_B_PK | Unique | Default | SCHEDULE_ID |