Help > Tables > W_Step

Table: W_Step

Information about an executed process step.

Column

Data type

Max. length (bytes)

Allow nulls

Description

ID

bigint

8

False

Unique identifier of the step.

SiteId

int

4

False

Currently not used.

Rev

bigint

8

False

Revision number. For internal use.

DocumentID

bigint

8

False

The ID of the related Document (ID in W_Document).

DocumentSiteId

int

4

False

Currently not used.

ProcessStepID

int

4

False

The ID of the related process (ProcessID in C_Process).

ActionType

int

4

False

0 = Create 
1 = Check out
2 = Check In
3 = Check in with Error
4 = Routed Manually
5 = Undo Check out
6 = Statistics

DoneAt

datetime

8

False

When the step was executed.

CheckOutDuration

float

8

False

The period of time in seconds during which the document was checked out for this step.

ErrorInfo

varbinary(max)

max

False

Error information if the document was checked in with an error.

Identifier

nvarchar(255)

510

False

The unique identifier of the process step definition.

Item

int

4

False

The sequence number of the step.

UserName

nvarchar(255)

510

False

The Windows user in whose name the client process ran.

Machine

nvarchar(255)

510

False

The Computer on which the client process ran.

BatchID

bigint

8

False

The ID of the root document (BatchID in W_Document).

BatchSiteId

int

4

False

Currently not used.

ValidID

int

4

False

The ID of the validation status (ID in C_Status). 

ErrorID

int

4

False

The ID of the error status (ID in C_Status).

DeletedAt

datetime

8

True

The date when the data set was deleted from the XBOUND database (main database).

Available in XBOUND 3.8 and later.

Foreign keys

Name

Columns

FK_W_Step_W_Document

DocumentID -> W_Document.ID

DocumentSiteId -> W_Document.SiteId

Uses

The available tables

The available views