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

VIEW: APPS.HRBV_COMPETENCE_ELEMENTS_V

Object Details
Object Name: HRBV_COMPETENCE_ELEMENTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Competence elements (from PER_COMPETENCE_ELEMENTS table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (30) Yes (Lookup code based on lookup type COMPETENCE_ELEMENT_TYPE).
TYPE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type COMPETENCE_ELEMENT_TYPE).
MANDATORY VARCHAR2 (30)
(Lookup code based on lookup type YES_NO).
MANDATORY_M VARCHAR2 (4000)
(Lookup meaning based on lookup type YES_NO).
EFFECTIVE_DATE_FROM DATE

Effective date from.
EFFECTIVE_DATE_TO DATE

Effective date to.
GROUP_COMPETENCE_TYPE VARCHAR2 (30)
Group competence type.
COMPETENCE_TYPE VARCHAR2 (30)
(Lookup code based on lookup type COMPETENCE_TYPE).
COMPETENCE_TYPE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type COMPETENCE_TYPE).
SEQUENCE_NUMBER NUMBER

Sequence number.
NORMAL_ELAPSE_DURATION NUMBER

Normal elapse duration.
NORMAL_ELAPSE_DURATION_UNIT VARCHAR2 (30)
(Lookup code based on lookup type ELAPSE_DURATION).
NORMAL_ELAPSE_DURATION_UNIT_M VARCHAR2 (4000)
(Lookup meaning based on lookup type ELAPSE_DURATION).
SOURCE_OF_PROFICIENCY_LEVEL VARCHAR2 (30)
(Lookup code based on lookup type PROFICIENCY_SOURCE).
SOURCE_OF_PROFICIENCY_LEVEL_M VARCHAR2 (4000)
(Lookup meaning based on lookup type PROFICIENCY_SOURCE).
LINE_SCORE NUMBER (9)
Line score.
CERTIFICATION_DATE DATE

Certification date.
CERTIFICATION_METHOD VARCHAR2 (30)
(Lookup code based on lookup type CERTIFICATION_METHOD).
CERTIFICATION_METHOD_M VARCHAR2 (4000)
(Lookup meaning based on lookup type CERTIFICATION_METHOD).
NEXT_CERTIFICATION_DATE DATE

Next certification date.
COMMENTS VARCHAR2 (2000)
Comments.
OBJECT_NAME VARCHAR2 (30)
Object name.
UNIT_STANDARD_TYPE VARCHAR2 (60)
Unit standard type.
STATUS VARCHAR2 (40)
Status.
INFORMATION_CATEGORY VARCHAR2 (30)
Information category.
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

Achieved date.
_DF:CEL CHAR (35)
COMPETENCE_ELEMENT_ID NUMBER (15) Yes Primary key for PER_COMPETENCE_ELEMENTS.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
COMPETENCE_ID NUMBER (15)
Foreign key to PER_COMPETENCES.
MEMBER_COMPETENCE_SET_ID NUMBER (15)
Member Competence Set Id.
PROFICIENCY_LEVEL_ID NUMBER (15)
Foreign key to PER_RATING_LEVELS.
HIGH_PROFICIENCY_LEVEL_ID NUMBER (15)
Foreign key to PER_RATING_LEVELS.
WEIGHTING_LEVEL_ID NUMBER (15)
Foreign key to PER_RATING_LEVELS.
RATING_LEVEL_ID NUMBER (15)
Foreign key to PER_RATING_LEVELS.
PERSON_ID NUMBER (15)
Foreign key to PER_ALL_PEOPLE_F.
ENTERPRISE_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
JOB_ID NUMBER (15)
Foreign key to PER_JOBS.
VALID_GRADE_ID NUMBER (15)
Foreign key to PER_VALID_GRADES.
POSITION_ID NUMBER (15)
Foreign key to PER_ALL_POSITIONS.
ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
WORK_ITEM_ID NUMBER (15)
Work Item Id.
COMPETENCE_SET_ID NUMBER (15)
Competence Set Id.
PARENT_COMPETENCE_ELEMENT_ID NUMBER (15)
Foreign key to PER_COMPETENCE_ELEMENTS.
ACTIVITY_VERSION_ID NUMBER (15)
Activity Version Id.
ASSESSMENT_ID NUMBER (15)
Foreign key to PER_ASSESSMENTS.
ASSESSMENT_TYPE_ID NUMBER (15)
Foreign key to PER_ASSESSMENT_TYPES.
OBJECT_ID NUMBER (15)
Object Id.
PARTY_ID NUMBER (15)
Foreign key to HZ_PARTIES.
QUALIFICATION_TYPE_ID NUMBER (10)
Foreign key to PER_QUALIFICATION_TYPES.
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
BG_SECURITY_FLAG_CODE CHAR (1)
Business group security flag code.
Query Text

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


SELECT TYPE
,      TYPE_M
,      MANDATORY
,      MANDATORY_M
,      EFFECTIVE_DATE_FROM
,      EFFECTIVE_DATE_TO
,      GROUP_COMPETENCE_TYPE
,      COMPETENCE_TYPE
,      COMPETENCE_TYPE_M
,      SEQUENCE_NUMBER
,      NORMAL_ELAPSE_DURATION
,      NORMAL_ELAPSE_DURATION_UNIT
,      NORMAL_ELAPSE_DURATION_UNIT_M
,      SOURCE_OF_PROFICIENCY_LEVEL
,      SOURCE_OF_PROFICIENCY_LEVEL_M
,      LINE_SCORE
,      CERTIFICATION_DATE
,      CERTIFICATION_METHOD
,      CERTIFICATION_METHOD_M
,      NEXT_CERTIFICATION_DATE
,      COMMENTS
,      OBJECT_NAME
,      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
,      _DF:CEL
,      COMPETENCE_ELEMENT_ID
,      BUSINESS_GROUP_ID
,      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
,      OBJECT_ID
,      PARTY_ID
,      QUALIFICATION_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_COMPETENCE_ELEMENTS_V;

Dependencies

[top of page]

APPS.HRBV_COMPETENCE_ELEMENTS_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPER_COMPETENCE_ELEMENTS

APPS.HRBV_COMPETENCE_ELEMENTS_V is not referenced by any database object