Tenders
- Last UpdatedAug 02, 2024
- 3 minute read
The following table lists the fields which are available in the Tenders data model.
If using a third-party application such as PowerBI, we recommend you select only the required fields. Many fields in the Analytics data models are duplicated and can be excluded from queries; see Duplicated fields for more information.
Any tender custom fields which have been configured by the Administrator are also available and can be used according to their type. The field names for custom fields are prefixed with Tender_Custom_Field_, e.g. Tender_Custom_Field_HSSE.
Warning If the custom field name contains any characters that are not alphanumeric, these are replaced by underscores in the Analytics data model.
For example:
• The tender custom field "Doc. Ref" has the Analytics field name of Tender_Custom_Field_Doc__Ref - the . and space are replaced by _
• The tender custom field "VAT#" has the Analytics field name of Tender_Custom_Field_VAT_ - the # is replaced by _
Note The base currency of the data is configured when AVEVA Contract Risk Management Analytics is installed.
Note For DateTime fields, only the date is stored. The time portion of the value of DateTime fields is therefore always 00:00.
|
Field name |
Type |
Description |
Values |
Data type and size |
Nullable |
|
TenderName |
String |
The name of the tender. |
nvarchar(510) |
No |
|
|
TenderReference |
String |
The unique reference for the tender. |
nvarchar(510) |
No |
|
|
TenderDescription |
String |
The description of the tender. |
nvarchar(8000) |
Yes |
|
|
IsDeleted |
String |
Indicates whether the tender is in the Recycle Bin. |
|
nvarchar(100) |
No |
|
PlannedStartDate |
DateTime |
The current planned start date of the tender process. |
datetime |
Yes |
|
|
PlannedEndDate |
DateTime |
The current planned end date of the tender process. |
datetime |
Yes |
|
|
ActualStartDate |
DateTime |
The actual start date of the tender process. |
datetime |
Yes |
|
|
ActualEndDate |
DateTime |
The actual end date of the tender process. |
datetime |
Yes |
|
|
Category |
String |
The category of the tender. |
nvarchar(510) |
No |
|
|
TenderTemplateName |
String |
The name of the tender template from which the tender was created. |
nvarchar(510) |
No |
|
|
EstimatedBudgetBase |
Decimal |
The estimated budget of the contract which will be or has been awarded, in the base currency of the data. |
money(19,4) |
No |
|
|
EstimatedBudget |
Decimal |
The estimated budget of the contract which will be or has been awarded. |
money(19,4) |
No |
|
|
ContractAwarded |
String |
Indicates if a contract has been awarded from the tender. |
|
nvarchar(6) |
No |
|
ContractReferences |
String |
The unique references of the contracts which have been awarded from the tender, separated by |. e.g. |100044C|100045C|. Use the contains filter to search for a specific contract - see Specifying URLs. |
nvarchar(8000) |
No |
|
|
ContractNames |
String |
The unique references of the contracts which have been awarded from the tender, separated by |. e.g. |Contract1|Contract2|. Use the contains filter to search for a specific contract - see Specifying URLs. |
nvarchar(8000) |
No |
|
|
ContractsAwardedTo |
String |
The names of the contractors who were awarded the contracts from this tender, separated by |. e.g. |ContractorA|ContractorB|. Use the contains filter to search for a specific contractor - see Specifying URLs. |
nvarchar(8000) |
No |
|
|
DaysStartDateDelayed |
Int32 |
The number of days that the start of the tender process was delayed. |
Integer |
Yes |
|
|
TenderDaysOverdue |
Int32 |
The number of days that the tender process is overdue. |
Integer |
Yes |
|
|
TenderStatus |
String |
The status of the tender. |
|
nvarchar(40) |
No |
|
HasActiveAlert |
String |
Indicates if the tender has any active alerts. |
|
nvarchar(6) |
No |
|
TenderDaysRemaining |
Int32 |
The number of days remaining for the tender process to be completed. |
Integer |
Yes |
|
|
ShortListedContractorNames |
String |
The names of the contractors who were shortlisted for this tender, separated by |. e.g. |ContractorA|ContractorB|. Use the contains filter to search for a specific contractor - see Specifying URLs. |
nvarchar(8000) |
No |
|
|
ShortListedContractorReferences |
String |
The references of the contractors who were shortlisted for this tender, separated by |. e.g. |ContractorA|ContractorB|. Use the contains filter to search for a specific contractor - see Specifying URLs. |
nvarchar(8000) |
No |
|
|
ProjectDepartmentName |
String |
The reference and name of the project/dept in which the tender is located. |
nvarchar(300) |
No |
|
|
BusinessUnitId |
Int32 |
The unique identifier of the business unit in which the tender is located. |
Integer |
No |
|
|
ProjectReference |
String |
The unique reference of the project/dept in which the tender is located. |
nvarchar(40) |
No |
|
|
BusinessUnitName |
String |
The name of the business unit in which the tender is located. |
nvarchar(300) |
No |
|
|
TenderCurrency |
String |
The currency of the tender. |
nvarchar(255) |
No |
|
|
TenderCreatedOn |
DateTime |
The date and time that the tender was created. |
datetime |
No |