Physical Items

Field Descriptions

The following fields are available in Physical Items.

Physical Items – Field Descriptions

Physical Item Details

The Physical Item Details table is a fact table that stores all measures relating to specific physical items such as number of items, time loaned, etc. This table also holds details about the physical items including barcode and material type. The primary key is ITEM_ID.

Physical Item Details
Field	Description	Additional Information
Barcode	The unique identifier of the specific physical item	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Base Status	Indicates the availability of the item in its permanent location (in place/not in place)
Chron I	The main level of chronology - usually the year	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Chron J-M	Additional chronology fields
Committed to Retain	Indicates if the library has committed to retain the item. This enables librarians to mark items and prevent them from being withdrawn.	This feature is also supported in import, export and API workflows.
Creation Date	Holds the date the physical item was created	This date is assigned by Alma when the physical item is created.
Creator	Holds the username of the operator that created the physical item
Description	Description of the item	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Display Temp Call Number	A normalized temporary call number for display	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Due Back Date	Indicates the date that an item in a temporary location is due back to its permanent location	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Enum A	The main level of enumeration - usually the volume	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Enum B-H	Additional enumeration fields
Expected Receipt Date	The date when a purchased item is expected to arrive at the library	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below (Expected Receipt Date).
Fulfillment Note	The Fulfillment note	For more information, see the Physical Item Editor Page - Notes Tab table in Updating Item-Level Information.
IEP	The IE number for physical items	You can use this identifier to reconcile Analytics data, which has only MMS IDs, with the number from record IDs supplied to Primo from Alma. You can then pass the results to a reading list system in order to make relegation and capacity decisions. This number is essential for reports on Fulfillment activity where this number is the only common ID between the two systems. This is the PID or Publishing ID in Alma.
Internal Note 1-3	Internal notes 1-3	For more information, see the Physical Item Editor Page - Notes Tab table in Updating Item-Level Information.
Inventory Date	The last time inventory was checked	This field is a calendar field that can be edited manually using the item editor. It can be used for any need. The common use is to track missing items. To do this, enter the date that a missing item was last searched for in the Inventory Date field.
Inventory Number	The inventory number
Inventory Price	The price of the physical inventory for each physical item
Is Magnetic	Whether the item is magnetic material or not.	This is used in the circulation desk in order not to desensitize magnetic material See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Item Call Number	The item call number for display	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Item Call Number Type	The item call number type	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Item Copy ID	The ID of the copy of the item	The field “Item Copy ID” folder comes from the item record and not from the holdings record. It is visible in the physical item editor in the “general” tab and is called “Copy ID”.
Item Issue Date (Calendar)	The issue date of the physical item.	Calendar Date fields consist of a month, date, and year. If the information is not provided, 01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date.
Item ID	Stores the unique ID of the physical item	See the field location in Alma in the Physical Item Editor figures, below.
Item Policy	Defines the conditions under which a request for this item can be fulfilled	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Last Loan Date	The last time the item was loaned	This loan measure includes migrated data,
Last Loan Date (In House)	The last time the item was used in the library, but not actually loaned	This field is available only for loans that were handled in Alma and does not include migrated data.
Last Loan Date (Not in House)	The last time the item was actually loaned	This field is available only for loans that were handled in Alma and does not include migrated data.
Lifecycle	Indicates whether the item is active or deleted	The following are possible values: Active – the item is active Deleted – the item was deleted None – the item has a holding record, but not an item record
Material Type	Describes the nature of the material represented by the item record	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Modification Date	Holds the date the physical item was modified
Modified By	Holds the user name that modified the physical item
Num of Items (Deleted + In Repository)	Stores the number of deleted + in repository items (one for each item)	See the field location in Alma in the figure List of Holdings, below.
Num of Items (In Repository)	Stores the number of in repository items (one for each item)
Num of Loans (In house + Not In House)	The sum of the in house loans and the not in house loans.	This number includes loans with a loan status of inactive as well as in-house loans. This number includes loans that were handled in Alma and includes migrated data.
Num of Loans (In House)	The number of items that were used in the library, but not actually loaned	This number includes loans that were handled in Alma and includes migrated data.
Num of Loans (Not In House)	The number of items that were actually loaned	This number includes loans that were handled in Alma and includes migrated data.
Num of Requests (Booking)	The number of booking requests
Num of Requests (Digitization)	The number of digitization requests
Num of Requests (General Hold)	The number of general hold requests
Num of Requests (Physical Item)	The number of physical item requests
Num of Requests (Total)	The total number of requests
Originating System ID	The ID of the item in the source system from which it has been imported	See the field location in Alma in the figure MARC Record Simple View, below.
Physical Condition	The physical condition of the item.	Possible values: Brittle Damaged Deteriorating Fragile None
Pieces	The item’s number of pieces.
Process Type	When the item is being processed (acquisition/loan/bindery/etc) this indicates the type of processing	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Process Type Date	The date that the process type was changed	Data for this field is available from August 2017 and later.
Provenance Code	A code used to identify separate items that belong to different groups (but may be shelved together)	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Receive Number	A sequential number assigned by the library to help maintain inventory.	For more information, see Configuring Physical Item Sequences.
Receiving Date	The date the material was actually received/activated for the first time	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Receiving Date and Time	The date and time the material was actually received/activated for the first time	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Replacement Cost	The replacement cost	In order to filter your report based on the Replacement Cost field, you must add a second copy of this field and edit the formula with the following CAST("Physical Item Details"."Replacement cost" AS DOUBLE). This causes Alma Analytics to treat the field as numeric.
Retention Note	A free-text note concerning the library's commitment to retain the item.
Retention Reason	The reason the library has committed to retain the item.	The list of reasons can be configured by an administrator.
Statistics Note 1-3	Holds statistic notes	See the field location in Alma in the figure Physical Item Editor – Notes Tab, below. For more information, see the Physical Item Editor Page - Notes Tab table in Updating Item-Level Information.
Storage Location ID	The ID of the storage location.
Temporary Call Number Type	A call number type provided when the item is in a temporary location	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Temporary Item Policy	The temporary item policy
Temporary Physical Location In Use	Whether the item is currently (at the time at which the report is run) in a temporary location or in a permanent location. For example: An item was moved from a permanent location to a temporary location on November 28, 2017. It was loaned on November 29, 2017, and when it was loaned, it was still in a temporary location. It was returned from loan on December 13, 2017. On December 14, 2017 it was returned to its permanent location. If an Analytics report was run between November 28 and December 13, the Temp Physical Location In Use is Yes. If the report was run before November 28 or after December 13, the Temp Physical Location In Use is No.	See the field location in Alma in the figure Physical Items Details Fields in Physical Item Editor – General Information Tab, below.
Times Loaned	The number of loans including pre-migration. The Num of Loans measures include all loans in Alma, while "Times Loaned" includes all loans in Alma and also loans from pre-migration.
Weeding Date	A date assigned by the library as the weeding date. By default it is the date that the weeding number was assigned
Weeding Number	A sequential number assigned by the library to help maintain inventory.	For more information, see Configuring Physical Item Sequences.

Most of the fields of the Physical Items details dimension are taken from the fields of the Physical Item Editor:

Physical Items Details Fields in Physical Item Editor – General Information Tab

MARC Record Simple View

Physical Item Editor – Notes Tab

Holding Details

The Holding Details table is the dimension table that stores additional details about physical items. The primary key is ITEM_ID.

Deleted holdings with no items are not visible in Analytics, by default. To have reports take into account deleted holdings with no items, contact Ex Libris Support.

Holdings Details
Field	Description	Additional Information
852 MARC	The first value in the 852 MARC field.
Accession Number	A sequential code used to file items on the shelf.
Binding Information	The binding information.	From MARC holdings record 563 field
Call Number Prefix	The call number prefix.	From MARC field 852, subfield k.
Call Number Suffix	The call number suffix.	From the holdings record 852 field subfield m
Copy and Version Identification Note	The copy and version identification note.	From the MARC holdings record 562 field
Copy ID	When multiple copies of the same title exist at the same library/location, the copy ID is used to identify each of the copies.	See the field location in Alma in the figure List of Holdings, below.
Creation Date	The creation date of the holdings record
Creator	The creator of the holdings record
Electronic Location and Access	The electronic location and access.	From the holdings record 856 field
HOL 008 MARC	The contents of the MARC 008 holdings field
HOL LDR MARC	The contents of the MARC LDR holdings field
Holding ID	The unique identifier of the holding	See the field location in Alma in the figure List of Holdings, below.
Holding Lifecycle	Indicates if the holdings record is active or deleted.
Holding Local Param (1-10)	Customizable fields (any local holdings field and not just a 9XX field) In order to make use of this field, you must contact Ex Libris Support and supply them with a three-digit MARC field code (Dublin Core is not supported). Following configuration of this field by Ex Libris Support, its value will be available in Analytics. Subfields can be maintained in the Analytics fields identified for Local Param. When this capability is implemented, fields/subfields appear in Alma Analytics with the Alma subfield delimiter (either $$ or ‡) used to delineate the subfield content. Contact Support to enable this feature. Note that reindexing is required to fully implement this capability. Note that the local param fields are not related to the MARC type of the record. For example, if field 913 is defined to be in local param 1 then field 913 will always be in local param 1. This is the case if the record is of the type KORMARC, CNMARC, UNIMARC, MARC21, and so forth. It is not possible to have different sets of Local Param 1-10 for different types of MARC. The data in the local parameters is limited to 3900 characters.
Immediate Source of Acquisition Note	The immediate source of the acquisition note.	From MARC holdings record 541 field
Method of Acquisition	The method of acquisition.	From MARC holdings record 008 field position 7
Modification Date	The date the modification record was changed
Modified by	The user who modified the holdings record
Non Public Note	The non-public note.	From MARC holdings record 852 field subfield x
Normalized Call Number	Holds the normalized call number
Ownership and Custodial History	The ownership and custodial history.	From MARC holdings record 561 field
Permanent Call Number	A code used to file the items on the shelf	See the field location in Alma in the figure List of Holdings, below.
Permanent Call Number Type	The call number type.	Possible values are: Source specified in subfield $2 None Superintendent of Documents classification Shelved separately Shelving control number Other scheme National Library of Medicine classification Dewey Decimal classification Unknown Library of Congress classification Title
Permanent Dewey Classification Top Line	Store the first 3 digits of the Dewey Classification
Permanent LC Classification Code	Stores the letters that the LC class number start with such as BF, QA, etc.
Permanent LC Classification Number	Stores the numbers that follow the letters until the first period that is followed by a letter
Permanent LC Classification Top Line	Stores the LC class number top line that represents the code and numbers until the first period followed by a letter.	For example, when lc_class_number is NB933.F44, the top line is NB933).
Public note	The public note.	From MARC holdings record 852 field subfield z For more information, see the Physical Item Editor Page - Notes Tab table in Updating Item-Level Information.
Summary Holding	Free-text enumeration and chronology data	This information comes from the 866$a field. If the record has multiple 866 fields, the information is separated by a semicolon delimiter.
Suppressed from Discovery	Indicates if the bibliographic record is suppressed from discovery	From the holdings record Suppressed From Discovery option in the MD Editor
Suppressed from Discovery by Suppressed Location	Indicates if the holdings record is suppressed from discovery because the location is suppressed (but not necessarily the record)	From the Suppress from Discovery checkbox for the location in the configuration of the location

List of Holdings Page

Item Creation Date

The Item Creation Date table is a dimension table that stores details about the physical item creation date. Key fields are used whenever calculations are required. Description fields may be used for formatting the display of the report. Alma stores the following types of fields:

Calendar Fields – These are date fields as they display in the calendar.
Fiscal Date Fields – These are date fields that match the institution's fiscal period. In the examples below, the fiscal period of the institution is for fiscal year 2012 that starts June 1, 2011 and ends May 31, 2012.

Using this dimension, the user may drill down from year to month to the specific date on which the physical item was created. The number of the physical item is accumulated to the relevant level in the hierarchy.

Item Creation Date
Field	Description	Additional Information
Item Creation Date	Stores the item creation date in a date format such as 2/29/2014.	All date dimensions include dates up to and including 30 years back and 20 years forward. So, for example, if today is March 17, 2021: The earliest loan date that would appear is March 17, 1991. The latest due date that would appear is March 17, 2041.
Item Creation Start of Week	The date of the first business day of the week
Item Creation Week Number	The number of the week of the year
Item Creation Month Key	Stores the month of the date in number format such as 2 for February	This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
Item Creation Month	Stores the month of the date in month description format such as February
Item Creation Full Month	Stores the month and the year of the date in a display format such as Feb 12	This field is useful when comparing data on a month basis between years.
Item Creation Quarter	Stores the quarter of the date in a display format such as Q1
Item Creation Year	Stores the year of the date in number format such as 2012
Item Creation Fiscal Month Key	Stores the fiscal month of the date in number format such as 2 for February	This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
Item Creation Fiscal Year	Stores the fiscal year of the date in a string format such as 2012.	If the fiscal year description is stored in the institution fiscal period configuration table. This value is taken from there.
Item Creation Date Filter (under construction)	Used to filter the item creation date. The functionality of this field may change in the future, so this field should not be used for saved reports.
Creation Date	Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific modification date.	This column provides you with the option of viewing the accumulative measures in each level of the hierarchy.

Item Modification Date

The Modification Date table is a dimension table that stores details about modification of physical item inventory.

The Item Modification date is the date of the last change to the item. Therefore, if on January 19, 2016 the item was in process type Acquisition, on January 20, 2016 the item was in process type Request, and on January 21, 2016 the item was in process type Loan (and no additional change to the item was made after January 21), the Item Modification Date is January 21, 2016.

Key fields are used whenever calculations are required. Description fields may be used for formatting the display of the report. Alma stores the following types of fields:

Calendar Fields – These are date fields as they display in the calendar.
Fiscal Date Fields – These are date fields that match the institution's fiscal period. For the examples below, the fiscal period of the institution is for fiscal year 2012 that starts June 1, 2011 and ends May 31, 2012.

Using this dimension, the user can drill down from year to month to the specific date on which the physical item was created. The number of physical item is accumulated to the relevant level in the hierarchy.

The Item Modification Date is updated when a core activity is performed, but not a fulfillment activity.

Manually saving a holding record will update the modification date for physical items.

Item Modification Date
Field	Description	Additional Information
Item Modification Date	Stores the item modification date in a date format such as 2/29/2014.
Item Modification Start of Week	The date of the first business day of the week
Item Modification Week Number	The number of the week of the year
Item Modification Month Key	Stores the month of the date in number format such as 2 for February	This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
Item Modification Month	Stores the month of the date in month description format such as February
Item Modification Full Month	Stores the month and the year of the date in a display format such as Feb 12	This field is useful when comparing data on a month basis between years.
Item Modification Quarter	Stores the quarter of the date in a display format such as Q1
Item Modification Year	Stores the year of the date in number format such as 2012
Item Modification Fiscal Month Key	Stores the fiscal month of the date in number format such as 2 for February	This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
Item Modification Fiscal Year	Stores the fiscal year of the date in a string format such as 2012.	If the fiscal year description is stored in the institution fiscal period configuration table, this value is taken from there.
Item Modification Date Filter	Used to filter the item modification date. The functionality of this field may change in the future, so this field should not be used for saved reports.
Modification Date	Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific modification date. By using this column it provides the user the option to view the accumulative measures in each level of the hierarchy.

Item Receiving Date

The Receiving Date table is a dimension table that stores details about the date the item was received by the library.

Item Receiving Date
Field	Description	Additional Information
Item Receiving Date	Stores the item modification date in a date format such as 2/29/2014.
Item Receiving Start of Week	The date of the first business day of the week
Item Receiving Week Number	The number of the week of the year
Item Receiving Month Key	Stores the month of the date in number format such as 2 for February	This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
Item Receiving Month	Stores the month of the date in month description format such as February
Item Receiving Full Month	Stores the month and the year of the date in a display format such as Feb 12	This field is useful when comparing data on a month basis between years.
Item Receiving Quarter	Stores the quarter of the date in a display format such as Q1
Item Receiving Year	Stores the year of the date in number format such as 2012
Item Receiving Fiscal Month Key	Stores the fiscal month of the date in number format such as 2 for February	This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
Item Receiving Fiscal Year	Stores the fiscal year of the date in a string format such as 2012.	If the fiscal year description is stored in the institution fiscal period configuration table, this value is taken from there.
Item Receiving Date Filter	Used to filter the item receiving date. The functionality of this field may change in the future, so this field should not be used for saved reports.
Item Receiving Date	Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific receiving date. By using this column it provides the user the option to view the accumulative measures in each level of the hierarchy.

Bibliographic Details

The Bibliographic Details table is a dimension table that stores the bibliographic details of the physical item. The primary key of the table is MMS_ID.

The field descriptions can be found in the Bibliographic Details shared dimension.

Ex Libris works with content providers worldwide to enrich the metadata available in the Alma Community Zone. To enrich the journal/serial content in the CZ, we work directly with the Library of Congress CONSER feed for electronic serials, which we match against our knowledge base to enrich with all of the relevant metadata fields that they supply (for more details, see Community Zone Serial Records Enrichment) and enrich the CZ records with all relevant metadata, including the 050 fields (when available).

In the case of book content, we work with multiple providers who are willing to share their metadata with the Alma community globally (for more details, see Community Zone Monograph Records Enrichment). If you have local access to these classifications, you may want to consider working with the local extension for these records whenever an update is not available. (For more details, see Working with Local Extension Fields for Community Zone-linked Records.)

The Bibliographic Details table contains two kinds of fields, those derived from the MARC record and those that come from Alma. Although in analytics there is no distinction made between these fields, for explanatory purposes we have divided them into two tables below.

Bibliographic Details
Field	Note	Mapping from MARC21	Mapping from UNIMARC	Mapping from Dublin Core
Author		100,110,111	700,701,710,711	Currently empty, planned to come from dc:creator, dcterms:creators
Author (Contributor)	An additional Author field	711 a,c-e,i,j,n,q,u and its 880 700 a-e,j,q,u and its 880 710 a-e,i,n,u and its 880	700 a-d,f,p 701 a-d,f,p 710 a-h,p 711 a-h,p 720 a,f" 721 a,f 702 a-d,f,g 712 a-h,p 722 a,f	Currently empty, planned to come from dc:contributor, dcterms:contributor
Begin Publication Date		008 pos. 07-10	100.Date1	Not relevant for Dublin Core
BIB 008 MARC	The contents of the MARC 008 bibliographic field	008		Not relevant for Dublin Core
BIB LDR MARC	The contents of the MARC LDR bibliographic field	LDR		Not relevant for Dublin Core
Bibliographic Acquisition Accession Number Note	The identification code assigned to materials acquired in a single and separate transfer of custody (from MARC field 541 $e).	541 e		Not relevant for Dublin Core
Bibliographic ID		010 excluding numeric subfields	020 a	dcterms:identifier dcterms:ISBN, dcterms:identifier dcterms:ISSN
Bibliographic Level		Position 7 of the LDR field of the bibliographic record	Position 7 of the LDR field of the bibliographic record	Not relevant for Dublin Core
Bibliographic Source of Acquisition Note	The name of the people or organization that is the source of the material (from MARC field 541 $a)	541 a		Not relevant for Dublin Core
Category of Material		Position 0 of the 007 field	200 b	dc:type
DC Description		Relevant only for Dublin Core	Relevant only for Dublin Core	dc:description dcterms:description dcterms:abstract
DC License		Relevant only for Dublin Core	Relevant only for Dublin Core	Field does not yet exist. It will be populated by dcterms:license
DC Rights		Relevant only for Dublin Core	Relevant only for Dublin Core	Field does not yet exist. It will be populated by dc:rights and dcterms:rights
Edition		MARC 250 subfields a,b	205 a,b,f,g	dcterms:isVersionOf
Electronic location and access	The location and access URl for the electronic resource	856 all subfields
End Publication Date		008 pos. 11-14	100.Date2	Not relevant for Dublin Core
Form of Item	The form of the item	MARC 008 pos. 29 (Maps and Visual Material) or 23 (other material configurations)		dc:format
General Note	The general note	500 a, 5
Government Publication	The government publication type	MARC 008 pos. 28 According to MARC21 Format for Bibliographic Data, MARC 008 pos. 28 is Government Publication for the following material types: Books, Computer Files, Continuing Resources, Maps, and Visual Materials. For Music MARC 008 pos. 28 is Accompanying matter. For Mixed material MARC 008 pos. 28 is Undefined. Consequently, when using this field, you may want to filter out records with Material Type = Music and Material Type = Mixed material.		Not relevant for Dublin Core
ISBN		MARC 020 a,z MARC 776 z	010 a	dcterms:identifier dcterms:ISBN
ISBN Valid	The valid ISBN value	MARC 020 a		Not relevant for Dublin Core
ISSN		022 l,a 776 x (for non-physical records)	011 a f	dcterms:identifier dcterms:ISSN
ISSN Valid	The valid ISSN value	MARC 022 a		Not relevant for Dublin Core
Language Code		008 pos. 35-37	101 a	Currently comes from dc:language. Planned to come from dc:language and dcterms:language
Language Of Cataloging	The language in which the cataloging was done	040 b	100 a,22-24	Not relevant for Dublin Core
Local Note	The local note	590 a, 5
Material Type	See the table, Fields that Identify the Bibliographic Material Type, in the Material Types in Search Results section for a description of material type.	MARC control LDR Material Type		Planned to be empty. Currently comes from dc:type
Material Type Code	Code of the material type described above (in Material Type).	MARC control LDR Material Type		Not relevant for Dublin Core
Network Number		035 a z	053 a z	dc:identifier , dcterms:identifier
OCLC Control Number (019)	The OCLC control number Leading zeros are not displayed.	019 a When the subfield begins with one of the following prefixes: (OCLC) (OCoLC) ocm ocn on		Not relevant for Dublin Core
OCLC Control Number (035a)	The OCLC control number Leading zeros are not displayed.	035 a When the subfield begins with one of the following prefixes: (OCLC) (OCoLC) ocm ocn on	035 a	Not relevant for Dublin Core
OCLC Control Number (035a+z)	The OCLC control number Leading zeros are not displayed.	035a+z When the subfield begins with one of the following prefixes: (OCLC) (OCoLC) ocm ocn on	035a+z	Not relevant for Dublin Core
OCLC Control Number (035z)	The OCLC control number Leading zeros are not displayed.	035 z When the subfield begins with one of the following prefixes: (OCLC) (OCoLC) ocm ocn on	035 z	Not relevant for Dublin Core
Open Access	Indicates if the article is open access	Based on 506 f 506 2		Not relevant for Dublin Core
Original Cataloging Agency	The MARC code or the name of the organization that created the original record	040 a	081 b	Not relevant for Dublin Core
Place Code		008 pos. 15-17	102$$a	Currently empty, planned to come from dcterms:spatial
Place of Publication - City	The city of publication	For a list of country codes, see: MARC Code List for Countries	For a list of country codes, see: List of ISO 3166 Country Codes	Not relevant for Dublin Core (use Place Code) If the value of this field in the bibliographic record does not exist in the official list of place codes, the value for this field in Alma Analytics will be "No place, unknown, or undetermined". If there are multiple place codes in this field, only the first value is displayed.
Place of Publication - Country	The country of publication	For a list of country codes, see: MARC Code List for Countries	For a list of country codes, see: List of ISO 3166 Country Codes	Not relevant for Dublin Core (use Place Code) If the value of this field in the bibliographic record does not exist in the official list of place codes, the value for this field in Alma Analytics will be "No place, unknown, or undetermined". If there are multiple place codes in this field, only the first value is displayed.
Place of Publication - State	The state of publication	For a list of country codes, see: MARC Code List for Countries	For a list of country codes, see: List of ISO 3166 Country Codes	Not relevant for Dublin Core (use Place Code) If the value of this field in the bibliographic record does not exist in the official list of place codes, the value for this field in Alma Analytics will be "No place, unknown, or undetermined". If there are multiple place codes in this field, only the first value is displayed.
Publication Date		The publication date is determined as follows: the bibliographic details publication date comes from 264 subfield c if there is no 264 subfield c, then the publication date comes from 260 subfield c if there is no 264 subfield c and also no 260 subfield c, then the publication date comes from 008 pos. 7-10	The publication date is determined as follows: the bibliographic details publication date comes from 210 subfield d If there is no 210 subfield d, then the publication date comes from field 214 subfield d. if both fields do not exist, then the publication date comes from field 100 subfield a pos. 9-12	dc:date
Publication Place		MARC 260 a. When 260a is empty, it is taken from MARC 264a	210 a 214 a	Not relevant for Dublin Core (use Place Code)
Publisher		260 b 264 b	210 c 214 c	dcterms:publisher, dc:publisher
Resource Type	Constructed based on existing bibliographic fields such as the LDR and 008. For more information, see The Resource Type Field.
Series		800 t,v 810 t,v 811 t,v 830 a,n,p,v	410 a,h,i,o,t,x	Currently empty. Planned to come from dcterms:isPartOf
Series Statement	The series statement	490 a,v x
Subjects		6XX excluding 69X, 630, 689	600 a,b 602 603-8 610 616 617	dc:subject dcterms:LCSH,MESH,DDC,UDC,LCC
Subjects (Names)	The subject names	600 a,b,c,d,e,l,t.u 610 a,b,c,d,e,l,n,t,u 611 a,b,c,d,e,j,l,n,q,t,u
Title		245 a,b 249 a,b,c,v	200 a,c,d,e,h,i	dc:title
Title (Complete)	The information from MARC field 245, subfields $p, $n, $s, $k, $f, $g.	245 a,n,p,h,b,c,f,g,k,s	200 a-i	Currently empty, planned to come from dc:alternative
Title (Filing)	The title with common words such as "The" and "An" removed to help with sorting the title alphabetically. Any text between double arrows (<<>>) is removed. For a video describing the use of this field, see Sort Analytics Reports by Filing Title - Ignoring "The", "A", and "An".	240 a,c,p 245 a,c,p	200 a,e 500	Not relevant for Dublin Core
Title (Normalized)	The normalized Title. This field is useful when you want to use the normalized title from one subject area to compare with a report with fields from a different subject area. This field is built in the following manner: Alma does the following to the 245 field (except subfields c,h,6 and 8) in the following order: Removes non filing text. Removes <<>> and anything between them. Removes these characters: []\|,.;:" Changes these characters to a space: !@#$%^&*()_+-={}\<>?/~' Changes characters to lowercase. Packs spaces (replace all sequences of more than one space with a single space).	245 a,b,n,p 249 a,b,c,v	200 a,c,d,e,h,i	dc:title
Title Author Combined and Normalized	100 characters of the normalized title and the first four letters of the author in lowercase letters, with spaces removed	See Author and Title Fields	See Author and Title Fields	See Author and Title Fields
Type of Date		008 pos. 6	100 pos 8	Not relevant for Dublin Core
Uniform Resource Identifier	The uniform resource identifier	856 u	856 u	dc:identifier (dcterms:URI) ,dcterms:identifier (dcterms:URI)
Uniform Resource Identifier Exists	Indicates if 856 subfield u contains data
Uniform Title		240 130	500	Not relevant for Dublin Core

The following table describes other fields in the shared dimension (taken from Alma and not MARC):

Administrative Bibliographic Details
Field	Source in Alma (for Internal Reference)
Active Course Code	The code of an active course.
Active Course Name	The name of an active course.
Bibliographic Lifecycle	The Lifecycle of the item. Possible values are Deleted and In Repository. This allows you to filter reports by In Repository/Deleted items.
Brief Level	The level of the brief record
Chinese Classifications	Stores the Chinese Classification
Collection ID	The ID of the collection. This is a title level collection as defined at 'Resources > Manage Inventory > Manage Collections'.
Collection Name	The name of the collection. This is a title level collection as defined at 'Resources > Manage Inventory > Manage Collections'.
Creation Date	Stores the creation date. Date fields can consist of a partial date, such as just the year or a month and year.
Creation Date (Calendar)	Stores the creation date. Calendar Date fields always consist of a month, date, and year. If the information is not provided, 01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date.
Creator	Stores the name of the user that created the record
Dewey Classification	Stores the Dewey Classification
Dewey Classification Top Line	Stores the first 3 digits of the Dewey Classification Regarding Dublin Core: Currently empty. Planned to come from dc:subject (dcterms:DDC), dcterms:subject (determs:DDC)
Has Local Extensions	Indicates if the Community Zone-linked record has local extensions (Y/N)
ISBN (Normalized)	The normalized ISBN.
ISSN (Normalized)	The normalized ISSN.
LC Classification Top Line	Stores the combined LC code and classification numbers until the first period which is followed by a letter. If there are no periods then the entire string is taken until there is a space. The length is limited to 50 characters. For example: if the LC Classification is \| a HB3821.I8 \|b R3 then the LC Classification Top Line will be HB3821 if the LC Classification is \| a DF506.5 \|b .G27 then the LC Classification Top Line will be DF506.5 if the LC Classification is \| a N 7353 \|b .K513 1965 then the LC Classification Top Line will be N if the LC Classification is \| a NOT YET ORDERED then the LC Classification Top Line will be NOT The LC Classification Top Line will contain one value. For MARC21, if the bibliographic record has: both 090 and 050 then the LC Classification Top Line will come from 090 050 and not 090 then the LC Classification Top Line will come from 050 090 and not 050 then the LC Classification Top Line will come from 090 Regarding Dublin Core: Currently empty. Planned to come from: (dcterms:LCSH), dcterms:subject (determs:LCSH), dc:subject (dcterms:LCC), dcterms:subject (determs:LCC) Recent data may not be available if it has not yet been received from CONSER.
Link ID	The link ID. For more information concerning this field and the next two, see Understanding the fields Link ID Linked to CZ and Linked to NZ in the Bibliographic Details folder.
Linked to CZ	Indicates if the record is linked to the Community Zone
Linked to NZ	Indicates if the record is linked to the Network Zone
Local Param 1-10	This field allows you to enrich the bibliographic information exported to Analytics with additional information from MARC fields in Alma. In order to make use of this field, you must contact Ex Libris Support and supply them with a three-digit MARC field code (for example, 901). (The field does not need to include a 9.) The fields can be number and code fields but not control fields. Therefore, the field must be greater than or equal to 010, because 00X are Control Fields and 01X-09X are Numbers and Code Fields. Following configuration of this field by Ex Libris Support, its value will be available in analytics. Subfields can be maintained in the Analytics fields identified for Local Param. When this capability is implemented, fields/subfields appear in Alma Analytics with the Alma subfield delimiter (either $$ or ‡) used to delineate the subfield content. Contact Support to enable this feature. Note that reindexing is required to fully implement this capability. Note that the local param fields are not related to the MARC type of the record. For example, if field 913 is defined to be in local param 1 then field 913 will always be in local param 1. This is the case if the record is of the type KORMARC, CNMARC, UNIMARC, MARC21, and so forth. It is not possible to have different sets of Local Param 1-10 for different types of MARC. The data in the local parameters is limited to 3900 characters.
Managed by Provider	Indicates if the electronic resource is managed by the provider
MMS ID	Stores the MMS ID of the item. This is the MMS ID of the portfolios associated with the electronic collection. It is not the MMS ID of the electronic collection or of the MMS ID of the descriptive bibliographic record added in the Additional tab of the electronic collection editor. If there are no portfolios, the value of this field is empty.
Modification Date	Stores the modification date. Date fields can consist of a partial date, such as just the year or a month and year.
Modification Date (Calendar)	Stores the modification date. Calendar Date fields always consist of a month, date, and year. If the information is not provided, 01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date.
Modified By	Stores the user name that modified the record
Network ID	This field is used by institutions implementing a Network Zone. It is the same as the MMS ID of the bibliographic record in the Network Zone and can be used to create reports that show the MMS ID in the member institution (using the existing MMS ID), as well as the corresponding MMS ID in the Network Zone.
Originating System	The system where the bibliographic record originated
Originating System ID	The ID of the system where the bibliographic record originated
Originating System Version	The version of the originating system
Peer Reviewed	Indicates if the article was peer reviewed
Provider Name	The name of the provider
Record Format	The format of the bibliographic record. Examples: MARC 21 DC KORMARC CNMARC UNIMARC
Suppressed from Discovery	Indicates whether the record is suppressed from external discovery systems

Library Unit

The Library Unit table is a dimension table that stores details about the library that manages your physical items.

The field descriptions can be found in the Library Unit shared dimension.

Library Unit
Field	Description	Additional Information
Library Code	Stores the library code
Library Code (Active)	Stores the code of active (not deleted) libraries	This field is empty if the library is deleted.
Library Name	Stores the library name
Library Name (Active)	Stores the library name of active (not deleted) libraries	This field is empty if the library is deleted.
Library Description	Stores the library description
Unit Type	Store the type of organization unit	Values can be Institution/Library

Location

Location
Field	Description	Additional Information
Campus Code	Stores the code of the campus where the physical item is located.	This value is calculated through the library campus.
Campus Name	Stores the description of the campus.	This value is calculated through the library campus.
Campus Description	Stores the name of the campus.	This value is calculated through the library campus.
Library Code	Stores the library code to which the location of the physical item belongs.	It is recommended to use the Library Code field of the Library Unit dimension instead of this one.
Library Name	Stores the library name to which the location of the physical item belongs.	It is recommended to use the Library Name field of the Library Unit dimension instead of this one.
Library Description	Stores the library description to which the location of the physical item belongs.
Location Code	Stores the code of the location of the physical item.
Location Name	Stores the name of the location of the physical item.
Location Type	Stores the type of the location of the physical item, whether it is open stack or closed stack.
Call Number Type	Stores the call number type used by the location of the physical item.
External Name	Stores the name to be displayed to patrons for the location of the physical item.
Remote Storage Code	Points to a remote storage location where the physical items are stored, if one exists.
Location	Stores the Hierarchy column that allows the user to drill down from the campus to the library and then to the location of the physical item.	This column provides the user with the option to have the user view the accumulative measures (num_of_items) in each level of the hierarchy.
Suppressed from Discovery	Indicates if the holdings record is suppressed from discovery because the location is suppressed (but not necessarily the record)	From the Suppress from Discovery checkbox for the location in the configuration of the location

LC Classification

Using this dimension, the user can drill down from Group1 to Group4. In each level, the user may see measures accumulated to the relevant group and see the number of items grouped by classification.

The field descriptions can be found in the LC Classifications shared dimension.

For Physical Items, Alma takes LC classification information from the holdings record level. For all other subject areas, it is taken from the bibliographic record level.

Ex Libris works with content providers worldwide to enrich the metadata available in the Alma Community Zone. To enrich the journal/serial content in the CZ, we work directly with the Library of Congress CONSER feed for electronic serials, which we match against our knowledge base to enrich with all of the relevant metadata fields that they supply (for more details, see Community Zone Serial Records Enrichment). We receive weekly updates from CONSER and enrich the CZ records with all relevant metadata, including the 050 fields (when available).

In the case of book content, we work with multiple providers who are willing to share their metadata with the Alma community globally (for more details, see Community Zone Monograph Records Enrichment). If you have local access to these classifications, you may want to consider working with the local extension for these records whenever an update is not available. (For more details, see Working with Local Extension Fields for Community Zone-linked Records)

LC Classifications
Field	Description	Additional information
Start Range	Stores the start range of the group such as PS501
End Range	Stores the end range of the group such as PS689
Classification Code	Stores the letters in the beginning of the range such as PS	In the Fulfillment subject area, if there is more than one classification code, the last one appears. The Classification Code comes from the bibliographic record, except for in the Physical Items subject area where it comes from the holdings record.
Start Range Number	Stores the numbers that come after the letter in the start range
End Range Number	Stores the numbers that come after the letter in the end range
Group1	Stores the name of the first level
Group2	Stores the name of the second level
Group3	Stores the name of the third level
Group4	Stores the name of the fourth level
Group5	Stores the name of the fifth level
Classifications	Stores the Hierarchy column that allows the user to drill down from the first level of the classification to the fourth level. Using this column provides the user with the option to view the accumulative measures. Note that the fifth level is not included in this field.

For a Knowledge Article related to LC Classifications, see Analytics LC Classification code shows Unknown even though a call number is present in Alma.

Dewey Classifications

Books can be classified with Dewey Classifications.

In Dewey Classifications, topics are ordered in a hierarchy that is indicated by a three digit number. The highest level of the hierarchy is indicated by a number with one significant digit followed by two zeros, such as 600. The second level in the hierarchy is indicated by a number with two significant digits followed by one zero, such as 630. The third level in the hierarchy is indicated by a number with three significant digits such as 636.

Note that the Dewey number is taken from the 852 subfield h of the holdings record and not from the 082 of the bibliographic record.

The field descriptions can be found in the Dewey Classifications shared dimension.

Dewey Classifications
Field	Description	Additional information
Dewey Number	Holds the first 3 digits of the Dewey Classification.	The Dewey Number comes from the bibliographic record, except for in the Physical Items subject area where it comes from the holdings record.
Group1	Stores the name of the first level.
Group2	Stores the name of the second level.
Group3	Stores the name of the third level.
Dewey Classifications	Stores the Hierarchy column that allows the user to drill down from the first level of the Dewey Classification to the third level. Using this column provides the user with the option to view the accumulative measures (loans or returns) in each level of the hierarchy.

Other Classifications

The Other Classifications table is a dimension table that contains fields for classification systems other than LC and Dewey. Like LC and Dewey classifications, you can drill down to different levels, or groups. At each level, the measures associated with the selected group are displayed.

Other Classifications
Field	Description	Additional Information
Chinese Classifications
Classification Code	The Chinese classification code	If the code is not found or in an incorrect format Unknown is displayed.
Group 1-7 (Chinese)	Stores the name of the levels of classification in Chinese
Group 1-7 (English)	Stores the names of the levels of classification in English
Chinese Classifications (Taiwan)
Classification Code	The Chinese (Taiwan) classification code	If the code is not found or in an incorrect format Unknown is displayed.
Group 1-3 (Chinese-Taiwan)	Stores the name of the levels of classification in Chinese-Taiwan
Group 1-3 (English)	Stores the names of the levels of classification in English
NLM Classifications
NLM Classification Code	Stores the NLM classification code	If the code is not found or in an incorrect format, Unknown is displayed. If there are multiple codes, only the first is displayed. Taken from the 060 or 096 fields of the bibliographic record.
NLM Classification Number	Stores the numbers that come after the NLM letter code
NLM Group 1-5	Stores the names of the levels of classification
U.S. SuDoc Classifications
U.S. SuDoc Classification Code	Stores the SuDoc Classification code with which to find a match to the SuDoc Classification code from the bibliographic record	The SuDoc Classification Code is derived from government document fields in the bibliographic record. If the code is not found or in an incorrect format, Unknown is displayed. If there are multiple codes, only the first is displayed.
U.S. SuDoc Classification Number	Stores the numbers that come after the SuDoc letter code	The SuDoc Classification Number is derived from the published SuDoc Classification table on the Federal Depository Library Program (GPO) Website
U.S. SuDoc Agency	Stores the name of the top level (parent) U.S. government agency	Unlike other classification systems, the SuDoc system groups publications together by the publishing agency, that is, a U.S. government agency.
U.S. SuDoc SubAgency	Stores the name of subordinate bureaus and divisions of the parent U.S. agency	A subagency is displayed if a publication is published by a subordinate bureau or division within a parent agency. If the top level agency is the publishing agency, then that agency is also listed as the subagency.
U.S. SuDoc Title	Stores the name of either the title of the publication or indicates miscellaneous publications	Title designates either a specific publication title or category of the publication.

Temporary Location

The Temporary Location table is a dimension table that stores details about the temporary location where the physical item is located. The primary key of the table is LIBRARYID and LOCATION_CODE.

Location
Field	Description	Additional Information
Campus Code	Stores the code of the campus where the physical item is located.	This value is calculated through the library campus.
Campus Name	Stores the description of the campus.	This value is calculated through the library campus.
Campus Description	Stores the name of the campus.	This value is calculated through the library campus.
Library Code	Stores the library code to which the location of the physical item belongs.	It is recommended to use the Library Code field of the Library Unit dimension instead of this one.
Library Name	Stores the library name to which the location of the physical item belongs.	It is recommended to use the Library Name field of the Library Unit dimension instead of this one.
Library Desc	Stores the library description to which the location of the physical item belongs.
Location Code	Stores the code of the location of the physical item.
Location Name	Stores the name of the location of the physical item.
Location Type	Stores the type of the location of the physical item, whether it is open stack or closed stack.
Call Number Type	Stores the call number type used by the location of the physical item.
External Name	Stores the name to be displayed to patrons for the location of the physical item.
Remote Storage Code	Points to a remote storage location where the physical items are stored, if one exists.
Location	Stores the Hierarchy column that allows the user to drill down from the campus to the library and then to the location of the physical item.	This column provides the user with the option to have the user view the accumulative measures (num_of_items) in each level of the hierarchy.

PO Line

The PO Line table is a dimension table that stores details about the PO and the PO Line that is associated with the fund transaction. PO Line is the management unit of the order. The inventory item holds all information needed to create the inventory item, fund transaction, as well as manage the receiving, renewing, and activating ordered inventory items. The primary key of the table is PO_LINE_ID.

Field	Description	Field Location in Alma	Additional Information	Data Type	Data Size
Access Model	The public access model for the electronic resource.	The "Activation Information" section on the PO Line Summary page.	Available only for electronic resources. The values are configured in the Access Model code table.	VARCHAR	4000


Acquisition Method	The code of the method by which the PO Line is acquired, with the default value set as PURCHASE. This value may affect when the PO Line is sent.		See the Acquisition Method Code table.	VARCHAR	255
Acquisition Method Description	The description (label) of the acquisition method.	The "PO Line Information" section on the PO Line Summary page. The label in Alma is "Acquisition method".		VARCHAR	4000


Additional Order Reference	An additional identifier for the PO line.	The "PO Line Information" section on the PO Line Summary page. The label in Alma is "Additional PO Line Reference Field".		VARCHAR	255


Application	Used for identifying migrated PO lines.			VARCHAR	255
Assigned To	The user that the order is assigned to.	The top Summary section on the PO Line Summary page.		VARCHAR	255
Associated PO Line	The PO line associated with the current one.	The "PO Line Information" section on the PO Line Summary page.		VARCHAR	255
Association Type	The type of association between PO lines, such as defined by user or by a process or job.	In the "Associated PO Lines" tab.	Available when there is an associated PO line	VARCHAR	255
Cancellation Reason	Code for the reason that a PO line is canceled Displays only on canceled lines.		The cancellation reason can be seen in the History tab. See also PO Line Cancellation Reasons Code table.	VARCHAR	255
Cancellation Restriction	Indicates if a cancellation restriction note, containing a warning upon the cancellation of a PO line, is configured to be displayed.	The "PO Line Information" section on the PO Line Summary page.		VARCHAR	4000
Cancellation Restriction Note	The warning to be displayed when canceling a PO line.	The "PO Line Information" section on the PO Line Summary page.	When "Cancellation Restriction" is true.	VARCHAR	4000
CKB ID	When clicking 'Order' from an Electronic Collections search, a CKB ID is stored as a reference to the electronic collection PID, rather than an MMS ID.			VARCHAR	50
Claiming Date	The date on which the PO line is sent to the claims task list.		Determined by adding the number of days in the claiming grace period to the expected receipt/activation date. Calculated from the "Claiming grace period field (days)" field on the "Vendor Information" section on the PO Line Summary page.	DATETIME


Claiming Date (Calendar)	Claiming Date without a timestamp			DATE
Currency	The currency of the transaction.	The "Pricing and Funding" section on the PO Line Summary page.		VARCHAR	3
Discount	The discount amount.	The "Pricing and Funding" section on the PO Line Summary page. The label in Alma is "Discount (amount)".		DOUBLE


ERP Number	The ERP number of the purchase order.		Used by customers that want the purchase order to be approved by an ERP system before it is sent to the vendor.	VARCHAR	255
Expected Activation Date	The expected date for the resource activation by vendor for electronic PO lines.	The "PO Line Information" section on the PO Line Summary page.	Only for electronic PO lines.	DATE
Expected Activation Interval	For electronic PO Lines, the number of days after ordering that you expect electronic orders to be activated.	The "Vendor Information" section on the PO Line Summary page. The label in Alma is "Activation due after ordering (days)".	Only for electronic PO lines.	DOUBLE


Expected Receipt after Ordering Interval	For physical PO Lines, the number of days after ordering that you expect physical orders to be received.	The "Vendor information" section on the PO Line Summary page. The label in Alma is "Expected receipt after ordering (days)".	Only for physical PO lines.	DOUBLE


Expected Receiving Date	For physical PO lines, the expected date for physical items to be received from the vendor.	The "Vendor information" section on the PO Line Summary page. The label in Alma is "Expected receipt (date)".	Only for physical PO lines.	DATE


Expected Receiving Interval	Displays the interested users for the PO line. If more than one user is added to the PO line, values are concatenated.	The "Interested Users" section on the PO Line Summary page.	Note that to search for a specific user, you should use the contain filter to also find cases where more than one user was added to the PO.	DOUBLE
Interested Users	Displays the interested users for the PO line. If more than one user is added to the PO line, values are concatenated.	The "Interested Users" section on the PO Line Summary page.	Note that to search for a specific user, you should use the contain filter to also find cases where more than one user was added to the PO.	VARCHAR	4000
Invoice Status	The status of the invoice.	The "PO Line Information" section on the PO Line Summary page.		VARCHAR	4000
Is Claimed	Flags the PO Line if there is an open claim to the vendor. A PO line is claimed if the items were not received or if the receiving/activation date of the PO line passed.	The marked "In Claim" in the Top Summary section on the PO Line Summary page.		VARCHAR	3
Item Description	Description of the item.	The "Ordered Items" section on the PO Line Summary page.	The description entered for the PO line. Note that this field is not taken from the bibliographic details. It is useful when no item is related to the PO line. Only for physical one-time PO lines.	VARCHAR	4000
License ID	The ID of the license of the PO line that is relevant for electronic PO lines.	The ID of the "License" field in the "Activation Information" section on the PO Line Summary page.	Available only for electronic resources.	VARCHAR	50
List Price	The list price for a single copy of the item.	The "Pricing and Funding" section on the PO Line Summary page.		DOUBLE
Manual Renewal	An indication whether the PO line is renewed manually or automatically.	The "Renewal Information" section on the PO Line Summary page.	Yes for manual and No for automatic.	VARCHAR	3
Material Supplier	The vendor supplying the material being ordered.	The "Vendor Information" section on the PO Line Summary page.	This is a concatenation of: name (name code)/account description (account code).	VARCHAR	800
Material Type	The material type of the PO line.	The "PO Line Information" section on the PO Line Summary page.	For example: Book.	VARCHAR	4000
Net Price	A calculation of the total price for the PO line based on the list price per copy, the discount, and the number of copies ordered.	The "Pricing and Funding" section on the PO Line Summary page.		DOUBLE
No Charge	Indicates that there is no charge for the PO line.	The "Pricing and Funding" section on the PO Line Summary page.	Yes / No	VARCHAR	10
Note To Vendor	Notes to the vendor.	The "Vendor Information" section on the PO Line Summary page.		VARCHAR	2000
Order Line Type	The order line type as it appears in the order in Alma.	Top Summary section on the PO Line Summary page. Does not have a label in the Alma UI.	See the PO Line Type Code table.	VARCHAR	4000
Order Line Type Code	The code for the Purchase Order line type.		See the PO Line Type Code table.	VARCHAR	255
PDA Code	The patron driven acquisition code.		Only if the PO line was created by a PDA process.	VARCHAR	4000
PDA Name	The patron driven acquisition name		Only if the PO line was created by a PDA process.	VARCHAR	4000
PO Approval Date	The date the PO was approved (the sent date).	The "Sent Date" field on the "PO Summary" page.		DATE
PO Creation Date	The timestamp of the PO creation date.	Can be seen by clicking the information icon on the "PO Summary" page. The label in Alma is "Created on".		TIMESTAMP
PO Creation Date (Calendar)	PO creation date without a timestamp.			DATE
PO Creator	The user that created the PO (user name).	Can be seen by clicking the information icon on the "PO Summary" page. The label in Alma is "Created by".		VARCHAR	255
PO Line Binding During Receiving	Indicates that the PO line is marked for binding during receiving (for physical items).	The "Receiving Information" section on the PO Line Summary page. The label in Alma is "Binding during receiving".	Relevant only for physical items.	VARCHAR	4000
PO Line Creation Date	The timestamp of the PO line creation date.	Can be seen by clicking the info icon on the "History" tab. The label in Alma is "Created on".		TIMESTAMP
PO Line Creation Date (Calendar)	PO line creation date without a timestamp.		Calendar Date fields always consist of a month, date, and year. If the information is not provided, 01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date.	DATE
PO Line Creator	The user that created the PO line (user name).	Can be seen by clicking the information icon on the "History" tab. The label in Alma is "Last created by".		VARCHAR	255
PO Line Identifier	The identifier of the ordered title. (ISSN or ISBN)	The "PO Line Information" section on the PO Line Summary page. The label in Alma is "Identifier".		VARCHAR	4000
New for June! PO Line Inventory Active Library Code	The library code of the inventory (item).			VARCHAR	4000
PO Line Inventory Library Code	The library code of the inventory (item).			VARCHAR	4000
PO Line Manual Packaging	Indicates if the PO line was manually packaged into a PO.	The "PO Line Information" section on the PO Line Summary page. The label in Alma is "Manual packaging".		VARCHAR	4000
PO Line Modification Date	The timestamp of the PO line modification date.	Can be seen by clicking the information icon on the "History" tab. The label in Alma is "Last updated on".		TIMESTAMP
PO Line Modification Date (Calendar)	PO line modification date without a timestamp.			Date
PO Line Modified By	The user that modified the PO line (user name).	Can be seen by clicking the info icon on the "History" tab. The label in Alma is "Last updated by".		VARCHAR	255
PO Line Notes	The notes on the PO line.	"Notes" section on the PO Line Summary page. The label in Alma is "Internal note".	Multiple notes are separated by a semicolon.	VARCHAR	4000
PO Line Owner Library Code	The code of the PO line owner library.			VARCHAR	4000
PO Line Owner Library Name	The name of the PO line owner library.	Top Summary section on the PO Line Summary page. The label in Alma is "PO Line Owner".		VARCHAR	4000
PO Line Reference	The business identifier of the PO line (PO Line number).	Top Summary section on the PO Line Summary page. The label in Alma is "PO Line".	This is the PO line number in Alma.	VARCHAR	255
PO Line Routing During Receiving	Indicates that the PO line is marked for routing during receiving (for physical items).	The "Receiving Information" section on the PO Line Summary page. The label in Alma is "Routing during receiving".	Relevant only for physical items	VARCHAR	4000
PO Line Title	The title of the PO line.	Appears in the top Summary section on the PO Line Summary page.		VARCHAR	4000
PO Line Vendor Title Number	The number of the PO line vendor title.		An identifier other than ISBN/ISSN for non-books inventory.	VARCHAR	4000
PO Modification Date	The timestamp of the PO modification date.	Can be seen by clicking the information icon on the "PO Summary" page. The label in Alma is "Last updated on".		TIMESTAMP
PO Modification Date (Calendar)	The PO modification date without the timestamp.		Calendar Date fields always consist of a month, date, and year. If the information is not provided, 01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date.	DATE
PO Modified By	The user that modified the PO (user name).	Can be seen by clicking the info icon on the "PO Summary" page. The label in Alma is "Last updated by".		VARCHAR	255
PO Number	The business identifier of the PO related to the PO line.	Top Summary section on the PO Line Summary page. The label in Alma is "PO".		VARCHAR	255
Quantity for Pricing	The number of items to be paid for.	The "Pricing and Funding" section on the PO Line Summary page.	The quantity for pricing and the number of items to create may be different in a case of discounted pricing through a deal such as "buy two items and get a third item at no additional charge".	DOUBLE
Receiving / Activation Note	Text with which the Purchasing Operator indicates to the Receiving Operator the intended location of serial order items in which no inventory items are created.	The "Receiving Information" / "Activation Information" section on the PO Line Summary page.	For physical - receiving note, for electronic - activation note.	VARCHAR	4000
Receiving Date (Latest in POL)	This field allows you to retrieve the latest receiving date for an item in a PO line.		This is useful, since a PO line can have several items and each of the items may have a different receiving date.	DATE
Receiving Status	An indication of whether or not all physical items were received in the receiving workbench.			VARCHAR	10
Reclaim Interval (Days)	The interval number of days that Alma will send reclaim letters after the initial claim letter is sent.	The "Vendor Information" section on the PO Line Summary page.		NUMERIC
Renewal Cycle	The cycle for the autorenewal job for continuous orders For example, if it is set to one year, the PO line is renewed in one year.	The "Renewal Information" section on the PO Line Summary page.	Defined in the RenewalCycle code table.	DOUBLE
Renewal Date	The date of the PO line’s next renewal for continuous orders.	The "Renewal Information" section on the PO Line Summary page.	Relevant only for continuous orders.	DATE
Renewal Note	The note of the PO line renewal for continuous orders.	The "Renewal Information" section on the PO Line Summary page.	Relevant only for continuous orders.	VARCHAR	4000
Renewal Reminder Period	Determines how many days before renewal is an email regarding that renewal sent.	The "Renewal Information" section on the PO Line Summary page. The label in Alma is "Renewal reminder period (days)".	Relevant only for manually renewed continuous orders.	DOUBLE
Reporting Code - 1-5	Five fields that store the reporting codes.	The "Reporting Codes" section on the PO Line Summary page.		VARCHAR	255
Reporting Code Description -1-5	Five fields that store the description of the five reporting code fields.	The "Reporting Codes" section on the PO Line Summary page.	As defined in the Reporting Codes code tables.	VARCHAR	4000
Rush	Indicates whether the PO line is to be rushed.	The "Receiving Information" section on the PO Line Summary page.		VARCHAR	4000
Sent Date	The date that the PO/ PO line is sent to the vendor.	The "PO Line Information" section on the PO Line Summary page. For PO line - in the history tab.		DATE
Ship To Address City	The shipped to city address.	The "Contact Information" tab on Vendor Details page.		VARCHAR	176
Ship To Address Country	The shipped to country address.	The "Contact Information" tab on Vendor Details page.		VARCHAR	320
Ship to Address ID	Internal ID of the library shipping address that should be used by the vendor.			DOUBLE
Ship To Address Line 1-5	The shipped to address lines.	The "Contact Information" tab on Vendor Details page.		VARCHAR	784
Shipping Method	The method for the vendor to ship the order.		Per the values in Shipping Method code table defined in the acquisition configuration menu.	VARCHAR	255
Source ID	The source file ID used for the EOD lines.			VARCHAR	255
Source Type	The source from which the PO line originated, for example, EOD, Manual, and Migration.	The "PO Line Information" section on the PO Line Summary page.		VARCHAR	255
Status	The business status of the PO line as Active, Canceled, or Closed There are a number of sub-statuses included in the business status "Active". See the Status (Active) field.	Appears in the top Summary section on the PO Line Summary page.		VARCHAR	255
Status (Active)	Indicates the sub-status of the "Status" field. For example: Waiting for Invoice, Waiting for Manual Renewal, Recurring Renewal, Under Evaluation, Sent, In Review, Ready to Be Sent, Waiting for Packaging, and Manual Packaging.	Appears in the top Summary section on the PO Line Summary page.	When the status is active.	VARCHAR	4000
Subscription From Date	The date for the beginning of a subscription for continuous orders.	The "Renewal Information" section on the PO Line Summary page.	Relevant only for continuous orders.	DATE
Subscription To Date	The date for the end of a subscription for continuous orders.	The "Renewal Information" section on the PO Line Summary page.	Relevant only for continuous orders.	DATE
Vendor Access Provider	The vendor that provides access to electronic resources.	The "Vendor Information" section on the PO Line Summary page.	The label in Alma is "Access provider".	VARCHAR	255
Vendor Account Code	The vendor account code as defined in the Alma vendor account definitions.	The fourth section of the field. The "Account" field in the top Summary section on the PO Line Summary page. The "Material Supplier" field in the "Vendor Information" section on the PO Line Summary page.		VARCHAR	784
Vendor Account Description	The vendor account description as defined in the Alma vendor account definitions.	The third section of the field. The "Account" field in the top Summary section on the PO Line Summary page. The "Material Supplier" field in the "Vendor Information" section on the PO Line Summary page.		VARCHAR	255
Vendor Code	The vendor code as defined in the Alma vendor details definitions.	The second section of the field. The "Account" field in the top Summary section on the PO Line Summary page. The "Material Supplier" field in the "Vendor Information" section on the PO Line Summary page.	All the vendors that have been on the order, not just the active vendor.	VARCHAR	255
Vendor Contact Person ID	The related vendor contact person ID.	On the vendor record.	Can be accessed by clicking on the Material Supplier in the Vendor Information section.	VARCHAR	50
Vendor Name	The vendor name as defined in the Alma vendor details definitions.	The first section of the field. The "Account" field in the top Summary section on the PO Line Summary page. The "Material Supplier" field in the "Vendor Information" section on the PO Line Summary page.		VARCHAR	255
Vendor Reference Number	The reference number for the PO line in Alma, as provided by the vendor Serves as a matching point for identifying a PO line in Alma.	The "Vendor Information" section on the PO Line Summary page.		VARCHAR	255
Vendor Reference Number Type	The type of the reference number.	The "Vendor Information" section on the PO Line Summary page.		VARCHAR	255

PO Line Approver

The PO Line Approver table is a dimension table that stores details about the approver of the PO line.

PO Line Approver
Field	Description	Additional Information
PO Line Approver Birth Date	The birth date
PO Line Approver Cant Edit Restricted Users	Indicates if the user can edit restricted user groups
PO Line Approver Campus Code	The campus code
PO Line Approver Creation Date	The creation date
PO Line Approver Creator	The creator
PO Line Approver Disable All Login Restrictions	Indicates if the user has IP login restrictions disabled
PO Line Approver Expiry Date	The expiry date
PO Line Approver External ID	The external ID
PO Line Approver Failed Authentication	Indicates if authentication failed
PO Line Approver First Name	The first name
PO Line Approver Full Name	The full name
PO Line Approver Gender	The gender
PO Line Approver Identifier 1-2	Identifiers 1-2
PO Line Approver IdP Service In Use	Indicates if an identity provider service is in use
PO Line Approver Job Category	The job category
PO Line Approver Job Description	The job description
PO Line Approver Last Name	The last name
PO Line Approver Last Activity Date	The last date that a patron made a request or borrowed or returned an item
User – PO Line Approver Linked from Institution Code	The linked from institution code
User – PO Line Approver Linked from Institution Name	The linked from institution name
PO Line Approver Linked to Other Institution	Indicates if linked to another institution
User – Linked From Other Institution	Indicates if the user is linked from another institution	Possible values: yes no
PO Line Approver Locked Out Date	The locked out date
PO Line Approver Middle Name	The middle name
PO Line Approver Modification Date	The modification date
PO Line Approver Modified By	The user that modified
PO Line Approver Preferred First Name	The preferred first name
PO Line Approver Preferred Language	The preferred language
PO Line Approver Preferred Last Name	The preferred last name
PO Line Approver Preferred Middle Name	The preferred middle name
PO Line Approver Primary Identifier	The primary identifier
PO Line Approver Purge Date	The purge date
PO Line Approver Resource Sharing Library	The resource sharing library
PO Line Approver Resource Sharing Library Code	The resource sharing library code
PO Line Approver Statistical Category 1-10	Statistical categories 1-10	These fields allow you to map ten statistical categories. This allows you to filter reports based on advanced user information typically stored in the statistical category fields. For more information, see Configuring Statistical Categories for Analytics.
PO Line Approver Status	The status
PO Line Approver Status Date	The status date
PO Line Approver User Email	The user's preferred email for correspondence
PO Line Approver User Group	The user group
PO Line Approver User Group Code	The user group code
PO Line Approver User ID	The user ID
PO Line Approver User Record Type	The user record type
PO Line Approver User Title	The user title
PO Line Approver User Type	The user type
PO Line Approver Cataloger Level	The cataloger level of the user
PO Line Approver Has Role Other Than Patron	Indicates if the patron has a role other than Patron
PO Line Approver Has Role Other Than Patron and Instructor	Indicates if the patron has a role other than Patron and Instructor
PO Line Approver Is Blocked	Indicates if the patron is blocked
PO Line Approver Patron Letters Opt In	The letters for which the patron has opted in
PO Line Approver Patron Letters Opt Out	The letters for which the patron has opted out

PO Line Creation Date

The PO Line Creation Date table is a dimension table that stores details about the date that the PO line was created.

PO Line Creation Date
Field	Description	Additional Information
PO Line Creation Date	Stores the date in the date format 2/29/2012
PO Line Creation Start Of Week	The date of the first business day of the week
PO Line Creation Week Number	The number of the week of the year
PO Line Creation Month Key	Stores the month of the date in number format such as 2 for February
PO Line Creation Month	Stores the month of the date in month description format such as February
PO Line Creation Full Month	Stores the month and the year of the date in a display format such as Feb 12
PO Line Creation Quarter	Stores the quarter of the date in a display format such as Q1
PO Line Creation Year	Stores the year of the date in string format such as 2012
PO Line Creation Fiscal Month Key	Stores the fiscal month of the date in number format such as 2 for February
PO Line Creation Fiscal Year	Stores the fiscal year of the date in string format such as 2012.
PO Line Creation Date Filter	Used to filter report results by date.

Fund Information

This dimension allows you to report on fund information together with physical item information. The Receiving Date field from the Physical Item Details folder can be used together with library, location, and fund information to create reports combining receiving date and fund.

This dimension enables you to answer the following business question: What is the cost per use for physical inventory? Some applications of this question are the following:

What is the number of physical items purchased with specific funds during the past year?
What is the number of loans by fund that purchased the loaned item?
What is the average number of loans per physical item for physical items purchased in the past year with specific funds?
Which funds used to purchase items in the last year had the lowest rate of circulation for those items?
How much money was expended on items acquired in a given fiscal year that have not circulated within X number of years, with a breakdown by fund, call number, and location?

Attributes (grey fields) from all dimensions, including the Physical Item Details dimension can be used together with measures and attributes from the Fund Information dimension.
Do not use the measures (yellow fields) from the Physical Item Details dimension together with measures (yellow fields) or attributes (grey fields) from the Fund Information dimension. This produces incorrect results.
This dimension is only for expenditure type transactions.

The Fund Information dimension contains the following folders:

Fund Instructions (Tooltip) - A tooltip that explains how to use the Fund Information dimension

Fund Measures

Fund Measures
Field	Description	Additional Information
Fund Expenditure	When an item is retrieved, this is the amount that came out of the specific fund for the specific item. It is a transaction of type Expenditure.
Num of Items per Fund	When a specific fund is retrieved, this is the number of items ordered from that fund. (One item can be for multiple funds.)
Num of Loans per Fund (In House + Not in House)	When a specific fund is retrieved, this is the number of in house + not in house loans for items ordered from that fund. (Since one item can be for multiple funds, one loan can also be from multiple funds.)
Num of Loans per Fund (In House)	When a specific fund is retrieved, this is the number of in house loans for items ordered from that fund. (Since one item can be for multiple funds, one loan can also be from multiple funds.)
Num of Loans per Fund (Not in House)	When a specific fund is retrieved, this is the number of not in house loans for items ordered from that fund. (Since one item can be for multiple funds, one loan can also be from multiple funds.)
% from Funds	When a specific fund is retrieved, this is the percentage of the price of the item that came from that fund. If there is one fund, it will be 100%. If the item cost is 100 USD and fund A spent 30 USD on it and fund B spent 70 USD on it, the % from Funds is 30% for fund A and 70% for fund B.
Num of Requests (Booking)	The number of booking requests
Num of Requests (Digitization)	The number of digitization requests
Num of Requests (General Hold)	The number of general hold requests
Num of Requests (Physical Item)	The number of physical item requests
Num of Requests (Total)	The total number of requests

PO Line Type, Fund, Fund Fiscal Period - For more information, see the Funds Expenditure subject area.

Receiving Operator

The Receiving Operator table is a dimension table that stores details about the receiving operator.

Receiving Operator
Field	Description	Additional Information
Campus Code	The campus code of the receiving operator
External ID	The external ID of the receiving operator
First Name	The first name of the receiving operator
Gender	The gender of the receiving operator
IdP Service in Use	Indicates if an identity provider service is in use
Job Description	The job description of the receiving operator
Job Title	The job catagory of the receiving operator
Last Name	The last name of the receiving operator
Last Activity Date	The last date that a patron made a request or borrowed or returned an item
Middle Name	The middle name of the receiving operator
Preferred First Name	The preferred first name of the receiving operator
Preferred Last Name	The preferred last name of the receiving operator
Preferred Middle Name	The preferred middle name of the receiving operator
Primary Identifier	The primary identifier of the receiving operator
Status	The status of the user with the receiving operator role	Possible values are: Active Inactive Deleted
User Group	The user group of the receiving operator
User Record Type	The user record type of the receiving operator
User Type	The user type of the receiving operator

Institution

The shared Institution dimension allows the Network Zone to view reports according to institution. It is available in every subject area. It contains the following fields:

Institution
Field	Description	Additional information
Institution Code	The code of the institution.
Institution Name	The name of the institution.
Institution Timezone	The timezone of the institution
Data Available As Of	When the data became available to analytics
Data Updated As Of	When the data was taken from Alma

If an analytics report is run from the Network Zone in a collaborative network implementing a Network Zone, all member institutions are included in the report for Institution Code and Institution Name.

If an analytics report is run from an institution that is not part of a collaborative network implementing a Network Zone, only the single institution from which the report is run is included in the report for Institution Code and Institution Name.

Reports involving data across a collaborative network implementing a Network Zone may take longer to run than reports within one institution.

Shared Dimensions with Other Subject Areas

For information concerning shared dimensions with other subject areas, see Shared Dimensions.