› Manage Invoice Processing › Validation activity configuration › Database lookups › Kofax Search and Matching Server databases › KSMS AP_Employee settings

KSMS AP_Employee settings

When adding the AP_Employee 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