Creating a Data Source

To create a new data source:

1. Select the New action. The New Report Data Source page appears.

   Figure 3-2 New Report Data Source Page

   

2. Enter the details.

   Table 3-1 New Report Data Source Page

   Details	Description
   Code	Enter a unique uppercase code for this data source. Mandatory field.
   Version	The version will default to 1. Read-only field.
   Status	This will default to Draft. Read-only field.
   System Delivered	This will default to No. Read-only field.
   Description	Enter the description for this data source in the supported languages. The description for the default language is mandatory.
   Data Source Type	Select the type of data source. The default option is Query, which is the usual option for a tabular report. The Audit API option is used for form reports that present a page per Audit/Visit.
   Query	Select the query that corresponds to the data to be provided by the data source. Mandatory field. This field is hidden if one of the APIs has been selected as the data source type. The options in the list are fixed, based on the set of predefined queries provided by Oracle.
   Selected Columns	Once the query has been selected, click the icon to select which of its columns are to be provided by the data source. This field is hidden if one of the APIs has been selected as the data source type, otherwise it is a mandatory field.

3. Optionally add any filters to be applied to the data source. See Filters.

4. Save the changes and exit.