West Virginia Public Service Commission Order Search

General Information       Search Rules       Examples


General Information: This search form allows you to search the database of Commission orders in two different ways.

The top section allows you to select a subset of orders to be searched, greatly increasing the speed and efficiency of your search. It is much faster to put the name of the utility in the case name field or the Activity Summary field than in the text search field.

The bottom section allows you to enter text to look for in the text of the orders.

To return to a prior page, click your browser's back button, use the links on the screens, or use the links in the left panel of the screen.

If you receive an 'Error Executing Database Query' message when you click submit, the top paragraph of the message will give you some idea what is wrong - most probably with the text search portion of your request. For example, the message after typing : service and electric : is [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error occurred near 'and'. Expected " " in search condition 'service and electric'. This tells you that it was expecting " " in the search condition 'service and electric' - it should have been either "service" and "electric" or "service and electric" depending on what you were trying to do.

If results appear inconsistent, click the New Search link in the left panel, click your browser's refresh button, and re-enter the criteria.



Search Rules:
The search fields at the top follow different rules than the text search of the document. In short:

When Searching DATABASE FIELDS FULL TEXT
Are searches case sensitive? No. No.
When should I use double quotes around text? Never. If there is more than 1 word in the text you are looking for, the text contains special characters like &, or you use conditional words (ie AND or OR) the double quotes are required. Otherwise, they are optional but highly recommended.
May I use logic terms to enhance my search? No. You may use AND, OR, NEAR, xxx AND NOT. These words must appear between text strings inside double quotes, as in: "Public" AND NOT "Service Commission"
How do I search for part of a word? Set the condition to contains, begins with, or ends with and type the text in the box. Put double quotes around the word and an *, as in "deny*" to find deny, denying, etc. The text entered must be the at beginning of the word and be an exact match.
How do I search for forms of a word (ie ran or run)? The text entered must exactly match some part of the word in order to be included in the results. If you use CONTAINS DENY it will not find DENIED but it will find DENYING. Use FORMSOF(INFLECTIONAL, XXX) where XXX is the word to find forms of. Using DENY here would find DENY, DENIED, DENYING, etc.
What about periods, commas, and dashes in the text? Everything you type must match exactly what is in the database field being searched, to the last period. Periods, commas, and even filler words like 'of' and 'to' will be ignored during the search. Type in "Bell-Atlantic*" and it will also return "Bell Atlantic". HOWEVER, if you type in "Bell Atlantic*" it will not find "Bell-Atlantic".

Data Search Rules:
The database field section follows the same rules as the Web Docket search.

I. The drop down condition box lets you control the results.

  A. For text fields, the primary options are:
1. CONTAINS Find the characters entered, exactly as entered, anywhere in the field.
      CAP will hit on CAP, CAPE, RECAP, ESCAPE
2. BEGINS WITH Find the characters entered, exactly as entered, at the beginning of any word.
      CAP will hit on CAP and CAPE but not RECAP or ESCAPE
3. ENDS WITH Find the characters entered, exactly as entered, at the end of any word.
      CAP will hit on CAP and RECAP but not CAPE or ESCAPE
  B. Other text field options, which should be used with care, are:
1. DOES NOT CONTAIN Will return anything where the letter group does not occur.
      CAP will return anything where C-A-P does not occur in the field.
2. IS What you enter is exactly like the entire contents of the field.
      Case Name IS American Electric Power will not return case names of American Electric Power, Inc or American Electric Power and Allegheny Gas.
3. IS NOT Returns anything that is not exactly like the entire contents of the field.
      Case Name IS NOT American Electric Power will return case names of American Electric Power, Inc or American Electric Power and Allegheny Gas, or Bluewell PSD.
4. BEFORE Returns anything alphabetically before what you enter, starting at the beginning of the field.
      Case Name BEFORE CAR will return case names beginning with A, B, or C through CAR. In a field allowing both numerals and letters, 10 is less than (before) than 2.
5. AFTER Returns anything alphabetically after what you enter, starting at the beginning of the field.
      Case Name AFTER CAR will return case names beginning with CARA and going on throught D, E, F, etc.
  C. For Date fields, the primary options are
1. EQUALS Will look for that one day.
2. DOES NOT EQUAL Will look for any day EXCEPT the date entered.
2. BEFORE Will look for anything up to and including the date entered.
2. AFTER Will look for anything after the date entered, including the day itself.
 
II. The text box allows you to enter the search text.

  A. For text fields, the text entered must match exactly with the results:
1. Every character you enter, including quotes, periods, and spaces, must appear in the results exactly as typed.
2. You cannot use logic terms such as AND to append search strings together. The search will simply read them as required text.
  B. For date fields, you must enter the date in mm/dd/yyyy format.
1. On this search screen, the conditions are preset so that if there is a date in Date Range Ending it assumes you want a date on or after Activity Date and on or before Ending. If there is not a date in Activity Date it will find activities on the Ending date.
2. You cannot use logic terms such as AND to append search strings together. The search will simply read them as required text.

Full Text Search Rules:
General Rules.
  A. When you type in a series of letters or numbers, the search will look for them as a complete word.
         CAP will only hit on CAP.
1. * Placing an asterisk (*) at the end of the text will find the complete word or any word beginning with the text entered. You must use double quotes around the text.
      "REFER*" will return refer or referring or referendum.
      "meter test*" will return meter test or meter tests or meter testing.
2. FORMSOF Placing your search text in this function will find gramatical variations on the word.
You may not use the * or multiple words or double quotes here. You may use AND, NOT, etc.
      FORMSOF(INFLECTIONAL, meet) will return meet or meeting or met.
  B. If there is more than one word in your search string or it includes special characters, you must use double quotes.
       It is highly recommended that you always put the text that you are searching for inside of double quotes.
         "AT&T"
  C. You may use logic terms like AND, OR, NEAR, AND NOT to enhance your search.
       You must use double quotes around the search text in your query.
1. AND The text strings on either side must both be in the document.
      "Appalachian" AND "REFER*"
2. OR At least one of the text strings on either side must be in the document.
      "Appalachian" OR "Mountaineer"
3. NEAR A refinement of AND, this requires that both strings be present and close together.
       You cannot use NEAR with FormsOf(inflectional, xxx).
      "Appalachian" NEAR "Power"
4. AND NOT The first string must be present and the second string missing.
      "Appalachian" AND NOT "Power"



Examples:

1. Find all Utility and Motor Carrier orders issued during August, 2005.
    Enter 8/1/2005 in Activity Date and 8/31/2007 in Date Range Ending. Click search.
     (NOTE: If two dates are entered it knows to start with the first date and include activities through the second date. You don't have to set the condition.)

2. Find all Motor Carrier orders issued during 2005 for Fly-By-Nite:
    Enter the dates 1/1/2005 and 12/31/2005, Case Number Contains MC, and Case Name Contains Fly-By-Nite. Click search.

3. Find all orders in electric petition for consent cases issued during March, 2007, that reference Raleigh County:
    Enter the dates 3/1/2007 and 3/31/2007, Case Number Contains E-PC, and Text "Raleigh". Click Search.
NOTE: If you change the text condition here to "Raleigh County" or "Raleigh" NEAR "County" you do not find any orders because the text in these documents actually has Raleigh in a list and uses 'Counties'. Using "Raleigh" AND FORMSOF(INFLECTIONAL, county) finds all of the orders.

4. Find all orders from July 10, 2007 through July 20/2007, referring to Beckley and deny.
    Enter the dates 7/10/2007 and 7/20/2007 and Text "deny AND "Beckley" - no hits.
    Enter the dates 7/10/2007 and 7/20/2007 and Text FORMSOF(INFLECTIONAL, deny) AND "Beckley" - 3 hits all of which contain some form of the work DENY but not the word itself.