...
| 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 withdrawn from HD inventory. Format: MM/DD/YYYY | Date | ||
| 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 DateARRIVAL_DATE | Arrived at ReCAP. Format MM/DD/YYYY | Date | ||
| ReCAP Delete DateDELETE_DATE | Date item withdrawn from ReCAP. Format MM/DD/YYYY. | Date | ||
| ReCAP Owner Code | Owner Code | Text | ||
| ReCAP Owner Name | Owner Name | Text | ||
| ReCAP Owner Collection" | LTS-LIBRARY"."".REPORTING."A1_LKUP_RECAP_OWNER (Alma Alone)".DESC2Owner 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_DATETray Identifier | Text |