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 PM DefaultView: Datasheet

DOL: Long binary data GUID: {guid {03BDD329-E268-4A76-

9326-A5A7A42B9F07}}

LastUpdated: 3/17/2010 12:42:24 PM MaxRecords: 0

ODBCTimeout: 60 OrderByOn: False

Orientation: Left-to-Right RecordLocks: No Locks

RecordsAffected: 0 RecordsetType: Dynaset

ReturnsRecords: True Type: 0

Updatable: True

SQL

SELECT [*__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 Data
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:40:48 PM DefaultView: Datasheet

DOL: Long binary data GUID: {guid {AAB03095-D02A-4AD2-

A2D2-FC862EC980A7}}

LastUpdated: 3/17/2010 12:44:40 PM MaxRecords: 0

ODBCTimeout: 60 OrderByOn: False

Orientation: Left-to-Right RecordLocks: No Locks

RecordsAffected: 0 RecordsetType: Dynaset

ReturnsRecords: True Type: 0

Updatable: True

SQL

SELECT [*__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 Data
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 2:03:13 PM DefaultView: Datasheet

DOL: Long binary data GUID: {guid {346A053C-1E45-42A6-

B0A1-D7EE640754A2}}

LastUpdated: 3/17/2010 12:43:13 PM MaxRecords: 0

ODBCTimeout: 60 OrderBy: OwnershipType

OrderByOn: False Orientation: Left-to-Right

RecordLocks: No Locks RecordsAffected: 0

RecordsetType: Dynaset ReturnsRecords: True

Type: 0 Updatable: True

SQL

SELECT [*__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 Data
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 2:06:46 PM DefaultView: Datasheet

DOL: Long binary data GUID: {guid {A75C4753-9197-4F3B9720-2A43175B6CA5}}

LastUpdated: 3/17/2010 12:45:09 PM MaxRecords: 0

ODBCTimeout: 60 OrderBy: OwnershipType

OrderByOn: False Orientation: Left-to-Right

RecordLocks: No Locks RecordsAffected: 0

RecordsetType: Dynaset ReturnsRecords: True

Type: 0 Updatable: True

SQL

SELECT [*__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 Data
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 2:46:19 PM DefaultView: Datasheet

DOL: Long binary data GUID: {guid {020E5AEB-6778-4E7BA1EA-C26AD03EB4E8}}

LastUpdated: 3/17/2010 12:44:00 PM MaxRecords: 0

ODBCTimeout: 60 OrderByOn: False

Orientation: Left-to-Right RecordLocks: No Locks

RecordsAffected: 0 RecordsetType: Dynaset

ReturnsRecords: True Type: 0

Updatable: True

SQL

SELECT [*__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 Data
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 11:01:37 AM DefaultView: Datasheet

DOL: Long binary data GUID: {guid {3213238E-CF56-473EA8CD-A1A99173E01C}}

LastUpdated: 3/17/2010 12:41:27 PM MaxRecords: 0

ODBCTimeout: 60 OrderByOn: False

Orientation: Left-to-Right RecordLocks: No Locks

RecordsAffected: 0 RecordsetType: Dynaset

ReturnsRecords: True Type: 16

Updatable: True

SQL

TRANSFORM 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 Data
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 11:02:29 AM DefaultView: Datasheet

DOL: Long binary data GUID: {guid {2822537A-B73B-4578-

BF05-916FD49B55EC}}

LastUpdated: 12/24/2009 11:02:42 AM MaxRecords: 0

ODBCTimeout: 60 OrderByOn: False

Orientation: Left-to-Right RecordLocks: No Locks

RecordsAffected: 0 RecordsetType: Dynaset

ReturnsRecords: True Type: 16

Updatable: True

SQL

TRANSFORM 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 Data
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 12:08:16 PM DefaultView: Datasheet

DOL: Long binary data GUID: {guid {B52D7587-4C3A-4537-

A410-EDEF63504F62}}

LastUpdated: 12/24/2009 12:08:27 PM MaxRecords: 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

SQL

SELECT [*__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 Data
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 12:08:47 PM DefaultView: Datasheet

DOL: Long binary data GUID: {guid {F3A0C6B9-AE62-4A25-

B844-3A32091DB1C4}}

LastUpdated: 12/24/2009 12:08:57 PM MaxRecords: 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

SQL

SELECT [*__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