# DW_WS_WORK_PATTERN_ASSIGNMENT_D

This table stores work pattern assignment information.

## Details

Module: Global Human Resources

## Key Columns

WORK_PATTERN_ASSIGNMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
WORK_PATTERN_ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Unique system generated identifier for a work pattern assignment. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique source record identifier for the work pattern assignment row. |  |
WORK_PATTERN_ID | NUMBER | 38 | 0 |  | Identifier of the work pattern associated to this work pattern assignment. |  |
ANCHOR_NUM | NUMBER | 38 | 0 |  | Identifies the period in repeating period unit during which work pattern starts. This is anchor cycle for work pattern. |  |
DATE_FROM | DATE |  |  |  | Date from which the assignment of the work pattern is valid. |  |
DATE_TO | DATE |  |  |  | Date up to which the assignment of the work pattern is valid. |  |
SOURCE | VARCHAR2 | 32 |  |  | Source through which work pattern was created. | DW_WS_WORK_PATTERN_ASG_SOURCE_D_TL | WORK_PATTERN_ASG_SOURCE
SOURCE_WORK_PAT_TEMPLATE_ID | NUMBER | 38 | 0 |  | Identifier of work pattern template which was used to create the work pattern. | DW_WS_WORK_PATTERN_D_TL | WORK_PATTERN_ID
PERSON_ID | NUMBER | 38 | 0 |  | Person ID to which the work pattern is assigned. |  |
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment ID of the person to which the work pattern is assigned. |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise identifier. |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.