VIEW: HR.PER_COMPETENCE_ELEMENTS#

Source

View Text - Preformatted

select COMPETENCE_ELEMENT_ID COMPETENCE_ELEMENT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TYPE TYPE, COMPETENCE_ID COMPETENCE_ID, MEMBER_COMPETENCE_SET_ID MEMBER_COMPETENCE_SET_ID, PROFICIENCY_LEVEL_ID PROFICIENCY_LEVEL_ID, HIGH_PROFICIENCY_LEVEL_ID HIGH_PROFICIENCY_LEVEL_ID, WEIGHTING_LEVEL_ID WEIGHTING_LEVEL_ID, RATING_LEVEL_ID RATING_LEVEL_ID, PERSON_ID PERSON_ID, ENTERPRISE_ID ENTERPRISE_ID, JOB_ID JOB_ID, VALID_GRADE_ID VALID_GRADE_ID, POSITION_ID POSITION_ID, ORGANIZATION_ID ORGANIZATION_ID, WORK_ITEM_ID WORK_ITEM_ID, COMPETENCE_SET_ID COMPETENCE_SET_ID, PARENT_COMPETENCE_ELEMENT_ID PARENT_COMPETENCE_ELEMENT_ID, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID, ASSESSMENT_ID ASSESSMENT_ID, ASSESSMENT_TYPE_ID ASSESSMENT_TYPE_ID, MANDATORY MANDATORY, EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM, EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO, GROUP_COMPETENCE_TYPE GROUP_COMPETENCE_TYPE, COMPETENCE_TYPE COMPETENCE_TYPE, SEQUENCE_NUMBER SEQUENCE_NUMBER, NORMAL_ELAPSE_DURATION NORMAL_ELAPSE_DURATION, NORMAL_ELAPSE_DURATION_UNIT NORMAL_ELAPSE_DURATION_UNIT, SOURCE_OF_PROFICIENCY_LEVEL SOURCE_OF_PROFICIENCY_LEVEL, LINE_SCORE LINE_SCORE, CERTIFICATION_DATE CERTIFICATION_DATE, CERTIFICATION_METHOD CERTIFICATION_METHOD, NEXT_CERTIFICATION_DATE NEXT_CERTIFICATION_DATE, COMMENTS COMMENTS, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_ID OBJECT_ID, OBJECT_NAME OBJECT_NAME, PARTY_ID PARTY_ID, QUALIFICATION_TYPE_ID QUALIFICATION_TYPE_ID, UNIT_STANDARD_TYPE UNIT_STANDARD_TYPE, STATUS STATUS, INFORMATION_CATEGORY INFORMATION_CATEGORY, INFORMATION1 INFORMATION1, INFORMATION2 INFORMATION2, INFORMATION3 INFORMATION3, INFORMATION4 INFORMATION4, INFORMATION5 INFORMATION5, INFORMATION6 INFORMATION6, INFORMATION7 INFORMATION7, INFORMATION8 INFORMATION8, INFORMATION9 INFORMATION9, INFORMATION10 INFORMATION10, INFORMATION11 INFORMATION11, INFORMATION12 INFORMATION12, INFORMATION13 INFORMATION13, INFORMATION14 INFORMATION14, INFORMATION15 INFORMATION15, INFORMATION16 INFORMATION16, INFORMATION17 INFORMATION17, INFORMATION18 INFORMATION18, INFORMATION19 INFORMATION19, INFORMATION20 INFORMATION20, ACHIEVED_DATE ACHIEVED_DATE, APPR_LINE_SCORE APPR_LINE_SCORE from "HR"."PER_COMPETENCE_ELEMENTS"

View Text - HTML Formatted

SELECT COMPETENCE_ELEMENT_ID COMPETENCE_ELEMENT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TYPE TYPE
, COMPETENCE_ID COMPETENCE_ID
, MEMBER_COMPETENCE_SET_ID MEMBER_COMPETENCE_SET_ID
, PROFICIENCY_LEVEL_ID PROFICIENCY_LEVEL_ID
, HIGH_PROFICIENCY_LEVEL_ID HIGH_PROFICIENCY_LEVEL_ID
, WEIGHTING_LEVEL_ID WEIGHTING_LEVEL_ID
, RATING_LEVEL_ID RATING_LEVEL_ID
, PERSON_ID PERSON_ID
, ENTERPRISE_ID ENTERPRISE_ID
, JOB_ID JOB_ID
, VALID_GRADE_ID VALID_GRADE_ID
, POSITION_ID POSITION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, WORK_ITEM_ID WORK_ITEM_ID
, COMPETENCE_SET_ID COMPETENCE_SET_ID
, PARENT_COMPETENCE_ELEMENT_ID PARENT_COMPETENCE_ELEMENT_ID
, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, ASSESSMENT_ID ASSESSMENT_ID
, ASSESSMENT_TYPE_ID ASSESSMENT_TYPE_ID
, MANDATORY MANDATORY
, EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, GROUP_COMPETENCE_TYPE GROUP_COMPETENCE_TYPE
, COMPETENCE_TYPE COMPETENCE_TYPE
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, NORMAL_ELAPSE_DURATION NORMAL_ELAPSE_DURATION
, NORMAL_ELAPSE_DURATION_UNIT NORMAL_ELAPSE_DURATION_UNIT
, SOURCE_OF_PROFICIENCY_LEVEL SOURCE_OF_PROFICIENCY_LEVEL
, LINE_SCORE LINE_SCORE
, CERTIFICATION_DATE CERTIFICATION_DATE
, CERTIFICATION_METHOD CERTIFICATION_METHOD
, NEXT_CERTIFICATION_DATE NEXT_CERTIFICATION_DATE
, COMMENTS COMMENTS
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_ID OBJECT_ID
, OBJECT_NAME OBJECT_NAME
, PARTY_ID PARTY_ID
, QUALIFICATION_TYPE_ID QUALIFICATION_TYPE_ID
, UNIT_STANDARD_TYPE UNIT_STANDARD_TYPE
, STATUS STATUS
, INFORMATION_CATEGORY INFORMATION_CATEGORY
, INFORMATION1 INFORMATION1
, INFORMATION2 INFORMATION2
, INFORMATION3 INFORMATION3
, INFORMATION4 INFORMATION4
, INFORMATION5 INFORMATION5
, INFORMATION6 INFORMATION6
, INFORMATION7 INFORMATION7
, INFORMATION8 INFORMATION8
, INFORMATION9 INFORMATION9
, INFORMATION10 INFORMATION10
, INFORMATION11 INFORMATION11
, INFORMATION12 INFORMATION12
, INFORMATION13 INFORMATION13
, INFORMATION14 INFORMATION14
, INFORMATION15 INFORMATION15
, INFORMATION16 INFORMATION16
, INFORMATION17 INFORMATION17
, INFORMATION18 INFORMATION18
, INFORMATION19 INFORMATION19
, INFORMATION20 INFORMATION20
, ACHIEVED_DATE ACHIEVED_DATE
, APPR_LINE_SCORE APPR_LINE_SCORE
FROM "HR"."PER_COMPETENCE_ELEMENTS"