# DW_COI_MODEL_JOB_PRFL_SKILL_CRNT_D (Preview)

This table requires activation of Career Of Interest functional area. Table stores information about job model profile skills as of current date

## 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 | DW_PRFL_PROFILE_ITEM_D | PROFILE_ITEM_ID
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique identifier on profile item |  |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group |  |
PROFILE_ID | NUMBER | 38 | 0 |  | Profile Identifier | DW_PRFL_PROFILE_D | PROFILE_ID
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
SOURCE_TYPE | VARCHAR2 | 32 |  |  | Source Type. For example, HRTR |  |
CALENDAR_DATE | DATE |  |  |  | Calendar Date | DW_DAY_D | CALENDAR_DATE
QUALIFIER_ID1 | NUMBER | 38 | 0 |  | The instance qualifier to use for the item | DW_PRFL_QUALIFIERS_D | QUALIFIER_ID
MIN_SKILL_RATING_MODEL_ID | NUMBER | 38 | 0 |  | Minimum skill rating model identifier | DW_RATING_LEVEL_D | RATING_MODEL_ID
MAX_SKILL_RATING_MODEL_ID | NUMBER | 38 | 0 |  | Maximum skill rating model identifier | DW_RATING_LEVEL_D | RATING_MODEL_ID
MIN_SKILL_RATING_LEVEL_ID | NUMBER | 38 | 0 |  | Minimum skill rating level identifier | DW_RATING_LEVEL_D | RATING_LEVEL_ID
MAX_SKILL_RATING_LEVEL_ID | NUMBER | 38 | 0 |  | Maximum skill rating level identifier | DW_RATING_LEVEL_D | RATING_LEVEL_ID
MANDATORY | VARCHAR2 | 32 |  |  | Required flag, a generic mandatory check box specific to Fusion |  |
IMPORTANCE | NUMBER | 38 | 0 |  | Relative importance |  |
IMPORTANCE_CHAR | VARCHAR2 | 128 |  |  | Relative importance of Character datatype |  |
SKILL_NAME_ATTRIBUTE | VARCHAR2 | 256 |  |  | Name of the skill available as optional text attribute |  |
SPECIALITY | VARCHAR2 | 32 |  |  | Speciality |  |
CURATION_STATUS | VARCHAR2 | 32 |  |  | Curation status of the skill |  |
SOURCE | VARCHAR2 | 32 |  |  | Source of the skill |  |
MIN_YEAR_OF_EXP | NUMBER | 38 | 0 |  | Minimum year of exp |  |
SECTION_ID | NUMBER | 38 | 0 |  | Section Identifier |  |

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