| 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 | ||
| 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 | ||
| 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 |
Manage space
Manage content
Integrations