When adding a business relationship for a constituent who does not currently have one in the Constituent Update Batch the RELATIONSHIPID will be null in the address and phone database tables.
The RELATIONSHIPID gets set when the constituent is added as a contact for the organization. This is currently not available in the Constituent Update Batch, and is only available on the constituent's record when editing the relationship. At that point, when the constituent is marked as a contact for the organization then the RELATIONSHIPID will be set on the phone and address database table.
Steps to Duplicate
1. Go to batch entry and add a new Constituent Update Batch 2. Make sure that the Business, Business reciprocal type, Business relationship type, Business address, Business address type fields are included in the template. 3. Enter in a constituent who does not currently have a organization relationship on their record 4. In the Business field, search for the organization that you would like to add a relationship for on the constituent's record. 5. Fill in the appropriate Business reciprocal type and Business relationship type 6. Save the batch and commit 7. Note that the RELATIONSHIPID is null in the address and phone database tables.