ILLiad Database Tables

Sara Juel

Updated August 12, 2024 16:43

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.

Addons

PK	Field Name	Field Type
PK	ID	int
	Name	nvarchar(100)
	AddonType	nvarchar(50)
	Active	bit
	Package	varbinary(max)
	Settings	nvarchar(max)
	LastUpdated	datetime
	NVTGC	nvarchar(20)

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(100)

ApiRequestMapping

PK	Field Name	Field Type
	WebPlatformConfigId	int
	ILLiadFieldName	nvarchar(50)
	RemoteFieldValue	nvarchar(255)
	ILLiadFieldValue	nvarchar(255)
	Action	nvarchar(10)

BarometerExclusions

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

Billing

ILLiad can automatically create a new account for all registering users by creating entries in The default billing account can be specified by NVTGC (shared server site code or delivery location) and Status. The account is created immediately after the user record is created and it can display to the user on the EditAccountInformation.html page. This also allows you to edit the EditAccountInformation.html page to not allow customers to create more accounts and just display their account information or any other welcome message for new users.

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(100)

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

Note: This table was deprecated in ILLiad v8.1 and removed in v9.2.

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)

DecisionSupportPipelineAddonProperties

PK	Field Name	Field Type
PK	ID	int
	Pipeline	int

DecisionSupportPipelineBusinessRules

PK	Field Name	Field Type
PK	ID	int
	NVTGC	nvarchar(20)
	Pipeline	nvarchar(50)
	Enabled	bit
	RuleNumber	int
	MatchString	nvarchar(max)
	RuleType	nvarchar(50)
FK	AddonTarget	int
	QueueTarget	nvarchar(40)
	SystemTarget	nvarchar(50)
	Description	nvarchar(255)

DecisionSupportPipelineReccomendations

PK	Field Name	Field Type
PK, FK	Transaction Number	int
FK	AddonTarget	int
	QueueTarget	nvarchar(40)
	Notes	nvarchar(max)

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

Fulfillment Data

PK	Field Name	Field Type
PK	ID	int
FK	TransactionNumber	int
FK	Source	int
	Available	bit
	CopyrightIncluded	bit
	Cost	money (USD)
	TurnaroundTime	int
	Format	nvarchar(255)
	CustomData	nvarchar(max)
	Notes	nvarchar(255)

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(100)

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(100)

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(100)
	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)

RemoteAuthValidation

PK	Field Name	Field Type
	NVTGC	nvarchar(20)
	ILLiadFieldName	nvarchar(40)
	RemoteFieldName	nvarchar(1024)
	Validation	nvarchar(max)
	ValidAction	nvarchar(50)
	InvalidAction	nvarchar(50)
	ValidDefault	nvarchar(255)
	InvalidDefault	nvarchar(255)
	Overwrite	nvarchar(7)
	LogIfChanged	bit

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)

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(100)

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(100)

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(20)
	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)
	FailedLoginCount	int
	Locked	bit
	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(100)

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
PK	ID	int
	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(100)
	AuthPass	nvarchar(100)
	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)

ILLiadDatabaseTables.xlsx
(40 KB)