PSM_ReportTreeParamAssoc (ver6.0.0)
A table used to associate a Report Tree 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. |
FilterDecision | 6.2.0 | Number(3) | Set to 1 if the filter to be applied should be read from PSM_ReportParamOptions.FilterSQL or PSM_ReportParamOptions.DistrictSQL. |
FilterSQL | 6.2.0 | Varchar2(4000) | Filter expression applied to the query when running school level. |
ID | 6.0.0 | Number(19) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
ReportParameterID | 6.0.0 | Number(19) | Sequential number generated by the application, uniqueness in the PSM_ReportParameter table and is guaranteed by Primary Key Unique Index on that table. Required. |
ReportTreeID | 6.0.0 | Number(19) | Sequential number generated by the application, uniqueness in the PSM_ReportTree table and is guaranteed by Primary Key Unique Index on that table. Required. |
SortOrder | 6.0.0 | Number(10) | A number representing the relative sort of report trees and report parameters as displayed in the user interface. |