ConstituentProspectStatusHistories
Returns a list of prospect histories for a constituent.
Table Specific Information
Select
The connector will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
Note: ConstituentId is required in order to query ConstituentProspectStatusHistories.
- ConstituentId supports the '=' operator.
select * from ConstituentProspectStatusHistories where ConstituentId = '1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Is the status past due. | |
| AuthorId | String | The author id of the status history record. | |
| AuthorName | String | The author name of the status history record. | |
| Comments | String | The comments for the prospect status history | |
| ConstituentId | String | The constituent identifier for the prospect status history | |
| DaysElapsed | Integer | The number of days elapsed in this particular prospect status | |
| IsPastDue | Boolean | Is the status past due. | |
| StartDate | Datetime | The status start date for the prospect status history | |
| StatusDescription | String | The status description for the prospect status history | |
| StatusId | String | The status identifier for the prospect status history |