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)