Copyright: Repository Mgmt Online Help - 9.0.2.80.0  Copyright © 1995, 2002, Oracle Corporation.  All Rights Reserved


Features added in Repository Reports in Release 2.1.2

Features added in Repository Reports in Release 2.1.2 are listed below.

Terminology

List of changes to Repository Reports terminology

Appearance of the tool

Toolbars and windows

Changes to standard reports

New reports

Changed reports

Obsolete reports

User control of reports

Defining your own Repository reports

Defining your own report parameters

Adding parameters to standard or user defined reports.

Deleting parameter definitions from the Repository.

Hiding a report

Hiding a parameter for a particular report.

Using the right mouse button

Report groups

Creating your own report groups

Report output

Sending report output to an HTML file

Sending report output to a PDF file

New terminology

This release contains updated terminology, which increases consistency between Oracle Designer Repository Reports and other Oracle Designer and Oracle Developer tools, particularly Report Builder:

Old terminology	New terminology
Reports window	Reports Navigator
Parameters window	Parameters Palette
Toolbars and windows

The buttons on the main toolbar have been divided between the toolbar and a new tool palette for the Reports Navigator.

When you enter a parameter value for a report, you now do so directly on the parameter line instead of in a field at the top of the Parameters Palette.

New reports

Database Object Implementation Definition

Database Synonym Definition

Datastore Completeness Checks

Detailed Module DefinitionElements not on a DiagramEntity Completeness Checks

Function Completeness Checks

Index Storage and PartitioningModule Component Definition

Oracle Type Definition

Strategic Considerations

Changed reports

A number of reports have had their contents simplified or changed since the last release. Of these, several have different names:

Old name	New name	Short name
Create Status Quality Control	Complete Status Quality Control	CDCRSQC
Dataflow	Flow	CKDFLOW
File, Record and Field Definitions	Record File, Record and Field Definitions	CDFILE1
Group Definition	Role Definition	CKGRPDFN
Invalid Database Objects	Invalid Database Objects Quality Control	CDIDOQC
Module Parameter	Module Argument	CDPARDFN
Package/Procedure/ Function Definition	PL/SQL Module Definition	CKPKGDFN
Snapshot Definition	Snapshot/View Definition	CKVWDEF
Storage Parameter	Storage Definition	CDOSP
User Definition	Database User Definition	CDUSRDFN
View Definition	Snapshot/View Definition	CKVWDEF
Obsolete reports

A number of reports are no longer provided. In many cases, this is because their contents have been combined into other reports. The obsolete reports are:

Obsolete Report	See...
Activity vs Business Unit	- (can be shown in Matrix Diagrammer)
Application Systems in a Version Group	- (no longer supported)
Atomic Functions not Included on a Dataflow Diagram	Function Completeness Checks
Attribute Names across Application Systems	- (no longer supported)
Attributes not Contained in any Datastore	- (no longer supported)
Business Unit vs Activity	- (can be shown in Matrix Diagrammer)
Business Units and Descriptions	Business Unit Definition
C++ Class Code Locations	- (no longer supported)
C++ File Contents	- (no longer supported)
C++ Object Model Definition	- (no longer supported)
Candidate Menu Module Definition	Module Definition
Candidate Module Definition	Module Definition
Database Trigger Quality Control	- (now validated by Server Generator)
Dataflows between a Function and an Ancestor	- (no longer supported)
Datastores without Attributes or Data Items	Datastore Definition
Datastores without Input Dataflows	Datastore Completeness Checks
Datastores without Input or Output Dataflows	Datastore Completeness Checks
Datastores without Output Dataflows	Datastore Completeness Checks
Datastructure Quality Control	- (now validated by Server Generator)
Element to Element Matrix	- (can be shown in Matrix Diagrammer)
Entities and their Descriptions	System Glossary
Entities not used by Functions	Entity Completeness Checks
Entities Used at a Given Business Unit	- (can be shown in Matrix Diagrammer)
Entities with no Attributes	Entity Completeness Checks
Entities with no Description	Entity Completeness Checks
Entities with no Relationships	Entity Completeness Checks
Entities with no Unique Identifier	Entity Completeness Checks
Entity Model Information	Entity Model Reference
Entity Relationship Diagram Details	Entity Model Reference
Event vs Function	Function Definition
Events and the Functions they Trigger	Function Definition
Externals in a Given Application	- (can be shown in Matrix Diagrammer)
Function Description	Function Definition
Functions and the Events they Trigger	Function Definition
Functions Executed at a Business Unit	- (can be shown in Matrix Diagrammer)
Functions Implemented by Modules	- (can be shown in Matrix Diagrammer)
Functions not Included on a Dataflow Diagram	Function Completeness Checks
Functions that Use a Given Attribute	- (can be shown in Matrix Diagrammer)
Functions Triggered by a Function	Function Definition
Groups/Users Quality Control	- (now validated by Server Generator)
Module Data Summary	Module Definition (table and column usages) Module Argument (module arguments)
Modules and the Tables/Columns Used	- (can be shown in Matrix Diagrammer)
Modules that Implement a Given Function	- (can be shown in Matrix Diagrammer)
Modules Used by a Given Module	- (can be shown in Matrix Diagrammer)
Modules which Use a Given Module	- (can be shown in Matrix Diagrammer)
Modules which Use a Given Table/View	- (can be shown in Matrix Diagrammer)
Non-atomic Functions not Dataflow Diagrammed	Function Completeness Checks
Package/Procedure Quality Control	- (now validated by Server Generator)
Relationships	Entity Model Reference
Report Definition	Detailed Module Definition
Rollback Segment Definition	Database Definition
Screen Definition	Detailed Module Definition
Shareable Elements of an Application System	- (no longer supported)   About
Skills vs Business Unit	Business Unit Definition
Snapshot Definition	Snapshot/View Definition
Table Quality Control	- (now validated by Server Generator)
Tables and their Indexes	Table Definition
Tablespace Definition	Database Definition
Transferable Elements of an Application System	- (no longer supported) About
Unique Identifiers for an Entity	Entity Model Reference
View Definition	Snapshot/View Definition
Views and their Table Derivations	Snapshot/View Definition
Using the right mouse button

If you select a report or report group in the Reports Navigator window, and then click the right mouse button, a popup menu is displayed. This menu consists of a number of options that are especially relevant at this point. For example, selecting a report name, clicking the right mouse button and selecting Run Report from the popup menu runs the report.

Selecting a parameter value in the Parameters Palette and then clicking the right mouse button brings up an editing menu, where this is possible.

Clicking the right mouse button on a file name in the Output window opens the file in the appropriate viewer.


What kind of reports can I run?

Related Topics

The Repository Reports tool provides around 100 predefined reports that you can run to examine the contents of the repository. Advanced users can also define their own repository reports.

The Reports Navigator window contains a list of reports, from which you can choose one to run. When you choose a report, its parameters are displayed in the Parameters Palette ready for you to fill in.

You can have the list of reports arranged in one of three ways:

•	by functional group (for example, entity/relationship modeling, module design and so on)

•	by repository object type (for example, business function, entity and so on)

•	alphabetically by report name

Each repository report includes data from only the current workarea. You can change to a different workarea before running a report. How

If the workarea has external references (that is, objects in the workarea refer to objects outside the workarea), the external references are not included in the report. Other repository tools provide the means to check external references, for example the Repository Object Navigator. How


Repository Reports

Introduction

What kind of reports can I run?

Features added in Repository Reports for 6i

Running a Repository report

Finding the report you want

Previewing a report

Printing a report

Sending report output to a file

Creating your own Repository reports

Defining a new Repository report

Modifying an existing report

Changing report parameters

Deleting reports, groups and parameters

Exporting and importing user-defined reports

Performing general tasks

Navigating around the report groups

Customizing the Repository Reports tool

Using the Output Window

Exiting from the Repository Reports tool

Reference

Online descriptions of all the reports

Reports arranged by group

Reports arranged by object type


Finding the report you want

In the Repository Reports tool, you can find a report in any of the following ways:

•	Finding a report by name

•	Listing reports by group

•	Listing reports by object type

•	Listing reports by name


Printing a report

To print a report:

1.	(Optional)  Change the print setup if necessary. How

2.	Find the report you want and select it in the Reports Navigator. How

3.	In the Parameters Palette, set Destination Type to Printer.

4.	Set the Destination Format to the correct printer driver (if in doubt, leave it blank or use dflt). About

5.	Set the Mode parameter. About

6.	Set the number of copies (if printing more than one copy).

7.	Set the report-specific parameters. About

8.	Click [image] in the toolbar, or double-click the report name, or use the right mouse button. How

Note:	If the Run Report icon or menu option is unavailable, the Previewer may still be active from a previous report. Click [image] in the Previewer toolbar and run the report again.

9.	When the Print dialog box is displayed, check that the settings are correct and click OK.


Using the right mouse button to run a report

To run a report using the right mouse button:

1.	Select the report name.

2.	Click the right mouse button.

3.	Select "Run Report" from the popup menu.


Setting the report parameters
Setting report parameters

Related Topics

For most reports, you will need to set parameter values of some kind to get the exact output you want. Some parameters might be displayed in different colors (for example, mandatory parameters are displayed in red). About

When you have run a report and you choose the same report again, the parameter settings that you made previously are redisplayed.

To enter a parameter value:

1.	In the Repository Reports tool, click the parameter in the Parameters Palette.

2.	If the parameter has a list of possible values already defined, a [image] (List of Values) symbol is displayed beside the field. Click this to display the possible values (for some parameters, you can also click the field itself to display the list).

Click a value to select it.

3.	If there is no list of values, type the value in the field next to the parameter name. If the parameter has a default value displayed, you can overtype this or leave it unchanged.


Exiting from the Repository Reports tool

To exit from Repository Reports, choose File→Exit.

Note:	If you want to close only the current Reports Navigator, Parameters Palette or Output Window without exiting from Repository Reports, choose File→Close.


Navigating around the report groups

Finding a report by name

Selecting items in the report list

Expanding the report list

Collapsing the report list

Setting a bookmark

Jumping to a bookmark

Listing reports by group

Listing reports by object type

Listing reports by name


Finding a report by name

Related Topics

You can find a report from its title or short name.

You can enter all or part of a report name and search for it. For example, searching for tabl will find the first report with this string in its title.

Note:	If you are searching for a report short name (for example, ckentdef), you must first display the list of report names by choosing View→Report Name View.

To find a report by name using the menu:

1.	In the Repository Reports tool, choose Navigator→Find.

2.	In the Find dialog box, enter the text you want to search for.

3.	Click the Find button.

4.	(Optional)  To search for further occurrences of the text, click the Find Next button.

To find a report by name using the toolbar:

1.	In the text entry field of the toolbar, enter the text you want to search for.

2.	Click [image] in the toolbar.

3.	(Optional)  To search for further occurrences of the text, repeat step 2.


Selecting items in the report list

Related Topics

To select a single item in the report list:

•	Click the item.

The item is highlighted to show that it is selected. Any previous selection is lost.

Note:	In this task, an item can be a report group name, an object type name or an individual report name.

To select a range of items:

1.	Select an item to identify the start of the range.

2.	Holding down SHIFT, select an item to mark the end of the selection.

All the items between the two selected items are highlighted to show that they are selected.

To select individual items that are not within a range:

•	 Holding down CTRL, select the items individually.


Expanding the report list

Related Topics

The Reports Navigator is initially displayed in group view, in which only the report groups are listed. You can also list groups by object type or by name. How

You can expand all or part of the contents of the Reports Navigator to view report names and run reports. You can expand a node in the Reports Navigator only when the node has a [image] icon next to it. About

To expand an item in the list, either click the [image] icon next to the item or do the following:

1.	Select the item that you want to expand.

2.	Click [image] in the tool palette.

To fully expand the Repository Reports node:

1.	Select the Repository Reports node.

2.	Click [image] in the tool palette.


More about expanding the report list

When you expand a group or object type, the reports for that group or object type are displayed.

When you expand a node after it was collapsed, the display returns to how it was before the node was collapsed.

When you fully expand the Repository Reports node (at the top of the list), the Reports Navigator displays all the reports. If group view or hierarchy view is selected when you fully expand the node, the reports are arranged accordingly under the appropriate headings.


Collapsing the report list

Related Topics

You can collapse all or part of the report list to make the display more compact. You can collapse a node in the Reports Navigator only when the node has a [image] icon next to it. When you expand a node after it was collapsed, the display returns to how it was before the node was collapsed.

To collapse an item in the list, either click the [image] icon next to the item or do the following:

1.	Select the item that you want to collapse.

2.	Click [image] in the tool palette.

To fully collapse the list:

1.	Select the Repository Reports node at the top of the list.

2.	Click [image] in the tool palette.

If you are in group view or hierarchy view you can now click [image] to redisplay the groups or object types respectively.


Setting a bookmark

Related Topics

You can use a bookmark to mark your place in the report list so that you can move to it quickly at a later stage. Only one bookmark can exist in the list at any one time.

To set a bookmark:

1.	In the Repository Reports tool, select the item you want to mark.

2.	Click [image] in the toolbar.


Jumping to a bookmark

Related Topics

When a bookmark has been set in the report list, you can quickly move to the marked item.

To jump to a bookmark:

•	Click [image] in the toolbar.

The report list automatically scrolls to the last bookmark that you set.


Listing reports by group

Related Topics

Reports are listed by group initially, for example, Entity/Relationship Modeling, Module Design and so on. If you have changed the view since you started, you can redisplay the group names.

To list reports by group:

•	In the Repository Reports tool, choose View→Group View.


Listing reports by object type

Related Topics

You can list the reports according to the type of repository object that they describe, for example, container, business function, entity and so on.

To list reports by object type:

•	In the Repository Reports tool, choose View→Hierarchy View.


Listing reports by name

Related Topics

To list reports alphabetically by name:

•	In the Repository Reports tool, choose View→Report Name View.


Customizing the Repository Reports tool

You can customize the Repository Reports tool on your workstation in a number of ways:

Defining a new Repository report

Deleting reports, groups and parameters

Showing or hiding reports in the list

Showing or hiding the toolbar, tool palette and status bar

Opening a new Reports Navigator

Opening a new Parameters Palette

Setting display options

Changing text colors and fonts

Specifying the location of user defined reports

Specifying the location of report output files

Using the Output window

Closing the active window


Setting display options

You can set a number of display options for the Repository Reports tool, enabling you to customize the display windows. You can set:

•	different text colors and display fonts for the display windows  How

•	the location of user-defined reports, if any  How

•	the location of report output files  How


Setting options

From the General Settings dialog box, you can do the following:

Specify the location of user defined reports

Specifying the location of report output files


Showing or hiding the toolbar, tool palette and status bar

You can choose individually whether to display or hide the toolbar, tool palette and status bar in the Repository Reports window.

To show or hide the...	Choose
Toolbar	View→Toolbar
Tool palette	View→Tool Palette
Status bar	View→Status Bar


Opening a new Reports Navigator

You can open a new Reports Navigator if none is currently open.  Opening a new Reports Navigator automatically opens a Parameters Palette if none is currently open.

To open a new Reports Navigator:

1.	In the Repository Reports tool, choose Tools→Reports Navigator.

2.	If desired, organize the windows to your liking within the main window. How


Opening a new Parameters Palette

You can open a new Parameters Palette if none is currently open.

Note:	Opening a new Reports Navigator automatically opens a Parameters Palette if none is currently open.

To open a new Parameters Palette:

1.	In the Repository Reports tool, choose Tools→Parameters Palette.

2.	If desired, organize the windows to your liking within the main window. How


Using the Output window

The Output window shows the report files that currently exist in the directory specified as the report output file location. About

To open an Output window:

•	In the Repository Reports tool, choose Window→Output Window.

To view the contents of a report file in the Output window:

•	Do one of the following:

−	double-click the filename

−	highlight the file in the Output window and choose File→Open

To delete a file from the Output window:

•	Choose Edit→Delete.


Closing the active window

You can close the active window at any time.

If the active window is:

•	a Reports Navigator, its associated Parameters Palette is also closed.

•	a Parameters Palette, its associated Reports Navigator is also closed.

•	an Output window, only the Output window is closed.

To close the active window:

1.	Choose File→Close.

2.	Repeat step 1 for any further windows to be closed.


Starting the Adobe Acrobat Reader

Related Topics

If you output a report as a PDF (Portable Display Format) file, you can use the Adobe Acrobat Reader, supplied with Oracle Designer, to view this file.

To start the Acrobat Reader:

•	In the Repository Reports tool, choose Run→Adobe Acrobat Reader.


Starting the Web browser

Related Topics

If you output a report as an HTML file, you can use a Web browser to view this file.

The Web browser must be already installed on your workstation. Contact your Customer Support representative if you need further information.

To start the Web browser:

•	In the Repository Reports tool, choose Run→Browse Web.


Starting SQL*Plus

SQL*Plus is an interactive SQL -based language for data manipulation and data definition for use with the repository data. SQL*Plus enables you easily to create ad hoc queries, retrieve and format data, and perform a variety of maintenance tasks.

To start SQL*Plus:

•	Choose Tools→SQL*Plus.


Changing the database connection

To change the database connection:

1.	Choose File→Close to close the current window. If necessary, repeat this step until no more windows are open.

2.	Choose File→Change Connection.

3.	Specify a username and password.

4.	Specify a host name for the Oracle database to which you want to connect.

If you have any problems trying to connect to a database, please refer to your System Administrator.


Organizing the windows

If you have more than one window open in the Repository Reports tool, you can rearrange the windows on the screen.

To organize your windows, choose:

•	Window→Cascade to arrange the open windows in an overlapping pattern.

•	Window→Tile Horizontally to arrange all the windows one above the other across the tool window so that all are visible and none are overlapping.

•	Window→Tile Vertically to arrange all the windows next to each other using the full height of the tool window so that all the windows are visible and none are overlapping.

•	Window→Arrange Icons to tidy up the window icons of any windows you have minimized.


Displaying an open window

You can display a Repository Reports window that is open but not currently visible on the screen, for example, if it is obscured by other windows. When you select such a window for display, it becomes the active window.

To display an open window, choose Window→<window name>.


Previewing a report

Related Topics

To preview a report:

1.	Find the report you want. How

2.	Select the report in the Reports Navigator.

3.	In the Parameters Palette, make sure that Destination Type is set to Preview.

4.	Set the report-specific parameters. About

5.	Click [image] in the toolbar, or double-click the report name, or use the right mouse button. How

Note:	If the Run Report icon or menu option is unavailable, the Previewer may still be active from a previous report. Click [image] in the Previewer toolbar and run the report again.

6.	When the Previewer is displayed, click [image] in the Previewer toolbar (or press the PAGE DOWN key) to page through the report.

7.	(Optional)  To print the report from the Previewer, click [image] in the Previewer toolbar.

Note:	If you try to print a report that has been run with a destination type of Screen rather than Preview, a message is displayed informing you that text in some screen fonts might be truncated owing to font remapping. Choose either Continue or Cancel.

8.	To close the Previewer, click [image] in the Previewer toolbar.

Note:	If you do not close the Previewer at this time, you will need to do so before you can preview any other reports in this session.


Sending report output to a file
Sending report output to a file (text, PDF or HTML)

Related Topics

You can save a repository report in a disk file in one of three different formats.  You can:

Send a report to a text file

Send a report to an HTML file

Send a report to a PDF file

The default viewer for these different types of report is preset in the Windows Registry, and the correct viewer must be installed on your workstation. You can specify other viewers for ASCII or HTML reports.


Sending a report to a text file

Related Topics

You can send report output to a text file for subsequent viewing via a text editor or similar program.

To send a report to a text file:

1.	Find the report you want. How

2.	Select the report in the Reports Navigator.

3.	In the Parameters Palette, set Destination Type to File.

4.	(Optional)  In the Destination Name field, change the file name and/or destination directory. By default, text reports are sent to a file with the extension .LIS in the Oracle Designer working directory.

5.	Ensure that the Destination Format is set to dflt or wide.

6.	Ensure that Mode is set to Bitmap.

7.	(Optional)  Set the number of copies, if you want the file to contain more than one copy.

8.	Set the report-specific parameters. About

9.	Click [image] in the toolbar, or double-click the report name, or use the right mouse button. How

Note:	If the Run Report icon or menu option is unavailable, the Previewer may still be active from a previous report. Click [image] in the Previewer toolbar and run the report again.

10.	When the Print dialog box is displayed, ensure that the Print to File check box is selected and click OK.


Sending a report to an HTML file

Related Topics

You can send report output to an HTML file for subsequent viewing via a Web browser. Users at other locations can view the report over the Internet, provided that they have access to the drive where the report resides.

To send a report to an HTML file:

1.	Find the report you want. How

2.	Select the report in the Reports Navigator.

3.	In the Parameters Palette, set Destination Type to File.

4.	(Optional)  In the Destination Name field, change the file name and/or destination directory. By default, HTML reports are sent to a file with the extension .HTML in the Oracle Designer working directory.

5.	Set the Destination Format to html.

Alternatively, if you want the report to support cascading style sheets, set the Destination Format to htmlcss. For more information on cascading style sheets, see the online documentation for Oracle Developer Report Builder.

6.	Ensure that Mode is set to Bitmap.

7.	(Optional)  Set the number of copies, if you want the file to contain more than one copy.

8.	Set the report-specific parameters. About

9.	Click [image] in the toolbar, or double-click the report name, or use the right mouse button. How

Note:	If the Run Report icon or menu option is unavailable, the Previewer may still be active from a previous report. Click [image] in the Previewer toolbar and run the report again.

10.	When the Print dialog box is displayed, ensure that the Print to File check box is selected and click OK.


Sending a report to a PDF file

Related Topics

You can send report output to a PDF (Portable Document Format) file for subsequent viewing via the Adobe Acrobat Reader supplied with Oracle Designer. PDF format allows files to be exchanged easily between different users worldwide.

To send a report to a PDF file:

1.	Find the report you want. How

2.	Select the report in the Reports Navigator.

3.	In the Parameters Palette, set Destination Type to File.

4.	(Optional)  In the Destination Name field, change the file name and/or destination directory. By default, PDF reports are sent to a file with the extension .PDF in the Oracle Designer working directory.

5.	Set the Destination Format to pdf.

6.	Ensure that Mode is set to Bitmap.

7.	(Optional)  Set the number of copies, if you want the file to contain more than one copy.

8.	Set the report-specific parameters. About

9.	Click [image] in the toolbar, or double-click the report name, or use the right mouse button. How

Note:	If the Run Report icon or menu option is unavailable, the Previewer may still be active from a previous report. Click [image] in the Previewer toolbar and run the report again.

10.	When the Print dialog box is displayed, ensure that the Print to File check box is selected and click OK.


Viewing report output in a file
Viewing report outputs in a file

If you have sent report output to a file, you can view the results by using the appropriate viewer for the type of file.  About

The output is sent to a file in the report output file directory.

To view report output in a file:

1.	If no Output window is open in the Repository Reports tool, choose Window→Output Window to open one.

2.	In the Output window, double-click the name of the output type (RDF, PDF or HTML) to show the output files in this format.

3.	To display the contents of the file, either double-click the file name in the Output window, or click the file name and choose File→Open.

If you have problems opening a viewer for an ASCII or HTML file, set the report viewer correctly. How

If you have problems opening a viewer for a PDF file, check that the Adobe Acrobat Reader has been correctly installed on your workstation. How


Defining a new Repository report

Related Topics

You can add a user-defined report to the standard set of repository reports supplied with Oracle Designer. You can add a new report definition either by creating one from the beginning, or by modifying an existing standard report definition.

Caution:	Unless you are simply modifying the parameters of an existing standard report definition, this process requires Report Builder to be installed on your workstation. Report Builder forms part of the Oracle Developer product, which is available separately from Oracle Designer.

To define a new report:

1.	(Optional)  In the Repository Reports tool, specify the directory where the definitions of user defined reports will be held. How

If you do not specify a directory, your report definitions will be stored in the same directory as the standard report definitions.

2.	If you are adding the new report to an existing report group, or if the report is not to be included in any group, continue from step 3.

If you are adding the report to a new group, create the new report group. How

3.	Create the report definition using one of these methods:

•	Create a new report definition from the beginning  How

•	Modify an existing report definition  How

4.	(Optional)  If the report is to appear under a particular report group, assign the report to the group. How

5.	To test the new report:

•	If you assigned the report to a group, choose View→Group View or View→Hierarchy View as appropriate (if not already selected) and run the report from there.

•	If the report is not assigned to any group, find the report in one of the following ways:

- choose View→Report Name View to list reports by name

- find the report by name  How

and then run the report.


Creating a report definition

From the Report Creation Options dialog box, you can:

•	Create a new report definition  How

•	Modify an existing report definition  How


Creating a new report definition

Related Topics

Advanced users can create the definition of a completely new report in addition to those supplied as standard with the Repository Reports tool. About

Caution:	Unless you are simply modifying the parameters of an existing standard report definition, this process requires Report Builder to be installed on your workstation. Report Builder forms part of the Oracle Developer product, which is available separately from Oracle Designer.

To create a new report definition:

1.	If you want to save user-defined report definitions in a directory other than the one used for the standard repository reports, specify the location for user-defined reports (if not done already). How

2.	In the Repository Reports tool:

a.	In the Reports Navigator window, click the top node named Repository Reports (or any node other than an existing report name)

b.	Choose Run→Report Builder.

3.	In Oracle Developer Report Builder, define the report. Use the Report Wizard if you are unfamiliar with Report Builder.

4.	In Report Builder, save the report definition as a file named filename.RDF in either the default reports directory or the directory defined as the location for user defined reports. About

5.	In the Repository Reports tool:

a.	Choose View→Report Name View (if reports are currently displayed by group or object type and not by name).

b.	Choose Edit→Create New Report.

6.	In the Report Creation Options dialog box, ensure that Create New Report is selected and click OK.

7.	In the Create New Report dialog box:

a.	In the Report Title field, type a name for the report (this name will appear in the Reports Navigator).

b.	In the Module Name field, type the filename with which you saved the report definition in step 4.

c.	(Optional)  In the Purpose field, type a brief description (up to 70 characters) of the purpose of the report.

d.	If the report width is to be 132 characters, change the Orientation value to Landscape, otherwise leave the value Portrait for an 80-character wide report.

e.	(Optional)  If you want users to specify a particular container when running this report, ensure that the Application Required check box is selected. Clear the check box if you want the report to operate on all containers in the repository.

f.	Click OK to return to the main Repository Reports window.

8.	In the Reports Navigator, choose View→Report Name View (if this is not already selected) and check that the report name appears in the list (it is normally added at the end).


New reports

You should be familiar with Oracle Developer Report Builder before trying to create a report definition. Report Builder includes a Report Wizard to guide you through this process, and an HTML -based Quick Tour to help you learn the basics of the tool.

You will also need to be familiar with the Repository Application Programming Interface (API). The API provides a number of repository views that you can use when creating a new report definition in Report Builder. About


Saving a user defined report definition

When you are ready to save the report definition, the directory containing the standard Repository Reports definitions is shown by default.

If you choose a different directory, you should use the one specified as the location for user-defined reports. How


Modifying an existing report

Related Topics

You can modify any existing standard or user-defined report to create a new report definition.

Caution:	Unless you are simply modifying the parameters of an existing standard report definition, this process requires Report Builder to be installed on your workstation. Report Builder forms part of the Oracle Developer product, which is available separately from Oracle Designer.

To modify an existing Repository report definition:

1.	If you want to save the modified report definition in a directory other than the one used for the standard repository reports, specify the location for user-defined reports (if not done already). How

2.	In the Repository Reports tool:

a.	Choose View→Report Name View (if reports are currently displayed by group or object type and not by name).

b.	In the Reports Navigator window, look for the short name of the report you want to modify and make a note of it.

c.	Choose Edit→Create New Report.

3.	In the Report Creation Options dialog box, select Copy Standard Repository Report and click OK.

4.	In the Copy Standard Repository Report dialog box:

a.	From the Module Name drop-down list, select the short name corresponding to the report definition on which you are basing the new report.

b.	In the Copy Module Name field, type the short name to be used to identify the new report definition (the short name appears in the Reports Navigator only when viewing reports by name).

c.	In the Copy Report Title field, replace the current report name with the name of the new report (this name appears in the Reports Navigator).

d.	Click OK to return to the main Repository Reports window.

5.	Check that the new report name appears in the Reports Navigator list.

6.	(Optional)  Add or remove report parameters as desired. How

7.	(Optional)  To modify the report definition:

a.	Select the report in the Reports Navigator.

b.	Choose Run→Report Builder.

If the Report Builder option is unavailable, make sure that Report Builder is correctly installed on your workstation, and that it is not already active.

c.	In Report Builder, modify the report definition as desired and save the new definition.


Renaming a user-defined report or group

You can change the name of a report or report group that you have created.  You cannot change the name of any of the standard reports or groups.

To rename a user-defined report or group:

1.	In the Reports Navigator window of the Repository Reports tool, click the name of the report or group you want to rename.

Note:	Take care not to double-click a report name; doing so causes the report to run.

2.	Click the name again.

3.	Edit the name.

4.	When the new name is correctly specified, choose a different node in the Reports Navigator.


Creating a new report group

Related Topics

You can add a new group to those shown when the Reports Navigator is displaying group view or hierarchy view.  The group is visible only to you, not to other users.

To create a new report group:

1.	(Optional)  In the Repository Reports tool, choose View→Group View or View→Hierarchy View to select the Reports Navigator view under which the new group is to appear.

2.	Choose Edit→Create New Group.

3.	In the Create New Group dialog box:

a.	In the Group Name field, type the name of the group (this name will appear in the Reports Navigator).

b.	If you are currently listing the reports by report name, use the Type field to choose the view type as follows:

View type	Group name appears when...
Group	Listing reports by group
Hierarchy	Listing reports by object type
c.	Click OK to create the new group.

4.	If you are currently listing the reports by report name, choose View→Group View or View→Hierarchy View as appropriate.

5.	Check that the group name appears in the Reports Navigator list.


Assigning a report to a report group

Related Topics

You can assign one or more reports to a group in a single operation.

To assign a report to a group:

1.	In the Repository Reports tool, choose View→Group View or View→Hierarchy View to display the group to which you are assigning the report.

2.	Select the group name.

3.	Choose Edit→Add Report to Group.

4.	In the Select Report(s) to Add to Group dialog box:

a.	(Optional)  Filter the displayed list. For example, typing "A" in the field and clicking the [image] button displays only the reports whose names begin with A.

b.	Select the report or reports that you want to add to the group.  Tip

Click Select All if you want to select all reports in the displayed list. You can then deselect reports by holding down CTRL and clicking the report names.

User defined reports are listed with the prefix UD.

c.	Click OK to add the report(s) to the group.

d.	Check that the report has been added to the group in the Reports Navigator.


Use the SHIFT key to select adjacent reports; use the CTRL key to select non-adjacent reports.


Changing report parameters

You can change the parameters for a standard or user-defined report in the following ways:

Defining a new report parameter

Adding parameters to a report

Removing parameters from a report


Defining a new report parameter

Related Topics

You can define a new parameter which you can subsequently add to standard or user defined reports. The parameter is visible only to you, not to other users.

To define a new parameter:

1.	In the Repository Reports tool, choose Edit→Create New Parameter.

2.	In the Create New Parameter dialog box:

a.	In the Name field, type a short internal name for the parameter (this name does not appear in the Parameters Palette).  Tip

b.	In the Prompt field, type the prompt that you want to appear for this parameter in the Parameters Palette.

c.	(Optional)  If you want the parameter value to have a datatype other than Character, select one from the Datatype dropdown list.

d.	(Optional)  If you want the parameter value to be displayed in uppercase characters when users type it in the Parameters Palette, select "Uppercase" from the Case dropdown list.

e.	(Optional)  In the Hint field, type an explanation (up to 80 characters) of what the parameter does. This explanation will appear in the Repository Reports hint line when users select this parameter in the Parameters Palette.

f.	(Optional)  If you want to restrict the possible parameter values to those from a predefined list from which users can choose, select a domain from the Domain dropdown list. About

g.	(Optional)  If you are using domains and also want to allow users to enter wildcard characters for the parameter value, select the Include Wildcard check box.


The standard parameters use uppercase characters for their internal names. Doing so here ensures that the parameter is listed in the same way as the others when users select parameters to add.


Adding parameters to a report

Related Topics

You can customize any of the standard or user defined reports by adding parameters to them. The parameters themselves can be either standard or user defined.

To add a parameter to a report:

1.	Find the report you want. How

2.	Select the report in the Reports Navigator.

3.	Choose Edit→Add Parameter to Report.

4.	In the Select Parameter(s) to Add to Report dialog box, select the parameter or parameters you want to add and click OK. The parameter names shown on the left-hand side of this list (for example, "Application Level ?") are the ones that appear in the Parameters Palette. Tip

5.	In the Add Parameter to Report dialog box:

Note:	Some fields in this dialog box are mandatory, depending on the parameter you are adding. In addition, some fields may be unavailable, depending on how the parameter was defined.

a.	In the Default Value field, type a value if you would like one to be displayed when this parameter appears in the Parameters Palette.

b.	If a value must always be supplied for this parameter, select the Mandatory check box.

c.	If users must always choose from a predefined list of values for this parameter via a [image] icon in the Parameters Palette, select the Enforce check box.

d.	In the Element Type field, select the element type to be used for the list of values.

e.	If the selected element type has subtypes and you want to restrict the list of values to one of these subtypes, choose a subtype from the Sub-Types field.

f.	In the Property Name field, select the property that you want to use as a value for this parameter.

g.	In the Restrict LOV by Parameter field, select another parameter by which to limit the list of values (if used) for this parameter.

h.	Click OK when the dialog box is complete.

i.	If you selected more than one parameter in step 3, repeat steps a. to h. when the dialog box is redisplayed.

6.	In the Parameters Palette, check that the new parameters appear correctly for the selected report.


Use the SHIFT key to select adjacent parameters; use the CTRL key to select non-adjacent parameters. To find a particular parameter by name, start typing its name in the field at the top of the dialog box.


Deleting reports, groups and parameters

You can delete a number of items that have to do with reports and report definitions:

Deleting report definitions

Removing reports from a group

Deleting report groups

Reinstating deleted standard reports

Deleting parameters from the Repository

Removing parameters from a report


Deleting report definitions

Related Topics

You can delete one or more report definitions in a single operation.

Caution:	This operation deletes the definition of a report from the repository, and from all groups in which a report is included. You cannot undo this operation for user-defined reports, though you can reinstate standard reports.

To delete a report definition:

1.	(Optional)  If you are deleting a single report definition, find the report you want to delete and select it. How

Note:	User defined reports are added at the end of the main list until the next time you start the Repository Reports tool, after which they appear in alphabetical order with the other reports.

2.	In the Repository Reports tool, choose Edit→Delete Report.

3.	If you omitted step 1 then, in the Select Report(s) to Delete from Repository dialog box:

a.	Select the report or reports you want to delete. Tip

Note:	User defined reports are listed with the prefix UD in the dialog box.

b.	Click OK to delete the report(s).

4.	If a confirmatory message is displayed , reply Yes.


Removing reports from a group

Related Topics

You can remove one or more reports from a selected group.

Note:	Removing a report from a group does not delete the report definition.

To remove a report from a group:

1.	In the Repository Reports tool, choose View→Group View or View→Hierarchy View to display the group name.

2.	Do one of the following:

•	Select the report name in the group (if removing a single report).

•	Select the group name (if removing more than one report from the group).

3.	Choose Edit→Remove Report from Group.

4.	If you selected the report name in step 2, continue from step 5.

If you selected the group name then, in the Select Report(s) to Remove from Group dialog box:

a.	Select the report or reports you want to remove. Tip

b.	Click OK to remove the report(s).

5.	If a confirmatory message is displayed , reply Yes.


Deleting report groups

Related Topics

You can delete one or more report groups in a single operation.

Caution:	This operation deletes the definition of a group, and of all the reports contained in that group. You cannot undo this operation for user-defined reports, though you can reinstate standard reports.

To delete a report group:

1.	In the Repository Reports tool, choose View→Group View or View→Hierarchy View to display the group name.

2.	(Optional)  Select the group you want to delete.

3.	Choose Edit→Delete Group.

4.	If you selected the group in step 2, continue from step 5.

If you did not select a group name then, in the Select Group(s) to Delete from Repository dialog box:

a.	(Optional)  Filter the displayed list. For example, typing "A" in the field and clicking the [image] button displays only the groups whose names begin with A.

b.	Select the group or groups you want to remove. Tip

c.	Click OK to remove the group(s).

5.	If a confirmatory message is displayed, reply Yes.


Deleting parameters from the Repository

You can delete a standard or user defined parameter from the repository.

To delete a parameter from the Repository:

1.	In the Repository Reports tool, choose Edit→Delete Parameter.

2.	In the Select Parameter(s) to Delete from Repository dialog box, select the parameter or parameters you want to delete and click OK. Tip

3.	Reply Yes to the confirmatory message.


Removing parameters from a report

You can prevent a standard or user-defined parameter from being displayed in the Parameters Palette for a particular report.

Note:	You cannot remove a parameter from a standard report (unless the parameter has been added by a user), and you cannot remove the Container parameter from any report.

To remove a parameter from a report:

1.	Find the report you want. How

2.	Select the report in the Reports Navigator.

3.	Choose Edit→Remove Parameter from Report.

4.	In the Select Parameter(s) to Remove from Report dialog box, select the parameter(s) you want to remove and click OK.

5.	Reply Yes to the confirmatory message.


Showing and hiding reports in the list

Many users of the Repository Reports tool use only a small subset of all the available reports. If you would prefer not to see the ones that you never use, you can hide these from the display in the Reports Navigator. Note that hiding and redisplaying standard reports affects all users of the repository.

To hide a report:

1.	In the Repository Reports tool, choose View→Hide Reports.

2.	In the Select Report(s) to Hide dialog box, select the report or reports you want to hide. Tip

To redisplay a report that was hidden:

1.	Choose View→Show Reports.

2.	In the Select Report(s) to Show dialog box, select the report or reports you want to redisplay and click OK.  Tip

Note:	If you have hidden a user-defined report that you created, and another user redisplays all hidden reports, you will still need to explicitly redisplay your user-defined report before you can see it.


Reinstating deleted standard reports

Related Topics

If you delete the definition of a standard repository report, you can reinstate it at any time.

Note:	You cannot reinstate a user-defined report that you have deleted.

To reinstate a standard report:

1.	In the Repository Reports tool, choose Options→Reinstate Standard Reports.

2.	In the Reinstate Standard Report(s) dialog box, select the report or reports you want to reinstate and click OK.  Tip


Changing text colors and fonts

Related Topics

For some items in the Reports Navigator and Parameters Palette, you can change the text color. About

You can also change the display font for all items in the Reports Navigator, the Parameters Palette, or both.

To change a text color:

1.	In the Repository Reports tool, choose Options→Color/Font.

2.	In the Color/Font dialog box:

a.	In the Text Color field, select the type of item for which you want to change the text color. About

b.	Click the Color Palette button.

3.	In the Color dialog box:

a.	Click the required color on the main palette.

b.	Click OK to display a sample of the newly-colored text in the Color/Font dialog box.

4.	Repeat steps 2 and 3 for any other items for which you want to change the color.

5.	(Optional)  Make any desired changes to text fonts.

6.	Apply the changes as desired. How

To change a display font:

1.	If the Color/Font dialog box is not already displayed, choose Options→Color/Font.

2.	In the Fonts field of the Color/Font dialog box, select Navigator or Parameters Palette to indicate the window in which you are setting the text font.

3.	Click the Font Dialog >> button.

4.	In the Font dialog box, select the desired font, style and size.

5.	Click OK to display a sample of text in the new font in the Color/Font dialog box.

6.	(Optional)  Repeat steps 2 to 5 for any other objects or properties for which you want to change the font.

7.	Apply the changes as desired. How


More about text colors

The items for which you can change the text color are shown in the Text Color list on the Color/Font dialog box:

Item	Description	Default Color
Normal	Standard text	Black
Error/Mandatory	Parameters that have been given an invalid value, and mandatory parameters	Red
Modified	Parameters for which a valid value has been specified	Blue
User Defined Reports	Reports that have been added to the standard set	Black
User Defined Groups	Report groups that have been added to the standard set	Black


Applying changes

When you make changes to colors, fonts or general settings, you can choose to apply the changes immediately but for the current session only (to test their effect), or to apply them from the next time you start the Repository Reports tool.

When you have specified the changes, click:

•	OK to apply the changes for the current session only

•	Cancel to abandon the entire operation

•	Save (followed by Cancel) to cause the changes to apply from when you next start the tool

•	Reset to set the fields back to the value they had when you began the operation


Specifying the location of user defined reports

Related Topics

You can specify a particular directory in which the definitions of user defined reports are held.

If you do not specify a location, the directory containing the standard report definitions is used, namely:

homedir\repadm20\srw

where homedir is the directory where Oracle Designer was installed on your workstation.

To specify the location of user defined reports:

1.	In the Repository Reports tool, choose Options→General Settings.

2.	In the General Settings dialog box:

a.	Type the full path specification in the User Defined Reports Location field, or use the Browse button to locate the desired directory.

b.	Apply the changes as desired. How


Specifying the location of report output files

Related Topics

You can specify a particular directory to which report output files are to be sent.

If you do not specify a location, the output files are sent to the Oracle Designer working directory.

To specify the location of user defined reports:

1.	In the Repository Reports tool, choose Options→General Settings.

2.	In the General Settings dialog box:

a.	Type the full path specification in the Report Output File Location field, or use the Browse button to locate the desired directory.

b.	Apply the changes as desired. How


Specifying a viewer for ASCII or HTML reports

Oracle Designer specifies default viewers for repository reports produced in ASCII or HTML format. You can override these defaults if you want to use a different viewer that is available on your workstation.  About

To specify a viewer:

1.	In the Repository Reports tool, choose Options→Report Viewer Options.

2.	In the Report Viewer Options dialog box:

•	For reports in ASCII format, either type the command in the Text Viewer field that runs the ASCII text editor you want to use (for example, C:\Program Files\Windows NT\Accessories\Wordpad.exe), or use the Browse button to locate the .EXE file for the editor.

•	For reports in HTML format, either type the command in the HTML Viewer field that runs the Web browser you want to use (for example, C:\Program Files\Netscape\Program\Netscape.exe), or use the Browse button to locate the .EXE file for the browser.


Exporting and importing user-defined reports

You can export the definitions of all your user-defined reports to a disk file for use with a different repository. You can then import them from the disk file to the new repository.

To export user-defined reports:

1.	In the Repository Reports tool, choose Options→Export.

2.	In the Choose Location of File for Export dialog box:

a.	(Optional)  Select a drive and directory other than the default from the Save In dropdown list.

b.	In the File Name field, type the name you want to use for the disk file. You can use any extension you like.

c.	Click Save.

To import user-defined reports:

1.	Choose Options→Import.

2.	In the Choose Location of File for Import dialog box:

a.	(Optional)  Select a drive and directory other than the default from the Look In dropdown list.

b.	Under File Name, select the file containing the report definitions you want to import.

c.	Click Open.


Installing the viewer for PDF files

If you send report output to PDF (Portable Document Format) files, you will need to install the Adobe Acrobat Reader in order to view the contents of these files.

Note:	Use only the version of the viewer that is supplied on the Oracle Designer product CD, as earlier versions may not work correctly with the Repository Reports tool.

1.	Check whether the Adobe Acrobat Reader has been installed, and install it if necessary:

a.	Insert the Oracle Designer product CD into the CD-ROM drive of your workstation.

b.	Start the Oracle Installer if it does not start automatically.

c.	Select Custom Installation.

d.	If the Adobe Acrobat Reader does not appear in the Products Installed list (on the right of the display), select it from the Available Products list, under +(Product Components) and click Install.

e.	Click Exit, then Yes, to exit from the Oracle Installer.

2.	Click the Start bar and choose Programs → Oracle for Windows NT → Install Adobe Acrobat Reader.

3.	Follow the on-screen instructions for installing the viewer.


Text entry field

Related Topics

Allows you to enter text when searching for a report by name.


   Find Next button

Related Topics

Finds the next report whose name contains the text string in the toolbar text box. The text box is situated to the left of the Find Next button.


   Find Previous button

Related Topics

Returns to the last report found, if any, in a search operation that was initiated by the Find Next button.

If the Find Next button has not been previously selected the Find Previous button is unavailable.


Status bar

The status bar at the bottom of the Repository Reports window is made up of two areas which contain:

•	a brief description of what the currently selected option does.

•	an indication of whether the Caps Lock, Num Lock and Scroll Lock functions are enabled.

Message	Key
CAP	Caps Lock
NUM	Num Lock
SCRL	Scroll Lock


   Context sensitive help button

Provides access to context sensitive help information about the menu options and toolbar buttons for the Repository Reports tool.

Clicking this button, or pressing SHIFT+F1, and then choosing a menu option or toolbar button displays the help topic for the chosen item.

When this button is active and you click a report name or report group name in the Reports Navigator window, context-sensitive help is displayed for that report or group.

When this button is active and you click a parameter in the Parameters Palette, context-sensitive help for the corresponding report is displayed. This help includes a description of the report parameters.


File - Open
Open (File Menu)

Related Topics

Opens a selected report file that is listed in an Output window. You must open an Output window (choose Window→Output Window) before this option becomes available.

If you run a report and set the Destination Type parameter to File a report file appears in the list in an Output window. The window lists all files that have been sent to the report output directory in the following formats:  RDF (Oracle Developer - Reports), PDF (Adobe Acrobat) and HTML.

Default viewers for different file formats


File - Close
Close (File Menu)

Related Topics

If the active window is a Reports Navigator window or an Output window, this option closes it without exiting from the Repository Reports tool.

If the active window is a Reports Navigator window and has an associated Parameters Palette open, the Parameters Palette is also closed.

If the active window is a Parameters Palette, this option is unavailable.


File - Delete
Delete (File Menu)

Related Topics

Deletes a selected file from the Output window. The file is deleted from the directory shown in the Output window.


File - Run Report
   Run Report (File Menu)

Related Topics

Runs a selected report. You can use this option to:

•	Preview a report

•	Print a report

•	Send report output to a disk file


File - Change Container
Change Container (File Menu)

Allows you to change the container you are currently working in.


Edit - Create New Group
Create New Group (Edit Menu)

Related Topics

Enables you to define a new report group and add it to the list of groups. The group is visible only to you, not to other users.

Dialog box options

Group Name

The name of the group. This name will appear in the Reports Navigator.

Type

The type of Reports Navigator view in which you want the group to appear:

View type	Group name appears when...
Group	Reports are listed by group
Hierarchy	Reports are listed by object type
You can edit this field only if reports are currently displayed by report name.


Edit - Create New Report
Create New Report (Edit Menu)

Related Topics

Enables you to create the display details for a user-defined report, such as the report title that will appear in the Reports Navigator. The actual report definition must already exist.

Dialog box options

Create New Report

Creates a completely new repository report. About

Copy Standard Repository Report

Creates a new repository report that is based on the definition of an existing report. About


Edit - Create New Parameter
Create New Parameter (Edit Menu)

Related Topics

Enables you to define a new parameter for use with repository reports.

Dialog box options

Name

A short internal name for the parameter (this name does not appear in the Parameters Palette).  Tip

Prompt

The prompt that you want to appear for this parameter in the Parameters Palette.

Datatype

(Optional)  The datatype for the parameter (default is Character).

Case

(Optional)  The case (Uppercase or Lowercase) in which the parameter value is displayed when users type it in the Parameters Palette (default is Lowercase).

Hint

(Optional)  An explanation (up to 80 characters) of what the parameter does. This explanation will appear in the Repository Reports hint line when users select this parameter in the Parameters Palette.

List of Values

Domain

(Optional)  The name of a domain, used to restrict the possible parameter values. Specifying a domain name forces users to choose from a predefined list of values. About

Include Wildcard

(Optional)  When checked, permits users to enter wildcard characters for the parameter value.


Edit - Add Report to Group
Add Report to Group (Edit Menu)

Related Topics

Enables you to add one or more reports to a selected report group. The report and the report group can be either standard or user-defined.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the reports whose names begin with A.

List box

The list of report names, from which you select the ones that you want to add to the group.  Tip

User defined reports are listed with the prefix UD.

Select All button

Selects all the reports in the displayed list. You can then deselect reports by holding down CTRL and clicking the report names.


Edit - Add Parameter to Report
Add Parameter to Report (Edit Menu)

Related Topics

Enables you to add one or more parameters to a report definition.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the parameters whose names begin with A.

List box

The list of parameter names, from which you select the ones that you want to add to the report.  Tip

Select All button

Selects all the parameters in the displayed list. You can then deselect parameters by holding down CTRL and clicking the parameter names.


Edit - Delete Group
Delete Group (Edit Menu)

Related Topics

Deletes one or more report groups from the repository.

Caution:	This option deletes the definition of a group, and of all the reports contained in that group. You cannot undo this operation for user-defined reports, though you can reinstate standard reports.

You can either select one or more groups from the list in the Reports Navigator, or display a dialog box from which to select groups to delete.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the groups whose names begin with A.

List box

The list of group names, from which you select the ones that you want to delete.  Tip

Select All button

Selects all the groups in the displayed list. You can then deselect groups by holding down CTRL and clicking the group names.


Edit - Delete Report
Delete Report (Edit Menu)

Related Topics

Deletes one or more reports from the repository.

Caution:	This option deletes the definition of a report from the repository, and from all groups in which a report is included. You cannot undo this operation for user-defined reports, though you can reinstate standard reports.

You can either select a report from the list in the Reports Navigator, or display a dialog box from which to select one or more reports to delete.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the reports whose names begin with A.

List box

The list of report names, from which you select the ones that you want to delete.  Tip

User defined reports are listed with the prefix UD.

Select All button

Selects all the reports in the displayed list. You can then deselect reports by holding down CTRL and clicking the report names.


Edit - Remove Report from Group
Remove Report from Group (Edit Menu)

Related Topics

Removes one or more reports from a selected report group. The report definition is not deleted.

You can either select a report from the list in the Reports Navigator, or display a dialog box from which to select one or more reports to remove.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the reports whose names begin with A.

List box

The list of report names, from which you select the ones that you want to remove.  Tip

User defined reports are listed with the prefix UD.

Select All button

Selects all the reports in the displayed list. You can then deselect reports by holding down CTRL and clicking the report names.


Edit - Delete Parameter
Delete Parameter (Edit Menu)

Related Topics

Deletes one or more selected parameter definitions from the repository.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the parameters whose names begin with A.

List box

The list of parameter names, from which you select the ones that you want to delete.  Tip

Select All button

Selects all the parameters in the displayed list. You can then deselect parameters by holding down CTRL and clicking the parameter names.


Edit - Remove Parameter from Report
Remove Parameter from Report (Edit Menu)

Related Topics

Enables you to remove one or more parameters from the definition of a report.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the parameters whose names begin with A.

List box

The list of parameter names, from which you select the ones that you want to remove.  Tip

Select All button

Selects all the parameters in the displayed list. You can then deselect parameters by holding down CTRL and clicking the parameter names.


View - Group View
Group View (View Menu)

Related Topics

Lists the various report groups, for example, Data Model, Function Model and so on.


View - Hierarchy View
Hierarchy View (View Menu)

Related Topics

Lists the various repository object types about which reports are available, for example, containers, business function, entity and so on.


View - Report Name View
Report Name View (View Menu)

Related Topics

Lists all the available repository reports in alphabetical order.


View - Hide Reports
Hide Reports (View Menu)

Related Topics

Prevents one or more selected reports from appearing in the Reports Navigator.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the reports whose names begin with A.

List box

The list of report names, from which you select the ones that you want to hide.  Tip

User defined reports are listed with the prefix UD.

Select All button

Selects all the reports in the displayed list. You can then deselect reports by holding down CTRL and clicking the report names.


View - Show Reports
Show Reports (View Menu)

Related Topics

Restores a previously hidden report to the display in the Reports Navigator.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the reports whose names begin with A.

List box

The list of report names, from which you select the ones that you want to redisplay.  Tip

User defined reports are listed with the prefix UD.

Select All button

Selects all the reports in the displayed list. You can then deselect reports by holding down CTRL and clicking the report names.


View - Toolbar
Toolbar (View Menu)

Related Topics

Shows or hides the toolbar below the main menu bar.

The toolbar is, similar to the tool palette, is a row of buttons representing frequently used menu options. Each button is identified by an icon that indicates the action of the associated option.


View - Tool Palette
Tool Palette (View Menu)

Related Topics

Shows or hides the tool palette at the side of the Reports Navigator.

The tool palette, similar to the toolbar, is a row of buttons representing frequently used menu options. Each button is identified by an icon that indicates the action of the associated option.


View - Status Bar
Status Bar (View Menu)

Related Topics

Shows or hides the status bar at the bottom of the Repository Reports window.


Navigator - Find
Find (Navigator Menu)

Related Topics

Enables you to find a text string in the report list.

Dialog box options

Search For

The text string for which you want to search.

The system can find a string in the report name or the report short name, even in Group View or Hierarchy View where the report names may not be visible in the Navigator. In Group View or Hierarchy View, the system can also find a string in the name of a node in the Navigator. For example in Group View, searching for “ent” finds the node named Enterprise Modeling as well as the report named Entity To Table Implementation.

Find button

Finds the first occurrence of the string.

Find Next button

Finds the next occurrence of the string, if there is one.

Find Previous button

Finds the previous occurrence of the string, if the current occurrence is not the first.


Tools - Reports Navigator
Reports Navigator (Tools Menu)

Related Topics

Opens a Reports Navigator if one is not currently open.


Tools - Parameters Palette
Parameters Palette (Tools Menu)

Related Topics

Opens a Parameters Palette if one is not currently open.


Tools - SQL*Plus
SQL*Plus (Tools Menu)

Related Topics

Starts SQL*Plus, an interactive SQL -based language for data manipulation and data definition for use with the repository data. SQL*Plus enables you easily to create ad hoc queries, retrieve and format data, and perform a variety of maintenance tasks.


Options - Color/Font
Color/Font (Options Menu)

Related Topics

Specifies the color and font options for the Repository Reports tool.

You can specify the:

•	colors in which certain types of report parameters are displayed

•	fonts used in the Reports Navigator and the Parameters Palette

Dialog box options

Text Color

The type of item for which you want to change the text color. About

Fonts

The area of the Repository Reports window to which the changes are to apply:  Navigator or Parameters Palette.

Sample

Shows a sample of text in the current font and color.

Color Palette button

Displays a further dialog box from where you can choose a color.

Font Dialog button

Displays a further dialog box from where you can choose a font, font style and size.

Save button

Causes any changes to apply from when you next start the tool.

Reset button

Sets the fields back to the values they had when you opened the dialog box.


Options General Settings
General Settings (Options Menu)

Related Topics

Specifies options for the Repository Reports tool other than those for colors and fonts.

You can specify the location of the directories to contain:

•	definitions of user defined reports

•	report output files

Dialog box options

User Defined Reports Location

The directory in which the definitions of user defined reports are held. The default location is:

oracle_home\repadm20\srw

where oracle_home is the directory where Oracle Designer was installed on your workstation. You can either enter a directory name, or use the Browse button to navigate to a particular directory.

Report Output File Location

The directory to which report output files are to be sent. The default location is the Oracle Designer working directory. You can either enter a directory name, or use the Browse button to navigate to a particular directory.

Save button

Causes any changes to apply from when you next start the tool.

Reset button

Sets the fields back to the values they had when you opened the dialog box.


Options - Report Viewer Options
Report Viewer Options (Options Menu)

Related Topics

Enables you to specify a viewer for reports that are produced in ASCII or HTML text format.

Dialog box options

Text Viewer

Select command to run ASCII viewer

The command that runs the viewer for reports produced in ASCII format. The default viewer is Windows Notepad. You can either enter the specification of an .EXE file, or use the Browse button to navigate to a particular .EXE filename.

HTML viewer

Select command to run HTML viewer

The command that runs the viewer for reports produced in HTML format. The default viewer is your default Web browser. You can either enter the specification of an .EXE file, or use the Browse button to navigate to a particular .EXE filename.


Options - Export
Export (Options Menu)

Related Topics

Exports user-defined report definitions to a disk file. You can then import these definitions into a different repository.


Options - Import
Import (Options Menu)

Related Topics

Imports user-defined report definitions from a disk file.


Options - Reinstate Standard Reports
Reinstate Standard Reports (Options Menu)

Related Topics

Restores the definition of one or more standard reports that were previously deleted.

Note:	This option restores definitions only for standard repository reports. You cannot restore definitions for user-defined reports that have been deleted.

Dialog box options

Filter field

(Optional)  Enables you to filter the displayed list. For example, typing "A" in the field and clicking the filter button displays only the deleted reports whose names begin with A.

List box

The list of deleted reports from which you select the ones that you want to reinstate.  Tip

Select All button

Selects all the reports in the displayed list. You can then deselect reports by holding down CTRL and clicking the report names.


Run - Report Builder
Report Builder (Run Menu)

Starts Report Builder, a report definition tool that forms part of the Oracle Developer product, which is available separately from Oracle Designer.

Report Builder enables you to create and modify your own repository reports in a wide variety of formats, including tabular, group, master/detail, matrix, form-like, or a combination of styles.

Make sure that Report Builder has been correctly installed on your workstation before trying to run it, and that it is not currently active.

Note:	Running Report Builder is only part of the process of defining a new repository report. About


Run - Adobe Acrobat Reader
Adobe Acrobat Reader (Run Menu)

Related Topics

Starts the Adobe Acrobat Reader which enables you to read a report that has been output to a PDF (Portable Document Format) file.

Note:	The Acrobat Reader must be already installed on your workstation for this option to work.


Run - Browse Web
Browse Web (Run Menu)

Related Topics

Starts a Web browser, which enables you to read a report that has been output to an HTML file.

Note:	A Web browser must be already installed on your workstation for this option to work.


Window - Cascade
Cascade (Window Menu)

Related Topics

Arranges the Reports and Parameters windows so that they overlap. The title bar of each window remains visible.

Note:	Minimized windows are not affected by this option.


Window - Tile Horizontally
Tile Horizontally (Window Menu)

Related Topics

Arranges the Reports and Parameters windows one above the other in the main window. The title bar and a portion of each window remain visible.

The windows are displayed at the largest possible size that will fit into the main window without overlapping each other or the icons of minimized windows.

Note:	Minimized windows are not affected by this option.


Window - Tile Vertically
Tile Vertically (Window Menu)

Related Topics

Arranges the Reports and Parameters windows side by side in the main window. The title bar and a portion of the display remain visible for each window.

The windows are displayed at the largest possible size that will fit into the main window without overlapping each other or the icons of minimized windows.

Note:	Minimized windows are not affected by this option.


Window - Output Window
Output Window (Window Menu)

Related Topics

Opens an Output window, showing the report files that currently exist in the report output file directory.

The Output window is displayed, tiled vertically with any other open windows within the repository Reports window.


Window - Arrange Icons
Arrange Icons (Window Menu)

Related Topics

Arranges the Reports and Parameters window icons neatly at the bottom of the main window.

A minimized window is displayed as an icon in the main window. If you then move these icons around in the main window, you can use this option to tidy up the display.


Window - window name
<window name> (Window Menu)

Related Topics

Lists the windows that are currently open in this tool, though not all the open windows might be visible on the screen. If you select one of the listed windows, it becomes the active window. A check mark is displayed next to the name of the active window.


Reports arranged by group

Related Topics

When the reports are arranged by group in the Reports Navigator, the groups are as follows.

Enterprise Modeling

Reports relating to business process modeling, for example, business units, process source and consequences, value-added activities.

Entity/Relationship Modeling

Reports about entities, attributes and relationships.

Dataflow Modeling

Reports about dataflows and datastores.

Function Event Modeling

Reports about business functions.

Server Model Definition

Reports relating to server modeling (database design), including tables, views, snapshots, clusters, columns, constraints, PL/SQL definitions, sequences, synonyms and triggers.

File/Record Definition

Reports listing definitions for files, records and fields.

Module Design

Reports about modules in general; about modules of type screen, menu, report, package, procedure and function; and about datastructures and user preferences.

Database and Network Design

Reports listing definitions for databases, database users, database objects, roles and storage definitions as well as database and index sizing.

Quality

Quality control reports, for example, a listing of dataflows with no attributes or data items defined, or definition completeness checks for entities or business functions.

User Extensions

Reports about elements or text defined using the user extensibility features of the repository Administration Utility.

Impact Analysis

Reports highlighting the impact of changing a particular element, for example, a listing of functions that use a particular entity, or PL/SQL modules that use a particular table.

Global

Reports relating to containers or providing other information at the application level.


Reports arranged by object type

Related Topics

You can view the reports arranged by object type (also known as hierarchy view). The object types that have reports are as follows:

Action Item

A report giving details of module definitions, including details of any action items defined for the modules.

Application System

Reports relating to containers, for example, diagrams in a given container, elements shared into a container, and so on.

Argument

A report giving details of module arguments, that is, the parameters used when a module is run.

Assumption

A report giving details of various elements, including assumptions, that can be defined at the strategic planning stage of enterprise modeling.

Attribute

Reports about attributes, for example, entities and their attributes, entity completeness checks, and so on.

Business Function

Reports about business functions, including function definition, functions that use a particular entity, and so on.

Business Terminology

The system glossary report.

Business Unit

Reports concerning business units, including the business unit definition report.

Cluster Definition

The cluster definition report which list details of clusters in containers.

Cluster Implementation

A report about the implementation of database object definitions, including implementation of cluster definitions.

Cluster Index

The cluster definition report which list details of clusters in containers.

Column

Reports about columns in database tables and their usages.

Constraint

The constraint definition report which lists details of constraints defined for a given table, view or materialized view.

Critical Success Factor

A report giving details of various elements, including critical success factors, that can be defined at the strategic planning stage of enterprise modeling.

Data Item

A report giving details of dataflow definitions, including details of data items contained in the dataflows.

Database

A report that estimates the space required to store the tables and indexes defined for a specified database.

Database (Non-Oracle)

The database definition report for a database other than an Oracle database. These are: Rdb (v 7.0, 6.1), IBM DB2/2 and DB2/MVS 4.x, Microsoft SQL Server (v 6.5, 6.0), Sybase System 11 and ANSI 92-compliant databases.

Database (Oracle)

The database definition report for an Oracle8 or Oracle7 database.

Database Object Grant

The database user definition report.

Database Profile

The database user definition report.

Database Synonym

The database synonym definition report.

Database Trigger

Reports about database triggers.

Database User

The database user definition report.

Datafile

The file definition and database definition reports.

Dataflow

Reports about dataflows, including dataflow definition, functions without input or output dataflows, and so on.

Datastore

Reports about datastores: the datastore definition and datastore completeness check reports.

Datastructure

A report about the definition of datastructures, that is, composite datatypes.

Datastructure Item

The datastructure definition report.

Diagram

Reports about diagrams defined in the container.

Document

The document definition report, providing definitions of documents produced in relation to a business system, for example, feasibility studies or test plans.

Domain

Reports about domains: domain definition and columns in a domain.

Element

Reports relating to elements, for example, element definition, element type definition and so on.

Entity

Reports about entities, including entity definition, entities and their attributes, entity-to-table implementation, and so on.

Index

Reports about tables, views and snapshots, including details of any indexes defined.

Index Storage

A report giving implementation details for database objects in a container, including details of index storage for a table implementation.

Item

A report containing details of module definitions in an container, including details of bound and unbound items relating to the module.

Item Group

A report containing module definition details, including details of any item groups to which bound and unbound items belong.

Key Based Link

A report containing module definition details, including details of any table usage links via foreign keys.

Key Performance Indicator

A report giving details of various elements, including key performance indicators, that can be defined at the strategic planning stage of enterprise modeling.

Location

A report listing details of locations defined for the business units in a container.

Logfile

The database definition report, which includes details of redo log files defined for a database.

Module

Reports about modules, for example, module definition, modules in a container, and so on.

Module Component

A report containing details of module components defined in the current container.

Module Component Table Usage

The module component definition report, which includes details of table usages by module components.

Objective

A report giving details of various elements, including objectives, that can be defined at the strategic planning stage of enterprise modeling.

PL/SQL Definition

The PL/SQL module definition report.

PL/SQL Implementation

A report that includes details of the implementation of PL/SQL modules.

Problem

A report giving details of various elements, including problems, that can be defined at the strategic planning stage of enterprise modeling.

Program Datum

A report giving details of usages of program data by modules in an container.

Record

Reports giving details of file and field definitions for specified records.

Record File

Reports giving details of file and field definitions for specified records.

Relation

Reports giving details of the definition of relation elements (records, snapshots, views and tables).

Relationship

A report that includes details about relationships between entities.

Role

Reports about roles granted to database users.

Rollback Segment

A report giving details of the rollback segments defined for a container.

Sequence Definition

A report giving details of sequences defined in a container.

Sequence Implementation

A report giving details of the implementation of sequences defined in a container.

Snapshot Definition

A report containing comprehensive column definition details for snapshots defined in a container.

Snapshot Implementation

A report giving details of the implementation of snapshots defined in a container.

Source File

A report giving details of files defined in a container, including source files.

Storage Definition

A report listing details of the storage definitions for a container.

Synonym

Reports about the synonyms defined in a container.

Table Definition

Reports about tables defined in the repository, for example, table definition, column definition and so on.

Table Implementation

A report giving details of the implementation of tables defined in a container.

Tablespace

The database definition report, which includes details of tablespace definitions in a container.

Tablespace Quota

The database user definition report, which includes details of tablespace quotas defined for users.

Unique Identifier

The entity definition report, which includes details of the unique identifiers defined for entities in a container.

View Definition

Reports relating to views, for example, view definition, views and their table derivations, and so on.

View Implementation

A report giving details of the implementation of views defined in a container.

Window

A report containing module definition details, including details of window definitions relating to the modules.


General parameters

The general parameters are the first group that you see in the Parameters Palette. They are:

Destination Type

Destination Name*

Destination Format*

Mode

Copies

Container Name

Recurse Sub-container

*	These parameters are displayed only if the destination type is set to File or Printer.

The general parameters enable you to choose where to send the output and which container to report on. You can do any of the following, according to the value you give to the Destination Type parameter:

To	Set the Destination Type to
Print the report	Printer
Preview the report	Preview or Screen
Send the report to a disk file (ASCII, HTML or PDF format)	File


Destination Type

Determines where the report output is sent. Values are:

Value	Effect
File	Sends the output to a file in the report output file directory. The default name of the file is reportname.lis, where reportname is the name shown against the report if you choose View→View by Report Name.
Mail	Not supported.
Preview	(default) Sends the output to the Previewer for viewing on the screen. Output is formatted as PostScript output, and you can also print correctly from the Previewer.
Printer	Sends the output to a printer, which you can define in the Destination Name parameter.
Screen	Sends the output to the Previewer for viewing on the screen. You can also print from the Previewer, though text in some screen fonts might be truncated when printed.


Destination Name

Identifies the file or printer to which output is to be sent, where the destination type is File or Printer.

If the destination type is File, the default destination name is reportname.lis, where reportname is the name shown against the report if you choose View→View by Report Name.

If the destination type is Printer, the default destination name is that of the system default printer defined for Windows.


Destination Format

Used if the destination type is File or Printer to identify the output format.

If the destination type is Printer, the format identifies the printer driver to be used (for example, dflt, decwide, hpl and so on). For a list of valid values for your system see your system administrator.

If the destination type is File, use one of the following values:

For Output As	Use
ASCII file	dflt
HTML file	html
Adobe Acrobat file	pdf


Mode

Specifies the output mode: Character or Bitmap. Use Bitmap for screen displays and printing on PostScript printers; use Character for printing on character-mode printers. Ensure that you set a corresponding printer driver in the Destination Format parameter, for example, a character-mode printer driver if you set Mode to Character.


Copies

Specifies the number of copies of the report you want to print, from 1 to 9999. Default is 1.


Container Name

To restrict the report details to a specified container enter a container name in this filed or choose one from the drop down list. You can use % as a wild card.


Recurse Sub-container

Allows you to report on sub-containers of the specified container. Choose Yes to do so, otherwise leave the default value No.


Report-specific parameters

Related Topics

The report-specific parameters are those following the General parameters in the Parameters Palette.

Report-specific parameters enable you to choose exactly the output you want to include in the report. They are different for each report, and are fully explained in the online descriptions of the individual reports.


Colors of item names

Various items are displayed in different colors in the Reports Navigator and the Parameters Palette. By default, these colors are:

Black	Standard text User defined reports User defined report groups
Red	Mandatory parameter
Blue	Parameter whose value has been edited


Viewers for report output files

Related Topics

If you send report output to a file, you can choose one of the following file formats for the output:

•	ASCII (text format)

•	PDF (Adobe Acrobat format)

•	HTML (for use with a Web browser)

The default viewer for each format is as follows:

Format	Viewer
ASCII	Windows Notepad
PDF	Adobe Acrobat Viewer
HTML	Your default Web browser
Alternatively, for reports in ASCII and HTML format, you can specify any viewer that is available on your system.


Using shortcut keys to work with the Repository Reports
Using shortcut keys to work with Repository Reports

Shortcuts for menu options

To		Press		As a shortcut for
Open a report from an Output window		CTRL+O		File→Open
Close the active window		CTRL+W		File→Close
Exit from Repository Reports		CTRL+Q		File→Exit
Delete report from Repository		DELETE		Edit→Delete
Opens a Reports Navigator if one is not currently open.		F3		Tools→Reports Navigator
Opens a Parameters Palette if one is not currently open.		F4		Tools→Parameters Palette
Show this shortcut key help topic		CTRL+K		Help→Show Keys
Shortcuts when using the Repository Reports windows

To		Press
Make the next window active		CTRL+F6
Shortcuts when using the Repository Reports dialogs

To		Press
Go to the next control		TAB
Go to the previous control		SHFT+TAB


About... dialog box

Displays copyright and version number information about this application. You might need to know the version number for product support purposes.


Add Parameter to Report dialog box

Related Topics

Enables you to add a parameter to a system- or user-defined report.

Note:	Some fields in this dialog box are mandatory, depending on the parameter you are adding. In addition, some fields may be unavailable, depending on how the parameter was defined.

Dialog box options

Parameter Name

The internal name of the parameter, as selected on the previous dialog box.

Default Value

A value used to prefill the value field for this parameter in the Parameters Palette. If you omit this field, no value is prefilled when this parameter is displayed.

Mandatory

When checked, indicates that users must always supply a value for this parameter. When clear, indicates that a value for the parameter is optional.

List of Values

The fields in this section relate to the use of a predefined list of values for this parameter. Users can choose from the list via a [image] icon in the Parameters Palette.

Enforce

When checked, indicates that users must always choose from a predefined list of values for this parameter.

Element Type

An element type to be used for the list of values.

Sub-Type

The element sub-type to be used for the list of values. If you specify an element type that has sub-types defined, you can use this field to further restrict the available list of values.

Property Name

A property name to be used for the list of values. If you specify an element type, you can use this field to further restrict the available list of values.

Restrict LOV by Parameter

Another parameter by which to limit the list of values.


Copy Standard Repository Report dialog box

Enables you to copy one of the standard report definitions as the basis for the definition of a new report.

Note:	Use of this dialog box is only part of the process of creating a new report by modifying an existing report definition. About

Dialog box options

Module Name

The short name corresponding to the report definition on which you are basing the new report. Short names and their corresponding reports are displayed when you choose View→Report Name View.

Copy Module Name

The short name to be used to identify the new report definition.

Copy Report Title

The name of the new report (this name appears in the Reports Navigator).


Create New Report dialog box

Enables you to create a completely new report definition (that is, one that is not based on the definition of an existing report).

Note:	Use of this dialog box is only part of the process of creating a new report definition.  About

Dialog box options

Report Title

The name of the report (this name will appear in the Reports Navigator).

Module Name

The name of the report definition file. You create this file using the Report Builder tool as part of the process of creating a new report definition.

Purpose

A brief description (up to 70 characters) of the purpose of the report.

Orientation

Defines the orientation, and consequently the width, of the report:  Portrait (80 characters wide) or Landscape (132 characters wide).

Container Required

When checked, indicates that a particular container is to be specified when running this report. When clear, indicates that the report is to operate across all containers in the repository.


Choose Directory Path dialog box

Related Topics

Enables you to specify the location of the directory that contains either the files for user-defined report definitions (Choose Directory Path of User Defined Reports) or the files for reports that are output to a file (Choose Directory Path of Report Output Files).

Dialog box options

Directories

Indicates the current directory path for the specified files.

List box

A list of subdirectories under the current directory. Double-click a name to see any further subdirectories.

Drives

Indicates the current drive. You can choose a different one from the dropdown list.

Network button

Enables you to connect to a network drive.


Navigator - Expand
Expand (Navigator Menu)

Related Topics

Expands the selected node or nodes on the Navigator, to show the next level of branches below.

This option is available only when a selected node or nodes can be expanded. The [image] icon is displayed next to all nodes that can be expanded.

To expand only a single level below a selected node, click the [image] icon.


Navigator - Collapse
 Collapse (Navigator Menu)

Related Topics

Collapses the selected node or nodes on the Navigator. The Navigator does not store any information about the levels to which nodes are expanded.

This option is available only when a selected node has been expanded. If a node can be collapsed, the [image] icon is displayed next to it.

To collapse a node or nodes so that they can be expanded back to the same level, click the [image] icon.


Report descriptions

Select the initial letter of the report for which you want online information.

<Element> Definition

A

Access to Modules by Roles

Activity Based Costing

All Text Held Against an Element

Area Metric

Association Type Definition

Attribute Definition

Attributes in a Domain

B

Business Unit Definition

C

Changed Elements

Cluster Definition

Column Definition

Column Display Usage (by Table)

Columns in a Domain

Common Functions

Complete Status Quality Control

Constraint DefinitionContainer Definition

D

Database Definition

Database Object Implementation Definition

Database Objects

Database Synonym Definition

Database Table and Index Size Estimates

Database Trigger

Database User Definition

Dataflow Definition

Dataflows without Attributes or Data Items

Datastore Completeness Checks

Datastore Definition

Datastructure DefinitionDependency AnalysisDetailed <Element> Definition

Detailed Module Definition

Diagrams in a Container

Document Definition

Domain Definition

E

Element Type Definition

Elements Referenced by a Container

Elements and their Containers

Elements not on a Diagram

Entities and their Attributes

Entities, Synonyms and their Containers

Entity Completeness Checks

Entity Definition

Entity Model Reference

Entity to Table Implementation

F

File Definition

File and Field Definitions for a Given Record

Flow

Function Completeness Checks

Function Definition

Function Hierarchy

Function Hierarchy Summary

Function to Attribute Matrix

Function to Entity Matrix

Functions without Input or Output Dataflows

Functions/Modules which Use a Given Entity

G

H

I

Index Storage and PartitioningInvalid Database Objects Quality Control

J

K

L

M

Menu and Screen Definition

Module Argument

Module Component Definition

Module Definition

Module Documentation

Module Network

Module Program Data

Module Program Data Usages

Modules in a Container

N

Non-Default User Preferences

O

Oracle Type Definition

P

PL/SQL Module Definition

Process Source and Consequences

Q

Quality Checking of Relationships

R

Record File, Record and Field Definitions

Repository User to Container Access Rights

Role Definition

S

Sequence Definition

Storage Definition

Strategic Considerations

System Glossary

T

Table Definition

Tables and Primary Key Derivations

Tables, Columns and Foreign Key Derivations

Text Definition

U

V

Value Added ActivitiesView/Materialized View Definition

W

X

Y

Z


Access to Modules by Roles report

This report contains a list of roles defined for a specified database, the names of the database users to whom the role has been granted, and a list of the modules to which granting of the role gives access.

Report filename

CDUGRP

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Database Name
Mandatory
The name of the database for which the role has been defined. You can use % as a wildcard.

Role Name
Mandatory
The name of the role you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Database
The name of the database for which the role has been defined.

Database Role
The name of a role that has been granted on the specified database.

Comment
A comment or brief description about the role.

Granted to Database User(s)
The names of the database users to whom the role has been granted.

For Access to Modules
A list of all modules to which the granting of this role gives access.


All Text Held Against an Element report

This report shows textual details about the element(s) specified in the report parameters.

Report filename

CDELTXT

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Element Type
Mandatory
Enter the short name of the element type you want to report on. The list box displays a list of the available element types.

Element Name
Mandatory
The name of the element against which the report is selected. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Other information included in the report varies according to the element against which the report is selected and the details entered by the user for the element. The report includes some of, or all, the following:

Element Name
The path and name of the specified element.

Short Name
The short name of the specified element.

Owning Container
The path and name of the container that owns the specified element.

Multi-line Text Properties
Shows any multi-line text properties for the specified element.


Container Definition report

This report contains information about the specified container including details of parentage, ownership, objectives and constraints.

Report filename

CDAPPPT

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Include Privileges?
If you want the report to include details of the privileges (Select, Insert, Update and so on) granted to the owner of the container, use the default value Yes. Otherwise use No.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The path and name of the container for which the report has been produced.

Version
The version number of the specified container.

Title
The full title of the specified container.

Description
A brief description of the specified container.

Objectives
The objectives of the specified container.

Priorities
The priorities of the specified container.

Constraints
Any constraints that have been imposed on the specified container.

Summary
A summary of the purpose of the specified container.

Authority
The name of the person or organization that initiated and authorized the specified container.

Owner
The owner of the specified container i.e., the Oracle username of the repository user who created the container, or to whom ownership has been transferred.

Comment
Comments about the specified container.

Notes
Any additional comments or notes about the specified container.

Privileges of Repository Owner
Details of the privileges granted to the owner of the specified container for the following operations:  Select, Insert, Update, Delete, Version, Administrate.


Elements Shared into an Application System report
Elements Referenced by a Container report

This report lists all the elements that are owned by other containers and that are referenced by the specified container.

Report filename

CDSHARED

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The name of the specified container.

Version
The version number of the specified container.

Element Type
Element types referenced by the specified container.

Element
The names of the element types referenced by the specified container.

Owning Container
The name of the container to which the referenced element belongs.

Version
The version number of the container to which the referenced element belongs.


Area Metric report

This report calculates the Area Metric, used for estimating the relative size of a container. Area Metric is a way of combining the numbers of entities, attributes and relationships in an entity model, and the numbers of tables, columns and foreign keys in a database design, to produce a single measure so that designs can be compared.

The Area Metric technique treats the number of entities, attributes and relationships, and the number of tables, columns and foreign keys, as the lengths of three sides of a triangle. The measure of the complexity of the corresponding design is indicated by the area of the triangle. To enable designs to be compared, the Area Metric is then defined as the ratio of the area of the two designs.

Report filename

CDMETRIC

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Include Shared Elements
Mandatory
To calculate shared elements together with elements that belong to the specified container choose Y. To calculate only elements that belong to the specified container leave the default N.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

1.	Area Metric Based on Entity Model

The relative size of the application calculated from the entity model. This calculation measures entities, attributes and relationships.

2.	Area Metric Based on Schema Design

The relative size of the application calculated from the database design. This calculation measures tables, foreign keys and columns that are not foreign keys.

3.	Area Metric Based on Comparison of Entity Model and Schema Design

A calculation comparing the ratio of the relative size of the application at the two design levels.


Attribute Definition report

This report contains comprehensive details of all the attributes describing entities in a specified container. You can choose whether to include a single entity, or all the entities, in the container.

Report filename

CKATTDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Entity Name
To restrict the report to details of a specific entity, enter its name here or choose it from the dropdown list. You can use % as a wildcard.

ER Diagram
To restrict the report to entities that appear on a particular entity relationship diagram, enter the name of the diagram here or choose it from the dropdown list. You can use % as a wildcard to report on entities in all diagrams.

Created Start Date
Restricts the report to include only entities created after this date.

Created End Date
Restricts the report to include only entities created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only entities changed after this date.

Changed End Date
Restricts the report to include only entities changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Attribute
The name of the attribute.

Of Entity
The name of the entity that is described by the attribute.

In Domain
The name of the domain to which the attribute belongs.

Sequence in Entity
The sequence position in which this attribute should normally be displayed within the entity.

Comments
A brief description of the attribute.

Optional
Indicates whether the attribute is optional.

On Condition
The conditions under which the attribute can be used. This field applies only to optional attributes.

Format
The format of the attribute.

Length
The maximum length of the attribute.

Unit of Measure
The unit of measure for the attribute (e.g., meters, minuets, hours).

Responsibility of
The identification of the user who owns this attribute.

Authority
The level of user authority needed for updating this attribute.

Default Value
The default value of this attribute. A default value is used only for mandatory attributes.

Null Value
Indicates that the attribute is not present for a particular entity.

Derivation
The algorithm or expression that describes how the value for a derived attribute is established.

Description
A description of the attribute.

Attribute Values
Value
A valid value for this attribute. If a range of values is defined, this value defines the low value.

High Value
A high value for the attribute, if a range of values is defined.

Abbreviation
An abbreviation, or short code, for the value or meaning.

Meaning
The full meaning for the abbreviation that describes the value or range specified.

Domain Values
Value
A valid value for the domain to which this attribute belongs. If a range of values is defined this value defines the low value.

High Value
A high value for the domain, if a range of values is defined.

Abbreviation
An abbreviation, or short code, for the domain value or meaning.

Meaning
The full meaning for the abbreviation, or code value, which describes the domain value or range specified.

Attribute Validation Rules
The attribute validation rules, used when testing and implementing the system.

Domain Validation Rules
The domain validation rules, used when testing and implementing the system.

Sequence in Sort Key
The normal sequence of this attribute when sorting entities.

Sorting Order
Indicates whether the normal sort sequence of the attribute is ascending or descending.


Attributes in a Domain report

This report lists all attributes within domains for the specified container.

Report filename

CDDOM2

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Domain Name
Mandatory
Enter a domain name to list attributes within a specific domain. You can use % as a wildcard to list attributes in all domains.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Domain
The name of the domain in which the attributes within the specified container occur.

Entity Name
The name of the entity which the attribute describes.

Attribute Name
The name of the attribute within the listed domain for the specified container.

Format
The format of the listed attribute.

Length
The length of the listed attribute.

Precision
The number of decimal places allowed for this attribute.


Changed Elements report

This report displays information about the primary access controlled elements (PACs) that have changed between two given dates. The information in the report includes the name of the user who last changed the element, and the name of the user who originally created the element.

Note:	A change to a secondary access controlled element does not result in a change to its owning primary access controlled element.

Report filename

CDCHANGE

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer..

Other parameters are:

From Date
Mandatory
Enter the start date (the first of the range of two dates).

End Date
Enter the finish date (the second of the range of two dates). The default date is today's date.

PAC Element Type
Mandatory
Enter the short name of the element type to be reported. You can use % as a wildcard, and the default is %, which reports on all element types.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The name of the container for which the report has been produced.

Version
The version number of the specified container.

Element Type
The element type of a changed element.

Element Name
The full name of any elements of the specified type that have been changed between the two specified dates.

Date Changed
The last date on which the element was changed.

User Changed By
The name of the user who last changed the element.

Date Created
The date on which the element was originally created.

User Created By
The name of the user who originally created the element.


Cluster Definition report

This report lists details of the clusters defined within the specified container. Clustering is a means of structuring the data in one or more tables so that the columns are physically close to one another in the Oracle database.

Report filename

CDOCL

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Cluster Name
Mandatory
The name of the cluster you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Cluster
The name of the cluster and its owning container.

Type
Indicates whether this is an index cluster or a hash cluster.

Hash Keys
The number of hash values for a hash cluster.

Hash is
The expression for the hash function of a hash cluster.

Comment
A comment about this cluster.

Optimizing Access to Tables
Optimizing Access to Materialized Views
The path name of a table or materialized view to which access is optimized by this cluster, together with a comment about the table or materialized view.

Cluster Columns
This group of fields provides details of the cluster columns.

Name
The name of one of the columns which comprise the cluster key.

Mapping Column
Specifies the columns of the clustered tables that can be mapped onto the cluster column listed under Cluster Column. The path is included and columns are specified as table.column, where table is the name of the table within the cluster definition that contains the column, and column is the name of the column in the table.

Datatype
The Oracle datatype for the column.

Length
The total number of digits that can be specified in a numeric column.

Decimal Place
The total number of digits that may be used to the right of the decimal point in a numeric column.

Indexes
The next group of fields provides details of the cluster indexes.

Index Name
The name of the index.

Complete
Indicates whether this index is ready to be generated by the Server Generator.

Comment
A comment about why the index is created and how it is to be used.


Column Definition report

This report contains comprehensive column definition details for the given table(s), view(s) or materialized view(s) in the specified container, together with the display parameters.

Report filename

CKCOLDT

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Table/View/Materialized View
The name of the table, view or materialized view you want to include in your report. You can use % as a wildcard.

Oracle Object Type Name
To restrict the report to show details only from a particular Oracle object type, enter its name here. You can use % as a wildcard.

Data Structure Diagram
The name of a data structure diagram for which the report is to be displayed. This field can be used to restrict the information listed in the report to that appearing on the diagram(s) specified. The wildcard % can also be used.

Created Start Date
Restricts the report to include only columns created after this date.

Created End Date
Restricts the report to include only columns created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only columns changed after this date.

Changed End Date
Restricts the report to include only columns changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Column Name
The name(s) of any columns defined for the specified table(s), view(s) or materialized view(s). An asterisk (*) adjacent to the column indicates that the column is indexed.

Domain
The name of the domain to which the listed column belongs.

Table Name
The name of the table, view or materialized view for which the column is defined.

Owned By
The name of the container which owns the column.

Version
The version number of the container.

Sequence
The sequence number used to order the columns when the table, view or materialized view is created.

Datatype
The standard datatype of the column.

Max Length
The maximum length of data that the column can contain.

Ave Length
The average length of data contained in this column.

Decimal Places
The number of decimal places allowed for this column.

Oracle Type
Identifies the Oracle8 database object type, VARRAY or nested table that defines the structure of the data represented by this column.

Object Type Inclusion
If the column is defined as part of an object datatype, this property indicates whether that object is referenced or embedded.

Scope Table
Identifies the table from which the REF values for the column are obtained.

Store REF with ROWID?
Indicates whether the ROWID is stored with the column REF value. Doing so can improve the performance of dereferencing.

Nulls?
Indicates whether the column can contain null values.

Uppercase?
Indicates whether column values are stored in uppercase.

Display Datatype
The display datatype used when displaying the column in reports and screens.

Display Len
The length of data that can be displayed in the column.

Display Seq
The sequence number used to order the columns when displayed in reports and screens.

Init Vol
The percentage of the rows that will have a value in this column when the table is initially created (Initial Volume). The value will be 100 if this column is defined as not null.

Final Vol
The percentage of the rows that will have a value in this column when the table is in use (Final Volume). The value will be 100 if this column is defined as not null.

Prompt
The prompt used when displaying the column in reports, screens, etc.

Comment
A short general description of this column.

Hint Text
A single line of text describing the purpose of this column.

Default
The default value for the column, used by Generators when a row is created.

Sequence
The name of a sequence for this column.

The next section gives details of any primary keys or foreign keys of which this column forms a part.

Sequence in Primary Key
Indicates whether the sequence is used as part of the primary key.

Primary Key Comment
A comment about the primary key, for example, "Created by Default Database Design on <date> by <username>".

Autogenerate Key Value?
Indicates whether the specified column should be automatically generated.

Create?
Indicates whether the column is to be included in the CREATE TABLE statement generated by the Generate Database Objects Utility.

Descriptor Column?
Indicates whether the column is a descriptor column. One or more columns may be defined as being the descriptor columns for their table (i.e., those columns that can describe or identify individual rows). This preference determines whether Forms Generator will automatically include the descriptor columns from tables at the other end of foreign keys, where there are no explicit lookup usages associated with the foreign key.

Foreign Key Table
The name of a table that is joined, via a foreign key, to the table to which this column belongs.

Transferable?
Indicates whether the foreign key is transferable (that is, it can be updated).

Join Column
The name of the column, in the table identified by Foreign Key Table, to which this column is joined by the foreign key.

Cascade Delete Rule
The action following an attempt to delete a related row in the join table.

Cascade Update Rule
The action following an attempt to update a related row in the join table.

Is Column Value derived on the Server?
Indicates whether the column value is derived on the server, via a database trigger.

Use Domain as suggestion List only?
Indicates that the column domain is to be treated as a suggestion list only, not enforced.

Column Description
A description of the column.

Valid Values

Value
If High Value is specified, this is the low value of a range of valid values for the column. If no range is specified, this is a valid value to be used for the column.

High Value
Identifies a high value to be used where a range of valid values is used for the column.

Abbreviation
An abbreviation, or short code, for the value or range of values.

Meaning
The full meaning of the abbreviation that describes the value or range specified.

The next group lists details of indexes and help text relating to this column.

Sequence
The sequence of this column in the index.

Index Name
The name of the index.

Column Help Text
Default help information to be displayed by applications that reference this column.


Columns in a Domain report

This report lists the tables and columns that exist in each domain for the specified container.

Report filename

CDDOM1

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Domain Name
Mandatory
Choose a domain name to list tables and columns within a specific domain. The default value, %, lists tables and columns within all domains in the specified container.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Domain
The name of the domain.

Table Name
The name of the table within the listed domain.

Column Name
The name of the column within the listed domain.

Data Type
The datatype of the listed column.

Max Length
The maximum length of the datatype.

Dec Places
The number of decimal places allowed for this column.


Common Functions report

This report details all the common functions that have been defined in the specified container. A common function is a function which is an exact replica of a function already existing in the hierarchy.

Report filename

CDMFUN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Function Hierarchy
Choose the name of a function hierarchy diagram if you want to restrict the report to common functions on that diagram. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Master Function
The name of the original master function from which the details of the copied functions (slave functions) were derived.

Master Definition
A textual definition of a master function.

Slave Function(s)
The function which derives its details from the master function.

In Container
The name of the container in which the master function and slave function(s) exist.

Vn.
The version number of the listed container.


Constraint Definition report

This report shows details of the constraints defined for a given table, view or materialized view. You can choose any or all of the following types:  primary key constraints, unique key constraints, foreign key constraints and check constraints.

Report filename

CKCONDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Table/View/Materialized View
Mandatory
Enter the name of the table, view or materialized view you want to include in your report. You can use % as a wildcard; the default value % includes all tables, views and materialized views in the container.

Constraint Type
Choose a constraint type (e.g., primary key constraint, check constraint) if you want to restrict the report to constraints of that type. The default value % selects constraints of all types.

Created Start Date
Restricts the report to include only constraints created after this date.

Created End Date
Restricts the report to include only constraints created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only constraints changed after this date.

Changed End Date
Restricts the report to include only constraints changed before this date. Default is today's date.

Information included in the report

The report is divided into four sections: primary key constraints, unique key constraints, foreign key constraints and check constraints.

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The name of the specified container.

Version
The version number of the container.

Table Name
The name of the table for which the keys are defined.

Primary Key Constraint
Primary Key Name
The name of the primary key constraint for the listed table.

Complete?
Indicates whether the constraint is ready to be generated by the Server Generator.

Enable?
Indicates whether the constraint is to be enabled or disabled when the table is generated on the database.

Defer Status?
Indicates whether validation of the constraint is to be deferred until the end of the transaction, until the end of each DML statement, or is not to be deferred.

Validate In
The level at which the constraint is to be implemented:  client (application level only), server (database level only) or both.

Update?
Indicates whether the primary key can be updated.

Error Message
A user-defined error message that is issued instead of the default error message when data is entered that violates this constraint.

Exceptions Table
The name of the table, view or materialized view in which exceptions to this constraint are written.

Column
The name of the column that is defined as the primary key, or which forms part of the primary key.

Datatype
The defined datatype for the column.

Length
The maximum length of the data that the column can contain.

Allow Nulls
Indicates whether the column can contain null values. If the value is Yes, the column is optional and can therefore contain null values.

Comment
A brief comment about the column.

Unique Key Constraint
Unique Key Name
The name of the unique key for the specified table.

Complete?
Indicates whether the constraint is ready to be generated by the Server Generator.

Enable?
Indicates whether the constraint is to be enabled or disabled when the table is generated on the database.

Mandatory?
Indicates whether a value is required in the unique key.

Validate In
The level at which the constraint is to be implemented:  client (application level only), server (database level only) or both.

Update?
Indicates whether or not the unique key can be updated.

Defer Status?
Indicates whether validation of the constraint is to be deferred until the end of the transaction, until the end of each DML statement, or is not to be deferred.

Error Message
A user-defined error message that is issued instead of the default error message when data is entered that violates this constraint.

Exceptions Table
The name of the table, view or materialized view in which exceptions to this constraint are written.

Column
The name of the column that is defined as the unique key, or which forms part of the unique key.

Datatype
The defined datatype for the column.

Length
The maximum length of the data that the column can contain.

Allow Nulls
Indicates whether the column can contain null values. If the value is Yes, the column is optional and can therefore contain null values.

Comment
A brief comment about the column.

Foreign Key Constraint
Foreign Key Name
The name of the foreign key for the specified table.

Join Table
The name of the table that is to be joined to the table owning the constraint.

Complete?
Indicates whether the constraint is ready to be generated by the Server Generator.

Enable?
Indicates whether the constraint is to be enabled or disabled when the table is generated on the database.

Mandatory?
Indicates whether a value is required in the foreign key. If the value is Yes, the foreign key is mandatory and cannot contain null values.

Transferable?
Indicates whether any items that are based on the foreign key can be updated in a generated application, such as a form.

Validate In
The level at which the constraint is to be implemented e.g.,  client (application level only), server (database level only) or both.

Defer Status?
Indicates whether validation of the constraint is to be deferred until the end of the transaction, until the end of each DML statement, or is not to be deferred.

Error Message
A user-defined error message that is issued instead of the default error message when data is entered that violates this constraint.

Exceptions Table
The name of the table, view or materialized view in which exceptions to this constraint are written.

Cascade Delete
Indicates the action taken following an attempt to delete a related row in the join table.

Cascade Update
Indicates the action taken following an attempt to update a related row in the join table.

Arc Number
A number that identifies an arc in which the foreign key is located.

Arc Mandatory?
Indicates whether or not the arc is mandatory.

Column
The name of the column that is defined as the foreign key, or which forms part of the foreign key.

Datatype
The datatype defined for the column.

Length
The length of the data contained in the foreign key column.

Allow Nulls
Indicates whether the column can contain null values. If the value is Yes, the column is optional and can therefore contain null values.

Join Column
The name of the column in the join table that is the derivation for all, or part of, the foreign key.

Domain Constraint
Domain Constraint Name
The name of the domain constraint that applies to the listed table.

Join Table
The name of the table to which the current table is to be joined via the constraint.

Complete
Indicates whether the constraint is ready to be generated by the Server Generator.

Mandatory?
Indicates whether a value is required by the constraint.

Transferable?
Indicates whether any items that are based on the constraint can be updated in a generated application, such as a form.

Validate In
The level at which the constraint is to be implemented e.g.,  client (application level only), server (database level only) or both.

Defer Status?
Indicates whether validation of the constraint is to be deferred until the end of the transaction, until the end of each DML statement, or is not to be deferred.

Error Message
A user-defined error message that is issued instead of the default error message when data is entered that violates this constraint.

Cascade Delete
Indicates the action taken following an attempt to delete a related row in the join table.

Cascade Update
Indicates the action taken following an attempt to update a related row in the join table.

Column
The name of the column that is defined as the domain constraint, or which forms part of the domain constraint.

Datatype
The datatype defined for the column.

Length
The length of the data contained in the constraint column.

Allow Nulls
Indicates whether the column can contain null values. If the value is Yes, the column is optional and can therefore contain null values.

Join Column
The name of the column in the join table that is the derivation for all, or part of, the domain constraint.

Check Constraint
Check Constraint Name
The name of the check constraint that applies to the listed table.

Complete?
Indicates whether the constraint is ready to be generated by the Server Generator.

Enable?
Indicates whether the constraint is to be enabled or disabled when the table is generated on the database.

Validate In
The level at which the constraint is to be implemented:  client (application level only), server (database level only) or both.

Defer Status?
Indicates whether validation of the constraint is to be deferred until the end of the transaction, until the end of each DML statement, or is not to be deferred.

Error Message
A user-defined error message that is issued instead of the default error message when data is entered that violates this constraint.

Exceptions Table
The name of the table, view or materialized view in which exceptions to this constraint are written.

Enforce When Null?
Indicates whether the check constraint is to be validated by a generated application even if some of the column values are null.

Where/Valid Type
Indicates whether the Where/Validation Condition property for the check constraint defines a Function Call or a SQL Expression.

Comment
A comment about the purpose of the check constraint.

Check Constraint Description
A description of the check constraint, for example, including the SQL statement that checks the validity of the data.

Check Constraint Notes
Notes about the check constraint.


Complete Status Quality Control report

This report highlights any problems with the definition completeness of databases and their objects. The report is divided into the following sections:

•	database objects defined as complete but which are defined on objects that are not defined as complete (not ready to be generated by the Server Generator)

•	database objects defined as not complete

•	database objects defined as complete but which have not yet been granted to any database users or group of users

Report filename

CDCRSQC

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Information included in the report

The report is divided into three sections, as described above. Note that the complete status typically appears as the value of the Complete? parameter for the object in the Property Palette of the Design Editor or Repository Object Navigator.

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Objects with a complete status of 'Y' which are defined on objects with a complete status of 'N'
Users with create status of 'Y' granted roles with a create status of 'N'
Roles with create status of 'Y' granted roles with a create status of 'N'
The first section of the report lists any database objects that are ready to be generated by the Server Generator, but which are defined on objects that are not yet ready to be created.

Database Object Type
The type of database object specified in the next field.

Database Object Name
The name of the database object that is ready to be created (i.e. create status set to Y).

On Object Type
The type of database object specified in the next field.

Database Object Name
The name of the database object that is not yet ready to be created (i.e., create status set to N).

Objects defined with a complete status of 'N'
The next section of the report lists database objects that are not ready to be created.

Database Object Type
The type of database object specified in the next field.

Database Object Name
The name of the database object whose create status is set to N.

Objects with complete status = 'Y' and which have not been granted to any database users or groups
The last section of the report lists database objects that are ready to be created but which have not been granted to any database users or group of users.

Database Object Type
The type of database object specified in the next field.

Database Object Name
The name of the database object that is ready to be created (i.e. create status set to Y).


Database Definition report

This report lists details of the databases (Oracle and other databases) defined within the specified container. It also lists details of the storage used for the databases:  tablespaces, rollback segments, datafiles, log files  and (for Oracle8 databases) directories.

Report filename

CKODB

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Database Type
The database type, that is, Oracle or other databases. If you want the report to contain definitions of both types of database, leave the default value %.

Oracle databases are: Oracle8 and Oracle7.

Other databases are: Rdb (v 7.0, 6.1), DB2/2 and DB2/MVS 4.x, Microsoft SQL Server (v 6.5, 6.0), Sybase System 11and ANSI 92-compliant databases.

Database Name
Mandatory
To restrict the report to a specific database, enter the database name here. You can use % as a wildcard.

Include Storage Details ?
Leave the default value Yes if you want the report to include details of the database tablespaces, rollback segments, datafiles and log files. Choose No if you do not want these details.

Created Start Date
Restricts the report to include only database definitions created after this date.

Created End Date
Restricts the report to include only database definitions created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only database definitions changed after this date.

Changed End Date
Restricts the report to include only database definitions changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Database Name
The name of a database for which a definition exists in the container. An asterisk (*) beside the name indicates that the container owns the database definition.

Database Type
The database type (Oracle or other databases). Note that, for Oracle Designer purposes, Oracle Rdb is classed as an other database.

Version
For Oracle databases only, the Oracle version number.

Character Set
For Oracle databases only, the character set that the database uses to store data.

Shared Instances ?
Indicates whether multiple instances can access this database.

Reuse Control File ?
Indicates whether this database should reuse existing control files. When a control file is reused, any information that it already contains is ignored and overwritten.

Complete ?
Indicates whether the database definition is complete (that is, the database is ready to be generated by the Server Generator).

Maximum Instances
The maximum number of instances that can simultaneously mount and open this database.

Max Data Files
The maximum number of database files that can ever be created for this database.

Node
The name of the node where the database is to reside.

TNS Alias
The alias used for the connection path to the database, as defined in the TNSNAMES.ORA configuration file. This alias is used by SQL*Net Version 2.

Archive Redo Files ?
Indicates whether the redo log file can be archived before reuse, thus preparing for possible media recovery as well as instance recovery. The default value No indicates that a redo log file can be reused without archiving its contents. The file can then be used only for instance recovery.

Max. Log History
The maximum number of archived redo log files for automatic media recovery of Oracle with the Parallel Server option.

Connect String
The database alias that users enter to connect to the database via SQL*Net.

Max. Log Files
The maximum number of redo log files that can ever be created for this database.

Max. Log Members
The maximum number of members, or Copies, for a redo log file group.

Public Database Links To/From
These two sections list details of remote databases to which all users of the specified database have access (Links To) or from which all users can access the specified database (Links From).

Database Name
The name of the remote database.

Version
The Oracle Server version of the remote database.

Node
The name of the network node where the remote database resides.

In Communities
This section lists the Transparent Network Substrate (TNS) communities to which the specified database belongs. A TNS community is a group of Servers that can run TNS-based products (e.g., SQL*Net Version 2) and can communicate using one common network protocol.

Name
The name of a TNS community.

Protocol
The network protocol used by this community (for example, TCP/IP, SPX/IX).

Comment
A comment about, or brief description of, the community.

Storage Details
Tablespaces
Name
The name of a tablespace in this database.

Complete ?
Indicates whether this tablespace is ready to be generated by the Server Generator.

Online ?
Indicates whether the tablespace will be available for use immediately after generation. Only those users who have been granted access will be able to use the tablespace.

Read Only?
Where the tablespace design has been recovered from an existing database into the Oracle Designer Repository, a value of No indicates that write operations are allowed on the tablespace.

Temporary?
Indicates whether the tablespace is temporary. A temporary tablespace is used for operations such as sorting, which might require more space than is available in the default tablespace.

Storage Definition
The name of a storage definition for the tablespace, that is, a set of storage parameters that are to be used to define future space allocation for the tablespace.

Rollback Segments
Name
The name of a rollback segment in this database.

Complete ?
Indicates whether this rollback segment is ready to be generated by the Server Generator.

Public ?
Indicates whether the rollback segment is generally available for use by any instance accessing the database.

Tablespace
The name of the tablespace in which the rollback segment is created.

Storage Definition
The name of a storage definition for the rollback segment, that is, a set of storage parameters that are to be used to define future space allocation for the tablespace.

Data files
Log files
Name
The name of a data file or redo log file for this database.

Full Pathname
The complete file specification for the file.

Reuse ?
Indicates whether the database will be permitted to reuse the file.

File Size
The file size.

File Size Unit
The type of file size unit e.g. Kilobytes or Megabytes.

Directories
(Oracle8 only) Lists details of the directories defined for the specified database. A directory is an alias for a directory name on the server file system where binary file LOBs are located.
Name
The name of the directory (that is, the alias).

Complete ?
Indicates whether the directory definition is complete and ready to be used for generation.

Path
The directory name on the server file system to which the alias refers.


Database Objects report

This report provides information about a specified database within a given container, and includes a list of the objects within the database, together with details of which users have access to those objects.

Report filename

CKDBOBJ

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Database Name
Mandatory
To restrict the report to include only objects in a particular database definition, choose the database name from the dropdown list. The default value % includes all database definitions.

Database User
To restrict the report to include only objects to which a particular user has access, choose the username from the dropdown list. The default value % includes all users.

Created Start Date
Restricts the report to include only objects created after this date.

Created End Date
Restricts the report to include only objects created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only objects changed after this date.

Changed End Date
Restricts the report to include only objects changed before this date. Default is today's date.

Information Included in this Report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container Name
The name of the selected container.

Version
The version number of the container.

Database Name
The name of the Oracle database.

Owns Database
Indicates whether or not the specified container owns the listed database.

Node
The name of the machine on which the database is physically located.

ORACLE Version
The Oracle database version number.

Comment
A single line statement or comment about this database.

Database Administration Objects
Object Type
The type of any database administration objects (for example, tablespaces) within the specified container.

Object Name
The name(s) of any database administration objects within the specified container.

Database User
The name of a database user who has access to the database objects shown under "Schema Objects".

Schema Objects
Object Type
The object type.

Object Name
The name of the database objects to which this user has access.


Database Trigger report

This report shows details of the database triggers defined for the specified tables in a particular container. A trigger is a stored PL/SQL program unit associated with a specific database table. The trigger is fired automatically whenever a given SQL operation affects the table.  About

Report filename

CKTRGGER

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Table/View/Materialized View
Mandatory
To restrict the report to a particular table or view choose it from the dropdown list. You can use % as a wildcard. The default value % lists trigger definitions for all tables and views in the specified container.

NOTE: Materialized views and triggers are an invalid combination and will output an empty report. The reason for this is that triggers aren’t supported in materialized views.

Trigger Name
Mandatory
Enter the name of a trigger, or choose one from the dropdown list, to restrict the report to that trigger. You can use % as a wildcard; the default value % reports on all triggers in the container.

Created Start Date
Restricts the report to include only triggers created after this date.

Created End Date
Restricts the report to include only triggers created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only triggers changed after this date.

Changed End Date
Restricts the report to include only triggers changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The name of the specified container.

Version
The version number of the container.

Table/View Name
The name of the specified table for which trigger details are provided.

Trigger
Name
The name of the trigger associated with the specified table.

Create?
Indicates whether or not the trigger is ready to be created in the database.

PL/SQL Module Name
The name of the associated module for this trigger.

Enabled?
Indicates whether or not the trigger should be enabled when it is created in the database.

PL/SQL File
The name of the PL/SQL file in which the code for this trigger is located.

Purpose
The purpose of the trigger.

Trigger Time
Indicates whether the trigger is fired before or after the event specified under event.

Level
The level at which the trigger fires (e.g., ROW or STATEMENT).

Insert?
Indicates that an INSERT statement is to cause the trigger to fire.

Delete?
Indicates that a DELETE statement is to cause the trigger to fire.

Update?
Indicates that an UPDATE statement is to cause the trigger to fire.

New Alias
An alias for the associated table.

Old Alias
An alias for the associated table.

Update Columns
The columns in the associated table that may be updated by the trigger.

Trigger When Condition
The condition that determines when the trigger logic action is to be performed.

Trigger Logic
The underlying PL/SQL code that implements the trigger.


Dataflow Definition report

This report provides details of the dataflows connected to each of the functions, including information about the source, destination and data items.

Report filename

CDDFLOW

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Function Label
Mandatory
Enter the function label for the function(s) for which you want to include dataflow definitions in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Function
The label and short definition of the specified function.

Receives Data Items Via
Dataflow
The name of the dataflow by which the listed function receives data items from elements.

From
The type (e.g., FUNCTION, DATASTORE, EXTERNAL ENTITY) and name of the element from which the function receives data items via the dataflow.

Type
The source type of the dataflow.

Clas'fn
The classification for the dataflow, as assigned by the user, for example Report, Screen, Letter.

Description
A short description of the dataflow.

Data Items
Attribute
The name(s) of any attributes contained in the dataflow.

Entity
The name(s) of any entities described by the attributes.

Other Data Items
The name(s) of any other data items contained in the dataflow.

Provides Data Items Via
Dataflow
The name of the dataflow used by the function to provide data items to elements.

To
The type (e.g., FUNCTION, DATASTORE, EXTERNAL ENTITY) and name of the element to which the function provides data items via the dataflow.

Type
The destination type of the dataflow.

Clas'fn
The classification for the dataflow, as assigned by the user, for example Report, Screen, Letter.

Description
A short description of the dataflow.

Data Items
Attribute
The name(s) of any attributes contained in the dataflow.

Entity
The name(s) of any entities described by the attributes.

Other Data Items
The name(s) of any other data items contained in the dataflow.


Dataflows without Attributes or Data Items report

This report lists all the dataflows in the specified container for which contents have not been defined.

Report filename

CDDFD11

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Source
The source of the dataflow. The source is described as Type : Name. Type is the source type of the dataflow (i.e., function, datastore or external). Name is the name of the dataflow source (i.e., the name of the external, datastore or label of the function).

Dataflow
The name of the dataflow.

Destination
The destination of the dataflow. The dataflow is described as Type : Name. Type is the destination type of the dataflow (i.e., function, datastore or external). Name is the name of the dataflow destination (i.e., the name of the external, datastore or label of the function).


Datastore Definition report

This report contains details about the datastores within the specified container. The report shows the source of the data in the datastores, the functions, attributes and data items to which the datastores provide data, and the names of the dataflows that carry the data. The report also shows details of any attributes or data items that are not used by the datastores.

Report filename

CKDSTOR

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Datastore Name
Mandatory
Enter the name of the datastore you want to include in your report. You can use % as a wildcard.

Created Start Date
Restricts the report to include only datastores created after this date.

Created End Date
Restricts the report to include only datastores created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only datastores changed after this date.

Changed End Date
Restricts the report to include only datastores changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Datastore
The name of the datastore.

Type
The type of the datastore (e.g., Computer, Manual or Transient).

Description
A multi-line text description of the datastore.

Comment
A brief comment about the datastore.

Receives Data Items From

Function
The name of the function from which the specified datastore receives data.

Attributes
The names of any attributes from which the datastore receives data. The entities which the attributes describe are also listed.

Data Items
The names of any data items from which the datastore receives data.

Via Dataflow
The name of the dataflow that carries the data from the listed function to the specified datastore.

Provides Data Items To

Function
The name of the function to which the specified datastore provides data.

Attributes
The names of any attributes to which the datastore provides data. The entities which the attributes describe are also listed.

Data Items
The names of any data items to which the datastore provides data.

Via Dataflow
The name of the dataflow that carries the data from the specified datastore to the listed function.

Unused Attributes
The names of attributes (and their owning entities) for which usages have been defined for this datastore but which do not appear in that datastore.

Unused Data Items
The names of data items for which usages have been defined for this datastore but which do not appear in that datastore.


Datastructure Definition report

This report shows the datastructure definitions for a specified container. A datastructure is a structure such as a PL/SQL Table or Record, which consists of a collection of one or more datastructure items.

Report filename

CKDATDFN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Datastructure Name
Mandatory
To restrict the report to details of a specific datastructure, enter its name here or choose it from the dropdown list. You can use % as a wildcard.

Created Start Date
Restricts the report to include only datastructures created after this date.

Created End Date
Restricts the report to include only datastructures created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only datastructures changed after this date.

Changed End Date
Restricts the report to include only datastructures changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Module

Short Name
The short name of the module in which the datastructure is defined.

Type
The type of PL/SQL definition.

Datastructure

Name
The name of the datastructure.

Type
The type of datastructure (e.g., a PL/SQL Record or PL/SQL Table).

Scope
Indicates whether the datastructure is public or private.

Comment
A brief comment on the usage of the datastructure.

Datastructure Item
The name of the datastructure item. A datastructure item is a field within the datastructure.

Defined By
The type of element on which this datastructure item is based, if it does not have a datatype defined.

Element Name
The name of the element on which this datastructure item is based, if it does not have a datatype defined.

Datatype
The datatype of the datastructure item (e.g., NUMBER, CHAR, DATE), if it is not based on an element.

Length
For certain datatypes, the maximum length of the data that the datastructure item can contain.

Opt. ?
Indicates whether the datastructure item is optional, i.e., whether it can contain null values.

Default
The default value for the datastructure item.


Detailed Element Definition report
Detailed <Element> Definition report

This report shows how the user defined properties of a specified element are used, together with detailed instance data recorded for the element using the User Extensibility facilities of the Repository Administration Utility.

Report filename

CDUEELA

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Element Type
Mandatory
Enter the short name of the element type to be reported. The list box displays a list of the available element types.

Element Name
Mandatory
Enter the name of the element to be reported.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Element Name
The name of the specified element.

Element Type
The type of the specified element. Also displays the audit properties of the element.

Multi-line Text Properties
Shows any multi-line text properties for the specified element.

Associated Elements
Element Type
The type of the associated element.

The Type of the Association
The type of association between the elements.

Element Name
The name of the associated element. Also displays the audit properties of the element.


Document Definition report

This report contains information about a given document, including details of who owns the document, who last changed the document and who authorized the document.

Report filename

CKDOCDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Document Name
Mandatory
Enter the name of the document that you want to include in your report. You can use % as a wildcard.

Created Start Date
Restricts the report to include only documents created after this date.

Created End Date
Restricts the report to include only documents created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only documents changed after this date.

Changed End Date
Restricts the report to include only documents changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Application
The name of the specified container.

Version
The version number of the container.

Document
Name
The name of the document.

Author
The author of the document.

Type
The type of document (e.g., Feasibility Study, Installation Guide).

Status
The status of the document (e.g., Draft, Definitive).

Format
The format of the document (e.g. ASCII, MS Word).

Source Path
The location of the file which contains the document.

Reference
The library reference number or identifier for the document.

Change Control
Version
The version number of the document.

Creation Date
The date on which the document was created.

Date Changed
The date on which the document was last changed.

Changed By
The name of the person who made the last change to the document.

Authorization
Authorization Date
The date on which the document was authorized.

Authorized by
The name of the person or committee that authorized creation of the document.

Comment
A comment or brief description of the document.

References
Element Type
The type of element that the document references.

Name
The name of the element that the document references.

Documentation Text
The text of the document, in multi-line format.


Domain Definition report

This report shows all the details for a domain and any sub-domains in the specified container. You can choose to include a single domain, a selection of domains or all the domains in the container.

Report filename

CKDOMDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Domain Name
Mandatory
Enter the name of the domain you want to include in your report. You can use % as a wildcard.

Created Start Date
Restricts the report to include only domains created after this date.

Created End Date
Restricts the report to include only domains created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only domains changed after this date.

Changed End Date
Restricts the report to include only domains changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Name
The name of the specified domain.

Supertype
The name of the supertype of the domain (if a hierarchy exists).

Description
A brief description of the domain, listing the element which the domain is created from (e.g., column, program data, attribute).

Comment
Comments about the domain.

Attribute Format
The format of any attributes in this domain.

Length
The length of any attributes in this domain.

U.O.M.
The unit of measurement for the attributes in this domain.

Column Datatype
The datatype of any columns, program data, attributes in this domain.

Max Length
The maximum length of any columns, program data, attributes in this domain.

Owned by Container
The name of the container that owns this domain.

Authority
The level of authority needed to update this domain. The default is ANY.

Default Value
The default value for the attributes or columns in this domain.

Null Value
The value that indicates that the attribute or column in the domain is not present for an occurrence of the entity or table.

Derivation
The derivation of attributes within the domain.

Domain Values Value
A valid value for this domain. This field defines the low value if a range of values is defined.

High Value
A high value for the domain, if a range of values is defined.

Abbreviation
An abbreviation or code, commonly used for a value or range of values.

Meaning
The full meaning for the abbreviation.

Domain Validation Rules
Validation rules for use when testing and implementing the system.


<Element> Definition report

This report lists basic details about the definitions of any element types you specify.

Note:	A more detailed version of an element definition is available in the Detailed <Element> Definition report.

Report filename

CKUEELD

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Element Type
Mandatory
Choose the element type you want to include in your report. The element type you choose appears in the report title.

Element Name
Mandatory
Choose the element or elements you want to include in your report. You can use % as a wildcard.

Created Start Date
Restricts the report to include only elements created after this date.

Created End Date
Restricts the report to include only elements created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only elements changed after this date.

Changed End Date
Restricts the report to include only elements changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Name
The full name of the element.

Property Description
Shows the description of user defined properties for the element type. Also shows when the property was created or last changed.

Property Value
Shows the value of user defined properties. Also shows the name of the user who created or last changed the property.

Comment
A comment about or brief description of the element.

Description
A multi-line text description of the element.

Notes
Multi-line text notes about the element.


Elements and their Application Systems report
Elements and their Containers report

This report lists the names and descriptions of elements for the specified element type. The containers that use these elements are also listed.

Report filename

CDAPPLG

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Element Type
Mandatory
Enter the element type you want to include in your report.

Element Name
Mandatory
Enter the element name you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Element Type
The specified element type.

Element Name
The specified name and pathname of the element.

Description
A textual description of the purpose of the element.

Container
The name(s) of any containers which use the elements listed. An asterisk (*) beside an container name indicates that the container owns the element.

Vn.
The version number of the container.


Entities and their Attributes report

This report lists all the entities for the specified container, together with details of the attributes describing each entity.

Report filename

CKATTB14

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Entity Name
OtheEnter the name of an entity, or choose one from the dropdown list, to restrict the report to that entity. You can use % as a wildcard; the default value % includes all entities in the container.

ER Diagram
To restrict the report to entities that appear on a particular entity relationship diagram, enter the name of the diagram here or choose it from the dropdown list. You can use % as a wildcard.

Created Start Date
Restricts the report to include only entities created after this date.

Created End Date
Restricts the report to include only entities created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only entities changed after this date.

Changed End Date
Restricts the report to include only entities changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Entity Name
The full name(s) of any entities in the specified container.

Attribute Name
The name(s) of any attributes describing the listed entity.

Sequence
The sequence number to be used when displaying the values of this attribute. This information may be used by the Generator Products (for example, for determining the order of values displayed in an option group.

Optional
Indicates whether the attribute is optional.

Format
The format of the attribute.

Length
The length of the attribute.

Dec Pl
The number of decimal places allowed for this attribute.

Attribute Description
A description about the attribute.

Attribute Notes
Any notes or comments about the attribute.


Entities, Synonyms and their Application Systems report
Entities, Synonyms and their Containers report

This report lists the different containers in which a specified entity occurs and the synonyms for that entity.

Report filename

CDAPPL2

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer..

Other parameters are:

Entity Name
Mandatory
Enter the name of the entity you want to include in your report, or choose one from the dropdown list. You can use % as a wildcard; the default value % includes all entities in the container.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Entity Name
The name of the specified entity. An asterisk (*) beside the entity name indicates that the specified container owns the entity.

Container
The name of the container(s) in which the specified entity occurs or is referenced from.

Vn.
The version number of the container.

Synonyms
A list of any synonyms used for the specified entity in the container.


Entity Definition report

This report contains details for entities in the specified container. You can choose whether the report is to include a single entity or a selection of entities. The details include the synonyms, description, attributes, relationships and unique identifiers for each specified entity.

Report filename

CKENTDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Entity Name
Mandatory
To restrict the report to details of a specific entity, enter its name here. You can use % as a wildcard.

Include Notes?
Choose No if you do not want the report to include any multi-line text notes recorded for the entity, otherwise leave the default value Yes.

ER Diagram
To restrict the report to details of entities that appear on a particular entity relationship diagram, enter the name of the diagram here or choose it from the dropdown list, otherwise leave this field blank. You can use % as a wildcard.

Created Start Date
Restricts the report to include only entities created after this date.

Created End Date
Restricts the report to include only entities created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only entities changed after this date.

Changed End Date
Restricts the report to include only entities changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Entity

Name
The full name of the entity.

Short Name
The short name or synonym for the entity.

Plural Name
The format used for the plural of the entity name.

Notes
Any additional information about the specified entity.

Sub-type of
If the entity has any super-types, this field will contain the name of the super-types.

Initial Volume
The initial volume of the entity.

Maximum Volume
The maximum volume of the entity.

Average Volume
The average volume of the entity.

Annual Growth (%)
The percentage annual growth of the entity.

Description
A short description of the entity.

Attributes
Details of the attributes defined for the specified entity.

Notes
Additional information about the attributes.

Name
The name of the attribute. An asterisk (*) beside an attribute name indicates that the attribute is part of the primary unique identifier.

Domain
The name of the domain which the attribute belongs to.

Opt
The optional field indicates whether the attribute is optional.

Format
The format definition of the attribute.

Length
The maximum length allowed for this attribute.

Relationships
The relationships defined for the specified entity are described using the following format:

Each Occurrence of this Entity:
Degree of relationship at the first end of the relationship
Name of the relationship
Degree of relationship at the second end of the relationship
Name of the entity at the second end of the relationship

Unique Identifiers
This section provides details of any unique identifiers defined for the entity.

Name
The name of the unique identifier.

Primary ?
Indicates whether this is the primary unique identifier for this entity.

Attrib. Name
The name of an attribute that is used by the unique identifier.

Relationship
The name of a relationship that is used by the unique identifier.

To Entity Name
The name of the entity at the other end of the relationship that is used.


Entity to Table Implementation report

This report provides, for a specified application, a list of the entities and the tables that implement the entities, and a list of the tables and the entities that each table implements.

Report filename

CDTENTS

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Entity Name
Enter the name of the entity you want to include in your report, or choose one from the dropdown list. You can use % as a wildcard; the default value % includes all entities in the container.

Table Name
Enter the name of the table you want to include in your report, or choose one from the dropdown list. You can use % as a wildcard; the default value % includes all tables in the container.

Column Details
Leave the default value Yes if you want the report to include details of columns in the specified tables, otherwise choose No.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

The first section of the report lists the entities and the tables that implement each entity.

Entity Name
The name(s) of any entities in the specified application.

Table Name
The name(s) of any tables which implement the listed entity. If the Column Details parameter is set to Yes, the column names for each of these tables are also listed.

Source Attribute
If the Column Details parameter is set to Yes, this shows the name of any entity attribute on which the corresponding column is based.

Design Comment
The designer's comment on the table/entity implementation. The second section of the report lists the tables and the entities that each table implements.

Table Name
The name(s) of any tables in the specified application.

Entity Name
The name(s) of any entities implemented by the listed table.

Design Comment
The designer's comment on the table/entity implementation.


File and Field Definitions for a Given Record report

This report consists of file and field definitions that are used by the specified container for the selected record.

Report filename

CDREC1

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Record Name
Mandatory
Enter the name of the record you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Record Name
The name of the record. A hash (#) beside the record name indicates that the record is owned by the specified container.

File Name
The name of the file which holds the record.

Level
Specifies the level of the field listed under Field Name.

Field Name
The name(s) of any fields which belong to the listed record.

Storage Format
The format of the listed field.

Length
The maximum length of the listed field.


File Definition report

This report contains brief details of the files that are used in the specified container.

Report filename

CKFIL

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Filename
Mandatory
Enter the name of the file you want to include in your report. You can use % as a wildcard.

Created Start Date
Restricts the report to include only files created after this date.

Created End Date
Restricts the report to include only files created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only files changed after this date.

Changed End Date
Restricts the report to include only files changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

OS File Type
The operating system file type.

For Record Files
Recordfile Name
The name of the file that is used by the specified container. An asterisk (*) beside the file name indicates that the listed container owns this file.

File Organization
The organization type of the file (i.e., Indexed, Relative or Sequential).

RC File Type
The record file type.

Access Method
The method used for accessing the file.

Comment
Any notes or comments about the file.

For Source Files
Source File Name
The name of the file that is used by the specified container. An asterisk (*) beside the file name indicates that the listed container owns this file.

Scr File Type
The source file type.

Remark
Any remarks about the file.

DB File Type
The database file type e.g., datafile or logfile.

Dbfile Name
The name of the file that is used by the specified container. An asterisk (*) beside the file name indicates that the listed container owns this file.

Comment
Any comments about the file.

Reuse?
Indicates whether the current file can be reused.

Tablespace
The tablespace which is the parent of the datafile.

Database
The database in which the file exists.

PACfile Type
The PAC file type.

PACfile Name
The name of the file that is used by the specified container. An asterisk (*) beside the file name indicates that the listed container owns this file.

Kind
An indication of how the file is stored in the repository.

Description
A description of the file.


Record File, Record and Field Definitions report

This report contains a list of all the record files, and their records and fields, in the specified container. A record file is a file that is used to reference rows.

Report filename

CDFILE1

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Filename
Mandatory
Enter the name of the record file or files you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

File
The name of the record file. A hash (#) beside the file name indicates that the file is owned by the listed application.

Record
The name of a record held by the listed file. An asterisk (*) beside the record name indicates that the record is owned by the specified container.

File Container
The name of an container that uses the listed file.

Level
Specifies the level (e.g. as in COBOL - 88, 01, 02 etc.) of the field shown in the Field Name column.

Field
The name of a field belonging to the listed record.

Storage Format
The storage format of the field:  BIT, COMPUTATIONAL[-n], DISPLAY, POINTER or USER DEFINED.

Length
The maximum length of the listed field.


Function Definition report

This report contains detailed information about a specified business function in the specified container. You can include details of sub-functions in a function hierarchy. The report also shows the master function label and details for copy functions.

Report filename

CKFDEFIN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Function Label
Mandatory
Choose the function label for the top level function of the decomposition you want to include in your report.

Include Events ?
Leave the default value Yes if you want the report to include details of the events triggered by and triggering the selected functions, otherwise choose No.

Include Usages ?
Leave the default value Yes if you want the report to include details of business unit usages and entity usages by the selected functions, otherwise choose No.

Include Dataflows ?
Leave the default value Yes if you want the report to include details of input and output dataflows for the selected functions, otherwise choose No.

Elementary Functions Only
Mandatory
Choose Yes if you want the report to contain elementary functions only. Default value is No, which reports all leaf functions.

Level of Decomposition
The number of levels of decomposition you want to include in your report. Default value is 15.

Function Hierarchy
The name of a function hierarchy diagram for which the report is to be displayed. This field can be used to restrict the functions listed in the report to those appearing on the diagram(s) specified. You can use % as a wildcard; enter % to include all function hierarchy diagrams in this container.

Created Start Date
Restricts the report to include only functions created after this date.

Created End Date
Restricts the report to include only functions created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only functions changed after this date.

Changed End Date
Restricts the report to include only functions changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Function
The function label.

Parent
The label of the parent function of the listed function.

Elementary ?
Indicates whether the function is elementary (i.e., a function that, if started, must be completed).

Decomposed ?
Indicates whether the function has been decomposed (i.e., broken down) into sub-functions.

Frequency
The frequency with which the function is carried out.

Response
The response required for the function (i.e., immediate or overnight).

Definition
The full name of the function.

Master Description
A description of the master function, if any.

Master Notes/Remarks
Notes about the master function, if any.

Description
A description of the function.

Notes/Remarks
Notes about the function or its definition.

Function Decomposition
The label and short definition of any sub-functions defined for this function.

Events
This section gives details of any events that trigger, or are triggered by, this function.

Triggered By
The labels of any functions which trigger the listed function.

Trigger For
The labels of any functions which this function triggers.

Business Units
The name of any business units that perform this function.

Usage of Entity
The name (or synonym) of any entity which this function uses.

Cre
Indicates whether the function created the listed entity.

Ret
Indicates whether the function can retrieve the listed entity.

Upd
Indicates whether the function can update the listed entity.

Del
Indicates whether the function can delete the listed entity.

Arch
Indicates whether the function can archive the listed entity.

Oth
Indicates whether the function can use the entity in any other user-defined method.

Input Dataflows
Input dataflows specified for this function.

Output Dataflows
Output dataflows specified for this function.


Function Hierarchy report

This report shows the function hierarchy in the specified container.

Report filename

CDFDECOM

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Function Label
Mandatory
Choose the function label for the top level function of the decomposition you want to include in your report.

Level of Decomposition
The number of levels of decomposition you want to include in your report. Default value is 15.

Information included in the report

The label for each function is followed by a function box containing the function short definition. Functions that can be decomposed further are marked with ". . ." above the function box to indicate that there is more detail.

If a function is a copy function, the master function definition is displayed for this function, and the master function's label is listed above the definition box.

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.


Function Hierarchy Summary report

This report displays an indented summary of the function hierarchy in the specified container. Common functions are highlighted and the function label and detail of the master function are also shown in the report.

Report filename

CKFUNRPT

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Created Start Date
Restricts the report to include only functions created after this date.

Created End Date
Restricts the report to include only functions created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only functions changed after this date.

Changed End Date
Restricts the report to include only functions changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Fun Master Label
The label of the master function to which the current function is common.

Fun Name
A description of what the function does.

Fun Short Name
The function label (a unique hierarchic reference for the function). An asterisk (*) beside the function label indicates that this function is a common function (i.e., is a copy of a master function).

Fun Response
The response required of the function (i.e., immediate or overnight).

Fun Frequency
The frequency with which the function is carried out.

Fun Level
The level of the function in the hierarchy. These values are calculated when you run the report. For example a parent node will be shown as level ‘1’, a child node as level ‘2’ and a grandchild node will be shown as level ‘3’.


Function to Attribute Matrix report

This report consists of a table showing the functions, in the specified container, that use attributes and entities. It also shows how each function uses each attribute.

Report filename

CDFATTM

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Function Label
Mandatory
Enter the function label for the function you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Function
The function label.

Definition
A short definition of the function.

Entity
The name(s) of any entities that the specified function uses.

Attribute
The name(s) of any attributes used by the specified function which describe the listed entities.

Insert
Indicates whether the function can insert into the listed attribute.

Retrieve
Indicates whether the function can retrieve the listed attribute.

Update
Indicates whether the function can update the listed attribute.

Nullify
Indicates whether the function can change the listed attribute to null.

Arch.
Indicates whether the function can archive the listed attribute.

Oth.
Indicates whether the function can use the attribute in any other user-defined method.


Function to Entity Matrix report

This report consists of a table showing the functions that exist in the specified container, the entities used by those functions, and how each function uses each entity.

Report filename

CDFENTM

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Function Label
Mandatory
Enter the function label for the function you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Function
The function label.

Definition
A short definition of the function.

Entity
The name of any entity which this function uses.

Create
Indicates whether the function can insert into the listed entity.

Retrieve
Indicates whether the function can retrieve the listed entity.

Update
Indicates whether the function can update the listed entity.

Delete
Indicates whether the function can delete the listed entity.

Archive
Indicates whether the function can archive the listed entity.

Other
Indicates whether the function can use the entity in any other user-defined method.


Functions without Input or Output Dataflows report

This report lists all the functions in the specified container that are not attached to any dataflows.

Report filename

CDDFD2

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Function Label
The function label of any functions that are not attached to any dataflows.

Function Description
A description of the listed function.


Functions/Modules which Use a Given Entity report

This report shows the functions that use a given entity in the specified container and the modules that implement these functions.

Report filename

CDIMAN6

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Entity Name
Mandatory
Enter the name of the entity you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Entity
The name of the specified entity.

C
Indicates whether the function created the specified entity.

R
Indicates whether the function can retrieve the specified entity.

U
Indicates whether the function can update the specified entity.

D
Indicates whether the function can delete the specified entity.

A
Indicates whether the function can archive the specified entity.

O
Indicates whether the function can use the entity in any other user-defined method.

Function
The function label of any functions that use the specified entity.

Definition
The definition of the function listed under Label.

Module
The name(s) of any modules that implement the listed functions.


Role Definition report

This report displays details of the role definitions for a given container. These details include a list of the users (or other roles) who have been granted a particular role, and details of the object access privileges and system privileges which the role confers.

Report filename

CKGRPDFN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Database Name
Mandatory
The name of a database for which the report is to be displayed. This field can be used to restrict the information listed in the report to that appearing in the database(s) specified. You can use % as a wildcard.

Role Name
Mandatory
The name of the role(s) you want to include in your report. You can use % as a wildcard.

Created Start Date
Restricts the report to include only roles created after this date.

Created End Date
Restricts the report to include only roles created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only roles changed after this date.

Changed End Date
Restricts the report to include only roles changed before this date. Default is today's date.

Information Included in this Report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Database Name
The name of the database for which the roles have been defined.

Database Type
The type of database (Oracle or other databases). Note that, for Oracle Designer purposes, Oracle Rdb is classed as an other database.

Role Name
The name of the role.

Comment
A comment or brief description about the role.

Default Password
An initial password to prevent unauthorized use of the privileges assigned to this role.

Complete?
Indicates whether the role is ready to be generated by the Server Generator.

Database Object Privileges
This section shows details of the database object access privileges that this role confers on a user.

Type
The type of object (e.g., table, view) shown under Name.

Database User.Object Name
The name of a database object to which this role grants access, together with the name of the user to whom this access is granted.

All
Indicates whether a user with this role is granted all access privileges for this object.

Select
Indicates whether a user with this role is granted the SELECT privilege for this object.

Insert
Indicates whether a user with this role is granted the INSERT privilege for this object.

Update
Indicates whether a user with this role is granted the UPDATE privilege for this object.

Delete
Indicates whether a user with this role is granted the DELETE privilege for this object.

Index
Indicates whether a user with this role is granted the INDEX privilege for this object.

Alter
Indicates whether a user with this role is granted the ALTER privilege for this object.

References
Indicates whether a user with this role is granted the REFERENCE privilege for this object.

Execute
Indicates whether a user with this role is granted the EXECUTE privilege for this object.

Grant
Indicates whether a user with this role has the authority to grant access privileges for this object to another user or role.

Directory Privileges
This section shows details of the directory access privileges that this role confers on a user.

Name
The name of a directory to which this role grants access.

Create Synonym?
Indicates whether this role confers the CREATE SYNONYM privilege on the user.

All/Select/Insert/Update/Delete/Index/Alter/References/Execute/Grant
These indicate the directory access privileges that this role confers on a user. The privileges are similar to those for database object access, shown above under "Database Object Privileges".

System Privileges
This section shows details of the system privileges that this role confers on a user.

Privilege
The name of a system privilege conferred by this role.

With Admin Option?
Indicates whether a user with this role has the authority to grant this system privilege to another user or role.

Comment
A comment or statement on the granting of privileges to this user or role.

Module Access
This section shows details of the module access rights that this role confers on a user.

Module Short Name
The short name of the module for which a user with this role is granted access.

Module Name
The name of the module for which a user with this role is granted access.

Module Type
The type of module (e.g., menu, library).

With Admin Option?
Indicates whether a user with this role has the authority to grant access privileges for this object to another user or role.

Granted to Database User(s)/Role(s)
This section shows details of the database users, or other roles, to which a role has been granted.

Type
Indicates whether the role is being granted to a database user or to another role.

Name
The name of a database user who has been assigned this role.

With Admin Option?
Indicates whether the user is allowed to grant privileges to another user.


Invalid Database Objects Quality Control report

This report highlights problems with database objects that have been defined in the specified container version. The report is divided into the following sections:

•	database objects whose names are reserved words in PL/SQL or Oracle Designer

•	Oracle database objects which are not defined on an Oracle database

Note:	PL/SQL reserved words are listed in the SQL documentation, such as the SQL Language Quick Reference guide. Oracle Designer reserved words are those listed under RN_RES_NAME in the repository table SDD_RESERVED_NAMES.

Report filename

CDIDOQC

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.Other parameters are:

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Database objects whose names are reserved words in PL/SQL or Oracle Designer
The first section of the report lists all the database objects that have been defined in the repository using names that are reserved words in PL/SQL or Oracle Designer. Errors will occur in the Server when attempting to create these database objects. For example, it is not possible to create a package with the name 'package'.

Object Type
The type of database object  (e.g., table, materialized view) whose name is a reserved word.

Object
The database object name. For SAC elements the name of the owning object is also displayed.

Reserved Word in
Indicates whether the reserved word is a PL/SQL or a Oracle Designer reserved word.


Module Definition report

This report contains full details of the modules that implement functions in the specified container.

Report filename

CKMODPT

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Module Language
Mandatory
Restricts the report to include only modules written in a particular language, which you can choose from the dropdown list. Leave the default value, %, to select all languages.

Module Short Name
Mandatory
Restricts the report to include only the module with the specified short name. You can use % as a wildcard.

Order by Type?
Mandatory
Choose Yes if you want the report to list modules ordered by module type. The default value No orders the modules by the module short name.

Include Candidate?
Choose Yes to restrict the report to include only candidate modules and candidate menu modules, otherwise leave the default value No.

Include Usages?
Choose Yes if you want the report to include details of table and column usages by the module, otherwise leave the default value Yes.   Status
If you want the report to include details of modules whose definition status is either In Progress or Completed, choose the appropriate option from the dropdown list. The default value, Not Started, causes the report to display details of modules for which the definition has not yet been started.

Created Start Date
Restricts the report to include only modules created after this date.

Created End Date
Restricts the report to include only modules created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only modules changed after this date.

Changed End Date
Restricts the report to include only modules changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The name of the selected container.

Version
The version number of the container.

Module
Short Name
The short name of the module.

Name
The full name of the module.

Language
The language in which the module is written.

Type
The type of the module.

Implem'n Name
The name to be used during implementation of the module.

Candidate ?
Indicates whether this is a candidate module.

Status
Indicates whether or not the module design is complete.

Purpose
The purpose or short description of this module.

Project
The name of the project that contains this module.

Activity
The name of the activity that is to implement this module.

Task
The name of the task that is to implement this module.

Size
The estimated size of the module (the size units are user-defined).

Estimate
An estimate of the time required to build the module.

Units
The time units used for estimating the time required to build the module.

Complex
The complexity for this module: Easy, Average or Difficult.

Top Title
The title for the top of each report page or screen, or the title for the menu. This title can be used by Generators.

Bottom Title
The title for the bottom of each report page or screen. This title can be used by Generators.

Description
A description or specification for the module.

Notes
Any additional notes about the module.

Window Summary
This section provides details of the window definitions created for the module.

Name
The name of the window definition.

Scrollable ?
Indicates whether the generated window is scrollable.

Width
The default width of the generated window.

Height
The default height of the generated window.

X Pos.
The default X-coordinate of the generated window.

Y Pos.
The default Y-coordinate of the generated window.

Module Component Summary
This section provides summary details of the various components of the module.

Type
Indicates whether the module component is specific to a single module, or reusable in other modules. Reusable module components can be shared between containers; specific components cannot be shared.

Language
The type of application that is expected to be generated from this module component.

Name
The name of the module component.

Module Level
Indicates whether this is a module-level component, that is, one that is specific to a particular module and which contains only unbound items and not table usages.

Super-Modules
Short Name
The short name of any modules that call the specified module (super-modules).

Module Name
The full name of any super-modules.

Type
The type of any super-modules.

Usage Method
The method by which the module is incorporated into the super-module.

Sub-Modules
Short Name
The short name of any modules that are called by the specified module.

Module Name
The full name of any sub-modules.

Type
The type of any sub-modules.

Usage Method
The method by which the sub-module is incorporated into the current module. An asterisk (*) beside the row of information about a sub-module indicates that the sub-module has sub-modules itself.

Data Usage
This section provides details of table and column usage by the various components of the module.

Module Component
The name of the module component for which the data usages are displayed.

Type
The module component type: specific (to a single module) or reusable (in other modules).

Insert?
Indicates whether new records can be added using this module component.

Update?
Indicates whether records can be updated using this module component.

Delete?
Indicates whether records can be deleted using this module component.

Query?
Indicates whether QUERY operations are allowed using this module component.

Table Name
The name of a table used by the module component.

Column
The name of a column in the table that is used by the module component.

Insert?
Indicates whether users can enter a value in the column when a new record is created.

Update?
Indicates whether users can modify the column value when updating an existing record.

Query?
Indicates whether the column can be used when entering a query condition. Thus it indicates whether users can enter search criteria for the column before executing a query against the module component.

Business Functions Implemented
The name, short definiton and comments on any business units which are implemented by the specified module.

Business Units Implemented
The name, short name and comments on any business units which are implemented by the specified module.

Implemented at Nodes
This section provides details of specific nodes where the module is implemented.

Node
The name of a node where the module is implemented.

Forecast Freq.
An estimate of the frequency with which the node will run the module.

Freq. UOM
The unit of measure for the forecast frequency.

Req. Response
The response required when this node runs the module.

Urgency
A brief note about the urgency of the module run at this node.


Module Documentation report

This report provides details of module definitions within a given container. It also provides details of the tables and columns which the modules use.

Report filename

CKMODDOC

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Module Sub-type
You can restrict the report to include either: module definitions, PL/SQL definitions, or Java definitions. Or you can use the default value % to include all these module definition types.

Module Short Name
Mandatory
Enter the short name of the module you want to include in your report. You can use % as a wildcard.

Include Notes?
Mandatory
Default value Yes includes notes in the report. Choose No to exclude the notes.

Include Help?
Mandatory
Default value Yes includes help text in the report. Choose No to exclude the help text.

Include Description?
Mandatory
Default value Yes includes module descriptions in the report. Choose No to exclude the descriptions.

Include Release Notes?
Default value Yes includes information on the production version of the module. Choose No to exclude this information.

Include Generation History?
Default value Yes includes information on any previous operations to generate the module. Choose No to exclude this information.

Created Start Date
Restricts the report to include only modules created after this date.

Created End Date
Restricts the report to include only modules created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only modules changed after this date.

Changed End Date
Restricts the report to include only modules changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Module Name and Short Name
The full name and short name of the specified module.

Language
The type of application expected to be generated from this module. Only applicable to General Modules (GEM).

Purpose
The purpose of the listed module.

Type
This shows the short name of the listed module type. The types are General Module (GEM), PL/SQL Module (PLM) and Java Module (JAM).

Description
A description for the listed module.

Module Generation History
Information on any previous operations to generate the module.

Notes
Any notes about the listed module.

Release Notes
Information on the production version of the module.

User/Help Text
End-user text or help text for generated applications.

Module Component/Lists Of Values (LOV)
This section provides detailed information about the components and LOVs of the listed module.

Type
Indicates whether the module component or LOV is ‘Specific’ to a single module, or ‘Re-usable’ (and therefore available for use in other modules).

Description
A description of the module component or LOV.

Detailed Table Usage
The name(s) of any tables that the listed module component or LOV uses.

Comment
A comment on how this table is used by the module component or LOV.

Connect By Clause
A SQL "CONNECT BY" clause, used by some of the Generators.

Description
A description of the use of this table by the module component or LOV.

Lookup Validation Where Clause
A SQL "WHERE" clause, used by some of the Generators.

Notes
Any notes about how this table is used by the module component or LOV.

Starts With Clause
A SQL "STARTS WITH" clause, used by some of the Generators.

Validation Where Condition
A WHERE/validation condition to be applied to the table; used by some of the Generators.

Data Bound Items
This section provides details of data bound items, that is, usages of database columns by the module. The information includes the bound item name, the column name and a comment about the use of the item by the module.

Unbound Items
This section provides details of unbound items, that is, items whose value cannot be derived from a single column on a table. The information includes the item name, a comment about the use of the item by the module and a Derivation Expression.


Module Network report

This report shows the hierarchy of modules defined in a specified container.

Report filename

CDMODNET

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Module Sub-type
To restrict the report to include only general module definitions, PL/SQL definitions, or Java definitions choose the appropriate sub-type from the dropdown list. You can use % as a wildcard.

Module Short Name
Mandatory
Enter the short name of the root module for your report. The report shows only those modules which are children, grandchildren, and so on, of this module. You can use % as a wildcard.

Hierarchy Depth (max 15)
The level to which you want the module to be decomposed in the hierarchy. The default (and maximum) number of levels is 15.

Information included in the report

The report lists the full name, short name and the purpose of modules and their sub-modules, and so on.

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.


Module Argument report

This report displays details of the arguments (that is, the parameters) defined for the specified modules. The details include information about the datatype of the arguments, and about the values that are allowed for the arguments.

Report filename

CDPARDFN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Module Sub-type
To restrict the report to include only module definitions or only PL/SQL definitions, choose the appropriate sub-type from the dropdown list. The default value % includes both module definitions and PL/SQL definitions.

Module Short Name
Mandatory
Enter the name of the module you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container Name
The name of the selected container.

Version
The version number of the container.

Module
Module Name
The full name of the specified module.

Module Short Name
The short name of the specified module.

Purpose
The purpose, or a short description, of the specified module.

Argument
Argument Name
The name of an argument defined for the specified module.

Prompt
A short line of text used as a prompt for the argument.

In/Out
An indicator specifying the way in which the argument is used e.g.,  INPUT (argument is passed to but not from the module), OUTPUT (argument is passed from but not to the module) and MODIFY (argument is passed to and from the module, i.e., it is changed by the module).

Display
Indicates whether the argument is to be displayed.

If the argument datatype field is populated:
Datatype
A standard Oracle datatype for the argument.

Length
The maximum number of characters that can be used for the argument value.

Default
The default value for the argument.

If the argument datatype field is null:
Element Name
The name of the element by which the argument is defined.

Defined By Element Type
The element type by which the argument is defined e.g., table, column or domain.

Substitution String
The name of a substitution variable that can be used with the argument. A substitution variable is a variable name and numeral preceded by one or two ampersands (&). A substitution variable can be used in a command file to represent a value provided by the user when running the command file.

Value
An allowable value for the argument. If a range of values is defined, the valid value is the low value.

High Value
The high value for the argument, if a range of values is defined.

Abbreviation
An abbreviation, or short code, for the argument value or the meaning.

Meaning
The full meaning for the abbreviation, or code value, that describes the value or range specified.


Module Program Data report

This report displays details of the program data defined for a specified module. The report describes the program data constructs owned by the specified module, and the program data constructs shared with other modules.

Report filename

CDPGDDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Module Sub-type
To restrict the report to include only general module definitions, PL/SQL definitions, or Java definitions choose the appropriate sub-type from the dropdown list. You can use % as a wildcard.

Module Short Name
Mandatory
Enter the name of the module you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container Name
The name of the selected container.

Version
The version number of the container.

Module Short Name
The short name of the specified module.

Module Name
The full name of the specified module.

Purpose
The purpose, or short description, of the specified module.

Module Type
The type of the module (e.g., REPORT, SCREEN, CURSOR).

Source Path
The full pathname of the runtime file.

Program Data (owned)
Name
The name(s) of any program data constructs defined within and owned by the module.

Type
The type of the program data construct (e.g., CONSTANT, VARIABLE).

Domain
The name of the domain to which the program data construct belongs.

If the program datatype field is populated:
Datatype
The datatype of the program data construct.

Length
The maximum length of the program data construct.

Default
The default value for the program data construct.

If the program datatype field is null:
Element Name
The name of the element by which the program is defined.

Defined By Element Type
The element type by which the program is defined e.g., table, column or domain.

Delimiter
The delimiter used between the program data construct name and value.

Scope
The scope for the program data (i.e., PRIVATE or PUBLIC).

Read
Indicates whether or not the listed module reads the contents of the program data construct.

Write
Indicates whether or not the listed module writes to the contents of the program data construct.

Comment
A comment about the program data construct.

Program Data (shared)
Name
The name(s) of any program data constructs that belong to other modules but which can be used by the current module. Program data constructs must be declared as PUBLIC by the owning module if they are to be shared.

Owned
The name of the container that owns the program data construct used by the current module.

Type
The type of the shared program data construct.

If the program datatype field is populated:
Datatype
The datatype of the shared program data construct.

Length
The maximum length of the shared program data construct.

Default
The default value for the shared program data construct.

If the program datatype field is null:
Element Name
The name of the element by which the program is defined.

Defined By Element Type
The element type by which the program is defined e.g., table, column or domain.

Delimiter
The delimiter used between the program data construct name and value.

Read
Indicates whether or not the listed module reads the contents of the program data construct.

Write
Indicates whether or not the listed module writes to the contents of the program data construct.

Comment
A comment about the program data construct.


Module Program Data Usages report

This report displays all the program data usage details for a module in the specified container. The report displays, for each program data construct, the module that owns the program data construct and any modules that share the program data construct.

Report filename

CDPGDUSG

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Module Sub-type
Mandatory
To restrict the report to include only general module definitions, PL/SQL definitions, or Java definitions choose the appropriate sub-type from the dropdown list. You can use % as a wildcard.

Module Short Name
Mandatory
The short name of the module you want to include in your report. You can use % as a wildcard. Default value, %, lists program data usage details for all the modules in the specified container.

Program Data Name
Mandatory
The name of the program data construct you want to include in your report. You can use % as a wildcard. Default value, %, lists details for all program data constructs.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The name of the specified container.

Version
The version number of the container.

Module Name
The name(s) of the module.

Program Data
The name of the program data construct.

Construct Type
The type of the program data construct (e.g., CONSTANT, VARIABLE).

Datatype
This field will only be populated if the Defined by Element Type/Element Name fields are null. The datatype of the program data construct.

Length
This field will only be populated if the Defined by Element Type/Element Name fields are null. The maximum length of the program data construct.

Defined by Element Type
This field will only be populated if the Datatype/Length fields are null. Shows which type of element defines the program datum (e.g., Table Definition, Domain or Column).

Optional?
Indicates whether nulls are allowed in this program data construct.

Element Name
This field will only be populated if the Datatype/Length fields are null. Shows the name of the element type shown in the Defined by Element Type field.

Assignment Op
The assignment operator to be used between the program data construct and the default value.

Default Value
The default value for the program data construct.

Read
Indicates whether or not the value of the program data construct is read.

Scope
The scope for the program data (i.e., PRIVATE or PUBLIC).

Write
Indicates whether or not a value is to be assigned to the program data construct.

Comment
A comment about the use of this program data construct.

Description
A short description, or the purpose, of the program data construct.

Used in
This section of the report lists the modules that use the program data construct.

Module Name
The full name of the specified module.

Short Name
The short name of the specified module.

Type
The type of the module (e.g. DEFAULT, LIBRARY or PROCEDURE)

R
Indicates whether or not the listed module reads the contents of the program data construct.

W
Indicates whether or not the listed module writes to the contents of the program data construct.

Note:	An asterisk (*) by the side of the module usage entry indicates that the program data construct is owned by the module.


Modules in an Application System report
Modules in an Container report

This report consists of a summary of all the modules in the specified container. The information includes the filename, task, estimate and purpose for each module.

Report filename

CDMOD2

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Short Name
The short name(s) of any modules in the specified container.

Module
The full name(s) of any modules in the specified container. An asterisk (*) beside the module name indicates that the container owns the specified module.

Task
The name of the task that is to implement the listed module.

Estimate
An estimate of the time required to build the module.

Purpose
The purpose or short description of this module.

Complete
Indicates whether or not the building of the module is complete.


PL/SQL Module Definition report

This report lists details of one or more PL/SQL module definitions.  About

Report filename

CKPKGDFN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Module Short Name
Mandatory
To restrict the report to a specific PL/SQL module, enter its name here. You can use % as a wildcard. The default value % reports on all PL/SQL modules defined in the selected container.

Include Candidate?
Choose Yes to restrict the report to include only candidate modules and candidate menu modules, otherwise leave the default value No.

Status
If you want the report to include details of modules whose definition status is either In Progress or Completed, choose the appropriate option from the dropdown list. The default value, Not Started, causes the report to display details of modules for which the definition has not yet been started.

Include Cursors ?
If you want the report to include details of PL/SQL cursors that have been defined, leave the default value Yes, otherwise choose No.

Include Usages ?
If you want the report to include details of the business functions and business units implemented by the PL/SQL module leave the default value Yes. Choose No to omit these details.

Created Start Date
Restricts the report to include only modules created after this date.

Created End Date
Restricts the report to include only modules created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only modules changed after this date.

Changed End Date
Restricts the report to include only modules changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

PL/SQL Module
Short Name
The short name of the specified PL/SQL module. This property is used as the basis for naming generated files and objects.

Name
The full name of the module.

Type
The type of PL/SQL definition e.g.,  Cursor, Function, Package, Procedure or Trg-Logic.

Implementation Name
The name to be used during implementation of the module.

Purpose
The purpose, or a short description, of the module.

Oracle Object Type
Identifies the Oracle object type for which a type body is implemented by this PL/SQL definition.

Type Member Ordering
Indicates whether the object type body defined by this PL/SQL definition has a Map or an Order member function. These functions are used in comparing and ordering object types.

Scope
Indicates if other objects have access to this PL/SQL module definition e.g., Private or Public.

Status
Indicates whether the design of this definition is complete. Possible value are Not Started, In Progress or Completed.

Candidate
Indicates whether the module is a candidate module.

Return Type (Scalar)
The datatype of the value returned by the function.

Return Type (Object)
The datatype of the value returned by the member function.

Project
The name or code of the project that uses this definition.

Activity
The name or code of the activity that is to implement this definition.

Task
The name or code of the task that is to implement this definition.

Size
The estimated size of the definition (size units are user-defined).

Estimate
An estimate of the time needed to complete the definition.

Units
The units of time in which the above estimate is measured.

Complex
The complexity of the module definition:  Easy, Average or Difficult.

Write No Database State ?
Indicates whether the module is prevented from modifying database tables.

Read No Database State ?
Indicates whether the module is prevented from querying database tables.

Write No Package State ?
Indicates whether the module is prevented from modifying packaged variables.

Read No Package State ?
Indicates whether the module is prevented from querying packaged variables.

Is Part of
If the current module is a child module, this shows the name(s) of the parent module(s) (module(s) calling or including the current module).

Program Data
This section gives details of program data constructs (variables, constants and user-defined exceptions) defined for PL/SQL definitions and modules.

Name
The name of a program data construct defined within the specified PL/SQL module.

Type
The type of program data construct:  Constant, Exception or Variable.

Defined by Element Type
The element type of an element that defines this program data construct.

Element Name
The name of an element that defines this program data construct.

Datatype
The datatype of the program data construct.

Length
The maximum length of data that the program data construct can contain.

Scope
The scope of the program data construct (i.e., PRIVATE or PUBLIC).

Cursors
This section gives details of cursors defined for the specified PL/SQL module. A cursor is a PL/SQL construct used to name a SQL work area and access its stored information.

Cursor Name
The name of a cursor defined for the module.

Cursor Arguments
This section gives details of arguments defined for the cursor shown. Arguments are parameters that control which data is used when the module is run.

Argument Name
The name of a cursor argument.

Input/Output
Identifies how the parameter is to be used e.g., Input, Modify or Output.

Defined by Element Type
The element type of an element that defines this cursor argument.

Element Name
The name of an element that defines this cursor argument.

Datatype
The datatype of the cursor argument.

Length
The maximum number of characters in the value of the cursor argument.

Arguments
This section gives details of arguments defined for the PL/SQL module. Arguments are parameters that control which data is used when the module is run.

Argument Name
The name of an argument (that is, a parameter) defined for the specified PL/SQL module.

Input/Output
Identifies how the parameter is to be used:  Input (parameter is passed to, but not from, the module), Modify (parameter is changed by the module) or Output (parameter is passed from, but not to, the module).

Defined by Element Type
The element type of an element that defines this argument.

Element Name
The name of an element that defines this argument.

Datatype
The datatype of the argument.

Length
The maximum number of characters in the value of the argument.

Datastructures
This section gives details of datastructures defined for the PL/SQL module. A datastructure defines additional PL/SQL composite datatypes.

Datastructure Name
The name of a datastructure in the specified PL/SQL module.

Type
The composite datatype of the datastructure, e.g. PL/SQL Record or PL/SQL Table.

Comment
A comment, or short description, about the usage of the datastructure defined for the PL/SQL module.

PL/SQL Block
Defines in full the public declarations of subprograms and cursors listed in the package specification.

Package Specification
For modules of type Package, declares public functions, procedures, cursors, variables, constants and user-defined datatypes that can be accessed by subprograms and triggers outside the package.

Called Modules
PL/SQL Module Type
The type of the called PL/SQL module e.g., cursor, function

PL/SQL Module Name
The name of the called PL/SQL module.

Business Function Implemented
This section provides details of business functions implemented by the specified PL/SQL module (that is, details of module function usages defined for the PL/SQL module). Details include the function label, short definition and any design comments about the implementation of the function by the module.

Business Units Implemented
This section provides details of business units implemented by the specified PL/SQL module (that is, details of  module business unit usages defined for the PL/SQL module). Details include the business unit short name, name and any design comments about the implementation of the business unit by the module.


Quality Checking of Relationships report

This report selects all the relationships in the specified container that are non-standard (e.g., many-to-many, or one-to-one). The selection includes any involuted relationships that would be implemented as an infinite hierarchy.

Note:	Intersection tables are created by the Database Design Wizard for many-to-many relationships.

Report filename

CDACC1

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Relationship
All the relationships that are non-standard are described using the following format:

•	Each occurrence of the entity:

•	Degree of relationship at the first end of the relationship:

•	Name of the relationship:

•	Degree of relationship at the second end of the relationship:

•	The plural value of the entity at the second end of the relationship:

Message
An explanation about why the listed relationship is non-standard.


Sequence Definition report

This report lists details of sequence definitions in the specified container.

Report filename

CKOSQ

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Oracle Sequence Name
Enter the name of the sequence definition you want to include in your report. You can use % as a wildcard.Created Start Date
Restricts the report to include only sequences created after this date. Created End Date
Restricts the report to include only sequences created before this date. Default is today's date.Changed Start Date
Restricts the report to include only sequences changed after this date.Changed End Date
Restricts the report to include only sequences changed before this date. Default is today's date.Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Sequence
The name of the sequence. An asterisk (*) beside the sequence name indicates that it is owned by the container.

Database
The name of the database for which the sequence has been implemented.

Increment
The number by which the listed sequence is incremented.

Cycl
Indicates whether the listed sequence is cyclical (i.e., whether the sequence numbers are re-used).

Order
Indicates whether the sequence numbers should be generated in the order of the request.

Cache Order
The pre-allocation of sequence numbers that can be cached in the memory.

Minimum
The minimum value that the sequence will generate.

Maximum
The maximum value for the sequence.

Start Seq At
The number at which the sequence will start.

Comment
A short description of the sequence.


Materialized View/View Definition report
View/Materialized View Definition report

This report shows details of materialized views and views, together with their columns and their column derivations, within the specified container.

Report filename

CKVWDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Materialized View Name
The name of the materialized view you want to include in your report. You can use % as a wildcard; the default value % includes all materialized views in the container.

View Name
The name of the view you want to include in your report. You can use % as a wildcard; the default value % includes all views in the container.

Materialized Views ?
Leave the default value Yes if you want to include materialized views in the report, otherwise choose No.

Views ?
Leave the default value Yes if you want to include views in the report, otherwise choose No.

Created Start Date
Restricts the report to include only materialized views or views created after this date.

Created End Date
Restricts the report to include only materialized views or views created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only materialized views or views changed after this date.

Changed End Date
Restricts the report to include only materialized views or views changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The name of the specified container.

Version
The version number of the container.

View Name
The name of the materialized view or view.

Alias
The alias for the materialized view or view name.

Type
This will be either a ‘View’ or ‘Materialized View’ definition.

Object Type
The name of the Object Type the view is based on.

Updatable ?
For materialized views only, indicates whether INSERT, UPDATE and DELETE statements can be performed.

Column Prefix
For views only, a prefix for columns in the view. The column prefix is used by the Server Generator when generating the column names that are to be implemented on the database.

Display Title
The default title that Generator products can use to label the part of the application that is based on this materialized view or view. For example, generated forms show block titles, generated reports show group titles and generated Visual Basic applications show prompts or captions.

Comment
A comment about the materialized view or view.

Free Format Select Text?
Indicates whether tables on which the materialized view or view is to be based are defined using a free format SELECT statement, enabling complex queries to be defined.

Select Text
The SELECT statement that specifies the base tables and columns from which the materialized view or view is derived.

Optimizer Hint Clause Text
A hint clause used by the optimizer where the materialized view or view is defined declaratively. The optimizer uses the hint to choose an execution statement plan for the SQL statement.

Where/Validation Condition
A restriction or join condition for the materialized view or view, specified in a WHERE clause. This clause defines a condition on the SELECT statement that defines the materialized view or view. This condition must be met in order for rows resulting from the query to be returned.

Base Table Name
The name of the table from which the materialized view or view is derived.

Alias
An alias for the materialized view or view. This alias can be used to qualify columns in the SELECT and WHERE clause.

Used in Sub-Query?
Indicates that the relation definition referred to by the materialized view or view is used within a sub-query of the WHERE clause.

View Column
The name of a column within the materialized view or view.

Datatype
The datatype defined for the column.

Avg
The estimated average length of data that can be stored in this column.

Max
The maximum length of data that can be stored in this column.

Dp
The number of decimal places allowed for the column.

Base Column
The name of the column in the base table on which the materialized view column or view column is based.

Base Table
The name of the table to which the base column belongs.

Expression
The derivation expression. This is the SELECT statement that specifies the derivation of the column's value, where it is a product of other columns in the same row.


Storage Definition report

This report lists details of the storage definitions within the specified container. A storage definition is a named set of storage parameters for use in the STORAGE clause of a SQL statement when creating or modifying database objects.

Report filename

CDOSP

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Storage Definition Name
Mandatory
Enter the name of the storage definition. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Storage Definition
Name
The name of a storage definition. An asterisk (*) beside the storage definition name indicates that it is owned by the specified container.

Comment
A single line statement or comment on this storage definition.

Unlimited?
Shows whether the Storage Definition is unlimited or not. Possible values are Yes or No.

Extents
Initial Extent
The size of the first extent that will be allocated when the object is created (i.e., the original amount of space allocated to the object).

Initial Extent Unit
The units in which the initial extent size is expressed.

Next Extent
The size of every subsequent extent allocated.

Next Extent Unit
The units in which the next extent size is expressed.

Minimum Extents
The initial number of extents allocated (i.e., the total number of extents allocated when the segment is created).

Maximum Extents
The total number of extents that can be allocated at any time. This total includes the first extent.

Percentage Increase
The percentage by which each following extent will grow over the last extent allocated.

Freelists
Freelist Groups
The number of groups of free lists for a table, cluster or index.

Freelists
The number of free lists for each of the free list groups for a table, cluster or index.


Database Synonym Definition report

This report shows details of the database synonyms defined for objects in the specified container.

Report filename

CKSYNDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Created Start Date
Restricts the report to include only synonyms created after this date.

Created End Date
Restricts the report to include only synonyms created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only synonyms changed after this date.

Changed End Date
Restricts the report to include only synonyms changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The name of the specified container.

Version
The version number of the container.

Object Type
The database object type (PL/SQL, sequence, materialized view, table or view) to which the synonym refers.

Object Name
The name of the database object that has this synonym.

Database Synonym
The name of the synonym.

Scope
Indicates whether the synonym is public or private.

Complete ?
Indicates whether the definition of the synonym is complete and ready to be used by the Server Generator.


System Glossary report

This report combines the descriptions of the entities and terms in a specified container to produce a comprehensive system glossary. The report includes all the entities, their descriptions and, if requested, their synonyms and short names.

Report filename

CKGLOSS

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Include Short Names?
Mandatory
Default value Yes includes the entity short names in your report. Choose No to exclude entity short names.

Include Terms?
Default value Yes includes the synonyms for business terminology in your report. Choose No to exclude the business terminology synonyms.

Created Start Date
Restricts the report to include only entities or terms created after this date.

Created End Date
Restricts the report to include only entities or terms created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only entities or terms changed after this date.

Changed End Date
Restricts the report to include only entities or terms changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Type
The type of the entities and terms listed under Name.

Name
The name(s) and synonyms of any entities or terms within the specified container. Any synonyms and short names of entities (if requested) will also be listed.

Description
A description of the listed entities and terms. Also the name(s) and description(s) of any synonyms of the entities or terms.


Table Definition report

This report contains details of tables, views and materialized views in the specified container. The information includes descriptions, volumes, column details and indexes.

Report filename

CKTCI

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Table/View/Materialized View
Mandatory
The names of the tables, views and materialized views you want to include in your report. You can use % as a wildcard.

Tables?
Mandatory
Specifies whether you want to include information about tables in the report. Default value is Yes; choose No to exclude table information.

Views?
Mandatory
Specifies whether you want to include information about views in the report. Default value is No; choose Yes to include view information.

Materialized Views?
Mandatory
Specifies whether you want to include information about materialized views in the report. Default value is No; choose Yes to include materialized view information.

Column Details?
Mandatory
Specifies whether you want to include detailed information about columns in the report. Default value is No, meaning that only a column summary is included; choose Yes to include detailed column information as well.

Data Structure Diagram
The name of a data structure diagram for which the report is to be displayed. This field can be used to restrict the information listed in the report to that appearing on the diagram(s) specified. The wildcard % can also be used.

Created Start Date
Restricts the report to include only tables, views and materialized views created after this date.

Created End Date
Restricts the report to include only tables, views and materialized views created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only tables, views and materialized views changed after this date.

Changed End Date
Restricts the report to include only tables, views and materialized views changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Table/View/Materialized View Name
The name(s) of any tables, views or materialized views in the specified container.

Alias
A unique alias for the table, view or materialized view name.

Display Title
The display title for a table or view. This information can be used by Generator products.

Object Type
The Oracle object type on which the table is based.

Comment
A comment about the element.

Description
A multi-line text description of the element.

Volumes
Start Rows
An estimate of the number of rows that will be inserted into the table.

End Rows
An estimate of the maximum number of rows that the table will hold.

Storage
Index Organized?
Indicates whether this is an "index organized" table.

Cluster
The name of the cluster in which data from the table or materialized view is implemented.

Column Summary
A summary of the column definitions for the columns in this table. Information includes sequence number, column name, whether null values are allowed, and the datatype for the column.

Primary Key
The name and column identifier for the primary key for this table.

Other Unique Keys
The name and column identifier for other unique keys for this table.

Foreign Keys
Details of foreign keys for this table.

Check Constraints
Details of any check constraints that apply to the listed table.

Index Summary
Details of any indexes defined for this table, including index name, sequence, column(s) quoted and whether the index is to be used to maintain uniqueness.

Column Detail
Detailed information about the columns in the table, view or materialized view, including optionality, datatype, maximum length, number of decimal places, whether column values are stored in uppercase characters, and any comments entered for the columns.


Tables and Primary Key Derivations report

This report lists all the columns for a specified table, view or materialized view, and provides primary/foreign key details where applicable.

Report filename

CDKEYS2

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Table/View/Materialized View
Mandatory
The name of the table, view or materialized view you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Table Name
The name of the specified table, view or materialized view.

Seq
The number used to order the columns in the table, view or materialized view.

Column Name
The name(s) of any column(s) for the specified table(s), view(s) or materialized view(s). A number before the column name indicates that the sequence number is used in the primary key.

Column derived from
The name of the column in the join table that is the derivation for all or part of the foreign key. The column is displayed in the form TABLE.COLUMN.


Tables, Columns and Foreign Key Derivations report

This report lists all the columns for a specified table, and provides foreign key details where applicable.

Report filename

CDKEYS1

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Table Name
Mandatory
The name of the table(s) you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Table Name
The name of the specified table.

Seq
The number used to order the columns in the table.

Column
The name(s) of any columns for the listed table.

Column derived from
The name of the column in the join table that is the derivation for all or part of the foreign key. The column is displayed in the form TABLE.COLUMN.

Foreign Key
The foreign key of the specified table.


Database User Definition report

This report contains details of database users defined in a specified folder. The details include a list of all the access privileges granted for the user on database objects, a list of modules to which the user has access, details of tablespace quotas for the user, and information on system privileges and roles granted to the user.

Report filename

CDUSRDFN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Database Name
The name of a database for which the report is to be displayed. This field can be used to restrict the information listed in the report to that appearing in the database(s) specified. You can use % as a wildcard.

Database User
The name of the database user you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Database Name
The name of the database for which the users have been defined.

Database Type
The type of database (Oracle or other databases). Note that, for Oracle Designer purposes, Oracle Rdb is classed as an other database.

User Name
The name of the specified database user.

Initial Password
The password defined for the user.

Database Profile
The set of limits on database resources that apply to the user.

Comment
Any comments, or additional notes, about the database user.

Complete ?
Indicates whether the database user is ready to be generated by the Server Generator.

Default Tablespace
The name of the default tablespace for the user.

Temporary Tablespace
The name of the temporary tablespace for the user. The temporary tablespace is used for operations (such as sorting) that might need more space than is available in the default tablespace.

Database Objects
This section lists the database objects whose definitions are to be implemented for the specified user.

Type
The type of the object (e.g., view, record, sequence).

Name
The name of the object to be implemented for this user.

Comment
A comment, or statement, about the object.

Database Object Grants
This section lists the database objects that have been granted to the specified user.

Type
Indicates whether the grant is to a user or a role.

Name
The name of the database user who owns the object for which access has been granted.

Comment
A comment, or statement, about the granting of privileges to the specified  user.

All
Indicates whether the specified user has been granted all access privileges for the listed object.

Select
Indicates whether the specified user has been granted the SELECT privilege for the listed object.

Insert
Indicates whether the specified user has been granted the INSERT privilege for the listed object.

Update
Indicates whether the specified user has been granted the UPDATE privilege for the listed object.

Delete
Indicates whether the specified user has been granted the DELETE privilege for the listed object.

Index
Indicates whether the specified user has been granted the INDEX privilege for the listed object.

Alter
Indicates whether the specified user has been granted the ALTER privilege for the listed object.

References
Indicates whether the specified user has been granted the REFERENCE privilege for the listed object.

Grant
Indicates whether the specified user has the authority to grant access privileges for the listed object.

Modules to which the user has access
Module
The name of any modules to which the specified user has access.

With Grant Option
Indicates whether the specified user has grant options on the specified module. Possible values are Y or N.

Tablespace Quotas
Tablespace
The name of any tablespaces to which the specified user has access.

Quota
The number of bytes in the tablespace that the user is allowed.

Units
The unit of quota if the byte default is not used. The allowable values are M (megabytes) or K (kilobytes).

Comment
A comment about this tablespace quota.

System Privileges
Privilege
The type of privilege granted to the specified user.

With Grant Options
Indicates whether the specified user has the authority to grant this privilege to other users.

Comment
Comments on the privilege.

Database User Roles
The name of any role groups to which the listed user belongs.

With Grant Option
Indicates whether the specified user has grant options on the specified user role. Possible values are Y or N.


Association Type Definition report

This report shows the definition for all association types including user extended ones. The property usages are shown with the values for each of the display parameters. Associated element types are also included in the report.

Report filename

CDUEDEF2

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Association Type
Mandatory
Enter the short name of the association type to be reported. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Association Type Name
The name of the specified association type.

Short Name
The short name (abbreviation) of the association type.

Oracle Designer Association Type
Indicates whether the specified association is a standard Oracle Designer Repository association type.

Association Type Structure
The long and short name of the first element type in the association.

Connected to
The long and short name of the second element type in the association.

Property type
The name of the property type being used.

Title
A label for this use of the property.

Datatype
The datatype of the property.

Len
The maximum column length of a property value.

Sca
The number of decimal places of any value this property uses.

Opt
Indicates whether this property is optional.

Upper
Indicates whether the property type name should be in upper case.

Vis
Indicates whether the property is displayed on the instance definition screen (i.e., is visible to the user).

Seq
The sequence in which the properties will appear on the Matrix Diagrammer.

Up
Indicates whether the property can be updated using the Matrix Diagrammer.


Repository User to Application System Access Rights report
Repository User to Container Access Rights report

This report contains the full name and description of a specified repository user, and the access rights granted to that user on different containers and versions of containers.

Report filename

CDACM01

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Repository Username
Mandatory
Enter the username of the repository user whose container access rights you want to include in your report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Repository Username
The name of the specified user.

Description
A description of the repository user.

Container
The name(s) of any containers to which the user has access. An asterisk (*) by a container indicates that it is currently owned by the repository user.

Version
The version number of the specified container.

Access Rights
The access rights granted to the specified user on the listed container.


Element Type Definition report

This report shows the definition for a given element type that has been recorded using the User Extensibility facilities. The property usages are shown with the values for each of the display parameters. The report also lists each association type in which the given element type participates, together with the name of the element type at the other end of the association type.

Report filename

CDUEDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode. AboutThe Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Element Type
Mandatory
Choose the element type to be reported.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Element Type Name
The name of the element type.

Short Name
The short name of the element type.

Ready to be Used
Indicates whether the element type is complete so that you may create instances of this element type.

Oracle Designer Element Type
Indicates whether the specified element is a standard Oracle Designer Repository element type.

Properties
Property Type
The type of property describing the element type.

Title
A label for this specific use of the property.

Datatype
A standard datatype for the property.

Len
The maximum length of the property.

Sca
The scale field specifies the number of decimal places of any value for the property.

Opt
Indicates whether the property is mandatory (i.e., whether or not a value must be entered for the listed property for each instance of this element type).

Upp
Indicates whether or not values for the property must be upper case.

Vis
Indicates whether or not this property is visible on the instance definition screen.

Seq
The number in the sequence field determines the display position of this property on the Matrix Diagrammer.

Upd
Indicates whether or not a value for this property can be updated using the Matrix Diagrammer.

Part of Association Type
The full name and short name of those association types in which the specified element type participates.

Other End of Association Type
The full name and short name of those element types at the other end of the association type.


Activity Based Costing report

This report shows time and cost details on a per-activity basis for a business process model in a specified container.

Activities comprise process steps, stores and flows (in Process Modeler terms), otherwise referred to as business functions, datastores and dataflows.

The main purpose of this report is to highlight the activities in a process that are proportionately the longest, costliest and least productive, and which might therefore be good candidates for improvement.

Report filename

CKABCOST

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Business Process Model
Mandatory
Enter the name of the business process on which you want to report. You can use % as a wildcard; enter % to list the definitions of all business processes in this container.

Hours per Day
The average number of working hours in a day; default is 8.

Days per Week
The average number of working days in a week; default is 5.

Days per Month
The average number of working days in a month; default is 22.

Days per Year
The average number of working days in a year; default is 264.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Diagram
The name of the process diagram illustrating the business process for which the report shows the activity-based costing.

Parent Process
The parent process of the business process that the diagram illustrates.

The next section of the report shows a number of time, cost and other values for each activity in the business process that the diagram illustrates.

Activity
The name of an activity in the diagram.

Total Time
The total duration specified for this activity.

Cost per Unit
The cost rate specified for this activity. This figure takes account of person and overhead costs, but excludes additional costs.

Total Cost
The total cost of performing this activity, calculated from the Total Time and Cost per Unit figures for the activity.

Time%
The percentage of the total process time, for the whole diagram, that is occupied in performing this activity. This field highlights the activities that take proportionately the longest time, and which might therefore be good candidates for improvement.

Cost%
The percentage of the total process cost, for the whole diagram, that is incurred in performing this activity. This field highlights the activities that are proportionately the most expensive, and which might therefore be good candidates for improvement.

Work Time
The work time specified for this particular activity. This is the time taken to do the actual work for the activity, and excludes any time specified for delays or quality checking.

Work Time%
The percentage of the total duration of this activity that is specified as work time. This field highlights the activities that are proportionately the least productive, and which might therefore be good candidates for improvement.

Value
The level of value added to the entire process by performing this activity: High, Medium, Low or None. If no level of added value has been defined for this activity, the word None is also shown. Activities with a value-added level defined as Low or None might be good candidates for improvement.

Organization Unit
The organization unit responsible for performing this activity.

The last section of the report shows totals for time, cost and number of diagram elements.

Total Time
The total duration of the entire process illustrated by the diagram.

Total Cost
The total cost of the entire process illustrated by the diagram.

Total Flows
The total number of flows in the diagram.

Total Process Steps
The total number of process steps in the diagram.

Total Stores
The total number of stores in the diagram.


Business Unit Definition report

This report lists details of selected business units in an container. The report includes details of the elements used by a particular business unit and, optionally, the position of the unit in the business unit hierarchy.

Report filename

CKBUNDEF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Business Unit Short Name

OtheThe short name of the business unit for which you want to list details. You can use % as a wildcard.

Include BU Hierarchy?

OtheLeave the default value Yes to include details of the business unit hierarchy in the report; otherwise, choose No.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Name
The name and any comments on the business unit.

Shortname
The short name of the business unit. A multi-line text description of the business unit is also given if one has been defined.

Business Unit Hierarchy
Shows the position of this business unit in the business unit hierarchy. This is included in the report only if the Include BU Hierarchy? parameter is set to Yes.

Entities Used
The name and description of the entity used by the business unit.

Business Functions Used
The Label and short definition of the business function used by the business unit.

Modules Used
The short name, name and purpose of the modules used by the specified business unit.

Nodes Used
The name and type of the nodes used by the specified business unit.

Notes and Other Text
The contents of any notes or other text defined for this business unit.

Role Skills
Details of any skills possessed by the business unit as a whole, or by individuals within it.


Column Display Usage (by Table) report

This report gives details of all display usages of a specified column in a specified table, view or materialized view.

Report filename

CGRTAB

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Table/View/Materialized View
The name of the table(s), view(s) or materialized view(s) containing the column(s) you wish to include in your report. You can use % as a wildcard.

Column Name
The name of the column(s) you wish to include in your report. You can use % as a wildcard.

Information included in the report

The information for each detailed table usage includes the name, type and other details of the module that has the usage, and whether the usage is of type lookup or base.

The information for each detailed column usage includes the name, type and other details of the module that has the usage.

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Module Component Table Usages
Table
The name of the table that contains the specified column.

Used by Module Component
The name of a module component that uses the specified column.

Type
Indicates whether the module component is specific to a single module, or re-usable and therefore available for use by other modules.

Seq.
Sequence:  the order of the module component with respect to other components in the module.

I
Insert:  indicates whether new records can be added using this module component.

S
Select:  indicates whether query operations are allowed using this module component.

U
Update:  indicates whether records can be updated using this module component.

D
Delete: indicates whether records can be delete using this module component.

Title
The title displayed for this module component in the generated application.

Used in Module
The short name of a module that uses the specified column.

Module Name
The name of a module that uses the specified column.

Type
The way in which the module is expected to be implemented in its specified language.

Usage Type
The type of module component table usage:  base, lookup, sub-query or single-row SQL aggregate.

Bound Items
In the specified table, the name of a column that is used in a data bound item.

Module Component
The name of a module component that uses this column.

Module
The name of the module to which the component belongs.

D
Display:  indicates whether the item is displayed by the generated application.

I
Insert:  indicates whether the user is allowed to enter a value for the column when a new record is created.

S
Select:  indicates whether the item can be used when entering a query condition.

U
Update:  indicates whether the user can modify the column value when updating an existing record.

O
Optional:  indicates whether users need to enter a value for the column.

Datatype
The datatype of the column.

HT
Height:  the number of lines used for the generated item.

Oseq
Order By sequence:  a unique number to determine the order of this column in an ORDER BY clause. Also includes the sort order (ascending or descending).

Prompt
The prompt or label associated with the item in the generated application.


Database Table and Index Size Estimates report

This report estimates the space required to store the table and index database objects defined for the specified Oracle database(s) in the specified container. These estimations are based on the following principles:

•	Table partitions are not sized

•	Index organized tables are not sized differently from non-index organized tables

•	Bitmap indexes are not identified

The report also estimates the size of the indexes created implicitly, by the primary key / unique key definition on the tables. The names of these indexes are assumed to be the same as the constraint names.

Tables, indexes or constraints are listed by tablespace within the database. If the table, index or constraint has not been assigned to a tablespace, it will be listed under a tablespace named UNSPECIFIED.

The report estimates the total database size as the combined size of the tables and indexes. Table size and index size estimates are done separately. The formulae used for estimating table and index sizes are given at the beginning of the report, provided that the Include Help? parameter is set to Yes. These formulae are further described in the Oracle Server Administrator's Guide.

Wherever PCTFREE parameters, INITRANS parameters and other storage parameters have not been defined, the default value is assumed.

Note:	The report does not include an estimate of the space required to store PL/SQL package codes, materialized views or view definitions.

Report filename

CKDBSZ

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Database Name
Mandatory
To restrict the report to a specific database, choose the database name here, otherwise leave the default value % to report on all databases defined in the container.

Database User
Mandatory
To restrict the report to a particular user, choose the user name here. The default value, %, reports on all users of the specified database or databases.

Tablespace Name
Mandatory
To restrict the report to a particular tablespace, choose the tablespace name from the dropdown list. You can use % as a wildcard.

Table Name
Mandatory
To restrict the report to a particular table, choose the table name from the dropdown list. You can use % as a wildcard.

Override Complete Status?
Mandatory
To include in the report any database object definitions that are not complete, enter Yes in this field; otherwise, leave the default value No.

Include Help?
Mandatory
If you want the report to include at the beginning an explanation of what the report does and of the formulae used for estimating table and index sizes, leave the default value Yes, otherwise choose No.

Detail Level
Mandatory
The level of detail you want the report to include:

Database Only	Report includes only the Summary section
Database, Tables and Keys	Report includes the Summary section and the Details section, but the Details section has no column details
Database, Tables, Keys and Columns (default)	Report includes the Summary section, together with a complete Details section including column details
QA Check?
If you want the report to include a quality check for the selected database (for example, "No indexes defined for this table"), leave the default value Yes; otherwise, choose No. The quality check reports such potential problems as tables that have no columns defined, or database objects that have a create status of No.

Database Block Size
The block size to be used in estimating the database size; default is 2048 bytes.

Initial Extent
The size in bytes of the first extent that will be allocated when the table and index objects are created. If you leave this parameter blank, the report shows a recommended value.

Next Extent
The size in bytes of every subsequent extent to be allocated. If you leave this parameter blank, the report shows a recommended value.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

The report consists of two sections: the Estimated Database Size Summary and the Estimated Database Size Detail.

Estimated Database Size Summary for:
The summary section shows the following estimated information for the specified database:

•	total starting, ending and maximum possible space requirements for the database

•	total starting, ending and maximum possible space requirements for the tables and indexes that the database contains

Estimated Database Size Breakdown for:
The Details section shows the following estimated information for each tablespace in the database:

•	starting, ending and maximum possible size

•	for each table:

−	name

−	starting, ending and maximum possible:

-- size

-- row size

−	starting, ending and minimum number of rows per block

−	suggested storage parameters:

--	percentage increase (percentage by which each following extent will grow over the last extent allocated)

--	initial extent (original amount of space allocated to the object)

--	next extent (size of every subsequent extent to be allocated)

--	minimum extents (initial number of extents to be allocated)

--	maximum extents (total number of extents that can ever be allocated, including the first extent)

−	start rows (number of rows to be loaded into the table initially)

−	end rows (maximum number of rows that the table will hold)

−	initial transactions (initial number of transaction entries allocated within each block in the table)

−	maximum transactions (maximum number of transactions that may update a block concurrently)

−	percentage free and percentage used

−	for each column:  name; average and maximum length; datatype; null value*; initial and ending percentage used; starting, ending and maximum possible size in bytes

•	for each index:

−	name

−	name of table for which index is defined

−	starting, ending and maximum possible index size

−	suggested storage parameters:

--	percentage increase (percentage by which each following extent will grow over the last extent allocated)

--	initial extent (original amount of space allocated to the object)

--	next extent (size of every subsequent extent to be allocated)

--	minimum extents (initial number of extents to be allocated)

--	maximum extents (total number of extents that can ever be allocated, including the first extent)

−	initial transactions (initial number of transaction entries for the index)

−	percent free (the percentage of space allowed for growth of the index)

−	a list of the columns that comprise the index or key*

Items marked * are included only if the Detail Level parameter is set to Database, Tables, Keys and Columns.

Quality Check
If the QA Check? parameter is set to Yes, this section lists potential problems with the database definition that may cause the size estimate to be inaccurate:

•	tables or keys with no columns defined

•	tables with no indexes, or primary or unique keys, defined

•	database object definitions that have included in the estimate but which have their Create status set to No (that is, they will not be generated)

•	tables with no start or end rows defined

•	tables, indexes or keys with unusually high values for initial transactions


Flow report

This report gives details of time, cost, source and destination for dataflows in an container.

NOTE: In a business process model, dataflows are known as flows.

Report filename

CKDFLOW

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Business Process Model
To restrict the report to a specific business process diagram, enter the diagram name here. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Flow
The names of the flows in the specified container.

Type
The flow sub-type, if any:  data flow, material flow, temporal flow or flow (unclassified).

Total Time
The total duration of the flow.

Total Cost
The total cost rate defined for the flow.

Source
The name of the business function, datastore or external from which the flow originates. If the source is a datastore, the datastore symbol is shown against the name.

Org. Unit
The business unit responsible for the source function or datastore.

Destination
The name of the business function, datastore or external at which the flow terminates. If the destination is a datastore, the datastore symbol is shown against the name.

Org. Unit
The business unit responsible for the destination function or datastore.

Total Processes
The total number of business functions that are sources or destinations for flows in the container.

Total Stores
The total number of datastores that are sources or destinations for flows in the container.

Total Flows
The total number of flows in the container.


Diagrams in a Given Application report
Diagrams in a Container report

This report lists the diagrams created by the specified user(s) in an container, together with brief details of the elements shown in those diagrams.

Report filename

CKAPPDIA

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Repository Username
Mandatory
Enter the name of the user for whom diagrams are to be listed. You can use % as a wildcard.

Diagram Type
Mandatory
The type of diagram to be listed. Choose a type from the dropdown list, or leave the default value % to list diagrams of all types.

Diagram Name
To restrict the report to a specific diagram, enter the diagram name here. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Diagrams Created By
The username of the user who created the diagram(s) listed.

Diagram Type
The type of diagram, for example, Process Modeler, Data Diagrammer, Function Hierarchy Diagrammer and so on.

Diagram
Name
The diagram name.

Title
The diagram title (used for displaying additional information on the diagram).

Diagram Elements
Element Type
The type of element(s) shown on the diagram (e.g., entity, module).

Element
The name and path of the element(s) in the diagram.


Entity Model Reference report

This report contains complete details defined for specified entities in the specified container.

Report filename

CKEMODRF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Entity Name
Mandatory
The name of the entity for which you want to list details. You can use % as a wildcard.

ER Diagram
To restrict the report to entities that appear on a particular entity relationship diagram, enter the name of the diagram here. You can use % as a wildcard.

Include Details?
Mandatory
The default value, Yes, includes the Details section in the report for the selected entities. This section contains detailed information about the attributes, usage, volume and text associated with the entity. If you do not want this section in your report, choose No to include only the Summary section.

Created Start Date
Restricts the report to include only entities created after this date.

Created End Date
Restricts the report to include only entities created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only entities changed after this date.

Changed End Date
Restricts the report to include only entities changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

For each entity selected, the report includes the following details:

Entity Name
The name of the entity.

Short Name
The short name of the entity.

Synonyms
Shows any synonyms defined for this entity.

Summary
This section shows:

•	whether the entity is a subtype of another entity

•	any subtypes that this entity has

Attributes
Shows a summary of the attributes defined for this entity (also shows the attributes of the sub-type of this entity):

•	*  indicates a mandatory attribute

•	o  indicates an optional attribute

Relationships
This section shows a summary of the relationships defined for this entity.

Details
The Details section is included only if the Include Details? parameter is set to Yes. The section shows:

•	details of the attributes defined for the entity:  optionality, domain, format and default value

•	details of the attributes defined for subtypes, if any, of this entity

•	business functions that use this entity

•	business units that use this entity

•	volume information for the entity

•	notes and other text recorded for the entity

Defined Attributes for Entity
The name of the entity (or one of its sub-types, if any). The attribute details shown for this entity are:

Attribute Name
The attribute name

Optional
Whether a value is optional for this attribute

Domain
The domain, if any, to which the attribute belongs

Format
The attribute format, that is, the datatype

Default Value
The default value for the attribute

Used by Business Functions
For the specified entity (and each of its sub-types, if any), this section shows the short definition and the label of the business functions that use this entity.

Used by Business Units
For the specified entity (and each of its sub-types, if any), this section shows the name and short name of the business units that use this entity.

Volumetric Information of Entity
Shows volume information about the specified entity, namely the:

Initial
The initial number of occurrences

Average
The Average number of occurrences expected

Maximum
The maximum number of occurrences expected

Annual Growth (%)
The expected annual growth rate

Note and Other Text
Any notes about the entity.


Menu and Screen Definition report

This report shows the detailed design information for a specified module that is of type MENU, together with design information for specified modules of type SCREEN.

Report filename

CGRMEN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Screen Short Name
The name of the module of type SCREEN for which you want to include design information. You can use % as a wildcard.

Menu Short Name
The name of the module of type MENU for which you want to include detailed design information. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

The information is organized as follows:

•	the main details of the module definition

•	a summary of the sub-modules for the module (as defined by the module network)

•	a detailed description of the sub-modules for the module

•	the parameter details for each of the sub-modules

Short Name
The short name of the module.

Module
The module name.

Lang
The type of application expected to be generated from this module definition.

Type
The way in which the module is expected to be implemented based on the specified language. The value DEFAULT represents the way modules are most frequently implemented in that language. For example, if the Language is Oracle Developer Forms, the value DEFAULT indicates that the module is expected to be implemented as a form.

Format
For Oracle Developer Forms and Reports modules, the format in which the generated application is laid out. There are two sets of possible values, depending on the language type:

Language	Format	Meaning
Forms	LOV	Form module generated as query-only list of valid values.
	Master/Detail	Detail block displays information about record in master.
	Matrix	Two master blocks and a detail block.
Reports	Control Break	Tabular layout style for all groups.
	Label	Address layout style for all groups.
	Master/Detail	Form layout style for groups with child groups and tabular layout style for groups with no child groups.
	Matrix	Across layout style for all groups within the Across master hierarchy. Tabular layout style for all groups in the down master/cell hierarchy.
Purpose
The purpose, or a short description, of the module.

Titles
The top and bottom titles for the module. The top title is the main title for the module in the generated application,  while the bottom title is the title for the bottom of a generated report page or screen.

Summary of Menu Options
For a menu module, this section gives summary details of the modules that are called by the menu options.

Menu Option
The short name of the called module.

Module
The name of the called module.

Type
The way in which the called module is expected to be implemented based on the specified language. The value DEFAULT represents the way modules are most frequently implemented in that language. For example, if the Language is Oracle Developer Forms, the value DEFAULT indicates that the module is expected to be implemented as a form.

Purpose
The purpose, or a short description, of the called module.

Lang
The type of application expected to be generated from this called module.

Owns?
Indicates whether the specified container owns the module. Possible values are Y (yes) and N (no).

Menu Option
Module
The short name and name of the called module.

Lang
The language type of the called module.

Type
The module type of the called module.

Format
The layout format of the called module.

Command
The command line used to call this module in the generated application.

Purpose
The purpose, or a short description, of the called module.

Titles
The top and bottom titles for the called module.

Module Access Type
The access type for an access defined for the called module. This indicates whether access has been granted to a specific Oracle user, or via a role.

Name
The name of the Oracle user or role to which access to the called module has been granted.

Parameters
The name of an argument (i.e., parameter) for the called module.

Prompt
The prompt for the argument.

Default Value
The default value for the argument.


Non-Default User Preferences report

This report describes, for a selected module, the user preference settings that have been changed from the default (factory-supplied) settings.

The report follows the Oracle Designer preference levels in its output. For example, if you select Oracle Developer - Forms as the product, the preferences that are reported first are those that apply to the module as a whole (for example, application and module level preferences). Next, the report lists preferences that apply at module component usage level, and so on.

Note:	A single module can have different sets of preferences stored against it for Oracle Developer - Forms and Oracle Developer - Reports. The product that you select determines which set of preferences appears in the report.

Report filename

CKUPREF

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Product
Mandatory
The Oracle product for which preferences are to be reported.

Module Short Name
The short name of the module for which preferences are to be reported.

Application Level ?
Mandatory
Indicates whether the report is to include preferences defined at the application level.

Preference Set
Enter the name of a preference set to display its non-default preferences. You can use % as a wildcard; the value % includes all preference sets in the container.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Preference Set
The non-default preferences for the specified preference set.

Module
The short name and name of the module that has the preferences shown.

Group
The preference category to which a preference belongs.

Preference
The preference name.

Value Set
The value set for this preference.

Default Value
The default (factory-supplied) value for this preference.

Set Against
The preference level and element name against which the preference is set. If the preference is set at the application level, this shows the name of the container.


Process Source and Consequences report

For a specified business function (process step), this report lists:

•	all the trigger events and dataflows that might initiate the process containing this function

•	all the dataflows and outcome events that might be the end results of the process containing this function

Report filename

CKPRSC

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Function Label

Mandatory
Enter the label of the function about which you want to report. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Name
The label of the specified function.

Description
The short definition of the specified function.

Parent
The name of the parent function, if any, for this function.

Elementary?
Indicates whether this is an elementary business function.

Decomposed?
Indicates whether function decomposition has taken place for this function.

Sources:
Name
The names of dataflows that might initiate the process containing this function.

Into
The name or short definition, and the label or ID, of the element where a source dataflow terminates.

From
The type (FUNCTION or DATASTORE), name or short definition, and the label or ID, of the element where a source dataflow originates.

Events
The name of a trigger event, if any, associated with element where a source dataflow originates.

Consequences:
Name
The names of dataflows that might be the end results of the process containing this function.

From
The name or short definition, and the label or ID, of the element where a consequence dataflow originates.

To
The type (FUNCTION or DATASTORE), name or short definition, and the label or ID, of the element where a consequence dataflow terminates.

Outcomes
The name of an outcome event, if any, associated with element where a consequence dataflow terminates.


Text Definition report

This report shows definitions and usages of text types in a specified repository. For each specified text type, the report shows the elements that use that text type. You can choose to display only details of user-defined text types.

Report filename

CDUETXT

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Text Type
Mandatory
The text type for which you want to list details, for example, Derivation Expression, Package Specification, Summary Text and so on. You can use % as a wildcard.

Extended Types only?
Mandatory
Choose Yes to restrict the report to user-defined text types, otherwise leave the default value No.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Text Type
The name of the specified text type.

Description
The description of the text type.

Extended Text Type?
Indicates whether this text type is one of the standard Oracle Designer Repository text types.

Element Type
The short name of an element type that uses the specified text type.

Description
The description of the element type.

Extended Text Usage?
Indicates whether the element type uses the text type by means of the User Extensibility facilities.


Value Added Activities report

This report lists the activities (functions, datastores and dataflows) defined in an container, categorized by the level of value they add to the business process.

Report filename

CKVALADD

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Business Process Model
The name of the business process on which you want to report.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Value Added
The level of value added by a particular activity. The level can be High, Medium, Low or None.

Functions/Datastores/Dataflows
The activities (functions, datastores and dataflows) defined as adding a particular level of value.

Business Unit
The business unit responsible for the activity.

Location
The location of the business unit.

Total Time
The total time value defined for the activity.

Total Cost
The total cost value defined for the activity.

Total Dataflows
The total number of dataflows in the specified container.

Total Functions
The total number of functions in the specified container.

Total Datastores
The total number of datastores in the specified container.

Total High
The total number of activities defined as adding a high level of value to the business process.

Total Medium
The total number of activities defined as adding a medium level of value to the business process.

Total Low
The total number of activities defined as adding a low level of value to the business process.

Total None
The total number of activities for which no value added level has been defined.


Entity Completeness Check report
Entity Completeness Checks report

You can run this report to check on the completeness of entity definitions in specified containers. You can check for entities in a specified container that:

•	have no attributes

•	have no description

•	have no relationships

•	have no unique identifiers

•	are not used by any functions

You can perform any of these checks individually, or you can include them all in a single report.

Report filename

CDSCC3

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Entity Check Type

To choose a particular type of check (for example, to find any entities with no attributes), choose the check type here, otherwise leave the default value All to perform all the checks.

ER Diagram

To restrict the report to entities that appear on a particular entity relationship diagram, enter the name of the diagram here or choose it from the dropdown list. You can use % as a wildcard to check specifically for entities that appear in entity relationship diagrams . If you leave the field blank then all entities in the container will be checked.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Entities with No Attributes
Entities with No Description
Entities with No Unique Identifiers
Entities with No Relationships
Entities Not Used by Functions

The names and descriptions of any entities in the selected container that are incomplete in the categories listed.

An asterisk (*) next to an entity name indicates that the entity is owned by the selected container.


Function Completeness Check report
Function Completeness Checks report

This report lists functions in a selected container that do not appear on any dataflow diagram. You can choose to list all such functions, or only the atomic functions that come into this category, or only the non-atomic ones.

Report filename

CDDFD4

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Function Check Type
If you want a particular type of check (i.e., only atomic or only non-atomic functions), choose the check type here, otherwise leave the default value "All Functions not on any DFD" to check all types of function.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Atomic Functions not on any Dataflow Diagram
Non-Atomic Functions not on any Dataflow Diagram

The labels and descriptions of any functions, in the specified container that, are incomplete in the categories listed.

An asterisk (*) next to a function name indicates that the function is owned by the specified container.


Datastore Completeness Check report
Datastore Completeness Checks report

This report lists datastores in a selected container that do not have either input or output dataflows defined, or which have no dataflows defined at all.

Report filename

CDDFD8

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Datastore Check Type

If you want a particular type of check (i.e., only datastores with no input dataflows, or only those with no output dataflows), choose the check type here, otherwise leave the default value to check for the absence of both types of dataflow.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Datastores Without Input Dataflows
Datastores Without Output Dataflows

The names of any datastores in the selected container that are incomplete in the categories listed. The report also displays a brief comment about each datastore.

An asterisk (*) next to a datastore name indicates that the datastore is owned by the selected container.


Database Object Implementation Definition report

This report lists implementation details for database objects in a selected container.

Report filename

CKDOIDFN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Database Name
Mandatory
To restrict the report to a specific database, choose the database name here, otherwise leave the default value % to report on all databases defined in the container.

Database User
Mandatory
To restrict the report to a particular user of the specified database or databases, choose the user name here. The default value, %, reports on all users of the specified database or databases.

Database Object Type
Mandatory
To restrict the report to a specific database object type, choose the object type here, otherwise leave the default value % to report on all database object types.

Include Details ?
To include additional details specific to the object type (for example, details of index storage for a table implementation), leave the default value Yes, otherwise choose No.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Database Name
The name of the database containing the objects.

Database Type
The type of database (Oracle or other databases). Note that, for Oracle Designer purposes, Oracle Rdb is classed as an other database.

Database User
The Oracle username of the user who has implemented the database objects listed.

<object type> Implementation Details
This section lists basic implementation details for database objects of the type shown.

Database Object Name
The name of the database object implemented by this user.

Global Synonym Name
The name to be used by the Server Generator when creating synonyms for this object.

Complete ?
Indicates whether the definition is ready to be used by the Server Generator.

Scope
The scope of visibility of the database object:  DATABASE or WORLD. This is used by the Server Generator to determine when database links and synonyms need to be created.

Additional Details
If you choose the value Yes for the Include Details? parameter, the report may show some or all of the following additional details, depending on the type of object for which you are reporting the implementation:

Description
A brief description of the implementation.

Notes
Any notes about the implementation.

Non-Oracle Storage
Storage details for objects in an other database.

Storage Definition
The name of a storage definition used for the implementation.

Tablespace
The name of the tablespace in which the object is implemented.

Temporary ?
Indicates whether the tablespace is temporary.

Cached ?
Indicates whether caching is active for a table. Caching allows recently-used data blocks to be retrieved quickly.

Parallel ?
Indicates whether parallel query processing is to be used.

Degree
The number of query servers used in the parallel query operation.

Init. Trans.
The initial number of transaction entries that are allocated within each block in the table.

Max. Trans.
The maximum number of transactions that may update a block concurrently.

Instances
Specifies how a table is split among the available instances of a parallel server for parallel query processing.

Percent Free
The percentage of each block that is allocated to a table for future updates to the table data.

Percent Used
The minimum percentage of space usage maintained for each block.

Materialized View Log
This section provides details of a materialized view log, a table on the master database that is associated with the base table. The materialized view log is used to locate the rows that have been updated in the base table, so that the updated rows can be applied to the materialized view in order to refresh it.

Materialized View Log ?
Indicates whether a materialized view log is created for this implementation of the table.

Tablespace
The name of the tablespace in which the materialized view log is created.

Init. Trans.
The INIT TRANS parameter for the materialized view log of this implementation of the table.

Max. Trans.
The MAX TRANS parameter for the materialized view log of this implementation of the table.

Storage Definition
The name of a set of storage parameters used to define future space allocation for the materialized view log.

Percent Free
The minimum percentage of free space per block for the materialized view log.

Percent Used
The minimum percentage of used space per block for the materialized view log.

Index-Organized Tables
Percent Threshold
For an index-organized table, the percentage of the block size beyond which row data is considered overflow.

Overflow Tablespace
For an index-organized table, the name of the tablespace that is used for overflow purposes.

Refresh
This section provides details of refresh operations for a materialized view implementation.

Refresh Start Time
The first automatic refresh date for a materialized view.

Next Refresh Clause
The date on which the materialized view will next be refreshed. This date is expressed relative to the last refresh. The next section provides details of sequenceimplementations.

Refresh Type
The type of refresh operation:  null (uses the most suitable type at refresh time), COMPLETE (entirely replaces the data in the materialized view, without creating a materialized view log), FAST (updates only the changes in the base table, using the materialized view log) or FORCE (system chooses between fast and complete refresh at the time of the operation).

Start
Specifies the first sequence number to be created.

Increment
The number by which the sequence is incremented.

Order
Indicates whether the sequence numbers are generated in the order of the request.

Cache Value
Specifies a pre-allocation of sequence numbers that can be cached in memory.

Minimum
Maximum
The minimum and maximum values that the sequence generates.

Index Storage
Index Type
The type of index:  Not Unique (the rows in the table can contain duplicate values in the columns that define the index), Unique (no two rows in the table can contain duplicate values in the columns that define the index) or Bitmap (a bitmap index is used).

Index Name
A unique name for the index.

Tablespace
The tablespace in which the index is implemented.

Storage Definition
A storage definition for use with this index.

Base Relation Locations
This section gives details of the base relation locations for a view or materialized view implementation, identifying the schemas in which the underlying tables, views or materialized views are located.

Database Schema
Identifies a database user for which the materialized view or view is to be implemented.

Table Name
The name of the element on which the materialized view or view is based.

Alias
An alias for the view or materialized view. The alias can be used to qualify columns in the SELECT and WHERE clauses.


Module Component Definition report

This report contains details of module components defined in the current container.

Report filename

CKMODCP

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Module Component Type
The module component type: specific (to a single module) or reusable (in other modules). The default value % includes both types of module component.

Module Component Name
Mandatory
Restricts the report to include only a module component with the specified name, which you can either enter in the field or choose from the dropdown list. You can use % as a wildcard; the value % reports on all module components in the container.

Module Component Language
Mandatory
Restricts the report to include only module components written in a particular language, which you can choose from the dropdown list.

Module Short Name
Enter the short name of a module to include components only from that module. You can use % as a wildcard; the value % includes components from all modules.

Include Details ?
Leave the default value Yes if you want the report to include information on detailed table usages, data bound items, item groups and SQL query sets defined for the module component, otherwise choose No.

Include Description ?
Leave the default value Yes if you want the report to include the text description, if any, of the module component, otherwise choose No.

Include Notes ?
Leave the default value Yes if you want the report to include the text notes, if any, about the module component, otherwise choose No.

Include Help ?
Leave the default value Yes if you want the report to include details of user help text for the module component that is to appear in the generated application, otherwise choose No.

Created Start Date
Restricts the report to include only module components created after this date.

Created End Date
Restricts the report to include only module components created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only module components changed after this date.

Changed End Date
Restricts the report to include only module components changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Container
The name of the specified container.

Version
The version number of the specified container.

Module Component
Name
The name of the module component.

Short Desc
A brief description of the module component.

Language
The type of application that is expected to be generated from this module component.

Title
The title displayed for this module component in the generated application.

Module Level ?
Indicates whether this is a module-level component, that is, one that is specific to a particular module and which contains only unbound items and not table usages.

Insert
Indicates whether new records can be added using this module component.

Delete
Indicates whether records can be deleted using this module component.

Update
Indicates whether new records can be updated using this module component.

Query
Indicates whether QUERY operations are allowed using this module component.

Autoquery?
Indicates whether a generated module component should automatically query records on startup (for masterless module components) and when the record changes (for detail module components). A value of "Default Behavior" indicates that the Generator decides.

Layout Style
Indicates how the module component is presented in the generated application.

Rows Displayed
The preferred number of rows displayed at once for this module component in the generated application.

Overflow
Indicates the action that Form Generator takes if the canvas generated for this module component is not wide enough to show a row on a single line.

Canvas Width
Canvas Height
(Form Generator modules) If the module component is generated as the first block on a content canvas or stacked canvas, these indicate the width and height of the canvas.

View Width
View Height
(Form Generator modules) If the module component is generated as the first block on a stacked canvas, these indicate the width and height of the view on the stacked canvas.

Datasource Type
The type of data source from which the generated module component retrieves data.

Datatarget Type
The type of data target through which the generated module component writes data.

Description
A description of the module component.

Notes
Multi-line text notes about the module component.

Help
Help about the module component.

Module Component Inclusions
This section provides details of the modules in which this component is used.

Module Short Name
The short name of the module. This property is used for generating files and objects.

Module Name
The name of the module.

Module Type
The type of module, if different from the default type for the specified language. Used to indicate menu modules and library modules.

Detailed Table Usages
Table Name
The name of a table that is used by this module component.

Usage Type
The type of module component table usage.

Comment
A comment on the use of this table by this module component.

Data Bound Items
This section provides details of data bound items, that is, usages of database columns by the module component.

Column
The name of the column that is referenced by the module component.

Insert?
Indicates whether the user is allowed to enter a new value for the column when a new record is created.

Update?
Indicates whether the user is allowed to modify the column value when updating an existing record.

Query?
Indicates whether the item can be used when entering a query condition, i.e., the user may enter search criteria for the underlying column before executing a query against its associated module component.

Opt.?
Indicates whether the item is optional, that is, whether the user can omit a value for the column before saving a new or modified record.

Item Group
The name of the item group where this item is to be placed.

Prompt
The prompt (or label) associated with the item in the generated application.

Item Groups
This section gives details of item groups defined for this module component. An item group is a collection of items that have an associated prompt on a generated application.

Name
The name of an item group.

Prompt
A prompt, or label, to identify the group of items in the generated application.

SQL Query Sets
This section gives details of SQL query sets defined for the module component. A SQL query set defines an additional query that can be combined with the module component's base table query.

Name
The name of the SQL query set.

Table Usage Name
The name of a table that is used by the SQL query set.

Comment
A brief comment about the SQL query set.

Data Bound Items
This section provides details of data bound items, that is, usages of database columns by the SQL query set. The details are the same as for data bound items under Detailed Table Usages earlier in the report.

NOTE: SQL query set data bound items cannot be placed in an item group, therefore the ‘Item Group’ field will be empty for SQL Query Set data bound items.


Index Storage and Partitioning report

This report provides details of partitioning and index storage for selected tables or materialized views.

Report filename

CKISPD

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Database Name
Mandatory
To restrict the report to a specific database, enter the database name here. You can use % as a wildcard. The default value % reports on all databases defined in the selected container.

Database User
Mandatory
To restrict the report to a specific database user, enter the user name here. You can use % as a wildcard. The default value % reports on all users of the specified database(s).

Table Name
To restrict the report to a specific table, enter its name here. You can use % as a wildcard. The default value % reports on all tables defined in the selected container.

Materialized View Name
To restrict the report to a specific materialized view, enter its name here. You can use % as a wildcard. The default value % reports on all materialized views defined in the selected container.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Database Name
The name of the database in which the table or materialized view definition is to be implemented.

Database Type
The database type, that is, Oracle or an other database. Note that, for Oracle Designer purposes, Oracle Rdb is classed as an other database.

Database User
The name of a database user for whom the table or materialized view definition is to be implemented.

Table Implementation Details
Materialized View Implementation Details
This section lists details of how the table or materialized view definitions are to be implemented.

Database Object Name
The name of the table or materialized view.

Complete ?
Indicates whether the definition is ready to be created by the Server Generator.

Global Synonym Name
The name to be used by the Server Generator when creating synonyms for this table or materialized view.

Scope
The scope of visibility of this table or materialized view:  Database or World.

Imp’n Description
A multi-line text description of the implementation of this table or materialized view.

Imp’n Notes
Multi-line text notes about the implementation of this table or materialized view.

Other Database Storage
Any additional storage parameters for other databases.

Table Partitions
This section provides details if a table has been defined as partitioned (that is, divided into smaller pieces to make management easier). The details include partition name, tablespace name, the name of the storage definition that defines the storage parameters for the partition, together with transaction and usage details.

Table Partition Keys Name
The name of a column used as a key in a table partition.

Index Storage Name
This section provides storage details of any indexes defined for the table.


Oracle Type Definition report

This report provides details of Oracle types defined in the specified container. Oracle types are specific to Oracle8 databases. There are two classifications of Oracle types:

•	Oracle object types, which provide a way of creating user-defined datatypes for the Oracle8  database

•	Oracle collection types, which record definitions of VARRAYs or nested tables in the repository

Report filename

CKOTDFN

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Oracle Type
Choose Oracle Collection Type or Oracle Object Type to restrict the report to include only these types. Leave the default value % to include both types.

Oracle Type Name
Mandatory
To restrict the report to a specific Oracle type, enter its name here. You can use % as a wildcard. The default value % reports on all Oracle types selected by the Oracle Type parameter and defined in the selected container.

Include Usages?
Leave the default value Yes if you want the report to include details of the Oracle type usages e.g., type tables and module arguments.

Created Start Date
Restricts the report to include only Oracle types created after this date.

Created End Date
Restricts the report to include only Oracle types created before this date. Default is today's date.

Changed Start Date
Restricts the report to include only Oracle types changed after this date.

Changed End Date
Restricts the report to include only Oracle types changed before this date. Default is today's date.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Oracle Type Definition
Name
The name by which the Oracle type is identified.

Type
The classification of the Oracle type:  Oracle Object Type or Oracle Collection Type.

Description
A multi-line description of the Oracle type.

Notes
Multi-line notes about the Oracle type.

Oracle Collection Type Details
List of Oracle Collection Type types. If the collection type is VARRAY then also displays the size of the VARRAY. Lists whether the collection is a collection of scalars or objects.

Scalar Collection
If the collection contains scalars, this section shows details of the scalar datatype (the datatype of elements in the collection), and the maximum length and number of decimal places for elements in the collection.

Object Collection
If the collection contains objects, this section shows details of the object datatype (the Oracle object type on which the nested table or VARRAY is based) and whether this is a collection of REFs.

Oracle Object Type Details
Lists the column names of Oracle Object Type definitions. Also lists the datatype and average length of data that can be entered into the columns/attributes.

Type Tables
List of type tables based on the specified Oracle type.

Object Views
List of object views based on the Oracle type.

Return Type for PL/SQL Definitions
If the Oracle type is used by a PL/SQL definition, this section indicates the short name and name of the PL/SQL definition, as well as whether the object type body defined by this PL/SQL definition has a Map or an Order member function (used to compare and order object types).

Type Member Ordering
Indicates whether the object type body defined by this PL/SQL definition has a Map or an Order member function. These functions are used in comparing and ordering object types.

Used by Columns
List of columns that use this type, either as their datatype or by providing a reference to the type.

Datatype for Oracle Collection Types
List of Oracle collection types whose datatype is the specified object type.

Datatype for Module Arguments
List of module arguments whose datatype is the specified object type.

Datatype for Program Datums
List of program datums whose datatype is the specified object type.

Datatype for Datastructure Items
List of datastructre items whose datatype is the specified object type.


Detailed Module Definition report

This report provides a detailed definition of one or more selected modules in an container.

Report filename

CGRMOD

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Module Short Name
Enter the short name of the module you want to include in your report. You can use % as a wildcard.

Include Display Details ?
If you want the report to include display details for bound and unbound items, leave the default value Yes, otherwise choose No. Display details include data such as display type, width, height, formatting and so on.

Include Action Items ?
If you want the report to include details of action items, leave the default value Yes, otherwise choose No. Action items identify where a user is given the option to take a certain action when using a generated application.

Module Data Diagram
To restrict the report to module(s) on a particular Module Data Diagram, enter the diagram name here, otherwise leave this field blank. You can use % as a wildcard.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Short Name
The short name of the module.

Name
A unique name for the module.

Format
The format in which the generated application is laid out, e.g. master/detail, matrix etc.

Language
The type of application expected to be generated from this module definition.

Titles
The top and bottom titles for this module in the generated application.

Complexity
The complexity of the module definition: Easy, Average or Difficult.

Purpose
The purpose, or a short description, of the module.

Description
A multi-line text description of the module.

Notes
Multi-line text notes about the module.

Module Component Summary
Summary details of the components of this module. Details include the component type (single or reusable), name, title and base table usages.

Arguments
Details of the arguments (parameters) defined for this module.

Windows
Details of the window definitions relating to this module.

Module Component
Details of an individual component of the module. Details include the component name, type (single or reusable), name of the window definition within which the component is to be placed, language, whether this is a module-level component (i.e. specific to a particular module), how generated module components are placed in the window, and how the module component is laid out in the generated application (e.g. form, chart, list etc.)

Description
A multi-line text description of the module component.

Detailed Table Usages
Details of the table usages made by this module component. Details include the table name, usage type (base, lookup etc.),

Data Bound Items
Details of the bound items (i.e. database table columns) used by the module component.

Unbound Items
Details of the unbound items (e.g. aggregates, expressions, functions) used by the module component.

Action Items
Details of any action items defined for the windows used by the module. Action items identify where a user is given the option to take a certain action when using a generated application.


Elements not on a Diagram report

This report lists primary access (PAC) elements that do not appear on one or more selected diagrams. You can specify the type of element or diagram you want to report on or you can use the wildcard (%) to report on all elements or diagrams types.

Report filename

CKENOAD

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Repository Username
Mandatory
To restrict the report to elements owned by a particular repository user, enter the username here or choose it from the dropdown list. The default value % reports on elements owned by all users.

PAC Element Type
To restrict the report to primary access (PAC) elements of a particular type, choose the type from the dropdown list. The default value % reports on all PAC element types.

Diagram Type
Mandatory
To restrict the report to elements that are not on a particular type of diagram, choose the corresponding tool from the dropdown list. The default value % reports on all types of diagram.

Diagram Name
To restrict the report to elements that are not on a specific diagram, enter the diagram name or choose it from the dropdown list. The default value % reports on all diagrams in the container.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Diagrams Created By
The name of the repository user who created the diagram listed in the report.

Diagram Type
Diagram Name
Diagram Title
The type, name and title of the diagram listed in the report.

Element Type
Element Name
Description
The type, name and description of the element listed in the report.


Strategic Considerations report

This report gives details of various elements that can be defined at the strategic planning stage of enterprise modeling:  assumptions, critical success factors, key performance indicators, objectives and problems.

Report filename

CKSRCON

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Type
To restrict the report to a particular element type (for example, Assumptions) choose the element type from the dropdown list. The default value % reports on all strategic planning element types.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Assumptions
Type
The type of assumption, for example, business system.

Name
The name of the assumption definition.

Made By
The person, committee or event responsible for defining the assumption.

Ranking
The relative priority or rating for the assumption.

Stability
The level of confidence in the assumption (for example, a percentage).

Risk
The criticality of the assumption (for example, the impact on the business or system of an incorrect assumption).

Comment
A comment or brief description about the assumption.

Critical Success Factors
Name
The name by which this success factor is usually known.

Critical
Indicates whether this factor is critical to the success of the business or organization.

Parent
The critical success factor of which this factor forms a part, if the factor belongs to a hierarchy.

Relative Priority
The relative ranking or rating for the success factor.

Set By
The person, committee or event responsible for setting the success factor.

Target Value
A value that has been set as the target for the success factor.

Unit of Measure
The unit of measure for the target value.

External Dependency
Any consideration in achieving the success factor that is not governed by the business or organization (for example, statutory requirements).

Date Required
The date by which the success factor should be achieved.

Achievement Comment
The date on which the success factor was achieved, or a statement of the progress that has been made.

Comment
A comment or description about the success factor.

Key Performance Indicators
Name
The name by which this key performance indicator is usually known.

Parent KPI
The parent indicator, if this key performance indicator belongs to a hierarchy.

Responsibility
The person, committee or event that is responsible for maintenance of the key performance indicator.

Measured By
The information or facts measured to show the progress made towards achieving the business objectives.

Set By
The group or event that is responsible for setting the key performance indicator.

Target Value
The value that has been set as the target for the key performance indicator.

Comment
A comment or brief description of the key performance indicator.

Objectives
Type
The type of objective. Some organizations use the terms "aims", "goals", "targets" and so on.

Name
The name by which this objective is usually known.

Set By
The person, committee or event responsible for specifying the objective.

Target Value
A value that has been set as the target of the objective.

Unit of Measure
The unit of measure for the target value.

Planning Horizon
The timescale that was being considered when the objective was set (for example, PERMANENT, STRATEGIC, TACTICAL, 5YEAR, 10YEAR).

Date Required
The date by which the objective should be achieved.

Ranking
The relative priority or rating for the objective.

Achievement Comment
The date on which the objective was achieved, or a statement of the progress that has been made.

Comment
A comment or brief description of the objective.

Problems
Type
The problem type, such as the severity level (for example, LOW, MEDIUM or HIGH).

Name
The name by which this problem is usually known.

Parent Problem
The parent of this problem, if it is part of a hierarchy.

Identified By
The person, committee or event that identified the problem.

Date Identified
The date on which the problem was first identified.

Date Solved
The date on which the problem was solved.

Opportunities
Any opportunities that are triggered on identification of the problem.

Cause Category
The cause of the problem (for example, INTERNAL, EXTERNAL).

Resolution Benefit
A description of the benefits that result from resolution of the problem.

Comment
A comment or brief description of the problem.


Dependency Analysis Report

This report allows you to view all elements in a repository and identify the relationships between objects and determine the impact of any changes you might make.

Report filename

JRDAR1

Parameters

The first few parameters are the general parameters, such as Destination Type, Mode, Container Name and Recurse Sub-containers. About

The Copies parameter is shown in the Parameter Palette if you set the destination type to Printer.

Other parameters are:

Element Type
The specific type of element you want to report on.

Element Name
The name of the specific type of element you want to report on. You can use * or ? as a wildcard.

Note: % is not a valid wildcard for this parameter.

Information included in the report

The Front Page
This includes the general details of the report such as, report name, report date and total pages. The parameter values you set for the report are also displayed on the front page.

Name
The name of the specified element.

Path
The path name of the specified element.

Usage
Indicates whether the listed elements, use or are used by the specified element.

Context
The context of the specified element. Possible values are In Workarea or Missing.

Type
The type of the listed element.

Name
The name of any objects which have a dependency relationship with the specified element.

Path
The path name of any objects which have a dependency relationship with the specified element.


Domains for report parameters

Related Topics

When adding a user-defined parameter to a report, you can specify that values for the parameter are to be chosen from a predefined list. A number of predefined lists are available, in the form of domains. Attaching a particular domain to a parameter restricts the possible parameter values to those contained in that domain.

The available domains are as follows. Click a domain name to see its range of permitted values.

ABSTRACT_DATATYPE	Datatypes applicable to abstract types
ABT_TYPE	ABSTRACT_TYPE sub-type discriminator values
ACTION_ITEM_TYPE	Domain for ACTION_ITEM sub-type discriminator
ANNOTATION_TYPE	Classification for ANNOTATIONS required by BPR
APPLICATION_TYPE	Valid types of application system
BASIC_DATATYPE	Fundamental datatypes for ITEMS
CLUSTER_COLUMN_DATATYPE	Datatypes valid for cluster columns
CLUSTER_TYPE	Used to distinguish hash clusters from index clusters
COLUMN_STORAGE_TYPE	Sub-type discriminator values for COLUMN_STORAGE
DAT_TYPES	Created for attribute DS_TYPE of entity DATASTRUCTURE
DATABASE_FILE_TYPE	Valid values for DATABASE_FILE sub-type discriminator
DATABASE_USER_TYPE	Valid sub-types of DATABASE_USER
DATAFLOW END TYPE	Domain for discriminators of arcs on DATAFLOW
DATASOURCE_TYPE	Valid datasources of for module component
DATASTORE_TYPE	Created for attribute DATASTORE_TYPE of entity DATASTORE
DATATARGET_TYPE	Valid types of data target for a module component
DATATYPE	Created for attribute DATATYPE of entity DOMAIN
DATATYPE_LARGE	Longer version of DATATYPE domain for use when non-enforced
DATATYPE_LARGE_OF	Subset of DATATYPE_LARGE specific to Oracle Forms
DATATYPE_LARGE_OG	Subset of DATATYPE_LARGE specific to Oracle Graphics
DATATYPE_LARGE_OR	Subset of DATATYPE_LARGE specific to Oracle Reports
DATATYPE_LARGE_PLSQL	Subset of DATATYPE_LARGE specific to PL/SQL
DATAWAREHOUSE_TYPE	Classification of entities/tables in a datawarehousing application
DEFAULT_DISPLAY_TYPE	The default display types for a column
DERIVATION_EXPRESSION_TYPE	Classification for column derivation expressions
DIAGRAM_TYPE	Valid types of diagrams
DISPLAY DATATYPE	Created for attribute DISPLAY_DATATYPE of entity MODULE_DETAIL_COLUMN_USAGE
DISPLAY_DATATYPE_OF	Subset of DISPLAY DATATYPE specific to Oracle Forms
DISPLAY_DATATYPE_OG	Subset of DISPLAY DATATYPE specific to Oracle Graphics
DISPLAY_DATATYPE_OR	Subset of DISPLAY DATATYPE specific to Oracle Reports
DISPLAY_DATATYPE_VB	Subset of DISPLAY DATATYPE specific to Visual Basic
DISPLAY_DATATYPE_WEB	Subset of DISPLAY DATATYPE specific to Oracle Web Server
DOC_TYPE	Document types
EVENT_TYPE	Created for attribute EVENT_TYPE of entity EVENT
FIL_FILE_TYPE	Created for attribute FILE_TYPE of entity CDFILE
FLOW_TYPE	Classification for dataflows required by BPR
FUNCTION_TYPE	Classification for functions required by BPR
GENERAL_MODULE_TYPE	Valid types of module, other than the default for the language
GENERAL_MODULE_TYPE_LIB	Subset of GENERAL_MODULE_TYPE specific to D2KLIB
GENERAL_MODULE_TYPE_OG	Subset of GENERAL_MODULE_TYPE specific to Oracle Graphics
GENERAL_MODULE_TYPE_OR	Subset of GENERAL_MODULE_TYPE specific to Oracle Reports
GENERAL_MODULE_TYPE_WEB	Subset of GENERAL_MODULE_TYPE that applies to Oracle WebServer
GENERATOR_ITEM_TYPE	All types for generator action items
GENERATOR_ITEM_TYPE_VB	Subset of generator action types specific to VB
IMPLICIT_INDEX_TYPE	Types of implicit index supported by IMPLICIT_INDEX_STORAGE
INDEX_PARTITION_TYPE	Values for sub-type discriminator on INDEX_PARTITION
INDEX_STORAGE_SUBTYPE	Value for INDEX_STORAGE sub-type discriminator
INDEX_STORAGE_TYPE	Allows distinction between LOCAL and GLOBAL for indexes
INDEX_TYPE	Discriminator for sub-type of INDEX
ITEM_TYPE	Discriminator for ITEM
ITM_DATA_TYPE	Created for attribute DATA_TYPE of entity DATASTRUCTURE_ITEM
LANGUAGE_TYPE	Valid language classifications for non-PL/SQL modules
MAPPING_TYPE	Options for implementing an entity hierarchy in tables
MOD_TYPE	Created for attribute LANGUAGE_TYPE of entity LANGUAGE
MODULE_COMPONENT_LINK_TYPE	Discriminator for MODULE_COMPONENT_LINK
MODULE_COMPONENT_TYPE	Used to distinguish the type of module component
MODULE_SUBTYPE	Values of discriminator indicating sub-type of module
MTI_USAGE_TYPE	Created for attribute USAGE_TYPE of entity MODULE_DETAIL_TABLE_USAGE
NON_ORACLE_DATABASE_TYPE	Non-Oracle database types supported by Server Generator
OBJECT_IMPLEMENTATION_TYPE	Valid types of database object implementations
OCO_CONSTRAINT_TYPE	Created for attribute CONSTRAINT_TYPE of entity CONSTRAINT
ODB_DATABASE_TYPE	The sub-types of DATABASE
OKY_CONSTRAINT_TYPE	Created for attribute CONSTRAINT_TYPE of entity KEY_COMPONENT
ORACLE_COLLECTION_TYPE	The Oracle8 collection types
ORACLE_TYPE_SUBTYPE	Subtype discriminator values for ORACLE_TYPE
OS_FILE_TYPE	Sub-types of OS_FILE
OSQ_SEQUENCE_TYPE	Created for attribute SEQUENCE_TYPE of entity SEQUENCE
PASSED_VALUE_TYPE	Valid values for sub-type discriminator of PASSED_VALUE
PLS_DATA_TYPE	PL/SQL datatypes
PLS_DATATYPE	PL/SQL datatypes
PLSQL_MOD_TYPE	Valid types of PL/SQL modules
REFRESH_TYPE	Created for attribute REFRESH_TYPE of entity SNAPSHOT_DEFINITION
RPT_DATASTORE_CHECK_TYPE	Domain used in Reports front end
RPT_DATATYPE	Domain used by R2 reports front end
RPT_DESTYPE	Oracle Reports destination type
RPT_ENTITY_CHECK_TYPE	Domain used in Reports front end
RPT_FUNCTION_CHECK_TYPE	Domain used in Reports front end
RPT_GRPTYPE	Domain used by R2 reports front end
SET_TYPE	Sub-types of USER_DEFINED_SET
STORE_TYPE	Classification for DATASTORES required by BPR
TAB_TABLE_TYPE	Created for attribute TABLE_TYPE of entity RELATION_DEFINITION
TABLE_OR_TYPE	Values of discriminator for arcs involving tables/type
TCO_TYPE	TYPE_CONSTRAINT sub-type discriminator values
TME_TYPE	TYPE_MEMBER sub-type discriminator values
TYPE_MEMBER_ORDERING	Valid types of member functions
TYPE_OPERATION_TYPE	Types of Operation if other than a "normal" operation
UNBOUND_TYPE	Classification of unbound items
UNBOUND_TYPE_OF	Subset of UNBOUND_TYPE specific to Oracle Forms
UNBOUND_TYPE_OG	Subset of UNBOUND_TYPE specific to Oracle Graphics
UNBOUND_TYPE_VB	Subset of UNBOUND_TYPE specific to Visual Basic
UNBOUND_TYPE_WEB	Subset of UNBOUND_TYPE specific to Oracle WebServer


Values for ABSTRACT_DATATYPE domain

Binary

Boolean

Date

DateTime

Integer

Real

String


Values for ABT_TYPE domain

Object Type

Value Type


Values for ACTION_ITEM_TYPE domain

Custom Action Item

Generator Action Item

Navigation Action Item


Values for ANNOTATION_TYPE domain

Both Text and Graphic

Graphic

Text


Values for APPLICATION_TYPE domain

Normal

Dummy

Working


Values for BASIC_DATATYPE domain

CHAR

DATE

DATETIME

NUMBER

RAW


Values for CLUSTER_COLUMN_DATATYPE domain

BFILE

BINARY_INTEGER

BLOB

CFILE

CHAR

CLOB

DATE

DECIMAL

DOUBLE PRECISION

FLOAT

GRAPHIC

IMAGE

INTEGER

LONG VARCHAR

LONG VARGRAPHIC

NUMBER

RAW

REAL

ROWID

SMALLINT

SOUND

TEXT

TIME

TIMESTAMP

VARCHAR

VARCHAR2

VARGRAPHIC

VIDEO


Values for CLUSTER_TYPE domain

Hash Cluster

Index Cluster


Values for COLUMN_STORAGE_TYPE domain

LOB Column Storage

Nested Table Column Storage


Values for DAT_TYPES domain

PL/SQL Cursor

PL/SQL Record

PL/SQL Table


Values for DATABASE_FILE_TYPE domain

Datafile

Logfile


Values for DATABASE_USER_TYPE domain

NAMED_DATABASE_USER

PUBLIC


Values for DATAFLOW END TYPE domain

Datastore

External

Function


Values for DATASOURCE_TYPE domain

None

PL/SQL Procedure

Query

Table

View


Values for DATASTORE_TYPE domain

COMPUTER

MANUAL

TRANSIENT


Values for DATATARGET_TYPE domain

None

PL/SQL Procedure

Table

Transactional Triggers


Values for DATATYPE domain

BFILE

BINARY INTEGER

BLOB

CHAR

CLOB

DATE

DECIMAL

DOUBLE PRECISION

FLOAT

GRAPHIC

IMAGE

INTEGER

LONG

LONG RAW

LONG VARCHAR

LONG VARGRAPHIC

MLSLABEL

NCHAR

NCLOB

NUMBER

NVARCHAR2

RAW

REAL

ROWID

SMALLINT

SOUND

TEXT

TIME

TIMESTAMP

VARCHAR

VARCHAR2

VARGRAPHIC

VIDEO


Values for DATATYPE_LARGE domain

BFILE

BINARY_INTEGER

BLOB

BOOLEAN

CHAR

CHARACTER

CLOB

DATE

DEC

DECIMAL

DOUBLE PRECISION

FLOAT

GRAPHIC

IMAGE

INT

INTEGER

LONG

LONG RAW

LONG VARCHAR

LONG VARGRAPHIC

MLSLABEL

NATURAL

NATURALN

NCHAR

NCLOB

NUMBER

NUMERIC

NVARCHAR2

PLS_INTEGER

POSITIVE

POSITIVEN

RAW

REAL

ROWID

SIGNTYPE

SMALLINT

SOUND

STRING

TEXT

TIME

TIMESTAMP

VARCHAR

VARCHAR2

VARGRAPHIC

VIDEO


Values for DATATYPE_LARGE_OF domain

BFILE

BINARY_INTEGER

BLOB

CHAR

CLOB

DATE

DECIMAL

DOUBLE PRECISION

FLOAT

GRAPHIC

IMAGE

INTEGER

LONG

LONG RAW

LONG VARCHAR

LONG VARGRAPHIC

MLSLABEL

NCHAR

NCLOB

NUMBER

NVARCHAR2

RAW

REAL

ROWID

SMALLINT

SOUND

TEXT

TIME

TIMESTAMP

VARCHAR

VARCHAR2

VARGRAPHIC

VIDEO


Values for DATATYPE_LARGE_OG domain

BINARY_INTEGER

CHAR

DATE

DECIMAL

DOUBLE PRECISION

FLOAT

INTEGER

NUMBER

REAL

ROWID

SMALLINT

TEXT

TIME

TIMESTAMP

VARCHAR

VARCHAR2


Values for DATATYPE_LARGE_OR domain

BFILE

BINARY_INTEGER

BLOB

CHAR

CLOB

DATE

DECIMAL

DOUBLE PRECISION

FLOAT

GRAPHIC

IMAGE

INTEGER

LONG

LONG RAW

LONG VARCHAR

LONG VARGRAPHIC

MLSLABEL

NCHAR

NCLOB

NUMBER

NVARCHAR2

RAW

REAL

ROWID

SMALLINT

SOUND

TEXT

TIME

TIMESTAMP

VARCHAR

VARCHAR2

VARGRAPHIC

VIDEO


Values for DATATYPE_LARGE_PLSQL domain

BFILE

BINARY_INTEGER

BLOB

BOOLEAN

CHAR

CHARACTER

CLOB

DATE

DEC

DECIMAL

DOUBLE PRECISION

FLOAT

INT

INTEGER

LONG

LONG RAW

MLSLABEL

NATURAL

NATURALN

NCHAR

NCLOB

NUMBER

NUMERIC

NVARCHAR2

PLS_INTEGER

POSITIVE

POSITIVEN

RAW

REAL

ROWID

SIGNTYPE

SMALLINT

STRING

VARCHAR

VARCHAR2


Values for DATAWAREHOUSE_TYPE domain

Dimension

Fact


Values for DEFAULT_DISPLAY_TYPE domain

Button

Check box

Combo box

Image

OCX control

OLE container

Pop list

Radio group

Text list

Text

VBX control


Values for DERIVATION_EXPRESSION_TYPE domain

Function Call

SQL Expression


Values for DIAGRAM_TYPE domain

Type Diagram

Process Model

Dataflow Diagram

Server Model Diagram

Entity Relationship Diagram

Function Hierarchy Diagram

Module Diagram

Module Structure Diagram

Matrix Diagram


Values for DISPLAY DATATYPE domain

Button

Chart Container

Check box

Combo box

Current record

Descriptive flexfield

Drilldown current record

Image

Key Flexfield

OCX control

OLE container

Pop list

Radio group

Sound

Text list

Text

VBX control


Values for DISPLAY_DATATYPE_OF domain

Button

Chart Container

Check box

Combo box

Current record

Descriptive flexfield

Drilldown current record

Image

OLE container

Pop list

Radio group

Text list

Text


Values for DISPLAY_DATATYPE_OG domain

Bar

Bar overlapping

Bar absolute stack

Bar relative stack

Curvefit exponential

Curvefit straight line

Curvefit logarithmic

Curvefit power

Fill straight edge

Fill smooth edge

Fill stepped edge

Fill straight edge absolute stack

Fill smooth edge absolute stack

Fill stepped edge absolute stack

Fill straight edge relative stack

Fill smooth edge relative stack

Fill stepped edge relative stack

Label

Label relative stack

Line straight

Line smooth

Line stepped

Line straight relative stack

Line smooth relative stack

Line stepped relative stack

Origin

Period end

Period start

Slice

Spike

Spike absolute stack

Spike relative stack

Symbol

Symbol relative stack

Text

Value close

Value high

Value low


Values for DISPLAY_DATATYPE_OR domain

Button

Chart Container

Image

OLE container

Text


Values for DISPLAY_DATATYPE_VB domain

Button

Check box

Combo box

Pop list

Radio group

Text list

Text


Values for DISPLAY_DATATYPE_WEB domain

Check box

Image

Pop list

Radio group

Text list

Text


Values for DOC_TYPE domain

Computer Resources Integ. Support Doc.

Computer System Operator's Manual

Delivery and Acceptance Plan

Detailed Design

Engineering Change Proposal

Feasibility Study

Firmware Support Manual

High Level Design

Interface Design Document

Installation Guide

Interface Requirements Specification

Operations Documentation

Product Proposal

Quality Plan

Specification Change Notice

Software Design Document

Software Development Plan

Module Specification

Software Programmer's Manual

Software Product Specification

Software Requirements Specification

System/Segment Design Document

System/Segment Specification

Software Test Descriptions

Software Test Plan

Software Test Report

Software User's Manual

Terms of Reference

Version Description Document


Values for EVENT_TYPE domain

Change

External

Internal

Other

System

Time


Values for FIL_FILE_TYPE domain

ASCII

BINARY

DATA

I/O

TEXT


Values for FLOW_TYPE domain

Data

Material

Temporal

Unclassified


Values for FUNCTION_TYPE domain

Decision

Data Entry

Normal

Report

Unclassified


Values for GENERAL_MODULE_TYPE domain

Default

Library

Menu


Values for GENERAL_MODULE_TYPE_LIB domain

Library


Values for GENERAL_MODULE_TYPE_OG domain

Default

Library


Values for GENERAL_MODULE_TYPE_OR domain

Default

Library


Values for GENERAL_MODULE_TYPE_WEB domain

Default

Menu


Values for GENERATOR_ITEM_TYPE domain

Delete Record

New Record

Query

Resequence Down

Resequence Up

Save

Undo

View/Update Record


Values for GENERATOR_ITEM_TYPE_VB domain

Delete Record

New Record

Query

Resequence Down

Resequence Up

Save

Undo

View/Update Record


Values for IMPLICIT_INDEX_TYPE domain

OID Index

Snapshot Index


Values for INDEX_PARTITION_TYPE domain

Global Index Partition

Local Index Partition


Values for INDEX_STORAGE_SUBTYPE domain

Implicit Index Storage

User Object Index Storage


Values for INDEX_STORAGE_TYPE domain

Global

Local


Values for INDEX_TYPE domain

Cluster Index

Relation Index


Values for ITEM_TYPE domain

Bound Item

Unbound Item


Values for ITM_DATA_TYPE domain

Column within a table

Column qualified attribute

DataStructure

Datatype

Domain

Cursor

Oracle Type

Program Datum

Table


Values for LANGUAGE_TYPE domain

Chart

Report

Screen

Utility


Values for MAPPING_TYPE domain

Augment

Override


Values for MOD_TYPE domain

Background

Chart

Cursor

Function

General

Manual

Report

Package

Procedure

Report

Screen

Trg-Logic

Utility


Values for MODULE_COMPONENT_LINK_TYPE domain

Key Based Link

Shared Data link


Values for MODULE_COMPONENT_TYPE domain

Re-usable

Specific


Values for MODULE_SUBTYPE domain

Module

PL/SQL Definition


Values for MTI_USAGE_TYPE domain

Base

Lookup

Single Row SQL Aggregate

Sub-Query


Values for NON_ORACLE_DATABASE_TYPE domain

ANSI

DB2

DB2/2

ORACLE LITE

RDB

SQL SERVER

SYBASE


Values for OBJECT_IMPLEMENTATION_TYPE domain

Cluster Implementation

PL/SQL Implementation

Snapshot Implementation

Sequence Implementation

Table Implementation

View Implementation


Values for OCO_CONSTRAINT_TYPE domain

Check

Foreign

Primary

Unique


Values for ODB_DATABASE_TYPE domain

Non-Oracle Database

Oracle Database


Values for OKY_CONSTRAINT_TYPE domain

Check

Foreign

Primary

Unique


Values for ORACLE_COLLECTION_TYPE domain

NESTED TABLE

VARRAY


Values for ORACLE_TYPE_SUBTYPE domain

Oracle Collection Type

Oracle Object Type


Values for OS_FILE_TYPE domain

Record File

Source File


Values for OSQ_SEQUENCE_TYPE domain

Code Control Sequence

ORACLE Sequence


Values for PASSED_VALUE_TYPE domain

Argument Passed Value

Named Passed Value


Values for PLS_DATA_TYPE domain

nn (no size)

nn (no size)

onl(size = [m]) rf len=precis,not scale

onl(size = [m]) rf len=precis,not scale

nn (no size)

oo (size = [m[,n])

oo (size = [m[,n])

oo (size = [m[,n])

on (size = [m])

wn (size = [m])-warn

wn (size = [m])-warn

nn (no size)

nn (no size)

nn (no size)

oo (size = [m[,n]])

oo (size = [m[,n]])

nn (no size)

yn (size = m)

oo (size = [m[,n]])

nn (no size)

oo (size = [m[,n]])

onl(size = [m]) rf len=precis,not scale

ynl(size = m) rf len=precis,not scale

onl (size = m) rf len=precis, not scale


Values for PLS_DATATYPE domain

BFILE

BINARY_INTEGER

BLOB

BOOLEAN

CHAR

CHARACTER

CLOB

DATE

DEC

DECIMAL

DOUBLE PRECISION

FLOAT

INT

INTEGER

LONG

LONG RAW

MLSLABEL

NATURAL

NATURALN

NCHAR

NCLOB

NUMBER

NUMERIC

NVARCHAR2

PLS_INTEGER

POSITIVE

POSITIVEN

RAW

REAL

ROWID

SIGNTYPE

SMALLINT

STRING

VARCHAR

VARCHAR2


Values for PLSQL_MOD_TYPE domain

Cursor

Function

Package

Procedure

Trg-Logic

Type Body


Values for REFRESH_TYPE domain

COMPLETE

FAST

FORCE


Values for RPT_DATASTORE_CHECK_TYPE domain

Without Input Dataflows

Without Input and Output Dataflows

Without Output Dataflows


Values for RPT_DATATYPE domain

Char

Date

Meta

Number

Reference


Values for RPT_DESTYPE domain

File

Mail

Preview

Printer

Screen


Values for RPT_ENTITY_CHECK_TYPE domain

All

With No Attributes

With No Description

Not Used by Functions

With No Relationships

With No Unique Identifiers


Values for RPT_FUNCTION_CHECK_TYPE domain

Atomic Functions not on any DFD

All Functions not on any DFD

Non-Atomic Functions not on any DFD


Values for RPT_GRPTYPE domain

Group

Hierarchy


Values for SET_TYPE domain

C++ Generator Class Set

User Defined Set


Values for STORE_TYPE domain

Data

Material

Unclassified


Values for TAB_TABLE_TYPE domain

Record Definition

Snapshot Definition

Table Definition

View Definition


Values for TABLE_OR_TYPE domain

Oracle Object Type

Relation Definition


Values for TCO_TYPE domain

Arc Type Constraint

Other Type Constraint

Uniqueness Type Constraint


Values for TME_TYPE domain

Association Role

Type Attribute

Type Operation


Values for TYPE_MEMBER_ORDERING domain

Map

Order


Values for TYPE_OPERATION_TYPE domain

Constructor


Values for UNBOUND_TYPE domain

Client Side Function

Computed

Custom

Server Side Function

SQL Aggregate

SQL Expression

Target Specific


Values for UNBOUND_TYPE_OF domain

Client Side Function

Computed

Custom

Server Side Function

SQL Expression


Values for UNBOUND_TYPE_OG domain

Client Side Function

Computed

Custom

Server Side Function

Shared Data

SQL Aggregate

SQL Expression

Target Specific


Values for UNBOUND_TYPE_VB domain

Custom


Values for UNBOUND_TYPE_WEB domain

Client Side Function

Custom

Server Side Function

SQL Expression


Navigator - Return to Object Reference
   Return to Object Reference (Navigator Menu)

Related Topics

Returns to the repository object from which you located a referenced object.


Navigator - Expand All
   Expand All (Navigator Menu)

Related Topics

Expands the selected node or nodes on the Navigator, to show all the levels of branches below.

This option is available only when a selected node or nodes can be expanded. The [image] icon is displayed next to all nodes that can be expanded.

To expand only a single level below a selected node, click the [image] icon.


Navigator - Collapse All
   Collapse All (Navigator Menu)

Related Topics

Collapses the selected node or nodes and all the levels of nodes below them on the Navigator. The Navigator does not store any information about the levels to which nodes are expanded.

This option is available only when a selected node has been expanded. If a node can be collapsed, the [image] icon is displayed next to it.

To collapse a node or nodes so that they can be expanded back to the same level, click the [image] icon.


Navigator - Set Mark
   Set Mark (Navigator Menu)

Related Topics

Places a bookmark on the currently selected repository object. The Navigator can have only one bookmark at a time. At a later stage, if you want to return to the bookmark, you can use Navigator→Goto Mark.


Navigator - Go to Mark
   Go to Mark (Navigator Menu)

Related Topics

Automatically scrolls the Navigator to the location of the bookmark. This option is available only if a bookmark has been set using Navigator→Set Mark.


Navigator - Go to Object Definition
   Go to Object Definition (Navigator Menu)

Related Topics

Navigates to a repository object that is referenced by a selected repository object.

For example, if a table has a foreign key defined, you can use this option to navigate to the definition of the table containing the primary key referenced by the foreign key.


Help - Help Topics
Help Topics (Help Menu)

Related Topics

Displays a list of the main subject areas in the online documentation system.


Help - Show Keys
Show Keys (Help Menu)

Displays the shortcut keys for the current tool.


Help - How to use Help
How to Use Help (Help Menu)

Related Topics

Displays general information on how to use the Microsoft Windows help.


Help - About
About (Help Menu)

Displays copyright and version number information about this application. You might need to know the version number for product support purposes.


Help - Customer Support
Customer Support (Help Menu)

Displays an Oracle Support Problem Report (displayed in your default ASCII text editor) that you are requested to complete before contacting Oracle Support for assistance. The report asks for details about you, your environment setup and details about the problem, including any steps to reproduce the problem. By completing this form prior to contacting Oracle Support, you will aid the processing and response to your request.

A default text editor is set up for ASCII text based on the settings in the Windows Registry. You can specify an alternative editor by using Options→Text Editor Options.


Context-Sensitive Help button
   Context-Sensitive Help

Related Topics

Provides access to context-sensitive help information about the menu options, standard toolbar and drawing toolbar buttons.

Selecting this button, or pressing SHIFT+F1, and then selecting a menu option, standard toolbar button or palette button, displays help information for the chosen item.


Options - Customize Property Palette
Customize Property Palette (Options Menu)

Customizes which properties are displayed on the Property Palette.

Dialog box options

Show

Show Owning Folder

Displays or hides the name of the owning container for an element.

Show Version Label

Displays or hides the version label property in the Property Palette.

Show Audit Properties

Displays the audit properties (date created, date changed etc.) in the Property Palette.

Property Clipboard

Include Multi Line Text Properties

Includes or excludes multi-line text properties in the Properties Clipboard, used when copying properties.

Automatically switch to spreadtable mode on multi insert

If active, automatically switches the Property Palette to spreadtable view when creating more than one element in a single operation.


Options - Text Editor Options
Text Editor Options (Options Menu)

Related Topics

Defines Text Editor options. This enables you to specify which text editor to use for the values of repository definition properties that are stored in ASCII or HTML format.

Default text editors are set up for ASCII text and HTML text based on the settings in the Windows Registry. You can specify alternative editors for either or both of these kinds of text.

Dialog box options

Text Editor

Select command to run the ASCII editor

The command that runs the ASCII text editor. Ensure that the filename is followed by the characters <SPACE>%1 in order for the command to function correctly.

Browse button

Locates the .EXE file for the ASCII text editor. Selecting this button displays the Browse dialog box.

HTML Editor

Select command to run the HTML editor

The command that runs the HTML editor. If you specify Netscape Navigator as the editor, ensure that the filename is followed by the characters <SPACE>"%1" for the command to function correctly.

Browse Button

Locates the .EXE file for the HTML editor. Selecting this button displays the Browse dialog box.


Options - Broadcast Options
Broadcast Options (Options Menu)

Related Topics

Defines broadcast options.

Dialog box options

Broadcast Notifications

Disabled

Turns off the broadcasting mechanism, i.e., the user does not receive (or send) notification messages.

Desktop only

Broadcasts all changes made in the current tool to all tools running on this machine.

Network

Broadcasts all changes made in the current tool to all users participating in the network broadcasting mechanism.


Options - Diagnostics
Diagnostics (Options Menu)

Allows you to set diagnostic file and trace settings. This feature should not be used unless requested to do so by your Oracle customer support representative. If you inadvertently set any of the diagnostic options you may find that the tool's performance is affected. If you do find any degradation in performance, click the Disable Option button to switch off the diagnostics facility.


Font dialog box

Allows you to specify the details of the font to be used for a text item.

Dialog box options

Font

Specifies the font to be used. You can choose a font from the list.

Font Style

Specifies the style for the selected font. You can choose a style from the list. Available styles are: regular, italic, bold and bold italic.

Size

Specifies the size in points of the font for this text item. A point is 1/72nd of an inch.

Sample

Shows an example of how this text item will appear with the current font options.

Script

Specifies the character set to be used for the selected text item.


File - Close
Close (File Menu)

Closes the active window without quitting the tool. To quit the tool use File→Exit.


File - Summary Information
Summary Information (File Menu)

Related Topics

Displays information about the active window and enables you to record additional information about the window.

The database connection and the current workarea cannot be changed using this menu option, but can be changed using File→Change Connection and File→Change Workarea.

Dialog box options

When the active window is a diagram, the dialog box has the following tabs:

Summary Details

Text

Otherwise, the Summary Information (without tabs) dialog box is displayed.


Summary Information - Summary Details

The Show checkbox adjacent to each field determines whether or not the information in the field is displayed in the print legend on the active window.

Note:	Summary information cannot be saved against a diagram unless that diagram has already been saved in the repository.

When a diagram is copied, i.e., you open a read-only copy of a currently open diagram, the summary information about that diagram does not get copied.

Diagram

The name of the active diagram.

Title

The title of the active window. The title can be used for displaying additional information on the window.

Created

The date and time on which the contents of the active window was created.

Last Modified

The date and time on which the contents of the active window was last modified.

Author

The author of the contents of the window.

Container

The name of the container that you are currently using.

Username

The username for the Oracle database that you are currently using.

Connect String

The connect string for the Oracle database that you are currently using.

Workarea

The name of the workarea that you are currently using.


Summary Information - Text

Related Topics

Used to enter free format multi-line text for the text types associated with the active diagram, such as notes and description.

Note:	Multi-line text can be entered only for named diagrams.

Text Type field

Defines which text type you want to enter multi-line text for. A list of currently defined text is available.

Text Editor button

Opens the ASCII editor, which enables you to attach ASCII text to the selected multi-line text property.

HTML Editor button

Opens the HTML editor, which enables you to attach HTML text to the selected multi-line text property.


Summary Information dialog box

Related Topics

Displays information about the Navigator. The checkbox adjacent to each field determines whether or not the information in the field is displayed in the print legend.

Workarea

The name of the workarea that you are currently using.

Username

The username for the Oracle database that you are currently using.

Connect String

The connect string for the Oracle database that you are currently using.


File - Change Connection
Change Connection (File Menu)

Related Topics

Changes the Oracle database to which the current tool is connected.

Connect dialog box


Connect dialog box

Specifies or changes the Oracle database to which the current tool is connected.

Username

The name of the user that must be specified to gain access to the database account.

You can specify the full connect string in this field, in the format:

username/password@database_alias

For example, to connect to a database with the alias HQ8 using the username and password scott, you would enter:

scott/scott@HQ8

Note:	If you specify the full connect string here, you do not need to complete the Password and Connect fields.

Password

The password for the given username. The password is displayed as asterisks.

Connect String

The database alias required to access the database account. You must ensure that the database alias is specified in the TNSNAMES.ORA file in your Oracle home directory, usually d:\oracle_home\NET80\ADMIN.


File - Change Workarea
Change Workarea (File Menu)

Related Topics

Changes the workarea for the current tool and provides access to the Workarea Wizard which allows you to create new workareas.

Note, you must have the repository management privilege before you can create workareas.

Workarea dialog box


Workarea dialog box

Specifies or changes the workarea for the current tool, and enables you to create a new workarea.

Workarea list box

Lists the workareas that you can choose, together with various details about them. You can choose a workarea by selecting it and clicking OK.

Workarea

The names of the workareas that have been defined in the repository.

Owner

The username of the repository user who created the workarea.

Type

Indicates whether this is a private or shared workarea. Private workareas can be accessed only by the user who created them. Shared workareas can be accessed by any user to whom the owner grants access.

Check In Branch

(Versioned repositories only) The default branch, if any, to which versioned objects are checked in if they are updated via this workarea.

New

Enables you to create a new workarea. Clicking this button starts the Create Workarea Wizard, a predefined set of screen forms that takes you step by step through the process of creating a workarea.


Create Workarea Wizard: Options

The Create Workarea Wizard: Options screen provides the following four options for creating a workarea:

Option	Description
Create a default workarea	Simplest option - just enter the workarea name
Copy a workarea	Copies an existing workarea, but allows you to modify workarea details in the copy
Create a workarea based on a file-stored workarea specification	Uses rules and configurations stored in a file to create the workarea; you can modify these and other details
Create a custom workarea	Provides greatest choice - you can manually define all the details of the workarea
Note:	To edit an existing workarea, select the workarea and choose Edit→Edit Workarea.

Additional fields are displayed from each of the four available options. These allow you to name the workarea, provide a suitable description for the new workarea and, where appropriate, name a workarea to copy from.

Once you have made your selection, the wizard takes you step by step through the process of creating the workarea.

When you create a workarea, it is initially a private workarea, meaning that only you can access it. Subsequently you can, if you wish, grant one or more other users access to it, thus making it a shared workarea. If you later revoke access to the workarea from all other users, the workarea becomes private again.

For all except a default workarea, you can specify a default checkin branch if the automatic branching policy is enabled. You can also change the rules and configurations that make up the workarea specification.

A basic workarea specification, consisting merely of the rule LATEST (MAIN), is applied to all new workareas by default. This rule specifies that each time the workarea is refreshed it will display details of the latest version of all objects to which you have access on the MAIN branch. It is not necessary for a workarea to have any other rules or any configurations specified for it, but if you want to refine the workarea specification, you can do so using the wizard.


Application System dialog box

Specifies or changes the application system for the current tool.

Application System entry box

Identifies the name of the application system you want to use. If an application system is selected in the list box, then the name of that application system is displayed in this field.

Application System list box

Lists the names and owners of all the application system that you may use. If you select an application system from this list, its name is displayed in the application system entry box.


File - Print
   Print (File Menu)

Related Topics

Prints the contents of the active window. This option enables you to specify the range of pages to be printed, the print quality, the number of copies, the destination printer and other printing options.

Dialog box options

Printer

The name of the current printer. The current printer can be changed using the Setup button. If the current printer is the system (that is, the default) printer it is stated in this field.

Print Range

All

Prints all pages. All is the default print range value.

Pages

Prints a range of pages specified by the From and To fields. For example, entering 2 in the From field and 6 in the To field prints pages 2 to 6 inclusive.

Print Quality

Specifies the print density. The higher the print density, the better the print quality, but higher-quality copies may take longer to print.

Copies

The number of copies of the print job that you want to print.

Print to File

Determines whether or not the print job is printed to a specified file instead of being sent to the printer. When checked, the Print to File dialog box is displayed.

Page Numbers

Determines whether or not page numbers are printed at the bottom of each page of the print job.

Print to ASCII

Prints the textual content of the Navigator window to a text file. If this box is checked, a dialog box is displayed for you to specify the name and location of the text file. Note this option is available from the Repository Object Navigator only.

Page Title

Determines whether or not the title is printed at the top of each page of the print job.

Page Boundaries

Determines whether or not indicators are displayed showing the outermost edges of the printable area of the page.

Scale to Pages

X:

Determines the number of pages in the horizontal axis on which the data will be printed.

Y:

Determines the number of pages in the vertical axis on which the data will be printed.

Fit to Page

Determines whether or not the data is printed so that it fits onto one sheet of the currently selected paper size.

Setup button

Allows you to view or change the configuration of the current printer, or to choose a different printer if more than one is available. Selecting this button displays the Print Setup dialog box.


File - Print Preview
Print Preview (File Menu)

Related Topics

Displays the contents of the active window as it will appear when printed, and provides options for navigating through, and for changing the magnification of, the pages within the Print Preview window. The contents of the active window can also be printed directly from this preview window.

Print preview buttons

Print button

Displays the Print dialog box, allowing you to specify how and where the data is printed, and to initiate the print job. Selecting this button cancels the Print Preview window.

Next Page button

Shows how the next page of the data will appear when printed.

Prev Page button

Shows how the previous page of the data will appear when printed.

One Page/Two Page button

Specifies whether one or two pages are previewed at a time.

Zoom In button

Enlarges part of the page preview display.

Zoom Out button

Reduces the magnification of the page preview display.


File - Print Setup
Print Setup (File Menu)

Related Topics

Configures printer settings such as the destination printer, the paper size and the paper orientation. Advanced document properties set within an application can also be set. These settings will override the default settings made in Windows.

Dialog box options

Printer

Determines whether you want to use the default printer or one of the other currently connected printers. A dropdown list of currently connected printers is available. The default printer can be changed, and other printers connected, from the Settings option on the Windows Start menu.

Orientation

Determines whether the printout will appear in portrait or landscape format. Selecting the appropriate option button changes the image of the page accordingly in this field.

Size

Determines the paper size for the printer.

Source

Determines the source of the paper for the printer.

Options button

Displays the Options dialog box for the currently selected printer, allowing you to set some of the more advanced document printing options. Third party printer help is available for the Options dialog box.


File - Recent File
Recent file (File Menu)

Opens any of the four most recently opened files (diagrams or logic text) in the current workarea. Diagrams or logic files in other workareas which have been opened recently may also be listed, but cannot be opened using this option.


File - Exit
Exit (File Menu)

Exits from the tool.


Browse dialog box

Directories

The directory where the file that you want to embed or link to is located.

Drives

The drive where the file that you want to embed or link to is located.

Network... button

Locates a file on the network. For more information, select the Help button on the Connect Network Drive dialog box.


Print to File dialog box (Description not used by Designer in 2.1)

Related Topics

Allows you to specify the name of the file to which a print job is to be saved.

File Name

Specifies the name of the file (maximum of eight characters, plus a three-letter extension), including its path, to which you want to print the diagram.

Attention:	The filename must be different from the original filename, or the diagram must be saved to a different drive or directory.

Note:	If no file of this name currently exists, one will be created.

All the files of the specified type in the specified directory are listed below the File Name field.

Save File as Type

Specifies the file extension for the file. It also filters the File Name list so that only files of the specified type are listed.

Drives

Select the drive on which you want to store the file.

Directories

Select the directory where you want to store the file.

Network button

Opens the Connect Network Drive dialog box so that you can make a connection to a network drive. For more information, choose the Help button in that dialog box.