1. Tables and Views for HCM
  2. HRT_PERSON_PERF_RATINGS_V

HRT_PERSON_PERF_RATINGS_V

Details

  • Schema: FUSION

  • Object owner: HRT

  • Object type: VIEW

Columns

Name

PROFILE_ITEM_ID

BUSINESS_GROUP_ID

PROFILE_ID

PERSON_ID

PARTY_ID

PROFILE_TYPE_ID

CONTENT_TYPE_ID

DATE_FROM

DATE_TO

QUALIFIER_ID1

QUALIFIER_CODE

SOURCE_TYPE

SOURCE_KEY1

PERF_RATING_MODEL_ID

PERF_RATING_LEVEL_ID

PROF_RATING_MODEL_ID

PROF_RATING_LEVEL_ID

ASSIGNMENT_ID

OVERALL_COMMENTS

SECTION_CONTENT_TYPE_ID

PERF_NUMERIC_RATING

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

HRT_PROFILE_ITEMS.PROFILE_ITEM_ID PROFILE_ITEM_ID,

HRT_PROFILE_ITEMS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

HRT_PROFILE_ITEMS.PROFILE_ID PROFILE_ID,

HRT_PROFILES_B.PERSON_ID PERSON_ID,

HRT_PROFILES_B.PARTY_ID PARTY_ID,

HRT_PROFILES_B.PROFILE_TYPE_ID PROFILE_TYPE_ID,

HRT_PROFILE_ITEMS.CONTENT_TYPE_ID CONTENT_TYPE_ID,

HRT_PROFILE_ITEMS.DATE_FROM DATE_FROM,

HRT_PROFILE_ITEMS.DATE_TO DATE_TO,

HRT_PROFILE_ITEMS.QUALIFIER_ID1 QUALIFIER_ID1,

HRT_QUALIFIERS_B.QUALIFIER_CODE QUALIFIER_CODE,

HRT_PROFILE_ITEMS.SOURCE_TYPE SOURCE_TYPE,

HRT_PROFILE_ITEMS.SOURCE_KEY1 SOURCE_KEY1,

HRT_PROFILE_ITEMS.RATING_MODEL_ID1 PERF_RATING_MODEL_ID,

HRT_PROFILE_ITEMS.RATING_LEVEL_ID1 PERF_RATING_LEVEL_ID,

HRT_PROFILE_ITEMS.RATING_MODEL_ID2 PROF_RATING_MODEL_ID,

HRT_PROFILE_ITEMS.RATING_LEVEL_ID2 PROF_RATING_LEVEL_ID,

HRT_PROFILE_ITEMS.ITEM_NUMBER_1 ASSIGNMENT_ID,

HRT_PROFILE_ITEMS.ITEM_TEXT2000_1 OVERALL_COMMENTS,

HRT_PROFILE_ITEMS.ITEM_NUMBER_2 SECTION_CONTENT_TYPE_ID,

HRT_PROFILE_ITEMS.ITEM_DECIMAL_1 PERF_NUMERIC_RATING,

HRT_PROFILE_ITEMS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

HRT_PROFILE_ITEMS.CREATED_BY CREATED_BY,

HRT_PROFILE_ITEMS.CREATION_DATE CREATION_DATE,

HRT_PROFILE_ITEMS.LAST_UPDATED_BY LAST_UPDATED_BY,

HRT_PROFILE_ITEMS.LAST_UPDATE_DATE LAST_UPDATE_DATE,

HRT_PROFILE_ITEMS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

HRT_PROFILE_ITEMS, HRT_PROFILES_B, HRT_QUALIFIERS_B, HRT_CONTENT_TYPES_B

WHERE

HRT_PROFILES_B.PROFILE_ID = HRT_PROFILE_ITEMS.PROFILE_ID

AND HRT_PROFILE_ITEMS.CONTENT_TYPE_ID = HRT_CONTENT_TYPES_B.CONTENT_TYPE_ID

AND HRT_PROFILE_ITEMS.BUSINESS_GROUP_ID = HRT_CONTENT_TYPES_B.BUSINESS_GROUP_ID

AND HRT_CONTENT_TYPES_B.CONTEXT_NAME = 'PERFORMANCE_RATING'

AND HRT_PROFILES_B.PROFILE_USAGE_CODE = 'P'

AND HRT_QUALIFIERS_B.QUALIFIER_ID=HRT_PROFILE_ITEMS.QUALIFIER_ID1

AND HRT_QUALIFIERS_B.BUSINESS_GROUP_ID=HRT_PROFILES_B.BUSINESS_GROUP_ID