tab_bor_id.eng - what does col. 1 do? type "06 Campus Access" *BASIC*

• Article Type: General
• Product: Aleph
• Product Version: 19.01

Description:
Aside from ID 00 and 01 (system number and barcode), does the number in col 1 mean anything?

I'm looking at adding an LDAP id, and was surprised to see that we have an ID '06' which apparently displays as "LU Campus Access" in the GUI and can be used for verification, but I don't know where the "Campus Access" displayed in the GUI is coming from, nor the '06.'

Our tab_bor_id.eng says:
!!-!-!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!-!!-!-!-!-!-!
00 L System number 00 Y Y Y N
01 L Barcode 00 Y Y Y Y
02 L Additional ID 02 00 Y Y Y N
03 L Additional ID 03 00 Y Y Y N
04 L Additional ID 04 00 N Y Y Y
05 L Additional ID 05 00 N Y Y Y
06 L Campus Access 00 Y N N N

If I add an LDAP ID record with the PLIF, what am I supposed to do with this table?
Currently we have two IDs coming in with PLIF: barcode and Banner ID.

Resolution:
The following SQL query shows that you do not actually have any type '06' patron ID's:

abc50@ALEPH19> select unique substr(z308_rec_key,1,2) from z308;
**** Hit return to continue ****

SUBSTR
------
00
01
02

The seven ID types we see in your tab_bor_id.eng, including the "06 Campus Access", are coming from the as-delivered usm50 tab_bor_id.eng. You should delete any ones which you are not using.

Any additional ID types which you load should be included in tab_bor_id.eng:

1. so they have the proper GUI "Type Name",

2. so they display in the GUI Key Type drop-down, and

3. so the system knows how they are to be used.

Please see KB 16384-22225 in regard to the z308_verification and z308_verification_type (relevant to LDAP).

• Article last edited: 10/8/2013