Faull domain - is logical grping ofhardware and infra within an AD designed to provide isolkation from hardware failures
fault isolation
3 separate FD
automatic distribution
- Custom placement
no netwrok latency
-- BB as % of HR TI TO_CHAR( CASE WHEN NVL(parDetails.PD_HR_TI, 0) = 0 THEN 0 ELSE ( TO_NUMBER( CASE WHEN MC_FLAGS.BBMultiCurrencyFlag = 'Y' THEN BB_AMT.BB_IN_LATEST_HC ELSE TO_CHAR( NVL( SUM( CASE WHEN BP.PAY_PERIOD_ID BP.PAY_DATE THEN BP.PAY_AMT_PAY_CURR ELSE 0 END ), 0 ), 'FM9999999990.0000' ) END ...
FROM BG -- **NEW JOIN: Add PARTICIPANT_DUAL_SNAPSHOT** LEFT JOIN PARTICIPANT_DUAL_SNAPSHOT DUAL_SNAP ON DUAL_SNAP.PAYRUN_ID = BG.PAYRUN_ID AND DUAL_SNAP.CREDITED_PARTICIPANT_ID = BG.CREDITED_PARTICIPANT_ID AND DUAL_SNAP.ORG_ID = BG.ORG_ID -- Person Numbers LEFT JOIN PERSON_NUMBERS PN ON PN.participant_id = BG.CREDITED_PARTICIPANT_ID -- Latest Plan Component LEFT JOIN LATEST_PLAN_COMPONENT LPC ON LPC.PARTICIPANT_ID = BG.CREDITED_PARTICIPANT_ID AND LPC.ORG_ID = BG.ORG_ID AND LPC.PERIOD_ID = BG.PAY_PERIOD_ID AND LPC.PAYRUN_ID = BG.PAYRUN_ID -- Calendar LEFT JOIN PAY_CAL ON PAY_CAL.PAYMENT_BATCH_NAME = UPPER(BG.PAYRUN_NAME) AND PAY_CAL.PAYGROUP_NAME = UPPER(BG.PAY_GROUP_NAME) AND PAY_CAL.PERIOD_ID = BG.PAY_PERIOD_ID AND PAY_CAL.CURRENCY_CODE = BG.LAT...
-- Beginning Balance (BB) fields CASE WHEN MC_FLAGS.BBMultiCurrencyFlag = 'Y' THEN BB_AMT.BB_IN_LATEST_HC ELSE TO_CHAR( NVL( SUM( CASE WHEN BP.PAY_PERIOD_ID BP.PAY_DATE THEN BP.PAY_AMT_PAY_CURR ELSE 0 END ), 0 ), 'FM9999999990.0000' ) END AS BeginningBalance_c, -- BB in USD CASE WHEN MC_FLAGS.BBMultiCurrencyFlag = 'Y' THEN BB_AMT.BB_IN_USD ELSE TO_CHAR( NVL( SUM( CASE WHEN BP.PAY_PERIOD_ID BP.PAY_DATE THEN BP.PAY_AMT_PAY_CURR * ...
Comments
Post a Comment