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