Choosing an Action Code

Action Code

A code that indicates what you want to do with the borrower record information you import.

In S41 and M41 formats, the action code is the first field on each line and is designated by a x- in the header and ?- in the data. A space after the dash is optional.

Action Code

Description

A

Add. Adds a new borrower record to Horizon’s database. If the record exists in the borrower table, Borrower Import displays an error and goes to the next record.

D

Delete. Deletes the borrower record from Horizon’s database. If the record does not exist or if the borrower has a block such as overdue, Borrower Import displays an error and goes to the next record.

U

*Update. Replaces existing borrower records in the Horizon database with new records. If the record does not already exist, Borrower Import displays an error and goes to the next record.

M

*Modify. Replaces existing borrower records in the Horizon database with new records. If the record does not already exist, Borrower Import adds it to the Horizon database.

*You can replace tables in borrower records instead of replacing entire borrower records when you are updating or modifying records. To do this, enter only the table that you want to replace.

For example, you could enter these header and data files to replace the borrower_phone table:

header1.txt

x–borrower:second_id
borrower_phone:phone_type, phone_nodata1.txt

data1.txt

M–borrower:555-55-5555
borrower_phone:work, 223-5871

When you use update and modify, you must import all the necessary information for the borrower record, because the imported record replaces the existing record. However, if you are using the /Z N switch, you only need to import the necessary information for the table you are replacing.

 


© 1998-2017 Sirsi Corporation