Contract_FACT Table

FlexNet Manager Suite 2020 R1 (On-Premises)

Contract_FACT is a fact table storing contracts information per ComplianceOperator.

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 Contract_FACT table

Database Column

Details

ComplianceOperatorID

Type: integer. Key

Foreign key to the operator.

ContractID

Type: integer. Key

Foreign key of the contract.

ContractTypeID

Type: integer

Contract type ID of the contract.

ContractStatusID

Type: integer. Nullable

Contract status ID of the contract.

CurrencyID

Type: integer

Currency ID (total value id) of the contract.

GlobalAmount

Type: currency. Nullable

Global amount (total value) of the contract.

FlexNet Manager Suite (On-Premises)

2020 R1