| 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 |
deleted inventory| . 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 |
ARRIVAL_DATE| Arrived at ReCAP. Format MM/DD/YYYY | Date |
| ReCAP Delete Date |
DELETE_DATE | 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 |
"LTS-LIBRARY"."".REPORTING."A1_LKUP_RECAP_OWNER (Alma Alone)".DESC2| Owner Collection. ReCAP assigns codes that correspond to collections of materials in the owning library. | Text |
| ReCAP Tray ID |
"LTS-LIBRARY"."".REPORTING."A1_RECAP_ITEM (Alma Alone)".TRAY_ID | ReCAP Update Date | "LTS-LIBRARY"."".REPORTING."A1_RECAP_ITEM (Alma Alone)".UPDATE_DATE