CONFIRMATIONS Levels of Confirmation Working Example for BPS
CONFIRMATIONS Levels of Confirmation Working Example for BPS discussion
Point of view for discussion Upstream Pipe Downstream Pipe Location
Base Example Sample Data for Confirmations examples Base Data Set Upstream Pipe transactions SR SRK Dn Pty Dn K Dn Pkg ID Qty A A A A A B B A 1 A 1 A 2 A 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 2 987 876 765 654 543 432 321321 8787 9898 909 5454 2121 Pkg ID 123 blue 234 blue 345 blue 456 blue 567 red 123123 red 234234 red 2323 blue 3434 blue 4545 red 1212 blue 6565 red Downstream Pipe Transactions 100 100 100 SR SRK blue red red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 Pkg ID Up Pty 987 A 876 A 765 A 654 A 543 A 432 A 321321 A 8787 A 9898 A 909 A 5454 B 2121 B Up K Up Pkg ID Qty A 1 A 1 A 1 A 2 A 2 B 2 B 1 123 234 345 456 567 1234 234234 2323 3434 45454 12121 6565 100 100 100
First Level – One Party Upstream Party or Downstream Party • If Downstream Pipe is requesting the confirmation Then Downstream pipe provides the downstream party and requested quantity information to the upstream pipe • Upstream Pipe confirms the quantities at the requested level • Upstream pipe matches the downstream parties and quantities to the downstream parties listed for the shippers on Upstream pipe. • After confirming, Upstream pipe uses the confirmed quantities to schedule upstream pipe. • If there any reductions, upstream pipe uses its contract priorities and ranks to determine the cuts • • The parties selected for cut by Upstream Pipe are now used by Downstream Pipe to make corresponding cuts • Downstream Pipe cuts will use the tariff terms and shipper ranks for determining which transactions are cut.
First level – One Party First Level - One Party Base Data Set Upstream Pipe transactions SR SRK Dn Pty Dn K Dn Pkg ID Qty A A A A A B B A 1 A 1 A 2 A 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 2 987 876 765 654 543 432 321321 8787 9898 909 5454 2121 Pkg ID 123 blue 234 blue 345 blue 456 blue 567 red 123123 red 234234 red 2323 blue 3434 blue 4545 red 1212 blue 6565 red Downstream Pipe Transactions 100 100 100 SR SRK blue red red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 Pkg ID Up Pty 987 A 876 A 765 A 654 A 543 A 432 A 321321 A 8787 A 9898 A 909 A 5454 B 2121 B Up K Up Pkg ID Qty A 1 A 1 A 1 A 2 A 2 B 2 B 1 123 234 345 456 567 1234 234234 2323 3434 45454 12121 6565 REQUESTED INFO SR 100 blue 100 red 100 100 100 Qty 700 500
First level – One Party Matches? Party Quantities Match! How to determine which of blue goes to A/B? And Red to A/B? What pipeline rules solve this? First Level - One Party Base Data Set Upstream Pipe transactions SR SRK Dn Pty Dn K Dn Pkg ID Qty A A A A A B B A 1 A 1 A 2 A 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 2 987 876 765 654 543 432 321321 8787 9898 909 5454 2121 Pkg ID 123 blue 234 blue 345 blue 456 blue 567 red 123123 red 234234 red 2323 blue 3434 blue 4545 red 1212 blue 6565 red Downstream Pipe Transactions 100 100 100 SR SRK blue red red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 Pkg ID Up Pty 987 A 876 A 765 A 654 A 543 A 432 A 321321 A 8787 A 9898 A 909 A 5454 B 2121 B Up K Up Pkg ID Qty A 1 A 1 A 1 A 2 A 2 B 2 B 1 123 234 345 456 567 1234 234234 2323 3434 45454 12121 6565 REQUESTED INFO SR 100 blue 100 red 100 100 100 Qty 700 500
Pipeline rule solutions • If blue is delivering to A and B then is first pipeline rule to fill the firm contracts of both A and B first and then fill the IT? • Or is there some other rule that applies?
Second Level – Two Parties Upstream Party and Downstream Party • If Downstream Pipe is requesting the confirmation • Then Downstream pipe provides the upstream party/downstream party combination and requested quantity for each combination to the upstream pipe • • Downstream pipe determines this by summarizing the nominations at the confirmation location to this level of detail Upstream Pipe confirms the quantities at the requested level Upstream pipe matches the upstream/downstream parties combinations and quantities to the summarized upstream/downstream parties listed for the shippers on Upstream pipe. • After confirming, Upstream pipe uses the confirmed quantities to schedule upstream pipe. • If there any reductions, upstream pipe uses its contract priorities and ranks to determine the cuts within the upstream/downstream shipper combination • • The parties selected for cut by Upstream Pipe are now used by Downstream Pipe to make corresponding cuts • Downstream Pipe cuts will use the tariff terms and shipper ranks for determining which transactions are cut.
Second Level - Two Parties Base Data Set Upstream Pipe transactions SR SRK Dn Pty Dn K Dn Pkg ID Qty A A A A A B B A 1 A 1 A 2 A 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 2 987 876 765 654 543 432 321321 8787 9898 909 5454 2121 Pkg ID 123 blue 234 blue 345 blue 456 blue 567 red 123123 red 234234 red 2323 blue 3434 blue 4545 red 1212 blue 6565 red Downstream Pipe Transactions 100 100 100 SR SRK blue red red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 Pkg ID Up Pty 987 A 876 A 765 A 654 A 543 A 432 A 321321 A 8787 A 9898 A 909 A 5454 B 2121 B Up K Up Pkg ID Qty A 1 A 1 A 1 A 2 A 2 B 2 B 1 123 234 345 456 567 1234 234234 2323 3434 45454 12121 6565 REQUESTED INFO Up Pty 100 A 100 B 100 100 Dn Pty Blue Red Qty 600 400 100
Second Level - Two Parties Matches? All Party Quantities Match! Second Level - Two Parties Base Data Set Upstream Pipe transactions SR SRK Dn Pty Dn K Dn Pkg ID Qty A A A A A B B A 1 A 1 A 2 A 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 2 987 876 765 654 543 432 321321 8787 9898 909 5454 2121 Pkg ID 123 blue 234 blue 345 blue 456 blue 567 red 123123 red 234234 red 2323 blue 3434 blue 4545 red 1212 blue 6565 red Downstream Pipe Transactions 100 100 100 SR SRK blue red red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 Pkg ID Up Pty 987 A 876 A 765 A 654 A 543 A 432 A 321321 A 8787 A 9898 A 909 A 5454 B 2121 B Up K Up Pkg ID Qty A 1 A 1 A 1 A 2 A 2 B 2 B 1 123 234 345 456 567 1234 234234 2323 3434 45454 12121 6565 REQUESTED INFO Up Pty 100 A 100 B 100 100 Dn Pty Blue Red Qty 600 400 100
Second Level • Now pipeline looks at all of the contracts nominated for A/Blue and determines which contract to fill first (Firm, IT, other rules) • Then pipeline looks at all of the nominations related to the first contract filled and uses shipper provided ranks to determine which to fill first.
Third Level – Two contracts Up Party + Up Contract and Down Party + Down Contract • If Downstream Pipe is requesting the confirmation • Then Downstream pipe provides the up party + up contract/down party + down contract combination and requested quantity for each combination to the upstream pipe • • Downstream pipe determines this by summarizing the nominations at the confirmation location to this level of detail Upstream Pipe confirms the quantities at the requested level Upstream pipe matches the up party + up contract/down party + down contract combinations and quantities to the same summarized level listed for the transactions on Upstream pipe. • After confirming, Upstream pipe uses the confirmed quantities to schedule upstream pipe. • If there any reductions, upstream pipe uses its contract priorities and ranks to determine the cuts within the up party + up contract/down party + down contract combination • • The contracts selected for cut by Upstream Pipe are now used by Downstream Pipe to make corresponding cuts • Downstream Pipe cuts may be to firm contracts selected by Upstream Pipe processes
Third Level – Two Contracts Base Data Set Upstream Pipe transactions SR SRK Dn Pty Dn K Dn Pkg ID Qty A A A A A B B A 1 A 1 A 2 A 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 2 987 876 765 654 543 432 321321 8787 9898 909 5454 2121 Pkg ID 123 blue 234 blue 345 blue 456 blue 567 red 123123 red 234234 red 2323 blue 3434 blue 4545 red 1212 blue 6565 red Downstream Pipe Transactions 100 100 100 SR SRK blue red red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 Pkg ID Up Pty 987 A 876 A 765 A 654 A 543 A 432 A 321321 A 8787 A 9898 A 909 A 5454 B 2121 B Up K Up Pkg ID Qty A 1 A 1 A 1 A 2 A 2 B 2 B 1 123 234 345 456 567 1234 234234 2323 3434 45454 12121 6565 REQUESTED INFO Up Pty Qty 100 A 100 A 100 B 100 Up K Dn Pty Dn K A 1 A 1 A 2 A 2 B 2 B 1 Blue blue red red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 200 100 100
Third Level – Two Contracts Matches? Base Data Set Upstream Pipe transactions SR SRK Dn Pty Dn K Dn Pkg ID Qty A A A A A B B A 1 A 1 A 2 A 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 2 987 876 765 654 543 432 321321 8787 9898 909 5454 2121 Pkg ID 123 blue 234 blue 345 blue 456 blue 567 red 123123 red 234234 red 2323 blue 3434 blue 4545 red 1212 blue 6565 red Downstream Pipe Transactions 100 100 100 SR SRK blue red red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 Pkg ID Up Pty 987 A 876 A 765 A 654 A 543 A 432 A 321321 A 8787 A 9898 A 909 A 5454 B 2121 B Up K Up Pkg ID Qty A 1 A 1 A 1 A 2 A 2 B 2 B 1 123 234 345 456 567 1234 234234 2323 3434 45454 12121 6565 REQUESTED INFO Up Pty Qty 100 A 100 A 100 B 100 Up K Dn Pty Dn K A 1 A 1 A 2 A 2 B 2 B 1 Blue blue red red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 200 100 100
Third Level • Since confirming party has determined the quantity for each contract, then the pipeline’s rules of filling the firm transportation first will not apply.
Fourth– Two package IDs Up Party + Up Contract + Up Package and Down Party + Down Contract + Down Package • If Downstream Pipe is requesting the confirmation • Then Downstream pipe provides the up party + up contract + up package/down party + down contract + down package combination and requested quantity for each combination to the upstream pipe • • Downstream pipe determines this by summarizing the nominations at the confirmation location to this level of detail Upstream Pipe confirms the quantities at the requested level Upstream pipe matches the up party + up contract + up package/down party + down contract + down package combinations and quantities to the same summarized level listed for the transactions on Upstream pipe. • After confirming, Upstream pipe uses the confirmed quantities to schedule upstream pipe. • If there any reductions, upstream pipe uses its contract priorities and ranks to determine the cuts within the up party + up contract + up package/down party + down contract + down package combination • • The line items selected for cut by Upstream Pipe are now used by Downstream Pipe to make corresponding cuts • Only transactions where the package ID matches or there is no package id (therefore null matches) are confirmed
Fourth Level – Two Package IDs Base Data Set Upstream Pipe transactions SR SRK Dn Pty Dn K Dn Pkg ID Qty A A A A A B B A 1 A 1 A 2 A 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 2 987 876 765 654 543 432 321321 8787 9898 909 5454 2121 Pkg ID 123 blue 234 blue 345 blue 456 blue 567 red 123123 red 234234 red 2323 blue 3434 blue 4545 red 1212 blue 6565 red 100 100 100 Downstream Pipe Transactions Requested Info: SR SRK Pkg ID Up Pty Up K blue red red blue red A 1 A 1 A 1 A 2 A 2 B 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 987 A 876 A 765 A 654 A 543 A 432 A 321321 A 8787 A 9898 A 909 A 5454 B 2121 B Up Pkg ID Qty 123 234 345 456 567 1234 234234 2323 3434 45454 12121 6565 100 100 100
Fourth Level – Two Package IDs Matches? Base Data Set Upstream Pipe transactions SR SRK Dn Pty Dn K Dn Pkg ID Qty A A A A A B B A 1 A 1 A 2 A 2 B 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 2 987 876 765 654 543 432 321321 8787 9898 909 5454 2121 Pkg ID 123 blue 234 blue 345 blue 456 blue 567 red 123123 red 234234 red 2323 blue 3434 blue 4545 red 1212 blue 6565 red Downstream Pipe Transactions Requested Info: SR SRK Pkg ID Up Pty 100 blue 100 red 100 XXXXXXXX red 100 blue 100 XXXX red 100 XXXX blue 100 XXXX red blue 1 blue 2 red 1 red 2 blue 1 blue 2 red 1 blue 1 red 1 987 A 876 A 765 A 654 A 543 A 432 A 321321 A 8787 A 9898 A 909 A 5454 B 2121 B Up K A 1 A 1 A 1 A 2 A 2 B 2 B 1 Up Pkg ID Qty 123 234 345 456 567 1234 234234 2323 3434 45454 12121 6565 100 100 100
Fourth Level • Since the confirming party has confirmed at the package ID level, in most cases, the quantity is applied at the nomination level. If the shipper did not provide a package id then there may be summarized nomination quantities and the ranks may be used. Or, if one side provided package id’s and the other side did not, then the quantity may be cut.
- Slides: 19