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.