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