Specification of statistic files for Danish public libraries

 

Identifier: http://biblstandard.dk/statistic/Specification-public-libraries_2009-12-09.htm

Published: 09 December 2009

Published by: Danish Agency for Libraries and Media

Supersede version of 18 November 2008

 

 

Scope

Description of formats for files with annual statistic reports from Danish public libraries about circulation and handling of physical materials and about borrowers to Danish Agency for Libraries and Media.

 

 

Files

File name

Content

udlaan.txt

Counting of loans

forny.txt

Counting of renewals

bestmon.txt

Counting of stock of monographs

tilvmon.txt

Counting of accessions of monographs

afgamon.txt

Counting of discarding of monographs

bestser.txt

Counting of stock of serials

tilvser.txt

Counting of accessions of serials

afgaser.txt

Counting of discarding of serials

interin.txt

Counting of received interlibrary loans

laanere.txt

Counting of active borrowers

 

 

Validity of file

All lines except the last position (the counter) shall be unique. This condition is not case sensitive.

If multiple identical (except the counter) lines in files, only the last line will be recorded – and only the counter from this line will survive.

Lines with one or more empty positions will not be recorded. Exceptions to the rule:

  • for the file laanere: if position 4 has other values than per, then position 3 and 5 can be empty.
  • for the files udlaan and forny: if position 5 has other values than and, then position 8 can be empty

 

 

Definitions

Term

Definition

Library number

6 digit number for library assigned by Danish Agency for Libraries and Media

Affiliation

The type of department which the item belongs to children or adult for public library or joint departments school/public library

MonoOrSerial

An item is monograph or serial. If tag 008 subtag t is p the value of MonoOrSerial is p. For all other occurrences the value is m for monograph.

See: http://www.kat-format.dk/danMARC2/Danmarc2.9.htm#pgfId=1574258

Handle type

The type of entity handling the transaction – staff or borrower

Recipient codes

Codes for the person, institution or library who is target for the transaction

GMB+l

General material term (generel materialebetegnelse - GMB):

danMARC2, tag 009, subtag a – first occurrence

See: http://www.kat-format.dk/danMARC2/Danmarc2.a.htm#pgfId=1574265

If GMB is r and tag 005 subtag z is p or q, then GMB+l it the letter l (for talking book). All other values of GMB is also GMB+l

SMB

Specific material term (specifik materialebetegnelse)

danMARC2, tag 009, subtag g – first occurrence

See: http://www.kat-format.dk/danMARC2/Danmarc2.a.htm#pgfId=1574265

If tag 009, subtag g is missing, the bibliographic item is reported as a text, use value xx.

Type of serial

Type of serial from danMARC2, tag 008, subtag h

See: http://www.kat-format.dk/danMARC2/Danmarc2.9.htm#pgfId=1574258

If this subtag is empty, use value ?

Municipality code

4 digit number assigned to each municipality – place of domicile for borrowers

See OIO InfoStructureBase *)

For persons without address according to national registration office (ingen folkeregisteradresse), use value 9999

Year of birth

4 digits for year of birth for borrowers

Borrower main type

Dividing borrowers into libraries or not libraries

Borrower group

Dividing borrowers into domestic municipality, other municipalities and libraries

Borrower category

Dividing borrowers into different kinds of libraries and other borrowers

Counter

Integer

Supplier code

Codes for the library who supply with ILL

 

*) References to OIO InfoStructureBase:

http://rep.oio.dk/cpr.dk/xml/schemas/core/2005/03/18/cpr_municipalitycode.xsd.meta.xml

- which refer to:

http://rep.oio.dk/cpr.dk/xml/schemas/core/2005/03/18/cpr_municipalitycode.xsd

- which include:

http://rep.oio.dk/cpr.dk/xml/schemas/core/2005/03/18/CPR_AuthorityCode.xsd

- which include the technical definition: <restriction base="string"> and <pattern value="[0-9]{4}"/>

 

 

Values

There is linked to definitions of values defined outside this specification in Definitions above.

 

Affiliation

Definition

b

Materials belonging to departments for children – public library

v

Materials belonging to departments for adult – public library

r

Materials belonging to departments for children – joint departments school/public library

k

Materials belonging to departments for adult – joint departments school/public library

 

Handle type

Definition

p

Transaction handled by member of staff

l

Transaction handled by the borrower

 

Recipient codes

Definition

bi

Institutions for children

vi

Institutions for adults

over

Public libraries in the region

(only for regional libraries)

folk

Public libraries in Denmark

(for regional libraries: Public libraries outside own region)

skol

School libraries in Denmark

udd

Libraries for educational establishments between public school and higher education in Denmark

fors

Research libraries in Denmark

nord

Libraries in the Nordic Countries

verd

Libraries in rest of the world

and

All others

(mostly primary users of the library)

 

Borrower groups

Definition

i

Active borrowers in municipalities covered by the library

u

Active borrowers in municipalities outside municipalities covered by the library

b

Other libraries

 

Borrower categories

Definition

per

Private persons

aib

Institutions for children

aiv

Institutions for adults

apf

Private companies

aai

Other borrowers, who not are private persons

bfol

Other public libraries in Denmark

bsko

School libraries in Denmark

budd

Libraries for educational establishments between public school and higher education

bfor

Research libraries in Denmark

bude

Libraries outside Denmark

 

Borrower main type

Definition

ill

Other libraries (receiving copies)

own

All other borrowers than libraries (receiving copies)

 

Supplier codes

Definition

over

Public libraries in the region

(only for regional libraries)

folk

Public libraries in Denmark

(for regional libraries: Public libraries outside own region)

udd

Libraries for educational establishments between public school and higher education in Denmark

fors

Research libraries in Denmark

nord

Libraries in the Nordic Countries

verd

Libraries in rest of the world

 

 

File formats

Content defined in section Definitions.

 

Files: udlaan.txt and forny.txt

Position

Content

1

Library number

2

Affiliation

3

MonoOrSerial

4

Handle type

5

Recipient code

6

GMB+l

7

SMB

8

Year of birth

9

Counter

 

Example:

716500,b,m,p,and,a,xx,1954,678

716500,b,m,p,and,a,xx,1955,578
716500,v,p,p,and,a,xx,1998,678
716500,v,m,p,and,l,xh,1978,24
716500,v,m,p,folk,l,xh,,24

716500,v,m,p,budd,l,xh,,8

 

 

Files: bestmon.txt, tilvmon.txt and afgamon.txt

Position

Content

1

Library number

2

Affiliation

3

GMB+l

4

SMB

5

Counter

 

Example:

716500,b,a,xx,3467
716500,v,a,xx,98
716500,v,l,xh,956
716500,f,a,xx,712

 

Files: bestser.txt, tilvser.txt and afgaser.txt

Position

Content

1

Library number

2

Affiliation

3

Type of serial

4

Counter

 

Example:

716500,b,m,58
716500,v,n,31
716500,v,?,34

 

 

Files: interin.txt

Position

Content

1

Library number

2

MonoOrSerial

3

GMB+l

4

SMB

5

Supplier code

6

Counter

 

Example:

716500,p,a,xx,folk,12

716500,m,a,xx,folk,223

716500,m,s,xc,udd,34

716500,m,a,xx, fors,36

 

 

File: laanere.txt

Position

Content

1

Library number

2

Borrower group

3

Municipality code (if position 4 is per)

4

Borrower category

5

Year of birth (if position 4 is per)

6

Counter

 

Example:

716500,i,0827,per,1956,56
716500,i,0827,per,1957,43
716500,i,0827,aib,,12
716500,u,0825,per,1957,15
716500,u,9999,per,1957,1
716500,u,0823,apf,,2
716500,b,,bfol,,231
716500,b,,budd,,56
716500,b,,bfor,,123
716500,b,,bude,,3

 

 

Revision history

Date

Changes

5-9-2003

First version

1-12-2003

File formats for udlaan and forny was missing position 6 - corrected

2-7-2004

Affiliation BV and BVF joined to Affiliation and two new values added. The value f in specification of 1 December 2004 will be accepted for annual reports for 2004

Recipient code amt changed to over and definition adjusted

Recipient code udd added. Libraries covered of value udd can for annual reports for 2004 be included in value fors

27-9-2006

Error in definition of MonoOrSerial corrected – subtag t now named.

Some miss-spelling corrected

27-9-2006

Changes valid from reporting statistic for the year 2007:

  • File kopier to be struck out

27-9-2006

Changes valid from reporting statistic for the year 2008:

  • Municipality number changed to Municipality code - and from 3 to 4 digits and definition linked to OIO.
  • Year of birth added as position 8 in files udlaan and forny – and Counter moved from position 8 to 9. Remark that the change of file format must not be used when reporting for 2007.
  • New file interin added with counting of received interlibrary loans. Remark that reporting this file for 2007 will be acceptable, but the file will not be used.

18-11-2008

Update of institution name and email.

18-11-2008

Changes valid from reporting statistic for the year 2009:

  • Files names now have “.txt” added
  • Supplier code – definition and codes added
  • Supplier code added in position 5 in file interin.txt and counter moved to position 6
  • Examples added to interin.txt
  • Value of library number in examples changed.
  • Reference to OIO InfoStructureBase updated
  • Sorting of Definitions and Values now alphabetical

09-12-2009

Example to illustrate interim.txt updated to reflect the change of specification 18-11-2008.

 

 

 

Contact:

Eigil Skov

Danish Agency for Culture

Email: ESK@kulturstyrelsen.dk