2000000000 33393404-e29c-482b-8ff5-43e770c6a082 NCOA & Address Verification Processing Use this recipient group to export all household addresses and have them verified and/or processed for change of address updates. Create new recipient groups from this group to process subsets of household addresses. Connect4 Support true false <Query QueryName="" QueryGUID="07803113-0c34-465d-8493-cd619b07b2fa" SchemaGUID="33393404-e29c-482b-8ff5-43e770c6a082" SchemaVer="622"> <Properties /> <Top>All</Top> <ResultGrouping>0</ResultGrouping> <Select> <ReturnField> <FieldName>Person.APrimaryCountry</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>0</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryZip</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>1</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryState</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>2</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.ACounty</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>3</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryCity</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>4</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryAddress2</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>5</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryAddress1</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>6</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.AIDPrimary</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>7</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.HID</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>8</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PID</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>9</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> </Select> <Where> <ConditionGroup GroupName="baseGroup" Behavior="0"> <Condition> <ComparisonFieldName>Person.ADateLastVerified</ComparisonFieldName> <ComparisonTypeName>is null</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>Person.PHHead</ComparisonFieldName> <ComparisonTypeName>is true</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>Person.APrimaryCity</ComparisonFieldName> <ComparisonTypeName>is not null</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> </ConditionGroup> </Where> </Query> SELECT Person.PID AS Person_ID, Person.HID AS Household_ID, Person.AIDPrimary, Person.APrimaryAddress1 AS Primary_Address_Line_1, Person.APrimaryAddress2 AS Primary_Address_Line_2, Person.APrimaryCity AS Primary_Address_City, Person.ACounty AS Primary_Address_County, Person.APrimaryState AS Primary_Address_State, Person.APrimaryZip AS Primary_Address_Zip, (CASE WHEN APrimaryCountry = 'United States' THEN Null WHEN APrimaryCountry = '' THEN Null ELSE APrimaryCountry END) AS Primary_Address_Country FROM dbo.v1_Personv2 Person WHERE Person.ADateLastVerified is Null AND Person.PHHead = 1 AND Person.APrimaryCity is not Null false 1000 Connect4 Support 2120 * Persons with H'hold & Org & Related Info false 2000000000 1015 Address Vedrification Import Recipient Group Address Vedrification Import Recipient Group false false false 2025-08-05T11:53:32 2025-08-05T11:53:32 1000 Connect4 Support 2 false true 2000000000 1168 0 0 false false false false 2025-08-05T11:53:32 2025-08-05T11:53:32 1000 Connect4 Support 2000000000 2000000000 <__SourceCommsTypes> 1015 E-Mail Message EmailMergeEngine 3.1 Connect4.Framework.Email.dll,Connect4.Framework.Email.cEmailEngine Email 1016 1018 0 1 2 EPrimaryEmailAddress,PID,EIDPrimary,PFirstName|First_Name,PLastName|Last_Name false true true true false false false false true 30 <_x0024_External>true <__SourceCommsTypes> 1020 MSWord Mail-Merge MSWordMerge 3.3 CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cMSWordEngine Hardcopy 0 0 1021 2 3 AIDPrimary,HID true true false true false true false false false 30 <_x0024_External>true <__SourceCommsTypes> 1168 Mail File Generation MailFileGeneration 3.9 CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cExportFileEngine Postal Mail 0 2 AIDPrimary,HID false true false true false false false false true 30 <_x0024_External>true <__SourceCommsTypes> 1169 SMS Text Message SMSTextMessage 3.11 Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.dll,Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.cSMSTextEngine SMS Text Msg. 1016 3 PID,TIDPhoneMobile,TPhoneMobile,THasSMS,TSMSDenied false true true true false false false false false 30 <_x0024_External>true <__SourceCommsTypes> 1174 Gnosis Report Design GREPMergeEngine 3.13 Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.dll,Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.cGREPMergeEngine 1173 0 0 2 AIDPrimary,HID false true true true false false false false false 30 <_x0024_External>true <__SourceCommsTypes> 1265 RTF Mail-Merge RTFMerge 3.15 CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cRTFMergeEngine HardCopy 1263 0 0 2 AIDPrimary,HID false true false true false false false false false 30 <_x0024_External>true <__SourceCommsTypes> 1272 Envelopes (Gnosis Rep Design) GREPEnvelopes 3.13 Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.dll,Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.cGREPMergeEngine N/A 1173 0 0 2 AIDPrimary,HID false true true true false false false false false 30 <_x0024_External>true <__SourceCommsTypes> 1276 Envelopes (for RTF Mail-Merge) RTFEnvelopes 3.15 CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cRTFMergeEngine N/A 1263 0 0 2 AIDPrimary,HID false true false true false false false false false 30 <_x0024_External>true <__SourceCommsDataTypes> 1016 8 Plain Text txt 3 <__SourceCommsDataTypes> 1018 8 HTML htm txt 3 <__SourceCommsDataTypes> 1021 8 MS Word Document doc 3 <__SourceCommsDataTypes> 1173 8 Gnosis Report Format repx 3 <__SourceCommsDataTypes> 1263 8 RTF rtf txt 3 <__SourceCommsDataTypes> 1454 8 Beefree The beefree/pro/plugin json format (template) that the html is built from beeJSON