Tender reviews
- Last UpdatedAug 02, 2024
- 2 minute read
The following table lists the fields which are available in the TenderReviews 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.
Tip One instance of a tender review exists for each assigned reviewer. This enables you to create widgets by reviewer (group by TenderReviewerID) as well as by review (group by TenderReviewID).
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 |
|
TenderReviewId |
Int32 |
The unique identifier of the tender review. |
Integer |
No |
|
|
TenderReviewerId |
Int32 |
The unique identifier of the assigned reviewer. |
Integer |
No |
|
|
BusinessUnitId |
Int32 |
The unique identifier of the business unit in which the tender is located. |
Integer |
No |
|
|
BusinessUnitName |
String |
The name of the business unit in which the tender is located. |
nvarchar(300) |
No |
|
|
ProjectDepartmentName |
String |
The reference and name of the project/dept in which the tender is located. |
nvarchar(300) |
No |
|
|
TenderName |
String |
The name of the tender. |
nvarchar(510) |
No |
|
|
TenderReference |
String |
The unique reference for the tender. |
nvarchar(510) |
No |
|
|
IsDeleted |
String |
Indicates whether the tender is in the Recycle Bin. |
|
nvarchar(100) |
No |
|
TenderStatus |
String |
The status of the tender. |
|
nvarchar(40) |
No |
|
Category |
String |
The category of the tender. |
nvarchar(510) |
No |
|
|
TenderId |
Int32 |
The unique identifier of the tender to which the review belongs. |
Integer |
No |
|
|
ScheduleItemId |
Int32 |
The unique identifier of the schedule item to which the review belongs. |
Integer |
No |
|
|
ScheduleItemTitle |
String |
The name of the schedule item to which the review belongs. |
nvarchar(510) |
No |
|
|
ScheduleItemStatus |
String |
The status of the schedule item to which the review belongs. |
|
nvarchar(40) |
No |
|
TenderReviewName |
String |
The name of the tender review. |
nvarchar(200) |
No |
|
|
TenderReviewerName |
String |
The name of the assigned reviewer. |
nvarchar(510) |
Yes |
|
|
TenderReviewerUserRole |
String |
The user role of the assigned reviewer. |
nvarchar(510) |
Yes |
|
|
TenderReviewerStatus |
String |
The status of the reviewer's review. |
|
nvarchar(40) |
Yes |
|
DueDate |
DateTimeOffset |
The date and time that the review is due. |
datetime |
Yes |
|
|
AssignedOnDate |
DateTimeOffset |
The date and time that the review was assigned to the reviewers. |
datetime |
Yes |
|
|
NumberDocumentsToReview |
Int32 |
The number of documents attached to the review. |
Integer |
No |
|
|
NumberReviewers |
Int32 |
The total number of assigned reviewers. |
Integer |
No |
|
|
NumberReviewersWithReviewDone |
Int32 |
The number of reviewers who have completed the review. |
Integer |
No |
|
|
ElapsedDurationBand |
Decimal |
The percentage of the review duration that has elapsed, where the review duration is the number of days between the AssignedDate and the DueDate. |
decimal |
No |
|
|
ProjectReference |
String |
The reference of the project/dept in which the tender is located. |
nvarchar(40) |
No |
|
|
DaysToDueDate |
Int32 |
The number of days until the due date of the review. |
Integer |
Yes |
|
|
OverdueReviewDuration |
Int32 |
The number of days since the due date of the review. |
Integer |
Yes |
|
|
DaysSinceReviewAssigned |
Int32 |
The number of days since the review was assigned. |
Integer |
Yes |
|
|
IsTenderReviewOverdue |
String |
Indicates if the review is overdue. |
|
nvarchar(6) |
Yes |