Country transffer
SELECT
PART_DTLS.PARTICIPANT_ID "PARTICIPANT_ID",
PART_HDR.PARTICIPANT_NAME PARTICIPANT_NAME,
-- PART_DTLS.PARTICIPANT_DETAIL_ID "PARTICIPANT_DETAIL_ID",
-- PART_DTLS.ORG_ID "ORG_ID",
-- PART_DTLS.START_DATE "START_DATE",
-- PART_DTLS.END_DATE "END_DATE",
-- PART_DTLS.COUNTRY_CODE HR_Country,
-- PART_DTLS.ATTRIBUTE_CHAR40 Employment_Country,
-- PART_DTLS.ATTRIBUTE_NUMBER1 "HR_TI",
-- PART_DTLS.CURRENCY_CODE "HOME_CURRENCY",
-- PART_DTLS.ATTRIBUTE_CHAR2 HR_Status,
-- PART_DTLS.ATTRIBUTE_CHAR17 SalesRep,
-- PART_DTLS.ATTRIBUTE_CHAR33 ActionCode,
cpb.period_id
FROM CN_SRP_PARTICIPANT_DETAILS_ALL PART_DTLS
JOIN CN_SRP_PARTICIPANTS_ALL PART_HDR
ON PART_DTLS.PARTICIPANT_ID = PART_HDR.PARTICIPANT_ID
AND PART_DTLS.ORG_ID = PART_HDR.ORG_ID
JOIN CN_PERIODS_B CPB
on CPB.START_DATE >= PART_DTLS.START_DATE
and CPB.START_DATE <= PART_DTLS.END_DATE
--and PART_HDR.participant_id = 300000472439641
group by cpb.period_id
, PART_HDR.PARTICIPANT_NAME
, PART_DTLS.PARTICIPANT_ID
having count(1) > 1
Comments
Post a Comment