HRT_SECTION_VALUESET_NAMES_V

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name

SECTION_ID BUSINESS_GROUP_ID READING_LEVEL_ID REQUIRED_FLAG COUNTRY_CODE EDU_LEVEL_COMP_FLAG SUBSCRIPTION_PAY_METH REQUIREMENT_TYPE MASTERY_LEVEL_ID SKILL_CATEGORY TEMP_ASSIGN_FLAG WORK_HOURS PREFERRED_LOCATION_ID3 EXCLUDED_LOCATION_ID3 IMPACT_LEVEL_ID NEXT_MOVE_JOB_FAMILY ITEM_TEXT30_6 SPEAKING_LEVEL_ID PERF_RATING_LEVEL_ID VERIFIED_FLAG CURRENT_VOLUNTEER_FLAG NAT_TRAVEL_REQUIRED_FLAG READINESS_LEVEL_ID JOB_FAMILY_ID READINESS_ADDED_BY EXCLUDED_LOCATION_ID1 PATENT_PENDING NEXT_MOVE_LOCATION CONTENT_ITEM_ID RATING_INTERACTION_TYPE GRADUATED_FLAG TRMNL_DEG_DISCP_FLAG DURATION_UNITS RENEWAL_INPROGRESS_FLAG FLEXIBLE_WORK_FLAG CURRENCY_CODE PAY_FREQUENCY EMPLOYER_COUNTRY_ID POTENTIAL_LEVEL_ID GRADUATION_REQUIRED_FLAG REQUIRED_INTL_TRAVEL_FREQ REQUIRED_NAT_TRAVEL_FREQ READINESS_LEVEL SCORE_LEVEL_ID NEXT_MOVE_JOB_FUNCTION BILLABLE_FLAG ASSIGNMENT_ID RISK_REASON CONFIRMATION_STATUS CATEGORY ABLE_TO_TEACH_FLAG MIN_PROF_LEVEL_ID IMPORTANCE PROF_RATING_LEVEL_ID STATE_PROVINCE_CODE ACADEMIC_STANDING CONTACT_SUPERVISOR_FLAG FULL_TIME_CODE COUNTRY_ID CURRENT_MEMBERSHIP_REQ_FLAG AWARD_TYPE NAT_TRAVEL_FREQUENCY PREFERRED_LOCATION_ID1 PREFERRED_LOCATION_ID2 READINESS_PROFILE_ID DEPARTURE_REASON CONTACT_PERSON_ID PAY_RANGE SPECIALITY NATIVE_SPEAKER_FLAG MAX_PROF_LEVEL_ID PART_TIME_FLAG FEE_CURRENCY INTERNAL_FLAG PART_ASSIGN_FLAG STATE_PROVINCE_ID SKILL_RECOMMENDATION_TYPE PLATFORM ITEM_TEXT30_8 ABLE_TO_TRANSLATE_FLAG INTL_TRAVEL_FREQUENCY INTL_TRAVEL_REQUIRED_FLAG JOB_FUNCTION RISK_LEVEL_ID RATING_LEVEL_ID EST_REMAINING_MONTHS SKILL_GROUP NEXT_MOVE_LOCATION2 WRITING_LEVEL_ID RELATIONSHIP_CODE REVIEW_ACTIVE_FLAG EDUCATIONAL_ESTABLISHMENT_ID STATUS TUITION_METHOD HIGHEST_EDU_LEVEL INTERNAL_ORG_FLAG SKILL_CURATION_STATUS NAT_TRAVEL_FLAG RELOCATE_FLAG EXCLUDED_LOCATION_ID4 WORK_DAYS EXCLUDED_LOCATION_ID2 ACCOMPLISHMENT_TYPE PATENT_ISSUED MIN_SKILL_LEVEL_ID PRIMARY_AUTHOR NEXT_MOVE_DURATION COMPLETED_FLAG MAX_SKILL_LEVEL_ID SKILL_LEVEL_ID EVALUATION_TYPE INTEREST_LEVEL REVIEWER_APPR_FLAG EDUCATION_LEVEL RENEWAL_REQUIRED_FLAG CURRENT_JOB_FLAG EMPLOYER_STATE_ID INTL_TRAVEL_FLAG ALL_LOCATIONS_FLAG PREFERRED_LOCATION_ID4 TECHNICAL_LEVEL WAY_TO_OBTAIN_TITLE MAJOR

Query

SQL_Statement

select SECTION_ID, BUSINESS_GROUP_ID, READING_LEVEL_ID, REQUIRED_FLAG, COUNTRY_CODE, EDU_LEVEL_COMP_FLAG, SUBSCRIPTION_PAY_METH, REQUIREMENT_TYPE, MASTERY_LEVEL_ID, SKILL_CATEGORY, TEMP_ASSIGN_FLAG, WORK_HOURS, PREFERRED_LOCATION_ID3, EXCLUDED_LOCATION_ID3, IMPACT_LEVEL_ID, NEXT_MOVE_JOB_FAMILY, ITEM_TEXT30_6, SPEAKING_LEVEL_ID, PERF_RATING_LEVEL_ID, VERIFIED_FLAG, CURRENT_VOLUNTEER_FLAG, NAT_TRAVEL_REQUIRED_FLAG, READINESS_LEVEL_ID, JOB_FAMILY_ID, READINESS_ADDED_BY, EXCLUDED_LOCATION_ID1, PATENT_PENDING, NEXT_MOVE_LOCATION, CONTENT_ITEM_ID, RATING_INTERACTION_TYPE, GRADUATED_FLAG, TRMNL_DEG_DISCP_FLAG, DURATION_UNITS, RENEWAL_INPROGRESS_FLAG, FLEXIBLE_WORK_FLAG, CURRENCY_CODE, PAY_FREQUENCY, EMPLOYER_COUNTRY_ID, POTENTIAL_LEVEL_ID, GRADUATION_REQUIRED_FLAG, REQUIRED_INTL_TRAVEL_FREQ, REQUIRED_NAT_TRAVEL_FREQ, READINESS_LEVEL, SCORE_LEVEL_ID, NEXT_MOVE_JOB_FUNCTION, BILLABLE_FLAG, ASSIGNMENT_ID, RISK_REASON, CONFIRMATION_STATUS, CATEGORY, ABLE_TO_TEACH_FLAG, MIN_PROF_LEVEL_ID, IMPORTANCE, PROF_RATING_LEVEL_ID, STATE_PROVINCE_CODE, ACADEMIC_STANDING, CONTACT_SUPERVISOR_FLAG, FULL_TIME_CODE, COUNTRY_ID, CURRENT_MEMBERSHIP_REQ_FLAG, AWARD_TYPE, NAT_TRAVEL_FREQUENCY, PREFERRED_LOCATION_ID1, PREFERRED_LOCATION_ID2, READINESS_PROFILE_ID, DEPARTURE_REASON, CONTACT_PERSON_ID, PAY_RANGE, SPECIALITY, NATIVE_SPEAKER_FLAG, MAX_PROF_LEVEL_ID, PART_TIME_FLAG, FEE_CURRENCY, INTERNAL_FLAG, PART_ASSIGN_FLAG, STATE_PROVINCE_ID, SKILL_RECOMMENDATION_TYPE, PLATFORM, ITEM_TEXT30_8, ABLE_TO_TRANSLATE_FLAG, INTL_TRAVEL_FREQUENCY, INTL_TRAVEL_REQUIRED_FLAG, JOB_FUNCTION, RISK_LEVEL_ID, RATING_LEVEL_ID, EST_REMAINING_MONTHS, SKILL_GROUP, NEXT_MOVE_LOCATION2, WRITING_LEVEL_ID, RELATIONSHIP_CODE, REVIEW_ACTIVE_FLAG, EDUCATIONAL_ESTABLISHMENT_ID, STATUS, TUITION_METHOD, HIGHEST_EDU_LEVEL, INTERNAL_ORG_FLAG, SKILL_CURATION_STATUS, NAT_TRAVEL_FLAG, RELOCATE_FLAG, EXCLUDED_LOCATION_ID4, WORK_DAYS, EXCLUDED_LOCATION_ID2, ACCOMPLISHMENT_TYPE, PATENT_ISSUED, MIN_SKILL_LEVEL_ID, PRIMARY_AUTHOR, NEXT_MOVE_DURATION, COMPLETED_FLAG, MAX_SKILL_LEVEL_ID, SKILL_LEVEL_ID, EVALUATION_TYPE, INTEREST_LEVEL, REVIEWER_APPR_FLAG, EDUCATION_LEVEL, RENEWAL_REQUIRED_FLAG, CURRENT_JOB_FLAG, EMPLOYER_STATE_ID, INTL_TRAVEL_FLAG, ALL_LOCATIONS_FLAG, PREFERRED_LOCATION_ID4, TECHNICAL_LEVEL, WAY_TO_OBTAIN_TITLE, MAJOR from (select row_number() OVER ( PARTITION BY section_id,BUSINESS_GROUP_ID order by section_id) as r, SECTION_ID, BUSINESS_GROUP_ID, FIRST_VALUE(case when FIELD_NAME='READING_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as READING_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='REQUIRED_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as REQUIRED_FLAG, FIRST_VALUE(case when FIELD_NAME='COUNTRY_CODE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as COUNTRY_CODE, FIRST_VALUE(case when FIELD_NAME='EDU_LEVEL_COMP_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EDU_LEVEL_COMP_FLAG, FIRST_VALUE(case when FIELD_NAME='SUBSCRIPTION_PAY_METH' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as SUBSCRIPTION_PAY_METH, FIRST_VALUE(case when FIELD_NAME='REQUIREMENT_TYPE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as REQUIREMENT_TYPE, FIRST_VALUE(case when FIELD_NAME='MASTERY_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as MASTERY_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='SKILL_CATEGORY' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as SKILL_CATEGORY, FIRST_VALUE(case when FIELD_NAME='TEMP_ASSIGN_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as TEMP_ASSIGN_FLAG, FIRST_VALUE(case when FIELD_NAME='WORK_HOURS' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as WORK_HOURS, FIRST_VALUE(case when FIELD_NAME='PREFERRED_LOCATION_ID3' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PREFERRED_LOCATION_ID3, FIRST_VALUE(case when FIELD_NAME='EXCLUDED_LOCATION_ID3' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EXCLUDED_LOCATION_ID3, FIRST_VALUE(case when FIELD_NAME='IMPACT_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as IMPACT_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='NEXT_MOVE_JOB_FAMILY' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as NEXT_MOVE_JOB_FAMILY, FIRST_VALUE(case when FIELD_NAME='ITEM_TEXT30_6' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as ITEM_TEXT30_6, FIRST_VALUE(case when FIELD_NAME='SPEAKING_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as SPEAKING_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='PERF_RATING_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PERF_RATING_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='VERIFIED_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as VERIFIED_FLAG, FIRST_VALUE(case when FIELD_NAME='CURRENT_VOLUNTEER_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as CURRENT_VOLUNTEER_FLAG, FIRST_VALUE(case when FIELD_NAME='NAT_TRAVEL_REQUIRED_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as NAT_TRAVEL_REQUIRED_FLAG, FIRST_VALUE(case when FIELD_NAME='READINESS_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as READINESS_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='JOB_FAMILY_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as JOB_FAMILY_ID, FIRST_VALUE(case when FIELD_NAME='READINESS_ADDED_BY' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as READINESS_ADDED_BY, FIRST_VALUE(case when FIELD_NAME='EXCLUDED_LOCATION_ID1' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EXCLUDED_LOCATION_ID1, FIRST_VALUE(case when FIELD_NAME='PATENT_PENDING' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PATENT_PENDING, FIRST_VALUE(case when FIELD_NAME='NEXT_MOVE_LOCATION' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as NEXT_MOVE_LOCATION, FIRST_VALUE(case when FIELD_NAME='CONTENT_ITEM_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as CONTENT_ITEM_ID, FIRST_VALUE(case when FIELD_NAME='RATING_INTERACTION_TYPE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as RATING_INTERACTION_TYPE, FIRST_VALUE(case when FIELD_NAME='GRADUATED_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as GRADUATED_FLAG, FIRST_VALUE(case when FIELD_NAME='TRMNL_DEG_DISCP_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as TRMNL_DEG_DISCP_FLAG, FIRST_VALUE(case when FIELD_NAME='DURATION_UNITS' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as DURATION_UNITS, FIRST_VALUE(case when FIELD_NAME='RENEWAL_INPROGRESS_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as RENEWAL_INPROGRESS_FLAG, FIRST_VALUE(case when FIELD_NAME='FLEXIBLE_WORK_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as FLEXIBLE_WORK_FLAG, FIRST_VALUE(case when FIELD_NAME='CURRENCY_CODE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as CURRENCY_CODE, FIRST_VALUE(case when FIELD_NAME='PAY_FREQUENCY' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PAY_FREQUENCY, FIRST_VALUE(case when FIELD_NAME='EMPLOYER_COUNTRY_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EMPLOYER_COUNTRY_ID, FIRST_VALUE(case when FIELD_NAME='POTENTIAL_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as POTENTIAL_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='GRADUATION_REQUIRED_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as GRADUATION_REQUIRED_FLAG, FIRST_VALUE(case when FIELD_NAME='REQUIRED_INTL_TRAVEL_FREQ' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as REQUIRED_INTL_TRAVEL_FREQ, FIRST_VALUE(case when FIELD_NAME='REQUIRED_NAT_TRAVEL_FREQ' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as REQUIRED_NAT_TRAVEL_FREQ, FIRST_VALUE(case when FIELD_NAME='READINESS_LEVEL' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as READINESS_LEVEL, FIRST_VALUE(case when FIELD_NAME='SCORE_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as SCORE_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='NEXT_MOVE_JOB_FUNCTION' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as NEXT_MOVE_JOB_FUNCTION, FIRST_VALUE(case when FIELD_NAME='BILLABLE_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as BILLABLE_FLAG, FIRST_VALUE(case when FIELD_NAME='ASSIGNMENT_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as ASSIGNMENT_ID, FIRST_VALUE(case when FIELD_NAME='RISK_REASON' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as RISK_REASON, FIRST_VALUE(case when FIELD_NAME='CONFIRMATION_STATUS' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as CONFIRMATION_STATUS, FIRST_VALUE(case when FIELD_NAME='CATEGORY' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as CATEGORY, FIRST_VALUE(case when FIELD_NAME='ABLE_TO_TEACH_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as ABLE_TO_TEACH_FLAG, FIRST_VALUE(case when FIELD_NAME='MIN_PROF_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as MIN_PROF_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='IMPORTANCE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as IMPORTANCE, FIRST_VALUE(case when FIELD_NAME='PROF_RATING_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PROF_RATING_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='STATE_PROVINCE_CODE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as STATE_PROVINCE_CODE, FIRST_VALUE(case when FIELD_NAME='ACADEMIC_STANDING' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as ACADEMIC_STANDING, FIRST_VALUE(case when FIELD_NAME='CONTACT_SUPERVISOR_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as CONTACT_SUPERVISOR_FLAG, FIRST_VALUE(case when FIELD_NAME='FULL_TIME_CODE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as FULL_TIME_CODE, FIRST_VALUE(case when FIELD_NAME='COUNTRY_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as COUNTRY_ID, FIRST_VALUE(case when FIELD_NAME='CURRENT_MEMBERSHIP_REQ_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as CURRENT_MEMBERSHIP_REQ_FLAG, FIRST_VALUE(case when FIELD_NAME='AWARD_TYPE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as AWARD_TYPE, FIRST_VALUE(case when FIELD_NAME='NAT_TRAVEL_FREQUENCY' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as NAT_TRAVEL_FREQUENCY, FIRST_VALUE(case when FIELD_NAME='PREFERRED_LOCATION_ID1' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PREFERRED_LOCATION_ID1, FIRST_VALUE(case when FIELD_NAME='PREFERRED_LOCATION_ID2' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PREFERRED_LOCATION_ID2, FIRST_VALUE(case when FIELD_NAME='READINESS_PROFILE_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as READINESS_PROFILE_ID, FIRST_VALUE(case when FIELD_NAME='DEPARTURE_REASON' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as DEPARTURE_REASON, FIRST_VALUE(case when FIELD_NAME='CONTACT_PERSON_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as CONTACT_PERSON_ID, FIRST_VALUE(case when FIELD_NAME='PAY_RANGE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PAY_RANGE, FIRST_VALUE(case when FIELD_NAME='SPECIALITY' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as SPECIALITY, FIRST_VALUE(case when FIELD_NAME='NATIVE_SPEAKER_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as NATIVE_SPEAKER_FLAG, FIRST_VALUE(case when FIELD_NAME='MAX_PROF_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as MAX_PROF_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='PART_TIME_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PART_TIME_FLAG, FIRST_VALUE(case when FIELD_NAME='FEE_CURRENCY' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as FEE_CURRENCY, FIRST_VALUE(case when FIELD_NAME='INTERNAL_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as INTERNAL_FLAG, FIRST_VALUE(case when FIELD_NAME='PART_ASSIGN_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PART_ASSIGN_FLAG, FIRST_VALUE(case when FIELD_NAME='STATE_PROVINCE_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as STATE_PROVINCE_ID, FIRST_VALUE(case when FIELD_NAME='SKILL_RECOMMENDATION_TYPE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as SKILL_RECOMMENDATION_TYPE, FIRST_VALUE(case when FIELD_NAME='PLATFORM' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PLATFORM, FIRST_VALUE(case when FIELD_NAME='ITEM_TEXT30_8' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as ITEM_TEXT30_8, FIRST_VALUE(case when FIELD_NAME='ABLE_TO_TRANSLATE_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as ABLE_TO_TRANSLATE_FLAG, FIRST_VALUE(case when FIELD_NAME='INTL_TRAVEL_FREQUENCY' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as INTL_TRAVEL_FREQUENCY, FIRST_VALUE(case when FIELD_NAME='INTL_TRAVEL_REQUIRED_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as INTL_TRAVEL_REQUIRED_FLAG, FIRST_VALUE(case when FIELD_NAME='JOB_FUNCTION' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as JOB_FUNCTION, FIRST_VALUE(case when FIELD_NAME='RISK_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as RISK_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='RATING_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as RATING_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='EST_REMAINING_MONTHS' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EST_REMAINING_MONTHS, FIRST_VALUE(case when FIELD_NAME='SKILL_GROUP' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as SKILL_GROUP, FIRST_VALUE(case when FIELD_NAME='NEXT_MOVE_LOCATION2' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as NEXT_MOVE_LOCATION2, FIRST_VALUE(case when FIELD_NAME='WRITING_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as WRITING_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='RELATIONSHIP_CODE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as RELATIONSHIP_CODE, FIRST_VALUE(case when FIELD_NAME='REVIEW_ACTIVE_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as REVIEW_ACTIVE_FLAG, FIRST_VALUE(case when FIELD_NAME='EDUCATIONAL_ESTABLISHMENT_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EDUCATIONAL_ESTABLISHMENT_ID, FIRST_VALUE(case when FIELD_NAME='STATUS' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as STATUS, FIRST_VALUE(case when FIELD_NAME='TUITION_METHOD' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as TUITION_METHOD, FIRST_VALUE(case when FIELD_NAME='HIGHEST_EDU_LEVEL' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as HIGHEST_EDU_LEVEL, FIRST_VALUE(case when FIELD_NAME='INTERNAL_ORG_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as INTERNAL_ORG_FLAG, FIRST_VALUE(case when FIELD_NAME='SKILL_CURATION_STATUS' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as SKILL_CURATION_STATUS, FIRST_VALUE(case when FIELD_NAME='NAT_TRAVEL_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as NAT_TRAVEL_FLAG, FIRST_VALUE(case when FIELD_NAME='RELOCATE_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as RELOCATE_FLAG, FIRST_VALUE(case when FIELD_NAME='EXCLUDED_LOCATION_ID4' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EXCLUDED_LOCATION_ID4, FIRST_VALUE(case when FIELD_NAME='WORK_DAYS' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as WORK_DAYS, FIRST_VALUE(case when FIELD_NAME='EXCLUDED_LOCATION_ID2' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EXCLUDED_LOCATION_ID2, FIRST_VALUE(case when FIELD_NAME='ACCOMPLISHMENT_TYPE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as ACCOMPLISHMENT_TYPE, FIRST_VALUE(case when FIELD_NAME='PATENT_ISSUED' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PATENT_ISSUED, FIRST_VALUE(case when FIELD_NAME='MIN_SKILL_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as MIN_SKILL_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='PRIMARY_AUTHOR' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PRIMARY_AUTHOR, FIRST_VALUE(case when FIELD_NAME='NEXT_MOVE_DURATION' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as NEXT_MOVE_DURATION, FIRST_VALUE(case when FIELD_NAME='COMPLETED_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as COMPLETED_FLAG, FIRST_VALUE(case when FIELD_NAME='MAX_SKILL_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as MAX_SKILL_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='SKILL_LEVEL_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as SKILL_LEVEL_ID, FIRST_VALUE(case when FIELD_NAME='EVALUATION_TYPE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EVALUATION_TYPE, FIRST_VALUE(case when FIELD_NAME='INTEREST_LEVEL' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as INTEREST_LEVEL, FIRST_VALUE(case when FIELD_NAME='REVIEWER_APPR_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as REVIEWER_APPR_FLAG, FIRST_VALUE(case when FIELD_NAME='EDUCATION_LEVEL' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EDUCATION_LEVEL, FIRST_VALUE(case when FIELD_NAME='RENEWAL_REQUIRED_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as RENEWAL_REQUIRED_FLAG, FIRST_VALUE(case when FIELD_NAME='CURRENT_JOB_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as CURRENT_JOB_FLAG, FIRST_VALUE(case when FIELD_NAME='EMPLOYER_STATE_ID' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as EMPLOYER_STATE_ID, FIRST_VALUE(case when FIELD_NAME='INTL_TRAVEL_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as INTL_TRAVEL_FLAG, FIRST_VALUE(case when FIELD_NAME='ALL_LOCATIONS_FLAG' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as ALL_LOCATIONS_FLAG, FIRST_VALUE(case when FIELD_NAME='PREFERRED_LOCATION_ID4' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as PREFERRED_LOCATION_ID4, FIRST_VALUE(case when FIELD_NAME='TECHNICAL_LEVEL' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as TECHNICAL_LEVEL, FIRST_VALUE(case when FIELD_NAME='WAY_TO_OBTAIN_TITLE' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as WAY_TO_OBTAIN_TITLE, FIRST_VALUE(case when FIELD_NAME='MAJOR' then VALUE_SET_NAME end IGNORE NULLS) OVER ( PARTITION BY SECTION_ID,BUSINESS_GROUP_ID ) as MAJOR from (select SECTION_ID,BUSINESS_GROUP_ID,VALUE_SET_NAME,FIELD_NAME from hrt_profile_tp_sc_prp_b where source_code is null)) prp where prp.r=1