Table contains one row per split per recognition credit. Credits are consolidated at the household level.
Exceptions:
- Any revenue added to committees, groups or households is not included (Atlas policy does not allow revenue to be added on these constituents)
- “Recognition Only” recognition credits. These currently exist only at BWH, and are added to this table in addition to any other soft credits. Revenue will be double-counted if a donor has a “Recognition Only” recognition credit on a transaction in addition to any other type of recognition.
| Column | Comments |
|---|---|
| ACKNOWLEDGEDDATEDIMID | |
| ADDEDDATE | |
| ADDEDDATEDIMID | |
| APPEALBUSINESSSUBUNIT | |
| APPEALBUSINESSUNIT | |
| APPEALCATEGORY | |
| APPEALDESCRIPTION | |
| APPEALDIMID | |
| APPEALPROGRAM | |
| APPEALPURPOSE | |
| APPEALSITE | |
| CAMPAIGNLIST | |
| CHANGEDDATE | |
| CHANGEDDATEDIMID | |
| DESIGNATIONDEPARTMENT | |
| DESIGNATIONDIMID | |
| DESIGNATIONLIST | |
| DESIGNATIONLOOKUPID | |
| DESIGNATIONNAME | |
| DESIGNATIONSITE | |
| FINANCIALTRANSACTIONAMOUNT | |
| FINANCIALTRANSACTIONFACTID | |
| FINANCIALTRANSACTIONLINEITEMFACTID | |
| FINANCIALTRANSACTIONLINEITEMSYSTEMID | |
| FINANCIALTRANSACTIONPOSTDATEDIMID | |
| FINANCIALTRANSACTIONSYSTEMID | |
| GIFTTYPE | |
| GIFTTYPEDIMID | |
| H_Amount | |
| HARDCREDITDONORCONSTITUENTDIMID | |
| HARDCREDITDONORCONSTITUENTSYSTEMID | |
| HARDCREDITDONORLOOKUPID | |
| HardCreditDonorName | |
| HOUSEHOLDCONSTITUENTDIMID | |
| HOUSEHOLDCONSTITUENTSYSTEMID | |
| HouseholdFormalAddressee | |
| HouseholdSORTNAME | |
| HS_Amount | |
| HSM_Amount | |
| ISACKNOWLEDGED | |
| ISANONYMOUS | |
| ISCASH | |
| ISCOMMITMENT | |
| ISFIRSTGIFT | |
| ISHARDCREDITDONOR | |
| ISHONOROFTRIBUTE | |
| ISMEMORYOFTRIBUTE | |
| ISONLINEGIFT | |
| ISPRIMARYRECOGNITIONDONOR | Calculations require the Financial Transaction attribute "Primary Recognition Override" exist in affiliate database. See Organization Options to determine how this is calculated for a specific affiliates |
| MARKETINGEFFORTDESCRIPTION | |
| MARKETINGEFFORTSOURCECODE | |
| MARKETINGSEGMENTATIONDIMID | |
| OTHERPAYMENTMETHOD | |
| PAYMENTSUBTYPE | |
| PrimaryHouseholdMemberConstituentDimID | |
| PRIMARYHOUSEHOLDMEMBERCONSTITUENTSYSTEMID | |
| PrimaryHouseholdMemberLOOKUPID | |
| PRIMARYRECOGNITIONDONOR_CRITERIA | Added 9/2023, shows the number of the calculation rule used to determine ISPRIMARYRECOGNITION for this particular donor |
| PRIMARYRECOGNITIONDONOR_FLAG | Added 9/2023, shows data from Organization Options showing the calculation used for this affiliate to calculate ISPRIMARYRECOGNITIONDONOR |
| PURPOSELEVELDESCRIPTION | |
| PURPOSELEVELDIMID | |
| PURPOSELEVELLIST | |
| PURPOSELEVELLOOKUPID | |
| PURPOSELEVELNAME | |
| PURPOSELEVELPUBLICNAME | |
| PURPOSELEVELPUBLICNAMELIST | |
| PURPOSELEVELTYPE | |
| PURPOSESCATEGORY | |
| PURPOSESITE | |
| RECOGNITIONDATE | |
| RECOGNITIONDATEDIMID | |
| RECOGNITIONDATEFISCALMONTH | |
| RECOGNITIONDATEFISCALMONTHNAME | |
| RECOGNITIONDATEFISCALYEAR | |
| RECOGNITIONTYPE | |
| REVENUEAPPLICATION | |
| REVENUEBUSINESSUNIT | |
| REVENUECHANNELDESCRIPTION | |
| REVENUEDATE | |
| REVENUEDATEDIMID | |
| REVENUEDATEFISCALMONTH | |
| REVENUEDATEFISCALMONTHNAME | |
| REVENUEDATEFISCALYEAR | |
| REVENUEPAYMENTMETHOD | |
| REVENUERECOGNITIONFACTID | |
| REVENUERECOGNITIONSYSTEMID | |
| REVENUESPLITBUSINESSSUBUNIT | |
| REVENUETRANSACTIONTYPE | |
| SECONDARYHOUSEHOLDMEMBERCONSTITUENTDIMID | |
| SECONDARYHOUSEHOLDMEMBERCONSTITUENTSYSTEMID | |
| SECONDARYHouseholdMemberLOOKUPID | |
| SPLITRATIO | |
| TRIBUTELIST |