Welcome > Configure Kofax AP Agility > Manage Invoice Processing > Validation Activity configuration > Database lookups > Kofax Search and Matching Server databases > KSMS BRWEmployeeMaster settings

KSMS BRWEmployeeMaster settings

When adding the BRWEmployeeMaster database to KSMS, ensure that the following settings are applied. Without this configuration, the database lookup does not work as expected.

Setting

Value

Connection Type

Microsoft SQL Server

Connection String

Connection string for the APAgility database

Relational database object

BRWEmployeeMaster

Columns to Use

Ensure that the following columns and only these columns are selected for Search.

  • ID

  • Name

  • Address1

  • Address2

  • City

  • Zip

  • State

  • Country

Ensure that the following column and only this column is selected for Filtering.

  • PartitionID

Ignore case

Selected

Database active after import

Selected

Word separation characters

,-; and Space is selected