ProcessInstance
Tracks running instances of approval processes, recording their status and progression.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier for the process instance record. | |
| ProcessDefinitionId | String | Identifier of the approval process definition associated with this instance. | |
| TargetObjectId | String | Identifier of the record that the approval process is acting upon. | |
| Status | String | Current status of the process instance, such as Started, Approved, or Rejected. | |
| CompletedDate | Datetime | Date when the record was completed. | |
| LastActorId | String |
User.Id | ID of the LastActor associated with this record. |
| ElapsedTimeInDays | Double | Field containing ElapsedTimeInDays information. | |
| ElapsedTimeInHours | Double | Field containing ElapsedTimeInHours information. | |
| ElapsedTimeInMinutes | Double | Field containing ElapsedTimeInMinutes information. | |
| SubmittedById | String |
User.Id | ID of the SubmittedBy associated with this record. |
| IsDeleted | Bool | Indicates whether the process instance has been deleted from the system. | |
| CreatedById | String |
User.Id | Identifier of the user who initiated the process instance. |
| LastModifiedDate | Datetime | Date and time when the process instance was last updated. | |
| LastModifiedById | String |
User.Id | Identifier of the user who last modified the process instance. |
| SystemModstamp | Datetime | System-generated timestamp indicating the latest update to the process instance. | |
| CreatedDate | Datetime | Date and time when the process instance was created. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TargetObjectIdType | String | Specifies the type of the 'TargetObjectId' polymorphic field to use in the statement. | |
| TargetObjectIdExternalFieldName | String | Specifies the external field name of the 'TargetObjectId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| SOQL | String | Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. |