Doorgaan naar de website
OCLC Support

Data fields from main entities explained

Find information about and examples of the data fields appearing in Amlib OpenReports.

Acquisitions - Budget

Examples include:

  • Budget Commitments for this Year
  • Actual Expenditure for this Year
  • Different Group Levels used for the current Year
  • Budget Total Amount for the last 5 years

Data Element

Description

Example

Database Name ACCOUNT_HDR unless specified

Budget Account

Account code which is used for the expenditure within a budget

AF

ACH_ACCOUNT

Budget Account Details

Account description rather than the code

Adult Fiction

ACH_DESC

Budget Actual Amount

Actual Amount Spent within the Budget and on longer committed

2000.00

ACH_ACTUAL

Budget Commit Amount

Actual Amount Ordered and Committed within the Budget

1000.00

ACH_COMMIT

Budget Financial Year

Current Financial Year – generally the one to use as is available as a Drop-down

and references the Financial Years in use

2014

ACH_YEAR

Budget Group Level 1

GL Code 1 from the Budget hierarchy

LIB

ACH_GROUP1

Budget Group Level 1 Details

GL Code 1 Description from the Budget hierarchy

Library

ACCNO_GROUP.ACCNO_CODE_DESC

Budget Group Level 2

GL Code 2 from the Budget hierarchy

BK

ACH_GROUP2

Budget Group Level 2 Details

GL Code 2 Description from the Budget hierarchy

Books

ACCNO_GROUP.ACCNO_CODE_DESC

Budget Group Level 3

GL Code 3from the Budget hierarchy

AF

ACH_GROUP3

Budget Group Level 3 Details

GL Code 3 Description from the Budget hierarchy

Adult Fiction

ACCNO_GROUP.ACCNO_CODE_DESC

Budget Group Level 4

GL Code 4 from the Budget hierarchy

NOV

ACH_GROUP4

Budget Group Level 4 Details

GL Code 4 Description from the Budget hierarchy

Novels

ACCNO_GROUP.ACCNO_CODE_DESC

Budget Library Group

Library Group for current Budget

PRIM

ACH.LIB.GROUP

Budget Total Amount

Budgeted Amount allowed to spend within the Budget

5000.00

ACH.BUDGET

Acquisitions – Invoices

This Report enables reports for the Order Invoices within the system. Ideas for reports could be:

  • Recent Invoices within a Date range
  • Invoice lines for a particular Invoice No
  • Invoices from Supplier/s
  • Total Costs of invoices created since the beginning of the month
  • Pending invoices

Data Element

Description

Example

Database Name – ACCOUNT_HEADER

unless shown

Invoice Account

Account Code applied to the Invoice

ANF

ACCOUNT_COMPONENT.AC_ACCNO

Invoice Account Details

Description of the Account Code, applied to the Invoice

Adult Non Fiction

ACCOUNT.ACCNO_DESC

Invoice Allocation

Allocation Code set for the Order being invoiced

PK

ACCOUNT_COMPONENT.AC_ALLOCATE

Invoice Allocation Details

Description of the Allocation Code set for the Order being Invoiced

Paul Kosch

FIN_ALLOC.FA_DESC

Invoice Author

Invoice Line 2

Winton, Tim

ACCOUNT_COMPONENT.AC_LINE2

Invoice Date

Date Invoice was created

19/08/2015

AH_INVOICE_DATE

Invoice Discount

Discount as applied to the Invoice line

10%

ACCOUNT_COMPONENT.AC_DISCOUNT

Invoice Discount Indicator % or $

Indicates whether the Discount applied to Invoice costs is shown as a percentage, or money amount

%

ACCOUNT_COMPONENT.AC_DISCOUNT_ind

Invoice Forex Code

Foreign Exchange code as applied to the Invoice Header

AUS

AH_FCCODE

Invoice Forex Cost

Cost that applies to the Invoice Header prior to Discounts

30.00

AH_FCVALUE

Invoice Forex Date

Date of the Foreign Exchange code

01/01/1995

AH_FCDATE

Invoice Forex Rate

Rate applied to the Invoice amount for Foreign exchange

1.0000

AH_FCRATE

Invoice Lib Group

Library Group owning the Invoice Header

LIBRARY

AH_LIB_GROUP

Invoice Line includes Stockitem

The invoice line reference a Stockitem. Y/N

Y

AC_COMPONENT.AC_STOCKITEMYN

Invoice Line Notes

Notes associated with the Invoice Lines

Price changed on

Invoice – discounted

AC_COMPONENT.AC_NOTES

Invoice Line Tax Account

Tax Account allocated on Invoice line

TAX

AC_COMPONENT.AC_TAX_ACCNO

Invoice Line Tax Code

Tax Code allocated on the Invoice line

GST

AC_COMPONENT.AC_TAX_CODE

Invoice Line Tax Rate

Rate calculated for the Tax code chosen

1.1%

AC_COMPONENT.AC_TAX_RATE

Invoice Local Cost

Invoice Total before Tax – Forex amount minus the tax component

60.00

AH_TOTAL

Invoice No

Invoice Number allocated to the Invoice

008899

AH_INVOICE_NO

Invoice Notes

Invoice Note

Cash purchase at

Conference

AH_NOTES

Invoice Order Line No

Order Line No for processing

2

AC_COMPONENT.AC_ORDER_LNO

Invoice Order No

Order No included in the Order Invoice

516

AC_COMPONENT.AC_ORDER_NO

Invoice Report Date

Date of an Invoice report where the Update mode was set to Y

23/04/2015

AH_REPORT_DATE

Invoice Status

Status of the Invoice – either Pending or Invoiced

INVOICED

AH_STATUS

Invoice Supplier

Code of the Supplier for the Invoice

DYM

AH_SUPP_NO

Invoice Supplier Details

Description of the Supplier of the Invoice

Dymocks

PER_SUPPLIER.PS_COMPANY

Invoice Title

Invoice Line 1, usually the Title

Easy Reader Book 2

AC_COMPONENT.AC_LINE1

Invoice Total Tax excl

Invoice Total excluding Tax

66.00

AH_COST

Invoice Unit Cost exc Tax

Cost excluding the Tax component of the Invoice Line

40.00

ACCOUNT_COMPONENT.AC_COST

Invoice Unit Cost inc Tax

Cost including the Tax component of the Invoice Line

44.00

ACCOUNT_COMPONENT.AC_TOTAL

Invoice User Created

User who created the Invoice. Depends on login to the system

STAFF

AH_OPER

Invoiced Qty

No of items within the Invoice Line that have been invoiced

1

ACCOUNT_COMPONENT.AC_QTY_INVOICED

Acquisitions – Orders

This Report is a combination of Order Headers and Order Lines Useful Reports may include:

  • Orders placed during a time period
  • Orders Invoiced
  • Orders Received
  • Orders Not Received but placed over a certain date period
  • Orders placed by a certain supplier
  • Order Lines from a particular Order No
  • Orders where the cost of an Order line exceeds $100.00
  • Order Header Totals over a certain period

Data Element

Description

Example

Database Name

Order Header Condition

Order Condition of Header

NORM, URGENT

OH_CONDITION

Order Header Date Placed

Date place of the Order

16/09/2015

OH_DATE_PLACED

Order Header Date Printed

Date Order was printed (if in update mode)

16/09/2015

OH_DATE_PRINTED

Order Header Date To Claim

Date specified to claim

16/09/2015

OH_DATE_TO_CLAIM

Order Header Description

Order Header Notes

Delayed with Supplier

OH_DESCRIPTION

Order Header Forex Total

Order Header Total excluding Discounts

$30.00

OH_COST

Order Header Local Cost

Order Header Total Cost including Discounts

$27.00

OH_TOTAL

Order Header Summary

Summary

Bookweek purchases

OH_SUMMARY

Order Header Type

Order Type

NORM

OH_TYPE

Order Line Account

Account code for Order Line

JF

OC_ACCNO

Order Line Account Details

Description for the Account Code shown

Junior Fiction Books

OC_ACCNO_DESC

Order Line Allocation

Allocation code for Order Line

ENG

OC_ALLOC

Order Line Allocation Details

Description for the Allocation Code

English Dept

OC_ALLOC_DESC

Order Line Author

Order Line 2

Winton, Tim

OC_LINE2

Order Line Call No

Order Line 6

F WIN

OC_LINE6

Order Line Catalogue Ref

Order Line Catalogue Reference

103432

OC_CAT_REF

Order Line Discount

Discount allocated to Order Line

10%

OC_DISCOUNT

Order Line Grouping

Order Header Group

37-362392

OC_GROUP-NO

Order Line has Stockitem?

Order line has a Stockitem attached

Y

OC_STOCKITEMYN

Order Line ISBN

ISBN reference

9781863733144

OC_ISBN

Order Line ISSN

ISSN reference

2113-3321

OC_ISSN

Order Line Item

Stockitem Order Barcode

I94323

OC_STOCKITEM

Order Line Form

Form Code of the Order item

DVD

OC_FORM

Order Line Stats Code

Stats Code of the Order item

JF

OC_STATS_CODE

Order Line Lib Group

Library Group for Order Line

LIBRARY

OC_LIB_GROUP

Order Line No

Number of the Order Line

4

OC_ORDER_LNO

Order Line Notes

Notes entered in the Order Line

CIP confirmed

OC_NOTES

Order Line Process

Process associated with the Order Line as set in Defaults

ON ORDER

OC_PROCESS

Order Line Publisher

Order Line 3

Penguin, UK 2014

OC_LINE3

Order Line Qty Invoiced

Quantity already invoiced

6

OC_QTY_INVOICED

Order Line Qty Ordered

Quantity already Received

6

OC_QTY_RECEIVED

Order Line Qty Received

Quantity Ordered

12

OC_QTY_ORDERED

Order Line Series

Order Line 4

Animorphs

OC_LINE4

Order Line Subject

Order Line 3

Gold

OC_LINE3

Order Line Tax Account

Tax Account for the Order Line

TAX

OC_TAX_ACCNO

Order Line Tax Code

Tax Code for the Order Line

GST

OC_TAX_CODE

Order Line Tax Rate

Tax Rate for the Order Line

10

OC_TAX_RATE

Order Line Title

Order Line 1

The journey

OC_LINE1

Order Line Total Incl Tax

Local Amount inclusive of Tax

 

OC_TOTAL

Order Line Unit Cost

Cost per Item of the Order Line

20.00

OC_COST

Order Number

Order Number for the Order Header and associated Order lines

4500

OH_ORDER_NO

Order Supplier

Supplier for the Order Header

DYMOCKS

OH_SUPP_NO

Authorities

These reports focus on data from the Authority module of Amlib

Example reports for this module include:

  • New Subject Headings
  • New Genre Headings (655) Tags for promotion
  • New Series Headings from 490 or 440 Tags
  • Authorities with See Also references
  • Subjects with Authority Notes
  • Author list – including 100 and 700 Tags (added Authors)
  • Report on various Files as required

Data Element

Description

Example

Database Name – from

AUTHORITY unless shown

Authority

Created/Modified by

User who created or modified the Authority last

STAFF

AUTH_OPER

Authority Date Modified

Authority Date created or Date modified. Only one date Field in the Authority

22/06/2015

AUTH_DATETIME

Authority Details

Data contained within the Marc Tag

Animals - Fiction

AUTH_MARC

Authority File Date

File Date created or Date modified.

22/06/2015

FILE_DATE

Authority File Description

Description used to Name the File

SCIS 22/06

FILE_DESC

Authority File Entries

The number of entries within the File

121

FILE_QTY

Authority File Number

The unique File Number. This is recommended to pinpoint a particular File

(as the description may not be unique to each File)

3554

FILE_NUMBER

Authority File Operator

File Operator (User name)

STAFF

FILE_OPER

Authority File Operator

Access

Whether other Users are allowed to access the File Y/N

Y

FILE_OPER_ACCESS

Authority Has See Also?

The Authority has See Also references Y/N

Y

AUTH_HAS_SA

Authority Lib Group

Library Group Code associated with the Marc Tag

LIBRARY

AUTH_LIB_GROUP

Authority Note Text

Authority Note that guides the Cataloguer on to when to use the Authority

“Use for descriptive

works on houses”

AUTH_NOTE.AUTH_NOTE_

DATA

Authority Note?

Whether the Tag has an Authority Note Y/N

Y

AUTH_NOTE

Authority Search Key

Search term as held in the database table

MOLLYS REVENGE

AUTH_KEY

Authority Tag Description

Authority Description of the Authority Tag

Subject – Topical Term

TAG_TAGDEF.TT_TAG_DES

C

Authority Tag Indicator 1

First Indicator for the Tag

4

AUTH_IND1

Authority Tag Indicator 2

Second indicator for the Tag

1

AUTH_IND2

Authority Tag No

Authority Tag Number

650

AUTH_TAG_NO

Bibliographic

Useful for getting Bibliographic reports that gives the Catalogue Marc Tags in full. This allows for multiple Subject Headings and notes displaying.

Examples include:

  • New Fiction collection along with the blurb
  • New records with full catalogue display
  • Subject listings for a Department – for example within the Science Department etc.
  • Bibliography showing multiple Authors, including 100 (Main) and 700 (Added) Authors included
  • It is possible to report on a Catalogue File if required which is useful for Subject Lists and Newly received Files through Marc Take Up

Data Element

Description

Example

Database Name - from

CATALOGUE unless shown

Author

Author as shown in the 1st line of the Catalogue Display – usually Author

Winton, Tim, 1960-

CAT_STR1

Author Key

Author as stored by the Database, without punctuation,stopwords and all capitalized

WINTON TIM

CAT_KEY1

Call No

Call No as shown in the Catalogue

B/WIN

CAT_STR4

Call No Key

Call No as stored by the Database without punctuation and all capitalized

B WIN

CAT_KEY4

Catalogue Created By

Amlib Operator who created the Catalogue record

SSTAFF

CAT_CREATE_OPERATOR

Catalogue Date Created

Date the Catalogue record was created

19/01/2015

CAT_CREATE_DATETIME

Catalogue File Date

File Date created or Date modified.

22/06/2015

FILE_DATE

Catalogue File Description

Description used to Name the File

SCIS 22/06

FILE_DESC

Catalogue File Entries

The number of entries within the File

121

FILE_QTY

Catalogue File Number

The unique File Number. This is recommended to pinpoint a particular File (as the description may not be unique to each File)

3554

FILE_NUMBER

Catalogue File Operator

File Operator (User name)

STAFF

FILE_OPER

Catalogue File Operator

Access

Whether other Users are allowed to access the File Y/N

Y

FILE_OPER_ACCESS

Catalogue Indicator 1

Indicator 1 as shown within the Catalogue Data Tag

4

BIBVIEW.INDICATOR1

Catalogue Indicator 2

Indicator 2 as shown within the Catalogue Data Tag

5

BIBVIEW.INDICATOR1

Catalogue Lib Group

Lib Group for the Catalogue record

LIB

CAT_LIB_GROUP

Catalogue Modified By

Catalogue last modified by this Amlib User

JSTAFF

CAT.OPERATOR

Catalogue Ref Number

Catalogue Reference ID

67819

CAT_ NO

Catalogue Tag Data

Data associated with that Marc Tag

978-1-567-24526-8

BIBVIEW.TAG_DATA

Catalogue Tag Description

Description of the Catalogue Tag

Subject – Topical

Term

TT.TAG_DESCRIPTION

Catalogue Tag Number

Catalogue Tag Number

020

BIBVIEW.TAGNO

Catalogue Tag Seq

Catalogue Tag Sequence

24500

BIBVIEW.CATSEQUENCE

Catalogue Updated

Date/Time that the Catalogue was last updated. Default is to show the Date but Time can be formatted to display

29/09/2010

CAT_DATETIME

Non Authority Details

Only appears in Oracle OpenReports version. Non Authority data up to 250

characters

   

Non Authority Details Long

Only appears in Oracle OpenReports version. Non Authority data over 250 characters

   

Publisher

Publisher as shown in the 3rd line of the Catalogue Display – usually Publisher

London, Puffin : 2015

CAT_STR3

Publisher Key

Publisher as shown as stored in the Database, without punctuation and capitalized 

London Puffin 2016

CAT_KEY3

Title

Title as shown in the 2nd line of the Catalogue Display – usually Title

Molly’s revenge

CAT_STR2

Title Key

Title as shown as stored in the Database, without punctuation, stopwords and capitalized

MOLLYS REVENGE

CAT_KEY2

Borrower

Countless Reports can be derived from the Borrower Report Entity. Ideas may include:

  • Borrower joined since a certain date
  • Borrowers with a particular Type, Group or Class
  • Borrowers without email addresses
  • Borrowers with email addresses but Borrower Use Email is set to N
  • Borrowers without email addresses but Borrower Use Email is set to Y
  • Borrowers with a particular Postcode
  • Borrowers with a balance greater that a certain amount
  • Borrowers with Memos
  • Borrowers with a certain Memo Type
  • Borrower where Total Loans counts exceeds a set number (e.g. 1000)
  • List of Borrowers and associated Email address
  • Telephone list
  • Class Lists
  • Status reports – all Borrowers with Status other than OK
  • Registration due to come up in the next month
  • Count by Class, Type etc.

Data Element

Description

Example

Database Name - from

BORROWER unless shown

Borrower Address1 Full

Borrower Address shown as displayed in the Borrower Details Window for the first line of the Address. Usually displays, all the Address lines as well as the Telephone and Postcode, concatenated to one line and split by commas

0345677654 Unit 1,

15 Haddin Way,

Bedford, WA, 6115

BOR_ADDR1_TXT

Borrower Address1 Line1

Borrower Address as shown in the First Address Field of the Borrower – first line.

Unit 4

BORADDR.BA_ADDR1

Borrower Address1 Line2

Borrower Address as shown in the First Address Field of the Borrower – second line

Tiger Lane

BORADDR.BA_ADDR2

Borrower Address1 Line3

Borrower Address as shown in the First Address Field of the Borrower – third line

Chelsea

BORADDR.BA_ADDR3

Borrower Address1 Line4

Borrower Address as shown in the First Address Field of the Borrower – fourth line

Australia

BORADDR.BA_ADDR4

Borrower Address1 Postcode

Postcode as shown in the Postcode Field of the Borrower Address 1

3145

BORADDR.BA_PCODE

Borrower Address1 Telephone

Telephone as shown in the Telephone Field of the Borrower Address 1

0345677654

BORADDR.BA_TELEPHONE

Borrower Address2 Full

Borrower Address shown as displayed in the Borrower Details Window for the second line of the Address. Usually displays, all the Address lines as well as the Telephone and Postcode, concatenated to one line and split by commas for this second address.

0345677654 Unit 1,

15 Haddin Way,

Bedford, WA, 6115

BOR_ADDR2_TXT

Borrower Address2, Line 1

Address 2, Line 1

13 Station St

BORADDR2.BA_ADDR1

Borrower Address2, Line 2

Address 2, Line 2

Bedford

BORADDR2.BA_ADDR2

Borrower Address2, Line 3

Address 2, Line 3

WA 6115

BORADDR2.BA_ADDR3

Borrower Address2, Line 4

Address 2, Line 4

Australia

BORADDR2.BA_ADDR4

Borrower Address2 Postcode

Postcode as shown in the Postcode Field of the Borrower Address 2

 

BORADDR2.BA_PCODE

Borrower Address2 Telephone

Telephone as shown in the Telephone Field of the Borrower Address 2

 

BORADDR2.BA_TELEPHON

E

Borrower Address3 Full

Borrower Address shown as displayed in the Borrower Details Window for the third line of the Address. Usually displays, all the Address lines as well as the Telephone and Postcode, concatenated to one line and split by commas for this second address.

0345677654 Unit 1,

15 Haddin Way,

Bedford, WA, 6115

BOR_ADDR3_TXT

Borrower Address3, Line 1

Address 3, Line 1

13 Station St

BORADDR3.BA_ADDR1

Borrower Address3, Line 2

Address 3, Line 2

Bedford

BORADDR3.BA_ADDR2

Borrower Address3, Line 3

Address 3, Line 3

WA 6115

BORADDR3.BA_ADDR3

Borrower Address3, Line 4

Address 3, Line 4

Australia

BORADDR3.BA_ADDR4

Borrower Address3 Postcode

Postcode as shown in the Postcode Field of the Borrower Address 3

 

BORADDR3.BA_PCODE

Borrower Address3 Telephone

Telephone as shown in the Telephone Field of the Borrower Address 3

 

BORADDR3.BA_TELEPHON

E

Borrower Area Code

Borrower Area code

NW

BORADDR.BA_AREA_CD

Borrower Area Code Details

Borrower Area Description of Code

North West

AREA.AREA_NAME

Borrower Balance

Balance of money owing

24.00

BOR_OWING

Borrower Barcode

Barcode or ID of Borrower

B24256

BOR_BAR_NO

Borrower Class

Borrower Class Code

RM9

BOR_CLASS

Borrower Class Details

Class Code description

Room 9 – Mr Evans

BORCLASSES.BC_NAME

Borrower Count

Count of Borrower depending on the Filter used

25

#Function#

Borrower Date of Birth

Borrower Date of Birth (Format can be altered for the report)

21/03/1981

BOR_DOB

Borrower Email

Borrower Email address

Steven.evans@iinet.

net.au

BOR_EMAIL

Borrower Exclude from Debt Collection

Borrower exclude from Debt Collection setting Y/N

N

BOR_DC_EXCLUDE

Borrower File Date

File Date created or Date modified.

22/06/2015

FILE_SET_NAMES.FILE_DAT

E

Borrower File Description

Description used to Name the File

Admin Load 22/06

FILE_SET_NAMES.

FILE_DESC

Borrower File Entries

The number of entries within the File

121

FILE_SET_NAMES.FILE_QTY

Borrower File Number

The unique File Number. This is recommended to pinpoint a particular File (as the description may not be unique to each File)

3554

FILE_SET_NAMES.

FILE_NUMBER

Borrower File Operator

File Operator (User name)

STAFF

FILE_SET_NAMES.

FILE_OPER

Borrower File Operator Access

Whether other Users are allowed to access the File Y/N

Y

FILE_SET_NAMES.

FILE_OPER_ACCESS

Borrower File Date

File Date created or Date modified.

22/06/2015

FILE_SET_NAMES.FILE_DAT

E

Borrower Full Name- Given, Surname

Concatenated Borrower Given and Surnames in one string

Tom Strange

#Function#

Borrower Full Name- Surname, Given

Concatenated Borrower Surname and Given Name

Strange, Tom

#Function#

Borrower Gender

Borrower Sex/Gender

F

BOR_SEX

Borrower Given Name

Borrower Given Name

Steven

BOR_GIVEN

Borrower Group

Borrower Group Code

GOLD

BOR_GROUP

Borrower Group Details

Description of Borrower Group Code

GOLD FACTION

BORGROUPS.BG_NAME

Borrower Guardian address

Borrower Guardian address as shown in Address 3

Mr Taylor, 19 The Crescent, Maylands

WA 2522.

BOR_ADDR3_TXT

Borrower Initial

Initial for Middle Name

T.

BOR_INIT

Borrower Joined Date

Date that Borrower joined the Library (format can be altered within the report)

24/05/2013

BOR_START_MSHIP

Borrower Joined Location

Location Code - where Borrower joined the Library

CHEL

BOR_START_LOCATION

Borrower Joined Location

Details

Location Description of the Code - where Borrower joined the Library

Chelsea

LIB_LOCATIONS31.LL_NAM

E

Borrower Last Active

Date that Borrower last entered barcode for Circulation / Visit (Barcode was entered)

21/05/2015

BOR_LASTACTIVE

Borrower Last Status Update

Status last modified

21/11/2014

BOR_STATUS_DATE

Borrower Last Updated

Last time the Borrower Details were saved. Default is to show the date but time can be used to format differently

21/11/2014

BOR_DATETIME

Borrower Lib Group

Library Group for Location

LIB

BOR_LIB_GROUP

Borrower Loans Count

Borrower Total Loans as shown in the Borrower History

5

BOR_NO_ LOANS

Borrower Location

Current Location of Borrower

CHEL

BOR_LOCATION

Borrower Location Details

Description of Current Borrower Location

Chelsea Public

Library

LIB.LOCATIONS31.LL_NAM

E

Borrower Memo Date

Memo Date of Borrower’s Memo. Format can be altered within report

22/04/2014

BOR_MEMOS.BM_EFF_DA

TE

Borrower Memo Details

Memo Text of Borrower’s Memo

Left umbrella

LIB_MEMOS.LM_DESC

Borrower Memo Type

Memo Type for Borrower’s Memo

ADDRESS

BOR_MEMOS.BM_TYPE

Borrower Memo Type Details

Description for Borrower Memo Type

Change of Address

required

LIB_MEMOS.LM_DESC

Borrower Mobile Number

Mobile Telephone Number of Borrower

0411889933

BOR_MOBILE_TEL

Borrower PIN

Personal Identifier Number for Borrower

9999

BOR_PIN

Borrower Ref1

Data entered in Reference1 Field of Borrower. Free Text field and label can be altered through Supervisor, Installation Parameters

Page 264

Registration Book

BOR_REF1

Borrower Ref2

Data entered in Reference2 of Borrower. Free Text field and label can be altered through Supervisor, Installation Parameters

HILTOM

BOR_REF2

Borrower Registration Date

Date set for Borrower Registration

22/09/2017

BOR_REGDATE

Borrower Status

Borrower Status as currently shown within Borrower

OK

BOR_STATUS

Borrower Suburb Code

Suburb Code

BED

BA_SUBURB_CD

Borrower Suburb Code Details

Description of Suburb Code

Bedford

SUBURB.SUBURB_NAME

Borrower Surname

Borrower Surname or Family name

SMITH

BOR_SURNAME

Borrower Title

Title if given within Borrower Details

MR

BOR_TITLE

Borrower Total Renews

Number in total of Renewal as shown in Borrower History

24

BOR_NO_RENEWS

Borrower Total Reserves

Number in total of Reserves as shown in Borrower History

33

BOR_NO_RESERVES

Borrower Total Loans

Number in total of Loans as shown in Borrower History

1919

BOR_NO_LOANS

Borrower Total Visits

Number in total of Visits (Barcode used within Circulation tasks) as shown in Borrower History

50

BOR_NO_VISITS

Borrower Type

Borrower Type Code

A

BOR_TYPE

Borrower Type Details

Description given to Borrower type Code

Adult

BOR_TYPES.BT_NAME

Borrower Use Email

Borrower Use Email within Reports Y/N?

Y

BOR_USE_EMAIL

Borrower Use Mobile

Borrower Use Mobile within Reports Y/N

N

BOR_MOB_USFN

Borrower Ward Code

Ward Code of Borrower

SP

BA_WARD_CD

Borrower Ward Code Details

Description of Ward Code

South Perth

WARD.WARD_NAME

Borrower Addresses

The Headings that display in the Borrower Address Fields can be customised within Supervisor For example, first Address could be Postal

Counter

Enables a Count to be made of the Group Data Fields

Data Element

Description

Example

Database Name

Group Details Count

Include this field in your Display Fields and the report will contain a count of items per field(s) in the Group Fields

22

#Function#

There are different Entities as associated Data Fields to use depending on whether your Database is running Single or Double Financials To check whether you are running Single or Double entry Financials:

  1. Launch the Amlib client
  2. Go to Main > Supervisor > Installation – the Installation (DEFAULT) screen will display
  3. Select the System tab
  4. Scroll down and check the following setting: Use Double Entry Accounting
  5. If set to N, then your system is set to single-entry accounting
  6. If set to Y, then your system is set to double-entry accounting

Borrower financial - Double entry

Field names alter depending on whether the transactions for Borrower Financials are on a Double entry or Single entry. The Fields below are for Double entry only. This table can be combined with Borrower to get the details of Financial Transactions

A Special View (Financial Link View) of the database allows separate access to the Double and Single Financial Transactions

A Special View (Financial Link View) of the database allows separate access to the Double and Single Financial Transactions Samples of reports

  • Borrowers still owing money
  • Transactions over a date period
  • Receipt Nos associated with payments

Data Element

Description

Example

Database Name

From Special View created as Financial link View

DTransaction Amount Owing

Amount owing from the transaction

20.00

FINANCIALLINKVIEW.OUTSTANDING

DTransaction Borrower Name

Borrower Name as shown in the Transaction

 

FINANCIALLINKVIEW.BORROWERNAME

DTransaction Charge Amount

Debit transaction amount

30.00

FINANCIALLINKVIEW.VALUE

DTransaction Comments

Comments associated with the transaction

 

FINANCIALLINKVIEW.COMMENTS

DTransaction Credit or Debit

Whether the transaction was a CR - Credit (payment) or DB - Debit (charge)

CR

FINANCIALLINKVIEW.CRDB

DTransaction Date

Date for the Transaction – Format can be altered within the report

15/04/2015

FINANCIALLINKVIEW.DATEENTERED

DTransaction Invoice Date

Date for the Invoice

13/04/2015

FINANCIALLINKVIEW.INVDATE

DTransaction Invoice Number

Invoice Number included in the Transaction

13667

FINANCIALLINKVIEW.INVNUMBER

DTransaction Item Barcode

Associated Stockitem barcode for transaction

 

FINANCIALLINKVIEW.ITEMBARCODE

DTransaction Item Title

Associated Stockitem Title for transaction

The high tide

FINANCIALLINKVIEW.ITEMTITLE

DTransaction Last Modified

Date the Transaction was modified

13/04/2015

FINANCIALLINKVIEW.DATEMODIFIED

DTransaction Location

Location Code at which Transaction occurred

Chelsea

FINANCIALLINKVIEW.LOCATION

DTransaction Location Details

Description of Transaction Location Code

Chelsea Public

Library

LIBLOCATIONS16 - LLNAME

DTransaction Paid

Paid amount

10.00

FINANCIALLINKVIEW.PAID

DTransaction Paid Calculation

Paid amount Amount paid calculation

20.00

#Function#

DTransaction Quantity

Quantity of items/days

30

FINANCIALLINKVIEW.QTY

DTransaction Receipt No

Receipt Number of payment

76544

FINANCIALLINKVIEW.RECEIPTNUMBER

DTransaction Type

Transaction Type Code

FINE

FINANCIALLINKVIEW.TYPE

DTransaction Type Details

Description of Transaction Type Code

OVERDUE FINE

FINTYPES.FIN_DESC

Borrower financial – Single entry

There is a special Data element of “Transaction Amount Owing which can be useful for Filtering

Samples of reports

  • Borrowers still owing money
  • Transactions over a date period
  • Receipt Nos associated with payments

Data Element

Description

Example

Database Name - from

FIN_TRANS unless shown

Transaction Amount Owing

Amount owing from the transaction

20.00

#Function#

Transaction Borrower Name

Borrower Name as shown in the Transaction

Smith, Julian

FIN_NAME

Transaction Charge Amount

Debit transaction amount

30.00

FIN_VALUE

Transaction Comments

Comments associated with the transaction

Renewed item was

overdue

FIN_COMMENTS

Transaction Credit or Debit

Whether the transaction was a CR - Credit (payment) or DB -

Debit (charge)

CR

FIN_CR

Transaction Date

Date for the Transaction – Format can be altered within the report

15/04/2015

FIN_DATE

Transaction Invoice Date

Date for the Invoice

13/04/2015

FIN_INV_DATE

Transaction Invoice Number

Invoice Number included in the Transaction

13667

FIN_INV_NO

Transaction Item Barcode

Associated Stockitem barcode for transaction

I89321

FIN_ITEM

Transaction Item Title

Associated Stockitem Title for transaction

The high tide

FIN_TITLE

Transaction Last Modified

Date the Transaction was modified

13/04/2015

FIN_DATE_MOD

Transaction Location

Location Code at which Transaction occurred

Chelsea

FIN_LOC

Transaction Location Details

Description of Transaction Location Code

Chelsea Public Library

LIBLOCATIONS4.LLNAME

Transaction Paid

Paid amount

10.00

FIN_PAID

Transaction Quantity

Quantity of items/days

30

FIN_QTY

Transaction Receipt No

Receipt Number of payment

76544

FIN_RECEIPT

Transaction Type

Transaction Type Code

FINE

FIN_TYPE

Transaction Type Details

Description of Transaction Type Code

OVERDUE FINE

FIN_TYPES.FIN_DESC

Borrower history

Borrower History allows the reporting of items associated with Borrowers through History. Once selected it is possible to also select from the Borrower Entity. These reports will only work if the READING history is kept. Many sites use the RETURN history instead which actually comes from the Stockitem History so it maybe preferable to use Stockitem History to get the results required

Samples may include

  • List of Items issued by a Class
  • Count of items issued by a Borrower Type
  • Borrowers activity between a date range
  • List of Accounts sent through Report History

Data Element

Description

Example

Database Name

BOR_HISTORY – unless shown

Borrower History

Comments

Comment recorded within History

“980393755 Mindpower : set your sights on

success”

BH_COMMENTS

Borrower History Date

Date as displayed in History Table. **Note: Date and time element

6 March 2015 9:00AM

BH_DATE

Borrower History Title

Item Title

The Gift Horse

STK_TITLE

Borrower History Type

There are choices of Borrower history types

ACCOUNT,ACCT, CLAIMRET, READING,

RESADV, RESCANC

BH_TYPE

**Note: Date and time element. When Filtering with a Date that also includes a time, it is better to use a range of DateS rather than an equal.

For example Borrower History Date >= 15/04/2015 AND Borrower History Date < 16/04/2015 rather than Borrower History Date = 15/04/2015 so that all time periods are correctly accounted

Catalogue

There is no separate Catalogue Entity - To get Catalogue information use the Bibliographic Entity as the Date Catalogue created is included within that Entity and this entity gives much more scope for display.

Current loans

Loans are accessed from the Borrower Entity and Stockitem Entity to get the details required. For example Issue Date and Issue Date Due are in the Stockitem Entity

Data Element

Description

Example

Database Name

LOANS.VIEW – unless shown

Item Issue Date

Date the item was issued

12/02/2015. Can include Time element if

Format set

STK_ISS_DATE

Item Issue Due Back

Date

Date the item is due for return

12/03/2015

STK_ISS_DUE

Item Issue Location

Location Code at which the Issue transaction took place

CHEL

STK_ISS_LOC

Item Issue Location

Details

Description of the Location Code where the Issue took place

Chelsea Public Library

LIB_LOCATIONS.LL_NAME

Item Issue Times

Renewed

   

STK_ISSUE_RENEWED

Item Issue Type

How the Issue was processed – Hourly, Overnight, Daily, Term, Semester, Yearly

D

STK_ISSUE_TYPE

OPAC requests or suggests

These requests are derived from NetOpacs and/or OpenOPAC. This Report Type is from the Supervisor/Opac Suggests Table and can include the Request details and the Library Response

Data Element

Description

Example

Database Name

OPAC_USER_COMMENTS unless shown

OPAC Accept Cost

Whether patron will accept cost Y?N

N

OUC_COSTACCEPT

OPAC Author

Details entered on Line 2 of the form – usually Author

 

OUC_LINE2

OPAC Call No

Details entered on Line 6 of the form – usually Call No

 

OUC_ LINE6

OPAC Comments

Comments entered for the request

 

OUC_COMMENTS

OPAC Date

Date of the request

 

OUC_DATE

OPAC Estimated Cost

Estimated cost of the request

 

OUC_ESTCOST

OPAC Form code

Form code of the item requested

DVD

OUC_FORM

OPAC ISBN

ISBN of the item requested

 

OUC_ISBN

OPAC Library Response

Notes given by the Library Staff as a response

Your request has been received. We will respond by

the end of the week

OUCR_LIBRESPONSE

OPAC Location

Location Code of the Request

CHEL

OUC_LOCATION

OPAC Location Details

Location Description of the Code from the Request

Chelsea Public Library

LIBLOCATIONS8.LL_NAME

OPAC Notes

Notes from the Request

Urgent request

OUC_NOTES

OPAC Publisher

Details entered on Line 6 of the form – usually Call No

Penguin, London

OUC_LINE3

OPAC Reply Date

Reply date of the response given by Staff

Not used 15/06/2015

OUCR_DATE

OPAC Reply Type

Reply type of the response given by Staff

Not used

OUCR_TYPE

OPAC Series

Details entered on Line 4 of the form – usually Series

Animorphs

OUC_LINE4

OPAC Subject

Details entered on Line 5 of the form – usually Subject

Family - Fiction

OUC_LINE5

OPAC Title

Details entered on Line 1 of the form – usually Type

Breathe

OUC_LINE1

OPAC Type

Request details: All are Item now so not used

Item, Borrower or Opac.

OUC_TYPE

Periodicals

Periodicals have 4 main levels all of which are available under the Periodical Master Headings:

  • Main Periodical
  • Subscription
  • Issue details
  • Copy details Useful reports include:
  • Current Periodicals with a current Subscription
  • Issues with a Claim
  • Cost of Subscription for each Periodical
  • List of Main Titles
  • Issues associated with a certain Periodical
  • Renewals due in the next 3 months
  • Items received since a certain date

Data Element

Description

Example

Database Name

Periodical Call No

Call No as shown on the Copies window

REF PER NAT

PER_COPY.PC_CALL_NO

Periodical Circulation List

Circulation List

1234

PER_SUBS.PS_CIRC_LIST

Periodical Copies Due

The Number of Copies of Issues Due still due, on the Subscriptions/Issues window of Amlib

1

PER_ISSUES.PI_QTY_SUB

Periodical Copies Per Issue

The Number Copies Issues Due in total. This can be seen on the Subscriptions window

2

PER_SUBS.PS_QTY_DUE

Periodical Copies Received

The Number Issues Received. This can be seen on the Subscriptions/Issues window of Amlib

1

PER_ISSUES.PI_QTY_RECD

Periodical Copy Barcode

Barcode of the Stockitem received from Periodical

I984332

PER_COPY.PC_STK_ITEM_NO

Periodical Copy Title

Copy Description as shown in the Periodical Module (Issue Details)

Volume 49 Index No 1-

4 Supplement to

Reading Time Vol 50 No

1 2006

PER_COPY.PC_DESCRIPTION

Periodical Date Recd

Date that the copy was received

12/03/2015

PER_COPY.PC_DATE_RECD

Periodical Description

Description of the Issue

Vol 1. No 16, July 2015

PER_ISSUES.PI_DESCRIPTION

Periodical Form Code

Form Code as set in Stock Defaults

PER

PERIODICAL.PER_STK_FORM

Periodical Frequency

Frequency for the Periodical Subscription

M

PERIODICAL.PER_FREQ

Periodical ISSN

ISSN as shown on the Periodical

6554-1223

PERIODICAL.PER.ISSN

Periodical Issue Catalogue

Catalogue Reference attached to a Periodical Issue

389112

PER_ISSUES.PI_CAT_REF

Periodical Issue Claim

Where a Claim has been made against an Issue Y/N

N

PER_ISSUES.PI_CLAIM

Periodical Issues Per Subs

The Number of Issues for each Subscription

12

PER_SUBS.PS_QTY_ISSUES

Periodical Item Stats Code

Form Code as set in Stock Defaults

JPER

PERIODICAL.PER_STATS_CODE

Periodical Main Title

The Title given to the Main Periodical Details

Better homes and

gardens

PERIODICAL.PER_TITLE

Periodical Subs Comments

Comments related to the Subscription

Trial in 2015

PER_SUBS.PS_COMMENTS

Periodical Subs Cost

Cost for the Subscription

144.00

PER_SUBS.PS_COST

Periodical Subs Cost per Issue

Subscription cost per Issue as calculated by the No of Issues

and Subscription cost

12.50

PER_SUBS.PS_COST_ISSUE

Periodical Subs End Date

The final date for the Subscription

31/12/2015

PER_SUBS.PS_END_DATE

Periodical Subs Lib Group

The Library Group for the Subscription

LIB

PER_SUBS.PS_LIB_GROUP

Periodical Subs Location

The Location Code for the Subscription

CHEL

PER_SUBS.PS_LL_CODE

Periodical Subs Location Details

The Description given to the Location Code of the

Subscription

Chelsea Public Library

LIB_LOCATIONS7.LL_NAME

Periodical Subs Renewal Date

The Renewal Date given to the Subscription

15/11/2015

PER_SUBS.PS_RENEW_DATE

Periodical Subs Start Date

The beginning date of the Subscription

01/01/2015

PER_SUBS.PS_START_DATE

Periodical Subs Supplier

The Supplier Code for the Subscription

CNEW

PER_SUBS.PS_SUPP_NO

Periodical Supplier Details

The Description given to the Supplier Code

Chelsea Newsagent

PER_SUPPLIER.PS_COMPANY

RESERVATIONS

Can combine with Borrower to get the current reservations and reservation statuses

  • Reservations with status of Printed - Printed several days ago but not collected
  • Reservations with status of Return
  • Reservations placed at a location
  • Reservations to be collected at a location
  • Reservations by an individual
  • Counts of Borrowers - No of reservations determined by the filter
  • Counts of Items - No of reservations determined by the filter
  • Reservation Placed in the past week/month etc.
  • Reservations passed the Expiry date
  • Queue No of individuals

Data Element

Description

Example

Database Name – Reservations Table

unless shown otherwise

Reservation All or First

Whether Reservation was placed for all copies or the first copy only F - First/A-All

F

RES_ALL_OR_FIRST

Reservation Collection Location

Location code at which the Reservations will be collected

CHEL

RES_COLL_LOCATION

Reservation Collection Location Details

Location Description assigned to the code at which the Reservations will be collected

Chelsea Public

Library

LIB_LOCATIONS91.LL_NAME

Reservation Date Placed

Date the reservations were placed

12/05/2015

RES_DATE

Reservation Expiry Date

Date the reservations expired (set by Supervisor/Installation parameters)

19/05/2015

RES_EXPIRY

Reservation Item Title

Item Title for the Reservation

Breath

RESERVATIONSTOCKITEMVIEW.STK_LINE1

Reservation Placed Location

Location code at which the Reservations were placed

CHEL

RES_PLACED_LOC

Reservation Placed Location Details

Location Description assigned to the code at which the Reservations were placed

Chelsea Public

Library

LIB_LOCATIONS9.LL_NAME

Reservation Position in Queue

Queue position for the reservation. Generally in sets of 5 (5,10,15 etc)

10

RES_PRIORITY

Reservation Status

Status of Reservation: ILLS, ON LOAN, ORDER, PRINTED, RETURN, SHELF, TRANSFER

PRINTED

RES_STATUS

Reservation User Placed

Amlib Operator who placed the reserve

STAFF

RES_WHO_PLACED

STATISTICS

Statistics can be shown effectively as graphs

  • Issues per month for the last year
  • All activity this Financial year

Data Element

Description

Example

Database Name – STATS unless

shown otherwise

Statistics Borrower Area

Borrower Area Code at the time of the Statistics collection

Metro

STATS_AREA_CD

Statistics Borrower Area Details

Description of the Area Code

Metropolitan

AREA.AREA_NAME

Statistics Borrower Class

Borrower Class Code at the time of the Statistics collection

Rm5

STATS_BOR_CLASS

Statistics Borrower Class Details

Description of the Class Code

Room 5 – Mr Davies

BORCLASSES.BC_NAME

Statistics Borrower Group

Borrower Group Code at the time of the Statistics collection

E

STATS_BOR_GROUP

Statistics Borrower Group Details

Description of the Class Code

Endeavour

BORGROUPS.BG_NAME

Statistics Borrower Suburb

Borrower Suburb Code at the time of the Statistics collection

BEL

STATS_SUBURB

Statistics Borrower Suburb Details

Description of the Suburb Code

Belmont

SUBURBS.SUBURBS_NAME

Statistics Borrower Type

Borrower Type Code at the time of the Statistics collection

A

STATS_BOR_TYPE

Statistics Borrower Type Details

Description of the Borrower Type Code

Adult

BORTYPES.BT_NAME

Statistics Borrower Ward

Borrower Ward Code at the time of the Statistics collection

NW

STATS_WARD

Statistics Borrower Ward Details

Description of the Borrower Ward Code

North West Metro

WARDS.WARD_NAME

Statistics Count

Count calculated brought back from the Database

215

STATS_COUNT

Statistics Day 0123456

Day of collection of statistics 0 Sunday, 1 Monday etc.

1

STATS_DAY

Statistics Hour 0 24

Hour of collection of statistics in 24 hour format

12

STATS_HOUR

Statistics Item Form

Item Form Code at the time of the Statistics collection

DVD

STATS_STK_FORM

Statistics Item Stats Code

Item Stats Code at the time of the Statistics collection

AF

STATS_STK_CODE

Statistics Item Stats Code Details

Description of the Item Stats Code

Adult Fiction

STK_CODES.STATS_STK_CODE00

Statistics Location

Location Code where the Statistics were collected

LIB

STATS_LL_CODE

Statistics Location Details

Description of the Location Code where statistics collected

Chelsea Public

Library

LIB_LOCATIONS.LL_NAME

Statistics Money Amount

Money amount collected

15.00

STATS_MONEY

Statistics Month 0 12

Month of collection of statistics 1 – January to 12 December

IN 10,11,12

STATS_MONTH

Statistics Transaction Date

Date of collection of statistics by specific date

< 31/12/2015

STATS_DATE

Statistics Type 05 06 etc.

Number used for collection of Statistics. See Supervisor, Stats Params (05 – Issues, 06 – Renewals etc.)

05

STATS_TYPE

Statistics Type Details

Description used for Stats parameters

Issues

STATS_CODES.STATS_DESCRIPTION

Statistics Year 2014 etc.

Year of collection of statistics

2015

STATS_YEAR

STOCK HISTORY

Stock History relates to the Item History and provides information in relation to the History set in each Stockitem. This entity can be used in relation to the Stockitem Entity to get the necessary Data Fields such as Title, Call No etc. It can also be used in relation to Borrower to get the Name, Borrower Type, Class etc. as required.

Example of reports could include:

  • History of a particular item
  • History by Borrower Type
  • History by Item Type
  • History filtered by the History Type

Data Element

Description

Example

Database Name – uses

STK_HISTORY Table unless shown otherwise

Stock History Borrower Barcode

Borrower Barcode for the History Transaction

B44332

SH_BOR_NO

Stock History Comments

Comments recorded for the History transaction

Circ issue at VIC by IS1 to

RICCI, DEANNE Due: 06/11/2007 11:59 PM

SH_COMMENTS

Stock History Date

Date of the History transaction. It is possible to alter the Format of this to include the hour and minutes as this is kept by the History

dd/mm/yyyy 22/08/2015 dd/mm/yyyy hh:mm tt

22/08/2015 09:54 AM

SH_DATE

Stock History Item

Item Barcode for the History Transaction

I33442

SH_STK_ITEM_NO

Stock History Type

The History Type available includes ORDER, PRICE, TRANSFER, RENEW, RETURN, ISSUE, INHOUSE, RES.HIST

ISSUE

SH_TYPE

STOCKITEMS

From simple lists to complex lists there are many possibilities. For example Items with a Process code showing the cost

There are huge numbers of reports that can be gained using Stockitem on its own or in combination with other Entities – for example with Borrower, History, Reservations etc.

  • New items
  • Items with Call Set
  • Items with Cost
  • Items with a specific Process, Form, Stats Code etc.
  • Items at a particular Location
  • Items without a Catalogue Reference
  • Items Count by Form
  • Items Count by Stats Code
  • Items On Loan
  • Items Not on Loan
  • On Order items
  • Overdue List
  • Overdue list of Items issued by a Class or Type
  • Items on loan
  • Items on loan by Class or Type
  • ILL items on loan
  • Overdue ILL
  • Items issued from a particular Location
  • Items issued on a particular Day
  • Items due back on a particular Day
  • Shelf list of items overdue

Data Element

Description

Example

Database Name – uses STK_ITEM Table

unless shown otherwise

Item Author

Stock Line 2 of Stockitem Display – usually Author

Winton, Tim.

STK_LINE2

Item Barcode

Item Barcode as shown on the Stockitem window

I635589

STK_ITEM_NO

Item Call No

Stock Line 6 of Stockitem Display – usually Call No

F WIN

STK_LINE6

Item Call Set

Item Call Set as set via the Call Set Table

FOLK

STK_CALL_SET

Item Call Set Details

Description of the Call set as set on the Call Set Table

Folktales

STK_CALL_SETS.SC_DESC

Item Catalogue Reference

Catalogue reference attached to the Stockitem

139032

STK_CAT_REF

Item Convert Value

Item Convert Value as shown on the Stockitem Window.

This Field can have a different Heading as set in Supervisor/Installation

Signed by Author

STK_CONVERT_VALUE

Item Cost

Item Current Cost as shown in the Stockitem Window

25.50

STK_COST

Item Date Accessioned

Date accessioned as shown in the Stockitem Window

12/05/2015

STK_DATE_ACC

Item Date Modified

Date the item was last modified

01/01/2015

STK_DATETIME

Item Date Received

Date the item was received

31/12/2015

STK_DATE_RECD

Item Description

Item Description Value as shown on the Stockitem

Window. This Field can have a different Heading as set in Supervisor/Installation

Part of a Big Book set

STK_DESCRIPTION

Item Edition

Edition Field as shown on the Stockitem window.

Sometimes shows the Year of publication

2nd ed.

STK_EDITION

Item File Date

File Date created or Date modified.

22/06/2015

FILE_SET_NAMES1.FILE_DATE

Item File Description

Description used to Name the File

Admin Load 22/06

FILE_SET_NAMES1. FILE_DESC

Item File Entries

The number of entries within the File

121

FILE_SET_NAMES1.FILE_QTY

Item File Number

The unique File Number. This is recommended to pinpoint a particular File (as the description may not be unique to each File)

3554

FILE_SET_NAMES1. FILE_NUMBER

Item File Operator

File Operator (User name)

STAFF

FILE_SET_NAMES1. FILE_OPER

Item File Operator Access

Whether other Users are allowed to access the File Y/N

Y

FILE_SET_NAMES1. FILE_OPER_ACCESS

Item Floor Location

Floor location as shown on the Stockitem window

Map drawer

STK_LOC_FLOOR

Item For Loan?

Whether the item is allowed to be loaned or not. Y/N

N

STK_FOR_LOAN

Item Form

Item Form Code as currently set. Usually the basis for the Loan parameters

LP

STK_FORM

Item Form Details

Description of the Item Form Code

Large Print Book

STK_FORMS.STK_FORM_DESC

Item is on Loan?

Whether the item is on loan or not. Y/N

Y

STK_IS_ON_LOAN

Item is on Order?

Whether the item is on Order. Y/N

N

STK_IS_ON_ORDER

Item is on Reserve?

Whether the item is reserved. Y/N

Y

STK_IS_RESERVED

Item Last Active Date

Date of last active Circulation activity

12/05/2015

STK_LAST_ACTIVE

Item Last Depreciation

Date

Date of the last depreciation process

30/06/2015

STK_LAST_DEP

Item Library Group

Library Group related to the permanent Location

LIB

STK_LIB_GROUP

Item Loan Type

Item Loan Type if this applies. This is set on the Stockitem window and overwrites normal borrowing privileges

OV

STK_LOAN_TYPE

Item Memo Date

Item Memo Date created

23/06/2015

STK_MEMOS.SM_EFF_DATE

Item Memo Details

Item Memo Details contained in the Memo

Item is damaged. Repair

on return

STK_MEMOS.SM_DATA

Item Memo Type

Memo Type from Supervisor/Memo Types Table used by Item

SBARCODE

STK_MEMOS.SM_TYPE

Item Memo Type Details

Memo Type Description from Supervisor/Memo Types Table for the Memo Type

System change barcode

rule

LIB_MEMOS1.LM_DESC

Item Original Cost

Original Cost as set in Stockitem/History

15.00

STK_ORIG_COST

Item Perm Location

Permanent Location Code currently assigned to the item

CHEL

STK_LOC_PERM

Item Perm Location Details

Description of the Permanent Location Code

Chelsea Public Library

LIB_LOCATIONS122.LL_NAME

Item Process Code

Process or Status Code as set on the Stockitem window

MISSING

STK_PROCESS

Item Process Date

Date the process was assigned to the Stockitem

01/01/2013

STK_PROCESS_DATE

Item Publisher

Line 5 of the Stockitem Display – usually Publisher

London : Penguin, 2019.

STK_LINE5

Item Series

Line 4 of the Stockitem Display – usually Series

Animorphs v6.

STK_LINE4

Item Show in Opac?

Whether the Stockitem can be displayed in Opac Y/N

Y

STK_OPAC_SHOW

Item Source

The Origin Code of the Stockitem. Some sites use this to populate a Supplier or funding

DYM

STK_ITEM_ORIGIN

Item Stats Code

The Stats Code of the Stockitem

JF

STK_ITEM_STATS

Item Stats Code Details

The description of the Stockitem Stats Code

Junior Fiction

STK_CODES.STK_CODE_DESC

Item Stocktake Date

The date of the last Stocktake as shown in Stockitem History/Stocktake

01/12/2014

STK_LAST_TAKE

Item Subject

Line 3 of the Stockitem Display – usually Subject. Note that the Stockitem only shows 1 of the Subjects from the Catalogue

Family - Fiction

STK_LINE3

Item Temp Location

The Temporary Location Code that is displayed on the Stockitem window

ARM

STK_LOC_TEMP

Item Temp Location Details

The description of the Temporary Location Code

Armadale Public Library

LIB_LOCATIONS121.LL_NAME

Item Times Borrowed Total

The number of times borrowed since the beginning or since Period set as displayed in the Stockitem History

360

STK_TIMES_BORROWED

Item Times Renewed Total

The number of times renewed since the beginning or since Period set as displayed in the Stockitem History

24

STK_TIMES_RENEWED

Item Times Reserved Total

The number of times reserved since the beginning or since Period set as displayed in the Stockitem History

29

STK_TIMES_RESERVED

Item Title

The Main Title of the item

Black horse island

STK_LINE1

Item Type

Whether the Item is a Normal item, a Master or a Subsidiary. Note: Master and Subsidiary items are usually given to Kits and their Contents

Normal

STK_ITEM_TYPE

Item Volume

The Volume as shown on the Stockitem. This is sometimes set to the Series No

V22

STK_VOLUME