PSM_ReportParamOptions (ver6.0.0)
Additional attributes related to report parameters.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DistrictFilterSQL | 6.2.0 | Varchar2(4000) | Filter expression applied to the query when running in district level and the option is selected. |
FilterSQL | 6.2.0 | Varchar2(4000) | Filter expression applied to the query when running in school level and the option is selected. |
DefaultValue | 6.0.0 | Number(3) | The default value if there are multiple options for a single report parameter. |
ID | 6.0.0 | Number(19) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
OptionText | 6.2.0 | Varchar2(500) | Text to display for the option. |
OptionValue | 6.0.0 | Varchar2(256) | The value of the report parameter. Different values given for user to choose. |
ReportParameterID | 6.0.0 | Number(19) | The report parameter entity to which the report parameter option is related. Required. |
SortOrder | 6.0.0 | Number(10) | A number specifying the order that the parameter options should be sorted when displayed. |