Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Field nameDescriptionData type
HD Accession DateDate added to HD inventory. Format: MM/DD/YYYYDate
HD Active FlagY/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 ENDText
HD CollectionCollection codeText
HD Delete DateDate item withdrawn from HD. Format: MM/DD/YYYYDate
HD On ShelfY/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 CodeHD Owner codeText
HD Owner NameHD Owner nameText
HD Tray IDTray IdentifierText
ReCAP Accession DateDate added to ReCAP inventory. Format: MM/DD/YYYYDate
ReCAP Active FlagY/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 DateArrived at ReCAP. Format MM/DD/YYYYDate
ReCAP Delete DateDate item withdrawn from ReCAP. Format MM/DD/YYYY.Date
ReCAP On ShelfY/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 CodeOwner Code Text
ReCAP Owner NameOwner NameText
ReCAP Owner CollectionOwner Collection. ReCAP assigns codes that correspond to collections of materials in the owning library.Text
ReCAP Tray IDTray IdentifierText