QA WebOASIS Template Queries.doc

Table of Contents – Query Templates

002-4.3.2.1 transoffering

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

transofferingaudit

Queries

Response Parameters (similar to transoffering)

3. CSV Download

002-4.3.2.2 ancoffering

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

ancofferingaudit

Queries

Response Parameters (similar to ancoffering)

3. CSV Download

002-4.3.3.1 transserv

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

002-4.3.3.2 ancserv

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

002-4.3.4.1 scheduledetail

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

scheduledetailaudit

Queries

Response Parameters (similar to scheduledetail)

3. CSV Download

002-4.3.4.2 security

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

securityaudit

Queries

Response Parameters (similar to security)

3. CSV Download

002-4.3.4.3 reduction

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

002-4.3.4.4 systemdata

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

systemdataaudit

Queries

Response Parameters (similar to systemdata)

3. CSV Download

002-4.3.5.1 list

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

002-4.3.6.2 transstatus

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

transstatusaudit

Queries

Response Parameters (similar to transstatus)

3. CSV Download

002-4.3.8.2 ancstatus

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

ancstatusaudit

Queries

Response Parameters (similar to ancstatus)

3. CSV Download

002-4.3.8.10.2 message

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

002-4.3.10.4 personnel

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

personnelaudit

Queries

Response Parameters (similar to personnel)

3. CSV Download

002-4.3.10.5 discretion

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

discretionaudit

Queries

Response Parameters (similar to discretion)

3. CSV Download

002-4.3.10.6 stdconduct

1. Query Parameters

Queries

2. Response Parameters

3. CSV Download

stdconductaudit

Queries

Response Parameters (similar to stdconduct)

3. CSV Download

QA WebOASIS Template Queries – HTML Output (Switch fmt=DATA for CSV Download)

002-4.3.2.1 transoffering

1. Query Parameters

PATH_NAME*

SELLER_CODE*

SELLER_DUNS*

POINT_OF_RECEIPT*

POINT_OF_DELIVERY*

SERVICE_INCREMENT*

TS_CLASS*

TS_TYPE*

TS_PERIOD*

TS_WINDOW*

TS_SUBCLASS*

START_TIME (of transmission services)

STOP_TIME (of transmission services)

POSTING_REF

TIME_OF_LAST_UPDATE

Queries

transoffering?ver=1.4&templ=transoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=html&seller_code=CCGtlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transoffering?ver=1.4&templ=transoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller_duns=007946452start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09– phc

transoffering?ver=1.4&templ=transoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpath_name=S/EES/EES-LEPA//tlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transoffering?ver=1.4&templ=transoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=html&por=LAGNpod=SOCOtlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transoffering?ver=1.4&templ=transoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=html&service_increment=yearly&ts_class=FIRMts_type=POINT_TO_POINT&ts_period=FULL_PERIOD&ts_window=FIXED&ts_subclass=long term firmtlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transoffering?ver=1.4&templ=transoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=html&start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transoffering?ver=1.4&templ=transoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlposting_ref=646164040tlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transoffering?ver=1.4&templ=transoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

2. Response Parameters

TIME_OF_LAST_UPDATE

SELLER_CODE

SELLER_DUNS

PATH_NAME

POINT_OF_RECEIPT

POINT_OF_DELIVERY

INTERFACE_TYPE

OFFER_START_TIME

OFFER_STOP_TIME

START_TIME

STOP_TIME

CAPACITY (If null, then look in seller comments for information.)

SERVICE_INCREMENT

TS_CLASS

TS_TYPE

TS_PERIOD

TS_WINDOW

TS_SUBCLASS

ANC_SVC_REQ

SALE_REF

POSTING_REF

CEILING_PRICE

OFFER_PRICE

PRICE_UNITS

SERVICE_DESCRIPTION (if null, then look at transserv)

NERC_CURTAILMENT_PRIORITY

OTHER_CURTAILMENT_PRIORITY

SELLER_NAME

SELLER_PHONE

SELLER_FAX

SELLER_EMAIL

SELLER_COMMENTS

- Response parameters checked 8/26/09– phc

3. CSV Download

transoffering?ver=1.4&templ=transoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

transofferingaudit

Queries

transofferingaudit?ver=1.4&templ=transofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=html&seller_code=CCGtlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

transofferingaudit?ver=1.4&templ=transofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller_duns=007946452start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09– phc

transofferingaudit?ver=1.4&templ=transofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpath_name=S/EES/EES-LEPA//tlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

transofferingaudit?ver=1.4&templ=transofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=html&por=LAGNpod=SOCOtlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

transofferingaudit?ver=1.4&templ=transofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=html&service_increment=yearly&ts_class=FIRMts_type=POINT_TO_POINT&ts_period=FULL_PERIOD&ts_window=FIXED&ts_subclass=long term firmtlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

transofferingaudit?ver=1.4&templ=transofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=html&start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

transofferingaudit?ver=1.4&templ=transofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlposting_ref=646164040tlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- posting_ref returns a script error 8/26/09 - phc

transofferingaudit?ver=1.4&templ=transofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

Response Parameters (similar to transoffering)

RECORD_TYPE

TIME_OF_LAST_UPDAT etal

- Response parameters checked 8/26/09– phc

3. CSV Download

transofferingaudit?ver=1.4&templ=transofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20080501080000CD&user=SOCNEXTDAY1&passwd=Testing1

002-4.3.2.2 ancoffering

1. Query Parameters

SELLER_CODE*

SELLER_DUNS*

?CONTROL_AREA*

SERVICE_INCREMENT*

AS_TYPE*

START_TIME

STOP_TIME

POSTING_REF

TIME_OF_LAST_UPDATE

Queries

ancoffering?ver=1.4&templ=ancoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller=PGEtlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

ancoffering?ver=1.4&templ=ancoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller_duns=007909054tlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

ancoffering?ver=1.4&templ=ancoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlcontrol_area=EEStlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09– phc (would only accept EES as control area)

ancoffering?ver=1.4&templ=ancoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlservice_increment=HOURLY&as_type=SCtlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09– phc

ancoffering?ver=1.4&templ=ancoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlstart_time=20090805080000CDstop_time=20090901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09– phc

ancoffering?ver=1.4&templ=ancoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlposting_ref=340889713tlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

ancoffering?ver=1.4&templ=ancoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

2. Response Parameters

TIME_OF_LAST_UPDATE

SELLER_CODE

SELLER_DUNS

CONTROL_AREA

OFFER_START_TIME

OFFER_STOP_TIME

START_TIME

STOP_TIME

CAPACITY

SERVICE_INCREMENT

AS_TYPE

SALE_REF

POSTING_REF

CEILING_PRICE

OFFER_PRICE

PRICE_UNITS

SERVICE_DESCRIPTION (if blank, then look at ancserv)

SELLER_NAME

SELLER_PHONE

SELLER_FAX

SELLER_EMAIL

SELLER_COMMENTS

- Response parameters checked 8/26/09 - phc

3. CSV Download

ancoffering?ver=1.4&templ=ancoffering&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

ancofferingaudit

Queries

ancofferingaudit?ver=1.4&templ=ancofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller=PGEtlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

ancofferingaudit?ver=1.4&templ=ancofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller_duns=007909054tlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

ancofferingaudit?ver=1.4&templ=ancofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlcontrol_area=EEStlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- control_area parameter not accepted (malformed) 8/26/09– phc

ancofferingaudit?ver=1.4&templ=ancofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlservice_increment=HOURLY&as_type=SCtlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- as_type parameter causes ODBC error 8/26/09– phc

ancofferingaudit?ver=1.4&templ=ancofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlstart_time=20090805080000CDstop_time=20090901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09– phc

ancofferingaudit?ver=1.4&templ=ancofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlposting_ref=398858628tlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

ancofferingaudit?ver=1.4&templ=ancofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

Response Parameters (similar to ancoffering)

RECORD_TYPE

TIME_OF_LAST_UPDAT etal

- Response parameters checked 8/26/09– phc

3. CSV Download

ancofferingaudit?ver=1.4&templ=ancofferingaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20070805080000CD&user=SOCNEXTDAY1&passwd=Testing1

002-4.3.3.1 transserv

1. Query Parameters

TIME_OF_LAST_UPDATE

Queries

transserv?ver=1.4&templ=transserv&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked; format is inconsistent with other templates8/25/09 - phc

2. Response Parameters

TIME_OF_LAST_UPDATE

SERVICE_INCREMENT

TS_CLASS

TS_TYPE

TS_PERIOD

TS_WINDOW

TS_SUBCLASS

CEILING_PRICE

PRICE_UNITS

SERVICE_DESCRIPTION

NERC_CURTAILMENT_PRIORITY

OTHER_CURTAILMENT_PRIORITY

TARIFF_REFERENCE

- Response parameters checked 8/26/09 - phc

3. CSV Download

transserv?ver=1.4&templ=transserv&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

002-4.3.3.2 ancserv

1. Query Parameters

TIME_OF_LAST_UPDATE

Queries

ancserv?ver=1.4&templ=ancserv&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked; format is inconsistent with other templates8/25/09 - phc

2. Response Parameters

TIME_OF_LAST_UPDATE

SERVICE_INCREMENT

AS_TYPE

CEILING_PRICE

PRICE_UNITS

SERVICE_DESCRIPTION

TARIFF_REFERENCE

- Response parameters checked 8/26/09 - phc

3. CSV Download

ancserv?ver=1.4&templ=ancserv&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

002-4.3.4.1 scheduledetail

1. Query Parameters

PATH_NAME*

SELLER_CODE*

SELLER_DUNS*

CUSTOMER_CODE*

CUSTOMER_DUNS*

POINT_OF_RECEIPT*

POINT_OF_DELIVERY*

SERVICE_INCREMENT*

TS_CLASS*

TS_TYPE*

TS_PERIOD*

TS_WINDOW*

TS_SUBCLASS*

START_TIME

STOP_TIME

TIME_OF_LAST_UPDATE

ASSIGNMENT_REF

TRANSACTION_ID

Queries

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpath_name=start_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 – phc NOTE: path_name doesn’t appear to be used but query accepted the parameter with null variable.

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller=EEScustomer_duns=028255979start_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlcustomer_code=CPWMseller_duns=028255979start_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpor=CSWS&pod=EES&service_increment=MONTHLYstart_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlts_class=FIRMts_type=NETWORK&ts_period=FULL_PERIOD&ts_window=FIXED&ts_subclass=DESIGNATEDstart_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlaref=1666633start_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltransaction_id=LAGN_CCG000237GA05_SOCOstart_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlstart_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

2. Response Parameters

CONTINUATION_FLAG

TIME_OF_LAST_UPDATE

SCHEDULE_REF

TRANSACTION_ID

PATH_NAME

POINT_OF_RECEIPT

POINT_OF_DELIVERY

GCA_CODE

LCA_CODE

SOURCE

SINK

SCHEDULE_PRIORITY

START_TIME

STOP_TIME

SCHEDULE_REQUESTED

SCHEDULE_GRANTED

ASSIGNMENT_REF

SELLER_CODE

SELLER_DUNS

CUSTOMER_CODE

CUSTOMER_DUNS

AFFILIATE_FLAG

SERVICE_INCREMENT

TS_CLASS

TS_TYPE

TS_PERIOD

TS_WINDOW

TS_SUBCLASS

NERC_CURTAILMENT_PRIORITY

OTHER_CURTAILMENT_PRIORITY

CAPACITY_USED

PROVIDER_ACTION

SCHEDULE_LIMIT

CURTAILMENT_OPTIONS

SECURITY_REF

INITIATING_PARTY (e.g, CA/TP code)

RESPONSIBLE_PARTY (e.g., SC code)

PROCEDURE_NAME (e.g., "NERC TLR", or registered)

PROCEDURE_LEVEL (e.g., "2a", "3")

FACILITY_LOCATION (e.g, "INTERNAL" or"EXTERNAL")

FACILITY_NAME

FACILITY_CLASS (e.g., transformer, etc.)

FACILITY_LIMIT_TYPE (e.g, thermal, stability, etc.)

- Response parameters checked 8/26/09– phc (extra fields Annotation and Error Message)

3. CSV Download

scheduledetail?ver=1.4&templ=scheduledetail&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

scheduledetailaudit

Queries

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpath_name=start_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 – phc NOTE: path_name doesn’t appear to be used but query accepted the parameter with null variable.

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller=EES&customer_duns=028255979start_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlcustomer_code=CPWMseller_duns=028255979start_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpor=CSWS&pod=EES&service_increment=MONTHLYstart_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlts_class=FIRMts_type=NETWORK&ts_period=FULL_PERIOD&ts_window=FIXED&ts_subclass=DESIGNATEDstart_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlaref=1666633start_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltransaction_id=LAGN_CCG000237GA05_SOCOstart_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlstart_time=20090825080000CDstop_time=20090826000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

Response Parameters (similar to scheduledetail)

RECORD_TYPE

CONTINUATION_FLAG

TIME_OF_LAST_UPDATE (et al)

- Response parameters checked 8/26/09– phc

3. CSV Download

scheduledetailaudit?ver=1.4&templ=scheduledetailaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20090805080000CD&user=SOCNEXTDAY1&passwd=Testing1

002-4.3.4.2 security

1. Query Parameters

START_TIME

STOP_TIME

TIME_OF_LAST_UPDATE

SECURITY_REF

EVENT_ID

SECURITY_TYPE

INITIATING_PARTY

RESPONSIBLE_PARTY

PROCEDURE_NAME

FACILITY_CLASS

FACILITY_LIMIT_TYPE

FACILITY_LOCATION

Queries

security?ver=1.4&templ=security&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlstart_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

security?ver=1.4&templ=security&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlsecurity_ref=3116116start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- parsing error 8/26/09 - phc

security?ver=1.4&templ=security&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlevent_id=teststart_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- parsing error 8/26/09 - phc

security?ver=1.4&templ=security&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlsecurity_type=limittlupdate=20080505010000CD&user=SOCNEXTDAY1&passwd=Testing1

- security_type parameters returns a script error8/25/09 - phc

security?ver=1.4&templ=security&provider=EES&pprovduns=052524212&tz=CD&fmt=html&initiating_party=EES&start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- parsing error 8/26/09 - phc

security?ver=1.4&templ=security&provider=EES&pprovduns=052524212&tz=CD&fmt=html&responsible_party=EES&start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- responsible_party parameters returns a script error 8/26/09 - phc

procedure_name=nerc%20tlr&start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- procedure_name parameters returns a script error 8/26/09 - phc

security?ver=1.4&templ=security&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlfacility_class=transformer&facility_location=internal&facility_limit_type=thermalstart_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- parsing error 8/26/09 - phc

security?ver=1.4&templ=security&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20080505010000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

2. Response Parameters

TIME_OF_LAST_UPDATE

SECURITY_REF

EVENT_ID

SECURITY_TYPE ("LIMIT" or "OUTAGE")

INITIATING_PARTY (e.g., CA/TP code)

RESPONSIBLE_PARTY (e.g., SC code)

PROCEDURE_NAME (e.g., "NERC TLR", or registered)

PROCEDURE_LEVEL (dependent on PROCEDURE_NAME)

FACILITY_CLASS (e.g., "FLOWGATE", "LINE", etc.)

FACILITY_LIMIT_TYPE (e.g., "THERMAL", "STABILITY", etc.)

FACILITY_LOCATION ("INTERNAL" or "EXTERNAL")

FACILITY_NAME (e.g., path or flowgate name)

START_TIME

STOP_TIME

- Response parameters checked 8/26/09 - phc

3. CSV Download

security?ver=1.4&templ=security&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20080505010000CD&user=SOCNEXTDAY1&passwd=Testing1

securityaudit

Queries

securityaudit?ver=1.4&templ=securityaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlstart_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameter checked - no data returned 8/26/09 - phc

securityaudit?ver=1.4&templ=securityaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlsecurity_ref=3116116start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- parsing error 8/27/09 - phc

securityaudit?ver=1.4&templ=securityaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlevent_id=teststart_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- parsing error 8/26/09 - phc

securityaudit?ver=1.4&templ=securityaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlsecurity_type=limittlupdate=20080505010000CD&user=SOCNEXTDAY1&passwd=Testing1

- security_type parameters returns an ODBC error 8/27/09 - phc

securityaudit?ver=1.4&templ=securityaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=html&initiating_party=EES&start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- parsing error 8/26/09 - phc

securityaudit?ver=1.4&templ=securityaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=html&responsible_party=EES&start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- responsible_party parameters returns a script error 8/26/09 - phc

procedure_name=nerc%20tlr&start_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- procedure_name parameters returns a script error 8/26/09 - phc

securityaudit?ver=1.4&templ=securityaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlfacility_class=transformer&facility_location=internal&facility_limit_type=thermalstart_time=20080501080000CD&stop_time=20100901000000CD&user=SOCNEXTDAY1&passwd=Testing1

- parsing error 8/26/09 - phc

securityaudit?ver=1.4&templ=securityaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20080505010000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameter checked - no data returned 8/26/09 - phc

Response Parameters (similar to security)

RECORD_TYPE

TIME_OF_LAST_UPDATE (et al)

- Response parameters checked 8/26/09– phc

3. CSV Download

securityaudit?ver=1.4&templ=securityaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20080505010000CD&user=SOCNEXTDAY1&passwd=Testing1

002-4.3.4.3 reduction

1. Query Parameters

START_TIME

STOP_TIME

ASSIGNMENT_REF* (must be specified)

Queries

reduction?ver=1.4&templ=reduction&provider=EES&pprovduns=052524212&tz=CD&fmt=html&aref=1412180stime=20090825080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

reduction?ver=1.4&templ=reduction&provider=EES&pprovduns=052524212&tz=CD&fmt=html&aref=1412180stop_time=20090825080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

2. Response Parameters

CONTINUATION_FLAG

ASSIGNMENT_REF

CAPACITY_GRANTED

CAPACITY_AVAILABLE

START_TIME

STOP_TIME

REDUCTION_TYPE (e.g., REDIRECT, INTERRUPTION, RESALE, DISPLACEMENT, etc.)

REDUCTION_REASON

IMPACTING_REF (if applicable)

CAPACITY_REDUCED

- Response parameters checked 8/26/09– phc

3. CSV Download

reduction?ver=1.4&templ=reduction&provider=EES&pprovduns=052524212&tz=CD&fmt=data&aref=1412180stop_time=20090825080000CD&user=SOCNEXTDAY1&passwd=Testing1

002-4.3.4.4 systemdata

1. Query Parameters

PATH_NAME*

POINT_OF_RECEIPT*

POINT_OF_DELIVERY*

SYSTEM_ATTRIBUTE*

START_TIME

STOP_TIME

TIME_OF_LAST_UPDATE

Queries

systemdata?ver=1.4&templ=systemdata&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpath_name=S/EES/AECI-AMRN//por=AECIpod=AMRNtlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

systemdata?ver=1.4&templ=systemdata&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlsystem_attribute=TTCtlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

systemdata?ver=1.4&templ=systemdata&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlstart_time=20080501080000CDstop_time=20090825000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

systemdata?ver=1.4&templ=systemdata&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

2. Response Parameters

POSTING_REF

PATH_NAME

POINT_OF_RECEIPT

POINT_OF_DELIVERY

SYSTEM_ATTRIBUTE

START_TIME

STOP_TIME

ATTRIBUTE_VALUE

ATTRIBUTE_UNITS

TIME_OF_LAST_UPDATE

- Response parameters checked 8/26/09 - phc

3. CSV Download

systemdata?ver=1.4&templ=systemdata&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

systemdataaudit

Queries

systemdataaudit?ver=1.4&templ=systemdataaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpath_name=S/EES/AECI-AMRN//&por=AECI&pod=AMRNtlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

systemdataaudit?ver=1.4&templ=systemdataaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlsystem_attribute=TTCtlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

systemdataaudit?ver=1.4&templ=systemdataaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlstart_time=20080501080000CDstop_time=20090825000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

systemdataaudit?ver=1.4&templ=systemdataaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=htmltlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

Response Parameters (similar to systemdata)

RECORD_TYPE

TIME_OF_LAST_UPDATE

MODIFYING_COMPANY

MODIFYING_NAME

POSTING_REF (et al)

- Response parameters checked 8/26/09– phc

3. CSV Download

systemdataaudit?ver=1.4&templ=systemdataaudit&provider=EES&pprovduns=052524212&tz=CD&fmt=datatlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

002-4.3.5.1 list

1. Query Parameters

LIST_NAME

TIME_OF_LAST_UPDATE

Queries

list?ver=1.4&templ=list&provider=EES&pprovduns=052524212&tz=CD&fmt=htmllist_name=sellertlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked; format is inconsistent with other templates8/25/09 - phc

2. Response Parameters

TIME_OF_LAST_UPDATE

LIST_NAME

LIST_ITEM

LIST_ITEM_DESCRIPTION

- Response parameters checked 8/26/09– phc

3. CSV Download

list?ver=1.4&templ=list&provider=EES&pprovduns=052524212&tz=CD&fmt=data&list_name=sellertlupdate=20080805080000CD&user=SOCNEXTDAY1&passwd=Testing1

002-4.3.6.2 transstatus

1. Query Parameters

SELLER_CODE*

SELLER_DUNS*

CUSTOMER_CODE*

CUSTOMER_DUNS*

PATH_NAME*

POINT_OF_RECEIPT*

POINT_OF_DELIVERY*

SERVICE_INCREMENT*

TS_CLASS*

TS_TYPE*

TS_PERIOD*

TS_WINDOW*

TS_SUBCLASS*

STATUS*

START_TIME (Beginning time of service)

STOP_TIME

START_TIME_QUEUED (Beginning time queue)

STOP_TIME_QUEUED

NEGOTIATED_PRICE_FLAG

ASSIGNMENT_REF

REASSIGNED_REF

RELATED_REF

SALE_REF

REQUEST_REF

DEAL_REF

COMPETING_REQUEST_FLAG

TIME_OF_LAST_UPDATE

Queries

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller=EEStlupdate=20090825080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller_duns=052524212tlupdate=20090825080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller=EES&cust=TEMUtlupdate=20090820080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlseller_duns=052524212&customer_duns=253133508tlupdate=20090820080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/26/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpath=S/EES/EES-SOCO//tlupdate=20090820080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlpor=SOCO&pod=CSWStlupdate=20090825080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlservice_increment=monthlytlupdate=20090820080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlts_class=FIRMts_type=POINT_TO_POINT&ts_period=FULL_PERIOD&ts_window=FIXEDtlupdate=20090820080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09– phc

status=invalid&ts_subclass=native/nst%20loads&tlupdate=20090820080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09– phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlstatus=invalidtlupdate=20090820080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=html&service_increment=daily&ts_type=point_to_point&status=confirmed&start_time=20090820000000CD&negotiated_price_flag=l&user=SOCNEXTDAY1&passwd=Testing1

- negotiated_price_flag ignored - 8/26/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=html&service_increment=daily&ts_type=point_to_point&status=confirmed&start_time=20090820000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=html&service_increment=daily&ts_type=point_to_point&status=confirmed&stop_time=20090825000000CD&tlupdate=20090820080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=html&service_increment=daily&ts_type=point_to_point&status=confirmed&start_time_queued=20090820000000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=html&service_increment=daily&ts_type=point_to_point&status=confirmed&stop_time_queued=20090825000000CD&tlupdate=20090820080000CD&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlassignment_ref=69910850&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlreassigned_ref=69909515&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlrelated_ref=69908855&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmldeal_ref=69910952&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlsale_ref=69910953&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc

transstatus?ver=1.4&templ=transstatus&provider=EES&pprovduns=052524212&tz=CD&fmt=htmlrequest_ref=69910934&user=SOCNEXTDAY1&passwd=Testing1

- query parameters checked 8/25/09 - phc