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