View Data Tables

<< Click to Display Table of Contents >>

Navigation:  Professional > Tables > Data Tables (DT) >

View Data Tables

Open Tables and Views

 

To access data tables, complete the steps below.

1.Click Open > Tables Tables-Table.

2.In the Open window, select one or more data tables (e.g. DT_LOCATION).

3.Specify the mode for opening the table(s). For more information, see Open a Data Table.

4.Click Open.

 

15208_open_data_table_tables

 

This displays the DT_LOCATION data table.

 

Type a term into the Search field at the top of the form, then select the Go button (green arrow) to the right of the field, or type Tab then Enter to search within the current section of the Open window. Results returned will contain the search term anywhere within the name.

 

dt_location_data_table

 

The color coding in the column headers of the table provide information about each field in the table, as explained below.

 

A red column header indicates a required field (field that must contain a value).
 

An underlined column header indicates a Primary key field that helps to uniquely identify the row (most key fields are also required). Unique clustered index fields, found in PARAMETER tables, will not be underlined, although they too must be unique.
 

A blue column header indicates a foreign key field (i.e. a lookup) that may only contain a value predefined in another table (i.e. RT_ table).

 

Custom tables prefixed with either DT_ or AT_ will appear in the Data Tables.

 

Open Tables and Views

 

When opening a table or view, a drop-down at the bottom of the Open window offers three different options:

 

Option

Definition

 
Table

The Table option will open just the table or view (with no data). Build a query by establishing filters on desired columns. When selected, the Refresh button will retrieve just the data that satisfies the established filters. This mode is ideal for retrieving a small subset of data.

Table (all rows in facility)

The Table (all rows in facility) option will open the table or view with all of the rows for the current facility. Most of the tables in the database contain data for multiple facilities. This option shows only the data for the facility that is currently being worked on.

Table (all rows in database)

The Table (all rows in database) option will open the entire table or view, regardless of which facility the data belong to. Use this option only when necessary, since opening an entire table or view may take a long time and consume a large amount of system resources. This option is not available when using application level security (i.e. logged into EQuIS Professional using an EQuIS Enterprise Login).