Spreadsheet: kam_keiser__18069__Summary of Book Requests Update for Canada
Sheet: Sheet1

 | From: | Risk Management -Controls |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
 |  | (Mailbox= Risk Analytics)
 | Subject: | New Book Request # _____________________  (Risk Analytics Use) |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | System: | ERMS
 | Requestor:  [NAME]
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  |  | Type Of Transactions |  |  | Book Mapping
 | Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM or ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
167038 | FB-Canada1 | Canadian Financial Book 1 |  |  | X | ML | CanF1 | X | X | X |  |  |  | NGGJ/GJ/CAD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167048 | FB-Canada2 | Canadian Financial Book 2 |  |  | X | ML | CanF2 | X | X | X |  |  |  | NGGJ/GJ/CAD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167050 | FB-Canada3 | Canadian Financial Book 3 |  |  | X | ML | CanF3 | X | X | X |  |  |  | NGGJ/GJ/CAD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167051 | FB-Canada4 | Canadian Financial Book 4 |  |  | X | ML | CanF4 | X | X | X |  |  |  | NGGJ/GJ/CAD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167052 | FB-Canada5 | Canadian Financial Book 5 |  |  | X | ML | CanF5 | X | X | X |  |  |  | NGGJ/GJ/CAD | Lon Draper | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167053 | GDB-Canada1 | Canadian Gas Daily Book 1 |  |  | X | MT | CanGD1 |  |  |  | X |  | X | NG/MMBTU/USD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167055 | GDB-Canada2 | Canadian Gas Daily Book 2 |  |  | X | MT | CanGD2 |  |  |  | X |  | X | NG/MMBTU/USD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167056 | GDB-Canada3 | Canadian Gas Daily Book 3 |  |  | X | MT | CanGD3 |  |  |  | X |  | X | NG/MMBTU/USD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167057 | GDB-Canada4 | Canadian Gas Daily Book 4 |  |  | X | MT | CanGD4 |  |  |  | X |  | X | NG/MMBTU/USD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167058 | GDB-Canada5 | Canadian Gas Daily Book 5 |  |  | X | MT | CanGD5 |  |  |  | X |  | X | NG/MMBTU/USD | Lon Draper | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167059 | FB-USCOUNTER | Cdn Book for Deals with US Counterparties |  |  | X | ML | CanUS1 | X | X |  |  |  |  | NGGJ/GJ/CAD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167061 | FB-CDNCOUNTER | US Book for Deals with Cdn Counterparties |  |  | X | MR | [NAME] | X | X |  |  |  |  | NG/MMBTU/USD |  | MTM | new company | 2002-01-14 00:00:00 | US logic
167063 | IB-AB-Canada | Canadian Alberta Intramonth Book |  |  | X | MM | CanAlb |  |  |  |  | X |  | NGGJ/GJ/CAD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
167064 | IB-BC-Canada | Canadian BC Intramonth Book |  |  | X | MM | CanBC |  |  |  |  | X |  | NGGJ/GJ/CAD | [NAME] | MTM | new company | 2002-01-14 00:00:00 | Cdn logic
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
 | *A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
 | BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Risk Analytics Use Only:
 | ***Please provide login names for book administrators.*** |  |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC
 | IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | Hierarchy
 | Access List | Administrator* |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP
 | Canadian Gas Desk | bgillis |  |  |  |  |  |  |  |  |  |  |  | Created in TAGG/ERMS
 | Canadian Power Desk |  |  |  |  |  |  |  |  |  |  |  |  | Cross-Commodity DBA
 | cdawes
 | dhanslip |  |  |  |  |  |  |  |  |  |  |  |  | Real Portfolio Name:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HIERARCHY: | EXCEPTIONS | Added (Y/N) | Processors ID
 |  |  |  |  |  |  |  |  |  |  |  |  | ALL: | AGG-CREDIT | London Books
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-BU | Accrual/Index/Joint Venture
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-CM | Accrual/Index/Joint Venture
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DISCOUNTING USD | En-Power
 |  |  |  |  |  |  |  |  |  |  |  |  | IF: | Index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-INDEX
 |  |  |  |  |  |  |  |  |  |  |  |  |  | GDI
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GD-INDEX
 |  |  |  |  |  |  |  |  |  |  |  |  | IF: | Gas
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GAS III & IV
 |  |  |  |  |  |  |  |  |  |  |  |  | IF: | Power:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PWR IV & V
 | COMMENTS:
 |  |  |  |  |  |  |  |  |  |  | New Hierarchy: |  |  | AGG-TEST-BU
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AGG-TEST-CM