Contract obligations
- Last UpdatedAug 02, 2024
- 2 minute read
The following table lists the fields which are available in the Obligations 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 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 |
|
ObligationTitle |
String |
The title of the obligation. |
nvarchar(510) |
No |
|
|
ObligationType |
String |
The type of obligation:
|
|
nvarchar(200) |
No |
|
Owner |
String |
The owner of the obligation. |
|
nvarchar(510) |
No |
|
State |
String |
The state of the obligation. |
|
nvarchar(100) |
No |
|
InitiatedBy |
String |
For obligations of type Communication, the reference of the communication which initiated the obligation. |
nvarchar(120) |
No |
|
|
DueDate |
DateTime |
The due date of the obligation, if any. |
datetime |
Yes |
|
|
DoesTheObligationHaveADueDate |
String |
Indicates whether the obligation has a due date. |
|
nvarchar(6) |
No |
|
ResponsibleParty |
String |
The name of the responsible party for the obligation. Can be a company user, contract role or a business process role. |
nvarchar(510) |
No |
|
|
ObligationIsOverdue |
String |
Indicates whether the obligation is overdue. |
|
nvarchar(6) |
No |
|
ObligationOverdueWhenClosed |
String |
Completed obligations only. Indicates whether the obligation was overdue at the time it was completed. |
|
nvarchar(28) |
No |
|
DaysOverdue |
Int32 |
The number of days by which the obligation is overdue. |
Integer |
Yes |
|
|
DaysToDueDate |
Int32 |
The number of days until the due date of the obligation. |
Integer |
Yes |
|
|
ContractReference |
String |
The unique reference for the contract. |
nvarchar(510) |
No |
|
|
ContractName |
String |
The name of the contract. |
nvarchar(510) |
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 |
|
|
ContractorRef |
String |
The unique reference for the contractor. |
nvarchar(40) |
No |
|
|
ContractorName |
String |
The name of the contractor. |
nvarchar(1022) |
No |
|
|
ProjectDepartmentName |
String |
The reference and 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 |
|
|
IsDeleted |
String |
Indicates whether the contract to which the obligation belongs is in the Recycle Bin. |
|
nvarchar(100) |
No |
|
ProjectReference |
String |
The unique reference of the project/dept in which the contract is located. |
nvarchar(40) |
No |
|
|
BusinessUnitName |
String |
The name of the business unit in which the contract is located. |
nvarchar(300) |
No |