Overview
Utilitarian Views in Bizagi, similar to the main Views, are SQL queries specifically crafted to efficiently organize and present additional project-related information from database tables.
Prefixed with vwBA_ODS as well, they facilitate easy access to project data, encompassing configurations such as data models, catalog objects, Vocabulary and Interfaces settings, user authentication, jobs, logs, and more.
These Utilitarian Views provide insights into various database aspects, supporting efficient data retrieval and effectively aiding in project management tasks.
Data model
The Views containing information related to the data model of your Bizagi project are:
•vwBA_ODS_DM_ENTITY
•vwBA_ODS_DM_ATTRIB
vwBA_ODS_DM_ENTITY
Retrieves the list of entities utilized by the project, specifying the type of entity and where is it managed (Development, Production, or if it is a Replicated entity).
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idEnt |
int, not null |
The identifier of the Entity. It's related to the ENTITY table. |
entName |
varchar(50), not null |
The name of the Entity. |
entDisplayName |
varchar(50), null |
The display name of the Entity. |
entSrc |
nvarchar(26), not null |
The name of the physical table linked to the Entity. |
entType |
tinyint, not null |
The identifier of the Entity type. It's not related to any table and its possible values are: •Application = 0 •Master = 1 •Parameter = 2 •System = 3 •Stakeholder = 4 (Equivalent to Persona) •Adhoc = 5 •CaseInfo = 6 •FileUpload = 7 |
entTypeDesc |
varchar(9), not null |
The name of the Entity type. |
entSurrogateKey |
nvarchar(28), not null |
The name of the attribute/column which correspond to the surrogate key of the Entity. |
entAdministrable |
bit, not null |
Indicates if the Entity has been enabled as a web administrated Entity. |
entContentType |
tinyint, not null |
The identifier of the Entity content type. It's not related to any specific table and its possible values are: 1 for Data or 2 for Metadata. |
endContentTypeDesc |
varchar(19), not null |
The name of the Entity content type. Its possible values are: •Dev administration •Prod administration •Replicated |
entExtSrc |
nvarchar(128), null |
The name of the Physical table source when is a Replicated Entity. |
entDescription |
nvarchar(100), null |
The description of the Entity. |
entDeleted |
bit, not null |
Indicates if the Entity has been deleted. |
vwBA_ODS_DM_ATTRIB
Retrieves the list of attributes, providing details such as the attribute type, existing relationships between attributes, and a list of attributes associated with collections.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idEnt |
int, not null |
The identifier of the Entity. It's related to the ENTITY table. |
entName |
varchar(50), not null |
The name of the Entity. |
entDisplayName |
varchar(50), null |
The display name of the Entity. |
entSrc |
nvarchar(26), not null |
The name of the physical table linked to the Entity. |
entType |
tinyint, not null |
The identifier of the Entity type. It's not related to any table and its possible values are: •Application = 0 •Master = 1 •Parameter = 2 •System = 3 •Stakeholder = 4 (Equivalent to Persona) •Adhoc = 5 •CaseInfo = 6 •FileUpload = 7 |
entTypeDesc |
varchar(9), not null |
The name of the Entity type. |
idAttrib |
int, null |
The identifier of the Attribute. It's related to the ATTRIB table. |
AttribName |
nvarchar(26), not null |
The name of the Attribute. |
AttribDisplayName |
nvarchar(40), not null |
The display name of the Attribute. |
attribDescription |
nvarchar(118), null |
The description of the Attribute. |
columnScr |
nvarchar(26), null |
The name of the physical column in the table linked to the Attribute. |
attribType |
int, null |
The identifier of the Attribute type. It's not related to any specific table. The possible values 1, 2, 4, 5, 7, 8, 10, 12, 13, 15 and 23. |
attribTypeDesc |
nvarchar(18), not null |
The name of the Attribute type. Its possible values are: •Bigint •Bigint Foreing key •Int •Int Foreign key •Upload •Picture •Boolean •Numeric •Currency •Float •Date time •Small Date time •String |
AttribSize |
int, null |
The size of the Attribute, when the attribute type is String. |
attribExtSrc |
nvarchar(128), null |
The name of the physical column in the physical table source. When this attribute is a Replicated type, it's related to a replicated Entity. |
factType |
nvarchar(26), null |
The name of the fact type of the Attribute, when the attribute type is "Collection". It's related to the FACTRELATIONTYPE table. |
idRelatedEnt |
int, null |
The identifier of the Entity with which the attribute is related, when the attribute type is "ForeingKey" or "Collection". It´s related to the ENTITY table. |
relatedEntityName |
nvarchar(50), null |
The name of the Entity with which the attribute is related, when the attribute type is "ForeingKey" or "Collection". |
attribDeleted |
bit, not null |
Indicates if the Attribute has been deleted. This is a Logical deletion attribute: if it is 1, it has been deleted; otherwise, it is 0. |
Catalog
The Catalog View (vwBA_ODS_CATALOG) displays information about all Catalog objects that are active and allows you to view their contents.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
guidObject |
uniqueidentifier, null |
The unique object identifier. This attribute is in the GUID format, which consists of 32 hexadecimal characters divided into five groups separated by hyphens. The format is as follows: 8 hexadecimal characters, followed by three groups of 4 hexadecimal characters each, and a final group of 12 hexadecimal characters. |
guidObjectParent |
uniqueidentifier, null |
The unique identifier of the object's parent in case they have a parent. For example, an object of type attribute has an entity as parent. If it has no parent, it is the same guidObject.
This attribute is in the GUID format, which consists of 32 hexadecimal characters divided into five groups separated by hyphens. The format is as follows: 8 hexadecimal characters, followed by three groups of 4 hexadecimal characters each, and a final group of 12 hexadecimal characters. |
rootObject |
uniqueidentifier, null |
The identifier of the project to which the object belongs.
This attribute is in the GUID format, which consists of 32 hexadecimal characters divided into five groups separated by hyphens. The format is as follows: 8 hexadecimal characters, followed by three groups of 4 hexadecimal characters each, and a final group of 12 hexadecimal characters. |
objType |
int, not null |
The identifier of the object type of Bizagi's metada. For example: The Id corresponding to an Entity, Attribute, Application, Process, among others.
This column shows all the type of used objects in the project. |
objTypeName |
varchar(50), null |
The object type name. For example: Entity, Attribute, Application, Process, among others. This attribute is related to the objType attribute. |
objName |
varchar(256), not null |
The Object name. |
deleted |
bit, not null |
Indicates if the object has been deleted. This is a Logical deletion attribute If its value is 1, it means it has been deleted or 0 if it is otherwise. |
modifiedDate |
datetime, null |
Date of last modification of the object. |
modifiedByUser |
varchar(100), null |
The Identifier of the user that made the last modification of the object. It's related to the WFUSER table. |
contentFormat |
tinyint, null |
Indicator of whether it is a compressed object due to its size, for space optimization. This attribute is of the catalog's own logic. If it has value 1, it is compressed, otherwise it is 0. |
IsOverride |
varchar(1), not null |
Indicator of an object that was modified in the Production or Test environment throughout the MC. If its value is 1, it was created or modified in Production or Test. If its 0, it comes from a Development deployment. |
IsSystem |
varchar(1), not null |
Indicates if it's a Bizagi system object. |
content |
nvarchar(max), null |
Json that contains the information of the object. |
Configuration
The Views that display data from the Bizagi Vocabulary and Interfaces configuration are:
•vwBA_ODS_VOCABULARY
•vwBA_ODS_INTERFACE
vwBA_ODS_VOCABULARY
Extracts from the Catalog the Vocabulary type objects defined for the project.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
objName |
varchar(256), not null |
The Object name. |
Definition |
nvarchar(max), null |
Json that contains the information of the object. |
Level |
varchar(50), null |
Name of the type of parent object, for this case only the Application and Process values apply. |
ParentDefinition |
nvarchar(max), null |
Json that contains the information of the parent object, for this case only the values of Application and Process apply. When the parent object is of type Process, this Json corresponds to the Workflow definition. |
WFClassDefinition |
nvarchar(max), null |
Json that contains the information of the process to which the vocabulary belongs. It only applies when the parent object is of type Process and corresponds to the process and not to the workflow. |
guidObject |
uniqueidentifier, null |
The unique object identifier. |
vwBA_ODS_INTERFACE
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
objName |
varchar(256), not null |
The Object or Interface name. |
Interface |
nvarchar(max), null |
Json containing the interface configuration. |
EnvironmentDefinition |
nvarchar(max), null |
Json containing the interface configuration for every environment it has been deployed. It can be Development, Test or Production. |
ParentTypeName0 |
varchar(50), null |
Name of the type of parent object. For this case only FlowElement and FormClass values apply. |
ParentName0 |
varchar(256), null |
Name of the Name of the FlowElement and FormClass where the interface is invoked. |
ParentDefinition0 |
nvarchar(max), null |
Json containing the definition of the FlowElement and FormClass where the interface is invoked. |
ParentTypeName1 |
varchar(50), null |
Name of the type of the parent object. For this case only the values of Process and FormClass apply. |
ParentDefinition1 |
nvarchar(max), null |
Json with the definition of the Process (Workflow) or the FormClass containing the interface. |
ParentTypeName2 |
varchar(50), null |
Name of the type of object that is Parent of the Parent object, for this case only the values of ProcessClass and Entity apply. |
ParentName2 |
varchar(256), null |
Name of the ProcessClass or of the parent Entity of the parent entity to which the form containing the interface belongs. |
ParentDefinition2 |
nvarchar(max), null |
Json that contains the ProcessClass definition or of the parent Entity of the parent entity to which the form containing the interface belongs. |
Users
The View containing information about the users in your Bizagi project is vwBA_ODS_USER_AUTH. This View extracts user authentication details, including information such as the authentication token, user IP, and whether the authentication was successful or not.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idAuthLog |
bigint, not null |
The auto-generated identifier for each authentication event. |
alEntryDate |
datetime, null |
The exact date and time of the authentication event. |
ipAddress |
nvarchar(30), null |
The IP Address from which the authentication event originates. |
idUser |
int, null |
The identifier of the user who executes the authentication event. It's related to the WFUSER table. |
domain |
nvarchar(50), null |
The domain of the user who executes the authentication event. It's related to the WFUSER table. |
userName |
varchar(100), null |
The user name of the user who executes the authentication event. |
idAuthEventType |
int, not null |
The identifier of the authentication event type. It's related to the AUTHEVENTTYPE table. |
AuthEventTypeName |
nvarchar(25), null |
The name of the authentication event type. |
idAuthEventSubType |
int, null |
The identifier of the authentication event subtype. It's related to the AUTHEVENTSUBTYPE table. |
AuthEventSubTypeName |
nvarchar(50), null |
The identifier of the authentication event subtype. |
Cases
The Views containing information about the cases in your Bizagi project are:
•vwBA_ODS_WFE_ASYNCH
•vwBA_ODS_WFE_JOB
vwBA_ODS_WFE_ASYNCH
Displays details of asynchronous tasks retries, indicating whether they have failed or undergone retries.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, null |
The identifier of the Process. It's related to the WFCLASS table. |
wfClsName |
nvarchar(26), 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 Asynchronous task. It's related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow related to the Asynchronous task. |
wfActive |
bit, null |
Indicates if the Workflow to which the Asynchronous task belongs is active. If its value is 1, it means is Active, otherwise 0. |
idCase |
int, not null |
The identifier of the case instance. It's related to the WFCASE table. |
radNumber |
nvarchar(20), null |
The customized number of the case instance displayed in the Work Portal to end users. |
CaseClosed |
tinyint, null |
Indicates is the case is closed or not. If its value is 1, it means is Closed, otherwise 0. |
idWorkitem |
bigint, not null |
The identifier of the Workitem related to the failed Task. It's related to the WORKITEM table. |
wiClosed |
tinyint, null |
Indicates if the Workitem related to the Asynchronous task is closed. If its value is 1, it means is Closed, otherwise 0. |
idWorkItemState |
int, not null |
The identifier of the Workitem state related to the Asynchronous task. It's related to the WORKITEMSTATE table. |
wiName |
nvarchar(26), not null |
The name of the Workitem state related to the Asynchronous task. It's related to the WORKITEMSTATE table. |
idTask |
int, null |
The identifier of the Task. It's related to the TASK table. |
tskName |
nvarchar(26), 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. If it has value 1, it means it's an Asynchronous task, otherwise is 0. |
idTaskType |
int, null |
The identifier of the Task Type. Related to the TASKTYPE table. |
tskTpName |
nvarchar(26), null |
The name of the Task Type. |
wiEntryDate |
datetime, not null |
The exact date and time the Workitem related to the task was created. |
wiEstimatedSolutionDate |
datetime, null |
Date and time calculated by Bizagi for the end of the Workitem. |
wiSolutionDate |
datetime, null |
The exact date and time the Workitem related to the task was solved. |
idAsynchWorkitem |
bigint, not null |
The identifier of the Asynchronous Workitem corresponding to the failed task that was retried. It's related to the WORKITEM table. |
awEnabled |
bit, not null |
Identifies whether the Asynchronous Workitem is active. If its value is 1 it is active, otherwise it is 0. |
awState |
smallint, not null |
The Identifier of the state of the Asynchronous Workitem. Its possible values are: •Proccessed = 0 •ImmediateProcessing = 1 •BatchProcessing = 2 •QueuedForInmediateProcessing = 3 •Created = 4 |
awProcessing |
bit, not null |
Identifies whether the Asynchronous Workitem is running. If it is 1, it is in process, otherwise it is 0. |
awCreationDate |
datetime, not null |
The exact date and time the Asynchronous Workitem was created. |
awEnqueuedDate |
datetime, null |
The exact date and time the Asynchronous Workitem changes to the QueuedForInmediateProcessing = 3 state to be processed. |
awProcessingDate |
datetime, null |
The exact date and time the Asynchronous Workitem has been already processed. |
awNextProcessDate |
datetime, null |
The exact date and time the Asynchronous Workitem will be processed again. |
awrRetryDate |
datetime, not null |
The exact date and time the Asynchronous Workitem was executed in the retry. |
Now |
datetime, not null |
The current date and time (System date). |
awrMessage |
nvarchar(4000), not null |
Error message in case of retry failure. In case of success, it is indicates that it was processed successfully. |
vwBA_ODS_WFE_JOB
Retrieves information of jobs/timers, grouping them by process, case, and task.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, null |
The identifier of the Process. It's related to the WFCLASS table. |
wfClsName |
nvarchar(26), 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 Job. It's related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow related to the Job. |
wfActive |
bit, null |
Indicates if the Workflow to which the Job belongs is active. If its value is 1, it means is Active, otherwise 0. |
idCase |
int, not null |
The identifier of the case instance. It's related to the WFCASE/WFCASECL table. |
radNumber |
nvarchar(20), null |
The customized number of the case instance displayed in the Work Portal to end users. |
CaseClosed |
tinyint, null |
Indicates is the case is closed or not. If it has value 1, it means it's closed, otherwise is 0. |
idWorkitem |
bigint, not null |
The identifier of the Workitem. It's related to the WORKITEM table. |
wiClosed |
tinyint, null |
Indicates if the Workitem is closed. If it has value 1, it means it's closed, otherwise is 0. |
idWorkItemState |
int, not null |
The identifier of the Workitem state. It's related to the WORKITEMSTATE table. |
wiName |
nvarchar(26), not null |
The name of the Workitem state. |
idTask |
int, null |
The identifier of the Task. It's related to the TASK table. |
tskName |
nvarchar(26), 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. If it has value 1, it means it's an Asynchronous task, otherwise is 0. |
idTaskType |
int, null |
The identifier of the Task Type. Related to the TASKTYPE table. |
tskTpName |
nvarchar(26), null |
The name of the Task Type. |
wiEntryDate |
datetime, not null |
The exact date and time the Workitem related to the task was created. |
wiEstimatedSolutionDate |
datetime, null |
Date and time calculated by Bizagi for the completion of the Workitem. |
wiSolutionDate |
datetime, null |
The exact date and time the Workitem related to the task was completed. |
idJob |
int, not null |
The identifier of the Job. Related to the JOB table. |
jobName |
nvarchar(50), not null |
The name of the Job. |
jobDeleted |
bit, null |
Indicates if the Job has been deleted. This is a Logical deletion attribute: if it is 1, it has been deleted; otherwise, it is 0. |
jobEnabled |
int, not null |
Identifies if the Job is active. If the value is 1, it means is active, otherwise it is 0. |
jobType |
tinyint, not null |
The identifier of the Job Type. Related to the JOBTYPE table. |
jobTypeName |
nvarchar(26), not null |
The name of the Job Type. |
jobTypeEnabled |
bit, not null |
Identifies if the Job type is active. If the value is 1, it means is active, otherwise it is 0. |
jobCreationDate |
datetime, not null |
The exact date and time the Job was created. |
jobLastProcessingTime |
datetime, null |
The exact date and time the Job was executed last time. |
jobNextRunTime |
datetime, null |
The exact date and time the Job of the next execution. |
Now |
datetime, not null |
The current date and time (System date). |
jobIdCreatorUser |
nit, null |
The identifier of the user who created the Job. It´s related to the WFUSER table. |
Logs
The Logs Views correspond to the historical records in your Bizagi project and include:
•vwBA_ODS_WFE_CASELOG
•vwBA_ODS_WFE_WORKITEMLOG
•vwBA_ODS_WFE_ASSIGNATIONLOG
•vwBA_ODS_WFE_REASSIGNLOG
•vwBA_ODS_WFE_ATTRIBENTITYLOG
vwBA_ODS_WFE_CASELOG
Retrieves information about case status history.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, null |
The identifier of the Process. It's related to the WFCLASS table. |
wfClsName |
nvarchar(26), 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's related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow. |
wfActive |
bit, null |
Indicates if the Workflow is active. If its value is 1, it means is Active, otherwise 0. |
idCase |
int, not null |
The identifier of the case instance. It's related to the WFCASE/WFCASECL table. |
radNumber |
nvarchar(20), null |
The customized number of the case instance displayed in the Work Portal to end users. |
CaseClosed |
tinyint, null |
Indicates is the case is closed or not. If it has value 1, it means it's closed, otherwise is 0. |
idCaseStateLog |
bigint, not null |
Consecutive that identifies the change of status of the case in the CASESTATELOG table. |
cslEntryDate |
datetime, not null |
Date and exact time of case status change. |
idUser |
int, not null |
Identifier of the user who executed the task that caused the status change, in case of automatic tasks this user corresponds to the administrator. |
idCaseState |
int, not null |
The Case status identifier. It's related to the CASESTATE table. |
csName |
nvarchar(26), not null |
The name of the case status. |
vwBA_ODS_WFE_WORKITEMLOG
Retrieves information about history of task statuses and the users who processed them.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, null |
The identifier of the Process. It's related to the WFCLASS table. |
wfClsName |
nvarchar(26), 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's related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow. |
wfActive |
bit, null |
Indicates if the Workflow is active. If its value is 1, it means is Active, otherwise 0. |
idCase |
int, not null |
The identifier of the case instance. It's related to the WFCASE/WFCASECL table. |
radNumber |
nvarchar(20), null |
The customized number of the case instance displayed in the Work Portal to end users. |
CaseClosed |
tinyint, null |
Indicates is the case is closed or not. If it has value 1, it means it's closed, otherwise is 0. |
idWorkitem |
bigint, null |
The identifier of the Workitem. It's related to the WORKITEM table. |
idWorkItemState |
int, not null |
The identifier of the Workitem state. It's related to the WORKITEMSTATE table. |
wiName |
nvarchar(26), not null |
The name of the Workitem state. It's related to the WORKITEMSTATE table. |
idTask |
int, not null |
The identifier of the Task. It's 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. If it has value 1, it means it's an Asynchronous task, otherwise is 0. |
idTaskType |
int, null |
The identifier of the Task Type. Related to the TASKTYPE table. |
tskTpName |
nvarchar(26), null |
The name of the Task Type. |
idWIStateLog |
bigint, not null |
Consecutive that identifies the change of state of the Workitem in the WISTATELOG table. |
wislEntryDate |
datetime, not null |
Date and exact time of case status change for the Workitem. |
idUser |
int, not null |
Identifier of the user who executed the task corresponding to the Workitem. In the case of an automatic tasks, this user corresponds to the administrator. |
idWIState |
int, not null |
The Identifier of the Workitem status. It's related to the WORKITEMSTATE table. |
WIStateName |
nvarchar(26), not null |
Name of the state of the Workitem. |
vwBA_ODS_WFE_ASSIGNATIONLOG
Retrieves information about history of the assignment of tasks to users.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, null |
The identifier of the Process. It's related to the WFCLASS table. |
wfClsName |
nvarchar(26), 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's related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow. |
wfActive |
bit, null |
Indicates if the Workflow is active. If its value is 1, it means is Active, otherwise 0. |
idCase |
int, not null |
The identifier of the case instance. It's related to the WFCASE/WFCASECL table. |
radNumber |
nvarchar(20), null |
The customized number of the case instance displayed in the Work Portal to end users. |
CaseClosed |
tinyint, null |
Indicates is the case is closed or not. If it has value 1, it means it's closed, otherwise is 0. |
idWorkitem |
bigint, null |
The identifier of the Workitem. It's related to the WORKITEM table. |
wiClosed |
tinyint, null |
Indicates if the Workitem is closed. If it has value 1, it means it has been closed. Otherwise is 0. |
idWorkItemState |
int, not null |
The identifier of the Workitem state. It's related to the WORKITEMSTATE table. |
wiName |
nvarchar(26), not null |
The name of the Workitem state. It's related to the WORKITEMSTATE table. |
idTask |
int, not null |
The identifier of the Task. 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. If it has value 1, it means it is an Asynchronous task. Otherwise is 0. |
idTaskType |
int, null |
The identifier of the Task Type. Related to the TASKTYPE table. |
tskTpName |
nvarchar(26), null |
The name of the Task Type. |
idUser |
int, not null |
The Identifier of the user to whom the task was assigned to. It's related to the WFUSER Table. |
domain |
nvarchar(25), null |
The Domain to which the user to whom the task was assigned belongs. |
userName |
varchar(100), null |
Name of the user to whom the task was assigned. |
fullName |
varchar(200), null |
Full name of the user to whom the task was assigned. |
idAssignLog |
bigint, not null |
Consecutive that identifies the change of assignment of the Workitem in the ASSIGNATIONLOG table. |
aIEntryDate |
datetime, not null |
Date and exact time of the assignation. |
idAssignationLogType |
tinyint, null |
The Assignment type Identifier. It's related to the BAASSIGNATIONLOGTYPE table. |
assigLogType |
nvarchar(26), null |
Name of the assignation type. |
vwBA_ODS_WFE_REASSIGNLOG
Retrieves information about history of task's reassignment, preserving information about the previous user and the user to whom the task was reassigned.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, null |
The identifier of the Process. It's related to the WFCLASS table. |
wfClsName |
nvarchar(26), 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's related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow. |
wfActive |
bit, null |
Indicates if the Workflow is active. If its value is 1, it means is Active, otherwise 0. |
idCase |
int, not null |
The identifier of the case instance. It's related to the WFCASE/WFCASECL table. |
radNumber |
nvarchar(20), null |
The customized number of the case instance displayed in the Work Portal to end users. |
CaseClosed |
tinyint, null |
Indicates if the case is closed or not. |
idWorkitem |
bigint, null |
The identifier of the Workitem. It's related to the WORKITEM table. |
wiClosed |
tinyint, null |
Indicates if the Workitem is closed. If it has value 1, it means it has been closed. Otherwise is 0. |
idWorkItemState |
int, not null |
The identifier of the Workitem state. It's related to the WORKITEMSTATE table. |
wiName |
nvarchar(26), not null |
The name of the Workitem state. |
idTask |
int, not null |
The identifier of the Task. 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. If it has value 1, it means it is an Asynchronous task. Otherwise is 0. |
idTaskType |
int, null |
The identifier of the Task Type. Related to the TASKTYPE table. |
tskTpName |
nvarchar(26), null |
The name of the Task Type. |
wisEntryDate |
datetime, not null |
Date and exact time of task creation. |
wiEstimatedSolutionDate |
datetime, null |
The date and time calculated by Bizagi as the case solution date. |
idReassignLog |
bigint, not null |
Consecutive that identifies the Workitem reassignment in the REASSIGNATIONLOG table. |
rlOldAssignDate |
datetime, not null |
Date and exact time when the reassignment was made. |
idOldUser |
int, not null |
Identifier of the user previously assigned to the task. It's related to the WFUSER Table. |
oldUsername |
varchar(100), null |
Name of the user previously assigned to the task. |
oldFullName |
varchar(200), null |
Full name of the user previously assigned to the task. |
idNewUser |
int, not null |
Identifier of the user assigned to the task. It's related to the WFUSER table. |
newUsername |
varchar(100), null |
Name of the new user to whom the task was assigned. |
newFullName |
varchar(200), null |
Full name of the new user to whom the task was assigned. |
idAdmonUser |
int, not null |
Identifier of the user who carried out the task reassignment. It's related to the WFUSER table. |
admUsername |
varchar(100), null |
Name of the user who performed the task reassignment. |
admFullname |
varchar(200), null |
Full name of the user who performed the task reassignment. |
vwBA_ODS_WFE_ATTRIBENTITYLOG
Retrieves information about history of modifications made to the case data.
The attributes considered in this View are:
Column |
Data type |
Description |
|---|---|---|
idWfClass |
int, null |
The identifier of the Process. It's related to the WFCLASS table. |
wfClsName |
nvarchar(26), 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's related to the WORKFLOW table. |
wfVersion |
nvarchar(10), null |
The version of the Process Workflow. |
wfActive |
bit, null |
Indicates if the Workflow is active. If its value is 1, it means is Active, otherwise 0. |
idCase |
int, not null |
The identifier of the case instance. It's related to the WFCASE/WFCASECL table. |
radNumber |
nvarchar(20), null |
The customized number of the case instance displayed in the Work Portal to end users. |
CaseClosed |
tinyint, null |
Indicates if the Case is closed or not. If set to 1, it is closed. Otherwise is 0. |
idWorkitem |
bigint, null |
The identifier of the Workitem. It's related to the WORKITEM table. |
wiClosed |
tinyint, null |
Indicates if the Workitem is closed. If it has value 1, it means it has been closed. Otherwise is 0. |
idWorkItemState |
int, not null |
The identifier of the Workitem state. It's related to the WORKITEMSTATE table. |
wiName |
nvarchar(26), not null |
The name of the Workitem state. It's related to the WORKITEMSTATE table. |
idTask |
int, not null |
The identifier of the Task. 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. If it has value 1, it means it's an Asynchronous task, otherwise is 0. |
idTaskType |
int, null |
The identifier of the Task Type. Related to the TASKTYPE table. |
tskTpName |
nvarchar(26), null |
The name of the Task Type. |
idEnt |
int, not null |
The identifier of the Entity. It's related to the ENTITY table. |
entName |
varchar(50), not null |
The name of the Entity that the attribute belongs to. |
entDisplayName |
nvarchar(50), null |
The display name of the Entity that the attribute belongs to. |
entSrc |
nvarchar(26), not null |
The name of the physical table linked to the Entity that the attribute belongs to. |
entType |
tinyint, not null |
The identifier of the Entity type. It's not related to any table and its possible values are: •Application = 0 •Master = 1 •Parameter = 2 •System = 3 •Stakeholder = 4 (Equivalent to Persona) •Adhoc = 5 •CaseInfo = 6 •FileUpload = 7 |
entTypeDesc |
nvarchar(9), not null |
The name of the Entity type. |
idEntLogOpType |
tinyint, not null |
The Identifier of the type of operation on the entity when a modification occurs. It's related to the ENTLOGOPTYPE table. |
EntLogOpTypeName |
nvarchar(26), not null |
The name of the type of operation on the Entity when a modification occurs. |
elEntryDate |
datetime, null |
Date and exact time when a modification was made on the entity and the record was created in the log. |
idSurrogateKey |
bigint, not null |
The Identifier of the record (row) in the Entity to which the attribute that was modified in each case belongs. |
idAttrib |
int, null |
The identifier of the Attribute. It's related to the ATTRIB table. |
attribName |
nvarchar(26), not null |
The name of the Attribute. |
columnScr |
nvarchar(26), null |
The name of the physical column in the table linked to the Attribute. |
newValue |
nvarchar(500), null |
The value to which the attribute was updated at the time the task was advanced. |
idUser |
int, not null |
The identifier of the user who made a modification to the attribute. |
domain |
nvarchar(25), null |
Domain of the user who made the modification to the attribute. |
userName |
varchar(100), null |
The User name of the user who made the modification to the attribute. |
fullName |
varchar(200), null |
The full name of the user who made the modification to the attribute. |
|
To learn about the possible values available for the fields mentioned as related to value tables, refer to the Value List Tables article. |
Functions
In addition to Views, Bizagi has developed three functions that allow you to convert dates into integers, and viceversa. These functions are useful when you want to filter the database information you are querying over a range of dates.
Specifically, the functions are:
•xfnBA_DATE2BIGINT: Allows you to convert a date into a big integer (bigint). For more information on the range of the bigint data type, refer to the int, bigint, smallint, and tinyint (Transact-SQL) article of Microsoft’s SQL Server documentation.
create or alter function xfnBA_DATE2BIGINT (@dateTime datetime) returns bigint
as
begin
return convert(bigint, datediff_big(millisecond, '1970-01-01', @dateTime))
end
go
•xfnBA_DATE2INT: Allows you to convert a date into an integer (int). For more information on the range of the int data type, refer to the int, bigint, smallint, and tinyint (Transact-SQL) article of Microsoft’s SQL Server documentation.
create or alter function xfnBA_DATE2INT (@dateTime datetime) returns bigint
as
begin
--no milliseconds
return convert(bigint, datediff(second, '1970-01-01', @dateTime)) * 1000
end
go
•xfnBA_BIGINT2DATE: Allows you to convert a big integer (bigint) into a date.
create or alter function xfnBA_BIGINT2DATE (@dateNumber bigint) returns datetime
as
begin
return dateadd(millisecond, @dateNumber % 1000, dateadd(second, @dateNumber / 1000, '19700101'))
end
go
Last Updated 11/28/2024 11:27:38 AM