vdsReport

The vdsReport table contains the attributes of the existing reports defined in OneSpan Authentication Server.

Columns

Table: vdsReport table columns
Column name Data type Primary key Nullable Description
vdsDomain varchar(255) Yes No  
vdsReportID varchar(64) Yes No  
vdsReportName varchar(64) No No The name of the report.
vdsReportDesc varchar(255) No Yes  
vdsDataSource integer No No The source from where the data in the report originates.
vdsGroupLevel integer No Yes This is used to group the information in the report into the format required.
vdsReportType integer No No  
vdsRunPerms integer No No The usage permissions specifying who can view and run the report.
vdsChangePerms integer No No The change permissions specifying who can change the report.
vdsTimeFreq integer No Yes Specifies the sub-count time frequency for trend analysis reports.
vdsQueryDef varchar(4000) No No  
vdsUserID varchar(255) No Yes  
vdsCreateTime timestamp No No The date and time the data record was created.
vdsModifyTime timestamp No No The date and time the data record was last modified.
vdsVersion integer No Yes The current data schema version of the data record.

Keys

Primary key: (vdsDomain, vdsReportID)

Foreign keys:

  • (vdsDomain) references vdsDomain (vdsDomain)
  • (vdsDomain, vdsUserID) references vdsUser (vdsDomain, vdsUserID)

Indexes

Table: vdsReport table indexes
Index name Included fields
Level 0 (default)
vdsreportidx

vdsDomain

vdsReportId