Communication reviews

Field name

Type

Description

Values

Data type and size

Nullable

CommunicationReviewTitle

String

The title of the communication review.

nvarchar(510)

No

CommunicationRoutingPath

String

The routing path of the communication.

nvarchar(200)

No

CommunicationOwner

String

The name of the owner of the communication.

nvarchar(200)

No

CommunicationState

String

The state of the communication.

Note: 'Approved & Awaiting Agreement' is the alternative label for the Awaiting Agreement from Recipient state.

nvarchar(100)

No

CommunicationProcessLimitType

String

The type of due date of the communication. If this is Not Defined, the communication does not require agreement.

• Not Defined

• Target

• Deadline

nvarchar(100)

No

CommunicationTemplateTitle

String

The title of the communication template from which the communication was created.

nvarchar(510)

No

CommunicationTemplateAbbreviation

String

The abbreviation of the communication template from which the communication was created.

nvarchar(40)

No

CommunicationTitle

String

nvarchar(510)

No

CommunicationTemplateReportingCategory

String

The reporting template of the communication template from which the communication was created.

nvarchar(510)

No

CommunicationReportingCategory

String

The reporting category of the communication.

nvarchar(200)

No

ContractReference

String

The unique reference for the contract.

nvarchar(510)

No

ContractName

String

nvarchar(510)

No

ContractType

String

The type of the contract.

nvarchar(510)

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

Reviewers

String

The names of the company users, contract roles and business process roles who have been assigned as reviewers, separated by |.

e.g. |User|Contract Role|Business Process Role|

Use the contains filter to search for a specific reviewer - see Filtering the Returned Data.

nvarchar(8000)

No

DecisionSet

String

The decision set which applies to the review.

nvarchar(300)

No

DueDate

DateTime

The date which the review is due.

datetime

Yes

DueDateType

String

The type of due date for the review.

• Target

• Deadline

nvarchar(300)

No

ReviewState

String

The state of the review.

• In Progress

• Complete

• Cancelled

nvarchar(100)

No

ReviewType

String

The type of review.

• Best Practice Review

• Ad Hoc Review

nvarchar(100)

No

IsReviewOverdue

String

Indicates whether the due date of the review has passed.

• Yes

• No

nvarchar(6)

No

DaysOverdue

Int32

The number of days by which the review is overdue.

Integer

Yes

CommunicationTotalFinancialImpact

Decimal

The financial impact value of the communication in the communication currency.

money(19,4)

Yes

CommunicationTotalFinancialImpactBase

Decimal

The financial impact value of the communication in the base currency of the data.

money(19,4)

Yes

CommunicationTotalScheduleImpact

Int32

The schedule impact value of the communication.

Integer

Yes

IsDeleted

String

Indicates whether the contract to which the communication belongs is in the Recycle Bin.

nvarchar(100)

No

CommunicationId

Int32

The unique ID of the communication that the review belongs to.

Integer

No

CommunicationReviewId

Int32

The unique ID of the communication review.

Integer

No

CommunicationReviewerName

String

The name of the assigned reviewer.

nvarchar(510)

No

CommunicationReviewerUserRole

String

The user role of the reviewer.

nvarchar(510)

No

MemberOf

String

The names of the contract roles and business process roles assigned as reviewers that the user belongs to, separated by |.

e.g. |Contract Role|Business Process Role|

Use the contains filter to search for a specific contract role or business process role - see Filtering the Returned Data.

nvarchar(8000)

Yes

ReviewerProgress

String

The progress of the reviewer's contribution.

• Not Started

• Started

• Completed

nvarchar(40)

No

ReviewerStatus

String

The status of the reviewer's contribution.

• Partially Accepted

• Not Accepted

• Accepted

nvarchar(40)

No

FinalDecision

String

The final decision made for the review by the review administrator.

nvarchar(300)

Yes

CommunicationReviewOverdueWhenCompleted

String

Indicates whether the review was overdue at the time the final decision was made.

• Not Defined - review is still in progress​

• Yes​

• No ​

nvarchar(22)

No

LastUpdatedOn

DateTime

The date and time that the reviewer last made a change to the review.

datetime

Yes

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