fianl bb selection
SELECT
BG.PAYRUN_ID,
BG.PAYMENT_BATCH_PERIOD,
BG.PAYEE_PARTICIPANT_ID,
-- BB columns
BB_AMT.OLD_PAY_PERIOD_IDS AS "BB Old Pay Period IDs",
BB_AMT.BB_HOME_CURRENCIES AS "BB Home Currencies",
BB_AMT.BB_BREAKDOWN_BY_CURRENCY AS "BB Breakdown by Currency",
BB_AMT.BB_IN_LATEST_HC AS "BB in Latest Home Currency",
BB_AMT.LATEST_HOME_CURRENCY AS "BB Latest Home Currency",
BB_AMT.BB_CONVERSION_RATE_AVG AS "BB Avg Conversion Rate",
-- PTD columns (if needed)
PTD_EARNINGS_AMT.PTD_IN_LATEST_HC AS "PTD in Latest Home Currency",
PTD_EARNINGS_AMT.LATEST_HOME_CURRENCY AS "PTD Latest Home Currency"
FROM your_base_query BG
LEFT JOIN BB_AMT
ON BB_AMT.CREDITED_PARTICIPANT_ID = BG.PAYEE_PARTICIPANT_ID
AND BB_AMT.PAY_PERIOD_ID = BG.PAYMENT_BATCH_PERIOD
AND BB_AMT.PAYRUN_ID = BG.PAYRUN_ID
LEFT JOIN PTD_EARNINGS_AMT
ON PTD_EARNINGS_AMT.CREDITED_PARTICIPANT_ID = BG.PAYEE_PARTICIPANT_ID
AND PTD_EARNINGS_AMT.PAY_PERIOD_ID = BG.PAYMENT_BATCH_PERIOD
AND PTD_EARNINGS_AMT.PAYRUN_ID = BG.PAYRUN_ID
Comments
Post a Comment