[Home] [Help] [Dependency Information]
Object Name: | HRBV_COMPETENCE_ELEMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Competence elements (from PER_COMPETENCE_ELEMENTS table).
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. |
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;
|
|
|