Skip to main content

NCOA Interface Parameters

Paige Freeman
  • Updated

You must have access to the Settings.ApplicationSettings security application to access this page.

To define interface parameters for National Change of Address (NCOA):

  1. From the Settings section of the left navigation menu, select Application Settings. From the Application Settings page, select NCOA Interface Parameters from the Third Party Integrations > Other Third Party Interfaces section.
    The Configure NCOA page displays, as shown below.
  2. Select the edit pencil in the grid to edit the value of the corresponding parameter.
    Please see the table below for descriptions of the available parameters.
Parameter Name Parameter Value Comments

ADDITIONAL_FILTER

CUS_ADDRESS_DETAIL.PRIORITY_SEQ=0 AND CUS_ADDRESS_DETAIL.SHIP_TO_FLAG='Y'

This parameter should have valid sql condition to be appended into the where clause while exporting the data for NCOA. The tables should be CUSTOMER, CUS_ADDRESS and CUS_ADDRESS_DETAIL. e.g. CUS_ADDRESS_DETAIL.PRIORITY_SEQ=0 AND CUS_ADDRESS_DETAIL.SHIP_TO_FLAG='Y', etc.

ADDRESS_TYPE_CODE

WORK,HOME

Address Type against which files will be generated. In case of multiple values, please provide Comma (,) separated values.

CLIENT_NAME

BASE

Client name for NCOA file(The value of this parameter will be used to generate the Unique File Name)

COUNTRY_CODE

USA,CAN

Country Code for NCOA file should be USA or CAN only/both with comma (,) separated.

NCOA_FILE_PATH

C:\NCOA_Files

Physical file path at the BOE server where the ETL files will be generated.

NCOA_MIN_RECORD_COUNT

101

Minimum required record count to be processed at NCOA

NCOA_MODOPER

NCOA_ETL_JOB

Modoper to be set while updating the CUS_ADDRESS and CUS_ADDRESS_DETAIL tables.

RECORD_TYPE

I,C,S,T

Provide the Record type against which we want to generate the file to be sent over for NCOA. In case of multiple values, please provide Comma (,) separated values.

STATE

ALL

State against which we need to generate the NCOA file. The values should be "ALL" or any valid state code. In case of multiple states provide Comma (,) separated values.

VENDOR_NAME

VeriMove

Vendor name for NCOA file. (The value of this parameter will be used to generate the Unique File Name)