Alma Items - HD & ReCAP

Field name	Description	Data type
HD Accession Date	Date added to HD inventory. Format: MM/DD/YYYY	Date
HD Active Flag	Y/N field where Y is active and N is deleted. Formula: CASE WHEN Accession Date is not null and Delete Date is not null then 'N', ELSE IF Accession Date is not null and Delete Date is null then 'Y', ELSE IF Accession Date is null and Delete Date is null then null END END	Text
HD Collection	Collection code	Text
HD Delete Date	Date item withdrawn from HD. Format: MM/DD/YYYY	Date
HD On Shelf	Y/N field where Y indicates the item is on the shelf, and N indicates the item has been retrieved. Formula: CASE WHEN Delete Date is null and Number of Retrievals = 0 THEN 'Y' ELSE CASE WHEN Delete Date is not null then 'N' ELSE CASE WHEN Last Refi Date is null THEN 'N' ELSE 'Y' END END END	Text
HD Owner Code	HD Owner code	Text
HD Owner Name	HD Owner name	Text
HD Tray ID	Tray Identifier	Text
ReCAP Accession Date	Date added to ReCAP inventory. Format: MM/DD/YYYY	Date
ReCAP Active Flag	Y/N field where Y is active and N is deleted. Formula: CASE WHEN Accession Date is not null and Delete Date is not null then 'N', ELSE IF Accession Date is not null and Delete Date is null then 'Y', ELSE IF Accession Date is null and Delete Date is null then null END END	Text
ReCAP Arrival Date	Arrived at ReCAP. Format MM/DD/YYYY	Date
ReCAP Delete Date	Date item withdrawn from ReCAP. Format MM/DD/YYYY.	Date
ReCAP On Shelf	Y/N field where Y indicates the item is on the shelf, and N indicates the item has been retrieved. Formula: CASE WHEN Delete Date is null and Number of Retrievals = 0 THEN 'Y' ELSE CASE WHEN Delete Date is not null then 'N' ELSE CASE WHEN Last Refi Date is null THEN 'N' ELSE 'Y' END END END	Text
ReCAP Owner Code	Owner Code	Text
ReCAP Owner Name	Owner Name	Text
ReCAP Owner Collection	Owner Collection. ReCAP assigns codes that correspond to collections of materials in the owning library.	Text
ReCAP Tray ID	Tray Identifier	Text