DW_WS_SKILL_D

This table stores skill information for scheduling to match workers with tasks.

Details

Module: Global Human Resources

Key Columns

SKILL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SKILL_ID NUMBER 38 0 True System generated identifier to uniquely identify a skill.    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. Unique source record identifier for the skill row.    
ENTERPRISE_ID NUMBER 38 0   Enterprise identifier.    
JOB_PROFILE_TYPE VARCHAR2 32     Type of job profile used to define the skill. DW_WS_JOB_PROFILE_TYPES_D_TL JOB_PROFILE_TYPES
JOB_PROFILE_ID NUMBER 38 0   Identifier of the job profile.    
COMPETENCY_ID NUMBER 38 0   Identifier of a competency.    
SCHEDULING_GROUP_CODE VARCHAR2 32     Scheduling group used to group jobs. DW_WS_SCHEDULING_GROUP_D_TL SCHEDULING_GROUP

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