Duplicated fields
- Last UpdatedAug 02, 2024
- 4 minute read
Many fields are duplicated across AVEVA Analytics data models to support their use in AVEVA Contract Risk Management dashboard widgets.
However, the amount of duplicated data can negatively impact the performance of queries to the Analytics API. Therefore, when retrieving data from the Analytics API for use in third-party applications such as Power BI, we recommend:
You only select the necessary fields in your queries to avoid retrieving duplicate data.
The following table lists the duplicated fields and the data models in which they are present.
|
Field |
Description |
Data models |
|
ContractName |
The name of the contract. |
Contracts, BreakdownItems, ContractLineItems, Communications, CommunicationReviews, CommunicationLineItems, Obligations |
|
ContractReference |
The unique reference for the contract. |
Contracts, BreakdownItems, ContractLineItems, Communications, CommunicationReviews, CommunicationLineItems, Obligations |
|
ProjectDepartmentName |
The name of the project/dept in which the contract is located. |
Contracts, BreakdownItems, Communications, CommunicationReviews, CommunicationLineItems, Obligations |
|
The reference and name of the project/dept in which the tender is located. |
||
|
BusinessUnitId |
The unique ID of the business unit in which the contract is located. |
Contracts, BreakdownItems, ContractLineItems, Communications, CommunicationReviews, CommunicationLineItems, Obligations, Communication Stories |
|
The unique identifier of the business unit in which the tender is located. |
||
|
ContractorReference |
The unique reference for the contractor. |
Contracts, BreakdownItems, ContractLineItems, Communications, CommunicationLineItems, Obligations |
|
ContractorName |
The name of the contractor. |
Contracts, BreakdownItems, ContractLineItems, Communications, CommunicationLineItems, Obligations |
|
BusinessUnitName |
The name of the business unit in which the contract is located. |
Contracts, BreakdownItems, Communications, CommunicationReviews, CommunicationLineItems, Obligations, Communication Stories |
|
The name of the business unit in which the tender is located. |
||
|
ProjectReference |
The unique reference of the project/dept in which the contract is located. |
Contracts, BreakdownItems, ContractLineItems, Communications, CommunicationReviews, Obligations, Communication Stories |
|
The unique reference of the project/dept in which the tender is located. |
||
|
ContractCurrency |
The base currency of the contract. |
|
|
CompanyRepresentative |
The name of the company user assigned to the Company Representative contract role. |
Contracts, BreakdownItems, Communications, CommunicationLineItems, Obligations |
|
ContractOwner |
The name of the company user assigned to the Contract Owner contract role. |
Contracts, BreakdownItems, Communications, CommunicationLineItems, Obligations |
|
ContractorRepresentative |
The name of the contractor user assigned to the Contractor Representative contract role. |
Contracts, BreakdownItems, CommunicationLineItems, Obligations |
|
CommunicationId |
The unique ID of the communication that the item belongs to. |
Communications, CommunicationReviews, CommunicationLineItems, Communication Stories |
|
CommunicationRoutingPath |
The routing path of the communication. |
|
|
CommunicationState |
The state of the communication. |
Communications, CommunicationReviews, CommunicationLineItems |
|
CommunicationProcessTimeLimitType |
Communications which require response only. The type of due date of the communication. If this is Not Defined, the communication does not require a response. |
|
|
CommunicationTemplateTitle |
The title of the communication template from which the communication was created. |
|
|
CommunicationTemplateAbbreviation |
The abbreviation of the communication template from which the communication was created. |
|
|
CommunicationTitle |
The title (subject) of the communication. |
Communications, CommunicationReviews, CommunicationLineItems |
|
CommunicationTemplateReportingCategory |
The reporting template of the communication template from which the communication was created. |
|
|
CommunicationReportingCategory |
The reporting category to which the communication is assigned. |
Communications, CommunicationReviews, CommunicationLineItems |
|
CommunicationTotalFinancialImpact |
The financial impact value of the communication in the communication currency. |
|
|
CommunicationTotalFinancialImpactBase |
The financial impact value of the communication in the base currency of the data. |
|
|
CommunicationTotalScheduleImpact |
The schedule impact value of the communication. |
|
|
IsDeleted |
Indicates whether the contract is in the Recycle Bin. |
Contracts, Communications, CommunicationReviews, CommunicationLineItems, Obligations |
|
Indicates whether the tender is in the Recycle Bin. Also known as IsTenderDeleted. |
||
|
CommunicationReference |
The reference of the communication - unique in the contract. |
Communications, CommunicationReviews, CommunicationLineItems |
|
CountryName |
The country in which the contract operates. |
|
|
BreakdownItemName |
The name of the breakdown item. |
|
|
BreakdownItemReference |
The reference of the breakdown item. |
|
|
CommunicationCurrency |
The base currency of the communication. |
|
|
ContractAdministrators |
A list of users assigned to the Contract Administrator contract role. |
Contracts, BreakdownItems, ContractLineItems, CommunicationLineItems |
|
LineItemCode |
The code of the line item. |
|
|
SupplementaryCode |
An additional code which can be used to identify the line item. |
|
|
LineItemType |
The type of line item. |
|
|
LineItemTitle |
The name of the line item. |
|
|
LineItemUnitOfMeasure |
Unit Rate line items only. The unit of measure of the line item. |
|
|
ControlAccountCode |
The code for the control account that the line item is associated with. |
|
|
ControlAccountName |
The name of the control account that the line item is associated with. |
|
|
LineItemCurrency |
The base currency of the line item. |
|
|
TenderName |
The name of the tender. |
|
|
TenderReference |
The unique reference for the tender. |
|
|
TenderId |
The unique identifier of the tender. |
|
|
Category |
The category of the tender. |
|
|
TenderStatus |
The status of the tender. |
|
|
ScheduleItemId |
The unique identifier of the schedule item. |
|
|
ScheduleItemTitle |
The title of the schedule item. |
|
|
ScheduleItemStatus |
The status of the schedule item. |