Database Tables

All KB_ and LCL_ tables have the following fields:

KB_ and LCL_ Tables
Name	Description
OWNER	For customer owned data: should be displayed as R.customer.instance For all data distributed by ExL, the owner should be otb
AVAILABLE_FOR	In LCL_ tables, the field is used to indicate to whom the local data pertains – either DEFAULT or a specific group/institute. The format is either R.customer.instance or R.customer.instance.institute In KB_ tables, the field is used to indicate for whom the entry is visible in KBManager. The format is R.customer.instance or R.customer.instance.institute
CREATION_DATE	Date the DB entry was created
CREATED_BY	Name of the SFX administrator user that created the DB entry
LAST_UPDATE_DATE	Date the DB entry was last updated
LAST_UPDATED_BY	Name of the SFX administrator user that last updated the DB entry

All KB_ tables have the following fields:

KB_ Tables
Name	Value	Description
VERSION_NUMBER		DCS version number
RELEASE_NUMBER		Revision release number
CRUD_TYPE		Create-Read-Update-Delete - stores latest change of DB record

Only the KB_ tables listed in Table have the following additional fields:

KB_INTERFACES
KB_OBJECTS
KB_OBJECT_IDENTIFIERS
KB_OBJECT_PORTFOLIOS
KB_RELATIONS
KB_TARGETS
KB_TARGET_SERVICES
KB_MULTILANGUAGE

KB_ Tables
Name	Value	Description
STATUS	ACTIVE, WITHDRAWN	The purpose of this field is to store the life cycle information of the item. Initially it is used for withdrawn versus live status, but in the future it can also be used for under construction, approved, etc.
STATUS_DATE		Date of the last status change
DISTRIBUTION_STATUS	READY FOR DISTRIBUTION NOT FOR DISTRIBUTION	Purpose of this field is to indicate whether the record is ready for distribution or not
DISTRIBUTION_STATUS_DATE		Date of the last DISTRIBUTION_STATUS change

List of KB_ Tables

KB_Tables
Table Name	Field Name	Field Value	Field Description
KB_AUTHORS	AUTHOR_ID		Internal ID
	OBJECT_ID		Internal ID of the object
	AUTHOR_SIGNIFICANCE	MAIN ADDITIONAL (default) ALTERNATIVE	1. MAIN authors will only be loaded if the source is a MARC records (where 100 is main author, 700 are additional authors). In vendor files, we cannot assume that first author listed is the main author. In this case, all authors will be additional authors. Note: main versus additional is important for articles, not so much for books. If we make a distinction, is is more for display in KBManager, etc when displaying only the first author. 2. ALTERNATIVE authors are not loaded using MARC records, but are authors we would like to store as author variations available for searching. These authors will not be displayed in end-user applications (such as the SFX menu and SFX menudisplayers, target parsers, the A-Z list, CitationLinker multi-object window). They will not be included in Export formats. 3. ALTERNATIVE authors will be used for CJK author information, in case more than one author value is needed for searching.
	AUTHOR_TYPE	PERSONAL CORPORATE MEETING	Type of author can be personal, corporate, or meeting
	AUTHOR_FIRST_NAME		Contains the first name of the author names whose parsing of full name into author_first and author_last was successful - for display purposes.
	AUTHOR_LAST_NAME		Contains the last name of the author names whose parsing of full name into author_first and author_last was successful - for display purposes.
	AUTHOR_FULL_NAME		Contains the full author name as received from load file – for display purposes
	AUTHOR_FIRST_NAME_NORMALIZED		Contains the first name of the author names whose parsing of full name into author_first and author_last was successful - after normalization.
	AUTHOR_LAST_NAME_NORMALIZED		Contains the last name of the author names whose parsing of full name into author_first and author_last was successful - after normalization.
	AUTHOR_FULL_NAME_NORMALIZED		Contains the full author name as received from load file – after normalization.
	FULL_NAME_FORMAT	For PERSONAL author_type: FORENAME, SURNAME, FAMILY NAME, Default is SURNAME For CORPORATE, MEETING author_type: INVERTED, JURISDICTION, DIRECT ORDER Default is DIRECT ORDER	Description of each type – from MARC standard: Forename - Forename or a name consisting of words, initials, letters, etc. that are formatted in direct order. For authors of the type ‘Forename’, the Firstname field will be empty. The whole string is included as ‘Lastname’. Surname - Single or multiple surname formatted in inverted order or a single name without forenames that is known to be a surname. Family name - Name represents a family, clan, dynasty, house, or other such group and may be formatted in direct or inverted order. Inverted - Corporate name or Meeting name starting with a personal name in inverted order. Jurisdiction - Name of a jurisdiction that is also an ecclesiastical entity or is a jurisdiction name under which a corporate name/meeting name or a title of a work is entered. Direct Order - Corporate or Meeting Name in direct order
	COMMENT	LATIN (default), TRADITIONAL-CHI SIMPLIFIED-CHI, PINYIN KOREAN-UNSPEC HANGUL, JAPANESE-UNSPEC HIRAGANA	Will store type of CJK author – only used for ALTERNATIVE authors

KB_CAT	CAT_ID		Internal ID
	CAT_NORMALIZED		will store the global category information provided by ExL - after normalization
	CAT_DISPLAY		will store the global category information provided by ExL - for display purposes

KB_CAT_ASSIGN	CAT_ASSIGN_INTERNAL_ID		Internal ID
	CAT_SUBCAT_INTERNAL_ID		Internal ID of a global category/subcategory combination
	OBJECT_ID		Internal ID of the object

KB_CAT_SUBCAT	CAT_SUBCAT_INTERNAL_ID		Internal ID
	CAT_ID		Internal ID of a global category
	SUBCAT_ID		Internal ID of a global subcategory

KB_INTERFACES	INTERFACE_ID		Internal ID
	INTERFACE_NAME		Will store Interface name used for BO display purposes
	INTERFACE_PUBLIC_NAME		Will store Interface name used for display purposes for end-user (e.g. in A-Z list - locate tab - vendor list)

KB_LINKING_PARAMETERS	LINKING_PARAM_ID		Internal ID
	ITEM_TYPE	TARGET_SERVICE OBJECT_PORTFOLIO	Linking parameters can be connect to either target service or portfolio
	ITEM_ID		Internal ID of the target service or portfolio - in case of global entry
	LOCAL_ITEM_ID		Internal ID of the target service or portfolio - in case of locally created entry
	PARAMETER_NAME		Linking parameter name
	DESCRIPTION		Description of linking parameter - added to make it easier for SFX administrator to fill in the value
	IS_OTB_VALUE		Defines whether linking parameter has an out-of-the-box value or not
	OTB_VALUE		Stores out-of-the-box value

KB_MULTILANGUAGE	MULTILANGUAGE_INTERNAL_ID		Internal ID
	MULTILANGUAGE_GROUP		SFX application in which translation element is used
	MULTILANGUAGE_MESSAGE_CODE		HTML template code to refer to this translation element
	MULTILANGUAGE_MESSAGE_DETAILS		Description for this translation element
	MULTILANGUAGE_LANGUAGE_CODE		Language of the multilanguage translation element - using 3-letter ISO 639-2 standard language code
	MULTILANGUAGE_MESSAGE_TEXT		Actual value for this translation element

KB_OBJECTS	OBJECT_ID		Internal ID
	OBJECT_TYPE	BOOK CD CONFERENCE DATABASE DISSERTATION DOCUMENT JOURNAL MANUSCRIPT NEWSPAPER PROCEEDING REPORT SERIES TRANSCRIPT WIRE VIDEO AUDIO SCORE	Type of object
	LANGUAGE		Language of the object - using 3-letter ISO 639-2 standard language code
	PEER_REVIEWED	YES NO	Indicates whether object uses peer-review mechanism before allowing articles to be published
	MMS_ID		ID required for sync with MMS

KB_OBJECT_ATTRIBUTES_METADATA	OBJECT_TYPE	BOOK CD CONFERENCE DATABASE DISSERTATION DOCUMENT JOURNAL MANUSCRIPT NEWSPAPER PROCEEDING REPORT SERIES TRANSCRIPT WIRE VIDEO AUDIO SCORE	Table not in use - intended to store allowed attributes for each type of object
	TABLE_NAME
	ATTRIBUTE_TYPE
	MANDATORY

KB_OBJECT_IDENTIFIERS	OBJECT_IDENTIFIER_ID		Internal ID
	OBJECT_ID		Internal ID of the object
	TYPE	ISSN ISBN LCCN OCLC_NR CODEN DOI	Identifier type
	SUBTYPE	PRINT ELECTRONIC INCORRECT PRINT_HBK PRINT_PBK	Identifier subtype
	VALUE		Value

KB_OBJECT_PORTFOLIOS	OP_ID		Internal ID
	TARGET_ID		Internal ID of the Target
	TARGET_SERVICE_ID		Internal ID of the Target service
	OBJECT_ID		Internal ID of the object
	TARGET_PARSER_PROGRAM		Stores the name of the target parser program that will create the URLs to link to a particular TARGET_SERVICE
	PARSE_PARAM		Contains information that is used by the Target Parser to create URLs. You fill in parameters that apply to the specific portfolio for example, jkey
	DESCRIPTION		General description - will be used by the kb team to describe the portfolio (for ExL distributed targets) - can be used by customers to describe locally created portfolio
	KB_INTERNAL_DESCRIPTION		Internal field for KB team - not included in revision update package - used to store test account info, internal notes
	LINKING_LEVEL	ARTICLE ARTICLE_DOI ISSUE VOLUME JOURNAL CITATION BOOK DATABASE INHERIT
	THRESHOLD		Conditions placed on a portfolio. Thresholds determine whether or not a given service is displayed in the SFX menu screen.

KB_PUBLISHERS	PUBLISHER_ID		Internal ID
	PUBLISHER_NAME_DISPLAY		Publisher name information - used for display purposes
	PUBLISHER_NAME_NORMALIZED		Publisher name information - normalized version
	DATE_OF_PUBLICATION		Date of publication
	PLACE_OF_PUBLICATION_DISPLAY		Publisher place of publication information - used for display purposes
	PLACE_OF_PUBLICATION_NORMALIZED		Publisher place of publication information - normalized version
	OBJECT_ID		Internal ID of the object

KB_RELATIONS	RELATION_ID		Internal ID
	PRIMARY_OBJECT_ID		Internal ID of the primary object for this relation
	SECONDARY_OBJECT_ID		Internal ID of the secondary object for this relation
	RELATION_TYPE	PROCEEDING_SERIES PROCEEDING_ITEM OTHER_EDITION SERIES,SERIES_ITEM CONTINUES CONTINUED_BY CONTINUES_IN_PART CONTINUED_IN_PART_BY MERGED_INTO FORMED_BY_THE_UNION_OF SPLIT_INTO ABSORBED_BY ABSORBED ABSORBED_IN_PART_BY ABSORBED_IN_PART RELATED SUPPLEMENT SUPPLEMENT_PARENT TRANSLATION_ENTRY

KB_SORTING_ORDER	TYPE		Table used to to determine what takes preference when displaying id-info in kbmanager
	SUBTYPE
	ORDER

KB_SOURCES	SOURCE_ID		Internal ID
	SOURCE_NAME		name of the SOURCE
	SOURCE_PARSER_PROGRAM		the name of the source as listed in the source configuration file - source ID section.
	SHOW_AVAILABILITY	YES NO	setting this option to 'Yes' will make sure the availability information (available from 2009, 12, 1 until …') is shown in the SFX menu screen for a particular SOURCE
	DESCRIPTION		General description - will be used by the kb team to describe the source (for ExL distributed sources) - can be used by customers to describe locally created source

KB_SOURCE_SERVICES	SOURCE_SERVICE_ID		Internal ID
	SOURCE_ID		Internal ID of the source
	SERVICE_TYPE	getFullTxt getSelectedFullTxt getDOI getMessageNoFullTxt getHolding getDocumentDelivery getBookReview getAbstract getTOC getAlikeRecord getAuthor getCitedAuthor getCitedReference getReference getCitedBook getCitedGenome getCitedRecord getCitedJournal getAuthorEmail getSubject getWebService getWebSearch getRecommendation	Type of service

KB_SUBCAT	SUBCAT_ID		Internal ID
	SUBCAT_NORMALIZED		will store the global subcategory information provided by ExL - after normalization
	SUBCAT_DISPLAY		will store the global subcategory information provided by ExL - for display purposes

KB_TARGETS	TARGET_ID		Internal ID
	TARGET_NAME		the name of the target as displayed in SFX Admin Center Back Office interfaces
	TARGET_PUBLIC_NAME		the name of the TARGET as displayed to the user in the SFX menu screen. NOTE: the character # should not be used in the public name of the TARGET as this will cause problems when exporting database information.
	DESCRIPTION		General description: - will be used by the kb team to describe the target / target_service (for ExL distributed targets) - can be used by customers to describe locally created target
	KB_INTERNAL_DESCRIPTION		Internal field for KB team - not included in revision update package - used to store test account info, internal notes
	AGGREGATOR	0, 1	Indicates whether a target is aggregator or not. This will be used (1) with aggregator versus non-aggregator display logic rules and (2) during post revision update scripts - where if this field is set to 'Aggregator - Y', NEW Object Portfolios will be added as ACTIVE, in case the KB_TARGET_SERVICE has a LCL_SERVICE_INVENTORY record with ACTIVATION_STATUS set to be ACTIVE. (3) when adding portfolios in KBmanager The customer can change the behavior of aggregator automatic activation by using the LCL_SERVICE_INVENTORY field Autoactive. This field can be INHERIT/YES/NO. INHERIT means inherit value from the KB_TARGETS Aggregator field. If field is set to 'YES', this means that during updates, new OP will be added as ACTIVE, in case the KB_TARGET_SERVICE has a LCL_SERVICE_INVENTORY record with ACTIVATION_STATUS set to be ACTIVE. If field is set to 'NO', this means that during updates, new OP will be added as INACTIVE.
	SITE_AVAILABILITY	SITE DOWN SITE UP	This field will be for future use. This field will not be displayed in the KBManager UI in SFX version 4.0
	TARGET_CHARACTER_SET		can be used to specify a different Character Set (other than LATIN-1) which needs to be used for a particular TARGET.
	TARGET_TYPE	BOOK JOURNAL, MIXED A&I WEB SERVICE MIXED
	THRESHOLD		Conditions placed on a target. Thresholds determine whether or not a given service is displayed in the SFX menu screen.
	LOGIC_UPDATE_DATE		Date of last complete update: this is the date of the last complete overhaul of the target

KB_TARGET_SERVICES	TARGET_SERVICE_ID		Internal ID
	TARGET_ID		Internal ID of the target
	SERVICE_TYPE	getFullTxt getSelectedFullTxt getDOI getMessageNoFullTxt getHolding getDocumentDelivery getBookReview getAbstract getTOC getAlikeRecord getAuthor,getCitedAuthor getCitedReference getReference getCitedBook getCitedGenome getCitedRecord getCitedJournal getAuthorEmail getSubject getWebService getWebSearch getRecommendation	Type of Service
	SERVICE_PUBLIC_DESCRIPTION		Contains the text describing a specific service, for example, “Full-text available via”. This text will override the default explanatory text defined in the ‘Services Public Names’ tab (for simplified menu) or services_public_names.config_ for that service type.
	DESCRIPTION		General description - will be used by the kb team to describe the target_service (for ExL distributed targets) - can be used by customers to describe locally created target service
	KB_INTERNAL_DESCRIPTION		Internal field for KB team - not included in revision update package - used to store test account info, internal notes
	TARGET_PARSER_PROGRAM		stores the name of the target parser program that will create the URLs to link to a particular TARGET_SERVICE
	PARSE_PARAM		contains information that is used by the target Parser to create URLs. You fill in parameters that apply to the whole target Service, for example, base URL
	TARGET_DISPLAYER_PROGRAM		used to specify a special display type for a particular TARGET_SERVICE. If the field is left blank, the default display is used. For example, the UNION_CATALOGUE’s getHolding service uses a DISPLAYER to create a drop-down list of different union catalogues in the SFX menu screen.
	OBJECT_LOOKUP	YES, NO	Object-lookup should be ‘Yes” when objects are attached to this target service. This means that the target service only shows up in the SFX menu screen if the object requested (for example, a particular journal) is part of the object portfolio of that particular target service. If Object-lookup is ‘No’, this means no objects are connected to a particular target service. The target service will show up in the SFX menu screen, regardless of the object you start from. This is used for more general, ‘searchoriented’ target services, such as a getHolding or getWebSearch service.
	LINKING_LEVEL	ARTICLE ARTICLE_DOI ISSUE VOLUME JOURNAL CITATION BOOK DATABASE INHERIT
	IS_FREE		indicates whether all the portfolios for a target service are accessible freely, without subscription fee.
	CROSSREF_SUPPORTED	YES, NO	Indication whether Crossref lookup can be used for this target service to improve target linking, as part of the revision update. Customers do not have to do anything if they want to use crossref for a particular target service in v4. Can be overridden by ROSSREF_ENABLED field in LCL_LINKING_TARGET_SERVICE table Purpose of this field is to provide a local override option – in case customers want to disable crossref lookup for a particular target service.
	THRESHOLD		Conditions placed on a target service. Thresholds determine whether or not a given service is displayed in the SFX menu screen.
	AUTOLOADER_USED		internal KB team field - indicates whether autoloader is used to update this target service
	LOGIC_UPDATE_DATE		date of last complete update: this is the date of the last complete overhaul of the target service

KB_TITLE	TITLE_ID		Internal ID
	OBJECT_ID		Internal ID of the object
	TITLE_TYPE	MAIN TRANSLATION ROMANIZATION WRITING_SYSTEM ABBREVIATION UNIFORM ALTERNATIVE	title type
	TITLE_SUB_TYPE	SIMPLIFIED TRADITIONAL PINYIN HIRAGANA KATAKANA HANGUL	title subtype
	TITLE_VALUE		title value
	NON_FILLING_CHAR		stores the number of characters at the beginning of a title which should be ignored when sorting. By default or when no non‐filing character is loaded, the value will be ‘0’.
	TITLE_LANGUAGE		stores the title language - using 3-letter ISO 639-2 standard language code

KB_TITLE_KEYS	TITLE_KEY_ID		Internal ID
	OBJECT_ID		Internal ID of the object
	TITLE_ID		Internal ID of the corresponding title
	TITLE_KEY_USE	SEARCH, SORT	defines what title will be used for - searching or sorting purposes
	TITLE_KEY_TYPE	generalDiacritics diacriticsGerman diacriticsSwedish diacriticsDanish diacriticsUSA Hangul pinyinNormalization StrokeSequence StrokeCount katakana Hiragana koreanNormalization JapaneseNormalization ChineseNormalization TaiwaneseNormalization	title key type
	TITLE_KEY_VALUE		title value
	NON_FILLING_CHAR		stores the number of characters at the beginning of a title which should be ignored when sorting. By default or when no non‐filing character is loaded, the value will be ‘0’.

List of LCL_ Tables

LCL_Tables
Table Name	Field Name	Field Value	Field Description
LCL_CAT	CAT_ID		Internal ID
	CAT_NORMALIZED		will store the local category information - after normalization
	CAT_DISPLAY		will store the local category information - for display purposes

LCL_CAT_ASSIGN	CAT_ASSIGN_INTERNAL_ID	CAT_ASSIGN_ID	Internal ID
	CAT_SUBCAT_INTERNAL_ID		Internal ID of a local category/subcategory combination
	OBJECT_ID		Internal ID of the object

LCL_CAT_SUBCAT	CAT_SUBCAT_INTERNAL_ID	CAT_SUBCAT_ID	Internal ID
	CAT_ID		Internal ID of a local category
	SUBCAT_ID		Internal ID of a local subcategory

LCL_LINKING_PARAMETERS	INTERNAL_ID		Internal ID
	LINKING_PARAM_ID		Internal ID of KB_LINKING_PARAMETERS entry for which value is stored
	VALUE		Stores linking parameter value

LCL_MULTILANGUAGE	MULTILANGUAGE_INTERNAL_ID		Internal ID
	MULTILANGUAGE_GROUP		SFX application in which translation element is used
	MULTILANGUAGE_MESSAGE_CODE		HTML template code to refer to this translation element
	MULTILANGUAGE_MESSAGE_DETAILS		Description for this translation element
	MULTILANGUAGE_LANGUAGE_CODE		Language of the multilanguage translation element - using 3-letter ISO 639-2 standard language code
	MULTILANGUAGE_MESSAGE_TEXT		Actual value for this translation element

LCL_OBJECT_IDENTIFIERS	OBJECT_IDENTIFIER_ID		Internal ID
	OBJECT_ID		Internal ID of the object
	TYPE		Identifier type - table is currently only used to store LOCAL attribute
	SUB_TYPE		Identifier subtype
	VALUE		Value

LCL_OBJECT_PORTFOLIO_INVENTORY	INTERNAL_ID		Internal ID
	OP_ID		Internal ID of KB_OBJECT_PORTFOLIOS entry for which activation information is stored
	ACTIVATION_STATUS	ACTIVE, INACTIVE	Activation status
	DEACTIVATION_REASON		Reason for deactivation

LCL_OBJECT_PORTFOLIO_LINKING_INFO	INTERNAL_ID		Internal ID
	OP_ID		Internal ID of KB_OBJECT_PORTFOLIOS entry for which activation information is stored
	AUTHENTICATION_NOTE		Authentication note - will be displayed in SFX menu to endusers
	PUBLIC_NOTE		General note - will be displayed in SFX menu to endusers
	INTERNAL_DESCRIPTION		Internal description - used by SFX administrator for internal purposes
	TARGET_PARSER_PROGRAM		Override of KB_ TARGET_PARSER_PROGRAM value
	PARSE_PARAM		Override of KB_ PARSE_PARAM value
	THRESHOLD		Override of KB_ THRESHOLD value

LCL_SERVICE_INVENTORY	INTERNAL_ID		Internal ID
	TARGET_ID		Internal ID of KB_TARGETS entry for which activation information is stored
	TARGET_SERVICE_ID		Internal ID of KB_TARGET_SERVICES entry for which activation information is stored
	AUTO_ACTIVE	YES, NO, INHERIT	If field is set to 'YES', this means that during updates, new OP will be added as ACTIVE, in case the KB_TARGET_SERVICE has a LCL_SERVICE_INVENTORY record with ACTIVATION_STATUS set to be ACTIVE. If field is set to 'NO', this means that during updates, new OP will be added as INACTIVE. Ifi field is set to 'INHERIT', this means inherit behavior from value from the KB_TARGETS AGGREGATOR field.
	ACTIVATION_STATUS	ACTIVE, INACTIVE	Activation status
	DEACTIVATION_REASON		Reason for deactivation
	SITE_DOWN	0, 1	Field is either set in KBManager or triggered by Verde soap service. When a TARGET_SERVICE has status SITE DOWN, then SFX menu will display an icon that shows that the target service is down. Additionally, the ‘Go’ button and link to target window not be presented, instead a text saying site down will appear
	SITE_DOWN_DATE		Site_down_date can be used to describe, for the SFX administrator, the date of the downtime.
	SITE_DOWN_REASON		site_down_reason can be used to describe, for the SFX administrator, in more details the reason of the downtime.

LCL_SERVICE_LINKING_INFO	INTERNAL_ID		Internal ID
	TARGET_SERVICE_ID		Internal ID of KB_TARGET_SERVICES entry for which activation information is stored
	SERVICE_PUBLIC_DESCRIPTION		Text describing service - will be displayed in SFX menu to endusers - overrides default text describing service
	AUTHENTICATION_NOTE		Authentication note - will be displayed in SFX menu to endusers
	PUBLIC_NOTE		General note - will be displayed in SFX menu to endusers
	INTERNAL_DESCRIPTION		Internal description - used by SFX administrator for internal purposes
	TARGET_PARSER_PROGRAM		Override of KB_ TARGET_PARSER_PROGRAM value
	PARSE_PARAM		Override of KB_ PARSE_PARAM value
	TARGET_DISPLAYER_PROGRAM		Override of KB_ THRESHOLD value
	PROXY_ENABLED		Used for selective proxy use
	OBJECT_LOOKUP	Y, N, INHERIT	Local field to override KB_SOURCE_SERVICES OBJECT_LOOKUP field
	CROSSREF_ENABLED	INHERIT, NO	Local field to override KB_SOURCE_SERVICES CROSSREF_ENABLED field
	THRESHOLD		Override of KB_ THRESHOLD value

LCL_SOURCE_LINKING_INFO	INTERNAL_ID		Internal ID
	SOURCE_ID		Internal ID of KB_SOURCES entry for which activation information is stored
	INTERNAL_DESCRIPTION		Internal description - used by SFX administrator for internal purposes
	SHOW_AVAILABILITY	YES, NO, INHERIT	Field to override the KB_SOURCES SHOW_AVAILABILITY value (by setting this option to 'Yes' will make sure the availability information (available from 2009, 12, 1 until …') is shown in the SFX menu screen for a particular SOURCE)

LCL_SOURCE_SERVICE_INVENTORY	INTERNAL_ID		Internal ID
	SOURCE_ID		Internal ID of KB_SOURCES entry for which activation information is stored
	SOURCE_SERVICE_ID		Internal ID of KB_SOURCE_SERVICES entry for which activation information is stored
	ACTIVATION_STATUS	ACTIVE, INACTIVE	Activation status
	DEACTIVATION_REASON		Reason for deactivation

LCL_SUBCAT	SUBCAT_ID		Internal ID
	SUBCAT_NORMALIZED		will store the local subcategory information - after normalization
	SUBCAT_DISPLAY		will store the local subcategory information - for display purposes

LCL_TARGET_INVENTORY	INTERNAL_ID		Internal ID
	TARGET_ID		Internal ID of KB_TARGETS entry for which activation information is stored
	ACTIVATION_STATUS	ACTIVE, INACTIVE	Activation status
	DEACTIVATION_REASON		Reason for deactivation
	SITE_DOWN	Y, N	Field for future use only - not displayed in KBManager
	SITE_DOWN_REASON	SITE_NOT_AVAILABLE	Field for future use only - not displayed in KBManager
	SITE_DOWN_DATE		Field for future use only - not displayed in KBManager

LCL_TARGET_LINKING_INFO	INTERNAL_ID		Internal ID
	TARGET_ID		Internal ID of KB_TARGET
	TARGET_PUBLIC_NAME		Override of KB_TARGET public name
	AUTHENTICATION_NOTE		Authentication note - will be displayed in SFX menu to endusers
	PUBLIC_NOTE		General note - will be displayed in SFX menu to endusers
	INTERNAL_DESCRIPTION		Internal description - used by SFX administrator for internal purposes
	THRESHOLD		Override of KB_ THRESHOLD value

LCL_TITLE	INTERNAL_ID		Internal ID
	TITLE_ID		Internal ID of the corresponding KB_TITLE entry
	OBJECT_ID		Internal ID of the object
	TITLE_VALUE		title value
	NON_FILING_CHAR		stores the number of characters at the beginning of a title which should be ignored when sorting. By default or when no non‐filing character is loaded, the value will be ‘0’.

LCL_TITLE_KEYS	TITLE_KEY_ID		Internal ID
	OBJECT_ID		Internal ID of the object
	TITLE_ID		Internal ID of the corresponding title
	TITLE_KEY_USE	SEARCH', 'SORT', 'BOTH	defines what title will be used for - searching or sorting purposes
	TITLE_KEY_TYPE	generalDiacritics', 'diacriticsGerman', 'diacriticsSwedish', 'diacriticsDanish', 'diacriticsUSA, Hangul', 'PinyinNormalization', 'StrokeSequence', 'StrokeCount', 'Katakana', 'Hiragana', 'KoreanNormalization, JapaneseNormalization', 'ChineseNormalization, TaiwaneseNormalization	title key type
	TITLE_KEY_VALUE		title value
	NON_FILING_CHAR		stores the number of characters at the beginning of a title which should be ignored when sorting. By default or when no non‐filing character is loaded, the value will be ‘0’.

LCL_TRANS_CAT	CAT_ID		Internal ID of KB_CAT table
	CAT_TRANS_NORMALIZED		will store the translated version of the global category information provided by ExL - after normalization
	CAT_TRANS_DISPLAY		will store the translated version of the global category information provided by ExL - for display purposes

LCL_TRANS_SUBCAT	SUBCAT_ID		Internal ID of KB_SUBCAT table
	SUBCAT_TRANS_NORMALIZED		will store the translated version of the global subcategory information provided by ExL - after normalization
	SUBCAT_TRANS_DISPLAY		will store the translated version of the global subcategory information provided by ExL - for display purposes

CONTROL	CONTROL_INTERNAL_ID		Internal ID of CONTROL table
	CONTROL_GROUP		Group of configuration settings
	CONTROL_SECTION		Section within configuration group
	INSTITUTE_ID		Institute ID information
	CONTROL_NAME		Configuration setting name
	CONTROL_VALUE		Configuration setting value
	CONTROL_VARTYPE	SCALAR, ARRAY

INSTITUTE_IP	INSTITUTE_IP_ID		Internal ID of INSTITUTE_IP table
	INSTITUTE_ID
	INSTITUTE_IP_FROM
	INSTITUTE_IP_TO

INSTITUTE	INSTITUTE_ID		Internal ID of INSTITUTE table
	INSTITUTE_NAME
	INSTITUTE_TYPE	I, G

SYNONYM	INSTITUTE_ID		Internal ID of SYNONYM table
	SYNONYM_ID
	SYNONYM_RANK

SFX_REQUEST	INTERNAL_ID		Internal ID of KB_SFX_REQUEST table
	SERIALIZED
	SERVICES
	MODIFIED

STAT_OBJECT and	REQUEST_ID		Internal ID
STAT_OBJECT_OFFLINE	ISSN
	ISBN
	LCCN
	LOCAL
	TITLE
	ATITLE
	JTITLE
	BTITLE
	CTITLE
	SERIES
	PUBLISHER
	PLACE_OF_PUBLICATION
	OBJECT
	SUBCATEGORY
	STATUS
	DOI
	DATE
	TIME
	SOURCE
	IP
	OBJECT_TYPE
	INSTITUTE
	USER_GROUP
	FACULTY
	HAS_FULLTXT
	DATE_OF_PUBLICATION
	SPAGE
	EPAGE
	PRESENTATION_FORMAT
	SESSION_ID
	OPEN_URL

STAT_REPEATABLES and	INTERNAL_ID		Internal ID
STAT_REPEATABLES_OFFLINE	REQUEST_ID
	ATTRIBUTE
	VALUE

STAT_TARGET_SERVICE and	REQUEST_ID
STAT_TARGET_SERVICE_OFFLINE	TARGET
	CLICKS
	SERVICE
	URL

USERS	INTERNAL_ID		Internal ID of USERS table
	USER_ID
	PASSWORD
	PROFILE
	NAME
	DESCRIPTION
	INSTITUTE_ID
	SESSION_ID

ERD Diagram

The following diagram illustrates the connections between objects (with title and Identifier information), targets, target services and object portfolios. It includes connections from the global KB_ tables to LCL_ tables with inventory and local linking information.