Doorgaan naar de website
OCLC Support

OLSTF tags for export/output

Find OLIB Standard Transfer Format (OLSTF) tags for export.

General Tags

Tag

Description

#H#…#/H#

Header - include whatever text is included between the #H#…#/H# tag set on the first line of the file that is created by the export

#F#…#/F#

Footer - include whatever text is included between the #F#…#/F# tag set on the last line of the file that is created by the export

#SYSDATE#...#/SYSDATE#

Insert the current date and/or time in the format specified by the Oracle date format code included between the hash tags. For example, #SYSDATE#dd/mm/yyyy#/SYSDATE# will insert the current date, e.g. 29/10/2016

#B#

Include a blank line in the text file, e.g. between records

<DF>

e.g. 'DD-MON-YYYY'. When exporting OLSTF records, the DF tag should be included at the top of the file to specify the date format used for all the records in the file

#NULLxxx#...#/xxxNULL#

Any tag can be surrounded by the #NULLxxx#...#/xxxNULL# hash tag (where xxx is the tag itself) to indicate that whatever is included between the start hash tag and the end hash tag should be output if the field is empty. For example, #NULLPP#No place of publication#/PPNULL# will cause “No place of publication” to be included in the output if the Place of Publication field (the PP tag) is empty.

Titles

Tag

Description


Non-Repeatable Tags
(Note: all non-repeatable tags have corresponding "not null" hash tag sets, e.g. #STNN#…#/STNN#)

<TI>

Title

<ACN>

Additional conditions key ID (titles.addcon)

(Added in SP9)

<ACNLD>

Additional conditions long description

(Added in SP9)

<AMMEND>

Amendment note (titles.ammend)

(Added in SP5)

<ARTCIT>

A single field that is a concatenation of parent information for this title, if the title has a parent. For titles that do not have a parent, refer to the <TISRC> tag.

For serial article records, this will be the journal title, issue title, the article record’s Article Source field and the article record’s Pagination field. The Bound Volume information will not be included.

<BNOTES>

Binding notes

(Added in OLIB 9.0)

<BTC>

Binding type key ID

<BTD>

Binding type long description

<BTSD>

Binding type short description

(Added in OLIB 9.0)

<CD>

Date catalogued (DD-MON-YYYY)

<COPIES>

Number of copies

NB – the OLSTF import process uses the <CO> tag

<DEL*>

* (only present if the title record’s mxxi_rec_status is set to d)

(Added in SP5)

<DIG>

Available online

(Added in OLIB 8.1)

<DN>

The title's general published date (genpubdate)

<EBY>

The user who entered the record – [Sname], [Fname]

<ED>

Edition

<FMC>

Format key ID

<FMD>

Format long description

<GED>

Gen. exp. date (DD-MON-YYYY)

<GED_BDDS>

Gen. exp. date (YYYY-MM-DD). Specific to the Datasets XML output, for NRW and anyone else who needs to export records to GEMINI or MEDIN XML. Hard-coded as YYYY-MM-DD, irrespective of whether a DF has been supplied, as this is stipulated by the GEMINI and MEDIN standards

(Added in OLIB 9.0)

<GLKEY1> - <GLKEY30>

General Lookup 1 – 30 key ID

(Added in OLIB 8.1)

<GLDESC1> - <GLDESC30>

General Lookup 1 – 30 description

(Added in OLIB 8.1)

<HSUM>

Holdings summary.

HSUM+ can be used as a repeatable tag during import to append to previous content of this field.

<IF>

(Article records only) The parent title record's non-file characters

<INCDAT>

Inclusive dates

INCDAT+ can be used as a repeatable tag during import to append to previous content of this field.

<LM>

Last changed date (DD-MON-YYYY)

<LM_BDDS>

Last changed date. Specific to the Datasets XML output, for NRW and anyone else who needs to export records to GEMINI or MEDIN XML. Hard-coded as YYYY-MM-DD, irrespective of whether a DF has been supplied, as this is stipulated by the GEMINI and MEDIN standards

(Added in OLIB 9.0)

<LRI>

(Serial records only) Latest received issue (but only if the issue record’s COPIES field is > 0)

<LXC_BDDS>

Lower X co-ordinate (taken from the titlecartcodes record with a title cart. Code type of LXCD). Specific to the Datasets XML output, for NRW and anyone else who needs to export records to GEMINI or MEDIN XML

(Added quite a while ago, but only just included in the tag list in SP9)

<MARCTI>

The title in MARC tag 245 format

(Added in OLIB 9.0)

<MBY>

The user who last modified the record – [Sname], [Fname]

<ME>

Media sub-type key ID

<MELD>

Media sub-type long description

(Added in SP6)

<MT>

Media type key ID

<MTLD>

Media type long description

<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) (Defaults to Y if the field is blank in the database)

<OSGRIDREF>

OS Grid Reference (a concatenation of the os_sheet, os_easting and os_northing fields in the title record)

(Added in SP8)

<PAGES>

Pagination, extent

<PCM>

Primary Classmark

(Added in SP12)

<PFN>

The parent title record’s 1st object’s object locator

<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

<PK6X>

Parent Title Number (Hex 6-Char)

(Added in SP13)

<PMTLD>

The parent title record’s media type long description (for titles other than articles)

<PSD>

Dates of publication and/or sequential designation

<PSUBTI>

The parent title record’s subtitle (for titles other than articles)

<PTI>

The parent title record’s title (for titles other than articles)

<PTISN>

The parent title record's ISxN (for titles other than articles). If the parent title record has more than one ISxN, the ISxN record with the lowest isnno (i.e. the ISxN that was entered first) will be used for the PTISN tag

<PUBP1>

Publication pattern 1 key ID

<PUBP2>

Publication pattern 2 key ID

<RECST*>

* (only present if the title record’s status is anything other than AUT or UNAUT)

<RECSTLD>

Record status long description

<RESRC>

Record source key ID

<RESRCLD>

Record source long description

<RETD>

Retention date (DD-MON-YYYY)

<RN>

Title import record control number

<RS>

Statement of responsibility

RS+ can be used as a repeatable tag during import to append to previous content of this field.

<SHST>

(Article records only) The grandparent (i.e. journal) title's series status key ID

<SISN>

(Article records only) The grandparent (i.e. journal) title record's 1st ISxN

<SIT>

(Article records only) The parent (i.e. issue) title record’s title

<SP>

Supplier name

<SPFN>

(Article records only) The grandparent (i.e. journal) title record’s object locator

<SPNF>

(Article records only) The grandparent (i.e. journal) title's non-file characters

<SPTI>

(Article records only) The grandparent (i.e. journal) title record’s title

<ST>

Subtitle

<TALLOC>

Owner/Allocated To

<TAUTHS>

A single, non-repeatable field that is a concatenation of all the authors, separated by semi-colons (titlecrosstabview.authors)

Note: The data in the <TAUTHS> tag is taken from a special table in the OLIB database called a "materialized view". Materialized views are updated in daystart, not in real time. Thus, for example, when you link a new author to a title record, that author will not be included in the TAUTHS tag until daystart is next run. Typically, this will mean that it will not be included until the day after you link it to the title

<TFR>

Frequency key ID

(Added in OLIB 9.0)

<TFRLD>

Frequency long description

(Added in OLIB 9.0)

<THARVARD>

The complete title record in Harvard citation format. Uses the Titles_HarvardDisplay.GetHarvardDisplay function

(Added in SP9)

<TICAT>

Catalogue source description (titles..cat_src)

<TIED>

End date (DD-MON-YYYY)

<TIED_BDDS>

End date (YYYY-MM-DD). Specific to the Datasets XML output, for NRW and anyone else who needs to export records to GEMINI or MEDIN XML. Hard-coded as YYYY-MM-DD, irrespective of whether a DF has been supplied, as this is stipulated by the GEMINI and MEDIN standards

(Added in OLIB 9.0)

<TIEDREM>

Edition remainder note

(Added in OLIB 9.0)

<TIEXP>

The title's expiry date (titles.expdate)

<TINT>

Notes

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)

<TIPD1>

A single, non-repeatable field that contains the publication date from the first titlepub record (nvl(titlepub.tdate, to_char(titlepub.pubdate, 'DD-MON-YYYY')) where titlepub.repeat_seq = 1 )

<TIPD2>

A single, non-repeatable field that contains the 2nd publication date from the first titlepub record (nvl(titlepub.tdate, to_char(titlepub.pubdate, 'DD-MON-YYYY')) where titlepub.repeat_seq = 1 )

(Added in OLIB 9.0)

<TIPP1>

The first place of publication (place long description)

(Added in OLIB 8.1)

<TIPU1>

The first publisher (publisher name)

<TISD>

Start date (DD-MON-YYYY)

<TISD_BDDS>

Start date (YYYY-MM-DD). Specific to the Datasets XML output, for NRW and anyone else who needs to export records to GEMINI or MEDIN XML. Hard-coded as YYYY-MM-DD, irrespective of whether a DF has been supplied, as this is stipulated by the GEMINI and MEDIN standards

(Added in OLIB 9.0)

<TISER>

Series status key ID

<TISRC>

Article source

<TITEM>

The title's item number

<TN>

Title number

<TN1> - <TN30>

The title's Note 1 – Note 30 fields

Each can be specified with a + (e.g. TN4+ ..) during import to append to the previous value of this field

<TN6X>

Title number left-padded to 6 digits. Specific to the Datasets XML output, for NRW and anyone else who needs to export records to GEMINI or MEDIN XML

(Added in OLIB 9.0, but no longer used by NRW)

<TREPR>

The title's reprint year

<TSERST>

Title series status key ID (titles.serst)

(Added in SP9)

<TSERSTLD>

Title series status long description

(Added in SP9)

<TYN1> - <TYN20>

The title's Yes/No 1 – Ys/No 20 fields

(Added in SP9)

<UYC_BDDS>

Upper Y co-ordinate (taken from the titlecartcodes record with a title cart. code type of UYCD). Specific to the Datasets XML output, for NRW and anyone else who needs to export records to GEMINI or MEDIN XML

(Added quite a while ago, but only just included in the tag list in SP9)


Repeatable Data Blocks


Authors

#AUNN#…#/AUNN#

Only include whatever is between the not null authors hash tag set if there is at least one author linked to the title.

#AU#…#/AU#

Include whatever is between the authors hash tag set for each author not already covered by the #A1#…#/A1#, #A2#…#/A2#, #A3#…#/A3# and #AL#…#/AL# hash tag sets

#A1#…#/A1#

Include whatever is between the first authors hash tag set for the first author

#A2#…#/A2#

Include whatever is between the second authors hash tag set for the second author

#A3#…#/A3#

Include whatever is between the third authors hash tag set for the third author

#AL#…#/AL#

Include whatever is between the last authors hash tag set for the last author if it has not already covered by the #A1#…#/A1#, #A2#…#/A2# and #A3#…#/A3# hash tag sets

<ADOB>

Date of birth (DD-MON-YYYY)

<ADOD>

Date of death (DD-MON-YYYY)

<AF>

Forename

<AFUNC>

Function

<AI>

Initials

<AN>

Numerals

<AN1> .. <AN10>

Notes 1 .. 10

<AR>

Responsibility type key ID

<MR> can be used during import to assign the responsibility type to this and all preceding authors linked to the title

<ARLD>

Responsibility type long description

<AS>

Surname

<ASUB>

Corporate/conference author subordinate unit

<AT>

Title

<ATD>

Author's textual dates

<ATP>

Author type key ID

<FS>

Filing surname

<ID>

Identification

<ISNI>

International Standard Name Identifier

(Added in SP12)

<ORCID>

Open Researcher and Contributor ID

(Added in SP12)

<VIAF>

Virtual International Authority File identifier

(Added in SP12)


Publishers

#PUNN#…#/PUNN#

Only include whatever is between the not null publishers hash tag set if there is at least one titlepub record linked to the title.

#PU#…#/PU#

Include whatever is between the publishers hash tag set for each titlepub record not already covered by the #P1#…#/P1#, #P2#…#/P2#, #P3#…#/P3# and #PL#…#/PL# hash tag sets

#P1#…#/P1#

Include whatever is between the first publishers hash tag set for the first titlepub record

#P2#…#/P2#

Include whatever is between the second publishers hash tag set for the second titlepub record

#P3#…#/P3#

Include whatever is between the third publishers hash tag set for the third titlepub record

#PL#…#/PL#

Include whatever is between the last publishers hash tag set for the last titlepub record if it has not already covered by the #P1#…#/P1#, #P2#…#/P2# and #P3#…#/P3# hash tag sets

<PD>

Sort publication date (DD-MON-YYYY)

<TD> Free text publication date

<PP>

Place of publication

<PU>

Publisher

<TIPU1> The publisher from the first publication record for this title
<TIPP1> The place of publication from the first publication record for this title
<TIPD1> The free text date from the first publication record for this title. If not set, this will export the second (or third) free text date from this same record. If none of those are set, this will export the sort date in the format DD-MON-YYYY
<TIPD2> The second free text publication date from the first publication record for this title
   

Price details

#PRNN#…#/PRNN#

Only include whatever is between the not null price details hash tag set if there is at least one price details record linked to the title.

#PR#…#/PR#

Include whatever is between the price details hash tag set for each price details record not already covered by the #R1#…#/R1#, #R2#…#/R2#, #R3#…#/R3# and #RL#…#/RL# hash tag sets

#R1#…#/R1#

Include whatever is between the first price details hash tag set for the first price details record

#R2#…#/R2#

Include whatever is between the second price details hash tag set for the second price details record

#R3#…#/R3#

Include whatever is between the third price details hash tag set for the third price details record

#RL#…#/RL#

Include whatever is between the last price details hash tag set for the last price details record if it has not already covered by the #R1#…#/R1#, #R2#…#/R2# and #R3#…#/R3# hash tag sets

<PN>

Price in textual format

<PR>

Price (numeric)

<PRTP>

Currency key ID

<PRTPD>

Currency long description


Series

#SENN#…#/SENN#

Only include whatever is between the not null series hash tag set if there is at least one series record linked to the title.

#SE#…#/SE#

Include whatever is between the series hash tag set for each series record not already covered by the #E1#…#/E1#, #E2#…#/E2#, #E3#…#/E3# and #EL#…#/EL# hash tag sets

#E1#…#/E1#

Include whatever is between the first series hash tag set for the first series record

#E2#…#/E2#

Include whatever is between the second series hash tag set for the second series record

#E3#…#/E3#

Include whatever is between the third series hash tag set for the third series record

#EL#…#/EL#

Include whatever is between the last series hash tag set for the last series record if it has not already covered by the #E1#…#/E1#, #E2#…#/E2# and #E3#…#/E3# hash tag sets

<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

<STP>

Series type key ID

<STPLD>

Series type long description

<TSN>

Part number (from the textual Vol/No field)


Notes

#NONN#…#/NONN#

Only include whatever is between the not null notes hash tag set if there is at least one title notes record linked to the title.

#NO#…#/NO#

Include whatever is between the notes hash tag set for each title notes record not already covered by the #N1#…#/N1#, #N2#…#/N2#, #N3#…#/N3# and #NL#…#/NL# hash tag sets

#N1#…#/N1#

Include whatever is between the first notes hash tag set for the first title notes record

#N2#…#/N2#

Include whatever is between the second notes hash tag set for the second title notes record

#N3#…#/N3#

Include whatever is between the third notes hash tag set for the third title notes record

#NL#…#/NL#

Include whatever is between the last notes hash tag set for the last title notes record if it has not already covered by the #N1#…#/N1#, #N2#…#/N2# and #N3#…#/N3# hash tag sets

<NO>

Note

<NT>

Note type key ID

<NTD>

Note type description


Subjects

#SUNN#…#/SUNN#

Only include whatever is between the not null subjects hash tag set if there is at least one subject linked to the title.

#SU#…#/SU#

Include whatever is between the subjects hash tag set for each subject not already covered by the #S1#…#/S1#, #S2#…#/S2#, #S3#…#/S3# and #SL#…#/SL# hash tag sets

#S1#…#/S1#

Include whatever is between the first subjects hash tag set for the first subject

#S2#…#/S2#

Include whatever is between the second subjects hash tag set for the second subject

#S3#…#/S3#

Include whatever is between the third subjects hash tag set for the third subject

#SL#…#/SL#

Include whatever is between the last subjects hash tag set for the last subject if it has not already covered by the #S1#…#/S1#, #S2#…#/S2# and #S3#…#/S3# hash tag sets

<SU>

Subject

<SUBTP>

Subject type key ID

<SUBTPD>

Subject type long description

<SURST>

Subject record status key ID


Subjects (subject type-specific)


(replace XXXXX with the subject type)

#SUXXXXXNN#…#/SUXXXXXNN#

Only include whatever is between the not null subjects hash tag set if there is at least one subject linked to the title with the specified subject type

#SUXXXXX#…#/SUXXXXX#

Include whatever is between the subjects hash tag set for each subject with the specified subject type not already covered by the #SXXXXX1#…#/SXXXXX1#, #SXXXXX2#…#/SXXXXX2#, #SXXXXX3#…#/SXXXXX3# and #SXXXXXL#…#/SXXXXXL# hash tag sets

#SXXXXX1#…#/SXXXXX1#

Include whatever is between the first subjects hash tag set for the first subject with the specified subject type

#SXXXXX2#…#/SXXXXX2#

Include whatever is between the second subjects hash tag set for the second subject with the specified subject type

#SXXXXX3#…#/SXXXXX3#

Include whatever is between the third subjects hash tag set for the third subject with the specified subject type

#SXXXXXL#…#/SXXXXXL#

Include whatever is between the last subjects hash tag set for the last subject with the specified subject type if it has not already covered by the #SXXXXX1#…#/SXXXXX1#, #SXXXXX2#…#/SXXXXX2# and #SXXXXX3#…#/SXXXXX3# hash tag sets

<SU;XXXXX>

Subject


Classmarks

#CMNN#…#/CMNN#

Only include whatever is between the not null classmarks hash tag set if there is at least one classmark linked to the title.

#CM#…#/CM#

Include whatever is between the classmarks hash tag set for each classmark not already covered by the #L1#…#/L1#, #L2#…#/L2#, #L3#…#/L3# and #LL#…#/LL# hash tag sets

#L1#…#/L1#

Include whatever is between the first classmarks hash tag set for the first classmark

#L2#…#/L2#

Include whatever is between the second classmarks hash tag set for the second classmark

#L3#…#/L3#

Include whatever is between the third classmarks hash tag set for the third classmark

#LL#…#/LL#

Include whatever is between the last classmarks hash tag set for the last classmark if it has not already covered by the #L1#…#/L1#, #L2#…#/L2# and #L3#…#/L3# hash tag sets

<CLD>

Classmark schema long description

(Added in SP9)

<CM>

Classmark

<CMD>

Classmark description

(Added in SP13)

<CS>

Classmark schema key ID


Classmarks (classmark type-specific)


(replace XXXXX with the classmark type)

(Added in OLIB 9.0)

#CMXXXXXNN#…#/CMXXXXXNN#

Only include whatever is between the not null classmark hash tag set if there is at least one classmark linked to the title with the specified classmark type

#CMXXXXX#…#/CMXXXXX#

Include whatever is between the classmark hash tag set for each classmark with the specified classmark type not already covered by the #LXXXXX1#…#/LXXXXX1#, #LXXXXX2#…#/LXXXXX2#, #LXXXXX3#…#/LXXXXX3# and #LXXXXXL#…#/LXXXXXL# hash tag sets

#LXXXXX1#…#/LXXXXX1#

Include whatever is between the first classmark hash tag set for the first classmark with the specified classmark type

#LXXXXX2#…#/LXXXXX2#

Include whatever is between the second classmark hash tag set for the second classmark with the specified classmark type

#LXXXXX3#…#/LXXXXX3#

Include whatever is between the third classmark hash tag set for the third classmark with the specified classmark type

#LXXXXXL#…#/LXXXXXL#

Include whatever is between the last classmark hash tag set for the last classmark with the specified classmark type if it has not already covered by the #LXXXXX1#…#/LXXXXX1#, #LXXXXX2#…#/LXXXXX2# and #LXXXXX3#…#/LXXXXX3# hash tag sets

<CM;XXXXX>

Classmark

<CMD;XXXXX>

Classmark description

(Added in SP13)


Title control numbers

#XCNN#…#/XCNN#

Only include whatever is between the not null title control numbers hash tag set if there is at least one title control number record linked to the title.

#XC#…#/XC#

Include whatever is between the title control numbers hash tag set for each title control number record not already covered by the #Y1#…#/Y1#, #Y2#…#/Y2#, #Y3#…#/Y3# and #YL#…#/YL# hash tag sets

#Y1#…#/Y1#

Include whatever is between the first title control numbers hash tag set for the first title control number record

#Y2#…#/Y2#

Include whatever is between the second title control numbers hash tag set for the second title control number record

#Y3#…#/Y3#

Include whatever is between the third title control numbers hash tag set for the third title control number record

#YL#…#/YL#

Include whatever is between the last title control numbers hash tag set for the last title control number record if it has not already covered by the #Y1#…#/Y1#, #Y2#…#/Y2# and #Y3#…#/Y3# hash tag sets

<XC>

Title control number

<XS>

Title control number type key ID


Copies

#CONN#…#/CONN#

Only include whatever is between the not null copies hash tag set if there is at least one copies record linked to the title.

#CO#…#/CO#

Include whatever is between the copies hash tag set for each copies record not already covered by the #C1#…#/C1#, #C2#…#/C2#, #C3#…#/C3# and #CL#…#/CL# hash tag sets

#C1#…#/C1#

Include whatever is between the first copies hash tag set for the first copies record

#C2#…#/C2#

Include whatever is between the second copies hash tag set for the second copies record

#C3#…#/C3#

Include whatever is between the third copies hash tag set for the third copies record

#CL#…#/CL#

Include whatever is between the last copies hash tag set for the last copies record if it has not already covered by the #C1#…#/C1#, #C2#…#/C2# and #C3#…#/C3# hash tag sets

<AC>

Date accessioned (DD-MON-YYYY)

<BC>

Copy barcode

<CC>

Copy category key ID

<CCD>

Date created (DD-MON-YYYY)

<CCLD>

Copy category long description

<CHLDED>

Holdings end date

<CHLDSD>

Holdings start date

<CHLDSUM>

Holdings summary

<CN>

Notes

<CN1> .. <CN5>

Note 1 .. 5

(Added in SP11)

<COLLN>

Collection code

(Added in SP12)

<CP>

Price

<CPTP>

Currency key ID

<CSUMM>

Copy summary:

decode(c.withdraw, 'Y', 'Withdrawn: ', '') ||

c.shelfmark || chr(9) || g.description ||

chr(9) || s.shelfsd || chr(9) || l.locsd ||

chr(9) || cs.copystsd || chr(9) ||

c.hd_storage

from copies c, copysts cs, locs l,

shelves s, geo_collections g

where s.shelf(+) = c.shelf

and c.copyst = cs.copyst

and c.loc = l.loc

and c.geo_collection = g.collection(+)

<CZ>

Copy status

<CZD>

Copy status long description

<EXST>

Extraction status key ID

<LO>

Location key ID

<LOLD>

Location long description (export only)

<LS>

Loan status

<LSD>

Loan status long description (export only)

<RETDATE>

Return date

<SA>

Shelf description (import only)

<SC>

Shelf key ID

<SCLD>

Shelf long description

<SLC>

Sub-location key ID

(Added in OLIB 8.2)

<SLD>

Sub-location long description

(Added in OLIB 8.2)

<SM>

Shelfmark


Cross-referenced titles

#XTNN#…#/XTNN#

Only include whatever is between the not null xref titles hash tag set if there is at least one cross-referenced title record linked to the title.

#XT#…#/XT#

Include whatever is between the xref titles hash tag set for each cross-referenced title record not already covered by the #X1#…#/X1#, #X2#…#/X2#, #X3#…#/X3# and #XL#…#/XL# hash tag sets

#X1#…#/X1#

Include whatever is between the first xref titles hash tag set for the first cross-referenced title record

#X2#…#/X2#

Include whatever is between the second xref titles hash tag set for the second cross-referenced title record

#X3#…#/X3#

Include whatever is between the third xref titles hash tag set for the third cross-referenced title record

#XL#…#/XL#

Include whatever is between the last xref titles hash tag set for the last cross-referenced title record if it has not already covered by the #X1#…#/X1#, #X2#…#/X2# and #X3#…#/X3# hash tag sets

<KT>

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

<LT>

Link type key ID

<LTLD>

Link type long description

<XHARV>

The cross-referenced title record in Harvard citation format. Uses the Titles_HarvardDisplay.GetHarvardDisplay function

(Added in SP9)

<XNOTE>

Cross-referenced title note

<XT>

Cross-referenced title


Alternative titles

#ATNN#…#/ATNN#

Only include whatever is between the not null alternative titles hash tag set if there is at least one alternative title record linked to the title.

#AT#…#/AT#

Include whatever is between the alternative titles hash tag set for each alternative title record not already covered by the #T1#…#/T1#, #T2#…#/T2#, #T3#…#/T3# and #TL#…#/TL# hash tag sets

#T1#…#/T1#

Include whatever is between the first alternative titles hash tag set for the first alternative title record

#T2#…#/T2#

Include whatever is between the second alternative titles hash tag set for the second alternative title record

#T3#…#/T3#

Include whatever is between the third alternative titles hash tag set for the third alternative title record

#TL#…#/TL#

Include whatever is between the last alternative titles hash tag set for the last alternative title record if it has not already covered by the #T1#…#/T1#, #T2#…#/T2# and #T3#…#/T3# hash tag sets

<ALTTI>

Alternative title

<TT>

Alternative title type key ID

<TTFI>

Alternative title's first indicator

<TTLD>

Alternative title type long description


ISxNs

#ISNN#…#/ISNN#

Only include whatever is between the not null ISxNs hash tag set if there is at least one titleisns record linked to the title.

#IS#…#/IS#

Include whatever is between the ISxNs hash tag set for each titleisns record not already covered by the #I1#…#/I1#, #I2#…#/I2#, #I3#…#/I3# and #IL#…#/IL# hash tag sets

#I1#…#/I1#

Include whatever is between the first ISxNs hash tag set for the first titleisns record

#I2#…#/I2#

Include whatever is between the second ISxNs hash tag set for the second titleisns record

#I3#…#/I3#

Include whatever is between the third ISxNs hash tag set for the third titleisns record

#IL#…#/IL#

Include whatever is between the last ISxNs hash tag set for the last titleisns record if it has not already covered by the #I1#…#/I1#, #I2#…#/I2# and #I3#…#/I3# hash tag sets

<IS>

ISxN

<ISTP>

ISxN type


Attached objects

#OBNN#…#/OBNN#

Only include whatever is between the not null objects hash tag set if there is at least one object linked to the title.

#OB#…#/OB#

Include whatever is between the objects hash tag set for each object not already covered by the #O1#…#/O1#, #O2#…#/O2#, #O3#…#/O3# and #OL#…#/OL# hash tag sets

#O1#…#/O1#

Include whatever is between the first objects hash tag set for the first object

#O2#…#/O2#

Include whatever is between the second objects hash tag set for the second object

#O3#…#/O3#

Include whatever is between the third objects hash tag set for the third object

#OL#…#/OL#

Include whatever is between the last objects hash tag set for the last object if it has not already covered by the #O1#…#/O1#, #O2#…#/O2# and #O3#…#/O3# hash tag sets

<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


Physical details

#PHNN#…#/PHNN#

Only include whatever is between the not null physical details hash tag set if there is at least one physical details record linked to the title.

#PH#…#/PH#

Include whatever is between the physical details hash tag set for each physical details record not already covered by the #F1#…#/F1#, #F2#…#/F2#, #F3#…#/F3# and #FL#…#/FL# hash tag sets

#F1#…#/F1#

Include whatever is between the first physical details hash tag set for the first physical details record

#F2#…#/F2#

Include whatever is between the second physical details hash tag set for the second physical details record

#F3#…#/F3#

Include whatever is between the third physical details hash tag set for the third physical details record

#FL#…#/FL#

Include whatever is between the last physical details hash tag set for the last physical details record if it has not already covered by the #F1#…#/F1#, #F2#…#/F2# and #F3#…#/F3# hash tag sets

<BIND>

Binding details

<DIM>

Dimensions

<DIMN>

Dimensions (non-use)

<ENR>

Enrichment data

<FULLPHYS>

Full physical details:

decode(no_items, NULL, NULL, no_items||'; ')||

decode(materialtp, NULL, NULL, materialtp||'; ')||

decode(trade_names, NULL, NULL, trade_names||'; ')||

decode(length, NULL, NULL, length||'; ')||

decode(physical_chars, NULL, NULL, physical_chars||'; ')||

decode(enrich, NULL, NULL, enrich||'; ')||

decode(specific_enrich, NULL, NULL,

specific_enrich||'; ')||

decode(special_char, NULL, NULL, special_char||'; ')||

decode(dim_non_use, NULL, NULL, dim_non_use||'; ')||

decode(weight, NULL, NULL, weight||'; ')||

decode(dim_use, NULL, NULL, dim_use||'; ')||

decode(format, NULL, NULL, format||'; ')||

decode(acc_material, NULL, NULL, acc_material||'; ')||

decode(acc_desc, NULL, NULL, acc_desc||'; ')||

decode(binding, NULL, NULL,

binding||'; ')

from titlephysical

<ITEMS>

Number of items

<PAG>

Length

PAG+ can be used as a repeatable tag during import to append to previous content of this field.

<SPENR>

Specific enrichment data

<TPACC>

Accompanying materials

<TPADE>

Accompanying materials description

<TPFMT>

Format


Cartographic Data

#CTNN#…#/CTNN#

Only include whatever is between the not null cart. data hash tag set if there is at least one cart. data record linked to the title.

#CT#…#/CT#

Include whatever is between the cart. data hash tag set for each cart. data record not already covered by the #G1#…#/G1#, #G2#…#/G2#, #G3#…#/G3# and #GL#…#/GL# hash tag sets

#G1#…#/G1#

Include whatever is between the first cart. data hash tag set for the first cart. data record

#G2#…#/G2#

Include whatever is between the second cart. data hash tag set for the second cart. data record

#G3#…#/G3#

Include whatever is between the third cart. data hash tag set for the third cart. data record

#GL#…#/GL#

Include whatever is between the last cart. data hash tag set for the last cart. data record if it has not already covered by the #G1#…#/G1#, #G2#…#/G2# and #G3#…#/G3# hash tag sets

<CCOORD>

Coordinates text

(Added in SP9)

<CPRJ>

Projection text

<CSAL>

Scale additional text

(Added in OLIB 9.0)

<CSCL>

Scale text

<TCDGL1>

Cart. Data gen. lookup 1

(Added in OLIB 9.0)


Child Records

#CHNN#…#/CHNN#

Only include whatever is between the not null child records hash tag set if there is at least one child record linked to the title.

#CH#…#/CH#

Include whatever is between the child records hash tag set for each child record not already covered by the #?D#…#/D1#, #D2#…#/D2#, #D3#…#/D3# and #DL#…#/DL# hash tag sets

#D1#…#/D1#

Include whatever is between the first child records hash tag set for the first child record

#D2#…#/D2#

Include whatever is between the second child records hash tag set for the second child record

#D3#…#/D3#

Include whatever is between the third child records hash tag set for the third child record

#DL#…#/DL#

Include whatever is between the last child records hash tag set for the last child record if it has not already covered by the #D1#…#/D1#, #D2#…#/D2# and #D3#…#/D3# hash tag sets

<CCI>

Child record’s copy count

<CMT>

Child record’s media type key ID

<CMTLD>

Child record’s media type long description

<CTI>

Child record’s title


Languages

#LANN#…#/LANN#

Only include whatever is between the not null languages hash tag set if there is at least one language record linked to the title.

#LA#…#/LA#

Include whatever is between the languages hash tag set for each language record not already covered by the #U1#…#/U1#, #U2#…#/U2#, #U3#…#/U3# and #UL#…#/UL# hash tag sets

#U1#…#/U1#

Include whatever is between the first languages hash tag set for the first language record

#U2#…#/U2#

Include whatever is between the second languages hash tag set for the second language record

#U3#…#/U3#

Include whatever is between the third languages hash tag set for the third language record

#UL#…#/UL#

Include whatever is between the last languages hash tag set for the last language record if it has not already covered by the #U1#…#/U1#, #U2#…#/U2# and #U3#…#/U3# hash tag sets

<LA>

Language description

<LALD>

Language description (export only)

<LAMXXI>

MARC language code (titlelangs.mxxi_lang_code)

(Added in SP9)

<LATP>

Language key ID

<LATP_LC>

Language key ID in lower case

(Added in SP7)


Metadata Languages

(Added in OLIB 9.0)

#QLNN#…#/QLNN#

Only include whatever is between the not null metadata languages hash tag set if there is at least one metadata language record linked to the title.

#QL#…#/QL#

Include whatever is between the metadata languages hash tag set for each metadata language record not already covered by the #Q1#…#/Q1#, #Q2#…#/Q2#, #Q3#…#/Q3# and #QL#…#/QL# hash tag sets

#Q1#…#/Q1#

Include whatever is between the first metadata languages hash tag set for the first metadata language record

#Q2#…#/Q2#

Include whatever is between the second metadata languages hash tag set for the second metadata language record

#Q3#…#/Q3#

Include whatever is between the third metadata languages hash tag set for the third metadata language record

#QL#…#/QL#

Include whatever is between the last metadata languages hash tag set for the last metadata language record if it has not already covered by the #Q1#…#/Q1#, #Q2#…#/Q2# and #Q3#…#/Q3# hash tag sets

<MLA>

Metadata language description

<MLATP>

Metadata language key ID


Film Notes

#FMNN#…#/FMNN#

Only include whatever is between the not null film note records hash tag set if there is at least one film note record linked to the title.

#FM#…#/FM#

Include whatever is between the film note records hash tag set for each film note record not already covered by the #M1#…#/M1#, #M2#…#/M2#, #M3#…#/M3# and #ML#…#/ML# hash tag sets

#M1#…#/M1#

Include whatever is between the first film note records hash tag set for the first film note record

#M2#…#/M2#

Include whatever is between the second film note records hash tag set for the second film note record

#M3#…#/M3#

Include whatever is between the third film note records hash tag set for the third film note record

#ML#…#/ML#

Include whatever is between the last film note records hash tag set for the last film note record if it has not already covered by the #M1#…#/M1#, #M2#…#/M2# and #M3#…#/M3# hash tag sets

<FNOTES>

Film note (specific to LDS)


Permissions

#PMNN#…#/PMNN#

Only include whatever is between the not null permissions records hash tag set if there is at least one permissions record linked to the title.

#PM#…#/PM#

Include whatever is between the permissions records hash tag set for each permissions record not already covered by the #Z1#…#/Z1#, #Z2#…#/Z2#, #Z3#…#/Z3# and #ZL#…#/ZL# hash tag sets

#Z1#…#/Z1#

Include whatever is between the first permissions records hash tag set for the first permissions record

#Z2#…#/Z2#

Include whatever is between the second permissions records hash tag set for the second permissions record

#Z3#…#/Z3#

Include whatever is between the third film note records hash tag set for the third permissions record

#ZL#…#/ZL#

Include whatever is between the last permissions records hash tag set for the last permissions record if it has not already covered by the #Z1#…#/Z1#, #Z2#…#/Z2# and #Z3#…#/Z3# hash tag sets

<PERMS>

Permissions


Abstract

#ABNN#…#/ABNN#

Only include whatever is between the not null abstract hash tag set if the title has an abstract.

<AB>

Abstract, output in one unbroken chunk

<ABLB>

Abstract, divided into lines of up to 100 characters. The first line is prefaced by "AB ". Subsequent lines are prefixed with "AB \ "


Title Borrowers (link type-specific)
(replace XXXXX with the link type)

(Added a while ago but not documented until SP9)

#TBXXXXXNN#…#/TBXXXXXNN#

Only include whatever is between the not null title borrower hash tag set if there is at least one borrower linked to the title with the specified link type

#TBXXXXX#…#/TBXXXXX#

Include whatever is between the title borrower hash tag set for each borrower with the specified link type not already covered by the #VXXXXX1#…#/VXXXXX1#, #VXXXXX2#…#/VXXXXX2#, #VXXXXX3#…#/VXXXXX3# and #VXXXXXL#…#/VXXXXXL# hash tag sets

#VXXXXX1#…#/VXXXXX1#

Include whatever is between the first title borrower hash tag set for the first borrower with the specified link type

#VXXXXX2#…#/VXXXXX2#

Include whatever is between the second title borrower hash tag set for the second borrower with the specified link type

#VXXXXX3#…#/VXXXXX3#

Include whatever is between the third title borrower hash tag set for the third borrower with the specified link type

#VXXXXXL#…#/VXXXXXL#

Include whatever is between the last title borrower hash tag set for the last borrower with the specified link type if it has not already covered by the #LXXXXX1#…#/LXXXXX1#, #LXXXXX2#…#/LXXXXX2# and #LXXXXX3#…#/LXXXXX3# hash tag sets

<TBTITLE-XXXXX>

The user’s title, e.g. Mr or Mrs

<TBFNAME-XXXXX>

The user’s forename

<TBSNAME-XXXXX>

The user’s surname

<TBEMAIL-XXXXX>

The user’s email address

<TBDEPT-XXXXX>

The user’s department long description

<TBTEL-XXXXX>

The user’s telephone number (from the user’s address with an address type of M if there is one, otherwise from the user’s location’s address with an address type of M)

<TBFAX-XXXXX>

The user’s fax (ditto)

<TBHOUSE-XXXXX>

The user’s house name (ditto)

<TBSTREET-XXXXX>

The user’s street (ditto)

<TBPOBOX-XXXXX>

The user’s PO Box number (ditto)

<TBPOSTCODE-XXXXX>

The user’s postcode (ditto)

Copies

Tag

Description

#ITEM#…#/ITEM#

Repeat whatever is between the not null item hash tag set for each copy record on loan to the user for whom the alert is being generated.

<CP_AC>

Date accessioned (DD-MON-YYYY)

<CP_AUTOBANDATE>

Date and time on which the item was automatically banned (DD-MON-YYYY HH24:MI)

(Added in OLIB 8.1)

<CP_BC>

Item barcode

<CP_BORBARCODE>

The barcode of the user to whom the item is currently on loan

(Added in OLIB 8.1)

<CP_BVPTI>

Bound volume parent title

(Added in SP13)

<CP_CC>

Copy category key ID

<CP_CCD>

Date created (DD-MON-YYYY)

<CP_CCLD>

Copy category long description

<CP_CCSD>

Copy category short description

(Added in OLIB 8.2)

<CP_CF>

Current fine

<CP_CF_CURRENCY>

The currency of the current fine (taken from WorldView Defaults Default Currency)

(Added in OLIB 8.1)

<CP_CIRCSTATUS>

Circulation status

<CP_CN>

Notes

<CP_CN1> .. <CP_CN5>

Note 1 .. 5

(Added in SP11)

<CP_COLX>

Collection key ID

(Added in OLIB 8.2)

<CP_COLXLD>

Collection long description

(Added in OLIB 8.2)

<CP_COLXSD>

Collection short description

(Added in OLIB 8.2)

<CP_COPYNO>

Copy number

<CP_COPYSEQ>

The copy record’s sequence number

(Added in OLIB 8.1)

<CP_COPYSTOLD>

The status that the item was set to before it was issued in transit

(Added in OLIB 8.1)

<CP_COPYTRAPS>

The number of traps that are currently entered against the item

(Added in OLIB 8.1)

<CP_COTI>

Copy title

<CP_CP>

Price

<CP_CPTP>

Currency key ID

<CP_CZ>

Copy status

<CP_CZD>

Copy status long description

<CP_CZSD>

Copy status short description

(Added in OLIB 8.2)

<CP_ENDFINE>

The item’s end fine

(Added in OLIB 8.1)

<CP_EXST>

Extraction status key ID

<CP_EXSTLD>

Extraction status long description

<CP_EXSTSD>

Extraction status short description

(Added in OLIB 8.2)

<CP_FINESEQ>

The fine sequence that is currently being applied to the overdue item

(Added in OLIB 8.1)

<CP_GEO_COLL>

Geographic collection code

(Added in SP12)

<CP_GEO_COLLD>

Geographic collection description

(Added in SP12)

<CP_GPTI>

Grandparent title. If present, the grandparent’s subtitle will be appended with a “: “ separating the two fields.

(Added in SP12)

<CP_GIFT>

Gift (Y or N)

(Added in SP8)

<CP_HSUM>

Holdings summary

(Added in SP8)

<CP_ITFROMLOC>

The location from which the item was issued in transit (key ID)

(Added in OLIB 8.1)

<CP_ITFROMLOCLD>

The location from which the item was issued in transit (long description)

(Added in OLIB 8.1)

<CP_ITFROMLOCSD>

The location from which the item was issued in transit (short description)

(Added in OLIB 8.2)

<CP_ISSCNT>

Issue count

(Added in OLIB 9.0)

<CP_ISSDATE>

Date issued (DD-MON-YYYY)

<CP_ISSDATEHL>

Date/time issued (DD-MON-YYYY HH24:MI) (for hourly loan items)

<CP_ITSD>

Date issued in transit (DD/MM/YY)

<CP_ITTOLOC>

Location issued in transit to (key ID)

<CP_ITTOLOCLD>

Location issued in transit to (long description)

<CP_ITTOLOCSD>

Location issued in transit to (short description)

(Added in OLIB 8.2)

<CP_LO>

Location key ID

<CP_LOLD>

Location long description

<CP_LOSD>

Location short description

(Added in OLIB 8.2)

<CP_LS>

Loan status

<CP_LSD>

Loan status long description

<CP_NEXT_ODUE>

The next overdue step that is due to be generated

(Added in OLIB 8.1)

<CP_OCSYM>

OCLC Symbol

(Added in SP5)

<CP_ODUEAUDITNO>

The auditno of the most recently sent overdue notice

(Added in OLIB 8.1)

<CP_ODUE_SEQ>

The overdue sequence that is currently being applied to the overdue item

(Added in OLIB 8.1)

<CP_ORIGRETDATE>

The item’s original return date (DD-MON-YYYY)

(Added in OLIB 8.1)

<CP_PLOAN>

Y if the item is on permanent loan

(Added in OLIB 8.1)

<CP_RENCNT>

The item’s current total renewal count

<CP_RENDATE>

Date last renewed (DD-MON-YYYY)

(Added in OLIB 8.1)

<CP_RESCNT>

The count of active reservations on the item

<CP_RESCNTPRE>

The count of as yet unactivated reservations on the item

(Added in OLIB 8.1)

<CP_RESDATE>

Date reserved (DD-MON-YYYY HH24:MI)

(Added in OLIB 8.1)

<CP_RESBORBARCODE>

The barcode of the user who is first on the item’s reservation list

(Added in OLIB 8.1)

<CP_RETDATE>

Date due back (DD-MON-YYYY)

<CP_RETDATEHL>

Date/time due back (DD-MON-YYYY HH24:MI) (for hourly loan items)

<CP_SC>

Shelf key ID

<CP_SCLD>

Shelf long description

<CP_SCSD>

Shelf short description

(Added in OLIB 8.2)

<CP_SLC>

Sub-location key ID

(Added in OLIB 8.2)

<CP_SLD>

Sub-location description

(Added in OLIB 8.2)

<CP_SM>

Shelfmark

<CP_TITLENO>

The parent title record’s record number

(Added in OLIB 8.1)

<CP_TITLETRAPS>

The number of traps that are currently entered against the item’s parent title record

(Added in OLIB 8.1)

<CP_UNSEENRENCNT>

The item’s current unseen renewal count

(Added in OLIB 8.1)

<CP_WITHDRAW>

Y if the item is due to be or has been withdrawn

(Added in OLIB 8.1)

Copy Transactions

Added in OLIB 8.2

Tag

Description

<CT_ID>

Copy transaction ID

<CT_CTRANTP>

Transaction type key ID

<CT_CTRANTPSD>

Transaction type short description

<CT_CTRANTPLD>

Transaction type long description

<CT_PROCDATE>

Date processed

<CT_TRANDATE>

Transaction date

<CT_TRANS_USER>

Transaction recorded by (Sname, Fname)

<CT_ADDRESS>

Sent To address (using AddressDisplay.GetAddress)

<CT_TRANS_SOURCE>

Client in which the transaction was recorded (OLIB Web / WorldView / SIP / NCIP / OPAC)

<CT_MANTRAN_DATE>

Manually recorded transaction date

Users

Tag

Description

<ALTBAR>

Alternative barcode

<BALDATE>

The date on which the user’s current balance was last re-calculated (DD-MON-YYYY)

(Added in OLIB 8.1)

<BAR>

Barcode

<BORROWER>

User record number

<CAT>

User category

<CATLD>

User category long description

<CIRCBAN>

Y or N to indicate whether the user has been flagged as “banned”

(Added in OLIB 8.1)

<CIRCBANB>

‘true’ if CIRCBAN = Y

<CURBAL>

Current balance

<CURBAL_CURRENCY>

The currency of the user’s current balance (taken from WorldView Defaults Default Currency)

(Added in OLIB 8.1)

<CURLOAN>

Number of items currently on loan

<CURODUES>

Number of items currently overdue

<CURRESCOLL>

Number of held items currently awaiting collection

<CURRESPRE>

Number of inactive reservations

(Added in OLIB 8.1)

<CURRESQUE>

Number of non-held active reservations

<EXP>

Membership expiry date

<FORE>

Forename

<INIT>

Initials

<INST>

Institution code

<JOIN>

Join date (DD-MON-YYYY)

<LASTACTIVE>

Last active date (DD-MON-YYYY)

<LOC>

Locatie

<LOCULD>

Location long description

<MAIL>

Email address

<MAXLOAN>

Maximum loans

<MAXRENEW>

Maximum seen renewals

(Added in OLIB 8.1)

<MAXRES>

Maximum reservations

<MAXTOTALREN>

Maximum total renewals

<MAXUNSEENRENEW>

Maximum unseen renewals

(Added in OLIB 8.1)

<NAMEDISP1>

A single field containing a concatenation of the user's surname and the user's forename (or initials if the forename field is blank), separated by a comma and a space

<NAMEDISP2>

A single field containing a concatenation of the user's forename (or initials if the forename field is blank) and the user's surname, separated by a space

<NOTESU>

Notes

<NOTE1U> - <NOTE10U>

User note 1 – User note 10

<OCLC-INSTID>

OCLC Institution ID (from the user’s location or, if this is not set, from OLIB Defaults)

(Added in OLIB 9.0)

<PWEXP>

Password reset due date

(Added in SP9)

<ROOMNO>

Room number

<SUR>

Surname

<TELHOME>

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

<TELWORK>

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

<TELMOB>

The user’s mobile telephone number (from the borrowers record)

<TIU>

Title (Mr, Mrs, Miss, etc.)

<TRAPS>

The number of traps against the user record

(Added in OLIB 8.1)

<UADDR1>

The user's 1st address (using AddressDisplay.GetAddress3)

<UADDR[X]>

The user or organisation's address (using AddressDisplay.GetAddress3). Replace [X] with the address type

<UADDR[X]field>

User's address. Replace [X] with the address type.

The following fields are available:

ADDRESSEE

HOUSE

STREET

POBOX

DISTRICT

CITY

REGION

COUNTRY

POSTCODE

TEL

EXT

<UDOB>

User's date of birth (DD-MON-YYYY)

<UIDENT>

User's Identification field (export only)

<UORADDRESSEE>

<UORHOUSE>

<UORSTREET>

<UORPOBOX>

<UORDISTRICT>

<UORCITY>

<UORREGION>

<UORCOUNTRY>

<UORPOSTCODE>

<UORTEL>

User's overdue/recall address fields

(Added in OLIB 9.0)

<UORG[X]NAME>

User's organisation’s name. Replace [X] with the link type used to link the user to the organisation

<USECCODE>

User's secondary code

<USUP_FORE>

User's supervisor’s forename

<USUP_SUR>

User's supervisor’s surname

<USUP_TIU>

User's supervisor’s title

<UTP>

User type key ID

(Added in OLIB 8.2)

<UTPLD>

User type long description

(Added in OLIB 8.2)

<UTPSD>

User type short description

(Added in OLIB 8.2)

<WMS-SOURCE>

sysglobs.wms_sourcesystem if sysglobs.oclc_institutionid is not null

(Added in OLIB 9.0)

<XMLUDOB>

Membership expiry date (YYYY-MM-DD) (for XML export)

(Added in OLIB 9.0)

<XMLEXP>

Membership expiry date (YYYY-MM-DD"T"hh24:mi:ss) (for XML export)

(Added in OLIB 9.0)

<XMLJOIN>

Join date (YYYY-MM-DD"T"hh24:mi:ss) (for XML export)

(Added in OLIB 9.0)

<XMLULCD>

Last changed date (YYYY-MM-DD"T"hh24:mi:ss) (for XML export)

(Added in OLIB 9.0)


Repeatable Data Blocks


Departments

#UDNN#…#/UDNN#

Only include whatever is between the not null departments hash tag set if there is at least one department linked to the user.

#UD#…#/UD#

Include whatever is between the departments hash tag set for each department not already covered by the #D1#…#/D1#, #D2#…#/D2#, #D3#…#/D3# and #DL#…#/DL# hash tag sets

#D1#…#/D1#

Include whatever is between the first departments hash tag set for the first department

#D2#…#/D2#

Include whatever is between the second departments hash tag set for the second department

#D3#…#/D3#

Include whatever is between the third departments hash tag set for the third department

#DL#…#/DL#

Include whatever is between the last departments hash tag set for the last department if it has not already covered by the #D1#…#/D1#, #D2#…#/D2# and #D3#…#/D3# hash tag sets

<UDEPT>

User's department key ID

<UDEPTLD>

User's department long description


Subscription Services

#SSNN#…#/SSNN#

Only include whatever is between the not null subscription services hash tag set if there is at least one subscription service linked to the user.

#SS#…#/SS#

Include whatever is between the subscription services hash tag set for each subscription service not already covered by the #S1#…#/S1#, #S2#…#/S2#, #S3#…#/S3# and #SL#…#/SL# hash tag sets

#S1#…#/S1#

Include whatever is between the first subscription services hash tag set for the first subscription service

#S2#…#/S2#

Include whatever is between the second subscription services hash tag set for the second subscription service

#S3#…#/S3#

Include whatever is between the third subscription services hash tag set for the third subscription service

#SL#…#/SL#

Include whatever is between the last subscription services hash tag set for the last subscription service if it has not already covered by the #S1#…#/S1#, #S2#…#/S2# and #S3#…#/S3# hash tag sets

<USSSUBLD>

Subscription service description

<USSSUBNOCOPIES>

The number of copies covered by the subscription

<USSSUBREF>

The subscription reference


User Financial Transactions
(Added in OLIB 8.1, but not currently available for export)

#SSNN#…#/SSNN#

Only include whatever is between the not null subscription services hash tag set if there is at least one subscription service linked to the user.

#SS#…#/SS#

Include whatever is between the subscription services hash tag set for each subscription service not already covered by the #S1#…#/S1#, #S2#…#/S2#, #S3#…#/S3# and #SL#…#/SL# hash tag sets

#S1#…#/S1#

Include whatever is between the first subscription services hash tag set for the first subscription service

#S2#…#/S2#

Include whatever is between the second subscription services hash tag set for the second subscription service

#S3#…#/S3#

Include whatever is between the third subscription services hash tag set for the third subscription service

#SL#…#/SL#

Include whatever is between the last subscription services hash tag set for the last subscription service if it has not already covered by the #S1#…#/S1#, #S2#…#/S2# and #S3#…#/S3# hash tag sets

<UFT_AMOUNT>

The amount debited or credited (9G999G999G999G999G990D99)

<UFT_AUDITNO>

The auditno of the financial transaction record

<UFT_DRORCR>

Whether the financial transaction was a debit or credit transaction

<UFT_BTRANTP>

The transaction type key ID

<UFT_BTRANTPLD>

The transaction type description

<UFT_CURRENCY>

The currency of the financial transaction (taken from WorldView Defaults Default Currency)

<UFT_ITEMBARCODE>

The barcode of the item to which the transaction applies (debit transactions only)

(Added in OLIB 9.0)

<UFT_OSAMOUNT>

The outstanding amount (9G999G999G999G999G990D99)

<UFT_TRANMETH>

The transaction method key ID (credit transactions only)

<UFT_TRANMETHLD>

The transaction method description (credit transactions only)

<UFT_TRANDATE>

The date and time of the transaction (DD-MON-YYYY HH24:MI)


Courses

(Added in SP5)

#UCNN#…#/UCNN#

Only include whatever is between the not null courses hash tag set if there is at least one course linked to the user.

#UC#…#/UC#

Include whatever is between the courses hash tag set for each course not already covered by the #C1#…#/C1#, #C2#…#/C2#, #C3#…#/C3# and #CL#…#/CL# hash tag sets

#C1#…#/C1#

Include whatever is between the first courses hash tag set for the first course

#C2#…#/C2#

Include whatever is between the second courses hash tag set for the second course

#C3#…#/C3#

Include whatever is between the third courses hash tag set for the third course

#CL#…#/CL#

Include whatever is between the last courses hash tag set for the last course if it has not already covered by the #C1#…#/C1#, #C2#…#/C2# and #C3#…#/C3# hash tag sets

<UCOURSE>

User's course key ID

<UCOURSELD>

User's course long description

Reservations

Tag

Description

<RES_RESNO>

Reservation number

<RES_ACTIVATED>

Y/N to indicate whether the reservation has been activated

<RES_ACTIVATEDATE>

Date on which the reservation was activated – DD-MON-YYYY

<RES_AREALD>

If the reservation is an area-specific reservation, the area long description

<RES_BORBARCODE>

The reservee’s barcode

<RES_CANCDATE>

If the reservation has been cancelled, the date on which it was cancelled

<RES_COLL_DEL>

Collect From or Deliver To

(Added in SP7)

<RES_COLLLOC>

The collection location key ID

<RES_COLLLOCLD>

The collection location long description

<RES_COLLLOCSD>

The collection location short description

(Added in SP9)

<RES_CONFIRMED>

Y/N to indicate whether the reservation has been confirmed

<RES_COPIES_HLD>

The number of copies held (set reservations)

(Added in SP4)

<RES_COPIES_ISS>

The number of copies issued (set reservations)

(Added in SP4)

<RES_COPIES_REQ>

The number of copies requested (set reservations)

(Added in SP4)

<RES_COPIES_RES>

The number of copies reserved (set reservations)

(Added in SP4)

<RES_COPYCAT>

If the reservation is a copy category-specific reservation, the copy category key ID

<RES_COPYCATLD>

If the reservation is a copy category-specific reservation, the copy category description

<RES_DELADDR>

Delivery address (using AddressDisplay.GetAddress4)

(Added in SP7)

<RES_EST_AVAIL_DATE>

The date on which the system has calculated that the item will become available (DD-MON-YYYY)

<RES_EXP_HOLD_DATE>

The date on which the hold on a held reservation is due to expire (DD-MON-YYYY)

<RES_GLOBALRES>

Y or N to indicate whether it is a global reservation

(Added in OLIB 8.1)

<RES_HELDBARCODE>

The barcode of the copy which has been trapped an held to satisfy the reservation

<RES_HELDCLO>

The location of the copy that has been held to satisfy the reservation (key ID)

(Added in OLIB 9.0)

<RES_HELDCLOLD>

The location of the copy that has been held to satisfy the reservation (long description)

(Added in OLIB 9.0)

<RES_HELDCCC>

The copy category of the copy that has been held to satisfy the reservation (key ID)

(Added in OLIB 9.0)

<RES_HELDCCCLD>

The copy category of the copy that has been held to satisfy the reservation (long description)

(Added in OLIB 9.0)

<RES_HELDCSC>

The shelf of the copy that has been held to satisfy the reservation (key ID)

(Added in OLIB 9.0)

<RES_HELDCSCLD>

The shelf of the copy that has been held to satisfy the reservation (long description)

(Added in OLIB 9.0)

<RES_HELDCSLD>

The sub-location of the copy that has been held to satisfy the reservation (long description)

(Added in OLIB 9.0)

<RES_HELDCSM>

The shelfmark of the copy that has been held to satisfy the reservation

(Added in OLIB 9.0)

<RES_HELDDATE>

The date on which an item was held to satisfy the reservation (DD-MON-YYYY)

<RES_LINKRESNO>

The record number of the linked reservation

(Added in OLIB 8.1)

<RES_LOC>

If the reservation is a location-specific reservation, the location key ID

<RES_LOCLD>

If the reservation is a location-specific reservation, the location description

<RES_OCLCNO>

The OCLC number of the title to which the reservation relates

(Added in OLIB 9.0)

<RES_OVERRIDELTBAN>

Y or N to indicate whether to ignore the ban flag in Loan Terms

(Added in OLIB 8.1)

<RES_REQBYDATE>

The date before which the reservation is required (DD-MON-YYYY)

<RES_REQDATE>

The date after which the reservation is required (DD-MON-YYYY)

<RES_REQFROM>

The date from which the reservation is required (DD-MON-YYYY)

<RES_REQTO>

The date to which the reservation is required (DD-MON-YYYY)

<RES_RESDATE>

The date on which the reservation was placed (DD-MON-YYYY)

<RES_RESNOTES>

Notes

<RES_RESPRIOR>

The reservation priority

<RES_RESTP>

Reservation type (Title or Copy)

(Added in OLIB 8.2)

<RES_SATISFIED>

Y or N to indicate whether the reservation has been satisfied

(Added in OLIB 8.1)

<RES_SENDBY>

The date by which an item must be sent to satisfy the reservation (DD-MON-YYYY)

<RES_STATUS>

Reservation status

(Added in OLIB 8.2)

<RES_TITLENO>

The record number of the title record that has been reserved

(Added in OLIB 8.1)

Orders

Tag

Description

<ORDNO>

Order number

<ORDCOMPDATE>

Date completed

<ORDCONTACT>

Supplier’s contact addressee ([title] [forename] [surname])

(Added in OLIB 9.0)

<ORDCURR>

Currency

<ORDCURRLD>

Currency long description

<ORDDELM>

Delivery method key ID

<ORDDELMLD>

Delivery method description

<ORDLOC>

Order location key ID

<ORDNOTES>

Notes

<ORDORDDATE>

Order date

<ORDORDERREF>

Order reference

<ORDSTATUS>

Status

<ORDSTATUSLD>

Status long description

<ORDSUPP>

Supplier

<ORDSUPPORDEML>

The supplier’s order email address

<ORDSUPPREF>

Supplier reference

<ORDTOTALCOST>

Total cost

<SOACONTFNAME>

Supplier’s contact forename

(Added in OLIB 9.0)

<SOACONTINIT>

Supplier’s contact initials

(Added in OLIB 9.0)

<SOACONTPOS>

Supplier’s contact job title/position

(Added in OLIB 9.0)

<SOACONTSNAME>

Supplier’s contact surname

(Added in OLIB 9.0)

<SOACONTTITLE>

Supplier’s contact title

(Added in OLIB 9.0)

<SOADDRESSEE>

<SOHOUSE>

<SOSTREET>

<SOPOBOX>

<SODISTRICT>

<SOCITY>

<SOREGION>

<SOCOUNTRY>

<SOPOSTCODE>

Supplier's order address fields

(Added in OLIB 9.0)

Order Items

Tag

Description

<OINO>

Order item number

<OICANCDATE>

Date cancelled

<OICCAT>

Order item copy category

<OICLOC>

Order item copy location

<OIDELPER>

Delivery period

<OIDISCRATE>

Discount rate (990D99)

<OIDUEDATE>

Date expected

<OIINOTES>

Internal notes. Also used for the reason for rejection if a purchase suggestion is rejected

<OIINV>

Number invoiced

<OIITEMPRICE>

Item price

<OINEEDDATE>

Needed By date

<OIOLOC>

Order items’ order location

<OIORD>

Number ordered

<OIORDDATE>

Order date

<OIORDNO>

Order number

<OIORDREF>

Order reference

<OIOUT>

Number outstanding

<OIREC>

Number received

<OIRECDATE>

Date received

<OISTATUS>

Order status key ID

<OISTATUSLD>

Order status long description

<OISUBSSTART>

Subscription start date (serial subscription orders)

<OISUBSFINISH>

Subscription end date (serial subscription orders)

<OISUPP>

Supplier

(Added in SP9)

<OISUPPCLEML>

Supplier’s email address for claims

<OISUPPREF>

Supplier reference

<OITAXRATE>

Tax rate, e.g. VAT rate (990D99)

<OITITLE>

Title

<OITOTALCOST>

Total cost

<OITYPE>

Order item type (CAT=monograph order item ; SER=serial subscription order item ; NONC=non-catalogue order item

<OIXNOTES>

External notes


Payment Accounts

#PANN#…#/PANN#

Only include whatever is between the not null payment accounts hash tag set if there is at least one payment account linked to the order item.

#PA#…#/PA#

Include whatever is between the payment accounts hash tag set for each payment account record not already covered by the #P1#…#/P1#, #P2#…#/P2#, #P3#…#/P3# and #PL#…#/PL# hash tag sets

#P1#…#/P1#

Include whatever is between the first payment account hash tag set for the first payment account record

#P2#…#/P2#

Include whatever is between the second payment account hash tag set for the second payment account record

#P3#…#/P3#

Include whatever is between the third payment account hash tag set for the third payment account record

#PL#…#/PL#

Include whatever is between the last payment account hash tag set for the last payment account record if it has not already covered by the #P1#…#/P1#, #P2#…#/P2# and #P3#…#/P3# hash tag sets

<OIPAYAC>

Payment account (ac_accsd || ' ' || fp1.fp_sd || decode(ae_debitaccinstno, ae_requestaccinstno, NULL, ' (Paid by ' || a1.ac_accsd || ' ' || fp1.fp_sd || ')') || ' - ' || ltrim(to_char(ae_debitcommitamtsource, '99G999G999G999G990D99'))

Invoices

Tag

Description

<INVNO>

Invoice number

<INVCURR>

Currency

<INVCURRLD>

Currency long description

<INVINVDATE>

Invoice date

<INVINVREF>

Invoice reference

<INVNOTES>

Notes

<INVOTHC>

Other costs

<INVOTHNT>

Other costs notes

<INVPROCDATE>

Date processed

<INVSUPP>

Supplier

<INVTOTALAMT>

Total cost

<INVTAXAMT>

Tax amount

<INVTAXRATE>

Tax rate

<INVTYPE>

Type (I – Invoice ; C – Credit note)

Invoice Items

Tag

Description

<IINO>

Invoice item number

<IICOST>

Total invoice item cost

<IIDISCRATE>

Discount rate (990D99)

<IIINV>

Number invoiced

<IIITEMPR>

Item price

<IINOTES>

Notes

<IITAXRATE>

Tax rate, e.g. VAT rate (990D99)


Payment Accounts

#IPNN#…#/IPNN#

Only include whatever is between the not null payment accounts hash tag set if there is at least one payment account linked to the order item.

#IP#…#/IP#

Include whatever is between the payment accounts hash tag set for each payment account record not already covered by the #P1#…#/P1#, #P2#…#/P2#, #P3#…#/P3# and #PL#…#/PL# hash tag sets

#P1#…#/P1#

Include whatever is between the first payment account hash tag set for the first payment account record

#P2#…#/P2#

Include whatever is between the second payment account hash tag set for the second payment account record

#P3#…#/P3#

Include whatever is between the third payment account hash tag set for the third payment account record

#PL#…#/PL#

Include whatever is between the last payment account hash tag set for the last payment account record if it has not already covered by the #P1#…#/P1#, #P2#…#/P2# and #P3#…#/P3# hash tag sets

<IIPAYAC>

Payment account (ac_accsd || ' ' || fp1.fp_sd || decode(ae_debitaccinstno, ae_requestaccinstno, NULL, ' (Paid by ' || a1.ac_accsd || ' ' || fp1.fp_sd || ')') || ' - ' || ltrim(to_char(ae_debitcommitamtsource, '99G999G999G999G990D99'))

Enquiries

All added in OLIB 8.2

Tag

Description

<ENQNO>

Enquiry number

<ALLOC>

Allocated to

<CBY>

Date to be completed by

<CDATE>

Date completed

<CTIME>

Total time spent on the enquiry

<DESC>

Enquiry description

<DOBY>

Do By date

<DREC>

Date received

<EDATE>

Date entered

<ENQLOC>

Enquiry location

<ENTBY>

Entered by

<ESRCS>

External sources

<EUSER>

Internal user name (Sname, Fname)

<LTIME>

Lapsed time between the date/time the enquiry was received and the date/time it was marked as completed

<NOTE1> - <NOTE10>

Notes 1 – 10

<OALLOC>

Previously allocated to

<OSTA>

Previous status

<PRIOR>

Priority

<PRMETH>

Preferred response method

<RCON>

Contact details for response

<RECBY>

Received by

<REF>

Enquiry reference

<REFTO>

Referred to

<RESP>

Response

<RMETH>

Receipt method

<STA>

Status

<TITLE>

Enquiry title

<TYPE>

Enquiry type

<UTEXT>

External user details

<UTYPE>

User type

<WORDIND>

Word Index


Subjects

#ESNN#…#/ESNN#

Only include whatever is between the not null enquiry subjects hash tag set if there is at least one subject linked to the enquiry.

#ES#…#/ES#

Include whatever is between the enquiry subjects hash tag set for each enquiry subject record not already covered by the #E1#…#/E1#, #E2#…#/E2#, #E3#…#/E3# and #EL#…#/EL# hash tag sets

#E1#…#/E1#

Include whatever is between the first enquiry subject hash tag set for the first enquiry subject record

#E2#…#/E2#

Include whatever is between the second enquiry subject hash tag set for the second enquiry subject record

#E3#…#/E3#

Include whatever is between the third enquiry subject hash tag set for the third enquiry subject record

#EL#…#/EL#

Include whatever is between the last enquiry subject hash tag set for the last enquiry subject record if it has not already covered by the #E1#…#/E1#, #E2#…#/E2# and #E3#…#/E3# hash tag sets

<ESUBJ>

Subjects

Subject Headings

Tag

Description

<SUBSU>

Subject

<SUBSUBTP>

Subject type key ID

<SUBSUBTPLD>

Subject type long description

<SUBSCOPE>

Scope note

<SUBNO>

Notes


Broader Terms

#BTNN#…#/BTNN#

Only include whatever is between the not null broader terms hash tag set if there is at least one broader term record linked to the subject.

#BT#…#/BT#

Include whatever is between the broader term hash tag set for each broader term record not already covered by the #B1#…#/B1#, #B2#…#/B2#, #B3#…#/B3# and #BL#…#/BL# hash tag sets

#B1#…#/B1#

Include whatever is between the first broader term hash tag set for the first broader term record

#B2#…#/B2#

Include whatever is between the second broader term hash tag set for the second broader term record

#B3#…#/B3#

Include whatever is between the third broader term hash tag set for the third broader term record

#BL#…#/BL#

Include whatever is between the last broader term hash tag set for the last broader term record if it has not already covered by the #B1#…#/B1#, #B2#…#/B2# and #B3#…#/B3# hash tag sets

<SUBBT>

Broader term subject


Narrower Terms

#NTNN#…#/NTNN#

Only include whatever is between the not null narrower terms hash tag set if there is at least one narrower term record linked to the subject.

#NT#…#/NT#

Include whatever is between the narrower term hash tag set for each narrower term record not already covered by the #N1#…#/N1#, #N2#…#/N2#, #N3#…#/N3# and #NL#…#/NL# hash tag sets

#N1#…#/N1#

Include whatever is between the first narrower term hash tag set for the first narrower term record

#N2#…#/N2#

Include whatever is between the second narrower term hash tag set for the second narrower term record

#N3#…#/N3#

Include whatever is between the third narrower term hash tag set for the third narrower term record

#NL#…#/NL#

Include whatever is between the last narrower term hash tag set for the last narrower term record if it has not already covered by the #N1#…#/N1#, #N2#…#/N2# and #N3#…#/N3# hash tag sets

<SUBNT>

Narrower term subject


Related Terms

#RTNN#…#/RTNN#

Only include whatever is between the not null related terms hash tag set if there is at least one related term record linked to the subject.

#RT#…#/RT#

Include whatever is between the related term hash tag set for each related term record not already covered by the #R1#…#/R1#, #R2#…#/R2#, #R3#…#/R3# and #RL#…#/RL# hash tag sets

#R1#…#/R1#

Include whatever is between the first related term hash tag set for the first related term record

#R2#…#/R2#

Include whatever is between the second related term hash tag set for the second related term record

#R3#…#/R3#

Include whatever is between the third related term hash tag set for the third related term record

#RL#…#/RL#

Include whatever is between the last related term hash tag set for the last related term record if it has not already covered by the #R1#…#/R1#, #R2#…#/R2# and #R3#…#/R3# hash tag sets

<SUBRT>

Related term subject


Use Terms

#USNN#…#/USNN#

Only include whatever is between the not null use terms hash tag set if there is at least one use term record linked to the subject.

#US#…#/US#

Include whatever is between the use term hash tag set for each use term record not already covered by the #S1#…#/S1#, #S2#…#/S2#, #S3#…#/S3# and #SL#…#/SL# hash tag sets

#S1#…#/S1#

Include whatever is between the first use term hash tag set for the first use term record

#S2#…#/S2#

Include whatever is between the second use term hash tag set for the second use term record

#S3#…#/S3#

Include whatever is between the third use term hash tag set for the third use term record

#SL#…#/SL#

Include whatever is between the last use term hash tag set for the last use term record if it has not already covered by the #S1#…#/S1#, #S2#…#/S2# and #S3#…#/S3# hash tag sets

<SUBUS>

Use term subject


Used For Terms

#UFNN#…#/UFNN#

Only include whatever is between the not null used for terms hash tag set if there is at least one used for term record linked to the subject.

#UF#…#/UF#

Include whatever is between the used for term hash tag set for each used for term record not already covered by the #F1#…#/F1#, #F2#…#/F2#, #F3#…#/F3# and #FL#…#/FL# hash tag sets

#F1#…#/F1#

Include whatever is between the first used for term hash tag set for the first used for term record

#F2#…#/F2#

Include whatever is between the second used for term hash tag set for the second used for term record

#F3#…#/F3#

Include whatever is between the third used for term hash tag set for the third used for term record

#FL#…#/FL#

Include whatever is between the last used for term hash tag set for the last used for term record if it has not already covered by the #F1#…#/F1#, #F2#…#/F2# and #F3#…#/F3# hash tag sets

<SUBUF>

Used for term subject


Classmarks Linked To Subjects

#SCNN#…#/SCNN#

Only include whatever is between the not null classmark hash tag set if there is at least one classmark record linked to the subject.

#SC#…#/SC#

Include whatever is between the classmark hash tag set for each classmark record not already covered by the #C1#…#/C1#, #C2#…#/C2#, #C3#…#/C3# and #CL#…#/CL# hash tag sets

#C1#…#/C1#

Include whatever is between the first classmark hash tag set for the first classmark record

#C2#…#/C2#

Include whatever is between the second classmark hash tag set for the second classmark record

#C3#…#/C3#

Include whatever is between the third classmark hash tag set for the third classmark record

#CL#…#/CL#

Include whatever is between the last classmark hash tag set for the last classmark record if it has not already covered by the #C1#…#/C1#, #C2#…#/C2# and #C3#…#/C3# hash tag sets

<SUBCL>

Classmark