Browse Tables

Browse the database Tables

Browsing the database tables is often as simple as clicking on the appropriate tab near the top of the screen. Tables are automatically loaded at the time you click on the tab. Loading tables typically takes only a few seconds.

All of the tables that are used to present the data share some common features:

• Columns can be resized by dragging the border of the title row to the left or right.
• The width of a table will often expand as the main program screen is made larger.
• If a column of interest can only be seen by scrolling the table to the right, you can grab the column title and move the column to the left. This will keep the column in view at all times.
• For the main ex ante tables, the right-click ppo-up menu also allows you to select the fields that are displayed in the table. Setting for the main tables will be remember the next time you start READI.

Use the Classification Trees to quickly access data

The two sets of tables presented under the "Classification Trees" tab can be used to navigate to Implementations, Measures, Costs and Technologies based on their Use classification or their Technology classification.

The tables present how many records are associated with each classification for the main ex ante tables. Double-clicking on one of these numeric cells will take you to that appropriate table and will filter that table to show the data of interest.

Use the tree's right-click menu (aka "pop-up" menu) for more options, such as fully expanding or collapsing the tree.

Support Tables

The Support Tables screen allows for a quick perusal of the many relatively simple tables in the ex ante database. The tables are organized into groups on the left side of the screen. Click on one of the group headings to bring up the list of tables and press one of the table buttons to load the data. Information about each table includes:

• Table Name: the name of the table in the central database.
• db Schema: the location of the table in the database. The "schema" is much like a directory and is used to store groups of related tables within the database.
• Table Usage: a brief description of how the data is used.
• SQL statement: dislays the Standard Query Language code used to retrieve the data. For database developers, this can provide some insight into the table structure.

The data table itself is similar to the other tables: key fields are highlighted in green, the column widths are expandable and columns are able to be rearranged. Tables can be filtered by specifying text in the edit box above the table. The specified text will be searched for in the first three columns of the table. Two search criteria can be specified with "and"; for example: "CFL and Outdoor" will return records that have both "CFL" and "Outdoor" in the first three fields.