Breakdown items
- Last UpdatedAug 01, 2024
- 4 minute read
The following table lists the fields which are available in the BreakdownItems 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.
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 |
Date type and size |
Nullable |
|
ContractId |
Int32 |
The unique ID of the contract to which the breakdown items belong. |
Integer |
No |
|
ContractName |
String |
The name of the contract. |
nvarchar(510) |
No |
|
ContractReference |
String |
The unique reference for the contract. |
nvarchar(510) |
No |
|
ProjectDepartmentName |
String |
The name of the project/dept in which the contract is located. |
nvarchar(300) |
No |
|
BusinessUnitId |
Int32 |
The unique ID of the business unit in which the contract is located. |
Integer |
No |
|
CountryName |
String |
The country in which the contract operates. |
nvarchar(510) |
No |
|
ContractorReference |
String |
The unique reference for the contractor. |
nvarchar(40) |
No |
|
ContractorName |
String |
The name of the contractor. |
nvarchar(1022) |
No |
|
CompanyRepresentative |
String |
The name of the company user assigned to the Company Representative contract role. |
nvarchar(302) |
No |
|
ContractOwner |
String |
The name of the company user assigned to the Contract Owner contract role. |
nvarchar(302) |
No |
|
ContractorRepresentative |
String |
The name of the contractor user assigned to the Contractor Representative contract role. |
nvarchar(302) |
No |
|
BreakdownItemName |
String |
The name of the breakdown item. |
nvarchar(510) |
No |
|
BreakdownItemReference |
String |
The reference of the breakdown item. |
nvarchar(100) |
No |
|
InitialCommitmentValueBase |
Decimal |
The initial commitment value of the breakdown item, in the base currency of the data. |
money(19,4) |
Yes |
|
InitialCommitmentValue |
Decimal |
The initial commitment value of the breakdown item, in the breakdown item currency. |
money(19,4) |
Yes |
|
ApprovedCommitmentValueBase |
Decimal |
The approved commitment value of the breakdown item, in the base currency of the data. |
money(19,4) |
Yes |
|
ApprovedCommitmentValue |
Decimal |
The approved commitment value of the breakdown item, in the breakdown item currency. |
money(19,4) |
Yes |
|
ApprovedExpenditureValueBase |
Decimal |
The approved expenditure value of the breakdown item, in the base currency of the data. |
money(19,4) |
Yes |
|
ApprovedExpenditureValue |
Decimal |
The approved expenditure value of the breakdown item, in the breakdown item currency. |
money(19,4) |
Yes |
|
PendingExpenditureValueBase |
Decimal |
The pending expenditure value of the breakdown item, in the base currency of the data. |
money(19,4) |
Yes |
|
PendingExpenditureValue |
Decimal |
The pending expenditure value of the breakdown item, in the breakdown item currency. |
money(19,4) |
Yes |
|
PotentialExpenditureValueBase |
Decimal |
The potential expenditure value of the breakdown item, in the base currency of the data. |
money(19,4) |
Yes |
|
PotentialExpenditureValue |
Decimal |
The potential expenditure value of the breakdown item, in the breakdown item currency. |
money(19,4) |
Yes |
|
PendingCommitmentValueBase |
Decimal |
The pending commitment value of the breakdown item, in the base currency of the data. |
money(19,4) |
Yes |
|
PendingCommitmentValue |
Decimal |
The pending commitment value of the breakdown item, in the breakdown item currency. |
money(19,4) |
Yes |
|
PotentialCommitmentValueBase |
Decimal |
The potential commitment value of the breakdown item, in the base currency of the data. |
money(19,4) |
Yes |
|
PotentialCommitmentValue |
Decimal |
The potential commitment value of the breakdown item, in the breakdown item currency. |
money(19,4) |
Yes |
|
CommitmentExposureValueBase |
Decimal |
The total commitment value of the breakdown item, in the base currency of the data: PotentialCommitmentValueBase + PendingCommitmentValueBase + ApprovedCommitmentValueBase |
money(19,4) |
Yes |
|
CommitmentExposureValue |
Decimal |
The total commitment value of the breakdown item, in the breakdown item currency: PotentialCommitmentValue + PendingCommitmentValue + ApprovedCommitmentValue |
money(19,4) |
Yes |
|
ExpenditureExposureValueBase |
Decimal |
The total expenditure of the breakdown item, in the base currency of the data: PotentialExpenditureValueBase + PendingExpenditureValueBase + ApprovedExpenditureValueBase |
money(19,4) |
Yes |
|
ExpenditureExposureValue |
Decimal |
The total expenditure of the breakdown item, in the breakdown item currency: PotentialExpenditureValue + PendingExpenditureValue + ApprovedExpenditureValue |
money(19,4) |
Yes |
|
Currency |
String |
The currency of the breakdown item. |
nvarchar(510) |
No |
|
BusinessUnitName |
String |
The name of the business unit in which the contract is located. |
nvarchar(300) |
No |
|
ContractAdministrators |
String |
A list of users assigned to the Contract Administrator contract role. |
nvarchar(8000) |
Yes |
|
CreatedOnDate |
DateTime |
The date and time that the breakdown item was created. |
datetime |
No |
|
OverconsumedAmount |
Decimal |
The amount by which the breakdown item has been overconsumed, in the breakdown item currency: ApprovedCommitmentValue - ApprovedExpenditureValue |
money(19,4) |
Yes |
|
OverconsumedAmountBase |
Decimal |
The amount by which the breakdown item has been overconsumed, in the base currency of the data: ApprovedCommitmentValueBase - ApprovedExpenditureValueBase |
money(19,4) |
Yes |
|
BreakdownItemCommitmentFullyAllocated |
String |
Indicates whether the breakdown item commitment is fully allocated to line items, i.e. if the approved commitment for the contract's line items is equal to the approved commitment for the contract's breakdown items. Possible values are Yes and No. |
nvarchar(6) |
Yes |
|
UnallocatedBreakdownItemCommitment |
Decimal |
The amount of the breakdown item which has not been allocated to line items, in the breakdown item currency: ApprovedCommitmentValue of all line items associated with the breakdown item (converted to the breakdown item currency) - ApprovedCommitmentValue of the breakdown item |
money(19,4) |
Yes |
|
UnallocatedBreakdownItemCommitmentBase |
Decimal |
The amount of the breakdown item which has not been allocated to line items, in the base currency of the data: ApprovedCommitmentValueBase of all line items associated with the breakdown item - ApprovedCommitmentValueBase of the breakdown item |
money(19,4) |
Yes |
|
BreakdownItemChangePercentage |
Decimal |
The percentage of commitment change applied to the breakdown item: ApprovedCommitmentValue - InitialCommitmentValue (as a percentage) |
decimal |
Yes |
|
ConsumedExpenditurePercentage |
Decimal |
The percentage of the approved commitment of the breakdown item that has been consumed as expenditure: ApprovedExpenditureValue - ApprovedCommitmentValue (as a percentage) |
decimal |
Yes |
|
ProjectReference |
String |
The unique reference of the project/dept in which the contract is located. |
nvarchar(40) |
No |