PSM_ReportPub (ver6.0.0)
A entity, which represents a specific report publication.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CustomPageName | 6.0.0 | Varchar2(4000) | The virtual page name for a report that is published as a custom page. This option is only valid when publishing to PowerSchool portals. |
Description | 6.0.0 | Varchar2(4000) | The description of the published report. |
ID | 6.0.0 | Number(19) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
ModifiedTimestamp | 6.0.0 | Timestamp(6) | The date and time of the report project when it was published. This serves as the version number for the report project that was published. |
Name | 6.0.0 | Varchar2(256) | The published report name. This name may or may not be the same as the report project name. This may also be a non-unique name. Required. |
OutputType | 6.0.0 | Varchar2(256) | The format type of the report that will be generated when the report is executed. The valid output types are: PDF, Delimited Text, HTML, Excel, or Custom Page. Required. |
PublicationScope | 6.0.0 | Varchar2(256) | The scope of the audience for the report publication. Only two values are valid: Full or Limited. Full means that all Report Generators can run the report. Limited means that only specified accounts and groups/roles can run the report. Required. |
PublishedBy | 6.0.0 | Varchar2(256) | The name of the report developer who published the report. Required. |
PublishedTimeStamp | 6.0.0 | Timestamp(6) | The date and time the report was published. |
QueryObject | 6.0.0 | BLOB | XML data for the report query columns and filters. |
RunTimeParamObject | 6.0.0 | BLOB | XML data that affects report rendering. |
TemplateObject | 6.0.0 | BLOB | XML data for the layout and column mapping. |