This table stores work pattern information.
Module: Global Human Resources
WORK_PATTERN_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| WORK_PATTERN_ID | NUMBER | 38 | 0 | True | Unique identifier for work pattern. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. Unique source record identifier for the work pattern row. | ||||
| ENTERPRISE_ID | NUMBER | 38 | 0 | Enterprise identifier. | |||
| REPEAT_NUM | NUMBER | 38 | 0 | Length of work pattern in repeating period unit. | |||
| REPEAT_CYCLE | VARCHAR2 | 64 | Unit of work pattern in repeating period unit. | DW_WS_PATTERNS_REPEAT_INCR_D_TL | PATTERNS_REPEAT_INCR | ||
| START_DAY_OF_PATTERN | VARCHAR2 | 32 | Identifies the day on which work pattern starts. | ||||
| TEMPLATE_FLAG | VARCHAR2 | 32 | Identifies whether work pattern is considered as a template. |
Copyright © 2019, 2026, Oracle and/or its affiliates.