ComplianceSearchType Table

ComplianceSearchType is a static table holding the name of the basic objects, such as an asset or license, for which custom views can be created.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for ComplianceSearchType table

Database Column

Details

ComplianceSearchTypeID

Type: integer. Key. Generated ID

A unique identifier for a type of compliance search. Possible values, together with the associated names of the object being searched, are:

  • -1 = Custom
  • 1 = Asset
  • 2 = License
  • 3 = Contract
  • 4 = Vendor
  • 5 = PurchaseOrder
  • 6 = SoftwareTitle
  • 7 = User
  • 8 = Computer
  • 13 = PurchaseOrderDetail
  • 14 = VirtualMachine
  • 15 = InstalledSoftware
  • 16 = SoftwareLicenseAllocation
  • 17 = PaymentSchedule
  • 18 = PaymentScheduleDetail
  • 19 = OracleInstance
  • 20 = OracleComponent
  • 21 = Suite
  • 22 = SuiteMember
  • 23 = TermAndCondition
  • 24 = ContractHistoryView
  • 25 = ContractDocumentView
  • 26 = DocumentNote
  • 27 = ComplianceResponsibility
  • 28 = ContractNote
  • 29 = Location
  • 30 = CostCenter
  • 31 = CorporateStructure
  • 32 = Category
  • 33 = VendorContact
  • 34 = Cluster
  • 35 = CloudServiceInstance.
TypeName

Type: text (max 64 characters). Key

The name of the objects being searched.

TypeNameResourceName

Type: text (max 256 characters). Nullable

The unique name of the localizable resource string representing a type name. Foreign key to the ComplianceResourceString table.

QuerySetup

Type: text. Nullable

Query pre-calculation statement executed before custom view query.

QueryFilter

Type: text. Nullable

Query filter template executed before custom view query.

QueryTemplate

Type: text. Nullable

Query template for this search type.

IsCustom

Type: boolean

False if the relation is out of the box, false otherwise.