OLE stores data relating to serials in two places:
* the Serials Receiving record, where new serial issues or volumes are received
* the OLE Holdings and E-holdings records in the OLE Docstore, where holdings statements are usually stored
Data for holdings and e-holdings records is loaded as part of the general Docstore data loading.
Serials receiving records can be created and populated with legacy data via the OLE user interface, by doing a Batch Process of the type "Serial Record Import". The import process asks for three files, to populate three tables in OLE:
1) Serial Receiving Record -- this table contains basic info for the Serials Receiving Record, and contains a linking ID for a Docstore holdings record
2) Serial Receiving Type -- this table contains the types of receipts allowed (such as main, supplement and index)
3) Serial Record History -- this table contains a row for each issue received
The files to be loaded can either be in either .csv or .xml format. The columns of the .csv files, or the elements of the XML file, must correspond exactly to the column structure of these tables:
For table ole_ser_rcv_rec:
| Column | Data Type | Comments |
|---|---|---|
| SER_RCV_REC_ID | varchar(40) | |
| FDOC_NBR | varchar(14) | |
| BIB_ID | varchar(40) | |
| RCV_REC_TYP | varchar(40) | |
| CLAIM | varchar(1) | |
| CLAIM_INTRVL_INFO | varchar(500) | |
| CREATE_ITEM | varchar(1) | |
| GEN_RCV_NOTE | varchar(500) | |
| INSTANCE_ID | varchar(40) | |
| PO_ID | varchar(50) | |
| PRINT_LBL | varchar(1) | |
| PUBLIC_DISPLAY | varchar(1) | |
| SER_RCPT_LOC | varchar(40) | |
| SER_RCV_REC | varchar(40) | |
| SUBSCR_STAT | varchar(40) | |
| TREATMENT_INSTR_NOTE | varchar(500) | |
| UNBOUND_LOC | varchar(100) | |
| URGENT_NOTE | varchar(500) | |
| VENDOR | varchar(30) | |
| CREATE_DATE | datetime | |
| OPTR_ID | varchar(40) | |
| MACH_ID | varchar(100) | |
| SUBSCR_STAT_DT | datetime | |
| OBJ_ID | varchar(36) | |
| VER_NBR | decimal(8,0) | |
| ACTIVE | varchar(1) |
For table ole_ser_rcv_rec_typ_t
| Column | Data Type | Comments |
|---|---|---|
| VER_NBR | decimal(8,0) | |
| SER_RCV_REC_TYP_ID | varchar(40) | |
| SER_RCV_REC_ID | varchar(40) | |
| RCV_REC_TYP | varchar(40) | |
| OBJ_ID | varchar(36) | |
| ENUM_CAPTN_LVL6 | varchar(50) | |
| ENUM_CAPTN_LVL5 | varchar(50) | |
| ENUM_CAPTN_LVL4 | varchar(50) | |
| ENUM_CAPTN_LVL3 | varchar(50) | |
| ENUM_CAPTN_LVL2 | varchar(50) | |
| ENUM_CAPTN_LVL1 | varchar(50) | |
| CHRON_CAPTN_LVL4 | varchar(50) | |
| CHRON_CAPTN_LVL3 | varchar(50) | |
| CHRON_CAPTN_LVL2 | varchar(50) | |
| CHRON_CAPTN_LVL1 | varchar(50) | |
| ACTN_INTRVL | varchar(40) | |
| ACTN_DATE | datetime |
For table ole_ser_rcv_rec_typ_t
| Column | Data Type | Comments |
|---|---|---|
| VER_NBR | decimal(8,0) | |
| STAFF_ONLY_RCPT | varchar(40) | |
| SER_RCV_REC_ID | varchar(40) | |
| SER_RCPT_NOTE | varchar(100) | |
| SER_RCPT_HIS_REC_ID | varchar(40) | |
| RCV_REC_TYP | varchar(40) | |
| RCPT_STAT | varchar(40) | |
| RCPT_DATE | datetime | |
| PUB_RCPT | varchar(40) | |
| PUB_DISPLAY | varchar(1) | |
| OPTR_ID | varchar(40) | |
| OBJ_ID | varchar(36) | |
| MACH_ID | varchar(100) | |
| ENUM_LVL_6 | varchar(50) | |
| ENUM_LVL_5 | varchar(50) | |
| ENUM_LVL_4 | varchar(50) | |
| ENUM_LVL_3 | varchar(50) | |
| ENUM_LVL_2 | varchar(50) | |
| ENUM_LVL_1 | varchar(50) | |
| CLAIM_TYPE | varchar(40) | |
| CLAIM_RESP | varchar(40) | |
| CLAIM_NOTE | varchar(100) | |
| CLAIM_DATE | datetime | |
| CLAIM_COUNT | varchar(50) | |
| CHRON_LVL_4 | varchar(50) | |
| CHRON_LVL_3 | varchar(50) | |
| CHRON_LVL_2 | varchar(50) | |
| CHRON_LVL_1 | varchar(50) |