HRT_PERSON_TALENT_SCORES

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 RATING_MODEL_ID RATING_LEVEL_ID OVERALL_COMMENTS OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

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

RATING_MODEL_ID

RATING_LEVEL_ID

OVERALL_COMMENTS

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 RATING_MODEL_ID, HRT_PROFILE_ITEMS.RATING_LEVEL_ID1 RATING_LEVEL_ID, HRT_PROFILE_ITEMS.ITEM_TEXT2000_1 OVERALL_COMMENTS, 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 = 'TALENT_SCORE' 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

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 RATING_MODEL_ID,

HRT_PROFILE_ITEMS.RATING_LEVEL_ID1 RATING_LEVEL_ID,

HRT_PROFILE_ITEMS.ITEM_TEXT2000_1 OVERALL_COMMENTS,

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 = 'TALENT_SCORE'

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