CST_Param (ver6.1.0)
This table is to be used for state reporting. It identifies the required parameters for each report.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Description | 6.1.0 | Varchar2(500) | Description of the parameter. |
DefaultVal | 6.2.1 | CLOB | Data provided in a report configuration file for populating parameter entry fields. |
ID | 6.1.0 | Number(19,0) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
InputLabel | 6.1.0 | Varchar2(255) | The label string to place on the input control. |
InputType | 6.1.0 | Varchar2(50) | The type of input control presented to the user for the parameter, such as pop-up menu, radio button, text field, etc. This is interpreted at the presentation layer. |
IsInternal | 6.1.0 | Number(1,0) | 1 indicates the parameter should not be displayed in the UI. |
IsRequired | 6.1.0 | Number(1,0) | 1 indicates a parameter value is required to be entered the user in the UI. |
IsSaveDisabled | 8.2.0 | Number(1,0) | A value of 1 will prevent the user from being able to save a local default value for this parameter. Defaults to 0. |
JavaCollType | 6.1.0 | Varchar2(50) | Indicates the specific java collection class type of the parameter if it is a collection of multiple values. The collection will contain instances of a type specified by the java type field. |
JavaType | 6.1.0 | Varchar2(50) | Indicates the java class type of the individual parameter value. |
Name | 6.1.0 | Varchar2(50) | Name of the parameter. |
OptDataDefaultValStmt | 6.2.1 | Varchar2(4000) | An SQL-formatted filter expression indicating the default values for the related UI parameter input. |
OptDataSortByStmt | 6.1.0 | Varchar2(4000) | Used to populate optional values for input controls that require them, such as a pop-up menu. Indicates the sort by clause used to order the options. |
OptDataSrc | 6.1.0 | Varchar2(4000) | Used to populate optional values for input controls that require them, such as a pop-up menu. Indicates the table or java class from which to draw options. |
OptDataTextFld | 6.1.0 | Varchar2(4000) | Used to populate optional values for input controls that require them, such as a pop-up menu. Indicates which column in the source table that provides the displayable text part of the option. |
OptDataValueFld | 6.1.0 | Varchar2(4000) | Used to populate optional values for input controls that require them, such as a pop-up menu. Indicates which column in the source table that provides the value part of the option. |
OptDataWhereStmt | 6.1.0 | Varchar2(255) | Used to populate optional values for input controls that require them, such as a pop-up menu. Indicates the where clause to filter the options by in the source table. |
ReportConfigID | 6.1.0 | Number(19,0) | The internal ID for the CST_ReportConfig record to which the record is associated. |
SortIndex | 6.1.0 | Number(6,0) | Indexing field used by Hibernate. |
WhenCreated | 6.2.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 6.2.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.0 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 6.2.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. |