Contract_DIM Table

FlexNet Manager Suite (Cloud)

Contract_DIM is a dimension table storing contracts information.

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

Database Column

Details

ContractID

Type: integer. Key

Primary key to the contract.

ContractNo

Type: text (max 60 characters)

Contract No of the contract.

ContractName

Type: text (max 100 characters)

Contract Name of the contract.

VendorName

Type: text (max 64 characters). Nullable

Vendor Name of the contract.

IsEvergreen

Type: boolean

If the contract never expires of the contract.

StartDate

Type: datetime. Nullable

Start date of the contract.

ExpiryDate

Type: datetime. Nullable

Expiry date of the contract.

ReviewDate

Type: datetime. Nullable

Review date of the contract.

RenewalDate

Type: datetime. Nullable

Renewal date of the contract.

IsLinkedToLicense

Type: boolean

If the contract is linked to a license.

FlexNet Manager Suite (Cloud)

Current