OLSTF tags for import

TI

Title

AMMEND

Amendment note

(Added in SP5)

ASSIGN

User barcode (adds the respective borrowers record number to titles.borrower)

(Added in OLIB 8.1)

ASSIGNID

User number (added straight to titles.borrower)

(Added in OLIB 8.2)

BTC

Binding type key ID

BTD

Binding type long description

CD

Date catalogued (DD-MON-YYYY)

CO

Number of copies

NB – the OLSTF export process uses <COPIES>

DF

e.g. 'DD-MON-YYYY'. For importing, this tag defines the default date format for all date fields in the file. For exporting, it should be included at the top of the file, for example, if you are configuring an OLSTF export format, so that you can include the DF tag in the OLSTF record which will be generated

DIG

Available online

(Added in OLIB 8.1)

DL

The title's general expected date (genexpdate)

DN

The title's general published date (genpubdate)

EBY

Entered by

(Added in OLIB 8.1)

ED

Edition

FMC

Format long key ID

FMD

Format long description

GLDESC1 - GLDESC10

Generic lookup fields (1-10) – description

(Added in OLIB 8.1)

GLKEY1 - GLKEY10

Generic lookup fields (1-10) – key ID

(Added in OLIB 8.1)

HSUM

Holdings summary (replace existing holdings summary)

HSUM+

Holdings summary (append to existing holdings summary)

(Added in OLIB 8.1)

INCDAT

Inclusive dates (replace existing inclusive dates)

(Added in OLIB 8.1)

INCDAT+

Inclusive dates (append to existing inclusive dates)

(Added in OLIB 8.1)

IF

For article records, the issue title record's non-file characters

LM

Last changed date (DD-MON-YYYY)

MBY

Last modified by

(Added in OLIB 8.1)

ME

Media sub-type key ID

MT

Media type key ID

MTLD

Media type long description

NB - both MTLD and MTTP are supported for import, but use MTLD in preference for forward compatibility

MTTP

Media type long description

NB - both MTLD and MTTP are supported for import, but use MTLD in preference for forward compatibility

NF

Non-file characters

OCLCNO

OCLC Record Number

(Added in OLIB 8.1)

OG

Organisation type key ID

OPAC

Include in OPAC (Y or N)

PAGES

Pagination, extent.

PK

The parent title's import record control number (or title number if the import RCN field is blank) if the media type is anything other than SART

PKISN

The parent title's ISxN

NB - both PKISN and PTISN are supported for import, but use PTISN in preference for forward compatibility

POPUP

Check-in pop-up message (replace existing)

POPUP+

Check-in pop-up message (append to existing)

(Added in OLIB 8.1)

PTISN

The parent title record's ISxN

NB - both PKISN and PTISN are supported for import, but use PTISN in preference for forward compatibility

PUBP1

Publication pattern 1 key ID

PUBP2

Publication pattern 2 key ID

RESRC

Record source key ID

RETD

Retention date (DD-MON-YYYY)

RN

Title import record control number

RS

Statement of responsibility (replace existing statement of responsibility)

RS+

Statement of responsibility (append to existing statement of responsibility) (added in OLIB 8.1)

SHST

For article records, the journal title's series status key ID

SIT

The parent title record’s title if the media type is SART, i.e. an article title's parent issue title

SP

Supplier name

SPNF

For article records, the journal title's non-file characters

SPTI

The grandparent title record’s title if the media type is SART, i.e. an article title's journal title

ST

Subtitle

TICAT

Catalogue source description

TIED

End date (DD-MON-YYYY)

TIEXP

The title's expiry date (titles.expdate)

TINT

Notes (replace existing)

NB – this is the TITLES.NOTES field. Notes from the TITLENOTES table are included in the Notes repeatable data block (see below)

TINT+

Notes (append to existing) (added in OLIB 8.1)

NB – this is the TITLES.NOTES field. Notes from the TITLENOTES table are included in the Notes repeatable data block (see below)

TIPD

The title's publication date (titles.pubdate)

TISD

Start date (DD-MON-YYYY)

TISER

Series status key ID

TISRC

Article source

(Added in OLIB 8.1)

TITEM

The title's item number

TITLES

Any field in the titles table that is not catered for by another tag, e.g.

TITLES PERFORM_MED Solo instrument and accompanying ensemble

will import “Solo instrument and accompanying ensemble” into the perform_med field in the titles table

(Added in OLIB 8.1)

TLATP

The title's language code

TN1 - 10

The title's Note 1 – 10 fields (replace existing)

TN[1 – 10]+

The title's Note 1 – 10 fields (append to existing)

(Added in OLIB 8.1)

TNUPD

Title number of the record to update during import

TPBC

The title's publication country code

TREPR

The title's reprint year

TYN1 - TYN10

Yes/No fields (1-10)

VE

The title’s verbal extension field

AA

Author’s address (separate lines with an asterisk)

ADESI

Author designation

ADOB

Date of birth (DD-MON-YYYY)

ADOD

Date of death (DD-MON-YYYY)

AE

Author's email

AF

Forename

AFUNC

Function

AI

Initials

AK

Author record import record control number

ALINK

The link type for the link between this author and the previous author during the import process, e.g.:

TI The Title

AS British Broadcasting Corporation

ATP CORP

ALINK AUUF

AS BBC

ATP CORP

ALINK AUUF

AS Auntie Beeb

ATP CORP

ALINK AUSEA

AS ITV

ATP CORP

*

ALOC

Author's location

AN

Numerals

AN1 – AN10

Author Note 1 – 10 fields

APREF

Preferred author flag

AR

Responsibility type key ID

ARLD

Responsibility type long description

AS

Surname

ASEC

Secondary element

ASPEL

Author spelling

ASUB

Corporate/conference author subordinate unit

AT

Title

ATD

Author's textual dates

ATP

Author type key ID

AUKEY

Author key

(Added in OLIB 8.1)

FS

Filing surname

ID

Identification

MR

Responsibility type key ID for all previous authors of this title

ISNI

International Standard Name Identifier

ORCID

Open Researcher and Contributor ID

VIAF

Virtual International Authority File identifier

XID

External identifier. If this value includes the appropriate ISNI, ORCID or VIAF prefix then it will be imported there. Otherwise it will be imported into RCN

SAN

Authorisation note

(Added in OLIB 8.1)

SCN

Citation note

(Added in OLIB 8.1)

SU

Subject

SUBTP

Subject type key ID

SUBTPD

Subject type long description

SUKEY

Subject key ID

(Added in OLIB 8.1)

SURST

Subject record status key ID

_LOC

Subject’s locality, description

(Added in 8.2)

_SUB

Subject’s subdivision, description

(Added in 8.2)

CL

Classmark

NB - both CL and CM are supported for import, but use CM in preference for forward compatibility

CLD

Classmark description

CM

Classmark

NB - both CL and CM are supported for import, but use CM in preference for forward compatibility

CS

Classmark schema key ID

AD

Publisher's address (lines separated with an asterisk)

PD

Sort publication date (DD-MON-YYYY)

PP

Place of publication

PPKEY

Place of publication key ID

(Added in OLIB 8.1)

PU

Publisher

PUKEY

Publisher key ID

(Added in OLIB 8.1)

SUPST

Publisher's status key ID

SUPTP

Publisher's type key ID

TD

Textual publication date (create new titlepub record)

TD+

Textual publication date (append to existing titlepub record)

(Added in OLIB 8.1)

IS

ISxN

ISTP

ISxN type

INVIS

Invalid ISxN value

ISPR

ISxN price

ISQU

ISxN qualification

AC

Date accessioned (DD-MON-YYYY)

BC

Copy barcode

CC

Copy category key ID

CCD

Date created (DD-MON-YYYY)

CCLD

Copy category description

CHED

Holdings end date

NB - both CHED and CHLDED are supported for import, but use CHLDED in preference for forward compatibility

CHLDED

Holdings end date

NB - both CHED and CHLDED are supported for import, but use CHLDED in preference for forward compatibility

CHLDSD

Holdings start date

NB - both CHSD and CHLDSD are supported for import, but use CHLDSD in preference for forward compatibility

CHLDSUM

Holdings summary

NB - both CHLDSUM and CHSUM are supported for import, but use CHLDSUM in preference for forward compatibility

CHSD

Holdings start date

NB - both CHSD and CHLDSD are supported for import, but use CHLDSD in preference for forward compatibility

CHSUM

Holdings summary

NB - both CHLDSUM and CHSUM are supported for import, but use CHLDSUM in preference for forward compatibility

CN

Notes

CN1 .. CN5

Note 1 .. 5

(Added in SP11)

COLLN

Collection code

(Added in SP12)

COPNO

Copy number

COTD

Textual date

CP

Price

CPTP

Currency key ID

CZ

Copy status

EXST

Extraction status key ID

LL

Location description

NB - both LOLD and LL are supported for import, but use LOLD in preference for forward compatibility

LLUH

Looseleaf update history

LO

Location key ID

LOLD

Location long description

NB - both LOLD and LL are supported for import, but use LOLD in preference for forward compatibility

LS

Loan status

SA

Shelf description

NB - both SA and SCLD are supported for import, but use SCLD in preference for forward compatibility

SC

Shelf key ID

SCLD

Shelf long description

NB - both SA and SCLD are supported for import, but use SCLD in preference for forward compatibility

SLC

Sub-location key ID

(Added in OLIB 8.2)

SLD

Sub-location description

(Added in OLIB 8.2)

SM

Shelfmark

FN

Locator

FSZ

Size

MM

Mime type

OC

Copyright statement

OST

Object status key ID

OT

Object type key ID

OTD

Object type long description

OV

Version

TO

Object title

BIND

Binding details

DIM

Dimensions

DIMN

Dimensions (non-use)

ENR

Enrichment data

ITEMS

Number of items

PAG

Length (add new titlephysical record)

PAG+

Length (append to existing titlephysical record’s Length field)

(Added in OLIB 8.1)

PHC

Physical characteristics

SPENR

Specific enrichment data

TPACC

Accompanying materials

TPADE

Accompanying description

TPFMT

Format

PN

Price in textual format

NB – this tag creates a Title Note record, not a Title Price record. The note type is set to whatever has been defined as the default title price note type

PR

Price

PRTP

Currency key ID

SE

Series title

SEMT

Series media type key ID

SERCN

Series citation note

SERST

Series status key ID

SI

Series ISSN

SK

Series import record control number

SN

Part number (from the textual Vol/No field)

NB - both SN and TSN are supported for import, but use TSN in preference for forward compatibility

STP

Series type key ID

TSN

Part number (from the textual Vol/No field)

NB - both SN and TSN are supported for import, but use TSN in preference for forward compatibility

NEBY

Entered by

(Added in OLIB 8.1)

NED

Date entered

(Added in OLIB 8.1)

NEFI

End film item

(Added in OLIB 8.1)

NEFNO

Start film number

(Added in OLIB 8.1)

NEVNT

Event, Subject

(Added in 8.2)

NFISS

Film item summary statement

(Added in OLIB 8.1)

NFNO

Film number

(Added in OLIB 8.1)

NFY

First Year, YYYY

(Added in 8.2)

NINC

Inclusive Dates, description

(Added in 8.2)

NLEDID

Locality, key

(Added in 8.2)

NLOC

Locality, Subject

(Added in 8.2)

NLI

Last item? (Y/N)

(Added in OLIB 8.1)

NLM

Last changed date

(Added in OLIB 8.1)

NLY

Last Year, YYYY

(Added in 8.2)

NMBY

Last changed by

(Added in OLIB 8.1)

NNUMFI

Number of film items

(Added in OLIB 8.1)

NO

Note

NO2

Note 2

(Added in OLIB 8.1)

NSFI

End film item

(Added in OLIB 8.1)

NSFNO

Start film number

(Added in OLIB 8.1)

NT

Note type key ID

NTD

Note type description

NTI

Title, description

(Added in 8.2)

NVOL

Volume #/Letter, description

(Added in 8.2)

AB and AB \

Abstract

Each line is prefaced by "AB ". If a line is to start a new paragraph, the preceding AB line should end in a backslash. For example, to achieve the following in the abstract:

This is the first line.

This is the second line.

the AB lines should be configured as follows:

AB This is the first line.\

AB This is the second line.

If you want a blank line between paragraphs, include an AB \\ line between each AB line. For example:

AB This is the first line.\

AB \\

AB This is the second line.

will import as:

This is the first line.

This is the second line.

To indent a paragraph, include \ and the required number of spaces at the start of the AB line. For example:

AB \ This is the first paragraph, the first line of which is indented by 4 spaces. The paragraph itself is long enough that it wraps to a second and subsequent lines so that you can clearly see the first line indent.\

AB \\

AB \ This is the second paragraph. Its first line is also indented by 4 spaces, and it too is sufficiently long that it wraps to a second line.

will import as:

This is the first paragraph, the first line of which is indented by 4 spaces. The paragraph itself is long enough that it wraps to a second and subsequent lines so that you can clearly see the first line indent.

This is the second paragraph. Its first line is also indented by 4 spaces, and it too is sufficiently long that it wraps to a second line.

XC

Title control number

XS

Title control number type key ID

KI

The cross-referenced title's ISxN

KT

The import RCN or, if this is null, the title number from the cross-referenced title

KX

The cross-referenced title's title control number

LT

Link type key ID

XT

Cross-referenced title

ALTTI

Alternative title

TT

Alternative title type key ID

TTFI

Alternative title's first indicator

TTLD

Alternative title type long description

LA

Language description

LATP

Language key ID

TIRAF

RAPID field name

TIRAV

RAPID field value

BAR

Barcode

ALTBAR

Alternative barcode

B-NOTES

Notes

B-NOTE1 - 10

User note 1 – 10

B-NOTES1 - 10

User note 1 – 10

(Added in SP13)

B-XXXXX

Any column in the borrowers table not covered by the standard tags, with some restrictions for data which requires special handling

CAT

User category

CIRCBAN

Banned from circulation (Y or N)

COSTC

Cost centre

DIST(+)

District

DOB or UDOB

Date of birth

EXP

Membership expiry date

FORE

Forename

GNAME

Group name (group record)

GROUP

Group name (group membership record)

GRSEC

Group seccode (group membership record)

IDENT or UIDENT

User's Identification field

INIT

Initials

INST(+)

Institution

JOIN

Join date

LASTACTIVE

Last active date

LASTCHANGE

Last changed date

LOC

Location

MAIL

Email address

MAXLOAN

Maximum loans

MAXREN

Maximum renewals

MAXRES

Maximum reservations

OCCUP(+)

Occupation

OWNSEC

Group owner’s seccode (group record)

PASS

Password (plain text)

PAYDATE

Pay date

PRESIGN

Presigned copyright declaration Yes/No

ROOMNO

Room number

SEC

Secondary Code

SELFREG

Self-registered (Y or N)

SEX

Gender (M or F)

SUR

Surname

TELHOME

The user’s home telephone number (to the borrowers record)

TELMOB

The user’s mobile telephone number (to the borrowers record, for SMS alerts)

TELWORK

The user’s work telephone number (to the borrowers record)

TEMP

Temporary (Y or N)

TIU

Title (Mr, Mrs, Miss, etc.)

TP(+)

User type

ADTP

Address Type (changed from ATP in OLIB 8.0. ATP continues to be supported for import, but use ADTP in preference for forward compatibility

ADREE

Addressee

HOUSE

House Name

STR

Street

PO

PO Box

DST

District

CITY

City

REG

Region

CNTRY

Country

PC

Post Code

EMAIL

Email Address

TELCOUNTRY

TELAREA

TELNUMBER

TELEXTEND

Telephone Number

FAXCOUNTRY

FAXAREA

FAX

FAXEXTEND

Fax Number

FTP

ftp address

NOTE

Note

END

End Date

START

Start Date

DELETE

For removing links to departments

DEPT(+)

User's department key ID
When suffixed with "+", the data should specify both the key ID and the description, separated by two or more consecutive spaces.

DEPTD(+)

User's department long description
When suffixed with "+", and the description does not match an existing record, the key ID will be generated as a number.

DELETE

For removing links to courses

COURSE(+)

User's course key ID.
When suffixed with "+", the data should specify both the key ID and the description, separated by two or more consecutive spaces.

COURSED(+)

User's course long description
When suffixed with "+", and the description does not match an existing record, the key ID will be generated as a number.

DELETE

For removing links to objects

OBJECT(+)

Object type and locator for the object to attach to the user

The value should be specified in several parts, for example: T - for textual (as opposed to file) location information

A space

WWW - The key value for the Object Type to be assigned to the Object created

Two spaces

http://students.ourcollege.ac.uk/......dent-78485.jpg - the URL for the image

SEC

Group identifier

FLD

Name of RAPID field to add/update

VAL

RAPID field value to insert or set

SU

Subject

CD

Date catalogued

(Added in OLIB 8.2)

LA

Language description

LATP

Language key ID

(Added in OLIB 8.2)

LCD

Last changed date

(Added in OLIB 8.2)

NF

Non-filing characters

(Added in OLIB 8.2)

NO

Notes

(Added in OLIB 8.2)

PAR

Parent subject description

(Added in OLIB 8.2)

PARTP

Parent subject type key ID

(Added in OLIB 8.2)

PARLANGTP

Parent subject language key ID

(Added in OLIB 8.2)

RN

Import RCN

(Added in OLIB 8.2)

SAN

Authority Note

SCN

Citation Note

SCOPE

Scope Note

SRECSRCLD

Subject record source description

(Added in OLIB 8.2)

SUBTP

Subject type

XRSU

Cross-referenced subject

LT

Cross-reference link type key ID

XRPR

Preferred (Y or N) – should be included if the LT is a US link (i.e. “the subject I am linking to is the preferred term for this term”)

Redundant in 9.0. The link type now determines whether it is a preferred or non-preferred term

XRSLATP

Cross-referenced subject language key ID

(Added in OLIB 8.2)

XRSTP

Cross-referenced subject type

CL

Classmark

CLD

Classmark description

(Added in OLIB 8.2)

CS

Classmark type key ID

ORDCURR

Currency

For EDI Quotes imports, the currency defaults from the default currency for the supplier and location specified in the Import Batch record

ORDDELM

Delivery Method

A delivery method key ID must be supplied. Defaults to the default delivery method for the supplier and location specified in the Import Batch record if it is not supplied in the incoming record

ORDLOC

Order Location

Location key ID

ORDNOTES

Order Notes

ORDORDDATE

Order Date

Defaults to the system date if it is not supplied in the incoming record

ORDORDERREF

Order Reference

Defaults to the system-generated order number if it is not supplied in the incoming record

ORDSTATUS

Order Status

PRE, AUTH or OUT. For EDI Quotes imports, the status defaults from the Import Batch record

ORDSUPP

Supplier

For EDI Quotes imports, the supplier defaults from the Import Batch record

ORDSUPPREF

Supplier Reference

Defaults to the default supplier reference for the supplier and location specified in the Import Batch record if it is not supplied in the incoming record

OICCAT

Order Item Default Copy Category

Location key ID

OICLOC

Order Item Default Copy Location

Location key ID

OIDELPER

Delivery Period

Defaults to the default delivery period for the supplier and location in the import record if it is not supplied in the incoming record

OIDUEDATE

Expected Date of Receipt

If not supplied in the incoming record, it is calculated automatically based on the order item’s delivery period

OIINOTES

Internal Note

OIITEMPRICE

Item Price

OIOLOC

Order Item Location

Location key ID

OIORD

Number Ordered

OIPAYAC

Payment Account

Must match an existing account number in the OLIB system into which the record is being imported, and that account must have an active account instance for the current financial period. If suitable account instance is not found, or if the OIPAYAC tag is not supplied in the incoming record, the payment account defaults to the default account for the supplier and location specified in the Import Batch record

OISUBSSTART

Subscription Start Date

For serial subscription orders

OISUBSFINISH

Subscription End Date

For serial subscription orders

OISUPPREF

Supplier Reference

Defaults to the order’s supplier reference if it is not supplied in the incoming record

OITITLENO

Title Number

Currently, the Orders OLSTF import process will only accept Orders OLSTF records containing an OITITLENO tag with the title number of the record in OLIB that an order is being raised for. (It will subsequently be extended to allow for a title, ISBN etc. to be supplied in the incoming record, and for these to be used either to match on an existing title record in OLIB or to create a new one)

OITYPE

Order Item Type

CAT, SERI or NONC. If it is not supplied in the incoming record, it defaults to the relevant value depending on the media type of the title being ordered

OIXNOTES

External Note