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 |