Spreadsheet: chris_stokley__3969__Power DB Field Requirements
Sheet: Field Requirements

Power Database Requirements
 |  | Calculated Field | Global Counter Party | Global Facility | Global Contracts | Deal Capture - Risk | Site Profile Database | Deal Capture/ Operations | Legal | Credit | Structuring | Site Profile | Booking | 30 day Deal List | OMS | DASH | Total | Provider | Same Requirements as Matrix?
1 | Company's correct legal name and address |  | X |  |  |  |  | X | X | X | X |  | X | X |  |  |  |  | Y
2 | Index or Fixed Price |  |  |  |  | X |  | X | X | X | X |  | X | X |  |  |  |  | Y
 | Agent Fees |  |  |  |  | X
 | Adder/Multiplier |  |  |  |  | X
5 | Contract/Deal Type (e.g.Mid Form, Master Form, GNO) |  |  |  | X | X |  | X | X | X | X |  | X | X |  |  |  |  | Y
3 | Deal Start Date |  |  |  |  | X |  | X | X | X | X |  | X |  |  |  |  |  | Y
4 | Deal End Date |  |  |  |  | X |  | X | X | X | X |  | X |  |  |  |  |  | Y
6 | Originator (Name, Phone, [NAME], Fax) |  |  |  |  | X |  | X |  | X | X |  | X | X |  |  |  |  | Y
7 | Current utility for each account |  |  |  |  |  | X | X | X |  | X | X |  | X |  |  |  |  | Y
8 | Deal Close Date |  |  |  |  | X |  | X | X |  | X |  | X |  |  |  |  |  | Y
9 | Term (in months) | X |  |  |  |  |  | X | X |  | X |  | X |  |  |  |  |  | Y
10 | Structure of Deal (e.g. discount, fixed price) |  |  |  |  |  |  | X | X | X | X |  |  |  |  |  |  |  | Y
12 | Deal Components (power, gas, projects, FM, etc.) |  |  |  |  | X |  | X |  | X | X | X |  |  |  |  |  |  | Y
14 | Utility Rate Schedule |  |  |  |  |  | X | X | X |  | X | X |  |  |  |  |  |  | Y
17 | Credit Approved? (Yes or No with E-Rating) |  |  |  |  |  |  | X |  |  | X |  | X | X |  |  |  |  | Y
20 | Facilities Name and Address |  |  |  |  |  | X | X | X |  | X | X |  |  |  |  |  |  | Y
21 | Account Numbers (Aggregation of Services Provided to Counterparty) |  |  |  |  |  | X | X | X |  | X | X |  |  |  |  |  |  | Y
11 | GCP ID |  | X |  |  |  |  | X |  |  |  | X | X |  |  |  |  |  | Y
13 | State |  |  |  |  |  | X | X | X |  | X |  |  |  |  |  |  |  | Y
15 | Total number of accounts |  |  |  |  |  |  | X |  |  | X |  |  | X |  |  |  |  | Y
16 | Potential Credit Exposure (33% Total Contract Revenue + 3 months A/R) |  |  |  |  |  |  |  |  | X |  |  | X | X |  |  |  |  | Y
19 | Notional or Executable Price |  |  |  |  |  |  | X | X |  | X
22 | Current Date |  |  |  |  |  |  | X |  | X |  |  | X |  |  |  |  |  | Y
23 | Previous 12 months consumption (broken down by month) - Needed for Load Bands |  |  |  |  |  | X | X |  |  | X | X |  |  |  |  |  |  | Y
38 | Invoice Address |  | X |  |  |  |  | X | X |  | X |  |  |  |  |  |  |  | Y
39 | [NAME] |  |  |  |  |  | X | X | X |  | X |  |  |  |  |  |  |  | Y
40 | Billing Name & Address (if different that facility name and address) |  | X |  |  |  |  | X | X |  | X |  |  |  |  |  |  |  | Y
47 | Facility Type Code |  |  |  |  |  | X | X |  |  | X | X |  |  |  |  |  |  | Y
48 | Heating Type (Gas/Electric) |  |  |  |  |  | X | X |  |  | X | X |  |  |  |  |  |  | Y
63 | [NAME] or Bundled - Derived Field (Utility or Direct Access Counterparty) |  |  |  |  |  |  | X |  |  | X |  |  | X |  |  |  |  | Y
18 | Which accounts/meters are serviced and which are passthrough |  |  |  |  | X | X | X |  |  | X
24 | Previous 12 months demand (broken down by month) |  |  |  |  |  | X |  |  |  | X | X |  |  |  |  |  |  | Y
25 | Previous 12 months cost (broken down by month) |  |  |  |  |  | X |  |  |  | X | X |  |  |  |  |  |  | Y
26 | Business Description |  | X |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  | Y
27 | Structurer |  |  |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | Y
28 | Executable Pricing by what date |  |  |  |  |  |  |  |  |  | X |  |  | X
29 | Credit Comments |  |  |  |  |  |  |  |  | X |  |  |  | X |  |  |  |  | Y
31 | Physical or Financial (If there will be a switch, indicate date) |  |  |  |  | X |  | X |  |  | X |  |  |  |  |  |  |  | Y
32 | [NAME] |  |  |  |  | X |  | X |  |  | X |  |  |  |  |  |  |  | Y
 | Lower Band |  |  |  |  | X
 | Contract Optionality |  |  |  |  | X
33 | Operational Change (formerly Material Change - percentage and calculation frequency) |  |  |  |  |  |  | X |  |  | X |  |  |  |  |  |  |  | Y
34 | Baseline (yes or no, if yes - what is it) |  |  |  |  |  | X | X |  |  | X |  |  |  |  |  |  |  | Y
37 | Notice Information |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  | Y
41 | Enron Entity |  |  |  |  | X |  | X |  | X |  |  |  |  |  |  |  |  | Y
42 | Customer's Tax ID # |  | X |  |  |  |  | X |  | X |  |  |  |  |  |  |  |  | Y
44 | New Counterparty? (Yes or No) |  |  |  |  |  |  | X |  | X |  |  |  |  |  |  |  |  | Y
45 | Customer Financial Contact (Name & Phone Number) |  | X |  |  |  |  | X |  | X |  |  |  |  |  |  |  |  | Y
46 | Estimated Annual Volumes |  |  |  |  |  |  | X |  | X |  |  |  |  |  |  |  |  | Y
49 | Contract ID |  |  |  | X |  |  | X |  |  |  | X |  |  |  |  |  |  | Y
58 | Product |  |  |  |  |  |  | X |  |  | X |  |  |  |  |  |  |  | Y
59 | Total number of meters (Priced vs Passthroughs) |  |  |  |  |  |  | X |  |  | X |  |  |  |  |  |  |  | Y
62 | Term (in years) | X |  |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | Y
65 | MWh Open - Tariff |  |  |  |  |  | X | X |  |  |  |  |  | X |  |  |  |  | Y
68 | DASH Manager |  |  |  |  |  |  |  |  |  | X |  |  | X
30 | Deal Booking Date |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | Y
35 | Tax Exemption status (yes or no) |  | X |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | Y
36 | Customer's state of incorporation |  | X |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  | Y
43 | Customer's D&B # |  | X |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | Y
50 | Company's Ticker |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  | Y
51 | Hours of Operations |  |  |  |  |  |  |  |  |  | X
52 | TCV |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  | Y
53 | Annual Spend |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  |  |  | Y
54 | NPV MWh |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  | Y
55 | Credit Reserve |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  | Y
56 | Voltage (Primary, Secondary) |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  | Y
57 | Margin Adder |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  | Y
60 | Availability of Data (e.g. 8760) |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  | Y
61 | Notional Pricing by what date |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  | Y
64 | MWh Open - Gen |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  | Y
66 | Standard or Custom |  |  |  |  |  |  |  |  |  |  |  |  | X
67 | Legal Deal Team Member |  |  |  |  |  |  |  |  |  |  |  |  | X
69 | Credit Analyst |  |  |  |  |  |  |  |  |  |  |  |  | X
70 | Overall Comments |  |  |  |  |  |  |  |  |  |  |  |  | X