Stage Gates
- Last UpdatedAug 02, 2024
- 3 minute read
The following table lists the fields which are available in the StageGates 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 Data is only shown for stage gates for which a stage gate package has been created.
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 |
|
ProjectDepartmentName |
String |
The reference and name of the project/dept in which the tender is located. |
nvarchar(300) |
No |
|
|
BusinessUnitName |
String |
The name of the business unit in which the tender is located. |
nvarchar(300) |
No |
|
|
BusinessUnitId |
Int32 |
The unique identifier of the business unit in which the tender is located. |
Integer |
No |
|
|
TenderReference |
String |
The unique reference for the tender. |
nvarchar(510) |
No |
|
|
TenderName |
String |
The name of the tender. |
nvarchar(510) |
No |
|
|
IsTenderDeleted |
String |
Indicates whether the tender is in the Recycle Bin. |
|
nvarchar(100) |
No |
|
TenderStatus |
String |
The status of the tender. |
|
nvarchar(40) |
No |
|
TenderId |
Int32 |
The unique identifier of the tender to which the stage gate belongs. |
Integer |
No |
|
|
StageGateId |
Int32 |
The unique identifier of the stage gate. |
Integer |
No |
|
|
Category |
String |
The category of the tender. |
nvarchar(510) |
No |
|
|
ScheduleItemTitle |
String |
The name of the stage gate schedule item. |
nvarchar(510) |
No |
|
|
ScheduleItemStatus |
String |
The status of the stage gate schedule item. |
|
nvarchar(40) |
No |
|
StageGatePackageName |
String |
The name of the stage gate package. |
nvarchar(510) |
No |
|
|
IssuedBy |
String |
The name of the user who issued the stage gate package. |
nvarchar(510) |
No |
|
|
IssuedByUserRole |
String |
The user role of the user who issued the stage gate package. |
nvarchar(510) |
No |
|
|
FirstIssuedDate |
DateTimeOffset |
The date and time that the stage gate package was first issued. |
datetime |
Yes |
|
|
BusinessProcessRole |
String |
The name of the business process role to which the stage gate package is assigned. |
nvarchar(510) |
No |
|
|
BusinessProcessRoleMembers |
String |
The members of the business process role to which the stage gate package is assigned. |
nvarchar(8000) |
No |
|
|
RequestedResponseDate |
DateTimeOffset |
The date and time that the stage gate response is due. |
datetime |
Yes |
|
|
EstimatedApprovalDate |
DateTimeOffset |
The date and time that the business process role has given as their estimated approval date. |
datetime |
Yes |
|
|
PlannedApprovalDuration |
Int32 |
The number of days that the approval is planned to take. |
Integer |
Yes |
|
|
ActualApprovalDuration |
Int32 |
The number of days that the approval actually took. |
Integer |
Yes |
|
|
PackageRevisions |
String |
The number of revisions of the stage gate package. |
nvarchar(24) |
No |
|
|
LatestApprovalStatus |
String |
The latest response sent by the business process role. |
nvarchar(300) |
No |
|
|
IsOverdue |
String |
Indicates if the stage gate response is overdue. |
|
nvarchar(30) |
No |
|
OverdueDays |
Int32 |
The number of days that the stage gate response is overdue. |
Integer |
Yes |
|
|
DaysSincePackageIssued |
Int32 |
The number of days since the stage gate package was issued. |
Integer |
Yes |
|
|
StageGateOverdueWhenCompleted |
String |
Indicates whether the stage gate was overdue when the formal response was made. |
|
nvarchar(28) |
No |
|
ProjectReference |
String |
The unique reference of the project/dept in which the tender is located. |
nvarchar(40) |
No |