Overview
Views in Bizagi are SQL queries created to efficiently retrieve and organize essential project data from database tables. Specifically tailored for reporting, these views encompass crucial information about Processes, Cases, Users, Personas, and other pertinent project details.
Prefixed with vwBA_ODS, they are distinguished from standard database views, which use vwBA.
These Views provide a streamlined approach to accessing critical information necessary for meeting business needs, ensuring clarity and ease of data retrieval and utilization.
Views
Process
The Views containing information about the automated processes in your Bizagi project are:
•WORKFLOW (vwBA_ODS_WF_WORKFLOW)
•TASKS (vwBA_ODS_WF_TASK)
•TRANSITIONS (vwBA_ODS_WF_TRANSITION)
WORKFLOW (vwBA_ODS_WF_WORKFLOW)
Retrieves information on the processes and their various versions, including details about the Applications, Process Entity, and the attribute linking the Process Entity.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWFClass |
int, not null |
The identifier of the Process. It is related to the WFCLASS table. |
wfClsName |
nvarchar(26), not null |
The name of the Process. |
wfClsDisplayName |
nvarchar(40), null |
The display name of the Process. |
wfAccessTypeName |
nvarchar(20), null |
The access type of the Process. It is related to the WFACCESSTYPE table. |
wfclassDeleted |
bit, not null |
Indicates if the Process has been deleted. This is a logical deletion attribute: if it is 1, the Process has been deleted; otherwise, it is 0. |
idCategory |
int, null |
The identifier of the Category of the Process. It is related to the CATEGORY table. |
catDisplayName |
nvarchar(40), null |
The display name of the Process Category. |
idApplication |
int, null |
The identifier of the Process Application. It is related to the APPLICATION table. |
appName |
nvarchar(26), null |
The name of the Process Application. |
appDisplayName |
nvarchar(40), null |
The display name of the Process Application. |
appDeleted |
bit, null |
Indicates if the Process Application has been deleted. This is a logical deletion attribute: if it is 1, the Process Application has been deleted; otherwise, it is 0. |
idAppEntity |
int, null |
The identifier of the Application's Entity configured for the Process. It is related to the ENTITY table. |
appEntName |
varchar(50), null |
The name of the Application's Entity configured for the Process. |
appEntDeleted |
bit, null |
Indicates if the Application's Entity configured for the Process has been deleted. This is a logical deletion attribute: if it is 1, the Application's Entity has been deleted; otherwise, it is 0. |
enableAlarms |
bit, null |
Indicates whether alarms/alerts have been enabled for the Workflow. |
enableNotifications |
bit, null |
Indicates whether notifications have been enabled for the Workflow. |
wfconfigDeleted |
bit, null |
Indicates if the Wrokflow configuration has been deleted. This is a logical deletion attribute: if it is 1, the Workflow configuration has been deleted; otherwise, it is 0. It is related to the WFCONFIG table. |
idWorkflow |
int, null |
The identifier of the Process Workflow. It is related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow. |
wfActive |
bit, null |
Indicates if the Workflow version is active or inactive. If active, it is set to 1. |
wfCreationDate |
datetime,null |
The exact date and time when the Workflow was created. |
wfEstimatedDuration |
int, null |
Duration configured for the Process, in minutes. |
caTypeName |
nvarchar(25), null |
Assigns the security level to each Case: either inherits the same level as the parent or allows Cases to be viewed by everyone, or only by those assigned. By default, it is set to None. It is related to the BACASEACCESSTYPE table |
workflowDeleted |
bit, null |
Indicates if the Workflow has been deleted. This is a logical deletion attribute: if it is 1, the Workflow has been deleted; otherwise, it is 0. |
idProcEntity |
int, null |
The identifier of the Process Entity. It is related to the ENTITY table. |
procEntName |
varchar(50), null |
The name of the Process Entity. |
procEntDeleted |
bit, null |
Indicates if the Process Entity has been deleted. This is a logical deletion attribute: if it is 1, the Process Entity has been deleted; otherwise, it is 0. |
idPVAttrib |
int, null |
The identifier of the Attribute in the Application Entity related to the Process. It is related to the ATTRIB table. |
pvAttribName |
varchar(26), null |
The name of the Attribute in the Application Entity related to the Process. |
attribDeleted |
bit, null |
Indicates if the Attribute in the Application Entity related to the Process has been deleted. This is a logical deletion attribute: if it is 1, the Attribute has been deleted; otherwise, it is 0. |
wfclassentityDeleted |
bit, null |
Indicates if the Entity related with the Process was deleted. This is a logical deletion attribute: if it is 1, the Entity has been deleted; otherwise, it is 0. It is related to the BAWFCLASS_ENTITY table. |
TASK (vwBA_ODS_WF_TASK)
For each Process, lists the Tasks associated with that Process, specifying whether a Task is a Sub-Process, if it is multi-instance, and indicating its functional area.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, not null |
The identifier of the Process. It is related to the WFCLASS table. |
wfClsName |
nvarchar(26), not null |
The name of the Process. |
wfClsDisplayName |
nvarchar(40), null |
The display name of the Process. |
idWorkflow |
int, null |
The identifier of the Process Workflow related to the Task. It is related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow related to the Task. |
wfActive |
bit, null |
Indicates whether the Workflow to which the Task belongs is active. |
idTask |
int, not null |
The identifier of the Task. It is related to the TASK table. |
tskName |
nvarchar(26), not null |
The name of the Task. |
tskDisplayName |
nvarchar(40), null |
The display name of the Task. |
taskDeleted |
bit, not null |
Indicates if the Task has been deleted. This is a logical deletion attribute: if it is 1, the Task has been deleted; otherwise, it is 0. |
tskDuration |
int, null |
Duration configured for the Task, in minutes. |
tskTimerEventDuration |
int, null |
Duration configured for the timer event associated with the Task, in minutes. |
tskSingleton |
bit, not null |
Indicates whether the Task is a singleton. |
tskIsAsynchTask |
bit, null |
Indicates whether the Task is asynchronous. If it is set to 1, it is asynchronous. |
tskAsynchTimeout |
int, null |
Timeout configured for the Asynchronous task. |
tskNumberOfRetries |
int, null |
Number of retries configured for the Asynchronous task. |
idTaskType |
int, null |
The identifier of the Task type. Related to the TASKTYPE table. |
tskTpName |
nvarchar(26), null |
The name of the Task type. |
idFunctionalArea |
int, null |
The identifier of the Functional Area where the Task is located in the Workflow. It is related to the FUNCTIONALAREA table. |
faDisplayName |
nvarchar(40), null |
The display name of the Functional Area. |
idPhase |
int, not null |
The identifier of the Phase where the Task is located in the Workflow. It is related to the PHASE table. |
phaseDisplayName |
nvarchar(26), not null |
The display name of the Phase related to the Task. |
phaseTypeName |
nvarchar(40), null |
The display name of the Phase type related to the Task. It is related to the PHASETYPE table. |
idSubProcType |
int, null |
The identifier of the Sub-Process Type. It is related to the SUBPROCTYPE table. |
sptName |
nvarchar(26), null |
The name of the Sub-Process Type. |
idSubProcMappingTypeI |
int, null |
The identifier of the Sub-Process Mapping Type when the Task is a Sub-Process. It is related to the SUBPROCMAPPINGTYPE table. |
sbProcMappingTypeIn |
nvarchar(26), null |
The name of the Sub-Process Mapping Type when the Task is a Sub-Process. |
idSubProcMappingTypeO |
int, null |
The identifier of the Sub-Process Mapping Type Out when the Task is a Sub-Process. It is related to the SUBPROCMAPPINGTYPE table. |
sbProcMappingTypeOut |
nvarchar(26), null |
The name of the Sub-Process Mapping Type Out when the Task is a Sub-Process. |
idSubWorkflow |
int, null |
The identifier of the Workflow Sub-Process configured when the Task is a Sub-Process. It is related to the WORKFLOW table. |
tskMultiple |
bit, not null |
Indicates whether the Sub-Process is multi-instance when the Task is a Sub-Process. If it is set to 1, it is multi-instance. |
idMultiInstanceExitMode |
int,null |
The identifier of the Exit Mode Type when the Task is a multi-instance Sub - Process. It is related to the MULTIINSTANCEEXITMODE table. |
miEmName |
nvarchar(26), null |
The name of the Exit Mode Type when the Task is a multi-instance Sub-Process. |
idMultiInstanceGroupByAttrib |
int, null |
The identifier of the Attribute used when a multi-instance Sub-Process has been grouped. It is related to the ATTRIB table. |
TRANSITION (vwBA_ODS_WF_TRANSITION)
For each Process, lists the Transitions between various Tasks, indicating the source and destination Tasks, along with the type of relationship between them.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, not null |
The identifier of the Process. It is related to the WFCLASS table. |
wfClsName |
nvarchar(26), not null |
The name of the Process. |
wfClsDisplayName |
nvarchar(40), null |
The display name of the Process. |
idWorkflow |
int, null |
The identifier of the Process Workflow to which the Transition belongs. It is related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow. |
wfActive |
bit, null |
Indicates if the Workflow to which the Transition belongs is active. If set to 1, it is active. |
idTransition |
int, not null |
The identifier of the Transition. It is related to the TRANSITION table. |
trName |
nvarchar(26), not null |
The name of the Transition. |
trDisplayName |
nvarchar(40), null |
The display name of the Transition. |
tranDeleted |
bit, not null |
Indicates if the Transition has been deleted. This is a logical deletion attribute: if it is 1, the Transition has been deleted; otherwise, it is 0. |
idTaskFrom |
int, null |
The identifier of the Task connected at the beginning of the Transition. It is related to the TASK table. |
tskFromName |
nvarchar(26), not null |
The name of the Task connected at the beginning of the Transition. |
tskFromDisplayName |
nvarchar(40), null |
The display name of the Task connected at the beginning of the Transition. |
idTaskTo |
int, null |
The identifier of the Task connected at the end of the Transition. It is related to the TASK table. |
tskToName |
nvarchar(26), not null |
The name of the Task connected at the end of the Transition. |
tskToDisplayName |
nvarchar(40), null |
The display name of the Task connected at the end of the Transition. |
idTransitionType |
tinyint, nit null |
The identifier of the Transition type. It is related to the TRANSITIONTYPE table. |
transitionTypeName |
nvarchar(26), not null |
The name of the Transition type. |
The View that contains information about the users in your Bizagi project is vwBA_ODS_USER. This View extracts comprehensive user information, encompassing details such as location, organization, working time schema, and availability for assignment.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idUser |
int, not null |
The unique identifier of the User. It is related to the WFUSER table. |
domain |
nvarchar(25), not null |
The domain to which the User belongs. |
userName |
varchar(100), null |
The name of the User. |
fullName |
nvarchar(200), not null |
The full name of the User. |
enabled |
bit, not null |
Indicates if the User is enabled as a user in the Work Portal. If enabled, it is set to 1. |
enabledForAssignation |
tinyint, null |
Indicates if the User is enabled for Case allocation. |
contactEmail |
nvarchar(100), not null |
The email of the User. |
idBossUser |
int, null |
The unique identifier of the Boss user. It is related to the WFUSER table. |
DelegateEnabled |
tinyint, null |
Indicates if the User has a Delegated user. |
idDelegate |
int, null |
The unique identifier of the Delegated user. It is related to the WFUSER table. |
language |
int, null |
The identifier of the language configured for the User. It is related to the LGLANGUAGE table. |
lgName |
nvarchar(50), null |
The name of the language configured for the User. |
cultureDisplayName |
nvarchar(100), null |
The display name of the culture related to User's language. It is related to the LGLANGUAGE table. |
cultureName |
nvarchar(10), null |
The name of the culture related to the User's language. |
country |
nvarchar(50), null |
The name of the country configured for the User. It is related to the LGLANGUAGE table. |
stateLanguage |
bit, null |
Indicates if the language of the User is active. If active, it is set to 1. |
idArea |
int, null |
The identifier of the Area configured for the User. It is related to the AREA table. |
areaName |
nvarchar(26), null |
The name of the Area configured for the User. |
areaDisplayName |
nvarchar(40), null |
The display name of the Area configured for the User. |
idTimeZone |
int, null |
The identifier of the Timezone configured for the User. It is related to the BATIMEZONE table. |
tzName |
nvarchar(50), null |
The name of the Timezone configured for the User. |
tzDisplayName |
nvarchar(100), null |
The display name of the Timezone configured for the User. |
idWorkingTimeSchema |
int, null |
The identifier of the Working Time Schema configured for the User. It is related to the WORKINGTIMESCHEMA table. |
wtsName |
nvarchar(50), null |
The name of the Working Time Schema configured for the User. |
idLocation |
int, null |
The identifier of the Location configured for the User. It is related to the LOCATION table. |
locName |
nvarchar(26), null |
The name of the Location configured for the User. |
locDisplayName |
nvarchar(40), null |
The display name of the Location configured for the User. |
locIdTimeZone |
int, null |
The identifier of the Timezone related to the Location configured for the User. It is related to the BATIMEZONE table. |
locTzName |
nvarchar(50), null |
The name of the Timezone related to the Location configured for the User. |
locTzDisplay-Name |
nvarchar(100), null |
The display name of the Timezone related to the Location configured for the User. |
locIdWorkingTimeSchema |
int, null |
The identifier of the Working Time Schema related to the Location configured for the User. It is related to the WORKINGTIMESCHEMA table. |
locWtsName |
nvarchar(50), null |
The name of the Working Time Schema related to the Location configured for the User. |
idOrg |
int, null |
The identifier of the Organization configured for the User. It is related to the ORG table. |
orgName |
nvarchar(26), null |
The name of the Organization configured for the User. |
orgIdTimeZone |
int, null |
The identifier of the Timezone related to the Organization configured for the User. It is related to the BATIMEZONE table. |
orgTzName |
nvarchar(50), null |
The name of the Timezone related to the Organization configured for the User. |
orgTzDisplayName |
nvarchar(100), null |
The display name of the Timezone related to the Organization configured for the User. |
orgIdWorkingTimeSchema |
int, null |
The identifier of the Working Time Schema related to the Organization configured for the User. It is related to the WORKINGTIMESCHEMA table. |
orgWtsName |
nvarchar(50), null |
The name of the Working Time Schema related to the Organization configured for the User. |
The Personas View (vwBA_ODS_PERSONA) is the only view that is created dynamically. This View extracts the identifier of the Persona type entities, their name, and details of each entity (related tables, if the entity is enabled, user related to the Persona, etc.).
A View is created for each Persona that exists in the project. In other words, there will be as many Views in the project as there are Personas.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idEnt |
int, not null |
The identifier of the Entity related to the Persona. It is related to the ENTITY table. |
entName |
varchar(50), not null |
The name of the Entity related to the Persona. |
entDisplayName |
varchar(50), null |
The display name of the Entity related to the Persona. |
entSrc |
nvarchar(26), not null |
The name of the physical table linked to the Entity related to the Persona. |
SurrogateKey |
bigint, not null |
The record ID in the Entity corresponding to the Persona. |
disabled |
bit, null |
Indicates if the Persona is disabled. If set to 1, it is disabled. |
idUser |
int, null |
The identifier of the User who belongs to the Persona. It is related to the WFUSER table. |
The Views that encompass information about the cases in your Bizagi project include:
•CASE (vwBA_ODS_WFE_CASE)
•ALL CASES (vwBA_ODS_WFE_CASE_ALL)
•PV (vwBA_ODS_PV)
•WORKITEM (vwBA_ODS_WFE_WORKITEM)
CASE (vwBA_ODS_WFE_CASE)
Provides metadata for open and closed Cases organized by Process, featuring the Case status and whether it is a Sub-Process.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, not null |
The identifier of the Process to which the Case's Workflow belongs. It is related to the WFCLASS table. |
wfClsName |
nvarchar(26), not null |
The name of the Process. |
wfClsDisplayName |
nvarchar(40), null |
The display name of the Process. |
idWorkflow |
int, null |
The identifier of the Workflow to which the Case corresponds. It is related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow. |
wfActive |
bit, null |
Indicates if the Workflow to which the Case belongs is active. If set to 1, it is active. |
idCase |
int, not null |
The identifier of the Case instance. It is related to the WFCASE/WFCASECL table. |
radNumber |
nvarchar(20), null |
The customized number of the Case instance displayed to end users in the Work Portal. |
casCreationDate |
datetime, not null |
The exact date and time the Case was created. |
casSolutionDate |
datetime, null |
The exact date and time the Case was closed. |
casEstimatedSolutionDate |
datetime, null |
The date and time calculated by Bizagi as the Case's solution date. |
idCreatorUser |
int, null |
The identifier of the User who created the Case. It relates to the WFUSER table. |
idCaseState |
int, not null |
The identifier of the Case state. It is related to the CASESTATE table. |
CaseClosed |
tinyint, null |
Indicates if the Case is closed or not. If set to 1, it is closed. |
idParentCase |
int, null |
The identifier of the Parent Case when the Case is an instance of a Sub-Process. It is related to the WFCASE/WFCLCASE table. |
idParentTask |
int, null |
The identifier of the Parent Task in the Parent Workflow when the Case is an instance of a Sub-Process. It is related to the TASK table. |
idParentWorkItem |
bigint, null |
The identifier of the Parent Workitem when the case is an instance of a Sub-Process. It is related to the WORKITEM table. |
idSubProcType |
int, null |
The identifier of the Sub-Process Type. It is related to the SUBPROCTYPE table. |
ancestorPath |
varchar(50), null |
XPath that contains the IDs of the Process. When it is a Sub-Process, it contains the IDs of its Parent Process and potentially more Parent Processes as applicable. The IDs belong to the WFClass. When it is a Parent Process, it only has its own ID. |
caseDuration |
int, null |
Duration of the Case calculated as the difference between the Case creation date and Case solution date, considering the Working Time Schema, in minutes. |
idOrg |
int, null |
The identifier of the Organization configured for the Case Creator User. It is related to the ORG table. |
idCaseAccess |
int, null |
Through this attribute, it is possible to determine the user IDs that have access to the Case. Using this ID, you can search in the BACASEACCESS table and find multiple rows, one for each user. If it is a Parent Process, the idCaseAccess is the same as the case ID. If it is a Sub-Process, the idCaseAccess is the ID of the Parent Case. |
csName |
varchar(26), not null |
The name of the Case state. |
sptName |
varchar(26), null |
The name of the Sub-Process Type. |
ALL CASES (vwBA_ODS_WFE_CASE_ALL)
Exhibits metadata for both open and closed Cases (with a nolock).
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idCase |
int, not null |
The identifier of the Case instance. It is related to the WFCASE/WFCASECL table. |
wfClsName |
nvarchar(26), not null |
The name of the Process. |
casCreationDate |
datetime, not null |
The exact date and time the Case was created. |
casSolutionDate |
datetime, null |
The exact date and time the Case was closed. |
casEstimatedSolutionDate |
datetime, null |
The date and time calculated by Bizagi as the Case's solution date. |
idWorkflow |
int, null |
The identifier of the Workflow. It is related to the WORKFLOW table. |
idCreatorUser |
int, null |
The identifier of the User who created the Case. It relates to the WFUSER table. |
idCaseState |
int, not null |
The identifier of the Case state. It is related to the CASESTATE table. |
idParentCase |
int, null |
The identifier of the Parent Case when the Case is an instance of a Sub-Process. It is related to the WFCASE/WFCLCASE table. |
idParentTask |
int, null |
The identifier of the Parent Task in the Parent Workflow when the Case is an instance of a Sub-Process. It is related to the TASK table. |
idSubProcType |
int, null |
The identifier of the Sub-Process Type. It is related to the SUBPROCTYPE table. |
radNumber |
nvarchar(20), null |
The customized number of the Case instance displayed to end users in the Work Portal. |
idParentWorkItem |
bigint, null |
The identifier of the Parent Workitem when the Case is an instance of a Sub-Process. It is related to the WORKITEM table. |
casExtEstimatedSolutionDate |
datetime, null |
The date and time calculated by Bizagi as the Case extended solution date. |
ancestorPath |
varchar(50), null |
XPath that contains the IDs of the Process. When it is a Sub-Process, it contains the IDs of its Parent Process and potentially more Parent Processes as applicable. The IDs belong to the WFClass. When it is a Parent Process, it only has its own ID. |
CaseClosed |
tinyint, null |
Indicates if the Case is closed or not. If set to 1, it is closed. |
idOrg |
int, null |
The identifier of the Organization configured for the Case Creator User. It is related to the ORG table. |
duration |
int, null |
Duration of the Case calculated as the difference between the Case creation date and Case solution date, considering the Working Time Schema, in minutes. |
idCaseAccess |
int, null |
Through this attribute, it is possible to determine the user IDs that have access to the Case. Using this ID, you can search in the BACASEACCESS table and find multiple rows, one for each user. If it is a Parent Process, the idCaseAccess is the same as the case ID. If it is a Sub-Process, the idCaseAccess is the ID of the Parent Case. |
csName |
varchar(26), not null |
The name of the Case state. |
sptName |
varchar(26), null |
The name of the Sub-Process Type. |
CaseGUID |
unique identifier, null |
Unique identifier of the Case in GUID format. |
hasCaseNumber |
bit, null |
Indicator to determine if a custom number is used for the radnumber or not. |
guidPlan |
unique identifier, null |
The GUID identifier of the Plan created for the Case, if a Plan has been created. It is related to the WFPLAN table. |
guidAdhocProcess |
unique identifier, null |
The GUID identifier corresponding to the Live Processes of the Case. When a Case corresponds to a Live Process, the data of WFClass and Workflow are null. You can use the View vwBA_ODS_CATALOG to obtain more details about the Live Process. |
caseMasked |
int, not null |
Indicator of whether the Case was anonymized. If set to 1, it is anonymized. |
caseMaskedDate |
datetime, null |
Date when the Case was anonymized. |
PV (vwBA_ODS_PV)
Presents a list of Cases for each Application Entity, showcasing details such as the Entity, Case ID, and Case creation date.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
table |
varchar(7), not null |
The physical table name in the database that corresponds to the Application Entity of the Process. It is related to the ENTITY table (field EntSrc). |
idCase |
int, not null |
The identifier of the Case instance. It is related to the WFCASE/WFCASESL table. |
finalEnt |
int, not null |
The identifier of the Application Entity associated with the Workflow to which the case corresponds. It is related to the ENTITY table. |
createdOn |
datetime, not null |
The exact date and time the Case was created. |
WORKITEM (vwBA_ODS_WFE_WORKITEM)
Displays metadata for open and closed Tasks organized by Process.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, not null |
The identifier of the Case instance. It is related to the WFCASE/WFCASESL table. |
wfClsName |
nvarchar(26), not null |
The name of the Process. |
wfClsDisplayName |
nvarchar(40), null |
The display name of the Process. |
idWorkflow |
int, null |
The identifier of the Process Workflow. It is related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow. |
wfActive |
bit, null |
Indicates if the Workflow to which the Case belongs is active. If set to 1, it is active. |
idTask |
int, not null |
The identifier of the Task. It is related to the TASK table. |
tskName |
nvarchar(26), not null |
The name of the Task. |
tskDisplayName |
nvarchar(40), null |
The display name of the Task. |
tskIsAsynchTask |
bit, null |
Indicates if the Task is an Asynchronous Task. |
tskDuration |
int, null |
Duration configured for the Task, in minutes. |
idTaskType |
int, null |
The identifier of the Task Type. Related to the TASKTYPE table. |
tskTpName |
nvarchar(26), null |
The name of the Task Type. |
radNumber |
nvarchar(20), null |
The customized number of the Case instance displayed to end users in the Work Portal. |
casCreationDate |
datetime, not null |
The exact date and time the Case was created. |
casSolutionDate |
datetime, null |
The exact date and time the Case was closed. |
casEstimatedSolutionDate |
datetime, null |
The date and time calculated by Bizagi as the Case solution date. |
caseIdWorkflow |
int, null |
The identifier of the Process Workflow. When the Case is a Sub-Process, it shows the idWorkflow of the Parent Case. It is related to the WORKFLOW table. |
idCreatorUser |
int, null |
The identifier of the User who created the Case. It relates to the WFUSER table. |
idCaseState |
int, not null |
The identifier of the Case state. It is related to the CASESTATE table. |
CaseClosed |
tinyint, null |
Indicates if the Case is closed or not. If it is set to 1, the Case is closed. |
idParentCase |
int, null |
The identifier of the Parent Case when the Case is an instance of a Sub-Process. It is related to the WFCASE/WFCLCASE table. |
idParentTask |
int, null |
The identifier of the Parent Task in the Parent Workflow when the Case is an instance of a Sub-Process. It is related to the TASK table. |
caseIdParentWorkItem |
bigint, null |
The identifier of the Parent Workitem in the Parent Workflow when the Case is an instance of a Sub-Process. It is related to the WORKITEM table. |
caseIdSubProcType |
int, null |
The identifier of the Sub-Process Type. It is related to the SUBPROCTYPE table. |
ancestorPath |
varchar(50), null |
XPath that contains the IDs of the Process. When it is a Sub-Process, it contains the IDs of its Parent Process and potentially more Parent Processes as applicable. The IDs belong to the WFClass. When it is a Parent Process, it only has its own ID. |
caseDuration |
int, null |
Duration of the Case calculated as the difference between the Case creation date and Case solution date, considering the Working Time Schema, in minutes. |
idOrg |
int, null |
The identifier of the Organization configured for the Case Creator User. It is related to the ORG table. |
idCaseAccess |
int, null |
Through this attribute, it is possible to determine the user IDs that have access to the Case. Using this ID, you can search in the BACASEACCESS table and find multiple rows, one for each user. If it is a Parent Process, the idCaseAccess is the same as the case ID. If it is a Sub-Process, the idCaseAccess is the ID of the Parent Case. |
csName |
nvarchar(26), null |
The name of the Case state. It is related to the CASESTATE table. |
caseSubProcType |
nvarchar(26), null |
The name of the Sub-Process Type. |
idCase |
int, not null |
The identifier of each Case instance. |
idWorkItemState |
int, not null |
The identifier of the Workitem state. It is related to the WORKITEMSTATE table. |
wiClosed |
tinyint, null |
Indicates if the Workitem is closed. If it is set to 1, the Workitem is closed. |
idWorkitem |
bigint, null |
The identifier of the Workitem. It is related to the WORKITEM table. |
idParentWorkItem |
bigint, null |
The identifier of the Parent Workitem when the Case is an instance of a Sub-Process. It is related to the WORKITEM table. |
wiEntryDate |
datetime, not null |
The exact date and time the Workitem was created. |
wiDuration |
int, not null |
Duration of the Workitem calculated as the difference between the Workitem creation date and Workitem solution date, considering the Working Time Schema, in minutes. |
wiEstimatedSolutionDate |
datetime, null |
The date and time calculated by Bizagi as the Workitem's solution date. |
wiSolutionDate |
datetime, null |
The exact date and time the Workitem was closed. |
wiName |
nvarchar(26), not null |
The name of the Workitem state. It is related to the WORKITEMSTATE table. |
|
To learn about the possible values available for the fields mentioned as related to value tables, refer to the Value List Tables article. |
Integration
Connectors
Connectors vwBA_ODS_CONNECTORS
Retrieves general information on saved connectors, even those that have already been deleted.
The attributes considered in this view are:
Column |
Data type |
Description |
|---|---|---|
connectorName |
varchar |
Connector name, obtained from objContent or objContentResolved. |
connectorVersion |
varchar |
Connector version, obtained from objContent or objContentResolved. |
objName |
varchar(256) |
Name of the object in the catalog. |
objTypeName |
varchar(50) |
Object type in the catalog for this object is usually InterfaceConnector. |
modifiedDate |
datetime |
Date of the last modification of the object. |
modifiedByUser |
varchar(100) |
User who made the last modification. |
deleted |
varchar |
Indicator of whether the object is deleted (true or false). |
hasSystemConfiguration |
varchar |
Indicator of whether the connector has system configuration (true or false). |
Extended Connectors vwBA_ODS_CONNECTORS_EXTEND
Retrieves more detailed information about the active connectors and the components from which they are being used.
The attributes considered in this view are:
Column |
Data type |
Description |
|---|---|---|
connectorName |
varchar |
Connector name, obtained from objContent or objContentResolved. |
connectorVersion |
varchar |
Connector version, obtained from objContent or objContentResolved. |
modifiedDate |
datetime |
Date of the last modification of the object. |
modifiedByUser |
varchar(100) |
User who made the last modification. |
connectorSystemConfigurationName |
varchar |
Name of the connector system configuration, obtained from objContentResolved. |
connectorInstanceName |
varchar |
Connector instance name, obtained from objContentResolved. |
componentName |
varchar(256) |
Name of the component related to the connector, parent object where the connector is being used. |
componentElementType |
varchar(50) |
Type of element of the parent component where the connector is being used. |
connectorsSource |
varchar |
Path with the object types of the parent objects of the connector in hierarchical order. |
firstParentType |
varchar(50) |
Type of the first parent object of the component where the connector is located. |
firstParentName |
varchar(256) |
Name of the first parent object of the component where the connector is located. |
secondParentType |
varchar(50) |
Type of the second parent object of the component where the connector is located. |
secondParentName |
varchar(256) |
Name of the second parent object of the component where the connector is located. |
thirdParentType |
varchar(50) |
Type of the third parent object of the component where the connector is located. |
thirdParentName |
varchar(256) |
Name of the third parent object of the component where the connector is located. |
Interfaces
Interfaces vwBA_ODS_INTERFACE
Retrieves information about the active SOAP and REST interfaces and the components from which they are being used.
The attributes considered in this view are:
Column |
Data type |
Description |
|---|---|---|
interfaceName |
varchar |
Interface name, obtained from objContentResolved. |
interfaceType |
varchar |
Type of the interface, obtained from objContentResolved. |
baseUrl |
varchar |
URL base de la interfaz, obtenida de objContentResolved. |
modifiedDate |
datetime |
Date of the last modification of the object. |
modifiedByUser |
varchar(100) |
User who made the last modification. |
contentInterfaceEnvironment |
varbinary |
Content of the interface environment, obtained from objContentResolved. |
contentFirstParent |
varbinary |
Content of the first parent object, obtained from objContentResolved. |
firstParentType |
varchar(50) |
Type of the first parent object of the interface. |
firstParentName |
varchar(256) |
Name of the first parent object. |
contentSecondParent |
varbinary |
Content of the second parent object, obtained from objContentResolved. |
secondParentType |
varchar(50) |
Type of the second parent object. |
secondParentName |
varchar(256) |
Name of the second parent object. |
contentThirdParent |
varbinary |
Content of the third parent object, obtained from objContentResolved. |
thirdParentType |
varchar(50) |
Type of the third parent object. |
thirdParentName |
varchar(256) |
Name of the third parent object. |
Considerations
It's crucial to understand that Views are not intended for performing calculations; they do not function as tables storing pre-calculated data. Instead, Views merely provide a perspective on existing tables, primarily accommodating filters and aggregations, and utilizing basic SQL calculations (such as max, min, sum, avg, among others).
Additional characteristics of Views include:
•Views cannot utilize Stored Procedures, cursors, temporary tables, etc., which are essential tools for conducting calculations as described earlier.
•Views are considered "static" objects; they cannot be customized, nor can they be swiftly modified to address new requirements (for instance, adding a column). They are integral parts of the database build.
•Views are intended for use by technical personnel responsible for constructing reports, not by end users. The technical expert should formulate such queries using the tool connecting to the ODS. End users only interact with the resulting data, potentially manipulating it through additional filters or modifications to the order, depending on the tool they employ.
Last Updated 10/25/2024 4:21:29 PM