Transactions on Hold Report

The following columns are available within the Transactions on Hold Report.

Tip: Transactions appear in the Transactions on Hold report once they have a true hold applied to them. For most hold reasons, that happens before a disbursement attempt is made. For stale checks, this happens when the check is voided.

Term Definition
Pledge ID The system-generated ID
Donation ID Donation ID/Transaction ID
Recent Payment Number Most recent payment number that the transaction appeared on
Employee First Name

Employee’s first name

Column data is from client HR data.
Employee Last Name

Employee’s last name

Column data is from client HR data.
Employee Email

Employee’s email address

Column data is from client HR data.
Employee ID Column data is from client HR data.
Is Employee Active

True/False - Identifies whether this is a current employee

  • If active, TRUE.

  • If inactive, FALSE.

Column data is from client HR data.
Charity Name Charity’s name
Registration Number Charity registration ID according to the charity feed from Blackbaud Verified Network. This is the charity's official ID, and is also referred to as Tax ID, bank identification number (BIN), employer identification number (EIN), registration number, or Government ID.
Charity ID The unique ID in the YourCause system for this charity
Charity Address 1 Charity’s address
Charity Address 2 Charity’s address
Charity City Charity’s city
Charity State Charity’s state
Charity Postal Code Charity’s postal code
Charity Country Name Charity's country name
Charity Country Code Charity’s country code
Charity Status

True/False - Identifies whether this is a current charity

  • If active, TRUE.

  • If inactive, FALSE.

Column data is from client HR data.
Charity Source Registration authority from charity management
Parent Charity ID

Parent Charity ID

  • If there is no parent, this field is blank.

  • If this is the parent charity, the ID is repeated here.
Original Donation ID Original donation ID/Transaction ID
Donation Date For offline donations, this is the original donation date entered by the user rather than the date recorded in the application.

For all other donation types, this is the date the donations were recorded in CSRconnect.
Designation The designation the user selected or entered when they made their donation/pledge
Transaction Amount Donation amount
Donation Type Donation/transaction type
Status Reason

Reason the transaction is currently on hold. This column is blank once the payment has been processed.

Applicable statuses include:

  • Stale Check Holds

  • Charity No Longer Active

  • Charity Not Give Eligible

  • Charity on State Revocation

  • Disbursement Suspended

  • Undelivered Check Holds

  • Returned ACH

  • Returned Wire

  • Charity Bank Account Info Missing

  • International Payee Bank Account Not Found

  • Payment Below Minimum Threshold
Stranded Funds Redirection Status

Was this transaction set to be redirected (but not yet disbursed to the new charity), redirected, reissued, or was no action taken?

Applicable statuses include:

  • Set To Be Redirected

  • Redirected

  • Reissued

  • No Action
Stranded Funds Automation Status

If redirected, did the automation or user redirect this transaction?

Applicable statuses include:

  • Automation-User Default: The donation was automatically redirected based on the user's previous selection. Applies to recurring transactions.

  • Automation-Affiliate Default: The donation was automatically redirected to the client's selected alternate organization.

  • Automation-ProcessorCharity: The donation was automatically redirected to the payment processor. Applies if the client has not selected an alternate organization, or if the selected alternate has become ineligible for giving.

  • User: The user selected a redirect organization. Applies to donors in California.

  • No Action
Stranded Funds Modified Date

Date of redirect/reissue

Date shown only if action taken. If there was no action taken yet, this field is blank.
Original Payment Created Date Original check or ACH date
Recent Payment Created Date Most recent check or ACH date
Number of Payments Number of times this transaction ID has been included on a payment (check or ACH)
Employee Residence Country Code

Employee's country of residence

Column can be null if the codes have not yet been submitted or the employee's residence is outside of the US or Canada.
Employee Residence State Code

Employee's state of residence

Column can be null if the codes have not yet been submitted or the employee's residence is outside of the US or Canada.
Donor CA or non-CA Did this donor select California as their location of residency? Determines which stranded funds automation process applies to the stranded fund.
Original Payment Aging in Days Number of days since the original check or ACH payment was created
Recent Payment Aging in Days Number of days since the most recent check or ACH payment was created
Net Amount Donation amount minus any applicable fees
Stranded Fund Stale Transaction Id Transaction Id for this stranded fund
Stranded Fund Processing Redirected Status Status of the redirection transaction
Stranded Fund Request Count

How many times the employee has been contacted to select a redirect option:

  • 1: The system has sent the 30-day reminder email

  • 2: The system has sent the 30-day and 14-day reminder emails

  • 3: The system has sent the 30-day, 14-day, and 7-day reminder emails
Stranded Fund Redirect Type

Type of redirect applied to this transaction:

  • UserRedirect: The user selected a redirect organization.

  • UserPreferenceRedirect: The donation was redirected to an organization the user previously selected when another transaction in this series entered Stranded Funds Automation. Applies to pledges and recurring transactions.

  • ExpiredRedirect: The user did not select a redirect organization, so the donation was redirected to the employer’s selected alternate organization.

  • UserRedirectFailed: The user selected a redirect organization, but this donation became a stranded fund again. The donation was redirected to the employer’s selected alternate organization.

  • NonCAResidentRedirect: The transaction was automatically redirected to the employer’s selected alternate organization without input from the employee.
Stranded Fund Original Charity Id Charity Id for the original charity
Stranded Fund Redirect Charity Id Charity Id for the redirect charity
Stranded Fund Original Processor Id Processor Id for the original donation
Stranded Fund Redirected Processor Id Processor Id for the redirected donation
Stranded Fund Status Reason Code Reason why this donation was placed on hold
Stranded Fund Payroll Deduction Request Id Request Id for stranded funds originating from a payroll deduction donation
Stranded Fund Grant Request Id Request Id for stranded funds originating from a volunteer grant
Is Stranded Fund Active Indicates whether the donation is still a stranded fund or has been resolved
Stranded Fund Created Date Date the donation became a stranded fund
Stranded Fund Updated Date Date of the last update to this stranded fund
Stranded Fund Updated By Entity that last updated this stranded fund
Transaction Redirect Setting Charity Id Charity Id for the employer’s selected alternate organization
Transaction Redirect Setting Charity Is Default Indicates whether this charity is selected as the employer’s alternate organization
Transaction Redirect Setting Charity Processor Id Processor Id for the employer’s selected alternate organization
Original Transaction Hold Type Name First hold type applied to this transaction. Only populates if the transaction has been on hold more than once.
Original Hold Reason Code Code for the reason the first hold was applied. Only populates if the transaction has been on hold more than once.
Original Hold Reason Code Name Reason the first hold was applied. Only populates if the transaction has been on hold more than once.
Original Transaction Hold Notes Any notes for the first hold. Only populates if the transaction has been on hold more than once.
Original Transaction Hold Created Date Date the first hold was applied. Only populates if the transaction has been on hold more than once.
Original Transaction Hold Created By Entity that applied the first hold. Only populates if the transaction has been on hold more than once.
Original Transaction Hold Updated Date Date of the most recent update to the first hold. Only populates if the transaction has been on hold more than once.
Original Transaction Hold Updated By Last entity to update the first hold. Only populates if the transaction has been on hold more than once.
Transaction Hold Type Name Hold type applied to this transaction. If the transaction has been put on hold more than once, this is the most recent hold.
Hold Reason Code Code for the hold reason. If the transaction has been put on hold more than once, this is the most recent hold.
Hold Reason Code Name Reason the hold was applied. If the transaction has been put on hold more than once, this is the most recent hold.
Transaction Hold Notes Notes for the hold. If the transaction has been put on hold more than once, this is the most recent hold.
Transaction Hold Created Date Date the hold was applied. If the transaction has been put on hold more than once, this is the most recent hold.
Transaction Hold Created By Entity that applied the hold. If the transaction has been put on hold more than once, this is the most recent hold.
Transaction Hold Updated Date Date of the most recent update to the hold. If the transaction has been put on hold more than once, this is the most recent hold.
Transaction Hold Updated By Last entity to update the hold. If the transaction has been put on hold more than once, this is the most recent hold.