Add affiliations for non-Household accounts

add-affs.apex

Contact[] contacts = [select Id, AccountId from Contact where AccountId != null and Account.RecordType.DeveloperName != 'HH_Account'];
List<Id> contactIds = new List<Id>();
for (Contact c : contacts) contactIds.add(c.Id);
npe5__Affiliation__c[] affs = [select npe5__Contact__c, npe5__Organization__c from npe5__Affiliation__c where npe5__Contact__c in :contactIds];

npe5__Affiliation__c[] inserts = new List<npe5__Affiliation__c>();

for (Contact c : contacts) {
    Boolean hasAff = false;
    for (npe5__Affiliation__c aff : affs) {
        if (aff.npe5__Contact__c != c.Id) continue;
        hasAff = true;
        break;
    }
    if (!hasAff) {
        inserts.add(new npe5__Affiliation__c(
            npe5__Contact__c = c.Id,
            npe5__Organization__c = c.AccountId
        ));
    }
}
insert inserts;