...
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:
...
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 oletable ole_ser_rcv_his_rec_typ_t
| 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) |
...