c_transfer_history
19,325 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), received_date (date)
| c_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-CA-27321-001 | 1999-08-06 10:11:00 | 0 | |||||||||
| 01-CA-27879-001 | 1999-11-30 08:00:00 | 0 | |||||||||
| 01-CA-30745-001 | 2004-11-04 14:40:00 | 0 | |||||||||
| 01-CA-36746-001 | 1999-05-25 15:15:00 | 0 | |||||||||
| 01-CA-36965-001 | 1999-12-14 16:16:00 | 0 | |||||||||
| 01-CA-37108-001 | 1999-04-21 16:25:00 | 0 | |||||||||
| 01-CA-37458-001 | 2001-04-05 09:52:00 | 0 | |||||||||
| 01-CA-37495-001 | 1999-10-18 16:03:00 | 0 | |||||||||
| 01-CA-37595-001 | 2000-01-10 12:20:00 | 0 | |||||||||
| 01-CA-37612-001 | 1999-09-27 15:10:00 | 0 | |||||||||
| 01-CA-38184-001 | 2000-05-30 13:01:00 | 0 | |||||||||
| 01-CA-38460-001 | 2000-11-20 14:33:00 | 0 | |||||||||
| 01-CA-39040-001 | 2001-05-02 14:53:00 | 0 | 2001-05-02 16:15:00 | 2001-05-01 00:00:00 | Other | Perm | 2001-05-02 | 01-CA-39040-001 | 34-CA-09672-001 | 2001-05-02 | |
| 01-CA-39040-001 | 2001-05-02 16:04:00 | 1 | |||||||||
| 01-CA-39082-001 | 2001-05-22 15:46:00 | 0 | 2001-05-22 17:30:00 | 2001-05-15 00:00:00 | Other | Perm | 2001-05-22 | 01-CA-39082-001 | 34-CA-09687-001 | 2001-05-22 | |
| 01-CA-39082-001 | 2001-05-22 17:11:00 | 1 | 2001-05-23 | ||||||||
| 01-CA-39180-001 | 2001-07-06 15:04:00 | 0 | 2001-07-06 17:00:00 | 2001-07-05 00:00:00 | Other | Perm | 2001-07-06 | 01-CA-39180-001 | 34-CA-09719-001 | 2001-07-06 | |
| 01-CA-39180-001 | 2001-07-06 16:52:00 | 1 | |||||||||
| 01-CA-39195-001 | 2004-02-02 08:38:00 | 0 | |||||||||
| 01-CA-39471-001 | 2005-05-05 11:42:00 | 0 | |||||||||
| 01-CA-39516-001 | 2001-12-07 13:20:00 | 0 | 2001-12-07 16:15:00 | 2001-11-29 00:00:00 | Other | Perm | 2001-12-07 | 01-CA-39516-001 | 05-CA-28886-001 | ||
| 01-CA-39516-001 | 2001-12-07 16:08:00 | 1 | 2001-12-07 | ||||||||
| 01-CA-39517-001 | 2001-12-07 16:08:00 | 0 | 2001-12-07 16:15:00 | 2001-11-29 00:00:00 | Other | Perm | 2001-12-07 | 01-CA-39517-001 | 05-CA-28958-001 | ||
| 01-CA-39517-001 | 2001-12-07 16:10:00 | 1 | |||||||||
| 01-CA-39646-001 | 2002-02-25 16:17:00 | 0 | |||||||||
| 01-CA-40505-001 | 2005-08-11 11:13:00 | 0 | |||||||||
| 01-CA-40690-001 | 2003-08-27 13:51:00 | 0 | |||||||||
| 01-CA-41061-001 | 2005-08-22 08:36:00 | 0 | |||||||||
| 01-CA-41110-001 | 2004-09-30 16:47:00 | 0 | |||||||||
| 01-CA-41132-001 | 2003-08-01 10:46:00 | 0 | 2003-08-01 11:00:00 | 2003-07-31 00:00:00 | Other | Perm | 2003-07-31 | 01-CA-41132-001 | 34-CA-10557-001 | 2003-07-31 | |
| 01-CA-41132-001 | 2003-08-01 10:51:00 | 1 | 2003-08-06 | ||||||||
| 01-CA-41199-001 | 2004-02-24 14:12:00 | 0 | |||||||||
| 01-CA-41207-001 | 2005-08-22 09:26:00 | 0 | |||||||||
| 01-CA-41272-001 | 2003-10-01 10:05:00 | 0 | 2003-10-01 14:30:00 | 2003-10-01 00:00:00 | Other | Perm | 2003-10-01 | 01-CA-41272-001 | 03-CA-24464-001 | 2003-10-01 | |
| 01-CA-41272-001 | 2003-10-01 14:15:00 | 1 | |||||||||
| 01-CA-41768-001 | 2010-05-11 12:44:00 | 0 | |||||||||
| 01-CA-42005-001 | 2004-08-18 09:08:00 | 0 | 2004-08-18 09:15:00 | 2004-08-18 00:00:00 | Geogr | Perm | 2004-08-18 | 01-CA-42005-001 | 04-CA-33191-001 | ||
| 01-CA-42005-001 | 2004-08-18 09:10:00 | 1 | 2004-11-18 14:45:00 | 2004-11-12 00:00:00 | Other | IAP | 2004-11-15 | 04-CA-33191-001 | 01-CA-42005-001 | 2004-11-18 | 2004-08-18 |
| 01-CA-42005-001 | 2004-11-18 14:31:00 | 2 | 2004-11-18 15:00:00 | 2004-11-12 00:00:00 | NeedA | IAP | 2004-11-15 | 01-CA-42005-001 | 04-CA-33191-001 | ||
| 01-CA-42005-001 | 2004-11-18 14:52:00 | 3 | |||||||||
| 01-CA-42013-001 | 2005-02-18 12:00:00 | 0 | |||||||||
| 01-CA-42161-001 | 2005-03-14 14:33:00 | 0 | |||||||||
| 01-CA-42167-001 | 2004-11-03 11:30:00 | 0 | |||||||||
| 01-CA-42296-001 | 2005-03-07 13:42:00 | 0 | |||||||||
| 01-CA-42299-001 | 2005-09-28 15:42:00 | 0 | |||||||||
| 01-CA-42420-001 | 2005-10-24 12:05:00 | 0 | |||||||||
| 01-CA-42639-001 | 2005-10-05 12:39:00 | 0 | |||||||||
| 01-CA-42984-001 | 2006-03-06 15:54:00 | 0 | |||||||||
| 01-CA-43007-001 | 2006-02-07 16:13:00 | 0 | |||||||||
| 01-CA-43077-001 | 2006-03-13 16:33:00 | 0 | |||||||||
| 01-CA-43100-001 | 2007-06-12 11:12:00 | 0 | |||||||||
| 01-CA-43542-001 | 2007-06-22 10:35:00 | 0 | |||||||||
| 01-CA-44021-001 | 2007-07-11 09:11:00 | 0 | 2007-07-11 09:30:00 | 2007-07-03 00:00:00 | NeedA | IAP | 2007-07-03 | 29-CA-28370-001 | 01-CA-44021-001 | ||
| 01-CA-44021-001 | 2007-07-11 09:17:00 | 1 | 2007-07-30 15:00:00 | 2007-07-25 00:00:00 | NeedA | Perm | 2007-07-30 | 01-CA-44021-001 | 29-CA-28370-001 | 2007-07-30 | |
| 01-CA-44021-001 | 2007-07-30 14:46:00 | 2 | |||||||||
| 01-CA-44022-001 | 2007-07-11 10:12:00 | 0 | 2007-07-11 10:30:00 | 2007-07-03 00:00:00 | NeedA | IAP | 2007-07-03 | 29-CA-28371-001 | 01-CA-44022-001 | ||
| 01-CA-44022-001 | 2007-07-11 10:18:00 | 1 | 2007-07-30 15:15:00 | 2007-07-30 00:00:00 | NeedA | Perm | 2007-07-30 | 01-CA-44022-001 | 29-CA-28371-001 | ||
| 01-CA-44022-001 | 2007-07-30 15:04:00 | 2 | |||||||||
| 01-CA-44034-001 | 2007-07-19 12:14:00 | 0 | |||||||||
| 01-CA-44159-001 | 2007-09-20 11:08:00 | 0 | |||||||||
| 01-CA-44262-001 | 2007-10-22 16:51:00 | 0 | 2007-10-23 09:45:00 | 2007-10-23 00:00:00 | NeedA | IAP | 2007-10-23 | 01-CA-44262-001 | 34-CA-11873-001 | 2007-10-23 | |
| 01-CA-44262-001 | 2007-10-23 09:44:00 | 1 | 2007-11-16 | ||||||||
| 01-CA-44402-001 | 2008-01-30 10:28:00 | 0 | |||||||||
| 01-CA-44521-001 | 2009-12-03 11:30:00 | 0 | |||||||||
| 01-CA-44616-001 | 2008-06-11 09:46:00 | 0 | 2008-06-11 14:05:00 | 2008-05-01 00:00:00 | NeedA | IAP | 2008-06-11 | 03-CA-26721-001 | 01-CA-44616-001 | 2008-06-11 | |
| 01-CA-44616-001 | 2008-06-11 14:04:00 | 1 | 2009-03-24 12:30:00 | 2009-03-24 00:00:00 | Other | IAP | 2009-03-25 | 01-CA-44616-001 | 03-CA-26721-001 | 2009-03-24 | 2008-06-18 |
| 01-CA-44616-001 | 2009-03-24 12:24:00 | 2 | |||||||||
| 01-CA-45278-001 | 2009-05-20 11:21:00 | 0 | |||||||||
| 01-CA-45314-001 | 2009-05-07 12:27:00 | 0 | 2009-05-07 12:45:00 | 2009-05-07 00:00:00 | Conso | Perm | 2009-05-07 | 12-CA-26334-001 | 01-CA-45314-001 | ||
| 01-CA-45314-001 | 2009-05-07 12:29:00 | 1 | 2009-07-16 09:15:00 | 2009-06-29 00:00:00 | Other | IAP | 2009-06-29 | 01-CA-45314-001 | 12-CA-26334-001 | 2009-07-17 | |
| 01-CA-45314-001 | 2009-07-16 09:08:00 | 2 | 2009-07-17 | 2009-07-20 | |||||||
| 01-CA-45397-001 | 2009-09-29 15:48:00 | 0 | |||||||||
| 01-CA-45489-001 | 2010-03-12 10:40:00 | 0 | |||||||||
| 01-CA-45885-001 | 2010-01-08 11:15:00 | 0 | |||||||||
| 01-CA-46277-001 | 2011-01-14 15:10:00 | 0 | |||||||||
| 01-CA-46324-001 | 2011-01-14 14:57:00 | 0 | |||||||||
| 01-CA-46759-001 | 2011-06-06 15:54:00 | 0 | |||||||||
| 01-CA-46761-001 | 2011-05-05 10:39:00 | 0 | |||||||||
| 01-CB-09496-001 | 2000-01-10 12:02:00 | 0 | Other | IAP | 24-CB-02003-001 | ||||||
| 01-CB-10161-001 | 2003-08-01 11:00:00 | 0 | 2003-08-01 11:15:00 | 2003-07-31 00:00:00 | Other | Perm | 2003-07-31 | 01-CB-10161-001 | 34-CB-02658-001 | 2003-07-31 | |
| 01-CB-10161-001 | 2003-08-01 11:01:00 | 1 | 2003-08-06 | ||||||||
| 01-CB-10392-001 | 2005-01-25 14:13:00 | 0 | 2005-01-25 14:30:00 | 2005-01-24 00:00:00 | Other | Perm | 2005-01-24 | 34-CB-02819-001 | 01-CB-10392-001 | 2005-01-25 | |
| 01-CB-10392-001 | 2005-01-25 14:21:00 | 1 | 2005-04-20 12:00:00 | 2005-03-31 00:00:00 | Other | IAP | 2005-04-01 | 01-CB-10392-001 | 34-CB-02819-001 | 2005-04-20 | |
| 01-CB-10392-001 | 2005-04-20 11:55:00 | 2 | 2005-04-22 | ||||||||
| 01-CB-10761-001 | 2007-06-12 16:27:00 | 0 | 2007-06-12 16:45:00 | 2007-06-12 00:00:00 | NeedA | IAP | 2007-06-12 | 29-CB-13440-001 | 01-CB-10761-001 | ||
| 01-CB-10761-001 | 2007-06-12 16:33:00 | 1 | 2007-09-19 10:30:00 | 2007-08-24 00:00:00 | NeedA | IAP | 2007-08-27 | 01-CB-10761-001 | 29-CB-13440-001 | 2007-08-27 | |
| 01-CB-10761-001 | 2007-09-19 10:26:00 | 2 | 2007-09-21 | ||||||||
| 01-CB-11084-001 | 2011-01-20 11:40:00 | 0 | |||||||||
| 01-CB-11275-001 | 2011-01-14 08:49:00 | 0 | |||||||||
| 01-CC-02777-001 | 2005-06-03 09:10:00 | 0 | |||||||||
| 02-CA-24304-001 | 2000-02-07 16:22:00 | 0 | |||||||||
| 02-CA-25386-001 | 2004-04-06 17:18:00 | 0 | |||||||||
| 02-CA-25984-001 | 1999-07-23 13:53:00 | 0 | |||||||||
| 02-CA-28427-001 | 2006-12-21 14:58:00 | 0 | |||||||||
| 02-CA-28505-001 | 2003-05-15 16:40:00 | 0 | |||||||||
| 02-CA-29835-001 | 2007-02-15 12:52:00 | 0 | |||||||||
| 02-CA-29877-001 | 2001-08-29 10:07:00 | 0 | |||||||||
| 02-CA-31014-001 | 2007-02-15 13:34:00 | 0 | |||||||||
| 02-CA-31312-001 | 2007-02-15 13:43:00 | 0 | |||||||||
| 02-CA-31323-001 | 2001-05-25 12:18:00 | 0 |
Table schema
CREATE TABLE c_transfer_history(c_case_number VARCHAR, history_date TIMESTAMP, "sequence" BIGINT, date_data_received TIMESTAMP, request_date TIMESTAMP, reason_transfer VARCHAR, transfer_type VARCHAR, transfer_order_date DATE, new_case_number VARCHAR, former_case_number VARCHAR, sent_date DATE, received_date DATE);