c_settlement
29,253 rows
Suggested facets: action_sequence, inf_settle_participation, inf_settle_scope, fs_settlement_sent_ops, fs_determination_date, determination_rcvd_reg, proposal_letter_sent_date (date), proposed_approval__date (date), inf_settle_approved (date), inf_settle_revoked (date), fs_settlement_sent_ops (date), fs_determination_date (date), determination_rcvd_reg (date)
| c_case_number | action_sequence | recurrence | proposal_letter_sent_date | proposed_approval__date | inf_settle_approved | inf_settle_participation | inf_settle_scope | inf_settle_revoked | fs_settlement_sent_ops | fs_submitted_to | formal_scope | fs_board_determination | fs_determination_date | determination_rcvd_reg | formal_participation |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-CA-19958-001 | 0 | 0 | 1983-02-18 | 1983-02-25 | 1983-03-21 | Unil | Full | ||||||||
| 01-CA-21943-001 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-22040-002 | 1 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-22769-001 | 0 | 0 | 1986-10-29 | Bilat | Full | ||||||||||
| 01-CA-23307-001 | 1 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-23748-001 | 1 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-24161-001 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-24390-002 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-24528-001 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-24863-001 | 0 | 0 | 1988-08-16 | Bilat | Full | ||||||||||
| 01-CA-24883-001 | 0 | 0 | 1988-08-16 | Bilat | Full | ||||||||||
| 01-CA-24921-001 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-24967-001 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-25033-001 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-25237-001 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-25237-002 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-25341-001 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-25867-001 | 0 | 0 | 2001-05-08 | Bilat | Full | ||||||||||
| 01-CA-26098-001 | 0 | 0 | 1989-05-11 | 1989-05-18 | 1989-05-19 | Unil | Full | ||||||||
| 01-CA-26232-001 | 0 | 0 | 1992-01-09 | Bilat | Full | ||||||||||
| 01-CA-26237-001 | 0 | 0 | 1992-01-09 | Bilat | Full | ||||||||||
| 01-CA-27197-001 | 0 | 0 | 1990-06-28 | Bilat | Full | ||||||||||
| 01-CA-27335-001 | 0 | 0 | 1993-03-29 | Bilat | Full | ||||||||||
| 01-CA-27356-001 | 0 | 0 | 1990-11-26 | Bilat | Full | ||||||||||
| 01-CA-27417-001 | 0 | 0 | 1990-11-26 | Bilat | Full | ||||||||||
| 01-CA-27421-001 | 0 | 0 | 1991-11-19 | 1991-11-26 | 1991-11-27 | Unil | Full | ||||||||
| 01-CA-27491-001 | 0 | 0 | 1991-11-12 | Bilat | Full | ||||||||||
| 01-CA-27659-001 | 0 | 0 | 1991-11-12 | Bilat | Full | ||||||||||
| 01-CA-27732-001 | 0 | 0 | 1991-11-12 | Bilat | Full | ||||||||||
| 01-CA-27732-002 | 0 | 0 | 1991-11-12 | Bilat | Full | ||||||||||
| 01-CA-27766-001 | 0 | 0 | 1991-11-13 | 1991-11-20 | 1991-12-19 | Unil | Full | ||||||||
| 01-CA-27937-001 | 0 | 0 | 1991-11-19 | 1991-11-26 | 1991-11-27 | Unil | Full | ||||||||
| 01-CA-28064-001 | 0 | 0 | 1991-11-19 | Bilat | Full | ||||||||||
| 01-CA-28297-001 | 0 | 0 | 1995-04-07 | Unil | Full | ||||||||||
| 01-CA-28298-001 | 0 | 0 | 1995-04-07 | Unil | Full | ||||||||||
| 01-CA-28348-001 | 0 | 0 | 1993-02-19 | Bilat | Full | ||||||||||
| 01-CA-28375-001 | 0 | 0 | 1991-12-11 | Bilat | Full | ||||||||||
| 01-CA-28376-001 | 0 | 0 | 1992-08-28 | Bilat | Full | ||||||||||
| 01-CA-28466-001 | 0 | 0 | 1993-05-19 | Bilat | Full | ||||||||||
| 01-CA-28481-001 | 0 | 0 | 1992-08-28 | Bilat | Full | ||||||||||
| 01-CA-28493-001 | 0 | 0 | 1991-11-19 | Bilat | Full | ||||||||||
| 01-CA-28518-001 | 0 | 0 | 1993-06-08 | 1993-06-17 | Unil | Full | |||||||||
| 01-CA-28558-001 | 0 | 0 | 1993-08-12 | Bilat | Full | ||||||||||
| 01-CA-28617-001 | 0 | 0 | 1992-08-28 | Bilat | Full | ||||||||||
| 01-CA-28767-001 | 0 | 0 | 1993-02-19 | Bilat | Full | ||||||||||
| 01-CA-28818-001 | 0 | 0 | 1993-02-19 | Bilat | Full | ||||||||||
| 01-CA-28892-001 | 0 | 0 | 1992-01-07 | Bilat | Full | ||||||||||
| 01-CA-29137-001 | 0 | 0 | 1993-08-12 | Bilat | Full | ||||||||||
| 01-CA-29145-001 | 0 | 0 | 1993-08-12 | Bilat | Full | ||||||||||
| 01-CA-29179-001 | 0 | 0 | 1993-03-17 | 1993-03-31 | |||||||||||
| 01-CA-29179-001 | 1 | 0 | 1993-05-12 | 1993-05-26 | 1993-05-28 | Unil | Part | ||||||||
| 01-CA-29217-001 | 0 | 0 | 1993-04-15 | Bilat | Full | ||||||||||
| 01-CA-29500-001 | 0 | 0 | 1993-08-05 | Bilat | Full | ||||||||||
| 01-CA-29550-001 | 0 | 0 | 1992-09-23 | Bilat | Full | ||||||||||
| 01-CA-29582-001 | 0 | 0 | 1993-08-12 | Bilat | Full | ||||||||||
| 01-CA-29602-001 | 0 | 0 | 1993-05-13 | Bilat | Full | ||||||||||
| 01-CA-29631-001 | 0 | 0 | 1993-03-16 | Bilat | Full | ||||||||||
| 01-CA-29690-001 | 0 | 0 | 1992-11-20 | Bilat | Full | ||||||||||
| 01-CA-29757-001 | 0 | 0 | 1993-03-16 | Bilat | Full | ||||||||||
| 01-CA-29869-001 | 0 | 0 | 1993-11-08 | 1993-11-15 | 1993-12-09 | Unil | Full | ||||||||
| 01-CA-29875-001 | 0 | 0 | 1993-08-06 | Bilat | Full | ||||||||||
| 01-CA-29891-001 | 0 | 0 | 1993-08-12 | Bilat | Full | ||||||||||
| 01-CA-30009-001 | 0 | 0 | 1993-08-02 | Bilat | Full | ||||||||||
| 01-CA-30013-001 | 0 | 0 | 1993-03-16 | Bilat | Full | ||||||||||
| 01-CA-30060-001 | 0 | 0 | 1993-06-23 | Bilat | Full | ||||||||||
| 01-CA-30110-001 | 0 | 0 | 1993-03-16 | Bilat | Full | ||||||||||
| 01-CA-30121-001 | 0 | 0 | 1993-08-02 | Bilat | Full | ||||||||||
| 01-CA-30139-001 | 0 | 0 | 1995-09-22 | 1995-09-29 | 1995-10-05 | Unil | Full | ||||||||
| 01-CA-30176-001 | 0 | 0 | 1993-04-26 | Bilat | Full | ||||||||||
| 01-CA-30218-001 | 0 | 0 | 1995-09-22 | 1995-09-29 | 1995-10-05 | Unil | Full | ||||||||
| 01-CA-30228-001 | 0 | 0 | 1995-09-22 | 1995-09-29 | 1995-10-05 | Unil | Full | ||||||||
| 01-CA-30267-001 | 0 | 0 | 1995-09-22 | 1995-09-29 | 1995-10-05 | Unil | Full | ||||||||
| 01-CA-30283-001 | 0 | 0 | 1995-06-23 | 1995-06-30 | 1995-07-31 | Unil | Full | ||||||||
| 01-CA-30292-001 | 0 | 0 | 1996-11-26 | Bilat | Full | ||||||||||
| 01-CA-30374-001 | 0 | 0 | 1993-09-28 | Bilat | Full | ||||||||||
| 01-CA-30379-001 | 0 | 0 | 1994-06-28 | Bilat | Full | ||||||||||
| 01-CA-30402-001 | 0 | 0 | 1994-06-08 | Bilat | Full | ||||||||||
| 01-CA-30407-001 | 0 | 0 | 1993-07-20 | Bilat | Full | ||||||||||
| 01-CA-30438-001 | 0 | 0 | 1994-01-25 | Bilat | Full | ||||||||||
| 01-CA-30509-001 | 0 | 0 | 1993-08-02 | Bilat | Full | ||||||||||
| 01-CA-30578-001 | 0 | 0 | 1996-12-23 | Bilat | Full | ||||||||||
| 01-CA-30630-001 | 0 | 0 | 1993-09-28 | Bilat | Full | ||||||||||
| 01-CA-30631-001 | 0 | 0 | 1994-10-18 | 1994-10-25 | 1994-10-28 | Unil | Full | ||||||||
| 01-CA-30655-002 | 0 | 0 | 1995-09-22 | 1995-09-29 | 1995-10-05 | Unil | Full | ||||||||
| 01-CA-30655-004 | 0 | 0 | 1995-09-22 | 1995-09-29 | 1995-10-05 | Unil | Full | ||||||||
| 01-CA-30671-001 | 0 | 0 | 1996-05-15 | Bilat | Full | ||||||||||
| 01-CA-30693-001 | 0 | 0 | 1993-08-31 | Bilat | Full | ||||||||||
| 01-CA-30716-001 | 0 | 0 | 1994-01-25 | Bilat | Full | ||||||||||
| 01-CA-30726-001 | 0 | 0 | 1997-03-25 | Bilat | Full | ||||||||||
| 01-CA-30739-001 | 0 | 0 | 1995-09-22 | 1995-09-29 | 1995-10-05 | Unil | Full | ||||||||
| 01-CA-30827-001 | 0 | 0 | 1994-10-18 | 1994-10-25 | 1994-10-28 | Unil | Full | ||||||||
| 01-CA-30830-001 | 0 | 0 | 1995-04-25 | Bilat | Full | ||||||||||
| 01-CA-30941-001 | 0 | 0 | 1994-06-09 | Unil | Full | ||||||||||
| 01-CA-30989-001 | 0 | 0 | 1994-07-12 | Bilat | Full | ||||||||||
| 01-CA-30999-001 | 0 | 0 | 1994-08-30 | Bilat | Full | ||||||||||
| 01-CA-31028-001 | 0 | 0 | 1996-11-26 | Bilat | Full | ||||||||||
| 01-CA-31066-001 | 0 | 0 | 1995-09-22 | 1995-09-29 | 1995-10-05 | Unil | Full | ||||||||
| 01-CA-31211-001 | 0 | 0 | 1997-03-25 | Bilat | Full | ||||||||||
| 01-CA-31218-001 | 0 | 0 | 1995-09-22 | 1995-09-29 | 1995-10-05 | Unil | Full | ||||||||
| 01-CA-31242-001 | 0 | 0 | 1994-07-12 | Bilat | Full |
Table schema
CREATE TABLE c_settlement(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, proposal_letter_sent_date DATE, proposed_approval__date DATE, inf_settle_approved DATE, inf_settle_participation VARCHAR, inf_settle_scope VARCHAR, inf_settle_revoked DATE, fs_settlement_sent_ops DATE, fs_submitted_to BIGINT, formal_scope VARCHAR, fs_board_determination VARCHAR, fs_determination_date DATE, determination_rcvd_reg DATE, formal_participation VARCHAR);