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

Popular posts from this blog

Child query new

child query latest -

final simple where