This table stores work pattern assignment information.
Module: Global Human Resources
WORK_PATTERN_ASSIGNMENT_ID
| 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.