Saved Reports Table
Reports generated in the background are saved upon their completion in table SF_SYSReports that has the following structure:
Column | Generalized data type | Use |
ReportName | VARCHAR(20) | Name of the reports |
ReportBody | BLOB | Archived SFSavedReport object |
Opened | LOGICAL | Flag to track viewed status of the report |
Pages | INT | Number of pages in the report |
SF_UserId | VARCHAR(255) | User-id of the user that created the report |
SF_DateChanged | CHAR(8) | Date of the last update of the row (CCYYMMDD) |
SF_TimeChanged | CHAR(6) | Time of the last update of the row (HHMMSS) |
SF_TimeStamp | SMALLINT | Version of the row (incremented with each update) |
Notes:
The table contains one row for each saved report.
ReportBody stores an archived SFSavedReport object that encapsulates arrays and other objects that contain report data, from which an image of the printed page is generated.
Opened is set to TRUE if the saved report has been viewed at least once.