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 |
SF_ReportName | VARCHAR(20) | Name of the reports |
SF_ReportBody | BLOB | Archived SFSavedReport object |
SF_Opened | LOGICAL | Flag to track viewed status of the report |
SF_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.
SF_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.
SF_Opened is set to TRUE if the saved report has been viewed at least once.