Doorgaan naar de website
OCLC Support

Tasks for start or end of year

Find a checklist of tasks for the start or end of the year in Amlib with accompanying instructions.

Checklist of tasks for start or end of year

TASK

SCREEN

 

Deletion of students who have left – for example: Year 7s, Year 12s, Staff

Main > Borrowers > Borrower (Borrower module)

 

Changes of Borrower Class Name/Descriptions (if applicable)

Class names/descriptions may need to be altered to reflect new teachers’ names, etc.

Main > Borrowers > BorrowerClasses

 

Import of new students using data from School Administration system (or manually change students through global changes) Separate notes are available if necessary

Main > Borrowers > BorrowerImport

 

Add new staff (manually or through School Administration system)

(Import) Main > Borrowers > BorrowerImport

(Manual) Main > Borrowers > Borrower – Borrower > EnterNewBorrower

 

Date Changes for DEFAULT (global) all items must be returned by, end of term, end of semester, end of year, etc.

Main > Supervisor > Installation Circulation tab

 

Add final Return By Dates to Borrower Types (as applicable) – for example: Term Loans or Year Groups who leave earlier – i.e. Year 11 and/or 12

Main > Borrowers > BorrowerTypes

 

Add closed dates to calendar (Including holidays)

Main > Supervisor > Installation Circulation tab +

Main > Supervisor > Calendar

 

Ensure that Backup procedures are in place and that logs of Backups are regularly checked

This is very important – contact our office if you are in doubt…

 

Check Amlib version: has it been updated in the last year?

Main > Base> AboutRelease for your release dates. Amlib Version 6.0 was released in March 2014.

 

Are you updating your server or installing new PCs

Please consult Amlib Support for more information prior to beginning

 

How to obtain Online Help

Press Ctrl + H

 

Borrower records

A new calendar year for schools means new term times, new students, students who need deleting - some which probably still have loans or memos!

  • Deletions: Non returning Students
  • Additions: New students either manually or through a download from the School Administration system (for example: SIS, Maze, Synergy etc.)
  • Changes /Updating: Dates, Class descriptions

Deletions

It is best to delete students who have left BEFORE adding new students – for example: in a Primary School this will be the Year 7 students; in a Secondary School the Year 12 students can be found and deleted.

The following instructions are for a Primary School:

  1. Launch the Amlib client
  2. Go to Main > Borrowers > Borrower – the Borrower Details screen will display:
  3. Search for the Year 12 students: in the Type field, type the code – for example: Y12 and click the F5 Query button
  4. The results will display in a Borrower List:
  5. Select the Borrowers to be deleted by highlighting the rows – to select and highlight all the Borrowers:
    1. Press the Ctrl key and click with the left mouse button first borrower in range and then run the mouse down the left column, or
    2. Select first name in list and then Press shift and select the last Borrower in the range (useful for highlighting all of a big list!)
  6. From the menu, select Table > MassBorrowerDelete – a prompt with the following message will display: You are about to delete the selected Borrowers. Do you want confirmation of delete message?

Hint: You have already highlighted the borrowers for deletion. Confirming each and every borrower to be deleted will slow down the process.

No: All borrowers highlighted in the table will be deleted unless the borrower has loans, reservations or memos. No messages display.

Yes: Each borrower’s ID will display. Messages will also display if the borrower cannot be deleted (for example: the borrower has loans, reservations or memos, etc).

Delete single patron records

  1. Search by Surname in the Borrower Details screen
  2. Delete by clicking the F4 Delete button – a prompt with the following message will display: Borrower XXXXX Are you sure you wish to delete this Borrower?
  3. Click the Yes button to delete the borrower record – a prompt with the following message will display: The Borrower has been Deleted
  4. Click the OK button

 Note: Students with Loans, Reservations or Memos will not be deleted. If a student has left with items showing on loan, if the books are unlikely to be returned, it is suggested that these items be returned from the patron and either made lost or deleted so that the student (or teacher!) can be deleted from your database

Additions

New students need to be added. This can be done manually or automatically from your School Administration system. See Appendix A: Borrower Import for more detail or email Support for separate notes.

Barcodes will need to be added to the records. This can be done by selecting the New File created in the Import of patrons, click F9 Select to choose the file.

  1. Double-click the first borrower on the list and wand the new barcode
  2. Click the F3 Update button to save changes
  3. Click the F9 > button to go to the next patron on your list, etc.

Start of year dates

There are two sets of dates that require adjusting at the start of the year: the Supervisor Installation settings and the Borrower Type settings.

Supervisor settings

Default

  1. Launch the Amlib client
  2. Go to Main > Supervisor > Installation – the Installation (DEFAULT) screen will display
  3. Select the Circulation tab
  4. Adjust the following settings:
    1. All items must be returned by the following date:
    2. All Semester loans are due back on the following date:
    3. All Term loans are due back on the following date:
    4. All Year loans are due back on the following date:
  5. Dates must be entered in DD/MM/YYYY format – for example: 15/12/2012
  6. Click the F3 Save button
  7. For these settings to take effect you must exit and restart the Amlib client

Locatie

It is also possible to adjust these settings by individual Location, allowing for a different set of dates to be entered. It is very important to check your other locations to make sure that old dates are not saved in there.

  1. Launch the Amlib client
  2. Go to Main > Supervisor > Installation – the Installation (DEFAULT) screen will display
  3. From the menu, select Installation > Choose Location – the Installation location prompt will display
  4. Select a location (for example: Chelsea Library) and click the OK button – the Installation screen for that location will then display
  5. Select the Circulation tab
  6. If you would like to use the DEFAULT page settings, then you can leave the date settings in this location table blank, otherwise adjust the following settings (these settings will apply only to that location):
    1. All items must be returned by the following date:
    2. All Semester loans are due back on the following date:
    3. All Term loans are due back on the following date:
    4. All Year loans are due back on the following date:
  7. Dates must be entered in DD/MM/YYYY format – for example: 15/12/2012
  8. Click the F3 Save button
  9. Repeat for all other circulating locations (including WEB – the location used by the NetOpacs)
  10. For these settings to take effect you must exit and restart the Amlib client

Borrower settings

Borrower types

  1. Launch the Amlib client
  2. Go to Main > Borrowers > BrorrowerTypes – the Borrower Types screen will display:


    For each borrower type it is possible to enter a Return By Date that overrides the Supervisor Date settings and allows for return dates to be set earlier (if the Return By Date is set after the Supervisor Date settings, then these Supervisor Dates will be the cut off point for returns)
  3. Enter a date in DD/MM/YYYY format in the Return By Date field of a selected borrower Type – for example: 15/11/2013
  4. Repeat for any borrower Type where the Return By Date is required to be different
  5. Click the F3 Save button when complete
  6. Exit the Borrower module (Ctrl-L) for these settings to take effect

Classes / Groups

Some of the Class Name / description may need to be change because of staff, room changes, etc.

  1. Launch the Amlib Client
  2. Select Main > Borrower > Borrowers > BorrowerClasses – the Borrower Classes screen will display:
  3. Make the change/s
  4. Click the F3 Save button when complete
  5. Select Main > Borrower > Borrowers > BorrowerGroups – the Borrower Groups screen will display
  6. Make the change/s
  7. Click the F3 Save button when complete

Mass borrower change

This process can be used to change Borrower Group, Type, Class, etc. The example used here is Borrower Group.

  1. Launch the Amlib client
  2. Go to Main > Borrowers > BorrowerWhere – the Borrower Where screen will display
  3. Create a Where clause – for example: Group = CHI (this will search for all Borrowers who are in that particular group)
    1. Highlight the field to search on: Group
    2. Choose Operator: =
    3. Enter the Where condition, or the exact data you want to find – for example: CHI
    4. Click the Paste button to insert the clause into the table
  4. Click on the F7 QtoFile button – the Borrower Saved Query Results screen will now display:
  5. Click on the F1 New button to create a new Saved File
  6. Type in a name for the file in the Details column – for example: Groups to Change
  7. Click on F3 Save button
  8. Highlight the new Saved File and click on the F9 Select button to save results to this file
  9. A prompt with the following message will display: The 'XXXX' file contains XX borrowers.
  10. Click the OK button
  11. Go to Main > Borrowers > Borrower – the Borrower screen will display
  12. Select File > DisplayFile – the Borrower Saved Query Results file screen will display:
  13. Highlight the required Saved File and click on the F9 Select button to display the file
  14. From the Borrowers List screen, select Table > Mass Borrower Change
  15. The Mass Change of Borrowers within a File screen will display:
  16. Enter the following settings:
    1. Select the field you wish to change for all stockitems in the file – for example: Group
    2. Type in the new value example, which is what you are changing all stockitems to be – for example: DUT
    3. Click on the Paste button to insert the new criteria into the bottom table
    4. Click on the F3 Update button to start the mass change
  17. This will change all the Borrower Groups in this file so that they are now Dutch – the Borrower List screen will display

Calendar

Days closed

If the Libraries at all campuses are closed on common days (for example: weekends) it is possible to set these days closed in the Supervisor module:

  1. Launch the Amlib client
  2. Go to Main > Supervisor > Installation – the Installation (DEFAULT) screen will display
  3. Select the Circulation tab
  4. Adjust the following settings:
    • Days of the week when ALL Locations are closed (Sun=0, , Sat=6) – type in 06 if closed Saturday and Sunday
  5. Click the F3 Save button when complete
  6. Exit and restart the Amlib client for the new settings to take effect

Holidays

It is possible to mark days (holidays) to be ‘closed’ in the calendar (for example: Easter).

When an item is issued, the program will ensure that it the item is not due for return on closed dates. Reservations will not be due for collection on closed dates. Dates may be entered as far in advance as desired.

To mark a date as a closed:

  1. Launch the Amlib client
  2. Go to Main > Supervisor > Calendar – the Calendar screen will display
  3. Use the F7, F8, F9 and F10 buttons to navigate to a month where you want to set a closed date:
  4. Select a date with your mouse – for example: 25 December 2012
  5. Click the F2 Set button – the Holiday prompt will display:
    • Type in a suitable description in the dialogue box – for example Melbourne Cup or Term Break
    • Click the OK button
  6. The date will be marked in red (indicating it is closed) – the Date and Description will appear in the table to the right of the calendar:
  7. Once the dates have been set, click the F3 Update button
  8. Exit and restart the Amlib client for the new settings to take effect

 Note: Where a Return By date falls on a closed date, the system allocates the next non-closed date past that date.

  • Arrow Keys [F7], [F8], [F9], [F10]

To scroll through the calendar you may use the F7 through F10 keys:

key description

F7

<<

Scrolls to the beginning of the year. Clicking again, scrolls back to one year past

F8

<

Scrolls to the previous month for the year as displayed

F9

>

Scrolls to the next month for the year as displayed

F10

>>

Scrolls to the end of the year. Clicking again scrolls one year in advance

Remove a closed date

  1. To remove a closed date, highlight the date
  2. Click the F4 Delete button – this will mark [x] the Closed date for deletion
  3. Click the F3 Update button when complete
  4. Exit and restart the Amlib client for the new settings to take effect

Copy a closed date to other locations

Closed dates in Calendar can be copied to other Locations.

  1. From the menu, select Calendar > Copy To All – a prompt will display asking: This will make every location have exactly the same holiday settings as ‘XXX’. Continue?
  2. Click the Yes button – this will copy the closed settings to ALL locations
  3. Once complete, a prompt will display with the following message: Calendar successfully reproduced.
  4. Click the OK button
  5. Exit and restart the Amlib client for the new settings to take effect

Different closed dates for each location

If different closed dates are required for different Locations.

  1. From the menu, select Calendar > Choose Location – a Location prompt will display
  2. Select the Location and click the OK button
  3. The set the closed dates for this Location
  4. Click the F3 Update button when complete
  5. Exit and restart the Amlib client for the new settings to take effect

Logging help calls

Contact OCLC Support for help with Amlib.

Appendix A

Borrower import

The Borrower Import function enables sites to import borrower data from an Administration system (for example: Cases, EDSAS, Maze, Synergetic, etc) into the Amlib system.

This allows for:

  1. New borrowers, including address information, to be included in Amlib without having to manually enter them
  2. Updates of existing borrower records with new Type, Class codes, addresses etc.

This function is predominantly used by school libraries at the start of each year/semester to update their student records (or add new ones).

The program allows for the restoration of the old data if necessary.

It has a facility to “map” administrative codes to those used on your Amlib database. They do not have to be the same codes, but need to be matched to the corresponding codes so they will import correctly for each borrower record.

The data file to be imported can be copied from the administrative database onto a USB drive, CD or to a file accessible on the network. You will need to know the exact path so that you can access it during the Borrower download process (from your administrative database). Once the data file has been downloaded from the administrative database, it can be uploaded into Amlib.

The file sent to you should be in one of the following file formats:

  • CSV (comma delimited)
  • TAB delimited
  • Pipe separated (|)

You can have empty fields in your import, but they must be left empty and not have the data moved across. For example: if you didn’t have a Second Name or Preferred Name, you would leave two blank fields where they should be in your file:

Example format (CSV):

  • ANDERL,ANDERTON,LAURENCE,WILLIAM,LAURIE,1,RED,B1SJ,1/01/83,M,BB,MR & MRS W B ANDERSON, 5/165 KING EDWARD STREET,BAYSWATER,WA,6053,9462 1111

If the above example left out the RED Group code, the data would be:

  • ANDERL,ANDERTON,LAURENCE,WILLIAM,LAURIE,1, ,B1SJ,1/01/83,M,BB,MR & MRS W B ANDERSON,5/165 KING EDWARD STREET,BAYSWATER,WA,6053,9462 1111

Pipe (|) separated:

  • ANDERL|ANDERTON|LAURENCE|WILLIAM|LAURIE|1| |B1SJ |1/01/83|M|BB|MR & MRS W B ANDERSON|5/165 KING EDWARD STREET|BAYSWATER|WA|605|9462 1111

Dates must be formatted in one of the following three ways:

  • 11/12/09
  • 11/12/2009
  • 11 Dec 09

If there are trailing spaces in the data, the program strips these out and causes no problems with the download.

Format 1: MAZE, Synergetic, CASES, COSYCORNER

This format contains only 17-18 fields, which should be downloaded into a data file from the administrative software (for example: MAZE, Synergetic, CASES, COSYCORNER, etc.) in the sequence as shown below.

Mandatory Fields: The data must include Borrower Shortname (Unique ID/BarCode), Surname and Type. These cannot be left as null fields. Any unused fields should be left blank but included as null fields.

FIELD

CSV COLUMN

EXAMPLE

1. (Unique ID/BarCode)

Borrower Short Name/MAZE Key

A

ANDERL

2. Surname

B

ANDERSON

3. Given

C

LAURENCE

4. Second Name (only imports initial)

D

WILLIAM

5. Preferred (overrides Borrower Given)

E

LAURIE

6. Type

F

1

7. Group

G

RED

8. Class

H

B1SJ

9. Date of Birth (or date of entry depending on what is used by the admin. database)

I

1/01/83

10. Sex

J

M

11. Location

K

BB

12. Contact name

L

MR & MRS W.B. ANDERSON

13. Contact Address Line 1

M

5/165 King Edward St

14. Contact Address Line 2

N

Bayswater

15. Contact Address Line 3

O

WA

16. Postcode

P

6053

17. Contact Phone Number

Q

9462 1111

18. Email (Optional)

R

john.smith@oclc.org

Format 2: SIS (WA Education Dept)

This format contains only 22 fields, which should be downloaded into a data file from the Administrative software (SIS) in the sequence as shown in below.

 Note: All files must be in a standard .CSV format. Any unused fields should be left blank but included as null fields.

FIELD #

FIELD NAME

TYPE & SIZE

EXAMPLE

1

(Unique ID) ID/REF/BarCode

Alpha Numeric 15

1234

2

Type

Alpha Numeric 1

  1. student
  2. teaching staff
  3. Non Teacher

3

Date of Birth

Date

12 JAN 1993

4

Sex

Alpha Numeric 1

M / F

5

Surname

Alpha Numeric 40

Smith

6

First name

Alpha Numeric 40

Jonathon

7

2nd name

Alpha Numeric 20

Peter

8

3rd name

Alpha Numeric 40

Paul

9

Preferred name

Alpha Numeric 40

John

10

Addr line 1

Alpha Numeric 40

151 Royal St

11

Addr line 2

Alpha Numeric 40

 

12

Addr line 3

Alpha Numeric 40

 

13

Suburb

Alpha Numeric 50

East Perth

14

State

Alpha Numeric 40

WA

15

Postcode

Alpha Numeric 10

6004

16

Phone 1

Alpha Numeric 30

9264 1111

17

Phone 2

Alpha Numeric 30

9264 1113

18

E-mail

Alpha Numeric 100

john.smith@oclc.org

19

Parent Salute

Alpha Numeric 60

Mr & Mrs Smith

20

Class

Alpha Numeric 15

Room 5

21

Group (Type)

Alpha Numeric 2

4 (K, P 12, up etc)

22

Entry Date

Date

22 SEP 1998

Format 3: All Fields/EDSAS (SA Education Dept)

You must have at least 19 columns, up to 25 columns (with the exception of 22 – see Format 2).

Mandatory Fields: Borrower Shortname (Unique ID/BarCode) and Borrower Type. Additionally, you need to have data in the Location column even if this does not come from your Admin system. If you do not store patron location against the student in your admin system, you can just put a 1 in every line of the file and match this 1 to your library location later.

 Note:  If the data file only contains 19 fields the Guardian details are copied from fields 12 – 16. Any unused fields should be left blank but included as null fields.

FIELD

CSV COLUMN

EXAMPLE

1. (Unique ID /BarCode) Borrower Short Name

A

ANDERL or B9988

2. Surname

B

ANDERSON

3. Given Name

C

LAURENCE

4. Middle Name (only imports initial)

D

WILLIAM

5. Preferred Name (overrides Given)

E

LAURIE

6. Type

F

1

7. Group

G

RED

8. Class

H

10A

9. BirthDate

I

01/01/91

10. Sex

J

M

11. Location

K

BB

12. Address 3 Line 1 (Guardian Name)

L

MR & MRS ANDERSON

13. Address 1 Line 1

M

5/165 King Edward St

14. Address 1 Line 2

N

Bayswater

15. Address 1 Line 3

O

WA

16. P/Z Code

P

6053

17. Address 1 Tel.

Q

08 9462 1111

18. Email

R

laurie@oclc.org

19. (Other ID) Ref2

S

18846

20. Address 3 Line 2

T

8 Osborne Rd.

21. Address 3 Line 3

U

Innaloo

22. Address 3 Line 3 (merges with above)

V

WA

23. Address 3 Postcode/Zip Code

W

6017

24. Address 3 Tel.

X

08 9754 0000

25. Mobile/Cell

Y

0425 113 655

How records are matched

The records will be matched in the following way:

  1. Unique ID/Other ID – If the Unique ID/Other ID (BarCode/Ref2) from the file is found in Borrower, then the information for that patron will be overwritten with the data there, regardless of whether or not the name is the same. So if a student changes their surname, the new surname would come across in the import as long as the Borrower ID/Barcode is identical.
  2. Surname/Given Name – If no matching Borrower ID/BarCode is found, the system will then do a search for any matching surnames and first names. If there is one match found, the system will overwrite that record with the data in your file.
  3. Date of Birth – If more than one match is found for the surname and first name, the system will then try to locate the correct one using the date-of-birth. If a matching date-of-birth for that surname and first name is found, that record is updated. If the birthdates for these Borrowers are null then the Borrowers are considered duplicates (and the system creates a new record with an auto-generated AMLIB BarCode).

 

In the example below John Goldsmith changed his Surname to Smith. The BarCode in the Amlib borrower record was identical to the Unique Import Key (Unique ID), therefore the details were updated, showing the Borrower details with the new Surname.

  • The Borrower Import will remove single quotes from any incoming names – for example: O'Brien becomes OBrien.

Suggested ‘Pre-import’ tasks

You may wish to move all year 12 students (or year 6 students – for primary schools) into another class such as Year 13 or Year 7 using Mass Borrower Change. From there you can upgrade all other years and import new students. Any returning year 12 (or 6) students would be updated and moved back to class year 12 (6). All Remainder students can be dealt with as necessary.

Alternatively all students may be mass changed to a generic class via Mass Borrower Change, thus giving all students a single class. When doing then next import, all classes will be changed to the correct class. Any left with the generic class can be dealt with as necessary.

Before starting the import process, check the Type, Group, Class and Location tables in Amlib to ensure all required codes have been created. Check the Location table to ensure that the locations required have a Valid for Borrower setting of Y.

Importing into Amlib

  1. Launch the Amlib client
  2. Go to Main > Borrowers > BorrowerImport – the Borrower Import screen will display:
  3. Click the F1 Open button – the Import File… screen will display:
  4. Browse to file to be uploaded, select (highlight) it and click on the Open button
  5. Your data will appear in the Borrower Import screen and a prompt will display with the following message: All the Type, Group, Class and Location Codes have been loaded from the Import File. Use the ‘Setup’ menu to assign each Imported Code an equivalent Amlib Code before using the ‘Import’ option to update all the Borrowers. 



    The data read from the Borrower Import File can be sorted or have the actions calculated prior to importing the data into Amlib.
  6. To sort: From the menu, select Sort By > and select the sort field – the data can be sorted by Surname, Given name, Borrower Type, Group or Class.
  7. The calculate action option (Table > Calculate Action) will read the import data and state whether each student import will be UPDated, NEW or a DUPlicated student record
  8. If the F4 Import button is greyed out, it indicates the mapping between the imported codes needs to be setup (or adjusted) to match the codes used within Amlib. If it’s is bolded, the skip ahead to step 13
  9. From the menu, select Setup and then select one of the following Borrower fields: Types, Groups, Classes or Locations – in the example below, we have selected Types:

     

     Note: If a selection is greyed out, this indicates there are no codes requiring mapping for that field. Once a field has been successfully mapped a bolded tick will appear at the front of the selection.

  10. A Setup screen will display with two columns: The Imported Type and the Amlib Type. The Imported Type will be the data located in your Borrower Type column (Field 6/CSV column F) of your import file. The Amlib Type will be the codes located in the Main > Borrowers > BorrowerTypes screen.
  11. For each Imported Type, use the Amlib Type drop-down to select a Borrower Type you would like to match (map) it against
     

     Note:It is possible to map more than one Imported Type to the same Amlib Type.

  12. You will need to do this for all the bolded selections in the Setup menu – when you have finished all the fields, they will all have a bolded tick next to them and the F4 Import button will then be active (bolded):
  13. Click the F4 Import button – the Borrower Import Files screen will display – this screen allows you to create files to save New, Updated and Duplicate borrowers to. It also allows you to Overwrite Given name(s) and initial(s) and to Use (their) Date of Birth for unique checking.
  14. Type in the filenames, and tick the settings you would like to use, then click the OK button – a prompt will display asking if you wish to save any changed borrowers to a file for recovery purposes: It is recommended that all changed Borrowers be written to a text file for recovery purposes. Do you want to save changed Borrowers to a file?


    WARNING! This is your insurance for your borrower data and is thoroughly recommended!!
     
  15. If you click the Yes button, a dialog box will display so that you can choose the file name for your original data and where to save it

     

     Note: In subsequent downloads, the restore.txt or restore.csv file will already exist and a message will display asking if you wish to overwrite this file. You would normally respond Yes to overwrite the file.

  16. Once complete, a prompt will display notifying you that: The Borrower Import is complete.

     

     Note: The import process can take several minutes (for example: 1-3 seconds per borrower). The status of the import displays at the bottom of the screen.

  17. If borrowers with duplicate Borrower IDs are imported, then you will receive notification of this as part of the completion notice: The Borrower Import is complete. Some Duplicate Borrower ID’s were detected – these Borrowers have been saved to the ‘Duplicate ID’ saved file.

File checking

 

  1. An Amlib Unique ID (BarCode) was created for the borrower who had the same ID as someone else (AMLIB0000…)
  2. If you go into the main Borrower screen (Main > Borrowers > Borrower) and go to File > DisplayFile you will see your three files for new, updated and duplicate borrowers, and a file for any duplicate IDs if your import had any

 

Common errors

  • The chosen file does not contain Borrower Import records.


    This could be caused by either having the information in the correct columns or having headings across the top of your document. Remove any headings and double check your file against the Import formats in this document.
     
  • The chosen file does not contain valid records.


    This could be caused by having headings across the top of your import file or it being saved in an incorrect format (for example: .xlsx and not .csv). Please remove any headings, ensuring that it only contains Borrower information and make sure it is in one of the three formats mentioned at the beginning of this document.

 Note: It is always a good idea to run a Borrower Import on your test databases first, to ensure no errors happen. If you do not have a test databases, please contact Support via one of the above methods to find out how to set one up.

Borrower import matching

The following explains the exact method in which Amlib matches on borrower imported records:

  1. Uses the Unique ID to match on Borrower BarCode
  2. If no matches then uses the Unique ID to match on Borrower Ref2
  3. If a Preferred Name has been Supplied:
    • Matches on Surname and Preferred EXACTLY
  4. If 2, matches on Surname and Preferred EXACTLY
  5. If Date-of-Birth Supplied:
    • Searches on Surname, Preferred and Date-of-Birth
  6. If no matches and an Initial has been supplied:
    • Matches on Surname, Preferred and Initial
  7. If no matches and an Initial has NOT been supplied:
    • Matches on Surname, Preferred and NULL Initial
  8. If no Date-of-Birth Supplied:
  9. If no matches and an Initial has been supplied
    • Matches on Surname, Preferred and Initial
  10. If no matches and an Initial has NOT been supplied
    • Matches on Surname, Preferred and NULL Initial
  11. If no matches on Surname and Preferred EXACTLY
    • Searches on Surname EXACTLY and LIKE Preferred (for example: Preferred%)
  12. If no matches then matches on Surname and Given EXACTLY
  13. If 2, matches on Surname and Given EXACTLY
  14. If Date-of-Birth Supplied:
    • Searches on Surname, Given and Date-of-Birth
  15. If no matches and an Initial has been supplied:
    • Matches on Surname, Given and Initial
  16. If no matches and an Initial has NOT been supplied
    • Matches on Surname, Given and NULL Initial
  17. If no Date-of Birth Supplied:
  18. If no matches and an Initial has been supplied:
    • Matches on Surname, Given and Initial
  19. If no matches and an Initial has NOT been supplied:
    • Matches on Surname, Given and NULL Initial
  20. If no matches on Surname and Given EXACTLY
    • Searches on Surname EXACTLY and LIKE Given (for example: Given Name)