IRC_PROFILE_SKILL_ITEMS_V

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name
SKILL_ID BUSINESS_GROUP_ID PROFILE_ID PARENT_PROFILE_ITEM_ID SECTION_ID CONTENT_TYPE_ID CONTENT_ITEM_ID SKILLS DATE_ACHIEVED YEARS_OF_EXPERIENCE PROJECT_NAME SPECIALITY COMMENTS DESCRIPTION REQUIRED_FLAG DATE_FROM DATE_TO IMPORTANCE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT PROFILE_ITEM_ID AS SKILL_ID , BUSINESS_GROUP_ID , PROFILE_ID , PARENT_PROFILE_ITEM_ID , SECTION_ID , CONTENT_TYPE_ID , CONTENT_ITEM_ID , ITEM_TEXT240_1 AS SKILLS , ITEM_DATE_1 AS DATE_ACHIEVED , ITEM_NUMBER_1 AS YEARS_OF_EXPERIENCE , ITEM_TEXT2000_1 AS PROJECT_NAME , ITEM_TEXT30_1 AS SPECIALITY , ITEM_CLOB_1 AS COMMENTS , ITEM_CLOB_2 AS DESCRIPTION , MANDATORY AS REQUIRED_FLAG, DATE_FROM, DATE_TO, IMPORTANCE AS IMPORTANCE, OBJECT_VERSION_NUMBER , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN FROM HRT_PROFILE_ITEMS PI WHERE CONTENT_TYPE_ID = 134 AND SECTION_ID IN (SELECT SECTION_ID FROM IRC_PROFILE_CONT_SECTIONS_V PTS WHERE PTS.PROFILE_TYPE_ID = 1 AND PTS.CONTENT_TYPE_ID = 134 AND PTS.BUSINESS_GROUP_ID = PI.BUSINESS_GROUP_ID)