HRT_PERSON_COMPETENCIES

Details

Schema: FUSION
Object owner: HRT
Object type: VIEW

Columns

Name
COMPETENCE_ELEMENT_ID BUSINESS_GROUP_ID OBJECT_VERSION_NUMBER TYPE COMPETENCE_ID MEMBER_COMPETENCE_SET_ID PROFICIENCY_LEVEL_ID HIGH_PROFICIENCY_LEVEL_ID WEIGHTING_LEVEL_ID RATING_LEVEL_ID PERSON_ID ENTERPRISE_ID JOB_ID VALID_GRADE_ID POSITION_ID ORGANIZATION_ID WORK_ITEM_ID COMPETENCE_SET_ID PARENT_COMPETENCE_ELEMENT_ID ACTIVITY_VERSION_ID ASSESSMENT_ID ASSESSMENT_TYPE_ID MANDATORY EFFECTIVE_DATE_FROM EFFECTIVE_DATE_TO GROUP_COMPETENCE_TYPE COMPETENCE_TYPE SEQUENCE_NUMBER NORMAL_ELAPSE_DURATION NORMAL_ELAPSE_DURATION_UNIT SOURCE_OF_PROFICIENCY_LEVEL LINE_SCORE CERTIFICATION_DATE CERTIFICATION_METHOD NEXT_CERTIFICATION_DATE COMMENTS ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_ID OBJECT_NAME PARTY_ID QUALIFICATION_TYPE_ID UNIT_STANDARD_TYPE STATUS INFORMATION_CATEGORY INFORMATION1 INFORMATION2 INFORMATION3 INFORMATION4 INFORMATION5 INFORMATION6 INFORMATION7 INFORMATION8 INFORMATION9 INFORMATION10 INFORMATION11 INFORMATION12 INFORMATION13 INFORMATION14 INFORMATION15 INFORMATION16 INFORMATION17 INFORMATION18 INFORMATION19 INFORMATION20 ACHIEVED_DATE APPR_LINE_SCORE ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15

Name

COMPETENCE_ELEMENT_ID

BUSINESS_GROUP_ID

OBJECT_VERSION_NUMBER

TYPE

COMPETENCE_ID

MEMBER_COMPETENCE_SET_ID

PROFICIENCY_LEVEL_ID

HIGH_PROFICIENCY_LEVEL_ID

WEIGHTING_LEVEL_ID

RATING_LEVEL_ID

PERSON_ID

ENTERPRISE_ID

JOB_ID

VALID_GRADE_ID

POSITION_ID

ORGANIZATION_ID

WORK_ITEM_ID

COMPETENCE_SET_ID

PARENT_COMPETENCE_ELEMENT_ID

ACTIVITY_VERSION_ID

ASSESSMENT_ID

ASSESSMENT_TYPE_ID

MANDATORY

EFFECTIVE_DATE_FROM

EFFECTIVE_DATE_TO

GROUP_COMPETENCE_TYPE

COMPETENCE_TYPE

SEQUENCE_NUMBER

NORMAL_ELAPSE_DURATION

NORMAL_ELAPSE_DURATION_UNIT

SOURCE_OF_PROFICIENCY_LEVEL

LINE_SCORE

CERTIFICATION_DATE

CERTIFICATION_METHOD

NEXT_CERTIFICATION_DATE

COMMENTS

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_ID

OBJECT_NAME

PARTY_ID

QUALIFICATION_TYPE_ID

UNIT_STANDARD_TYPE

STATUS

INFORMATION_CATEGORY

INFORMATION1

INFORMATION2

INFORMATION3

INFORMATION4

INFORMATION5

INFORMATION6

INFORMATION7

INFORMATION8

INFORMATION9

INFORMATION10

INFORMATION11

INFORMATION12

INFORMATION13

INFORMATION14

INFORMATION15

INFORMATION16

INFORMATION17

INFORMATION18

INFORMATION19

INFORMATION20

ACHIEVED_DATE

APPR_LINE_SCORE

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_NUMBER16

ATTRIBUTE_NUMBER17

ATTRIBUTE_NUMBER18

ATTRIBUTE_NUMBER19

ATTRIBUTE_NUMBER20

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

Query

SQL_Statement
SELECT ITEM.PROFILE_ITEM_ID COMPETENCE_ELEMENT_ID, ITEM.BUSINESS_GROUP_ID, ITEM.OBJECT_VERSION_NUMBER, 'PERSONAL' AS TYPE, ITEM.CONTENT_ITEM_ID COMPETENCE_ID, NULL AS MEMBER_COMPETENCE_SET_ID, ITEM.RATING_LEVEL_ID1 AS PROFICIENCY_LEVEL_ID, NULL AS HIGH_PROFICIENCY_LEVEL_ID, NULL AS WEIGHTING_LEVEL_ID, NULL AS RATING_LEVEL_ID, PROFILE.PERSON_ID AS PERSON_ID, NULL AS ENTERPRISE_ID, NULL AS JOB_ID, NULL AS VALID_GRADE_ID, NULL AS POSITION_ID, NULL AS ORGANIZATION_ID, NULL AS WORK_ITEM_ID, NULL AS COMPETENCE_SET_ID, ITEM.PARENT_PROFILE_ITEM_ID PARENT_COMPETENCE_ELEMENT_ID, NULL AS ACTIVITY_VERSION_ID, NULL AS ASSESSMENT_ID, NULL AS ASSESSMENT_TYPE_ID, ITEM.MANDATORY, ITEM.DATE_FROM EFFECTIVE_DATE_FROM, ITEM.DATE_TO EFFECTIVE_DATE_TO, NULL AS GROUP_COMPETENCE_TYPE, ITEM.ITEM_TEXT30_7 AS COMPETENCE_TYPE, ITEM.ITEM_NUMBER_3 AS SEQUENCE_NUMBER, ITEM.ITEM_NUMBER_4 AS NORMAL_ELAPSE_DURATION, ITEM.ITEM_TEXT30_5 AS NORMAL_ELAPSE_DURATION_UNIT, ITEM.ITEM_TEXT30_8 AS SOURCE_OF_PROFICIENCY_LEVEL, NULL AS LINE_SCORE, ITEM.ITEM_DATE_1 AS CERTIFICATION_DATE, ITEM.ITEM_TEXT30_9 AS CERTIFICATION_METHOD, ITEM.ITEM_DATE_2 AS NEXT_CERTIFICATION_DATE, ITEM.ITEM_TEXT2000_2 AS COMMENTS, ITEM.ATTRIBUTE_CATEGORY, ITEM.ATTRIBUTE1, ITEM.ATTRIBUTE2, ITEM.ATTRIBUTE3, ITEM.ATTRIBUTE4, ITEM.ATTRIBUTE5, ITEM.ATTRIBUTE6, ITEM.ATTRIBUTE7, ITEM.ATTRIBUTE8, ITEM.ATTRIBUTE9, ITEM.ATTRIBUTE10, ITEM.ATTRIBUTE11, ITEM.ATTRIBUTE12, ITEM.ATTRIBUTE13, ITEM.ATTRIBUTE14, ITEM.ATTRIBUTE15, ITEM.ATTRIBUTE16, ITEM.ATTRIBUTE17, ITEM.ATTRIBUTE18, ITEM.ATTRIBUTE19, ITEM.ATTRIBUTE20, ITEM.LAST_UPDATE_DATE, ITEM.LAST_UPDATED_BY, ITEM.LAST_UPDATE_LOGIN, ITEM.CREATED_BY, ITEM.CREATION_DATE, NULL AS OBJECT_ID, NULL AS OBJECT_NAME, PROFILE.PARTY_ID AS PARTY_ID, NULL AS QUALIFICATION_TYPE_ID, NULL AS UNIT_STANDARD_TYPE, NULL AS STATUS, ITEM.INFORMATION_CATEGORY, ITEM.INFORMATION1, ITEM.INFORMATION2, ITEM.INFORMATION3, ITEM.INFORMATION4, ITEM.INFORMATION5, ITEM.INFORMATION6, ITEM.INFORMATION7, ITEM.INFORMATION8, ITEM.INFORMATION9, ITEM.INFORMATION10, ITEM.INFORMATION11, ITEM.INFORMATION12, ITEM.INFORMATION13, ITEM.INFORMATION14, ITEM.INFORMATION15, ITEM.INFORMATION16, ITEM.INFORMATION17, ITEM.INFORMATION18, ITEM.INFORMATION19, ITEM.INFORMATION20, NULL AS ACHIEVED_DATE, NULL AS APPR_LINE_SCORE, ITEM.ATTRIBUTE21, ITEM.ATTRIBUTE22, ITEM.ATTRIBUTE23, ITEM.ATTRIBUTE24, ITEM.ATTRIBUTE25, ITEM.ATTRIBUTE26, ITEM.ATTRIBUTE27, ITEM.ATTRIBUTE28, ITEM.ATTRIBUTE29, ITEM.ATTRIBUTE30, ITEM.ATTRIBUTE_NUMBER1, ITEM.ATTRIBUTE_NUMBER2, ITEM.ATTRIBUTE_NUMBER3, ITEM.ATTRIBUTE_NUMBER4, ITEM.ATTRIBUTE_NUMBER5, ITEM.ATTRIBUTE_NUMBER6, ITEM.ATTRIBUTE_NUMBER7, ITEM.ATTRIBUTE_NUMBER8, ITEM.ATTRIBUTE_NUMBER9, ITEM.ATTRIBUTE_NUMBER10, ITEM.ATTRIBUTE_NUMBER11, ITEM.ATTRIBUTE_NUMBER12, ITEM.ATTRIBUTE_NUMBER13, ITEM.ATTRIBUTE_NUMBER14, ITEM.ATTRIBUTE_NUMBER15, ITEM.ATTRIBUTE_NUMBER16, ITEM.ATTRIBUTE_NUMBER17, ITEM.ATTRIBUTE_NUMBER18, ITEM.ATTRIBUTE_NUMBER19, ITEM.ATTRIBUTE_NUMBER20, ITEM.ATTRIBUTE_DATE1, ITEM.ATTRIBUTE_DATE2, ITEM.ATTRIBUTE_DATE3, ITEM.ATTRIBUTE_DATE4, ITEM.ATTRIBUTE_DATE5, ITEM.ATTRIBUTE_DATE6, ITEM.ATTRIBUTE_DATE7, ITEM.ATTRIBUTE_DATE8, ITEM.ATTRIBUTE_DATE9, ITEM.ATTRIBUTE_DATE10, ITEM.ATTRIBUTE_DATE11, ITEM.ATTRIBUTE_DATE12, ITEM.ATTRIBUTE_DATE13, ITEM.ATTRIBUTE_DATE14, ITEM.ATTRIBUTE_DATE15 FROM HRT_PROFILE_ITEMS ITEM, HRT_PROFILES_B PROFILE, HRT_CONTENT_TYPES_B CTYPE WHERE PROFILE.PROFILE_ID = ITEM.PROFILE_ID AND ITEM.CONTENT_TYPE_ID = CTYPE.CONTENT_TYPE_ID AND ITEM.BUSINESS_GROUP_ID = CTYPE.BUSINESS_GROUP_ID AND CTYPE.CONTEXT_NAME = 'COMPETENCY' AND PROFILE.PROFILE_USAGE_CODE = 'P'

SQL_Statement

SELECT

ITEM.PROFILE_ITEM_ID COMPETENCE_ELEMENT_ID,

ITEM.BUSINESS_GROUP_ID,

ITEM.OBJECT_VERSION_NUMBER,

'PERSONAL' AS TYPE,

ITEM.CONTENT_ITEM_ID COMPETENCE_ID,

NULL AS MEMBER_COMPETENCE_SET_ID,

ITEM.RATING_LEVEL_ID1 AS PROFICIENCY_LEVEL_ID,

NULL AS HIGH_PROFICIENCY_LEVEL_ID,

NULL AS WEIGHTING_LEVEL_ID,

NULL AS RATING_LEVEL_ID,

PROFILE.PERSON_ID AS PERSON_ID,

NULL AS ENTERPRISE_ID,

NULL AS JOB_ID,

NULL AS VALID_GRADE_ID,

NULL AS POSITION_ID,

NULL AS ORGANIZATION_ID,

NULL AS WORK_ITEM_ID,

NULL AS COMPETENCE_SET_ID,

ITEM.PARENT_PROFILE_ITEM_ID PARENT_COMPETENCE_ELEMENT_ID,

NULL AS ACTIVITY_VERSION_ID,

NULL AS ASSESSMENT_ID,

NULL AS ASSESSMENT_TYPE_ID,

ITEM.MANDATORY,

ITEM.DATE_FROM EFFECTIVE_DATE_FROM,

ITEM.DATE_TO EFFECTIVE_DATE_TO,

NULL AS GROUP_COMPETENCE_TYPE,

ITEM.ITEM_TEXT30_7 AS COMPETENCE_TYPE,

ITEM.ITEM_NUMBER_3 AS SEQUENCE_NUMBER,

ITEM.ITEM_NUMBER_4 AS NORMAL_ELAPSE_DURATION,

ITEM.ITEM_TEXT30_5 AS NORMAL_ELAPSE_DURATION_UNIT,

ITEM.ITEM_TEXT30_8 AS SOURCE_OF_PROFICIENCY_LEVEL,

NULL AS LINE_SCORE,

ITEM.ITEM_DATE_1 AS CERTIFICATION_DATE,

ITEM.ITEM_TEXT30_9 AS CERTIFICATION_METHOD,

ITEM.ITEM_DATE_2 AS NEXT_CERTIFICATION_DATE,

ITEM.ITEM_TEXT2000_2 AS COMMENTS,

ITEM.ATTRIBUTE_CATEGORY,

ITEM.ATTRIBUTE1,

ITEM.ATTRIBUTE2,

ITEM.ATTRIBUTE3,

ITEM.ATTRIBUTE4,

ITEM.ATTRIBUTE5,

ITEM.ATTRIBUTE6,

ITEM.ATTRIBUTE7,

ITEM.ATTRIBUTE8,

ITEM.ATTRIBUTE9,

ITEM.ATTRIBUTE10,

ITEM.ATTRIBUTE11,

ITEM.ATTRIBUTE12,

ITEM.ATTRIBUTE13,

ITEM.ATTRIBUTE14,

ITEM.ATTRIBUTE15,

ITEM.ATTRIBUTE16,

ITEM.ATTRIBUTE17,

ITEM.ATTRIBUTE18,

ITEM.ATTRIBUTE19,

ITEM.ATTRIBUTE20,

ITEM.LAST_UPDATE_DATE,

ITEM.LAST_UPDATED_BY,

ITEM.LAST_UPDATE_LOGIN,

ITEM.CREATED_BY,

ITEM.CREATION_DATE,

NULL AS OBJECT_ID,

NULL AS OBJECT_NAME,

PROFILE.PARTY_ID AS PARTY_ID,

NULL AS QUALIFICATION_TYPE_ID,

NULL AS UNIT_STANDARD_TYPE,

NULL AS STATUS,

ITEM.INFORMATION_CATEGORY,

ITEM.INFORMATION1,

ITEM.INFORMATION2,

ITEM.INFORMATION3,

ITEM.INFORMATION4,

ITEM.INFORMATION5,

ITEM.INFORMATION6,

ITEM.INFORMATION7,

ITEM.INFORMATION8,

ITEM.INFORMATION9,

ITEM.INFORMATION10,

ITEM.INFORMATION11,

ITEM.INFORMATION12,

ITEM.INFORMATION13,

ITEM.INFORMATION14,

ITEM.INFORMATION15,

ITEM.INFORMATION16,

ITEM.INFORMATION17,

ITEM.INFORMATION18,

ITEM.INFORMATION19,

ITEM.INFORMATION20,

NULL AS ACHIEVED_DATE,

NULL AS APPR_LINE_SCORE,

ITEM.ATTRIBUTE21,

ITEM.ATTRIBUTE22,

ITEM.ATTRIBUTE23,

ITEM.ATTRIBUTE24,

ITEM.ATTRIBUTE25,

ITEM.ATTRIBUTE26,

ITEM.ATTRIBUTE27,

ITEM.ATTRIBUTE28,

ITEM.ATTRIBUTE29,

ITEM.ATTRIBUTE30,

ITEM.ATTRIBUTE_NUMBER1,

ITEM.ATTRIBUTE_NUMBER2,

ITEM.ATTRIBUTE_NUMBER3,

ITEM.ATTRIBUTE_NUMBER4,

ITEM.ATTRIBUTE_NUMBER5,

ITEM.ATTRIBUTE_NUMBER6,

ITEM.ATTRIBUTE_NUMBER7,

ITEM.ATTRIBUTE_NUMBER8,

ITEM.ATTRIBUTE_NUMBER9,

ITEM.ATTRIBUTE_NUMBER10,

ITEM.ATTRIBUTE_NUMBER11,

ITEM.ATTRIBUTE_NUMBER12,

ITEM.ATTRIBUTE_NUMBER13,

ITEM.ATTRIBUTE_NUMBER14,

ITEM.ATTRIBUTE_NUMBER15,

ITEM.ATTRIBUTE_NUMBER16,

ITEM.ATTRIBUTE_NUMBER17,

ITEM.ATTRIBUTE_NUMBER18,

ITEM.ATTRIBUTE_NUMBER19,

ITEM.ATTRIBUTE_NUMBER20,

ITEM.ATTRIBUTE_DATE1,

ITEM.ATTRIBUTE_DATE2,

ITEM.ATTRIBUTE_DATE3,

ITEM.ATTRIBUTE_DATE4,

ITEM.ATTRIBUTE_DATE5,

ITEM.ATTRIBUTE_DATE6,

ITEM.ATTRIBUTE_DATE7,

ITEM.ATTRIBUTE_DATE8,

ITEM.ATTRIBUTE_DATE9,

ITEM.ATTRIBUTE_DATE10,

ITEM.ATTRIBUTE_DATE11,

ITEM.ATTRIBUTE_DATE12,

ITEM.ATTRIBUTE_DATE13,

ITEM.ATTRIBUTE_DATE14,

ITEM.ATTRIBUTE_DATE15

FROM

HRT_PROFILE_ITEMS ITEM,

HRT_PROFILES_B PROFILE,

HRT_CONTENT_TYPES_B CTYPE

WHERE

PROFILE.PROFILE_ID = ITEM.PROFILE_ID

AND ITEM.CONTENT_TYPE_ID = CTYPE.CONTENT_TYPE_ID

AND ITEM.BUSINESS_GROUP_ID = CTYPE.BUSINESS_GROUP_ID

AND CTYPE.CONTEXT_NAME = 'COMPETENCY'

AND PROFILE.PROFILE_USAGE_CODE = 'P'