33393404-e29c-482b-8ff5-43e770c6a082NCOA Household Address Information ExportThe NCOA Address Export Report is used to export data for National Change of Address (NCOA) processing. All columns, including numeric reference columns, must be supplied and returned from NCOA processing in order to import the result into Gnosis. <Query QueryName="" QueryGUID="d8713152-a3ed-4d44-a151-5bb9049c924b" SchemaGUID="33393404-e29c-482b-8ff5-43e770c6a082" SchemaVer="410"> <Properties /> <Top>All</Top> <ResultGrouping>0</ResultGrouping> <Select> <ReturnField> <FieldName>Person.APrimaryZip</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>0</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryState</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>1</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryCity</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>2</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryAddress2</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>3</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryAddress1</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>4</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.HName</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>5</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PFirstName</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>6</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PLastName</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>7</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.AIDPrimary</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>8</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.HID</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>9</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PID</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>10</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> </Select> <Where> <ConditionGroup GroupName="baseGroup" Behavior="0"> <Condition> <ComparisonFieldName>Person.APrimaryAddress1</ComparisonFieldName> <ComparisonTypeName>is greater than</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues> <ConditionValue>!</ConditionValue> </ConditionValues> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>Person.PHPrimaryHousehold</ComparisonFieldName> <ComparisonTypeName>is true</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> <ConditionGroup GroupName="" Behavior="1"> <Condition> <ComparisonFieldName>Person.APrimaryCountry</ComparisonFieldName> <ComparisonTypeName>equals</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues> <ConditionValue>United States</ConditionValue> </ConditionValues> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>Person.APrimaryCountry</ComparisonFieldName> <ComparisonTypeName>is null</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> </ConditionGroup> </ConditionGroup> </Where> </Query>0falsefalsefalsefalse2019-05-21T05:28:39Connect4 Supportrepx<__OriginalRID>1281