HistoryRuntimeAudit

Id

ID of Audit record.

No

BigInt

ControlRecipeId

ID that points to the parent History Control Recipe

No

Integer

ProcedureTokenId

ID that points to the parent History Capability. This will be null if this is an Equipment Audit Event.

Yes

Integer

ProcedureToken
Instance

Parent History Capability. This will be null if this is an Equipment Audit Event.

Yes

Integer

RequestUser

Name of user that triggered the request. It will be NULL for state changes

Yes

nVarchar

RequestUserDoneBy

Name of user that performed the Done By action on the request

Yes

nVarchar

RequestUserCheckBy

Name of user that performed the Check By action on the request

Yes

nVarchar

DoneByComment

Comment from the Done By user on the request

Yes

nVarchar

CheckByComment

Comment from the Check By user on the request

Yes

nVarchar

EventDateUtc

Specifies the DateTime when the audit event was added to history.

No

DateTime

RuntimeState

Specifies runtime state. It is either a new state (if the RuntimeRequest is None) or the current state when the request happened

No

Integer

RuntimeRequest

Specifies runtime request type. It is None if this is a State change and not a request

No

Integer

NextStateDateUtc

Specifies the DateTime of when the Runtime State changes.

Yes

DateTime

NextStateDate
Offset

Specifies the offset value from when the Runtime state was modified.

No

Integer

EventDateOffset

Specifies the offset value from when the audit event was added to history.

No

Integer

DoneByDateUTC

Specifies the DateTime when the DoneBy signature occurred.

Yes

DateTime

DoneByDateOffset

Specifies the offset value from when the signature DoneBy was added to history.

No

Integer

CheckByDateUTC

Specifies the DateTime when the CheckBy signature occurred.

Yes

DateTime

CheckByDate
Offset

Specifies the offset value from when the CheckBy signature was added to history.

No

Integer