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.