ILLiad Database Tables

Icon

Atlas product documentation has undergone a migration to the Atlas Systems Support page. We are working internally to try and redirect Prometheus articles. Please take this time to fix any links you have directing users to Prometheus as soon as possible. We will provide an update on deadlines for Prometheus access when we have more information on how that will work. If you have any questions please contact support@atlas-sys.com.

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

PKField NameField Type
 AlertIDint
 IdentifierTypenvarchar(50)
 IdentifierValuenvarchar(50)
 AlertTitlenvarchar(255)
 AlertMessagenvarchar(max)
 CreatedDatedatetime
 ActiveDatedatetime
 ExpirationDatedatetime
 AddedBynvarchar(50)

BarometerExclusions

PKField NameField Type
PKNVTGCnvarchar(100)
PKProcessTypenvarchar(200)
PKExcludeQueuenvarchar(100)

Billing

PKField NameField Type
PKTransactionNumberint
PKInternalNofloat
 Amountmoney
 Notenvarchar(100)
 BillingDatedatetime
 InvoiceDatedatetime
 Processednvarchar(3)

BillingAdditions

PKField NameField Type
PKAdditionNamenvarchar(100)
PKAdditionCategorynvarchar(20)
 BaseFeemoney
 Range1Pagesint
 Range1Amountmoney
 Range2Pagesint
 Range2Amountmoney
 Range3Pagesint
 Range3Amountmoney

BillingDefaults

PKField NameField Type
PKProcessTypenvarchar(10)
PKDocumentTypenvarchar(15)
 DefaultAmountmoney
PKCategorynvarchar(20)
 Range1Pagesint
 Range1Amountmoney
 Range2Pagesint
 Range2Amountmoney
 Range3Pagesint
 Range3Amountmoney

BillingDetails

PKField NameField Type
PKTransactionNumberint
PKChargeNamenvarchar(100)
 ChargeBasemoney
 ChargeUnitmoney
 ChargeQtyint
 ChargeAmountmoney
 ChargeDescnvarchar(250)
 ChargeNotenvarchar(250)
PKChargeDatedatetime

BillingServiceLevels

PKField NameField Type
PKProcessTypenvarchar(50)
PKServiceLevelnvarchar(100)
 Amountmoney

BillingServiceType

PKField NameField Type
PKProcessTypenvarchar(50)
PKServiceTypenvarchar(100)

BillingShippingFees

PKField NameField Type
PKProcessTypenvarchar(50)
PKShippingMethodnvarchar(100)
 Amountmoney

BorrowerStatus

PKField NameField Type
PKBorrowernvarchar(10)
 Statusnvarchar(40)
PKNVTGCnvarchar(20)

BorrowingInvoices

PKField NameField Type
PKInvoiceNumberint
 DateGenerateddatetime
 StartDatedatetime
 EndDatedatetime
 TotalAmountmoney
 Statusnvarchar(50)

BorrowingPayments

PKField NameField Type
PKPaymentNumberint
 InvoiceNumberint
 Amountmoney
 PaymentDatedatetime
 Methodnvarchar(100)
 CheckRefNumbernvarchar(50)
 Notesnvarchar(200)
 AddedBynvarchar(50)

BorrowingRequests

PKField NameField Type
PKTransactionNumberint
 RequestTextnvarchar(max)

Citation

PKField NameField Type
PKTransactionNumberint
 Citation1nvarchar(250)
 Citation2nvarchar(250)
 Citation3nvarchar(250)
 Citation4nvarchar(250)
 Citation5nvarchar(250)
 Citation6nvarchar(250)
 Citation7nvarchar(250)
 Citation8nvarchar(250)

ClientAccess

PKField NameField Type
PKFormnamenvarchar(60)
PKFormtypenvarchar(60)
PKActionnvarchar(60)
 UserGroupsnvarchar(255)
 MenuTextnvarchar(60)
 ActionTextnvarchar(60)

ConnectorDetails

PKField NameField Type
PKIDint
PKSessionIDint
PKConnectorDateTimedatetime
PKConnectorActionnvarchar(50)
PKResultnvarchar(50)
 ILLNumbernvarchar(15)

ConnectorSessions

PKField NameField Type
PKSessionIDint
 SessionBeginDateTimedatetime
 SessionEndDateTimedatetime
 BorrowingReceivesint
 BorrowingReturnsint
 BorrowingRenewalsint
 BorrowingConditionalsint
 BorrowingRenewalNoint
 BorrowingRenewalOKint
 BorrowingRecalledint
 BorrowingShippedint
 BorrowingUnfilledint
 BorrowingWillSupplyint
 BorrowingRequestsint
 LendingYesCopiesint
 LendingYesLoansint
 LendingCancelsint
 LendingConditionalsint
 LendingCompletesint
 LendingRenewalNoint
 LendingRenewalOKint
 LendingRequestsint
 LendingRenewalRequestsint
 LendingConditionalRequestsint
 NVTGCnvarchar(20)
 BorrowingSMOverduenvarchar(20)
 BorrowingSMReceivednvarchar(20)
 LendingSMNotReceivednvarchar(20)
 LendingSMCompletenvarchar(20)
 LendingRecallsnvarchar(20)

CopyrightSessions

PKField NameField Type
PKTransactionNumberint
 DateTimedatetime
PKOrderHeadernvarchar(50)
PKOrderDetailnvarchar(50)
 SubmittedBy 

CustomDropDown

PKField NameField Type
PKNVTGCnvarchar(20)
PKGroupNamenvarchar(100)
PKLabelNamenvarchar(200)
 LabelValuenvarchar(255)

CustomFlags

PKField NameField Type
PKIDint
 NVTGCnvarchar(20)
 FlagNamenvarchar(255)
 IsSystembit

Customization

PKField NameField Type
PKCustKeynvarchar(60)
 Valuenvarchar(255)
PKNVTGCnvarchar(20)
 Descriptionnvarchar(255)
 AdminCatnvarchar(50)
 AdminKeynvarchar(50)
 AdminTypenvarchar(50)

CustomizationTracking

PKField NameField Type
PKCustKeynvarchar(100)
 ValueChangedFromnvarchar(1000)
 ValueChangedTonvarchar(1000)
PKNVTGCnvarchar(50)
PKChangedTimedatetime
 ChangedBynvarchar(20)

CustomQueues

PKField NameField Type
PKQueueNamenvarchar(40)
PKProcessTypenvarchar(50)
PKNVTGCnvarchar(20)

DefaultAccounts

PKField NameField Type
PKNVTGCnvarchar(10)
PKStatusnvarchar(50)
 AccountNonvarchar(100)
 Typenvarchar(40)
 Descriptionnvarchar(100)
 CCExpirationDatenvarchar(50)
 CCNameOnCardnvarchar(50)
 ArticleBillingCategorynvarchar(50)
 LoanBillingCategorynvarchar(50)

DeliveryLocations

PKField NameField Type
PKSymbolnvarchar(20)
 Valuenvarchar(25)

DisplayStatuses

PKField NameField Type
PKIDint
 NVTGCnvarchar(10)
 ProcessTypenvarchar(50)
 TransactionStatusnvarchar(255)
 WebDisplayStatusnvarchar(255)

DocDelNotFoundReasons

PKField NameField Type
PKReasonNumberint
PKNVTGCnvarchar(20)
 Reasonnvarchar(150)
 DefaultNotenvarchar(255)

EFTSSessions

PKField NameField Type
PKNVTGCnvarchar(10)
PKBeginDatedatetime
PKEndDatedatetime
PKGeneratedDatedatetime
 SiteCountint
 RecordsCountint
 TotalAmountmoney

ElecDelAddresses

PKField NameField Type
PKAddressnvarchar(50)
PKSymbolnvarchar(40)
PKSystemIDnvarchar(50)

EMailCopies

PKField NameField Type
PKIDint
PKTransactionNumberint
PKEMailDatedatetime
 EMailTypenvarchar(100)
 EMailReferencenvarchar(100)
 EMailTonvarchar(max)
 EMailFromnvarchar(max)
 EMailCCnvarchar(max)
 EMailBCCnvarchar(max)
 Subjectnvarchar(255)
 Bodynvarchar(max)
 Staffnvarchar(20)
 Statusnvarchar(20)
 Notenvarchar(255)
 NVTGCnvarchar(10)

EMailImport

PKField NameField Type
PKIdint
 EMailNumberint
 NVTGCnvarchar(20)
 EMailImportNamenvarchar(50)
 ProcessTypenvarchar(50)
 TableNamenvarchar(20)
 FieldNamenvarchar(100)
 TagValuenvarchar(250)
 DefaultValuenvarchar(250)

EMailRouting

PKField NameField Type
PKProcessTypenvarchar(50)
PKNamenvarchar(50)
 DefaultToAddressnvarchar(100)
 DefaultToNamenvarchar(100)
 DefaultCCAddressnvarchar(100)
 DefaultSubjectnvarchar(100)
 DefaultFromAddressnvarchar(100)
 DefaultFromNamenvarchar(100)
 DefaultStatusnvarchar(100)
 LoanTemplatenvarchar(100)
 ArticleTemplatenvarchar(100)
PKNVTGCnvarchar(20)

EMST

PKField NameField Type
PKSymbolnvarchar(40)
PKRequestTypenvarchar(8)
 DaysToRespondint

ESPUpdate

PKField NameField Type
PKTransactionNumberint
PKSystemIDnvarchar(16)
PKILLNumbernvarchar(32)
PKActionnvarchar(50)
PKProcessTypenvarchar(16)
 Updatednvarchar(3)

EventLog

PKField NameField Type
PKLogDatedatetime
PKSubjectnvarchar(20)
PKStatusnvarchar(150)
 Staffnvarchar(20)

ExternalFieldMapping

PKField NameField Type
PKNamenvarchar(100)
 Valuenvarchar(max)
PKSystemIDint
PKExternalTypenvarchar(128)
PKExternalFieldnvarchar(128)

ExternalRequests

PKField NameField Type
PKIDint
 WebPlatformConfigIDint
 MappingNamenvarchar(100)
 TransactionNumberint
 ExternalIDnvarchar(100)
 Statenvarchar(50)
 Responsenvarchar(max)

FieldCustomizations

PKField NameField Type
PKUsernamenvarchar(50)
PKFieldNamenvarchar(50)
 DisplayNamenvarchar(50)
 IsHiddenbit

GAC

PKField NameField Type
PKNamenvarchar(50)
 Descriptionnvarchar(255)

Groups

PKField NameField Type
PKGroupNumberint
 NVTGCnvarchar(20)
 GroupNamenvarchar(50)
 DueDateOverrideint

GroupsLink

PKField NameField Type
PKGroupNumberint
PKLenderStringnvarchar(50)

History

PKField NameField Type
PKTransactionNumberint
PKDateTimedatetime
PKEntrynvarchar(250)
 Usernamenvarchar(50)

ImportedCallNumbers

PKField NameField Type
PKTransactionNumberint
 LCnvarchar(50)
 Deweynvarchar(50)
 Medicinenvarchar(50)

InvoiceDetails

PKField NameField Type
PKInvoiceNumberint
PKDetailNumberint
PKDetailTypenvarchar(50)
 ItemAmountmoney
 Citationnvarchar(250)
 BillingDetailsnvarchar(255)
 ILLNumbernvarchar(50)
 PaymentNumberint

InvoicePayments

PKField NameField Type
PKInvoiceNumberint
PKPaymentNumberint
 PaymentAmountmoney
 PaymentDatedatetime
 PaymentMethodnvarchar(50)
 ReferenceNumbernvarchar(50)
 PaymentNotesnvarchar(100)
 Staffnvarchar(50)

Invoices

PKField NameField Type
PKTransactionNumberint
 InvoiceNumbernvarchar(40)
 EntryDatedatetime
 InvoiceDatedatetime
 ItemAmountmoney
 OtherFeesmoney

InvoiceSessions

PKField NameField Type
PKInvoiceNumberint
 NVTGCnvarchar(10)
 ProcessTypenvarchar(20)
 InvoiceTypenvarchar(10)
 CustomerNamenvarchar(100)
 CustomerSymbolnvarchar(50)
 CustomerNumberint
 BeginDatedatetime
 EndDatedatetime
 DateGenerateddatetime
 TotalAmountmoney
 BalanceDuemoney
 Statusnvarchar(50)
 StatusDatedatetime

InvoiceTracking

PKField NameField Type
PKInvoiceNumberint
PKTrackingDatedatetime
PKStatusnvarchar(100)
 Staffnvarchar(50)

ISOBillingInfo

PKField NameField Type
PKTransactionNumberint
 Namenvarchar(50)
 Address1nvarchar(50)
 Address2nvarchar(50)
 Address3nvarchar(50)
 Citynvarchar(50)
 Statenvarchar(50)
 Countrynvarchar(50)
 Zipnvarchar(50)
 AccountNumbernvarchar(50)
 CurrencyCodenvarchar(50)
 MonetaryValuenvarchar(50)
 ReciprocalAgreementnvarchar(3)
 WillPayFeenvarchar(3)
 PaymentProvidednvarchar(3)

ISOControl

PKField NameFIeld Type
PKISONumberint
 Directionnvarchar(3)
 ProcessTypenvarchar(50)
 APDUNamenvarchar(50)
 Processednvarchar(3)
 TransactionNumberint
 EntryDatedatetime
 RequesterIdnvarchar(50)
 ResponderIdnvarchar(50)
 Transportnvarchar(20)

ISOConversion

PKField NameField Type
PKProcessTypenvarchar(50)
PKAPDUNamenvarchar(50)
PKConversionNumberint
 ConversionQuery1nvarchar(250)
 ConversionQuery2nvarchar(250)
 ConversionQuery3nvarchar(250)
 ConversionQuery4nvarchar(250)

ISOCustomization

PKField NameField Type
PKISOTypenvarchar(50)
PKISOValuenvarchar(50)
 ISONamenvarchar(50)
 ILLiadNamenvarchar(50)

ISOExchange

PKField NameField Type
PKISONumberint
PKAPFUNamenvarchar(50)
PKISOSequenceNumbernvarchar(50)
 ISONamenvarchar(150)
 ISOValuenvarchar(250)
 Level1int
 Level2int
 Level3int
 Level4int
 Level5int
 Level6int
 Level7int
 Level8int
 Level9int
 Level10int
 Level11int
 Level12int
 Level13int
 Level14int
 Level15int

ISOFieldMapping

PKField NameField Type
PKProcessTypenvarchar(20)
PKAPDUNamenvarchar(50)
PKISOSequenceNumbernvarchar(150)
 ISONamenvarchar(150)
 ActionTypenvarchar(50)
 ActionValuenvarchar(50)
 TableNamenvarchar(50)
 FieldNamenvarchar(100)

ISOState

PKField NameField Type
PKILLiadStatusnvarchar(100)
 ISOStateNamenvarchar(50)
 ISOStateNumberint

LenderAddresses

PKField NameField Type
PKLenderStringnvarchar(40)
PKAddressNumberint
PKNVTGCnvarchar(20)
 LibraryNamenvarchar(70)
 Address1nvarchar(80)
 Address2nvarchar(80)
 Address3nvarchar(80)
 Address4nvarchar(80)
 BAddress1nvarchar(80)
 BAddress2nvarchar(80)
 BAddress3nvarchar(80)
 BAddress4nvarchar(80)
 Faxnvarchar(15)
 ArielAddressnvarchar(50)
 Phonenvarchar(15)
 PriorityShippingnvarchar(3)
 CopyrightPayernvarchar(3)
 BillingExemptnvarchar(3)
 ArticleBillingCategorynvarchar(50)
 LoanBillingCategorynvarchar(50)
 LibCopyChargenvarchar(50)
 LibLoanChargenvarchar(50)
 LibBillingMethodnvarchar(50)
 EFTSnvarchar(3)
 BorrowingDeptEmailnvarchar(50)
 LendingDeptEmailnvarchar(50)
 OdysseyIPnvarchar(50)
 OverrideIFMnvarchar(3)
 ISOnvarchar(3)
 ISOIPAddressnvarchar(50)
 ISORequesterIdnvarchar(50)
 ISOUserNamenvarchar(50)
 ISOPasswordnvarchar(50)
 WebPasswordnvarchar(100)
 Blockednvarchar(3)
 TrustedSendernvarchar(3)
 TrustedSenderOverridenvarchar(3)
 OverrideOdysseynvarchar(3)
 DefaultShippingMethodLoannvarchar(50)
 DefaultShippingMethodArticlenvarchar(50)
 ISOAutoUpdateAddressnvarchar(10)
 ISOTransportnvarchar(20)
 ISOEMailAddressnvarchar(50)
 ESPShipTonvarchar(500)
 ESPBillTonvarchar(500)
 RSSIDnvarchar(50)
 OdysseyVersionnvarchar(15)

LenderPriorities

PKField NameField Type
PKSymbolnvarchar(50)
PKNVTGCnvarchar(50)
 ArticlePriorityint
 LoanPriorityint

LendingInvoices

PKField NameField Type
PKInvoiceNumberint
 DateGenerateddatetime
 StartDatedatetime
 EndDatedatetime
 TotalAmountmoney
 Statusnvarchar(50)

LendingPayments

PKField NameField Type
PKPaymentNumberint
 InvoiceNumberint
 Amountmoney
 PaymentDatedatetime
 Methodnvarchar(100)
 CheckRefNumbernvarchar(50)
 Notesnvarchar(200)
 AddedBynvarchar(50)

LendingReasonsForCancellation

PKField NameField Type
PKReasonNumberint
PKNVTGCnvarchar(20)
 Reasonnvarchar(150)
 DefaultNotenvarchar(255)
 OCLCCodenvarchar(50)
 DoclineCodenvarchar(50)

LendingReasonsForCond

PKField NameField Type
PKReasonNumberint
PKNVTGCnvarchar(20)
 Reasonnvarchar(150)
 DefaultNotenvarchar(255)
 OCLCCodenvarchar(50)
 DoclineCodenvarchar(50)

LendingRequests

PKField NameField Type
PKTransactionNumberint
 RequestTextnvarchar(max)

LibraryNotes

PKField NameField Type
PKNoteIdint
 Symbolnvarchar(40)
 AddressNumberint
 NVTGCnvarchar(20)
 NoteDatedatetime
 Notenvarchar(4000)
 AddedBynvarchar(20)

LocalInfo

PKField NameField Type
 NVTGCnvarchar(20)
 SystemNamenvarchar(50)
 SystemURLnvarchar(100)
 InstitutionNamenvarchar(50)
 LibraryNamenvarchar(50)
 OCLCSymbolnvarchar(50)
 DoclineSymbolnvarchar(50)
 GeneralContactNamenvarchar(50)
 GeneralPhonenvarchar(50)
 GeneralEMailAddressnvarchar(50)
 GeneralAddress1nvarchar(50)
 GeneralAddress2nvarchar(50)
 GeneralCitynvarchar(50)
 GeneralStatenvarchar(50)
 GeneralZipnvarchar(50)
 GeneralCountrynvarchar(40)
 GeneralFaxnvarchar(50)
 GeneralHoursnvarchar(100)
 BorrowingContactNamenvarchar(50)
 BorrowingPhonenvarchar(50)
 BorrowingEMailAddressnvarchar(50)
 BorrowingAddress1nvarchar(50)
 BorrowingAddress2nvarchar(50)
 BorrowingCitynvarchar(50)
 BorrowingStatenvarchar(50)
 BorrowingZipnvarchar(50)
 BorrowingFaxnvarchar(50)
 BorrowingHoursnvarchar(100)
 BorrowingArielAddressnvarchar(50)
 DocDelContactNamenvarchar(50)
 DocDelPhonenvarchar(50)
 DocDelEMailAddressnvarchar(50)
 DocDelAddress1nvarchar(50)
 DocDelAddress2nvarchar(50)
 DocDelCitynvarchar(50)
 DocDelStatenvarchar(50)
 DocDelZipnvarchar(50)
 DocDelFaxnvarchar(50)
 DocDelHoursnvarchar(100)
 DocDelArielAddressnvarchar(50)
 LendingContactNamenvarchar(50)
 LendingPhonenvarchar(50)
 LendingEMailAddressnvarchar(50)
 LendingAddress1nvarchar(50)
 LendingAddress2nvarchar(50)
 LendingCitynvarchar(50)
 LendingStatenvarchar(50)
 LendingZipnvarchar(50)
 LendingFaxnvarchar(50)
 LendingHoursnvarchar(100)
 LendingArielAddressnvarchar(50)
 BillingContactNamenvarchar(50)
 BillingPhonenvarchar(50)
 BillingEMailAddressnvarchar(50)
 BillingAddress1nvarchar(50)
 BillingAddress2nvarchar(50)
 BillingCitynvarchar(50)
 BillingStatenvarchar(50)
 BillingZipnvarchar(50)
 BillingFaxnvarchar(50)
 BillingHoursnvarchar(50)

Log

PKField NameField Type
PKIDint
PKLogDateTimedatetime
PKSourcenvarchar(50)
PKVersionnvarchar(50)
 Typenvarchar(50)
 Messagenvarchar(255)
 NVTGCnvarchar(10)
 Identifiernvarchar(50)

MARCCountry

PKField NameField Type
PKCodenvarchar(3)
 Descriptionnvarchar(50)

MARCLanguage

PKField NameField Type
PKCodenvarchar(3)
 Descriptionnvarchar(50)

Notes

PKField NameField Type
PKIdint
 TransactionNumberint
 NoteDatedatetime
 Notenvarchar(4000)
 AddedBynvarchar(20)
 NoteTypenvarchar(50)

NotificationTemplates

PKField NameField Type
PKNamenvarchar(50)
 Descriptionnvarchar(255)
PKNVTGCnvarchar(20)
 FromNamenvarchar(100)
 FromAddressnvarchar(100)
 ToNamenvarchar(100)
 ToAddressnvarchar(100)
 Subjectnvarchar(100)
 CCAddressnvarchar(100)
 BCCAddressnvarchar(100)
 EmailTextnvarchar(max)
 SMSTextnvarchar(max)

OCLCCollectionData

PKField NameField Type
PKIDint
 TransactionNumberint
 OCLCNumberint
 CollectionNamenvarchar(255)
 DocumentURLnvarchar(2048)
 ILLTermsnvarchar(255)
 Instructionsnvarchar(255)

OCLCDetailedHoldings

PKField NameField Type
PKIDint
 LocalHoldingsIDint
 CallNumbernvarchar(255)
 HoldingsFormatnvarchar(50)
 ItemDescriptionnvarchar(255)
 Materialnvarchar(255)
 NonPublicNotenvarchar(255)
 Notenvarchar(255)
 PhysicalConditionnvarchar(255)

OCLCLocalHoldings

PKField NameField Type
PKIDint
 TransactionNumberint
 LendingPolicynvarchar(30)
 LendingReproPolicynvarchar(30)
 LHRSummarynvarchar(255)
 OCLCNumberint
 OrigBibbit

OCLCRequestFieldDisplayOrder

PKField NameField Type
PKNVTGCnvarchar(20)
PKProcessTypenvarchar(10)
PKFieldnvarchar(50)
 DisplayOrderint

OCLCStatusOverride

PKField NameField Type
PKOCLCStatusnvarchar(50)
PKILLiadStatusnvarchar(50)
PKNVTGCnvarchar(20)

OdysseyAccess

PKField NameField Type
PKIPAddressnvarchar(50)
 Symbolnvarchar(16)
 Actionnvarchar(16)

OdysseyReceived

PKField NameField Type
 IDint
 TransactionNumberint
 Sendernvarchar(50)
 Receivernvarchar(50)
 DocumentIDTempnvarchar(50)
 DocumentIDSendernvarchar(50)
 DocumentIDReceivernvarchar(50)
 TrustedSendernvarchar(10)
 UserAgentnvarchar(50)
 Statusnvarchar(50)
 Receiveddatetime

OpenURLMapping

PKField NameField Type
PKIdint
 NVTGCnvarchar(20)
 URL_Vernvarchar(50)
 rfr_idnvarchar(100)
 ILLiadActionnvarchar(50)
 ILLiadFieldNamenvarchar(100)
 OpenURLFieldValuesnvarchar(250)
 ILLiadValuenvarchar(100)

OriginalRequest

PKField NameField Type
PKTransactionNumberint
 OLoanAuthornvarchar(100)
 OLoanTitlenvarchar(100)
 OPhotoArticleAuthornvarchar(100)
 OPhotoJournalTitlenvarchar(100)

PrintDetails

PKField NameField Type
 SessionIDint
 TransactionNumberint

PrintSessions

PKField NameField Type
PKSessionIDint
 NVTGCnvarchar(20)
 ProcessTypenvarchar(10)
 PrintDateTimedatetime
 PrintTypenvarchar(100)
 ItemsPrintedint

QueueSort

PKField NameField Type
PKNVTGCnvarchar(20)
PKSortNumberint
PKQueueNamenvarchar(100)
PKProcessTypenvarchar(20)

ReasonForNoHistory

PKField NameField Type
PKTransactionNumberint
PKILLNumbernvarchar(32)
PKOCLCNumbernvarchar(50)
PKLendernvarchar(10)
 ReasonForNonvarchar(50)
 ReasonDatenvarchar(50)
PKIDint

ReasonsForCancellation

PKField NameField Type
PKReasonNumberint
PKNVTGCnvarchar(20)
 Reasonnvarchar(150)
 DefaultNotenvarchar(255)

ReportQueries

PKField NameField Type
PKReportNumberint
PKNVTGCnvarchar(20)
PKProcessTypenvarchar(15)
PKReportCategorynvarchar(50)
PKReportNamenvarchar(100)
 ReportDescriptionnvarchar(255)
 DBFFileNamenvarchar(20)
 TextFileNamenvarchar(20)
 InternalReportNamenvarchar(50)
 ReportQuery1nvarchar(255)
 ReportQuery2nvarchar(255)
 ReportQuery3nvarchar(255)
 ReportQuery4nvarchar(255)

Resubmission

PKField NameField Type
PKTransactionNumberint
PKLendingStringnvarchar(150)
PKILLNumbernvarchar(32)
 ESPNumbernvarchar(32)
 SystemIDnvarchar(32)

Routing

PKField NameField Type
PKRuleNoint
 RuleActivenvarchar(3)
 ProcessTypenvarchar(20)
 TransactionStatusnvarchar(40)
 MatchStringnvarchar(max)
 NewProcessTypenvarchar(20)
 NewTransactionStatusnvarchar(40)
 RuleDescriptionnvarchar(250)

ServerAddons

PKField NameField Type
PKIDint
 Namenvarchar(100)
 Configurationnvarchar(max)
 Codenvarchar(max)

ShippingAddresses

PKField NameField Type
FKTransactionNumberint
 Attentionnvarchar(max)
 Address1nvarchar(max)
 Address2nvarchar(max)
 Address3nvarchar(max)
 Address4nvarchar(max)

SMSCopies

PKField NameField Type
PKIDint
 NotificationDatedatetime
 ReferenceTypenvarchar(100)
 Referencenvarchar(100)
 Tonvarchar(max)
 Messagenvarchar(160)
 Staffnvarchar(20)
 Statusnvarchar(20)
 Notenvarchar(255)
 NVTGCnvarchar(10)

Staff

PKField NameField Type
PKUsernamenvarchar(20)
 Passwordnvarchar(255)
 UserGroupnvarchar(20)
 NVTGCnvarchar(20)
 StaffFirstNamenvarchar(20)
 StaffLastNamenvarchar(20)
 StaffDescriptionnvarchar(100)
 ClientAccessnvarchar(3)
 OCLCRSSSettingsAccessnvarchar(3)
 WebCircAccessnvarchar(3)
 WebReportsAccessnvarchar(3)
 UserManagerAccessnvarchar(3)
 CustomizationManagerAccessnvarchar(3)
 BillingManagerAccessBorrowingnvarchar(3)
 BillingManagerAccessDocDelnvarchar(3)
 BillingManagerAccessLendingnvarchar(3)
 DatabaseManagerAccessnvarchar(3)
 ClientPermissionsint

StaffLayouts

PKField NameField Type
PKUsernamenvarchar(50)
PKLayoutTypenvarchar(150)
 Layoutvarbinary(max)

SystemInformation

PKField NameField Type
PKSourcenvarchar(50)
PKTypenvarchar(50)
 Informationnvarchar(255)

TestModeEFTSSessions

PKField NameField Type
PKNVTGCnvarchar(10)
PKBeginDatedatetime
PKEndDatedatetime
PKGeneratedDatedatetime
 SiteCountint
 RecordsCountint
 TotalAmountmoney

TestModeInvoiceDetails

PKField NameField Type
PKInvoiceNumberint
PKDetailNumberint
PKDetailTypenvarchar(50)
 ItemAmountmoney
 Citationnvarchar(255)
 BillingDetailsnvarchar(255)
 ILLNumbernvarchar(50)
 PaymentNumberint

TestModeInvoicePayments

PKField NameField Type
PKInvoiceNumberint
PKPaymentNumberint
 PaymentAmountmoney
 PaymentDatedatetime
 PaymentMethodnvarchar(50)
 ReferenceNumbernvarchar(50)
 PaymentNotesnvarchar(100)
 Staffnvarchar(50)

TestModeInvoiceSessions

PKField NameField Type
PKInvoiceNumberint
 NVTGCnvarchar(10)
 ProcessTypenvarchar(20)
 InvoiceTypenvarchar(10)
 CustomerNamenvarchar(100)
 CustomerSymbolnvarchar(50)
 CustomerNumberint
 BeginDatedatetime
 EndDatedatetime
 DateGenerateddatetime
 TotalAmountmoney
 BalanceDuemoney
 Statusnvarchar(50)
 StatusDatedatetime

TestModeInvoiceTracking

PKField NameField Type
PKInvoiceNumberint
PKTrackingDatedatetime
PKStatusnvarchar(100)
 Staffnvarchar(50)

TestModeTransactions

PKField NameField Type
PKTransactionNumberint
PKInvoiceNumberint

Tracking

PKField NameField Type
PKTransactionNumberint
PKDateTimedatetime
PKChangedTonvarchar(40)
 ChangedBynvarchar(50)

TransactionFlags

PKField NameField Type
FKFlagIDint
FKTransactionNumberint

Transactions

PKField NameField Type
PKTransactionNumberint
 Usernamenvarchar(50)
 RequestTypenvarchar(8)
 LoanAuthornvarchar(100)
 LoanTitlenvarchar(255)
 LoanPublishernvarchar(50)
 LoanPlacenvarchar(30)
 LoanDatenvarchar(30)
 LoanEditionnvarchar(30)
 PhotoJournalTitlenvarchar(255)
 PhotoJournalVolumenvarchar(30)
 PhotoJournalIssuenvarchar(30)
 PhotoJournalMonthnvarchar(30)
 PhotoJournalYearnvarchar(30)
 PhotoJournalInclusivePagesnvarchar(30)
 PhotoArticleAuthornvarchar(100)
 PhotoArticleTitlenvarchar(250)
 CitedInnvarchar(max)
 CitedTitlenvarchar(max)
 CitedDatenvarchar(max)
 CitedVolumenvarchar(max)
 CitedPagesnvarchar(max)
 NotWantedAfternvarchar(40)
 AcceptNonEnglishnvarchar(3)
 AcceptAlternateEditionnvarchar(3)
 TransactionStatusnvarchar(40)
 TransactionDatedatetime
 ISSNnvarchar(20)
 ILLNumbernvarchar(32)
 ESPNumbernvarchar(32)
 LendingStringnvarchar(150)
 BaseFeemoney
 PerPagemoney
 Pagesint
 DueDatedatetime
 RenewalsAllowednvarchar(3)
 SpecInsnvarchar(40)
 Piecesint
 LibraryUseOnlynvarchar(3)
 AllowPhotocopiesnvarchar(3)
 LendingLibrarynvarchar(40)
 ReasonForCancellationnvarchar(150)
 CallNumbernvarchar(100)
 Locationnvarchar(255)
 Maxcostnvarchar(50)
 ProcessTypenvarchar(10)
 ItemNumbernvarchar(10)
 LenderAddressNumberint
 Arielnvarchar(3)
 Patronnvarchar(50)
 PhotoItemAuthornvarchar(100)
 PhotoItemPlacenvarchar(40)
 PhotoItemPublishernvarchar(40)
 PhotoItemEditionnvarchar(40)
 DocumentTypenvarchar(15)
 InternalAcctNofloat
 PriorityShippingnvarchar(3)
 Rushnvarchar(30)
 CopyrightAlreadyPaidnvarchar(3)
 WantedBynvarchar(25)
 SystemIDnvarchar(32)
 ReplacementPagesnvarchar(3)
 IFMCostnvarchar(30)
 CopyrightPaymentMethodnvarchar(50)
 ShippingOptionsnvarchar(50)
 CCCNumbernvarchar(50)
 IntlShippingOptionsnvarchar(50)
 ShippingAcctNonvarchar(50)
 ReferenceNumbernvarchar(50)
 CopyrightCompnvarchar(10)
 TAddressnvarchar(100)
 TAddress2nvarchar(100)
 TCitynvarchar(50)
 TStatenvarchar(50)
 TZipnvarchar(50)
 TCountrynvarchar(50)
 TFaxnvarchar(50)
 TEMailAddressnvarchar(50)
 TNumbernvarchar(50)
 HandleWithCarenvarchar(3)
 CopyWithCarenvarchar(3)
 RestrictedUsernvarchar(3)
 ReceivedVianvarchar(20)
 CancellationCodenvarchar(50)
 BillingCategorynvarchar(50)
 CCSelectednvarchar(3)
 OriginalTNint
 OriginalNVTGCnvarchar(20)
 InProcessDatenvarchar(8)
 InvoiceNumberint
 BorrowerTNint
 WebRequestFormnvarchar(100)
 TNamenvarchar(100)
 TAddress3nvarchar(100)
 IFMPaidnvarchar(3)
 BillingAmountmoney
 ConnectorErrorStatusnvarchar(50)
 BorrowerNVTGCnvarchar(20)
 CCCOrdernvarchar(3)
 ShippingDetailnvarchar(50)
 ISOStatusnvarchar(50)
 OdysseyErrorStatusnvarchar(50)
 WorldCatLCNumbernvarchar(50)
 Locationsnvarchar(255)
 FlagTypenvarchar(50)
 FlagNotenvarchar(250)
 CreationDatedatetime
 ItemInfo1nvarchar(255)
 ItemInfo2nvarchar(255)
 ItemInfo3nvarchar(255)
 ItemInfo4nvarchar(255)
 ItemInfo5nvarchar(255)
 SpecialServicenvarchar(3)
 DeliveryMethodnvarchar(25)
 Webnvarchar(3)
 PMIDnvarchar(20)
 DOInvarchar(50)
 LastOverdueNoticeSentint
 ExternalRequestint
 AEUrlnvarchar(50)
 AEPasswordnvarchar(50)

Users

PKField NameField Type
PKUserNamenvarchar(50)
 LastNamenvarchar(40)
 FirstNamenvarchar(40)
 SSNnvarchar(20)
 Statusnvarchar(15)
 EMailAddressnvarchar(50)
 Phonenvarchar(15)
 MobilePhonenvarchar(15)
 Departmentnvarchar(255)
 NVTGCnvarchar(20)
 Passwordnvarchar(64)
 NotificationMethodnvarchar(10)
 DeliveryMethodnvarchar(25)
 LoanDeliveryMethodnvarchar(25)
 LastChangedDatedatetime
 AuthorizedUsersnvarchar(255)
 Clearednvarchar(3)
 Webnvarchar(3)
 Addressnvarchar(40)
 Address2nvarchar(40)
 Citynvarchar(30)
 Statenvarchar(2)
 Zipnvarchar(10)
 Sitenvarchar(40)
 ExpirationDatedatetime
 Numbernvarchar(20)
 UserRequestLimitnvarchar(5)
 Organizationnvarchar(50)
 Faxnvarchar(15)
 ShippingAcctNonvarchar(50)
 ArticleBillingCategorynvarchar(50)
 LoanBillingCategorynvarchar(50)
 Countrynvarchar(50)
 SAddressnvarchar(40)
 SAddress2nvarchar(40)
 SCitynvarchar(30)
 SStatenvarchar(2)
 SZipnvarchar(10)
 PasswordHintnvarchar(50)
 SCountrynvarchar(50)
 RSSIDnvarchar(50)
 AuthTypenvarchar(50)
 UserInfo1nvarchar(255)
 UserInfo2nvarchar(255)
 UserInfo3nvarchar(255)
 UserInfo4nvarchar(255)
 UserInfo5nvarchar(255)

UserAccounts

PKField NameField Type
PKInternalNofloat
 AccountNonvarchar(100)
 Typenvarchar(40)
 Validnvarchar(3)
 Descriptionnvarchar(100)
 Activenvarchar(3)
 CCExpirationDatenvarchar(50)
 CCNameOnCardnvarchar(50)

UserAccountsLink

PKField NameField Type
PKInternalNofloat
PKUsernamenvarchar(50)

UserNotes

PKField NameField Type
PKUsernamenvarchar(50)
PKNoteDatedatetime
 Notenvarchar(4000)
 AddedBynvarchar(20)

UserNotifications

PKField NameField Type
PKIDint
 Usernamenvarchar(50)
 ActivityTypenvarchar(50)
 NotificationTypenvarchar(50)

UserValidation

PKField NameField Type
PKUserNamenvarchar(50)
 UserValidationTypenvarchar(4)
 LastNamenvarchar(40)
 FirstNamenvarchar(40)
 SSNnvarchar(20)
 Statusnvarchar(15)
 EMailAddressnvarchar(50)
 Phonenvarchar(15)
 MobilePhonenvarchar(15)
 Departmentnvarchar(255)
 NVTGCnvarchar(20)
 Passwordnvarchar(64)
 NotificationMethodnvarchar(10)
 DeliveryMethodnvarchar(25)
 LoanDeliveryMethodnvarchar(25)
 AuthorizedUsersnvarchar(255)
 Webnvarchar(3)
 Addressnvarchar(40)
 Address2nvarchar(40)
 Citynvarchar(30)
 Statenvarchar(2)
 Zipnvarchar(10)
 Sitenvarchar(40)
 Numbernvarchar(20)
 Organizationnvarchar(50)
 Faxnvarchar(15)
 ArticleBillingCategorynvarchar(50)
 LoanBillingCategorynvarchar(50)
 Countrynvarchar(50)
 SAddressnvarchar(40)
 SAddress2nvarchar(40)
 SCitynvarchar(30)
 SStatenvarchar(2)
 SZipnvarchar(10)
 PasswordHintnvarchar(50)
 SCountrynvarchar(50)
 Blockednvarchar(3)
 PlainTextPasswordnvarchar(250)
 UserRequestLimitnvarchar(5)
 UserInfo1nvarchar(255)
 UserInfo2nvarchar(255)
 UserInfo3nvarchar(255)
 UserInfo4nvarchar(255)
 UserInfo5nvarchar(255)

WebFormValues

PKField NameField Type
PKNVTGCnvarchar(10)
PKFormnamenvarchar(40)
PKSubmitButtonValuenvarchar(100)
PKSubmitButtonTextnvarchar(100)

WebPlatformConfig

PKField NameField Type
PKIDint
 NVTGCnvarchar(20)
 APIKeyuniqueidentifier
 BaseWebserviceUrlnvarchar(256)
 Descriptionnvarchar(100)

WebSession

PKField NameField Type
PKUsernamenvarchar(50)
PKSessionIDnvarchar(255)
 Expirationdatetime
 SessionTypenvarchar(50)
 LastFormSignaturenvarchar(100)

WebValidation

PKField NameField Type
PKNVTGCnvarchar(10)
PKFormnamenvarchar(40)
PKFieldnamenvarchar(60)
 Validationnvarchar(200)
 Errornvarchar(200)
 ErrorTagnvarchar(60)

WindowsErrorCodes

PKField NameField Type
PKCodeint
 ErrorTextnvarchar(100)

WorkFormMapping

PKField NameField Type
PKNVTGCnvarchar(20)
PKWorkFormTypenvarchar(15)
PKOCLCFieldNamenvarchar(50)
 ILLiadFieldsnvarchar(250)
 ConstantDataActionnvarchar(50)

WorldCatInformation

PKField NameField Type
 TransactionNumberint
 OCLCNumbernvarchar(20)
 Typenvarchar(50)
 Datanvarchar(255)

ZProfiles

PKField NameField Type
PKProfileNamenvarchar(50)
 DBNamenvarchar(50)
 Portnvarchar(10)
 SearchSystemNumbernvarchar(200)
 SearchTitlenvarchar(200)
 SearchAuthornvarchar(200)
 SearchISSNnvarchar(200)
 SearchISBNnvarchar(200)
 SearchDatenvarchar(200)
 SearchKeywordTitlenvarchar(200)
 SearchKeywordAuthornvarchar(200)
 ZTypenvarchar(50)
 ZIdentifiernvarchar(50)
 ZCallNumbernvarchar(50)
 ZAvailabilitynvarchar(50)
 ZLocationnvarchar(50)
 AvailabilityTypenvarchar(50)
 AvailabilityRegExpnvarchar(255)
 AvailableTextTypenvarchar(50)
 AvailableTextnvarchar(50)
 NotAvailableTextTypenvarchar(50)
 NotAvailableTextnvarchar(50)

ZSearches

PKField NameField Type
PKSearchNumberint
PKNVTGCnvarchar(20)
 SearchNamenvarchar(50)
 ServerConfigNumbersnvarchar(100)
 DefaultSearchnvarchar(20)
 SortOrderint

ZServerConfig

PKField NameField Type
PKServerConfigNumberint
PKNVTGCnvarchar(20)
 Namenvarchar(50)
 Servernvarchar(50)
 Portint
 DBNamenvarchar(50)
 ServerTypenvarchar(50)
 SearchSystemNumbernvarchar(200)
 SearchTitlenvarchar(200)
 SearchAuthornvarchar(200)
 SearchISSNnvarchar(200)
 SearchISBNnvarchar(200)
 SearchDatenvarchar(200)
 SearchKeywordTitlenvarchar(200)
 SearchKeywordAuthornvarchar(200)
 AuthUsernvarchar(50)
 AuthPassnvarchar(50)
 ZTypenvarchar(50)
 ZIdentifiernvarchar(50)
 ZCallNumbernvarchar(50)
 ZAvailabilitynvarchar(50)
 ZLocationnvarchar(50)
 AvailabilityTypenvarchar(50)
 AvailabilityRegExpnvarchar(255)
 AvailableTextTypenvarchar(50)
 AvailableTextnvarchar(50)
 NotAvailableTextTypenvarchar(50)
 NotAvailableTextnvarchar(50)