ParticipantFees
Returns a list of fees for a participant.
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: ParticipantId is required in order to query ParticipantFees.
- ParticipantId supports the '=' operator.
SELECT * FROM ParticipantFees WHERE ParticipantId = '197'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The ID of the participant fee. | |
| ParticipantId | String | The ID of the record that the participant fee is linked to. | |
| DateD | Integer | The day in the fuzzy date. | |
| DateM | Integer | The month in the fuzzy date. | |
| DateY | Integer | The year in the fuzzy date. | |
| EventFeeContributionAmount | Double | The tax deductible amount for this fee. | |
| EventFeeCost | Double | The fee's cost. | |
| EventFeeEventId | String | The ID of the event the fee is linked to. | |
| EventFeeId | String | The ID of the event fee. | |
| EventFeeName | String | The name of the event fee. | |
| EventFeeNumberSold | Integer | The number of fees sold. | |
| FeeAmount | Double | The amount of the participant fee. | |
| Quantity | Integer | The quantity purchased. | |
| TaxReceiptableAmount | Double | The tax receiptable amount of the participant fee. |