Below is an outline of the fields for the Grateful Patient Solution (required fields are in bold). If you do not track some of the required fields, a column representing the field must still be present in the file. The format of your daily file submissions must remain consistent once the initial programming is complete for your Grateful Patient Solution process.
The file must be in comma-separated or pipe-delimited format. The file name must be no longer than 20 characters and may not contain spaces or special characters. The file name cannot change once the automation has been completed. The file may be submitted as often as once daily. After the file is created it must be uploaded to the Blackbaud FTP account setup for Grateful Patient Solution processing in the WPOT/IN folder.
- Constituent ID (Duplicate records will be created in ResearchPoint if the same ID isn't used each time the record is submitted to a service whose results are returned in ResearchPoint (ie. Grateful Patient Solution, Affluence Insights, etc.)
- First Name
- Last Name
- Home Address Line 1
- Home Address Line 2
- Home City
- Home State
- Home Zip Code
- 5 Optional custom fields, as set up with your Data Analyst.
If you have questions regarding your field layout, please contact your Data Analyst or the Target Analytics Support Team (http://support.blackbaud.com).