ILLiad Database Tables

Follow

This page provides a complete alphabetical list of the database tables and fields used in ILLiad. Primary keys for each table are designated in the PK column.

Alerts

PK Field Name Field Type
  AlertID int
  IdentifierType nvarchar(50)
  IdentifierValue nvarchar(50)
  AlertTitle nvarchar(255)
  AlertMessage nvarchar(max)
  CreatedDate datetime
  ActiveDate datetime
  ExpirationDate datetime
  AddedBy nvarchar(50)

BarometerExclusions

PK Field Name Field Type
PK NVTGC nvarchar(100)
PK ProcessType nvarchar(200)
PK ExcludeQueue nvarchar(100)

Billing

PK Field Name Field Type
PK TransactionNumber int
PK InternalNo float
  Amount money
  Note nvarchar(100)
  BillingDate datetime
  InvoiceDate datetime
  Processed nvarchar(3)

BillingAdditions

PK Field Name Field Type
PK AdditionName nvarchar(100)
PK AdditionCategory nvarchar(20)
  BaseFee money
  Range1Pages int
  Range1Amount money
  Range2Pages int
  Range2Amount money
  Range3Pages int
  Range3Amount money

BillingDefaults

PK Field Name Field Type
PK ProcessType nvarchar(10)
PK DocumentType nvarchar(15)
  DefaultAmount money
PK Category nvarchar(20)
  Range1Pages int
  Range1Amount money
  Range2Pages int
  Range2Amount money
  Range3Pages int
  Range3Amount money

BillingDetails

PK Field Name Field Type
PK TransactionNumber int
PK ChargeName nvarchar(100)
  ChargeBase money
  ChargeUnit money
  ChargeQty int
  ChargeAmount money
  ChargeDesc nvarchar(250)
  ChargeNote nvarchar(250)
PK ChargeDate datetime

BillingServiceLevels

PK Field Name Field Type
PK ProcessType nvarchar(50)
PK ServiceLevel nvarchar(100)
  Amount money

BillingServiceType

PK Field Name Field Type
PK ProcessType nvarchar(50)
PK ServiceType nvarchar(100)

BillingShippingFees

PK Field Name Field Type
PK ProcessType nvarchar(50)
PK ShippingMethod nvarchar(100)
  Amount money

BorrowerStatus

PK Field Name Field Type
PK Borrower nvarchar(10)
  Status nvarchar(40)
PK NVTGC nvarchar(20)

BorrowingInvoices

PK Field Name Field Type
PK InvoiceNumber int
  DateGenerated datetime
  StartDate datetime
  EndDate datetime
  TotalAmount money
  Status nvarchar(50)

BorrowingPayments

PK Field Name Field Type
PK PaymentNumber int
  InvoiceNumber int
  Amount money
  PaymentDate datetime
  Method nvarchar(100)
  CheckRefNumber nvarchar(50)
  Notes nvarchar(200)
  AddedBy nvarchar(50)

BorrowingRequests

PK Field Name Field Type
PK TransactionNumber int
  RequestText nvarchar(max)

Citation

PK Field Name Field Type
PK TransactionNumber int
  Citation1 nvarchar(250)
  Citation2 nvarchar(250)
  Citation3 nvarchar(250)
  Citation4 nvarchar(250)
  Citation5 nvarchar(250)
  Citation6 nvarchar(250)
  Citation7 nvarchar(250)
  Citation8 nvarchar(250)

ClientAccess

PK Field Name Field Type
PK Formname nvarchar(60)
PK Formtype nvarchar(60)
PK Action nvarchar(60)
  UserGroups nvarchar(255)
  MenuText nvarchar(60)
  ActionText nvarchar(60)

ConnectorDetails

PK Field Name Field Type
PK ID int
PK SessionID int
PK ConnectorDateTime datetime
PK ConnectorAction nvarchar(50)
PK Result nvarchar(50)
  ILLNumber nvarchar(15)

ConnectorSessions

PK Field Name Field Type
PK SessionID int
  SessionBeginDateTime datetime
  SessionEndDateTime datetime
  BorrowingReceives int
  BorrowingReturns int
  BorrowingRenewals int
  BorrowingConditionals int
  BorrowingRenewalNo int
  BorrowingRenewalOK int
  BorrowingRecalled int
  BorrowingShipped int
  BorrowingUnfilled int
  BorrowingWillSupply int
  BorrowingRequests int
  LendingYesCopies int
  LendingYesLoans int
  LendingCancels int
  LendingConditionals int
  LendingCompletes int
  LendingRenewalNo int
  LendingRenewalOK int
  LendingRequests int
  LendingRenewalRequests int
  LendingConditionalRequests int
  NVTGC nvarchar(20)
  BorrowingSMOverdue nvarchar(20)
  BorrowingSMReceived nvarchar(20)
  LendingSMNotReceived nvarchar(20)
  LendingSMComplete nvarchar(20)
  LendingRecalls nvarchar(20)

CopyrightSessions

PK Field Name Field Type
PK TransactionNumber int
  DateTime datetime
PK OrderHeader nvarchar(50)
PK OrderDetail nvarchar(50)
  SubmittedBy  

CustomDropDown

PK Field Name Field Type
PK NVTGC nvarchar(20)
PK GroupName nvarchar(100)
PK LabelName nvarchar(200)
  LabelValue nvarchar(255)

CustomFlags

PK Field Name Field Type
PK ID int
  NVTGC nvarchar(20)
  FlagName nvarchar(255)
  IsSystem bit

Customization

PK Field Name Field Type
PK CustKey nvarchar(60)
  Value nvarchar(255)
PK NVTGC nvarchar(20)
  Description nvarchar(255)
  AdminCat nvarchar(50)
  AdminKey nvarchar(50)
  AdminType nvarchar(50)

CustomizationTracking

PK Field Name Field Type
PK CustKey nvarchar(100)
  ValueChangedFrom nvarchar(1000)
  ValueChangedTo nvarchar(1000)
PK NVTGC nvarchar(50)
PK ChangedTime datetime
  ChangedBy nvarchar(20)

CustomQueues

PK Field Name Field Type
PK QueueName nvarchar(40)
PK ProcessType nvarchar(50)
PK NVTGC nvarchar(20)

DefaultAccounts

PK Field Name Field Type
PK NVTGC nvarchar(10)
PK Status nvarchar(50)
  AccountNo nvarchar(100)
  Type nvarchar(40)
  Description nvarchar(100)
  CCExpirationDate nvarchar(50)
  CCNameOnCard nvarchar(50)
  ArticleBillingCategory nvarchar(50)
  LoanBillingCategory nvarchar(50)

DeliveryLocations

PK Field Name Field Type
PK Symbol nvarchar(20)
  Value nvarchar(25)

DisplayStatuses

PK Field Name Field Type
PK ID int
  NVTGC nvarchar(10)
  ProcessType nvarchar(50)
  TransactionStatus nvarchar(255)
  WebDisplayStatus nvarchar(255)

DocDelNotFoundReasons

PK Field Name Field Type
PK ReasonNumber int
PK NVTGC nvarchar(20)
  Reason nvarchar(150)
  DefaultNote nvarchar(255)

EFTSSessions

PK Field Name Field Type
PK NVTGC nvarchar(10)
PK BeginDate datetime
PK EndDate datetime
PK GeneratedDate datetime
  SiteCount int
  RecordsCount int
  TotalAmount money

ElecDelAddresses

PK Field Name Field Type
PK Address nvarchar(50)
PK Symbol nvarchar(40)
PK SystemID nvarchar(50)

EMailCopies

PK Field Name Field Type
PK ID int
PK TransactionNumber int
PK EMailDate datetime
  EMailType nvarchar(100)
  EMailReference nvarchar(100)
  EMailTo nvarchar(max)
  EMailFrom nvarchar(max)
  EMailCC nvarchar(max)
  EMailBCC nvarchar(max)
  Subject nvarchar(255)
  Body nvarchar(max)
  Staff nvarchar(20)
  Status nvarchar(20)
  Note nvarchar(255)
  NVTGC nvarchar(10)

EMailImport

PK Field Name Field Type
PK Id int
  EMailNumber int
  NVTGC nvarchar(20)
  EMailImportName nvarchar(50)
  ProcessType nvarchar(50)
  TableName nvarchar(20)
  FieldName nvarchar(100)
  TagValue nvarchar(250)
  DefaultValue nvarchar(250)

EMailRouting

PK Field Name Field Type
PK ProcessType nvarchar(50)
PK Name nvarchar(50)
  DefaultToAddress nvarchar(100)
  DefaultToName nvarchar(100)
  DefaultCCAddress nvarchar(100)
  DefaultSubject nvarchar(100)
  DefaultFromAddress nvarchar(100)
  DefaultFromName nvarchar(100)
  DefaultStatus nvarchar(100)
  LoanTemplate nvarchar(100)
  ArticleTemplate nvarchar(100)
PK NVTGC nvarchar(20)

EMST

PK Field Name Field Type
PK Symbol nvarchar(40)
PK RequestType nvarchar(8)
  DaysToRespond int

ESPUpdate

PK Field Name Field Type
PK TransactionNumber int
PK SystemID nvarchar(16)
PK ILLNumber nvarchar(32)
PK Action nvarchar(50)
PK ProcessType nvarchar(16)
  Updated nvarchar(3)

EventLog

PK Field Name Field Type
PK LogDate datetime
PK Subject nvarchar(20)
PK Status nvarchar(150)
  Staff nvarchar(20)

ExternalFieldMapping

PK Field Name Field Type
PK Name nvarchar(100)
  Value nvarchar(max)
PK SystemID int
PK ExternalType nvarchar(128)
PK ExternalField nvarchar(128)

ExternalRequests

PK Field Name Field Type
PK ID int
  WebPlatformConfigID int
  MappingName nvarchar(100)
  TransactionNumber int
  ExternalID nvarchar(100)
  State nvarchar(50)
  Response nvarchar(max)

FieldCustomizations

PK Field Name Field Type
PK Username nvarchar(50)
PK FieldName nvarchar(50)
  DisplayName nvarchar(50)
  IsHidden bit

GAC

PK Field Name Field Type
PK Name nvarchar(50)
  Description nvarchar(255)

Groups

PK Field Name Field Type
PK GroupNumber int
  NVTGC nvarchar(20)
  GroupName nvarchar(50)
  DueDateOverride int

GroupsLink

PK Field Name Field Type
PK GroupNumber int
PK LenderString nvarchar(50)

History

PK Field Name Field Type
PK TransactionNumber int
PK DateTime datetime
PK Entry nvarchar(250)
  Username nvarchar(50)

ImportedCallNumbers

PK Field Name Field Type
PK TransactionNumber int
  LC nvarchar(50)
  Dewey nvarchar(50)
  Medicine nvarchar(50)

InvoiceDetails

PK Field Name Field Type
PK InvoiceNumber int
PK DetailNumber int
PK DetailType nvarchar(50)
  ItemAmount money
  Citation nvarchar(250)
  BillingDetails nvarchar(255)
  ILLNumber nvarchar(50)
  PaymentNumber int

InvoicePayments

PK Field Name Field Type
PK InvoiceNumber int
PK PaymentNumber int
  PaymentAmount money
  PaymentDate datetime
  PaymentMethod nvarchar(50)
  ReferenceNumber nvarchar(50)
  PaymentNotes nvarchar(100)
  Staff nvarchar(50)

Invoices

PK Field Name Field Type
PK TransactionNumber int
  InvoiceNumber nvarchar(40)
  EntryDate datetime
  InvoiceDate datetime
  ItemAmount money
  OtherFees money

InvoiceSessions

PK Field Name Field Type
PK InvoiceNumber int
  NVTGC nvarchar(10)
  ProcessType nvarchar(20)
  InvoiceType nvarchar(10)
  CustomerName nvarchar(100)
  CustomerSymbol nvarchar(50)
  CustomerNumber int
  BeginDate datetime
  EndDate datetime
  DateGenerated datetime
  TotalAmount money
  BalanceDue money
  Status nvarchar(50)
  StatusDate datetime

InvoiceTracking

PK Field Name Field Type
PK InvoiceNumber int
PK TrackingDate datetime
PK Status nvarchar(100)
  Staff nvarchar(50)

ISOBillingInfo

PK Field Name Field Type
PK TransactionNumber int
  Name nvarchar(50)
  Address1 nvarchar(50)
  Address2 nvarchar(50)
  Address3 nvarchar(50)
  City nvarchar(50)
  State nvarchar(50)
  Country nvarchar(50)
  Zip nvarchar(50)
  AccountNumber nvarchar(50)
  CurrencyCode nvarchar(50)
  MonetaryValue nvarchar(50)
  ReciprocalAgreement nvarchar(3)
  WillPayFee nvarchar(3)
  PaymentProvided nvarchar(3)

ISOControl

PK Field Name FIeld Type
PK ISONumber int
  Direction nvarchar(3)
  ProcessType nvarchar(50)
  APDUName nvarchar(50)
  Processed nvarchar(3)
  TransactionNumber int
  EntryDate datetime
  RequesterId nvarchar(50)
  ResponderId nvarchar(50)
  Transport nvarchar(20)

ISOConversion

PK Field Name Field Type
PK ProcessType nvarchar(50)
PK APDUName nvarchar(50)
PK ConversionNumber int
  ConversionQuery1 nvarchar(250)
  ConversionQuery2 nvarchar(250)
  ConversionQuery3 nvarchar(250)
  ConversionQuery4 nvarchar(250)

ISOCustomization

PK Field Name Field Type
PK ISOType nvarchar(50)
PK ISOValue nvarchar(50)
  ISOName nvarchar(50)
  ILLiadName nvarchar(50)

ISOExchange

PK Field Name Field Type
PK ISONumber int
PK APFUName nvarchar(50)
PK ISOSequenceNumber nvarchar(50)
  ISOName nvarchar(150)
  ISOValue nvarchar(250)
  Level1 int
  Level2 int
  Level3 int
  Level4 int
  Level5 int
  Level6 int
  Level7 int
  Level8 int
  Level9 int
  Level10 int
  Level11 int
  Level12 int
  Level13 int
  Level14 int
  Level15 int

ISOFieldMapping

PK Field Name Field Type
PK ProcessType nvarchar(20)
PK APDUName nvarchar(50)
PK ISOSequenceNumber nvarchar(150)
  ISOName nvarchar(150)
  ActionType nvarchar(50)
  ActionValue nvarchar(50)
  TableName nvarchar(50)
  FieldName nvarchar(100)

ISOState

PK Field Name Field Type
PK ILLiadStatus nvarchar(100)
  ISOStateName nvarchar(50)
  ISOStateNumber int

LenderAddresses

PK Field Name Field Type
PK LenderString nvarchar(40)
PK AddressNumber int
PK NVTGC nvarchar(20)
  LibraryName nvarchar(70)
  Address1 nvarchar(80)
  Address2 nvarchar(80)
  Address3 nvarchar(80)
  Address4 nvarchar(80)
  BAddress1 nvarchar(80)
  BAddress2 nvarchar(80)
  BAddress3 nvarchar(80)
  BAddress4 nvarchar(80)
  Fax nvarchar(15)
  ArielAddress nvarchar(50)
  Phone nvarchar(15)
  PriorityShipping nvarchar(3)
  CopyrightPayer nvarchar(3)
  BillingExempt nvarchar(3)
  ArticleBillingCategory nvarchar(50)
  LoanBillingCategory nvarchar(50)
  LibCopyCharge nvarchar(50)
  LibLoanCharge nvarchar(50)
  LibBillingMethod nvarchar(50)
  EFTS nvarchar(3)
  BorrowingDeptEmail nvarchar(50)
  LendingDeptEmail nvarchar(50)
  OdysseyIP nvarchar(50)
  OverrideIFM nvarchar(3)
  ISO nvarchar(3)
  ISOIPAddress nvarchar(50)
  ISORequesterId nvarchar(50)
  ISOUserName nvarchar(50)
  ISOPassword nvarchar(50)
  WebPassword nvarchar(100)
  Blocked nvarchar(3)
  TrustedSender nvarchar(3)
  TrustedSenderOverride nvarchar(3)
  OverrideOdyssey nvarchar(3)
  DefaultShippingMethodLoan nvarchar(50)
  DefaultShippingMethodArticle nvarchar(50)
  ISOAutoUpdateAddress nvarchar(10)
  ISOTransport nvarchar(20)
  ISOEMailAddress nvarchar(50)
  ESPShipTo nvarchar(500)
  ESPBillTo nvarchar(500)
  RSSID nvarchar(50)
  OdysseyVersion nvarchar(15)

LenderPriorities

PK Field Name Field Type
PK Symbol nvarchar(50)
PK NVTGC nvarchar(50)
  ArticlePriority int
  LoanPriority int

LendingInvoices

PK Field Name Field Type
PK InvoiceNumber int
  DateGenerated datetime
  StartDate datetime
  EndDate datetime
  TotalAmount money
  Status nvarchar(50)

LendingPayments

PK Field Name Field Type
PK PaymentNumber int
  InvoiceNumber int
  Amount money
  PaymentDate datetime
  Method nvarchar(100)
  CheckRefNumber nvarchar(50)
  Notes nvarchar(200)
  AddedBy nvarchar(50)

LendingReasonsForCancellation

PK Field Name Field Type
PK ReasonNumber int
PK NVTGC nvarchar(20)
  Reason nvarchar(150)
  DefaultNote nvarchar(255)
  OCLCCode nvarchar(50)
  DoclineCode nvarchar(50)

LendingReasonsForCond

PK Field Name Field Type
PK ReasonNumber int
PK NVTGC nvarchar(20)
  Reason nvarchar(150)
  DefaultNote nvarchar(255)
  OCLCCode nvarchar(50)
  DoclineCode nvarchar(50)

LendingRequests

PK Field Name Field Type
PK TransactionNumber int
  RequestText nvarchar(max)

LibraryNotes

PK Field Name Field Type
PK NoteId int
  Symbol nvarchar(40)
  AddressNumber int
  NVTGC nvarchar(20)
  NoteDate datetime
  Note nvarchar(4000)
  AddedBy nvarchar(20)

LocalInfo

PK Field Name Field Type
  NVTGC nvarchar(20)
  SystemName nvarchar(50)
  SystemURL nvarchar(100)
  InstitutionName nvarchar(50)
  LibraryName nvarchar(50)
  OCLCSymbol nvarchar(50)
  DoclineSymbol nvarchar(50)
  GeneralContactName nvarchar(50)
  GeneralPhone nvarchar(50)
  GeneralEMailAddress nvarchar(50)
  GeneralAddress1 nvarchar(50)
  GeneralAddress2 nvarchar(50)
  GeneralCity nvarchar(50)
  GeneralState nvarchar(50)
  GeneralZip nvarchar(50)
  GeneralCountry nvarchar(40)
  GeneralFax nvarchar(50)
  GeneralHours nvarchar(100)
  BorrowingContactName nvarchar(50)
  BorrowingPhone nvarchar(50)
  BorrowingEMailAddress nvarchar(50)
  BorrowingAddress1 nvarchar(50)
  BorrowingAddress2 nvarchar(50)
  BorrowingCity nvarchar(50)
  BorrowingState nvarchar(50)
  BorrowingZip nvarchar(50)
  BorrowingFax nvarchar(50)
  BorrowingHours nvarchar(100)
  BorrowingArielAddress nvarchar(50)
  DocDelContactName nvarchar(50)
  DocDelPhone nvarchar(50)
  DocDelEMailAddress nvarchar(50)
  DocDelAddress1 nvarchar(50)
  DocDelAddress2 nvarchar(50)
  DocDelCity nvarchar(50)
  DocDelState nvarchar(50)
  DocDelZip nvarchar(50)
  DocDelFax nvarchar(50)
  DocDelHours nvarchar(100)
  DocDelArielAddress nvarchar(50)
  LendingContactName nvarchar(50)
  LendingPhone nvarchar(50)
  LendingEMailAddress nvarchar(50)
  LendingAddress1 nvarchar(50)
  LendingAddress2 nvarchar(50)
  LendingCity nvarchar(50)
  LendingState nvarchar(50)
  LendingZip nvarchar(50)
  LendingFax nvarchar(50)
  LendingHours nvarchar(100)
  LendingArielAddress nvarchar(50)
  BillingContactName nvarchar(50)
  BillingPhone nvarchar(50)
  BillingEMailAddress nvarchar(50)
  BillingAddress1 nvarchar(50)
  BillingAddress2 nvarchar(50)
  BillingCity nvarchar(50)
  BillingState nvarchar(50)
  BillingZip nvarchar(50)
  BillingFax nvarchar(50)
  BillingHours nvarchar(50)

Log

PK Field Name Field Type
PK ID int
PK LogDateTime datetime
PK Source nvarchar(50)
PK Version nvarchar(50)
  Type nvarchar(50)
  Message nvarchar(255)
  NVTGC nvarchar(10)
  Identifier nvarchar(50)

MARCCountry

PK Field Name Field Type
PK Code nvarchar(3)
  Description nvarchar(50)

MARCLanguage

PK Field Name Field Type
PK Code nvarchar(3)
  Description nvarchar(50)

Notes

PK Field Name Field Type
PK Id int
  TransactionNumber int
  NoteDate datetime
  Note nvarchar(4000)
  AddedBy nvarchar(20)
  NoteType nvarchar(50)

NotificationTemplates

PK Field Name Field Type
PK Name nvarchar(50)
  Description nvarchar(255)
PK NVTGC nvarchar(20)
  FromName nvarchar(100)
  FromAddress nvarchar(100)
  ToName nvarchar(100)
  ToAddress nvarchar(100)
  Subject nvarchar(100)
  CCAddress nvarchar(100)
  BCCAddress nvarchar(100)
  EmailText nvarchar(max)
  SMSText nvarchar(max)

OCLCCollectionData

PK Field Name Field Type
PK ID int
  TransactionNumber int
  OCLCNumber int
  CollectionName nvarchar(255)
  DocumentURL nvarchar(2048)
  ILLTerms nvarchar(255)
  Instructions nvarchar(255)

OCLCDetailedHoldings

PK Field Name Field Type
PK ID int
  LocalHoldingsID int
  CallNumber nvarchar(255)
  HoldingsFormat nvarchar(50)
  ItemDescription nvarchar(255)
  Material nvarchar(255)
  NonPublicNote nvarchar(255)
  Note nvarchar(255)
  PhysicalCondition nvarchar(255)

OCLCLocalHoldings

PK Field Name Field Type
PK ID int
  TransactionNumber int
  LendingPolicy nvarchar(30)
  LendingReproPolicy nvarchar(30)
  LHRSummary nvarchar(255)
  OCLCNumber int
  OrigBib bit

OCLCRequestFieldDisplayOrder

PK Field Name Field Type
PK NVTGC nvarchar(20)
PK ProcessType nvarchar(10)
PK Field nvarchar(50)
  DisplayOrder int

OCLCStatusOverride

PK Field Name Field Type
PK OCLCStatus nvarchar(50)
PK ILLiadStatus nvarchar(50)
PK NVTGC nvarchar(20)

OdysseyAccess

PK Field Name Field Type
PK IPAddress nvarchar(50)
  Symbol nvarchar(16)
  Action nvarchar(16)

OdysseyReceived

PK Field Name Field Type
  ID int
  TransactionNumber int
  Sender nvarchar(50)
  Receiver nvarchar(50)
  DocumentIDTemp nvarchar(50)
  DocumentIDSender nvarchar(50)
  DocumentIDReceiver nvarchar(50)
  TrustedSender nvarchar(10)
  UserAgent nvarchar(50)
  Status nvarchar(50)
  Received datetime

OpenURLMapping

PK Field Name Field Type
PK Id int
  NVTGC nvarchar(20)
  URL_Ver nvarchar(50)
  rfr_id nvarchar(100)
  ILLiadAction nvarchar(50)
  ILLiadFieldName nvarchar(100)
  OpenURLFieldValues nvarchar(250)
  ILLiadValue nvarchar(100)

OriginalRequest

PK Field Name Field Type
PK TransactionNumber int
  OLoanAuthor nvarchar(100)
  OLoanTitle nvarchar(100)
  OPhotoArticleAuthor nvarchar(100)
  OPhotoJournalTitle nvarchar(100)

PrintDetails

PK Field Name Field Type
  SessionID int
  TransactionNumber int

PrintSessions

PK Field Name Field Type
PK SessionID int
  NVTGC nvarchar(20)
  ProcessType nvarchar(10)
  PrintDateTime datetime
  PrintType nvarchar(100)
  ItemsPrinted int

QueueSort

PK Field Name Field Type
PK NVTGC nvarchar(20)
PK SortNumber int
PK QueueName nvarchar(100)
PK ProcessType nvarchar(20)

ReasonForNoHistory

PK Field Name Field Type
PK TransactionNumber int
PK ILLNumber nvarchar(32)
PK OCLCNumber nvarchar(50)
PK Lender nvarchar(10)
  ReasonForNo nvarchar(50)
  ReasonDate nvarchar(50)
PK ID int

ReasonsForCancellation

PK Field Name Field Type
PK ReasonNumber int
PK NVTGC nvarchar(20)
  Reason nvarchar(150)
  DefaultNote nvarchar(255)

ReportQueries

PK Field Name Field Type
PK ReportNumber int
PK NVTGC nvarchar(20)
PK ProcessType nvarchar(15)
PK ReportCategory nvarchar(50)
PK ReportName nvarchar(100)
  ReportDescription nvarchar(255)
  DBFFileName nvarchar(20)
  TextFileName nvarchar(20)
  InternalReportName nvarchar(50)
  ReportQuery1 nvarchar(255)
  ReportQuery2 nvarchar(255)
  ReportQuery3 nvarchar(255)
  ReportQuery4 nvarchar(255)

Resubmission

PK Field Name Field Type
PK TransactionNumber int
PK LendingString nvarchar(150)
PK ILLNumber nvarchar(32)
  ESPNumber nvarchar(32)
  SystemID nvarchar(32)

Routing

PK

Field Name

Field Type

PK RuleNo int
  RuleActive nvarchar(3)
  ProcessType nvarchar(20)
  TransactionStatus nvarchar(40)
  MatchString nvarchar(max)
  NewProcessType nvarchar(20)
  NewTransactionStatus nvarchar(40)
  RuleDescription nvarchar(250)

ServerAddons

PK

Field Name

Field Type
PK ID int
  Name nvarchar(100)
  Configuration nvarchar(max)
  Code nvarchar(max)

ShippingAddresses

PK Field Name Field Type
FK TransactionNumber int
  Attention nvarchar(max)
  Address1 nvarchar(max)
  Address2 nvarchar(max)
  Address3 nvarchar(max)
  Address4 nvarchar(max)

SMSCopies

PK Field Name Field Type
PK ID int
  NotificationDate datetime
  ReferenceType nvarchar(100)
  Reference nvarchar(100)
  To nvarchar(max)
  Message nvarchar(160)
  Staff nvarchar(20)
  Status nvarchar(20)
  Note nvarchar(255)
  NVTGC nvarchar(10)

Staff

PK Field Name Field Type
PK Username nvarchar(20)
  Password nvarchar(255)
  UserGroup nvarchar(20)
  NVTGC nvarchar(20)
  StaffFirstName nvarchar(20)
  StaffLastName nvarchar(20)
  StaffDescription nvarchar(100)
  ClientAccess nvarchar(3)
  OCLCRSSSettingsAccess nvarchar(3)
  WebCircAccess nvarchar(3)
  WebReportsAccess nvarchar(3)
  UserManagerAccess nvarchar(3)
  CustomizationManagerAccess nvarchar(3)
  BillingManagerAccessBorrowing nvarchar(3)
  BillingManagerAccessDocDel nvarchar(3)
  BillingManagerAccessLending nvarchar(3)
  DatabaseManagerAccess nvarchar(3)
  ClientPermissions int

StaffLayouts

PK Field Name Field Type
PK Username nvarchar(50)
PK LayoutType nvarchar(150)
  Layout varbinary(max)

SystemInformation

PK Field Name Field Type
PK Source nvarchar(50)
PK Type nvarchar(50)
  Information nvarchar(255)

TestModeEFTSSessions

PK Field Name Field Type
PK NVTGC nvarchar(10)
PK BeginDate datetime
PK EndDate datetime
PK GeneratedDate datetime
  SiteCount int
  RecordsCount int
  TotalAmount money

TestModeInvoiceDetails

PK Field Name Field Type
PK InvoiceNumber int
PK DetailNumber int
PK DetailType nvarchar(50)
  ItemAmount money
  Citation nvarchar(255)
  BillingDetails nvarchar(255)
  ILLNumber nvarchar(50)
  PaymentNumber int

TestModeInvoicePayments

PK Field Name Field Type
PK InvoiceNumber int
PK PaymentNumber int
  PaymentAmount money
  PaymentDate datetime
  PaymentMethod nvarchar(50)
  ReferenceNumber nvarchar(50)
  PaymentNotes nvarchar(100)
  Staff nvarchar(50)

TestModeInvoiceSessions

PK Field Name Field Type
PK InvoiceNumber int
  NVTGC nvarchar(10)
  ProcessType nvarchar(20)
  InvoiceType nvarchar(10)
  CustomerName nvarchar(100)
  CustomerSymbol nvarchar(50)
  CustomerNumber int
  BeginDate datetime
  EndDate datetime
  DateGenerated datetime
  TotalAmount money
  BalanceDue money
  Status nvarchar(50)
  StatusDate datetime

TestModeInvoiceTracking

PK Field Name Field Type
PK InvoiceNumber int
PK TrackingDate datetime
PK Status nvarchar(100)
  Staff nvarchar(50)

TestModeTransactions

PK Field Name Field Type
PK TransactionNumber int
PK InvoiceNumber int

Tracking

PK Field Name Field Type
PK TransactionNumber int
PK DateTime datetime
PK ChangedTo nvarchar(40)
  ChangedBy nvarchar(50)

TransactionFlags

PK Field Name Field Type
FK FlagID int
FK TransactionNumber int

Transactions

PK Field Name Field Type
PK TransactionNumber int
  Username nvarchar(50)
  RequestType nvarchar(8)
  LoanAuthor nvarchar(100)
  LoanTitle nvarchar(255)
  LoanPublisher nvarchar(50)
  LoanPlace nvarchar(30)
  LoanDate nvarchar(30)
  LoanEdition nvarchar(30)
  PhotoJournalTitle nvarchar(255)
  PhotoJournalVolume nvarchar(30)
  PhotoJournalIssue nvarchar(30)
  PhotoJournalMonth nvarchar(30)
  PhotoJournalYear nvarchar(30)
  PhotoJournalInclusivePages nvarchar(30)
  PhotoArticleAuthor nvarchar(100)
  PhotoArticleTitle nvarchar(250)
  CitedIn nvarchar(max)
  CitedTitle nvarchar(max)
  CitedDate nvarchar(max)
  CitedVolume nvarchar(max)
  CitedPages nvarchar(max)
  NotWantedAfter nvarchar(40)
  AcceptNonEnglish nvarchar(3)
  AcceptAlternateEdition nvarchar(3)
  TransactionStatus nvarchar(40)
  TransactionDate datetime
  ISSN nvarchar(20)
  ILLNumber nvarchar(32)
  ESPNumber nvarchar(32)
  LendingString nvarchar(150)
  BaseFee money
  PerPage money
  Pages int
  DueDate datetime
  RenewalsAllowed nvarchar(3)
  SpecIns nvarchar(40)
  Pieces int
  LibraryUseOnly nvarchar(3)
  AllowPhotocopies nvarchar(3)
  LendingLibrary nvarchar(40)
  ReasonForCancellation nvarchar(150)
  CallNumber nvarchar(100)
  Location nvarchar(255)
  Maxcost nvarchar(50)
  ProcessType nvarchar(10)
  ItemNumber nvarchar(10)
  LenderAddressNumber int
  Ariel nvarchar(3)
  Patron nvarchar(50)
  PhotoItemAuthor nvarchar(100)
  PhotoItemPlace nvarchar(40)
  PhotoItemPublisher nvarchar(40)
  PhotoItemEdition nvarchar(40)
  DocumentType nvarchar(15)
  InternalAcctNo float
  PriorityShipping nvarchar(3)
  Rush nvarchar(30)
  CopyrightAlreadyPaid nvarchar(3)
  WantedBy nvarchar(25)
  SystemID nvarchar(32)
  ReplacementPages nvarchar(3)
  IFMCost nvarchar(30)
  CopyrightPaymentMethod nvarchar(50)
  ShippingOptions nvarchar(50)
  CCCNumber nvarchar(50)
  IntlShippingOptions nvarchar(50)
  ShippingAcctNo nvarchar(50)
  ReferenceNumber nvarchar(50)
  CopyrightComp nvarchar(10)
  TAddress nvarchar(100)
  TAddress2 nvarchar(100)
  TCity nvarchar(50)
  TState nvarchar(50)
  TZip nvarchar(50)
  TCountry nvarchar(50)
  TFax nvarchar(50)
  TEMailAddress nvarchar(50)
  TNumber nvarchar(50)
  HandleWithCare nvarchar(3)
  CopyWithCare nvarchar(3)
  RestrictedUser nvarchar(3)
  ReceivedVia nvarchar(20)
  CancellationCode nvarchar(50)
  BillingCategory nvarchar(50)
  CCSelected nvarchar(3)
  OriginalTN int
  OriginalNVTGC nvarchar(20)
  InProcessDate nvarchar(8)
  InvoiceNumber int
  BorrowerTN int
  WebRequestForm nvarchar(100)
  TName nvarchar(100)
  TAddress3 nvarchar(100)
  IFMPaid nvarchar(3)
  BillingAmount money
  ConnectorErrorStatus nvarchar(50)
  BorrowerNVTGC nvarchar(20)
  CCCOrder nvarchar(3)
  ShippingDetail nvarchar(50)
  ISOStatus nvarchar(50)
  OdysseyErrorStatus nvarchar(50)
  WorldCatLCNumber nvarchar(50)
  Locations nvarchar(255)
  FlagType nvarchar(50)
  FlagNote nvarchar(250)
  CreationDate datetime
  ItemInfo1 nvarchar(255)
  ItemInfo2 nvarchar(255)
  ItemInfo3 nvarchar(255)
  ItemInfo4 nvarchar(255)
  ItemInfo5 nvarchar(255)
  SpecialService nvarchar(3)
  DeliveryMethod nvarchar(25)
  Web nvarchar(3)
  PMID nvarchar(20)
  DOI nvarchar(50)
  LastOverdueNoticeSent int
  ExternalRequest int
  AEUrl nvarchar(50)
  AEPassword nvarchar(50)

Users

PK Field Name Field Type
PK UserName nvarchar(50)
  LastName nvarchar(40)
  FirstName nvarchar(40)
  SSN nvarchar(20)
  Status nvarchar(15)
  EMailAddress nvarchar(50)
  Phone nvarchar(15)
  MobilePhone nvarchar(15)
  Department nvarchar(255)
  NVTGC nvarchar(20)
  Password nvarchar(64)
  NotificationMethod nvarchar(10)
  DeliveryMethod nvarchar(25)
  LoanDeliveryMethod nvarchar(25)
  LastChangedDate datetime
  AuthorizedUsers nvarchar(255)
  Cleared nvarchar(3)
  Web nvarchar(3)
  Address nvarchar(40)
  Address2 nvarchar(40)
  City nvarchar(30)
  State nvarchar(2)
  Zip nvarchar(10)
  Site nvarchar(40)
  ExpirationDate datetime
  Number nvarchar(20)
  UserRequestLimit nvarchar(5)
  Organization nvarchar(50)
  Fax nvarchar(15)
  ShippingAcctNo nvarchar(50)
  ArticleBillingCategory nvarchar(50)
  LoanBillingCategory nvarchar(50)
  Country nvarchar(50)
  SAddress nvarchar(40)
  SAddress2 nvarchar(40)
  SCity nvarchar(30)
  SState nvarchar(2)
  SZip nvarchar(10)
  PasswordHint nvarchar(50)
  SCountry nvarchar(50)
  RSSID nvarchar(50)
  AuthType nvarchar(50)
  UserInfo1 nvarchar(255)
  UserInfo2 nvarchar(255)
  UserInfo3 nvarchar(255)
  UserInfo4 nvarchar(255)
  UserInfo5 nvarchar(255)

UserAccounts

PK Field Name Field Type
PK InternalNo float
  AccountNo nvarchar(100)
  Type nvarchar(40)
  Valid nvarchar(3)
  Description nvarchar(100)
  Active nvarchar(3)
  CCExpirationDate nvarchar(50)
  CCNameOnCard nvarchar(50)

UserAccountsLink

PK Field Name Field Type
PK InternalNo float
PK Username nvarchar(50)

UserNotes

PK Field Name Field Type
PK Username nvarchar(50)
PK NoteDate datetime
  Note nvarchar(4000)
  AddedBy nvarchar(20)

UserNotifications

PK Field Name Field Type
PK ID int
  Username nvarchar(50)
  ActivityType nvarchar(50)
  NotificationType nvarchar(50)

UserValidation

PK Field Name Field Type
PK UserName nvarchar(50)
  UserValidationType nvarchar(4)
  LastName nvarchar(40)
  FirstName nvarchar(40)
  SSN nvarchar(20)
  Status nvarchar(15)
  EMailAddress nvarchar(50)
  Phone nvarchar(15)
  MobilePhone nvarchar(15)
  Department nvarchar(255)
  NVTGC nvarchar(20)
  Password nvarchar(64)
  NotificationMethod nvarchar(10)
  DeliveryMethod nvarchar(25)
  LoanDeliveryMethod nvarchar(25)
  AuthorizedUsers nvarchar(255)
  Web nvarchar(3)
  Address nvarchar(40)
  Address2 nvarchar(40)
  City nvarchar(30)
  State nvarchar(2)
  Zip nvarchar(10)
  Site nvarchar(40)
  Number nvarchar(20)
  Organization nvarchar(50)
  Fax nvarchar(15)
  ArticleBillingCategory nvarchar(50)
  LoanBillingCategory nvarchar(50)
  Country nvarchar(50)
  SAddress nvarchar(40)
  SAddress2 nvarchar(40)
  SCity nvarchar(30)
  SState nvarchar(2)
  SZip nvarchar(10)
  PasswordHint nvarchar(50)
  SCountry nvarchar(50)
  Blocked nvarchar(3)
  PlainTextPassword nvarchar(250)
  UserRequestLimit nvarchar(5)
  UserInfo1 nvarchar(255)
  UserInfo2 nvarchar(255)
  UserInfo3 nvarchar(255)
  UserInfo4 nvarchar(255)
  UserInfo5 nvarchar(255)

WebFormValues

PK Field Name Field Type
PK NVTGC nvarchar(10)
PK Formname nvarchar(40)
PK SubmitButtonValue nvarchar(100)
PK SubmitButtonText nvarchar(100)

WebPlatformConfig

PK Field Name Field Type
PK ID int
  NVTGC nvarchar(20)
  APIKey uniqueidentifier
  BaseWebserviceUrl nvarchar(256)
  Description nvarchar(100)

WebSession

PK Field Name Field Type
PK Username nvarchar(50)
PK SessionID nvarchar(255)
  Expiration datetime
  SessionType nvarchar(50)
  LastFormSignature nvarchar(100)

WebValidation

PK Field Name Field Type
PK NVTGC nvarchar(10)
PK Formname nvarchar(40)
PK Fieldname nvarchar(60)
  Validation nvarchar(200)
  Error nvarchar(200)
  ErrorTag nvarchar(60)

WindowsErrorCodes

PK Field Name Field Type
PK Code int
  ErrorText nvarchar(100)

WorkFormMapping

PK Field Name Field Type
PK NVTGC nvarchar(20)
PK WorkFormType nvarchar(15)
PK OCLCFieldName nvarchar(50)
  ILLiadFields nvarchar(250)
  ConstantDataAction nvarchar(50)

WorldCatInformation

PK Field Name Field Type
  TransactionNumber int
  OCLCNumber nvarchar(20)
  Type nvarchar(50)
  Data nvarchar(255)

ZProfiles

PK Field Name Field Type
PK ProfileName nvarchar(50)
  DBName nvarchar(50)
  Port nvarchar(10)
  SearchSystemNumber nvarchar(200)
  SearchTitle nvarchar(200)
  SearchAuthor nvarchar(200)
  SearchISSN nvarchar(200)
  SearchISBN nvarchar(200)
  SearchDate nvarchar(200)
  SearchKeywordTitle nvarchar(200)
  SearchKeywordAuthor nvarchar(200)
  ZType nvarchar(50)
  ZIdentifier nvarchar(50)
  ZCallNumber nvarchar(50)
  ZAvailability nvarchar(50)
  ZLocation nvarchar(50)
  AvailabilityType nvarchar(50)
  AvailabilityRegExp nvarchar(255)
  AvailableTextType nvarchar(50)
  AvailableText nvarchar(50)
  NotAvailableTextType nvarchar(50)
  NotAvailableText nvarchar(50)

ZSearches

PK Field Name Field Type
PK SearchNumber int
PK NVTGC nvarchar(20)
  SearchName nvarchar(50)
  ServerConfigNumbers nvarchar(100)
  DefaultSearch nvarchar(20)
  SortOrder int

ZServerConfig

PK Field Name Field Type
PK ServerConfigNumber int
PK NVTGC nvarchar(20)
  Name nvarchar(50)
  Server nvarchar(50)
  Port int
  DBName nvarchar(50)
  ServerType nvarchar(50)
  SearchSystemNumber nvarchar(200)
  SearchTitle nvarchar(200)
  SearchAuthor nvarchar(200)
  SearchISSN nvarchar(200)
  SearchISBN nvarchar(200)
  SearchDate nvarchar(200)
  SearchKeywordTitle nvarchar(200)
  SearchKeywordAuthor nvarchar(200)
  AuthUser nvarchar(50)
  AuthPass nvarchar(50)
  ZType nvarchar(50)
  ZIdentifier nvarchar(50)
  ZCallNumber nvarchar(50)
  ZAvailability nvarchar(50)
  ZLocation nvarchar(50)
  AvailabilityType nvarchar(50)
  AvailabilityRegExp nvarchar(255)
  AvailableTextType nvarchar(50)
  AvailableText nvarchar(50)
  NotAvailableTextType nvarchar(50)
  NotAvailableText nvarchar(50)
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.