# DW_SKILL_JOB_CRNT_EF (Preview)

This table requires activation of Skills Management functional area. Table stores information about job profile skills as of current date

## Details

Module:

## Key Columns

PROFILE_ITEM_ID, JOB_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
JOB_ID | NUMBER | 38 | 0 | True | Job Identifier | DW_JOB_D | JOB_ID
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique identifier |  |
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 |  |

## Notes

#1 DW_JOB_D may contain multiple records for a job. Join should also consider fact calendar date to get the dimension values.

#2 DW_JOB_FAMILY_D may contain multiple records for a job family.

#3 DW_POSITION_D may contain multiple records for a position. Join should also consider fact calendar date to get the dimension values.

#4 DW_PAY_GRADE_D may contain multiple records for a grade. Join should also consider fact calendar date to get the dimension values.

#5 DW_GRADE_RATE_VALUE_D may contain multiple records for a grade rate value. Join should also consider fact calendar date to get the dimension values.

#6 DW_GRADE_RATE_D may contain multiple records for a grade rate. Join should also consider fact calendar date to get the dimension values.

#7 DW_PERSON_LEGISLATION_D may contain multiple records for a person. The person information is also legislation specific. Join should also consider fact calendar date and legislation to get the dimension values.

#8 For getting Organization hierarchy, DEPARTMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#9 For getting Organization hierarchy, REPORTING_ESTABLISHMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#10 For getting Organization hierarchy, LEGAL_EMPLOYER_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#11 For getting Organization hierarchy, BUSINESS_UNIT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

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