Use this report to query or print selected data dictionary (DD) information, as desired. The data dictionary consists of a set of tables in the Costpoint database that describes database information including table descriptions, how the tables are used, their life cycles and business rules, as well as detailed information at the column level.
The data dictionary tables hold data for all of the following schemas, as applicable:
Transactional — This schema contains the business data related to the Costpoint screens and processes.
Metadata — This schema contains application descriptions and application component descriptions that are read by Costpoint at runtime and dictate application presentation and behavior attributes.
Administrative — This schema contains Costpoint system configuration and user authorization information.
After entering your specifications and options, click to start printing the data dictionary report.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.
Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.
Enter, or click to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this group box to specify the module, tables, and/or columns you want to include in this report.
Use the drop-down list box to select the desired range of Costpoint application modules you want to use. All data dictionary information associated with this module are included in this report. The following options are available:
All — Select this option to include all available records. The Start and End fields are disabled for this option.
One — Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range — Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning — Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End — Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Use this field to enter, or use to select, the starting module name, as applicable.
Use this field to enter, or use to select, the ending module name, as applicable.
Use this drop-down list box to specify the Costpoint database table(s) you want to include on this report. The following options are available:
All — Select this option to include all data dictionary tables associated with the Costpoint module you specified in the Module drop-down list box. The unlabeled field on the right is disabled for this option.
One — Select this option to include one specific data dictionary table on this report. Use the unlabeled field to the right to enter a table name.
Begins With — Select this option to include all data dictionary tables that begin with a specific set of characters. Use the unlabeled field on the right to enter a value.
Contains — Select this option to include all data dictionary tables that contain a specific set of characters within the table name. Use the unlabeled field on the right to enter a value.
Use this drop-down list box to specify the data dictionary table columns you want to include on this report. The following options are available:
All — Select this option to include all columns associated with the data dictionary table(s) you specified in the Table drop-down list box. The unlabeled field on the right is disabled for this option.
One — Select this option to include one data dictionary table column on this report. Use the unlabeled field to the right to enter a table name.
Begins With — Select this option to include all data dictionary table columns that begin with a specific set of characters. Use the unlabeled field on the right to enter a value.
Contains — Select this option to include all data dictionary table columns that contain a specific set of characters within the table name. Use the unlabeled field on the right to enter a value.
Use the drop-down list boxes in this group box to determine the primary sort, secondary sort, and page break settings.
Use this drop-down list box to select whether to primarily sort this report by Table or Module.
Use this drop-down list box to select whether to sort this report again, based on your selection in the 1st Sort drop-down list box, by Primary Key or Column Order.
Select this check box to insert a page break between tables or modules depending on your selection in the 1st Sort drop-down list box.
Use this group box to specify additional options.
Use the check boxes in this group box to include table and/or column information on this report.
Select this check box to include all data dictionary table information on this report.
Select this check box to include all data dictionary table column information on this report.