Use this screen to provide a mapping between the fields in the many Costpoint applications and the database tables that the applications display and update. You can also select one or more tables and columns to determine if the application displays and/or allows editing to those tables and columns.
Use this screen whenever you want to determine relationships between the various Costpoint applications and the database tables displayed and/or updated by the applications.
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. Once 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. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should 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 produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Select an Application option from this drop-down list:
All - if you want to include all applications on the report.
One - to include only the application you select in the Start field to the right.
Range - to include the applications you enter in the Start and End fields to the right and all applications between them.
From Beginning - to include all applications from the beginning of the list through the one you enter in the End field to the right.
To End - to include all applications from the one you enter in the Start field to the right, through the end of the list of applications.
Enter, or use Lookup to select, a starting application. You need to complete this field if you have chosen "All," "One," "Range," or "To End" in the Application Option field.
Enter, or use Lookup to select, an ending application. You need to complete this field if you have chosen "All," "Range," or "From Beginning" in the Application Option field.
Select a table option from this drop-down list:
All - if you want to include all tables on the report.
One - if you want to select a particular table for the report. If you make this selection, you must enter, or use Lookup to select, a table designation in the Start field to the right.
Enter, or use Lookup to select, a table name if you have selected "One" in the Table Option field.
Select a column option from this drop-down list:
All - if you want to include all columns on the report
One - to include only the column you select in the Start field to the right
Contains - to enable entry of partial text in the Column Start field to the right.
Enter, or use Lookup to select, a column name if you have selected "One" in the Column Option field.
If you selected "Contains" in the Column Option field, enter partial text in this field.
Example: To have only columns with names including the letters "ACC" in the report, enter "ACC" in this field.
1st Sort *
Select your initial sort option from the drop-down list in this required field. Your options are "Application Name," "Module," and "Table."
|
|
Note: Some field values may be calculated or displayed from a result set. These display as "Derived" in the report. These fields only display when the 1st Sort is either "Application Name" or "Module." |
Select a secondary sort from the drop-down list in this field. Your options are "Application Name," Column," "Table Tab Order," "Column Label," and "Table."
Select this checkbox to include non-editable fields in the report.
* A red asterisk denotes a required field.
Data for the report derives from the S_RS_DESCRIPTION and S_RS_PRESENTATION tables.
