Load serials holdings
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:
Note: If you use .csv files, and your incoming data contains commas, you may want to use another character as the field delimiter. You can specify what character you're using in the SERIAL_RECEIVING_LOADER_DELIMETER (sic) parameter.
Â
For table ole_ser_rcv_rec:
Column | Data Type | Comments |
---|---|---|
SER_RCV_REC_ID | varchar(40) | Primary Key |
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) | Not Null |
VER_NBR | decimal(8,0) | Not Null |
ACTIVE | varchar(1) | Â |
Â
For table ole_ser_rcv_rec_typ_t
Column | Data Type | Comments |
---|---|---|
VER_NBR | decimal(8,0) | Not Null |
SER_RCV_REC_TYP_ID | varchar(40) | Primary Key |
SER_RCV_REC_ID | varchar(40) | Foreign Key. Reference table - ole_ser_rcv_rec |
RCV_REC_TYP | varchar(40) | Â |
OBJ_ID | varchar(36) | Not Null |
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_his_rec
Column | Data Type | Comments |
---|---|---|
VER_NBR | decimal(8,0) | Not Null |
STAFF_ONLY_RCPT | varchar(40) | Â |
SER_RCV_REC_ID | varchar(40) | Foreign Key. Reference table - ole_ser_rcv_rec |
SER_RCPT_NOTE | varchar(100) | Â |
SER_RCPT_HIS_REC_ID | varchar(40) | Primary Key |
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) | Not Null |
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) | Â |
Â
Â
Operated as a Community Resource by the Open Library Foundation