| 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 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 Date | ARRIVAL_DATE | Date |
| ReCAP Delete Date | DELETE_DATE | Date |
| ReCAP Owner Code | Owner Code | Text |
| ReCAP Owner Name | Owner Name | |
| ReCAP Owner Collection | "LTS-LIBRARY"."".REPORTING."A1_LKUP_RECAP_OWNER (Alma Alone)".DESC2 | |
| 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 |
Manage space
Manage content
Integrations