# DW_WS_WORK_PATTERN_D

This table stores work pattern information.

## Details

Module: Global Human Resources

## Key Columns

WORK_PATTERN_ID

## Columns

Columns
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.