ABSTRACTS
Name |
Type (Size) |
Description |
ABSTRACT |
VARCHAR(2000) |
Abstract |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
ORDSEQ |
NUMBER |
Order sequence of the abstract |
RECNO |
NUMBER |
Record number of catalogue record with abstract |
ROW_ID |
NUMBER |
Unique row number - system generated |
ARRAY_LIST
Name |
Type (Size) |
Description |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
ITEM |
VARCHAR(100) |
Item value in the array (managed) list |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
NAME |
VARCHAR(50) |
Array (managed) list name |
ORDSEQ |
NUMBER |
Order sequence of the array (managed) list |
AUTHORITY_FILE
Name |
Type (Size) |
Description |
CALLNO |
VARCHAR(100) |
Call number assigned to term |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
MARC |
VARCHAR(255) |
USMARC format of thesaurus term |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
REFERENCE |
NUMBER |
Unique reference number of thesaurus term |
SCOPE_NOTES |
VARCHAR(2000) |
Note to clarify meaning or application of term |
TYPE |
VARCHAR(30) |
Thesaurus entry type - Subject, Author, Series |
USED_BY |
NUMBER |
Number of hits |
VERIFIED |
VARCHAR(5) |
Whether term is verified - Y or N |
WORD |
NOT NULL, UNIQUE, VARCHAR(255) |
Subject, Author, Series term |
AUTHORITY_LINKS
Name |
Type (Size) |
Description |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
ORDSEQ |
NUMBER |
Order sequence of related terms |
PARENT_REF |
NUMBER |
Reference number of parent thesaurus term |
RECNO |
NUMBER |
Record number of Catalogue record with Link |
REFERENCE |
NUMBER |
Reference number of related thesaurus term |
ROW_ID |
NUMBER |
Unique row number – system generated |
TYPE |
VARCHAR(30) |
Thesaurus Entry Type - Subject, Author, Series |
TERM_TYPE |
VARCHAR(10) |
Narrower Term, Broader Term, Related Term, Use or Use For |
AUTHORITY_MARC
Name |
Type (Size) |
Description |
DATA |
VARCHAR(255) |
USMARC form of thesaurus term |
FIELD_NAME |
VARCHAR(50) |
USMARC tag |
INDICATOR |
VARCHAR(10) |
Indicator associated with the USMARC form of thesaurus term |
REFERENCE |
NUMBER |
Reference number of USMARC form of thesaurus term |
ROW_ID |
NUMBER |
Unique row number – system generated |
SUB_FIELD |
VARCHAR(50) |
USMARC sub field |
BINDING
Name |
Type (Size) |
Description |
CALLNO |
VARCHAR(100) |
Call number assigned to bound volume |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
INSTRUCTIONS |
VARCHAR(2000) |
Binding instructions |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
ORDSEQ |
NUMBER |
Order sequence of binding instructions |
RECNO |
NUMBER |
Unique record number – system generated |
ROW_ID |
NUMBER |
Unique row number – system generated |
RUBNO |
VARCHAR(100) |
Number assigned by binder |
BORROWER_LINKS
Name |
Type (Size) |
Description |
ADDRESS |
VARCHAR(500) |
Universal resource locator |
CATEGORY |
VARCHAR(30) |
Link category |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
DATE_VERIFIED |
DATE |
Date link is verified for web display |
LINK_TYPE |
VARCHAR(30) |
Universal resource locator stem |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
NOTES |
VARCHAR(2000) |
Link notes |
RECNO |
NUMBER |
Unique record number of associated catalogue record |
ROW_ID |
NUMBER |
Unique row number - system generated |
USER_ID |
VARCHAR(20) |
User id that the link is associated with |
VERIFIED |
VARCHAR(1) |
Indicates if the link is verified for web display |
BORROWER_ORDERS
Name |
Type (Size) |
Description |
ORDER_NO |
VARCHAR(20) |
Order number |
ROW_ID |
NUMBER |
Unique row number - system generated |
USER_ID |
VARCHAR(20) |
User id that the link is associated with |
BORROWER_RELATED
Name |
Type (Size) |
Description |
PRIMARY_USER_ID |
VARCHAR(20) |
User id of parent user record |
RELATED_USER_ID |
VARCHAR(20) |
User id related to the parent user id |
ROW_ID |
NUMBER |
Unique row number - system generated |
TYPE |
VARCHAR(30) |
Narrower Term, Broader Term, Related Term, Use or Use For |
BORROWERS
Name |
Type (Size) |
Description |
ACTIVE |
VARCHAR(1) |
Indicates if the borrower record is active or not |
ALERT_FREQUENCY |
VARCHAR(30) |
Frequency the borrow wants to receive current awareness alerts |
ADDRESS |
VARCHAR(255) |
Borrower address |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE _EXPIRY |
DATE |
Expiry date of a subscription to library service |
DATE_FIRST_BORROWED |
DATE |
Date borrower first borrowed |
DATE_MODIFIED |
DATE |
Date modified |
DATE_START |
DATE |
Start date of a subscription to library service |
EMPLOYER |
VARCHAR(255) |
Name of institution where borrower employed |
EMPLOYER_REFERENCE |
NUMBER |
Authority file reference number for employer |
GROUP_NAME |
VARCHAR(30) |
Circulation group to which the borrower belongs |
INTERNET |
VARCHAR(100) |
Internet address |
LIBRARY |
VARCHAR(50) |
External Inter-Library Loan borrower |
LOAN_PERIOD |
NUMBER |
Number of days for loans |
LOCATION |
VARCHAR(50) |
Borrower location |
LOGIN_ID |
VARCHAR(20) |
Logon ID |
MAIL_NAME |
VARCHAR(100) |
Email address |
MAX_LOANS |
NUMBER |
Maximum number of loans allowed |
MOBILE |
VARCHAR(20) |
Mobile phone |
MODIFIED_BY |
VARCHAR(20) |
User ID of person who last modified the record |
MAX_RESERVE |
NUMBER |
Maximum number of reservations allowed |
NOTES |
VARCHAR(2000) |
Borrower notes |
NUMBER_LOANS |
NUMBER |
Total number of loans ever borrowed |
OFFICE |
VARCHAR(50) |
Borrower office or room |
OTHER_PHONE |
VARCHAR(20) |
After hours phone number |
PHONE |
VARCHAR(20) |
Business telephone number |
PHOTO |
VARCHAR(255) |
Address of image file |
POSITION |
VARCHAR(100) |
Borrower position |
PRACTICE_AREA |
VARCHAR(255) |
Practice areas |
PROFILE |
VARCHAR(2000) |
Borrower profile |
RENEWALS |
NUMBER |
Number of renewals allowed |
SDI_SUBJECT |
VARCHAR(2000) |
Areas of interest |
STATUS |
VARCHAR(50) |
Borrower employment status e.g., full-time, part-time etc |
USER_ID |
NOT NULL UNIQUE VARCHAR(20) |
Unique Borrower ID |
USER_NAME |
VARCHAR(255) |
Borrower full name |
USER_REFERENCE |
NUMBER |
Authority file reference number for borrower |
CAT_KEYS
Name |
Type (Size) |
Description |
RECNO |
NUMBER |
Catalogue record number |
REFERENCE |
NUMBER |
Reference number of thesaurus terms used in catalogue fields |
PART |
VARCHAR(50) |
Series part (only used where TYPE = Series) |
ROW_ID |
NUMBER |
Unique row number - system generated |
TYPE |
VARCHAR(30) |
Thesaurus entry type - Author, Publisher, Series, Subject |
CATALOGUE
Name |
Type (Size) |
Description |
ACQ_NOTES |
VARCHAR(2000) |
Acquisitions notes |
ACRONYM |
VARCHAR(100) |
Acronym assigned to the title |
ANNOTATION |
VARCHAR(255) |
Annotation on review screen |
AUTHOR |
VARCHAR(255) |
Author/s, including corporate authors |
CALLNO |
VARCHAR(100) |
Call number assigned to record |
CITATION |
VARCHAR(255) |
Serial citation |
COPIES |
VARCHAR(10) |
Number of copies held |
COPY_INSTR |
VARCHAR(255) |
Copy instructions for routing |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_APPROVED |
DATE |
Date acquisition approved |
DATE_CATALOGUED |
DATE |
Date item was catalogued - system generated |
DATE_CREATED |
DATE |
Date entry created - system generated |
DATE_MODIFIED |
DATE |
Date record modified - system generated |
DATE_VERIFIED |
DATE |
Date record verified for web display |
FREQUENCY |
VARCHAR(20) |
Frequency of publication |
EDITION |
VARCHAR(50) |
Edition number |
ISBN_ISSN |
VARCHAR(100) |
ISBN and/or ISSN |
GMD |
VARCHAR(50) |
Material type |
HOLDINGS |
VARCHAR(2000) |
Statement of library holdings |
JURISDICTION |
VARCHAR(50) |
Jurisdiction of item |
KEYWORDS |
VARCHAR(2000) |
Keywords describing text |
LIBRARY |
VARCHAR(50) |
Unassigned field |
MODIFIED_BY |
VARCHAR(20) |
Login ID of modifier - system generated |
NOTES |
VARCHAR(2000) |
Catalogue record notes |
PAGINATION |
VARCHAR(100) |
Pagination details |
PLACE |
VARCHAR(50) |
Place of publication |
PRACTICE_AREA |
VARCHAR(255) |
Practice area heading/s |
PUB_START |
DATE |
Date a serial set starts |
PUB_END |
DATE |
Date a serial set ends |
PUBLISHER |
VARCHAR(255) |
Publisher name |
RECNO |
NOT NULL, UNIQUE, NUMBER |
Unique record number - system generated |
REQUESTOR |
VARCHAR(100) |
Person requesting acquisition of item |
ROUTE_LIST |
VARCHAR(255) |
Serial routing list |
ROUTE_INSTR |
VARCHAR(2000) |
Serial routing instructions |
SECTION |
VARCHAR(50) |
Unassigned field |
SERIES_TITLE |
VARCHAR(255) |
Series title |
SERIES_PART |
VARCHAR(100) |
Series part |
SERIAL_NOTES |
VARCHAR(2000) |
Serial notes |
STATUS |
VARCHAR(30) |
Acquisitions status |
SUBJECT |
VARCHAR(2000) |
Subject heading/s |
TITLE |
VARCHAR(2000) |
Full title, including sub-title (not Series Title) |
TZ_DATE_CATALOGUED |
DATE |
Date item catalogued in originating time zone |
TZ_DATE_CREATED |
DATE |
Date item created in originating time zone |
TZ_DATE_MODIFIED |
DATE |
Date item modified in originating time zone |
VERIFIED |
VARCHAR(2) |
Verification for OPAC display |
YEAR |
VARCHAR(50) |
Year of publication |
CATALOGUE_LINKS
Name |
Type (Size) |
Description |
ADDRESS |
VARCHAR(500) |
Universal resource locator |
CATEGORY |
VARCHAR(30) |
Link category |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
DATE_VERIFIED |
DATE |
Date link is verified for web display |
LINK_TYPE |
VARCHAR(100) |
Universal resource locator stem |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
NOTES |
VARCHAR(2000) |
Link notes |
RECNO |
NUMBER |
Unique record number of associated catalogue record |
ROW_ID |
NUMBER |
Unique row number - system generated |
VERIFIED |
VARCHAR(1) |
Indicates whether the link is verified for web display |
CATALOGUE_REVIEW
Name |
Type (Size) |
Description |
COMMENTS |
VARCHAR(2000) |
Comment text |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
DATE_REVIEW |
DATE |
Comment date |
DATE_VERIFIED |
DATE |
Date comment verified for web display |
MODIFIED_BY |
VARCHAR(20) |
Login ID of modifier - system generated |
NOTES |
VARCHAR(2000) |
Link notes |
RECNO |
NUMBER |
Unique record number of associated catalogue record |
ROW_ID |
NUMBER |
Unique row number - system generated |
SHELF_ROW_ID |
NUMBER |
Unique row number - system generated |
TYPE |
VARCHAR(30) |
Comment type |
USER_ID |
VARCHAR(20) |
Unique Borrower ID |
USER_NAME |
VARCHAR(255) |
Borrower full name |
VERIFIED |
VARCHAR(5) |
Verification for web display |
TZ_DATE_REVIEW |
VARCHAR(50) |
Date comment verified for web display in originating time zone |
CATALOGUE_SEARCHFIELDS
Name |
Type (Size) |
Description |
RECNO |
NUMBER |
Comment text |
SEARCHTITLE |
VARCHAR(2000) |
Login ID of creator - system generated |
PROPTITLE |
VARCHAR(255) |
Date created |
SEARCHNOTES |
VARCHAR(2000) |
Date modified |
SEARCHSUBJECT |
VARCHAR(2000) |
Comment date |
SEARCHAUTHOR |
VARCHAR(255) |
Date comment verified for web display |
CIRCULATION_GMD
Name |
Type (Size) |
Description |
GMD |
VARCHAR(50) |
Material type |
LOAN_PERIOD |
NUMBER |
Number of days for loans |
CIRCULATION_PRIVS
Name |
Type (Size) |
Description |
GROUP_NAME |
VARCHAR(50) |
Group to which the borrower belongs |
LOAN_PERIOD |
NUMBER |
Number of days for loans |
MAX_LOANS |
NUMBER |
Maximum number of loans allowed |
MAX_RESERVE |
NUMBER |
Maximum number of reservations allowed |
ORDSEQ |
NUMBER |
Determines the ordering of the list in the Borrowers Group_Name drop-down |
RENEWALS |
NUMBER |
Maximum number of renewals allowed |
CUSTOM_DATA
Name |
Type (Size) |
Description |
DATA |
VARCHAR(255) |
Data for each field |
FIELD_NAME |
VARCHAR(50) |
Fields used for defined material type |
MATERIAL_TYPE |
VARCHAR(30) |
Type of material or GMD |
RECNO |
NUMBER |
Unique system generated record number |
REFERENCE |
NUMBER |
Reference number of authority term |
ROW_ID |
NUMBER |
Unique row number – system generated |
CUSTOM_PATRON
Name |
Type (Size) |
Description |
FIELD_NAME |
VARCHAR(50) |
Fields used for defined patron field defintion |
DATA |
VARCHAR(255) |
Data for each field |
MATERIAL_TYPE |
VARCHAR(30) |
Type of material = ‘Patron’ |
REFERENCE |
NUMBER |
Reference number of authority term |
ROW_ID |
NUMBER |
Unique row number – system generated |
USER_ID |
VARCHAR(20) |
User id that the custom data is associated with |
CUSTOM_SEARCH
Name |
Type (Size) |
Description |
FIELD_NAME |
VARCHAR(50) |
Field name defined in search |
ORDSEQ |
NUMBER |
Order sequence of fields |
SCREEN |
VARCHAR(25) |
Search screen to which search applies |
TABLE_NAME |
VARCHAR(50) |
Table name for field defined in search |
VIEW_NAME |
VARCHAR(25) |
Search name |
DIACRITICS
Name |
Type (Size) |
Description |
MODIFIER |
NUMBER |
CHAR value of diacritic modifier |
MAP_FROM |
NUMBER |
CHAR value of diacritic map from |
MAP_TO |
VARCHAR(25) |
CHAR value of diacritic map to |
DIACRITICS_INTERNAL
Name |
Type (Size) |
Description |
MAP_FROM |
NUMBER |
CHAR value of diacritic map from |
MAP_TO |
NUMBER |
CHAR value of diacritic map to |
MODIFIER |
NUMBER |
CHAR value of diacritic modifier |
ELECTRONIC_ACCESS
Name |
Type (Size) |
Description |
ACCOUNT |
VARCHAR(50) |
Access account |
ADDRESS |
VARCHAR(255) |
url associated with access details |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
LOCATION |
VARCHAR(50) |
Access location |
MODIFIED_BY |
VARCHAR(20) |
Login ID of modifier - system generated |
PASSWORD |
VARCHAR(50) |
Access password |
ROW_ID |
NUMBER |
Unique row number – system generated |
SITE |
VARCHAR(10) |
Site associated with access details |
USERNAME |
VARCHAR(50) |
Access username |
ELECTRONIC_LINKS
Name |
Type (Size) |
Description |
ADDRESS |
VARCHAR(500) |
url associated with access details |
ACCESS_METHOD |
VARCHAR(50) |
Method of access e.g., anonymous, authenticated, ip fixed |
ACCESS_RIGHTS |
VARCHAR(255) |
Digital rights management statement |
ACCESS_NOTES |
VARCHAR(2000) |
Notes |
CONC_USERS |
NUMBER |
Number of concurrent users |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DESCRIPTION |
VARCHAR(2000) |
Description of electronic resource |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
LINK_TYPE |
VARCHAR(20) |
Type of link i.e., template or null |
MODIFIED_BY |
VARCHAR(20) |
Login ID of modifier - system generated |
ROW_ID |
NUMBER |
Unique row number – system generated |
SESSION_TIME |
NUMBER |
Time of session time out in minutes |
SITE |
VARCHAR(10) |
Site associated with access details |
EXPLAIN_PROC
Name |
Type (Size) |
Description |
DETAILS |
VARCHAR(2000) |
Description of database procedure |
PROCEDURE_NAME |
VARCHAR(50) |
Name of database procedure |
FIELD_DEFS
Name |
Type (Size) |
Description |
AUTHORITY_TYPE |
VARCHAR(30) |
Type of thesaurus a field is linked to |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATA_TYPE |
VARCHAR(50) |
USMARC, Patron, Custom |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
DESCRIPTION |
VARCHAR(255) |
Field description |
FIELD_LABEL |
VARCHAR(50) |
Screen field label |
FIELD_NAME |
VARCHAR(50) |
Field name |
FIELD_TYPE |
VARCHAR(30) |
Field type |
GRPSEQ |
NUMBER |
Order of groups of field names |
IDENTIFIER |
VARCHAR(50) |
USMARC indicator |
INIT |
VARCHAR(20) |
Default field value |
LOOKUP |
VARCHAR(2) |
Yes/No |
MANDATORY |
VARCHAR(10) |
Yes/No |
MAP_TO |
VARCHAR(50) |
Catalogue field name data is mapped to |
MASK |
VARCHAR(50) |
Data entry mask – validation rule |
MATERIAL_TYPE |
VARCHAR(30) |
Material type or GMD |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
OPAC_DISPLAY |
NUMBER |
Yes/No |
OPAC_ORDSEQ |
NUMBER |
Order sequence of fields displayed at OPAC |
ORDSEQ |
NUMBER |
Order sequence of fields |
PREFIX |
VARCHAR(255) |
Characters preceding field data values |
REPEATING |
VARCHAR(5) |
Yes/No |
SUB_FIELD |
VARCHAR(50) |
USMARC sub field |
SUFFIX |
VARCHAR(255) |
Characters proceeding field data values |
VALIDATED |
VARCHAR(2) |
Yes/No indicating if the field definition is applied |
FIELD_DEFS_UPDATE
Name |
Type (Size) |
Description |
AUTHORITY_TYPE |
VARCHAR(30) |
Type of thesaurus a field is linked to |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATA_TYPE |
VARCHAR(50) |
USMARC or Custom |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
DESCRIPTION |
VARCHAR(255) |
Field description |
FIELD_LABEL |
VARCHAR(50) |
Screen field label |
FIELD_NAME |
VARCHAR(50) |
Field name |
FIELD_TYPE |
VARCHAR(30) |
Field type |
GRPSEQ |
NUMBER |
|
IDENTIFIER |
VARCHAR(50) |
USMARC indicator |
INIT |
VARCHAR(20) |
Default field value |
LOOKUP |
VARCHAR(2) |
Yes/No |
MANDATORY |
VARCHAR(10) |
Yes/No |
MAP_TO |
VARCHAR(50) |
Catalogue field name data is mapped to |
MASK |
VARCHAR(50) |
Data entry mask – validation rule |
MATERIAL_TYPE |
VARCHAR(30) |
Material type or GMD |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
OPAC_DISPLAY |
NUMBER |
Yes/No |
OPAC_ORDSEQ |
NUMBER |
Order sequence of fields displayed at OPAC |
ORDSEQ |
NUMBER |
Order sequence of fields |
PREFIX |
VARCHAR(255) |
Characters preceding field data values |
PREV_FIELD_NAME |
VARCHAR(50) |
Previous name of the field |
REPEATING |
VARCHAR(5) |
Yes/No |
SUB_FIELD |
VARCHAR(50) |
USMARC sub field |
SUFFIX |
VARCHAR(255) |
Characters proceeding field data values |
VALIDATED |
VARCHAR(2) |
Yes/No indicating if the field definition is applied |
FIRST_PROPS
Name |
Type (Size) |
Description |
PKEY |
VARCHAR(50) |
Property key |
[VALUE] |
VARCHAR(100) |
Property value |
FUND_ALLOCATION
Name |
Type (Size) |
Description |
AMOUNT |
NUMBER |
$ amount allocated |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_FUND |
DATE |
Date fund created |
DATE_MODIFIED |
DATE |
Date modified |
FUND_NAME |
NOT NULL, VARCHAR(50) |
Name of fund receiving allocation |
MODIFIED_BY |
VARCHAR(20) |
Logon ID who last modified - system generated |
NOTES |
VARCHAR(2000) |
Notes associated with fund |
ROW_ID |
NUMBER |
Unique row number of allocation – system generated |
FUND_LINKS
Name |
Type (Size) |
Description |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
FUND |
VARCHAR(50) |
Name of fund |
LINK_TYPE |
VARCHAR(30) |
Type of link |
MODIFIED_BY |
VARCHAR(20) |
Logon ID who last modified - system generated |
NOTES |
VARCHAR(2000) |
Notes associated with linked fund |
RELATED_FUND |
VARCHAR(50) |
Name of related fund |
ROW_ID |
NUMBER |
Unique row number of allocation – system generated |
SITE |
VARCHAR(10) |
Site associated with linked fund |
FUNDS
Name |
Type (Size) |
Description |
CREATED_BY |
VARCHAR(50) |
Initials of user who created the fund |
EXCLUDE |
NUMBER |
Exclude from total library budget |
DATE_CREATED |
DATE |
Date fund created |
DATE_END |
DATE |
Date fund ends |
DATE_FUND |
DATE |
Date fund starts |
DATE_MODIFIED |
DATE |
Date fund modified |
FUND_NAME |
VARCHAR(50) |
Name of fund |
LIBRARY |
VARCHAR(30) |
Spare field |
MODIFIED_BY |
VARCHAR(20) |
Login ID of modifier – system generated |
NOTES |
VARCHAR(2000) |
Fund notes |
TYPE |
VARCHAR(30) |
Type of fund |
USER_ID |
VARCHAR(20) |
User_id associated with the fund |
GMT_LOOKUP
Name |
Type (Size) |
Description |
ACRONYM |
VARCHAR(50) |
Time zone acronym e.g. AEST |
OFFSET |
NUMBER |
GMT time zone off set |
IMPORT KEY MAPPINGS
Name |
Type (Size) |
Description |
TABLE_NAME |
VARCHAR(50) |
Name of table |
INTERNAL_KEY |
VARCHAR(50) |
Name of internal key |
IMPORT_KEY |
VARCHAR(255) |
Name of import key |
INTER_LIBRARY
Name |
Type (Size) |
Description |
ACCOUNT |
VARCHAR(50) |
Chargeable fund name |
AUTHOR |
VARCHAR(255) |
Author/s of text borrowed |
BARCODE |
VARCHAR(20) |
Barcode of text |
BORROWED_BY |
VARCHAR(50) |
Initials of borrower (from external library) |
CITATION |
VARCHAR(255) |
Citation |
COPY |
VARCHAR(20) |
Copy number of serial issue |
COST_CENTRE |
VARCHAR(50) |
Cost centre |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date loan created |
DATE_DUE |
DATE |
Date loan due |
DATE_LOAN |
DATE |
Date loan sent |
DATE_MODIFIED |
DATE |
Date loan record was modified |
DATE_PAID |
DATE |
Payment Date |
DATE_RECEIVED |
DATE |
Date item received |
DATE_RETURN |
DATE |
Date loan was returned |
GMD |
VARCHAR(50) |
Material type |
GST |
NUMBER |
Tax |
ILL_CHARGE |
NUMBER |
$ amount charged |
ILLID |
NUMBER |
Unique ID number of ILL record |
INVOICE_NO |
VARCHAR(50) |
Invoice number |
ISBN_ISSN |
VARCHAR(20) |
ISBN or ISSN of the item |
ITEM_ADDESS |
VARCHAR(255) |
Web address or url of item record |
KDD_REF |
VARCHAR(20) |
Kinetica reference |
LIBRARY |
VARCHAR(100) |
Name of external library |
MODIFIED_BY |
VARCHAR(20) |
Initials of user who modified record |
NOTES |
VARCHAR(2000) |
ILL notes |
OUTGOING |
NUMBER |
Source |
PAGINATION |
VARCHAR(100) |
Page numbering |
PART |
VARCHAR(100) |
Part of serial issue |
PATRON |
VARCHAR(50) |
Internal borrowers name |
PATRON_DETAILS |
VARCHAR(100) |
Phone number etc. |
PAY_BY |
VARCHAR(10) |
Initials of user who processed payment |
PAY_STATUS |
VARCHAR(50) |
Payment status |
PAYMENT_NOTES |
VARCHAR(255) |
Notes relating to the payment |
PLACE |
VARCHAR(50) |
Place of publication |
PUBLISHER |
VARCHAR(255) |
Publisher name |
REQUEST_TYPE |
VARCHAR(50) |
Request type |
REQUEST_METHOD |
VARCHAR(50) |
Method requested |
RETURNED_BY |
VARCHAR(50) |
Initials of person returning item (from external library) |
STATUS |
VARCHAR(30) |
Loan status |
SUPPLIER_NOTES |
VARCHAR(2000) |
Notes for the supplier |
TITLE |
VARCHAR(2000) |
Title of text borrowed |
VOLUME |
VARCHAR(50) |
Volume of serial issue |
VOUCHER_NO |
VARCHAR(100) |
ILL voucher numbers |
YEAR |
VARCHAR(50) |
Year of serial issue |
INVOICE_ITEMS
Name |
Type (Size) |
Description |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
GST |
NUMBER |
GST (Goods & Services Tax) (%) |
DATE_CREATED |
DATE |
Date invoice item (product) created |
DATE_MODIFIED |
DATE |
Date invoice item (product) modified |
ITEM_CODE |
VARCHAR(20) |
Unique invoice item (product) code |
ITEM_DETAILS |
VARCHAR(255) |
Description of the invoice item (product) |
LOCATION |
VARCHAR(50) |
Invoice item (product) location |
NOTES |
VARCHAR(2000) |
Notes |
REORDER |
INTEGER |
Number at which the invoice item (product) should be reordered |
ROW_ID |
INTEGER |
Unique row number of item – system generated |
STATUS |
VARCHAR(50) |
Invoice item (product) status e.g. current or discontinued |
STOCK |
INTEGER |
Invoice item (product) stock count |
UNIT_PRICE |
NUMERIC |
Invoice item (product) unit price |
VENDOR_ID |
VARCHAR(20) |
invoice item (product) Supplier ID |
ITEM_RENEWALS
Name |
Type (Size) |
Description |
BARCODE |
VARCHAR(20) |
Barcode of item renewed |
DATE_RENEWED |
DATE |
Date renewed |
RECNO |
NUMBER |
Unique record number – system generated |
USER_ID |
VARCHAR(20) |
User ID of user who renewed item |
JOURNAL_ARTICLE
Name |
Type (Size) |
Description |
PART |
VARCHAR(100) |
Part of parent serial issue |
PRIMARY_RECNO |
NUMBER |
Record number of journal article |
RELATED_RECNO |
NUMBER |
Record number of parent serial title |
ROW_ID |
NUMBER |
Unique row number of article – system generated |
TYPE |
VARCHAR(30) |
Type of linkage |
VOLUME |
VARCHAR(50) |
Volume of parent serial issue |
YEAR |
VARCHAR(50) |
Year of parent serial issue |
LOAN_CATEGORY
Name |
Type (Size) |
Description |
LOAN_CATEGORY |
VARCHAR(50) |
Loan category e.g. Reference |
LOAN_PERIOD |
NUMBER |
Loan period in days |
LOANS
Name |
Type (Size) |
Description |
BARCODE |
VARCHAR(20) |
Barcode of item borrowed |
DATE_DUE |
DATE |
Date loan due |
DATE_LOAN |
DATE |
Date loan created |
DATE_LOAN_TIME |
DATE |
Time and date loan created |
DATE_RETURN |
DATE |
Date loan returned |
NOTES |
VARCHAR(255) |
Lending notes |
ROW_ID |
NUMBER |
Unique row number of loan – system generated |
STATUS |
VARCHAR(30) |
Loan status |
TITLE |
VARCHAR(255) |
Title of item borrowed |
USER_ID |
VARCHAR(20) |
Borrowers user ID |
USER_NAME |
VARCHAR(255) |
Borrowers user name |
MARC_DATA
Name |
Type (Size) |
Description |
DATA |
VARCHAR(255) |
USMARC data value |
FIELD_NAME |
VARCHAR(50) |
USMARC tag |
INDICATOR |
VARCHAR(10) |
USMARC indicator |
RECNO |
NUMBER |
Unique record number – system generated |
REFERENCE |
NUMBER |
Reference number of authority term |
ROW_ID |
NUMBER |
Unique row number of field – system generated |
SUB_FIELD |
VARCHAR(50) |
USMARC sub field |
MESSAGE_DETAILS
Name |
Type (Size) |
Description |
BUFFER |
NUMBER |
Time (minutes) message will remain in outbox |
IS_INTEGRATED |
CHAR(1) |
Is personalized or generic |
LOG_USER_ID |
VARCHAR(20) |
User ID of user who receives a log of messages sent |
MAIL_MERGE_FIELDS |
VARCHAR(1500) |
Fields added to message body |
MESSAGE_BODY |
VARCHAR(1500) |
Text of message |
MESSAGE_CONDITION |
VARCHAR(2000) |
Conditions that define the message |
MESSAGE_FOOTER |
VARCHAR(255) |
Text at message footer |
MESSAGE_HEADER |
VARCHAR(1000) |
Text at message header |
MESSAGE_METHOD |
VARCHAR(10) |
Method the message is delivered |
MESSAGE_NAME |
VARCHAR(50) |
Message name |
MESSAGE_SQL |
VARCHAR(2000) |
Parsed SQL version of message condition |
RECIPIENT_TYPE |
VARCHAR(20) |
Patron or Vendor |
SCREEN |
VARCHAR(25) |
Screen the message is related too |
TASK_ID |
NUMBER |
Identifier linking the message to its task schedule |
USER_ID |
VARCHAR(20) |
User ID of the person who last modified the message |
MESSAGES_OUTBOX
Name |
Type (Size) |
Description |
DATE_TO_SEND |
DATE |
Date and time message is to be sent |
MESSAGE_NAME |
VARCHAR(50) |
Message name |
USER_ID |
VARCHAR(20) |
User ID of user to receive the message |
MESSAGES_RECIPIENTS
Name |
Type (Size) |
Description |
MESSAGE_NAME |
VARCHAR(50) |
Message name |
USER_ID |
VARCHAR(255) |
User ID of user to receive the message |
ORDSEQ |
NUMBER |
Order sequence of users to receive the message |
OPAC_TASK CONFIG
Name |
Type (Size) |
Description |
TASK_ID |
NUMBER |
Unique task ID |
PKEY |
VARCHAR(100) |
Parameter |
VALUE |
VARCHAR(2000) |
Value |
ORDER_LINKS
Name |
Type (Size) |
Description |
ADDRESS |
VARCHAR(500) |
Universal resource locator |
CATEGORY |
VARCHAR(30) |
Link category |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
LINK_TYPE |
VARCHAR(30) |
Universal resource locator stem |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
NOTES |
VARCHAR(2000) |
Link notes |
ORDER_NO |
VARCHAR(20) |
Order number |
RECNO |
NUMBER |
Unique record number of associated catalogue record |
ROW_ID |
NUMBER |
Unique row number - system generated |
SITE |
VARCHAR(10) |
Site associated with the link |
ORDERS
Name |
Type (Size) |
Description |
ACCOUNT |
VARCHAR(50) |
Account |
COST_CENTRE |
VARCHAR(50) |
Cost centre |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
CURRENCY |
VARCHAR(10) |
Foreign currency |
DATE_CREATED |
DATE |
Date created |
DATE_DELIVER |
DATE |
Delivery date |
DATE_EST_DELIVER |
DATE |
Date due |
DATE_ INVOICE |
DATE |
Date of invoice |
DATE_MODIFIED |
DATE |
Date modified |
DATE_ ORDER |
DATE |
Date order created |
DATE_RENEWAL |
DATE |
Subscription renewal date |
ESTIMATED_PRICE |
NUMBER |
$ amount quoted |
GST |
NUMBER |
Tax |
INVOICE_NO |
VARCHAR(20) |
Invoice number |
ITEM_CODE |
VARCHAR(20) |
Internal invoice code associated with order |
LOCATION |
VARCHAR(50) |
Location associated with the order |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
NOTES |
VARCHAR(2000) |
Order notes |
ORDER_DETAILS |
VARCHAR(255) |
Details of order to send to vendor |
ORDER_NO |
VARCHAR(20) |
Unique order number |
PAY_BY |
VARCHAR(10) |
Method of payment |
PRICE |
NUMBER |
Price |
QUANTITY |
NUMBER |
Quantity ordered |
RECNO |
NUMBER |
Unique record number |
ROW_ID |
NUMBER |
Unique row ID of order |
| SITE | VARCHAR(10) |
Site of logged in user creating the order |
STATUS |
VARCHAR(30) |
Order status |
SUPPLIER |
VARCHAR(50) |
Vendor supplying order |
PAYMENTS
Name |
Type (Size) |
Description |
AMOUNT |
NUMBER |
Order Amount charged to the fund |
COST_CENTRE |
VARCHAR(50) |
Cost Centre |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_ INVOICE |
DATE |
Invoice date |
DATE_MODIFIED |
DATE |
Date modified |
DATE_ PAID |
DATE |
Date paid |
FUND_NAME |
VARCHAR(50) |
Chargeable fund name |
GST |
NUMBER |
Tax |
INVOICE_NO |
VARCHAR(20) |
Invoice number |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
NOTES |
VARCHAR(2000) |
Payment notes |
ORDER_NO |
VARCHAR(20) |
Order number linking payment and order record |
PERCENTAGE |
NUMBER |
% of order total assigned to the fund |
ROW_ID |
NUMBER |
Unique row ID of payment |
STATUS |
VARCHAR(30) |
Payment status – Paid, Not Paid |
PREFS
Name |
Type (Size) |
Description |
ALERT_PERIOD |
NUMBER |
Overdue period for system alert (days) |
BARCODE_PREFIX |
VARCHAR(10) |
Barcode prefix |
DEFAULT_LOAN |
NUMBER |
Default loan period |
HOLIDAYS |
VARCHAR(255) |
Holiday periods |
INVOICE_PREFIX |
VARCHAR(10) |
Invoice number prefix |
LOAN_CATEGORY |
VARCHAR(30) |
Loan category |
LOCATION |
VARCHAR(50) |
Default library location |
NEXT_ALERT |
DATE |
Next date for system alert |
NEXT_BARCODE |
NUMBER |
Next barcode number for system generated barcodes |
NEXT_INVOICE |
NUMBER |
Next invoice number for system generated invoice numbers |
NEXT_ORDER |
NUMBER |
Next order number for system generated orders |
NEXT_PRODUCT |
NUMBER |
Next product number for system generated product numbers |
OFFICE |
VARCHAR(30) |
Office |
ORDER_PREFIX |
VARCHAR(10) |
Order number prefix |
OVERDUE_LOAN |
NUMBER |
Overdue grace period for loans (days) |
OVERDUE_MESSAGE |
VARCHAR(255) |
Overdue message for grace period 1 |
OVERDUE_MESSAGE2 |
VARCHAR(255) |
Overdue message for grace period 2 |
PRODUCT_PREFIX |
VARCHAR(10) |
Product number prefix |
RESERVATIONS_CANCEL |
NUMBER |
Number of days before a reservation is cancelled |
SEND_LOAN_ALERT |
VARCHAR(10) |
Started or Stopped |
SEND_RES_ALERT |
VARCHAR(10) |
Started or Stopped |
SEND_SDI_ALERT |
VARCHAR(10) |
Started or Stopped |
RESERVATIONS
Name |
Type (Size) |
Description |
BARCODE |
VARCHAR(20) |
Item barcode |
DATE_RESERVE |
DATE |
Reservation date |
DATE_RESERVE_FOR |
DATE |
Date reserved for |
DATE_RESERVE_TIME |
DATE |
Time of reservation |
LOCATION |
VARCHAR(50) |
Pickup location of reservation |
NOTES |
VARCHAR(255) |
Notes |
PART |
VARCHAR(100) |
Serial issue part |
PRIORITY |
NUMBER |
Priority order |
RECNO |
NOT NULL, UNIQUE NUMBER |
Record number of item reserved |
ROW_ID |
NUMBER |
Unique row ID of item reserved |
STATUS |
VARCHAR(30) |
Reservation status |
TITLE |
VARCHAR(255) |
Title of item |
TYPE |
VARCHAR(30) |
Type of reservation |
USER_ID |
VARCHAR(20) |
Borrower user ID |
USER_NAME |
VARCHAR(255) |
Borrower user name |
VOLUME |
VARCHAR(50) |
Serial issue volume |
YEAR |
VARCHAR(50) |
Serial issue year |
ROUTE_GROUPS
Name |
Type (Size) |
Description |
GROUP_NAME |
VARCHAR(50) |
Route group name |
ORDSEQ |
NUMBER |
Order of user on route list |
USER_ID |
VARCHAR(20) |
Borrower ID |
ROUTE_LIST
Name |
Type (Size) |
Description |
COPY |
VARCHAR(20) |
Copy number of routed item |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
FREQUENCY |
VARCHAR(30) |
Frequency user receives route |
LOCATION |
VARCHAR(50) |
Location of routed item |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
ORDSEQ |
NUMBER |
Order of user on route list |
RECNO |
NUMBER |
Unique record number of title routed |
ROUTE_STYLE |
VARCHAR(20) |
Routing method |
ROW_ID |
NUMBER |
Unique row ID |
USER_ID |
VARCHAR(20) |
Borrower ID of user on route list |
USER_NAME |
VARCHAR(255) |
Name of user on route list |
SAVED_RESULTS
Name |
Type (Size) |
Description |
DATE_CREATED |
DATE |
Date created |
RECORDS |
VARCHAR(2000) |
SQL of saved search |
RESULT_NAME |
VARCHAR(255) |
Saved result name |
TYPE |
VARCHAR(30) |
Search screen associated with saved search name |
USER_ID |
VARCHAR(20) |
User ID associated with saved search name |
SDI_KEYS
Name |
Type (Size) |
Description |
REFERENCE |
NUMBER |
Reference number of thesaurus term on SDI list |
ROW_ID |
NUMBER |
Unique row ID of item thesaurus term on SDI list |
TYPE |
VARCHAR(30) |
Thesaurus type - Subject, Author, Series |
USER_ID |
VARCHAR(20) |
User ID associated with SDI list |
SEQUENCE_BARCODE
Name |
Type (Size) |
Description |
USER_ID |
VARCHAR(20) |
User ID |
SEQUENCE_CUSTOM (Only for MSSQL)
Name |
Type (Size) |
Description |
NEXTID |
NUMBER |
Custom record ID |
USER_ID |
VARCHAR(20) |
User ID |
SEQUENCE_GUEST_USER_ID (Only for MSSQL)
Name |
Type (Size) |
Description |
GUEST_USER_ID |
NUMBER |
Guest user ID |
USER_ID |
VARCHAR(20) |
User ID |
SEQUENCE_ILLID
Name |
Type (Size) |
Description |
ILLID |
NUMBER |
Inter library loan ID |
USER_ID |
VARCHAR(20) |
User ID |
SEQUENCE_INVOICE_NO
Name |
Type (Size) |
Description |
INVOICE_NO |
NUMBER |
Invoice ID |
USER_ID |
VARCHAR(20) |
User ID |
SEQUENCE_MARC (Only for MSSQL)
Name |
Type (Size) |
Description |
NEXTID |
NUMBER |
MARC record ID |
USER_ID |
VARCHAR(20) |
User ID |
SEQUENCE_ORDERNO
Name |
Type (Size) |
Description |
ORDER_NO |
NUMBER |
Order ID |
USER_ID |
VARCHAR(20) |
User ID |
SEQUENCE_PRODUCT_NO
Name |
Type (Size) |
Description |
PRODUCT_NO |
NUMBER |
Product ID |
USER_ID |
VARCHAR(20) |
User ID |
SEQUENCE_RECNO
Name |
Type (Size) |
Description |
RECNO |
NUMBER |
Record number |
USER_ID |
VARCHAR(20) |
User ID |
SEQUENCE_REFERENCE
Name |
Type (Size) |
Description |
RECNO |
NUMBER |
Reference number |
USER_ID |
VARCHAR(20) |
User ID |
SHELF_ITEMS
Name |
Type (Size) |
Description |
ADDRESS |
VARCHAR(255) |
Universal Resource Locator |
BARCODE |
VARCHAR(20) |
Item barcode |
CALL_SUFFIX |
VARCHAR(100) |
Item call number |
COPY |
VARCHAR(20) |
Copy number |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_AUDIT |
DATE |
Date item last audited |
DATE_BORROWED |
DATE |
Date borrowed |
DATE_CREATED |
DATE |
Date created |
DATE_DUE |
DATE |
Date loan due |
DATE_MODIFIED |
DATE |
Date modified |
DATE_ PUB |
DATE |
Date published |
DATE_RECEIVED |
DATE |
Date item received |
FORMAT |
VARCHAR(50) |
Format of the shelf item |
LIBRARY |
VARCHAR(30) |
Collection |
LINK_CATEGORY |
VARCHAR(30) |
Link category |
LOAN_CATEGORY |
VARCHAR(30) |
Loan category of item |
LOAN_PERIOD |
NUMBER |
Loan category of item |
LOCATION |
VARCHAR(50) |
Library location |
MODIFIED_BY |
VARCHAR(20) |
Login ID of modifier - system generated |
NOTES |
VARCHAR(2000) |
Notes |
OFFICE |
VARCHAR (50) |
Office where item is located |
OLD_STATUS |
VARCHAR(30) |
Original status of borrowed items |
PART |
VARCHAR(100) |
Serial part |
RECNO |
NUMBER |
Unique record number - system generated |
RENEWALS |
NUMBER |
Number of times borrower has renewed loan |
ROW_ID |
NUMBER |
Unique row ID |
SITE |
VARCHAR(10) |
Site of the logged in user creating the item |
STATUS |
VARCHAR(30) |
Availability status |
TYPE |
VARCHAR(100) |
Universal Resource Locator stem |
USER_ID |
VARCHAR(20) |
Borrower user ID |
USER_LOCATION |
VARCHAR(50) |
Location of borrower |
USER_NAME |
VARCHAR(255) |
User name of borrower |
VOLUME |
VARCHAR(50) |
Serial volume |
YEAR |
VARCHAR(50) |
Serial year |
SHELF_ORDERS
Name |
Type (Size) |
Description |
CALL_SUFFIX |
VARCHAR(100) |
Item call number |
CLAIMS |
NUMBER |
Number of times claimed |
COPY |
VARCHAR(20) |
Serial copy number |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CLAIMED |
DATE |
Date last claimed |
DATE_CREATED |
DATE |
Date created |
DATE_DUE |
DATE |
Date due |
DATE_MODIFIED |
DATE |
Date modified |
DATE_ PUB |
DATE |
Date of publication |
DATE_ RECEIVED |
DATE |
Date received |
FORMAT |
VARCHAR(50) |
Format of the item |
LIBRARY |
VARCHAR(50) |
Collection |
LOAN_CATEGORY |
VARCHAR(50) |
Loan category |
LOCATION |
VARCHAR(50) |
Location |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
NOTES |
VARCHAR(2000) |
Notes |
ORDER_NO |
VARCHAR(20) |
Order number for serial |
PART |
VARCHAR(100) |
Serial Part |
RECNO |
NUMBER |
Unique record number of subscription |
ROW_ID |
NUMBER |
Unique row ID of subscription |
SITE |
VARCHAR(10) |
Site of user creating the order |
STATUS |
VARCHAR(30) |
Status |
VOLUME |
VARCHAR(50) |
Serial Volume |
YEAR |
VARCHAR(50) |
Serial Year |
STOCK_TAKE
Name |
Type (Size) |
Description |
BARCODE |
VARCHAR(20) |
Item barcode |
DATE_STOCK |
DATE |
Date of last stock take |
STATUS |
VARCHAR(30) |
Status at last stock take |
SUBSCRIPTIONS
Name |
Type (Size) |
Description |
ACQ_SET |
NUMBER |
Creates acquired set |
BARCODE_SET |
NUMBER |
Creates barcodes for serial set |
BND_VOL |
NUMBER |
Creates a bound volume |
COPY |
VARCHAR(20) |
Copy number |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
CUSTOM_INCR |
VARCHAR(20) |
Numerical values for serial frequency settings |
CUSTOM_TYPE |
VARCHAR(20) |
Text values for serial frequency settings |
DATE_CREATED |
DATE |
Date created |
DATE_FIRST_DUE |
DATE |
Date first issue due |
DATE_END |
DATE |
Date last issue due |
DATE_MODIFIED |
DATE |
Date modified |
DATE_START_PUB |
DATE |
Date first issue published |
FORMAT |
VARCHAR(50) |
Format of the subscription |
FREQUENCY |
VARCHAR(20) |
Frequency of publication |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
NO_COPIES |
VARCHAR(20) |
Number of copies |
NO_ISSUES |
VARCHAR(20) |
Number of issues in subscription |
PART |
VARCHAR(100) |
Serial part |
PART_INCR |
VARCHAR(20) |
Numerical start value for Part-Part serial labels |
PART_PREFIX |
VARCHAR(10) |
Part prefix |
PARTS_BND_VOL |
VARCHAR(20) |
Parts per bound volume value |
PREDICT_TYPE |
VARCHAR(20) |
Prediction type |
PREDICTION |
VARCHAR(100) |
Serial prediction pattern |
RECNO |
NUMBER |
Unique record number of subscription |
ROW_ID |
NUMBER |
Row ID |
START_PART_WITH |
VARCHAR(20) |
First part in a prediction sequence |
TEMPLATE |
VARCHAR(50) |
Prediction pattern template name |
VOLUME |
VARCHAR(50) |
Serial volume |
YEAR |
VARCHAR(50) |
Serial year |
SYS_FIRST
Name |
Type (Size) |
Description |
DB_TYPE |
VARCHAR(10) |
Database type |
DB_VERSION |
VARCHAR(10) |
Database version |
TASK_CONFIG
Name |
Type (Size) |
Description |
TASK_ID |
NUMBER |
Unique task ID - system generated |
PARAM_NAME |
VARCHAR(100) |
Task parameter name |
PARAM_VALUE |
VARCHAR(1000) |
Task parameter value |
TASK_SCHEDULE
Name |
Type (Size) |
Description |
ACTIVE |
VARCHAR(8) |
Enabled or Disabled |
ALERT_PERIOD |
NUMBER |
Defines x in sent every x day(s) / week(s) / month(s) |
CRON_EXP |
VARCHAR(50) |
Compiled task schedule expression |
END_DATE |
DATE |
Date a message is to stop running |
START_DATE |
DATE |
Date an enabled message is to commence running |
NEXT_ALERT |
DATE |
Date the message is scheduled to run next |
TASK_CLASS |
VARCHAR(100) |
The java class to execute when the task fires |
TASK_FREQUENCY |
VARCHAR(10) |
Defines the task as daily, weekly or monthly |
TASK_ID |
NUMBER |
Unique task identifier |
TASK_TYPE |
VARCHAR(50) |
The type of task being scheduled |
TEMPLATES
Name |
Type (Size) |
Description |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
FIELD_NAME |
VARCHAR(50) |
Template field name |
INIT |
VARCHAR(255) |
Default data value |
MODIFIED_BY |
VARCHAR(20) |
Logon ID when last modified |
ORDSEQ |
NUMBER |
Order sequence of template fields |
MATERIAL_TYPE |
VARCHAR(30) |
Material type or GMD |
SUB_FIELD |
VARCHAR(50) |
Template sub field name |
TEMPLATE_NAME |
VARCHAR(50) |
Template name |
USER_LOGON
Name |
Type (Size) |
Description |
OLD_USER_LASTLOG |
DATE |
Previous date of last logon |
USER_ID |
VARCHAR(20) |
User ID |
USER_LASTLOG |
DATE |
Date of last logon |
USER_LOGCOUNT |
NUMBER |
Count of number of logons |
USER_PASSWORD |
VARCHAR(12) |
User password |
VENDORS
Name |
Type (Size) |
Description |
ABN |
VARCHAR(20) |
Internet address |
ACCOUNT |
VARCHAR(50) |
Account number with vendor |
CONTACT |
VARCHAR(50) |
Contact name |
CREATED_BY |
VARCHAR(20) |
Login ID of creator - system generated |
DATE_CREATED |
DATE |
Date created |
DATE_MODIFIED |
DATE |
Date modified |
VARCHAR(100) |
Email address |
|
FAX |
VARCHAR(20) |
Fax number |
INTERNET |
VARCHAR(100) |
Internet address |
LIBRARY |
VARCHAR(50) |
Spare field |
MAIL_ADDRESS |
VARCHAR(255) |
Delivery or street address |
MODIFIED_BY |
VARCHAR(20) |
Login ID of modifier - system generated |
NOTES |
VARCHAR(2000) |
Notes |
PHONE |
VARCHAR(20) |
Phone number |
POST_ADDRESS |
VARCHAR(255) |
Postal address |
TYPE |
VARCHAR(30) |
Type of vendor |
VENDOR |
VARCHAR(100) |
Vendor name |
VENDOR_ID |
VARCHAR(50) |
Vendor ID |