eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PER_COMPETENCE_ELEMENTS

Object Details

Object Name:	PER_COMPETENCE_ELEMENTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_COMPETENCE_ELEMENTS
Subobject Name:
Status:	VALID

A competence element is used to record an individual competence and
an evaluation rating. Either a competence level or a specific rating
scale step may be indicated as the evaluation rating. A competence
element can be of the following types
Requirement
The competences and rating levels required by Organizations, Jobs,
Positions, Grades, Work, Work Allocations in order to fulfill their
Business Objectives.
Assessment
The competences and rating levels that result from an assessment of an
individual.
Prequisite
The competences and rating levels that are necessary for a person to
possess before they are entitled to a Qualifications or to attend a
Development Activity.
Output
The competences and rating levels that are delivered by a
Qualification or Development Activity.
Personal
The competences and rating levels that a person posesses.
Preference
The development activities that are the preferred delivery method of
certain competences at certain levels.
Definition
A competence and optionally a rating level that is part of a defined
set of competences.
Target
The competences and rating levels that are set as a target or
objective for a person.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_COMPETENCE_ELEMENTS_PK

COMPETENCE_ELEMENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_COMPETENCE_ELEMENTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPETENCE_ELEMENT_ID
PER_COMPETENCE_ELEMENTS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPETENCE_ID
PER_COMPETENCE_ELEMENTS_FK10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
PER_COMPETENCE_ELEMENTS_FK14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSESSMENT_ID
PER_COMPETENCE_ELEMENTS_FK15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSESSMENT_TYPE_ID
PER_COMPETENCE_ELEMENTS_FK16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RATING_LEVEL_ID
PER_COMPETENCE_ELEMENTS_FK17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WEIGHTING_LEVEL_ID
PER_COMPETENCE_ELEMENTS_FK18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_COMPETENCE_ELEMENT_ID
PER_COMPETENCE_ELEMENTS_FK19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALID_GRADE_ID
PER_COMPETENCE_ELEMENTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_COMPETENCE_ELEMENTS_FK20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTERPRISE_ID
PER_COMPETENCE_ELEMENTS_FK23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUALIFICATION_TYPE_ID
PER_COMPETENCE_ELEMENTS_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROFICIENCY_LEVEL_ID
PER_COMPETENCE_ELEMENTS_FK6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HIGH_PROFICIENCY_LEVEL_ID
PER_COMPETENCE_ELEMENTS_FK7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
PER_COMPETENCE_ELEMENTS_FK8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOB_ID
PER_COMPETENCE_ELEMENTS_FK9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_ID
PER_COMPETENCE_ELEMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TYPE
PER_COMPETENCE_ELEMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPETENCE_TYPE
PER_COMPETENCE_ELEMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_NAME OBJECT_ID
PER_COMPETENCE_ELEMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
PER_COMPETENCE_ELEMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_VERSION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PER_COMPETENCE_ELEMENTS	HR_ALL_ORGANIZATION_UNITS	PER_COMPETENCE_ELEMENTS ORGANIZATION_ID
PER_COMPETENCE_ELEMENTS	HR_ALL_ORGANIZATION_UNITS	PER_COMPETENCE_ELEMENTS ENTERPRISE_ID
PER_COMPETENCE_ELEMENTS	HR_ALL_ORGANIZATION_UNITS	PER_COMPETENCE_ELEMENTS BUSINESS_GROUP_ID
PER_COMPETENCE_ELEMENTS	PER_ASSESSMENTS	PER_COMPETENCE_ELEMENTS ASSESSMENT_ID
PER_COMPETENCE_ELEMENTS	PER_ASSESSMENT_TYPES	PER_COMPETENCE_ELEMENTS ASSESSMENT_TYPE_ID
PER_COMPETENCE_ELEMENTS	PER_COMPETENCES	PER_COMPETENCE_ELEMENTS COMPETENCE_ID
PER_COMPETENCE_ELEMENTS	PER_COMPETENCE_ELEMENTS	PER_COMPETENCE_ELEMENTS PARENT_COMPETENCE_ELEMENT_ID
PER_COMPETENCE_ELEMENTS	PER_JOBS	PER_COMPETENCE_ELEMENTS JOB_ID
PER_COMPETENCE_ELEMENTS	PER_RATING_LEVELS	PER_COMPETENCE_ELEMENTS WEIGHTING_LEVEL_ID
PER_COMPETENCE_ELEMENTS	PER_RATING_LEVELS	PER_COMPETENCE_ELEMENTS RATING_LEVEL_ID
PER_COMPETENCE_ELEMENTS	PER_RATING_LEVELS	PER_COMPETENCE_ELEMENTS PROFICIENCY_LEVEL_ID
PER_COMPETENCE_ELEMENTS	PER_RATING_LEVELS	PER_COMPETENCE_ELEMENTS HIGH_PROFICIENCY_LEVEL_ID
PER_COMPETENCE_ELEMENTS	PER_VALID_GRADES	PER_COMPETENCE_ELEMENTS VALID_GRADE_ID
PER_COMPETENCE_ELEMENTS	PER_COMPETENCE_ELEMENTS	PER_COMPETENCE_ELEMENTS PARENT_COMPETENCE_ELEMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COMPETENCE_ELEMENT_ID	NUMBER	(15)	Yes	Unique identifier fo Competence Elements
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign Key to HR_ORGANIZATION_UNITS
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
TYPE	VARCHAR2	(30)	Yes	The type of Competence Element.
COMPETENCE_ID	NUMBER	(15)		Competence Used
MEMBER_COMPETENCE_SET_ID	NUMBER	(15)		Competence Set for the Element
PROFICIENCY_LEVEL_ID	NUMBER	(15)		Low Proficiency Level for the Element
HIGH_PROFICIENCY_LEVEL_ID	NUMBER	(15)		High Proficiency Level for the Element
WEIGHTING_LEVEL_ID	NUMBER	(15)		Weighting on particular competence to be used in an Assessment Type
RATING_LEVEL_ID	NUMBER	(15)		Rating for a particular competence in an Element
PERSON_ID	NUMBER	(15)		The person for whom the competence element applies.
ENTERPRISE_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS
JOB_ID	NUMBER	(15)		Competence element for the Job requirement.
VALID_GRADE_ID	NUMBER	(15)		Foriegn Key to PER_VALID_GRADES
POSITION_ID	NUMBER	(15)		Competence Element for the Position requirement
ORGANIZATION_ID	NUMBER	(15)		Competence Element for the Organizational requirement
WORK_ITEM_ID	NUMBER	(15)		Competence Element for the Work Item
COMPETENCE_SET_ID	NUMBER	(15)		Grouping of Competences - Competence Set
PARENT_COMPETENCE_ELEMENT_ID	NUMBER	(15)		Competence Element which this competence element referes to
ACTIVITY_VERSION_ID	NUMBER	(15)		Activity Version of a Training course. Inidicates what competences a particular training activity can provide and at what levels.
ASSESSMENT_ID	NUMBER	(15)		Competence Element for the Assessment
ASSESSMENT_TYPE_ID	NUMBER	(15)		Competence Element for the Assessment Type
MANDATORY	VARCHAR2	(30)		An indication of whether the delivered competence should be automatically included in a persons competence profile or whether it should be manually selected.
EFFECTIVE_DATE_FROM	DATE			The date upon which the competence rating is effective
EFFECTIVE_DATE_TO	DATE			The date after which the competence rating is no longer valid
GROUP_COMPETENCE_TYPE	VARCHAR2	(30)		A group of competences used in an assessment template
COMPETENCE_TYPE	VARCHAR2	(30)		The categorization of a competence
SEQUENCE_NUMBER	NUMBER			A number to control the display sequence of elements within a profile
NORMAL_ELAPSE_DURATION	NUMBER			The elapsed time before a competence should be achieved within a planned competence profile
NORMAL_ELAPSE_DURATION_UNIT	VARCHAR2	(30)		The units for the elapsed time before a competence should be achieved within planned competence profile
SOURCE_OF_PROFICIENCY_LEVEL	VARCHAR2	(30)		The method by which the proficiency level was established e.g. Mandatory Delivered Competence, Assessemnt Rating
LINE_SCORE	NUMBER	(9)		The calculated score for a single line in an assessment
CERTIFICATION_DATE	DATE			The date on which the competence rating is certified
CERTIFICATION_METHOD	VARCHAR2	(30)		An indication of the process undertaken to determine he competence
NEXT_CERTIFICATION_DATE	DATE			The date on the which the next certification is due
COMMENTS	VARCHAR2	(2000)		Comments
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
OBJECT_ID	NUMBER	(15)		Generic Foreign Key id.
OBJECT_NAME	VARCHAR2	(30)		Generic Foreign Key Name.
PARTY_ID	NUMBER	(15)		Foreign key to HZ_PARTIES.
QUALIFICATION_TYPE_ID	NUMBER	(10)		Qualification Type id
UNIT_STANDARD_TYPE	VARCHAR2	(60)		Unit Standard Type
STATUS	VARCHAR2	(40)		Status of the competency. Values derived from lookup PER_QUAL_FWK_COMP_STATUS
INFORMATION_CATEGORY	VARCHAR2	(30)		Developer Descriptive Flexfield Structure defining column
INFORMATION1	VARCHAR2	(240)		Developer Descriptive Flexfield Column
INFORMATION2	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION3	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION4	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION5	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION6	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION7	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION8	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION9	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION10	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION11	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION12	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION13	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION14	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION15	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION16	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION17	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION18	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION19	VARCHAR2	(150)		Developer Descriptive Flexfield Column
INFORMATION20	VARCHAR2	(150)		Developer Descriptive Flexfield Column
ACHIEVED_DATE	DATE			Date when the competence was achieved
APPR_LINE_SCORE	NUMBER			Score calculated from appraisal ratings

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM HR.PER_COMPETENCE_ELEMENTS;

Dependencies

[top of page]

HR.PER_COMPETENCE_ELEMENTS does not reference any database object

HR.PER_COMPETENCE_ELEMENTS is referenced by following:

APPS: BEN_COMPETENCE_EVT; PER_COMPETENCE_ELEMENTS; PER_COMPETENCE_ELEMENTS_WHO
PUBLIC: PER_COMPETENCE_ELEMENTS