r_transfer_history
1,350 rows
Suggested facets: sequence, reason_transfer, transfer_type, history_date (date), date_data_received (date), request_date (date), transfer_order_date (date), sent_date (date)
| r_case_number | history_date | sequence | date_data_received | request_date | reason_transfer | transfer_type | transfer_order_date | new_case_number | former_case_number | sent_date | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-RC-20984 | 2003-06-09 10:59:00 | 0 | |||||||||
| 01-RC-21173 | 2000-05-01 13:53:00 | 0 | |||||||||
| 01-RC-21266 | 2000-11-17 15:22:00 | 0 | |||||||||
| 01-RC-21558 | 2003-02-03 14:49:00 | 0 | |||||||||
| 01-RC-21951 | 2005-09-19 10:42:00 | 0 | |||||||||
| 01-RC-22087 | 2007-03-26 15:54:00 | 0 | |||||||||
| 01-RC-22375 | 2010-01-22 08:39:00 | 0 | |||||||||
| 01-RC-22427 | 2010-03-09 10:36:00 | 0 | |||||||||
| 01-RC-22456 | 2010-05-10 09:41:00 | 0 | |||||||||
| 01-RD-02111 | 2010-08-18 14:31:00 | 0 | |||||||||
| 01-UC-00761 | 2000-12-12 15:28:00 | 0 | |||||||||
| 02-RC-21706 | 2002-08-08 13:26:00 | 0 | 2002-09-05 11:30:00 | 2002-09-05 | Other | Perm | 2002-09-05 | 02-RC-21706 | 26-RC-08187 | ||
| 02-RC-21706 | 2002-09-05 10:28:00 | 1 | |||||||||
| 02-RC-22092 | 2002-02-06 12:49:00 | 0 | |||||||||
| 02-RC-22120 | 2001-06-01 11:17:00 | 0 | |||||||||
| 02-RC-22217 | 2000-09-28 15:17:00 | 0 | |||||||||
| 02-RC-22295 | 2006-10-24 13:20:00 | 0 | |||||||||
| 02-RC-22327 | 2001-08-15 17:16:00 | 0 | 2002-03-20 11:30:00 | 2001-08-24 | Other | Perm | 2001-08-24 | 26-RC-08277 | 02-RC-22327 | ||
| 02-RC-22327 | 2002-03-20 11:29:00 | 1 | 2002-04-16 14:15:00 | 2001-11-09 | Other | Perm | 2001-11-09 | 02-RC-22327 | 26-RC-08277 | 2001-11-09 | |
| 02-RC-22327 | 2002-04-16 13:16:00 | 2 | |||||||||
| 02-RC-22355 | 2006-06-12 15:32:00 | 0 | |||||||||
| 02-RC-22396 | 2001-05-23 11:48:00 | 0 | |||||||||
| 02-RC-22401 | 2005-10-28 16:53:00 | 0 | |||||||||
| 02-RC-22490 | 2006-10-24 14:25:00 | 0 | |||||||||
| 02-RC-22498 | 2007-03-09 11:04:00 | 0 | |||||||||
| 02-RC-22516 | 2006-10-24 15:57:00 | 0 | |||||||||
| 02-RC-22521 | 2006-10-24 16:01:00 | 0 | |||||||||
| 02-RC-22537 | 2003-07-07 11:14:00 | 0 | |||||||||
| 02-RC-22603 | 2006-10-25 12:52:00 | 0 | |||||||||
| 02-RC-22644 | 2006-10-25 13:14:00 | 0 | |||||||||
| 02-RC-22675 | 2006-10-25 14:51:00 | 0 | |||||||||
| 02-RC-22679 | 2006-10-25 14:53:00 | 0 | |||||||||
| 02-RC-22712 | 2004-02-04 16:25:00 | 0 | |||||||||
| 02-RC-22714 | 2006-10-25 16:03:00 | 0 | |||||||||
| 02-RC-22737 | 2003-07-07 11:14:00 | 0 | 2003-07-08 11:45:00 | 2003-07-03 | Geogr | Perm | 2003-07-03 | 02-RC-22737 | 22-RC-12359 | ||
| 02-RC-22737 | 2003-07-08 11:44:00 | 1 | 2003-07-08 12:30:00 | 2003-07-08 | NeedA | Other | 2003-07-08 | 22-RC-12359 | 02-RC-22737 | ||
| 02-RC-22737 | 2003-07-08 12:29:00 | 2 | 2003-07-08 12:45:00 | 2003-07-03 | Geogr | Perm | 2003-07-08 | 02-RC-22737 | 22-RC-12359 | 2003-07-03 | |
| 02-RC-22737 | 2003-07-08 12:42:00 | 3 | |||||||||
| 02-RC-22770 | 2006-10-27 15:33:00 | 0 | |||||||||
| 02-RC-22874 | 2007-12-04 17:37:00 | 0 | |||||||||
| 02-RC-23030 | 2007-07-11 16:03:00 | 0 | |||||||||
| 02-RC-23146 | 2006-09-27 13:54:00 | 0 | |||||||||
| 02-RC-23213 | 2007-10-11 14:27:00 | 0 | |||||||||
| 02-RC-23219 | 2007-10-10 11:06:00 | 0 | |||||||||
| 02-RC-23529 | 2010-09-30 09:06:00 | 0 | |||||||||
| 02-RC-23572 | 2011-02-07 09:30:00 | 0 | |||||||||
| 02-RC-23591 | 2011-04-14 16:34:00 | 0 | |||||||||
| 02-RC-23604 | 2011-05-11 10:00:00 | 0 | 2011-05-11 10:15:00 | 2011-05-11 | Geogr | Perm | 2011-05-11 | 02-RC-23604 | 29-RC-12052 | 2011-05-11 | |
| 02-RC-23604 | 2011-05-11 10:12:00 | 1 | |||||||||
| 02-RD-01474 | 2003-04-09 16:24:00 | 0 | |||||||||
| 02-RD-01477 | 2006-10-25 13:52:00 | 0 | |||||||||
| 02-RD-01558 | 2007-11-19 13:30:00 | 0 | |||||||||
| 02-RD-01581 | 2009-12-03 16:18:00 | 0 | |||||||||
| 02-RM-02113 | 2008-08-06 14:26:00 | 0 | |||||||||
| 02-UC-00545 | 2001-11-08 17:11:00 | 0 | 2001-11-08 17:30:00 | 2001-11-08 | NeedA | Temp | 2001-11-08 | 26-UC-00191 | 02-UC-00545 | 2001-11-05 | |
| 02-UC-00545 | 2001-11-08 17:24:00 | 1 | 2002-03-15 15:00:00 | 2002-03-15 | Other | Other | 2002-03-15 | 02-UC-00545 | 26-UC-00191 | 2002-03-15 | |
| 02-UC-00545 | 2002-03-15 13:52:00 | 2 | |||||||||
| 02-UC-00561 | 2001-11-20 10:01:00 | 0 | |||||||||
| 02-UC-00597 | 2007-08-06 08:54:00 | 0 | 2007-08-06 15:00:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00597 | 29-UC-00537 | 2007-08-06 | |
| 02-UC-00597 | 2007-08-06 14:53:00 | 1 | |||||||||
| 02-UC-00598 | 2007-08-06 14:55:00 | 0 | 2007-08-06 15:15:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00598 | 29-UC-00538 | 2007-08-06 | |
| 02-UC-00598 | 2007-08-06 15:01:00 | 1 | |||||||||
| 02-UC-00599 | 2007-08-06 15:05:00 | 0 | 2007-08-06 15:15:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00599 | 29-UC-00539 | 2007-08-06 | |
| 02-UC-00599 | 2007-08-06 15:12:00 | 1 | |||||||||
| 02-UC-00600 | 2007-08-06 15:13:00 | 0 | 2007-08-06 15:30:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00600 | 29-UC-00540 | 2007-08-06 | |
| 02-UC-00600 | 2007-08-06 15:19:00 | 1 | |||||||||
| 02-UC-00601 | 2007-08-06 15:37:00 | 0 | 2007-08-06 15:45:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00601 | 29-UC-00541 | 2007-08-06 | |
| 02-UC-00601 | 2007-08-06 15:41:00 | 1 | |||||||||
| 02-UC-00602 | 2007-08-06 15:43:00 | 0 | 2007-08-06 16:00:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00602 | 29-UC-00542 | 2007-08-06 | |
| 02-UC-00602 | 2007-08-06 15:47:00 | 1 | |||||||||
| 02-UC-00603 | 2007-08-06 15:49:00 | 0 | 2007-08-06 16:00:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00603 | 29-UC-00543 | 2007-08-06 | |
| 02-UC-00603 | 2007-08-06 15:52:00 | 1 | |||||||||
| 02-UC-00604 | 2007-08-06 15:53:00 | 0 | 2007-08-06 16:00:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00604 | 29-UC-00544 | 2007-08-06 | |
| 02-UC-00604 | 2007-08-06 15:58:00 | 1 | |||||||||
| 02-UC-00605 | 2007-08-08 13:46:00 | 0 | 2007-08-08 14:15:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00605 | 29-UC-00545 | 2007-08-06 | |
| 02-UC-00605 | 2007-08-08 14:03:00 | 1 | |||||||||
| 02-UC-00606 | 2007-08-08 14:05:00 | 0 | 2007-08-08 14:15:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00606 | 29-UC-00546 | 2007-08-06 | |
| 02-UC-00606 | 2007-08-08 14:09:00 | 1 | |||||||||
| 02-UC-00607 | 2007-08-08 14:18:00 | 0 | 2007-08-08 14:30:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00607 | 29-UC-00547 | 2007-08-06 | |
| 02-UC-00607 | 2007-08-08 14:24:00 | 1 | |||||||||
| 02-UC-00608 | 2007-08-08 14:25:00 | 0 | 2007-08-08 14:45:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00608 | 29-UC-00548 | 2007-08-06 | |
| 02-UC-00608 | 2007-08-08 14:38:00 | 1 | |||||||||
| 02-UC-00609 | 2007-08-08 14:41:00 | 0 | 2007-08-08 15:00:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00609 | 29-UC-00549 | 2007-08-06 | |
| 02-UC-00609 | 2007-08-08 14:45:00 | 1 | |||||||||
| 02-UC-00610 | 2007-08-08 14:48:00 | 0 | 2007-08-08 15:00:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00610 | 29-UC-00550 | 2007-08-06 | |
| 02-UC-00610 | 2007-08-08 14:52:00 | 1 | |||||||||
| 02-UC-00611 | 2007-08-08 14:53:00 | 0 | 2007-08-08 15:00:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00611 | 29-UC-00551 | 2007-08-06 | |
| 02-UC-00611 | 2007-08-08 14:57:00 | 1 | |||||||||
| 02-UC-00612 | 2007-08-08 14:59:00 | 0 | 2007-08-08 15:15:00 | 2007-08-03 | Geogr | Perm | 2007-08-06 | 02-UC-00612 | 29-UC-00552 | 2007-08-06 | |
| 02-UC-00612 | 2007-08-08 15:05:00 | 1 | |||||||||
| 02-UD-00343 | 2005-10-28 16:05:00 | 0 | |||||||||
| 02-UD-00366 | 2008-03-10 07:17:00 | 0 | |||||||||
| 03-AC-00042 | 2000-08-22 10:34:00 | 0 | |||||||||
| 03-RC-10806 | 2008-08-22 15:25:00 | 0 | |||||||||
| 03-RC-10941 | 2003-09-23 15:12:00 | 0 | |||||||||
| 03-RC-10971 | 2001-01-09 10:37:00 | 0 | |||||||||
| 03-RC-10982 | 2000-07-18 15:03:00 | 0 | |||||||||
| 03-RC-11217 | 2006-08-21 15:50:00 | 0 | |||||||||
| 03-RC-11267 | 2002-10-01 10:37:00 | 0 | 2002-11-22 12:00:00 | 2002-11-15 | Other | Temp | 2002-11-15 | 04-RC-20580 | 03-RC-11267 | ||
| 03-RC-11267 | 2002-11-22 11:51:00 | 1 | 2003-01-02 13:45:00 | 2002-12-17 | NeedA | Perm | 2002-12-17 | 03-RC-11267 | 04-RC-20580 |
Table schema
CREATE TABLE r_transfer_history(r_case_number VARCHAR, history_date TIMESTAMP, "sequence" BIGINT, date_data_received TIMESTAMP, request_date DATE, reason_transfer VARCHAR, transfer_type VARCHAR, transfer_order_date DATE, new_case_number VARCHAR, former_case_number VARCHAR, sent_date DATE, received_date VARCHAR);