...
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) |
...