CST_ReportConfig (ver6.1.0)
This table is to be used for state reporting. Contains report configuration information.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ConfigFileID | 6.2.1 | Number(19,0) | The internal ID for the CST_ConfigFile record to which the record is associated. |
Description | 6.1.0 | Varchar2(500) | Description of the report. |
DisableEmtpyResultsMsg | 7.6.0 | Number(1,0) | 1 indicates that the rendering of the message "No Results Found" should be disabled in the output even if no records are returned by the query. Defaults to 0. |
| DisableReportListSubmit | 9.2.4 | Number(1,0) | 1 indicates that this report should not be allowed to be submitted directly from the report list page. Defaults to 0. |
| FeatureFlag | 23.5.0 | Varchar2(150 char) | Indicates the name of the feature flag used for the report |
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. |
IsExternalLinkOnly | 7.6.0 | Number(1,0) | 1 indicates to the framework that the report link to be rendered is not for an SRP report. Defaults to 0. |
IsTeacherSafe | 7.2.2 | Number(1,0) | Indicates whether or not the report displays for and can be run by teachers in PowerTeacher. 1 = Allow in PowerTeacher. 0 = Do not allow in PowerTeacher. |
| MaxAppVersion | 9.0.0 | Varchar2(50) | The maximum PowerSchool version (inclusive) in which the report is able to run. |
MinAppVersion | 9.0.0 | Varchar2(50) | The minimum PowerSchool version (inclusive) in which the report is able to run. |
ParamEntryURL | 6.1.0 | Varchar2(255) | The URL to the parameter entry page for the report. |
PartitionCollParam | 6.1.0 | Varchar2(50) | The name of the report parameter that is a collection type containing the unique partition identifiers. |
PartitionType | 6.1.0 | Varchar2(20) | The partition type to use for sub-processing. This would typically be set to "school". No other partition types are currently defined. |
PartitionUnitParam | 6.1.0 | Varchar2(50) | The name of the report parameter that is a single unique partition identifier. |
| PostSubmitAction | 9.2.0 | Varchar2(300) | The name of a Java class to run after a report request has been submitted. Post submit actions are optional. |
PreConditionQueryName | 9.0.0 | Varchar2(300) | Name of query or Java class to run in order to check whether precondition is met. If a Java class is specified, it must be encapsulated in a "Class" token. For example, "@Class(com.reporting.srp.sdk.precon.DashboardSchedJobPreConEval)". Preconditions are optional. |
QuoteFields | 7.6.0 | Number(1,0) | 1 indicates that output files should have their field values surrounded by double quotes. Affects only CSV or delimited text outputs. Defaults to 0. |
RecordDelimiter | 6.2.2.2 | Varchar2(50) | An optional record delimiter for reports in CSV output format. |
RenderClass | 6.2.1.7 | Varchar2(255) | Defines the fully qualified name of a java class to use as the render implementation; if specified overrides the default render implementation. The specified java class must be a subclass of the base Render class. |
ReportDelimiter | 6.2.0 | Varchar2(50) | An optional field delimiter for reports in CSV output format. |
ReportDistrictSchool | 6.2.1.7 | Number(10) | 1 indicates that the district school (internal ID of 0) will be included in the set of schools selected for reporting. 0 indicates that it will be excluded. |
ReportExcludedSchool | 6.2.1.7 | Number(10) | 1 indicates that schools with a State_ExcludeFromReporting field value of 1 (in Schools table) will still be included in the set of schools selected for reporting. |
ReportName | 6.1.0 | Varchar2(50) | This field, along with the StateCode, forms a unique identifier for the report. An empty StateCode field is also part of a valid combination. An empty StateCode field indicates a global report. Required. |
ReportOutputFileExtension | 6.2.1.7 | Varchar2(10) | File extension override for report output file; overrides what would otherwise be the assumed default based on report output type. |
ReportOutputFileName | 6.1.0 | Varchar2(255) | The name of the output file for the report, excluding the path. |
ReportOutputType | 6.1.0 | Varchar2(10) | The report output format for this specific report. Formats include csv, excel, html, jpeg, pdf, png, rtf, and xml. |
| ReportQueueDesc | 9.2.2 | Varchar2(1000) | Descriptive dynamic text about a particular report job that is displayed in the report queue. |
ReportVersion | 6.1.0 | Varchar2(1000) | The version number of the report. Typically incremented with each distributed revision of the report. |
ResultTableNamePattern | 6.1.0 | Varchar2(50) | The table-naming pattern for the result table generated for a report. |
| TabName | 8.3.0 | Varchar2(100) | Name of the tab page on which to list this report. |
StateCode | 6.1.0 | Varchar2(10) | The state code associated with the report, such as CA or NE. This field, along with ReportName, forms a unique identifier for the report. An empty StateCode field is also part of a valid combination. An empty StateCode field indicates a global report. |
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. |