Schedule items
- Last UpdatedAug 02, 2024
- 2 minute read
The following table lists the fields which are available in the ScheduleItems 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 |
|
TenderID |
Int32 |
The unique ID of the tender to which the schedule item belongs. |
Integer |
No |
|
|
TenderReference |
String |
The unique reference for the tender to which the schedule item belongs. |
nvarchar(510) |
No |
|
|
TenderName |
String |
The name of the tender to which the schedule item belongs. |
nvarchar(510) |
No |
|
|
IsTenderDeleted |
String |
Indicates whether the tender to which the schedule item belongs is in the Recycle Bin. |
nvarchar(100) |
No |
|
|
TenderStatus |
String |
The status of the tender to which the schedule item belongs. |
nvarchar(40) |
No |
|
|
TenderScheduleItemType |
String |
The type of the schedule item. |
nvarchar(40) |
No |
|
|
Category |
String |
The category of the tender to which the schedule item belongs. |
nvarchar(510) |
No |
|
|
ScheduleItemTitle |
String |
The title of the schedule item. |
nvarchar(510) |
No |
|
|
ScheduleItemStatus |
String |
The status of the schedule item. |
nvarchar(40) |
No |
|
|
MinimumDuration |
Int32 |
The minimum number of days that the schedule item should take, as defined in the tender template. |
Integer |
No |
|
|
MaximumDuration |
Int32 |
The maximum number of days that the schedule item should take, as defined in the tender template. |
Integer |
No |
|
|
PlannedDuration |
Int32 |
The planned number of days that the schedule item should take. |
Integer |
Yes |
|
|
ActualDuration |
Int32 |
The actual number of days that the schedule item took. |
Integer |
Yes |
|
|
PlannedStartDate |
DateTime |
The current planned start date of the schedule item. |
datetime |
Yes |
|
|
PlannedEndDate |
DateTime |
The current planned end date of the schedule item. |
datetime |
Yes |
|
|
ActualStartDate |
DateTime |
The actual start date of the schedule item. |
datetime |
Yes |
|
|
ActualEndDate |
DateTime |
The actual end date of the schedule item. |
datetime |
Yes |
|
|
OriginalStartDate |
DateTime |
The original start date of the schedule item. |
datetime |
No |
|
|
OriginalEndDate |
DateTime |
The original end date of the schedule item. |
datetime |
No |
|
|
DaysStartDateDelayed |
Int32 |
The number of days that the start of the schedule item was delayed. |
Integer |
Yes |
|
|
DaysOverdue |
Int32 |
The number of days that the schedule item is overdue. |
Integer |
Yes |
|
|
DespatchDate |
DateTime |
Despatch/Tracking schedule items only. The date that the dispatch was sent. |
datetime |
Yes |
|
|
FinalSubmissionDate |
DateTime |
Despatch/Tracking schedule items only. The final submission date by which bidders must submit their bids. |
datetime |
Yes |
|
|
ProjectDepartmentName |
String |
The reference and name of the project/dept in which the tender is located. |
nvarchar(300) |
No |
|
|
BusinessUnitId |
Int32 |
The unique ID of the business unit in which the tender is located. |
Integer |
No |
|
|
ProjectReference |
String |
The unique reference of the project/dept in which the tender is located. |
nvarchar(40) |
No |
|
|
BusinessUnitName |
String |
The name of the business unit in which the tender is located. |
nvarchar(300) |
No |