### Author: Abt Associates Inc.

Date Created:6/26/2008 Date Modified:3/14/2011
Purpose: Provides Access queries used in the IndustryProfileTables_3.17.10.mdb Access

database. These queries generate data supporting Electric Power Industry profile; these data are outputted into the Tables_03.13.11_v1.xls and Raw Data for Profile into Access_03.13.11.xls Excel files.

H:\ERD\TYCHE Contract\Assignments\WA 0-05 (316(b))\Task 4-Economic Monday, March 14, 2011 Analysis of Rule\Proposal Documentation 2010\Ch2_IndustryProfiles\Ch2_ElPowerProfile\IndustryProfileTables_3.17.10.m

Properties DateCreated: 12/24/2009 1:35:38 PMDefaultView: Datasheet DOL: Long binary data GUID: {guid {03BDD329-E268-4A76- 9326-A5A7A42B9F07}} LastUpdated: 3/17/2010 12:42:24 PMMaxRecords: 0 ODBCTimeout: 60 OrderByOn: False Orientation: Left-to-Right RecordLocks: No Locks RecordsAffected:0 RecordsetType: Dynaset ReturnsRecords: True Type: 0 Updatable: True

SQLSELECT [*__10qryDistUtilityFacilitiesandCap].OwnershipType,

Count([*__10qryDistUtilityFacilitiesandCap].PLNTCODE) AS CountOfPLNTCODE, Sum([*__10qryDistUtilityFacilitiesandCap].[Sum Total Capacity]) AS [SumOfSum Total Capacity] FROM [*__10qryDistUtilityFacilitiesandCap] GROUP BY [*__10qryDistUtilityFacilitiesandCap].OwnershipType;

Columns

Name Type Size OwnershipType Text 255 CountOfPLNTCODE Long Integer 4 SumOfSum Total Capacity Double 8

User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete DataH:\ERD\TYCHE Contract\Assignments\WA 0-05 (316(b))\Task 4-Economic Monday, March 14, 2011

Analysis of Rule\Proposal Documentation 2010\Ch2_IndustryProfiles\Ch2_ElPowerProfile\IndustryProfileTables_3.17.10.m

Properties DateCreated: 12/24/2009 1:40:48 PMDefaultView: Datasheet DOL: Long binary data GUID: {guid {AAB03095-D02A-4AD2- A2D2-FC862EC980A7}} LastUpdated: 3/17/2010 12:44:40 PMMaxRecords: 0 ODBCTimeout: 60 OrderByOn: False Orientation: Left-to-Right RecordLocks: No Locks RecordsAffected:0 RecordsetType: Dynaset ReturnsRecords: True Type: 0 Updatable: True

SQLSELECT [*__10_2_qryDistUtilityFacilitiesandCap_InScope_List].OwnershipType,

Sum([*__10_2_qryDistUtilityFacilitiesandCap_InScope_List].[P2F/P3F: Facility Count-Based]) AS [SumOfP2F/P3F: Facility Count-Based], Sum([*__10_2_qryDistUtilityFacilitiesandCap_InScope_List].CapacityWeighted) AS SumOfCapacityWeighted FROM [*__10_2_qryDistUtilityFacilitiesandCap_InScope_List] GROUP BY [*__10_2_qryDistUtilityFacilitiesandCap_InScope_List].OwnershipType;

Columns

Name Type Size OwnershipType Text 255 SumOfP2F/P3F: Facility Count-Based Double 8 SumOfCapacityWeighted Double 8

User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete DataH:\ERD\TYCHE Contract\Assignments\WA 0-05 (316(b))\Task 4-Economic Monday, March 14, 2011

Analysis of Rule\Proposal Documentation 2010\Ch2_IndustryProfiles\Ch2_ElPowerProfile\IndustryProfileTables_3.17.10.m

Properties DateCreated: 12/24/2009 2:03:13 PMDefaultView: Datasheet DOL: Long binary data GUID: {guid {346A053C-1E45-42A6- B0A1-D7EE640754A2}} LastUpdated: 3/17/2010 12:43:13 PMMaxRecords: 0 ODBCTimeout: 60 OrderBy: OwnershipType OrderByOn: False Orientation: Left-to-Right RecordLocks: No Locks RecordsAffected: 0 RecordsetType: Dynaset ReturnsRecords: True Type: 0 Updatable: True

SQLSELECT [*__11qryNonUtilFacilitiesandCap].OwnershipType,

Count([*__11qryNonUtilFacilitiesandCap].PLNTCODE) AS CountOfPLNTCODE, Sum([*__11qryNonUtilFacilitiesandCap].[Sum Total Capacity]) AS [SumOfSum Total Capacity] FROM [*__11qryNonUtilFacilitiesandCap] GROUP BY [*__11qryNonUtilFacilitiesandCap].OwnershipType;

Columns

Name Type Size OwnershipType Text 255 CountOfPLNTCODE Long Integer 4 SumOfSum Total Capacity Double 8

User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete DataH:\ERD\TYCHE Contract\Assignments\WA 0-05 (316(b))\Task 4-Economic Monday, March 14, 2011

Analysis of Rule\Proposal Documentation 2010\Ch2_IndustryProfiles\Ch2_ElPowerProfile\IndustryProfileTables_3.17.10.m

Properties DateCreated: 12/24/2009 2:06:46 PMDefaultView: Datasheet DOL: Long binary data GUID: {guid {A75C4753-9197-4F3B9720-2A43175B6CA5}} LastUpdated: 3/17/2010 12:45:09 PMMaxRecords: 0 ODBCTimeout: 60 OrderBy: OwnershipType OrderByOn: False Orientation: Left-to-Right RecordLocks: No Locks RecordsAffected: 0 RecordsetType: Dynaset ReturnsRecords: True Type: 0 Updatable: True

SQLSELECT [*__11_2_qryNonUtilityFacilitiesandCap_InScope_List].OwnershipType,

Sum([*__11_2_qryNonUtilityFacilitiesandCap_InScope_List].[P2F/P3F: Facility Count-Based]) AS [SumOfP2F/P3F: Facility Count-Based], Sum([*__11_2_qryNonUtilityFacilitiesandCap_InScope_List].CapacityWeighted) AS SumOfCapacityWeighted FROM [*__11_2_qryNonUtilityFacilitiesandCap_InScope_List] GROUP BY [*__11_2_qryNonUtilityFacilitiesandCap_InScope_List].OwnershipType;

Columns

Name Type Size OwnershipType Text 255 SumOfP2F/P3F: Facility Count-Based Double 8 SumOfCapacityWeighted Double 8

User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete DataH:\ERD\TYCHE Contract\Assignments\WA 0-05 (316(b))\Task 4-Economic Monday, March 14, 2011

Analysis of Rule\Proposal Documentation 2010\Ch2_IndustryProfiles\Ch2_ElPowerProfile\IndustryProfileTables_3.17.10.m

Properties DateCreated: 12/24/2009 2:46:19 PMDefaultView: Datasheet DOL: Long binary data GUID: {guid {020E5AEB-6778-4E7BA1EA-C26AD03EB4E8}} LastUpdated: 3/17/2010 12:44:00 PMMaxRecords: 0 ODBCTimeout: 60 OrderByOn: False Orientation: Left-to-Right RecordLocks: No Locks RecordsAffected:0 RecordsetType: Dynaset ReturnsRecords: True Type: 0 Updatable: True

SQLSELECT [*__12qryDistPlantandCapbyNERC_List].NERC,

Count([*__12qryDistPlantandCapbyNERC_List].PLNTCODE) AS CountOfPLNTCODE, Sum([*__12qryDistPlantandCapbyNERC_List].SumOfNAMEPLATE) AS SumOfSumOfNAMEPLATE FROM [*__12qryDistPlantandCapbyNERC_List] GROUP BY [*__12qryDistPlantandCapbyNERC_List].NERC;

Columns

Name Type Size NERC Text 255 CountOfPLNTCODE Long Integer 4 SumOfSumOfNAMEPLATE Double 8

User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete DataH:\ERD\TYCHE Contract\Assignments\WA 0-05 (316(b))\Task 4-Economic Monday, March 14, 2011

Analysis of Rule\Proposal Documentation 2010\Ch2_IndustryProfiles\Ch2_ElPowerProfile\IndustryProfileTables_3.17.10.m

Properties DateCreated: 12/24/2009 11:01:37 AMDefaultView: Datasheet DOL: Long binary data GUID: {guid {3213238E-CF56-473EA8CD-A1A99173E01C}} LastUpdated: 3/17/2010 12:41:27 PMMaxRecords: 0 ODBCTimeout: 60 OrderByOn: False Orientation: Left-to-Right RecordLocks: No Locks RecordsAffected:0 RecordsetType: Dynaset ReturnsRecords: True Type: 16 Updatable: True

SQLTRANSFORM Sum([*__4qryGenDataGroupedbyPlant_NR].SumOfNAMEPLATE) AS SumOfSumOfNAMEPLATE

SELECT [*__4qryGenDataGroupedbyPlant_NR].PLNTCODE FROM [*__4qryGenDataGroupedbyPlant_NR] GROUP BY [*__4qryGenDataGroupedbyPlant_NR].PLNTCODE PIVOT [*__4qryGenDataGroupedbyPlant_NR].[*PrimeMover_ProfileDef_1];

Columns

Name Type Size PLNTCODE Double 8 CC Double 8 GT Double 8 HY Double 8 IC Double 8 OT Double 8 ST Double 8

User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete DataH:\ERD\TYCHE Contract\Assignments\WA 0-05 (316(b))\Task 4-Economic Monday, March 14, 2011

Analysis of Rule\Proposal Documentation 2010\Ch2_IndustryProfiles\Ch2_ElPowerProfile\IndustryProfileTables_3.17.10.m

Properties DateCreated: 12/24/2009 11:02:29 AMDefaultView: Datasheet DOL: Long binary data GUID: {guid {2822537A-B73B-4578- BF05-916FD49B55EC}} LastUpdated: 12/24/2009 11:02:42 AMMaxRecords: 0 ODBCTimeout: 60 OrderByOn: False Orientation: Left-to-Right RecordLocks: No Locks RecordsAffected:0 RecordsetType: Dynaset ReturnsRecords: True Type: 16 Updatable: True

SQLTRANSFORM Sum([*__5qryGenDataGroupedbyPlant_RE].SumOfNAMEPLATE) AS SumOfSumOfNAMEPLATE

SELECT [*__5qryGenDataGroupedbyPlant_RE].PLNTCODE FROM [*__5qryGenDataGroupedbyPlant_RE] GROUP BY [*__5qryGenDataGroupedbyPlant_RE].PLNTCODE PIVOT [*__5qryGenDataGroupedbyPlant_RE].[*PrimeMover_ProfileDef_1];

Columns

Name Type Size PLNTCODE Double 8 CC Double 8 GT Double 8 HY Double 8 IC Double 8 OT Double 8 ST Double 8

User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete DataH:\ERD\TYCHE Contract\Assignments\WA 0-05 (316(b))\Task 4-Economic Monday, March 14, 2011

Analysis of Rule\Proposal Documentation 2010\Ch2_IndustryProfiles\Ch2_ElPowerProfile\IndustryProfileTables_3.17.10.m

Properties DateCreated: 12/24/2009 12:08:16 PMDefaultView: Datasheet DOL: Long binary data GUID: {guid {B52D7587-4C3A-4537- A410-EDEF63504F62}} LastUpdated: 12/24/2009 12:08:27 PMMaxRecords: 0 NameMap: Long binary data ODBCTimeout: 60 OrderByOn: False Orientation: Left-to-Right RecordLocks: No Locks RecordsAffected: 0 RecordsetType: Dynaset ReturnsRecords: True Type: 0 Updatable: True

SQLSELECT [*__PlantswithAppropCategory_NR].[Facility Type],

Count([*__PlantswithAppropCategory_NR].PLNTCODE) AS CountOfPLNTCODE FROM [*__PlantswithAppropCategory_NR] GROUP BY [*__PlantswithAppropCategory_NR].[Facility Type];

Columns

Name Type Size Facility Type Text 255 CountOfPLNTCODE Long Integer 4

User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete DataH:\ERD\TYCHE Contract\Assignments\WA 0-05 (316(b))\Task 4-Economic Monday, March 14, 2011

Analysis of Rule\Proposal Documentation 2010\Ch2_IndustryProfiles\Ch2_ElPowerProfile\IndustryProfileTables_3.17.10.m

Properties DateCreated: 12/24/2009 12:08:47 PMDefaultView: Datasheet DOL: Long binary data GUID: {guid {F3A0C6B9-AE62-4A25- B844-3A32091DB1C4}} LastUpdated: 12/24/2009 12:08:57 PMMaxRecords: 0 NameMap: Long binary data ODBCTimeout: 60 OrderByOn: False Orientation: Left-to-Right RecordLocks: No Locks RecordsAffected: 0 RecordsetType: Dynaset ReturnsRecords: True Type: 0 Updatable: True

SQLSELECT [*__PlantswithAppropCategory_RE].[Facility Type],

Count([*__PlantswithAppropCategory_RE].PLNTCODE) AS CountOfPLNTCODE FROM [*__PlantswithAppropCategory_RE] GROUP BY [*__PlantswithAppropCategory_RE].[Facility Type];

Columns

Name Type Size Facility Type Text 255 CountOfPLNTCODE Long Integer 4

User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data