# DW_PRFL_PRSN_SKILL_D

This dimension holds information about Person Profile type for Skill

## Details

Module: Profile Management

## Key Columns

PROFILE_ITEM_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PROFILE_ITEM_ID | NUMBER | 38 | 0 | True | Key to Profile items |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Primary Key consisting of Assignment Identifier and Calendar Date |  |
PROFILE_ID | NUMBER | 38 | 0 |  | Primary key of Profile | DW_PRFL_PROFILE_D | PROFILE_ID
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group |  |
SECTION_ID | NUMBER | 38 | 0 |  | Section Identifier |  |
DATE_FROM | DATE |  |  |  | Date From |  |
DATE_TO | DATE |  |  |  | Date To |  |
QUALIFIER_ID1 | NUMBER | 38 | 0 |  | The instance qualifier to use for the item |  |
SOURCE_TYPE | VARCHAR2 | 32 |  |  | Source Type. For example, HRTR |  |
CONTENT_TYPE_ID | NUMBER | 38 | 0 |  | Content type Identifier | DW_CONTENT_TYPE_D | CONTENT_TYPE_ID
CONTENT_ITEM_ID | NUMBER | 38 | 0 |  | Content item Identifier | DW_CONTENT_ITEM_D | CONTENT_ITEM_ID
SKILLS | VARCHAR2 | 256 |  |  | Skill |  |
YEARS_OF_EXPERIENCE | NUMBER | 38 | 0 |  | Years of Experience |  |

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