Spreadsheet: chris_stokley__3972__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?
x | 1 | Company's correct legal name and address |  | X |  |  |  |  | X | X | X | X |  | X | X |  |  |  |  | Y
x | 2 | Contract Price (Percentage of index +/- differential or fixed price) |  |  |  |  | X |  | X | X | X | X |  | X | X |  |  |  |  | Y
 |  | Agent Fees |  |  |  |  | X
 |  | Adder/Multiplier |  |  |  |  | X
x | 5 | Contract/Deal Type (e.g.disc. off frozen tariff, index plus fixed basis, outsourced contracts, etc.) |  |  |  | X | X |  | X | X | X | X |  | X | X |  |  |  |  | Y
x | 3 | Deal Start Date |  |  |  |  | X |  | X | X | X | X |  | X |  |  |  |  |  | Y
x | 4 | Deal End Date |  |  |  |  | X |  | X | X | X | X |  | X |  |  |  |  |  | Y
 | 6 | Originator (Name, Phone, [NAME], Fax) |  |  |  |  | X |  | X |  | X | X |  | X | X |  |  |  |  | Y
x | 7 | Utility/LDC name for each account or site |  |  |  |  |  | X | X | X |  | X | X |  | X |  |  |  |  | Y
x | 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
x | 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
x | 11 | GCP Customer Number |  | X |  |  |  |  | X |  |  |  | X | X |  |  |  |  |  | Y
x |  | RPS Customer Number
x |  | RPS Deal Number
 | 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
x | 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
x | 32 | [NAME] |  |  |  |  | X |  | X |  |  | X |  |  |  |  |  |  |  | Y
x |  | Lower Band |  |  |  |  | X
x |  | Contract Optionality |  |  |  |  | X
 | 33 | Operational Change (formerly Material Change - percentage and calculation frequency) |  |  |  |  |  |  | X |  |  | X |  |  |  |  |  |  |  | Y
x | 34 | Baseline (yes or no, if yes - what is it) |  |  |  |  |  | X | X |  |  | X |  |  |  |  |  |  |  | Y
 | 37 | Notice Information |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  | Y
x | 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