-- Synthetic seed data for the legacy schema (works in the DB2 and Oracle dialects).
-- Fake applicants, generic case types. Edge cases on purpose:
--   CHAR padding on every text column; CLOSE_DT 0001-01-01 sentinel on every case that is not closed;
--   non-ASCII names (applicants 7 and 13); amounts with cents, 0.01 and the DECIMAL(11,2) maximum.
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (1, 'Applicant-0001', 'Test', 'XB');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (2, 'Applicant-0002', 'Test', 'XC');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (3, 'Applicant-0003', 'Test', 'XD');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (4, 'Applicant-0004', 'Test', 'XA');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (5, 'Applicant-0005', 'Test', 'XB');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (6, 'Applicant-0006', 'Test', 'XC');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (7, 'Peña-Applicant', 'Test', 'XD');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (8, 'Applicant-0008', 'Test', 'XA');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (9, 'Applicant-0009', 'Test', 'XB');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (10, 'Applicant-0010', 'Test', 'XC');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (11, 'Applicant-0011', 'Test', 'XD');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (12, 'Applicant-0012', 'Test', 'XA');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (13, 'Applicant-0013', 'Zoë', 'XB');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (14, 'Applicant-0014', 'Test', 'XC');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (15, 'Applicant-0015', 'Test', 'XD');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (16, 'Applicant-0016', 'Test', 'XA');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (17, 'Applicant-0017', 'Test', 'XB');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (18, 'Applicant-0018', 'Test', 'XC');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (19, 'Applicant-0019', 'Test', 'XD');
INSERT INTO APPLICANT (APPL_ID, LAST_NM, FIRST_NM, ST_CD) VALUES (20, 'Applicant-0020', 'Test', 'XA');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000001', 1, 'DEF', 'C', DATE '2024-02-02', DATE '2024-02-03', 1234.56, TIMESTAMP '2026-02-02 01:07:13.001234');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000002', 2, 'GHI', 'P', DATE '2025-03-03', DATE '0001-01-01', 0.01, TIMESTAMP '2026-03-03 02:14:26.002468');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000003', 3, 'ABC', 'O', DATE '2026-04-04', DATE '0001-01-01', 999999999.99, TIMESTAMP '2026-04-04 03:21:39.003702');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000004', 4, 'DEF', 'C', DATE '2023-05-05', DATE '2023-05-06', 100.10, TIMESTAMP '2026-05-05 04:28:52.004936');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000005', 5, 'GHI', 'O', DATE '2024-06-06', DATE '0001-01-01', 329352.63, TIMESTAMP '2026-06-06 05:35:05.006170');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000006', 6, 'ABC', 'O', DATE '2025-07-07', DATE '0001-01-01', 95932.61, TIMESTAMP '2026-07-07 06:42:18.007404');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000007', 7, 'DEF', 'C', DATE '2026-08-08', DATE '2026-08-09', 154913.58, TIMESTAMP '2026-08-08 07:49:31.008638');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000008', 8, 'GHI', 'P', DATE '2023-09-09', DATE '0001-01-01', 464965.33, TIMESTAMP '2026-09-09 08:56:44.009872');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000009', 9, 'ABC', 'O', DATE '2024-10-10', DATE '0001-01-01', 102823.32, TIMESTAMP '2026-01-10 09:03:57.011106');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000010', 10, 'DEF', 'O', DATE '2025-11-11', DATE '0001-01-01', 471458.88, TIMESTAMP '2026-02-11 10:10:10.012340');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000011', 11, 'GHI', 'P', DATE '2026-12-12', DATE '0001-01-01', 61866.41, TIMESTAMP '2026-03-12 11:17:23.013574');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000012', 12, 'ABC', 'O', DATE '2023-01-13', DATE '0001-01-01', 273734.86, TIMESTAMP '2026-04-13 12:24:36.014808');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000013', 13, 'DEF', 'C', DATE '2024-02-14', DATE '2024-02-15', 399741.22, TIMESTAMP '2026-05-14 13:31:49.016042');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000014', 14, 'GHI', 'P', DATE '2025-03-15', DATE '0001-01-01', 454005.30, TIMESTAMP '2026-06-15 14:38:02.017276');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000015', 15, 'ABC', 'O', DATE '2026-04-16', DATE '0001-01-01', 88620.30, TIMESTAMP '2026-07-16 15:45:15.018510');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000016', 16, 'DEF', 'C', DATE '2023-05-17', DATE '2023-05-18', 104976.94, TIMESTAMP '2026-08-17 16:52:28.019744');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000017', 17, 'GHI', 'P', DATE '2024-06-18', DATE '0001-01-01', 191646.73, TIMESTAMP '2026-09-18 17:59:41.020978');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000018', 18, 'ABC', 'O', DATE '2025-07-19', DATE '0001-01-01', 266203.25, TIMESTAMP '2026-01-19 18:06:54.022212');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000019', 19, 'DEF', 'C', DATE '2026-08-20', DATE '2026-08-21', 424943.86, TIMESTAMP '2026-02-20 19:13:07.023446');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000020', 20, 'GHI', 'O', DATE '2023-09-21', DATE '0001-01-01', 467540.96, TIMESTAMP '2026-03-21 20:20:20.024680');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000021', 1, 'ABC', 'O', DATE '2024-10-22', DATE '0001-01-01', 438193.63, TIMESTAMP '2026-04-22 21:27:33.025914');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000022', 2, 'DEF', 'C', DATE '2025-11-23', DATE '2025-11-24', 113297.91, TIMESTAMP '2026-05-23 22:34:46.027148');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000023', 3, 'GHI', 'P', DATE '2026-12-24', DATE '0001-01-01', 156736.33, TIMESTAMP '2026-06-24 23:41:59.028382');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000024', 4, 'ABC', 'O', DATE '2023-01-25', DATE '0001-01-01', 3494.43, TIMESTAMP '2026-07-25 00:48:12.029616');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000025', 5, 'DEF', 'O', DATE '2024-02-26', DATE '0001-01-01', 212544.28, TIMESTAMP '2026-08-26 01:55:25.030850');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000026', 6, 'GHI', 'P', DATE '2025-03-27', DATE '0001-01-01', 404643.93, TIMESTAMP '2026-09-27 02:02:38.032084');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000027', 7, 'ABC', 'O', DATE '2026-04-01', DATE '0001-01-01', 212823.68, TIMESTAMP '2026-01-01 03:09:51.033318');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000028', 8, 'DEF', 'C', DATE '2023-05-02', DATE '2023-05-03', 181360.75, TIMESTAMP '2026-02-02 04:16:04.034552');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000029', 9, 'GHI', 'P', DATE '2024-06-03', DATE '0001-01-01', 300526.67, TIMESTAMP '2026-03-03 05:23:17.035786');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000030', 10, 'ABC', 'O', DATE '2025-07-04', DATE '0001-01-01', 142685.34, TIMESTAMP '2026-04-04 06:30:30.037020');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000031', 11, 'DEF', 'C', DATE '2026-08-05', DATE '2026-08-06', 314537.90, TIMESTAMP '2026-05-05 07:37:43.038254');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000032', 12, 'GHI', 'P', DATE '2023-09-06', DATE '0001-01-01', 158959.70, TIMESTAMP '2026-06-06 08:44:56.039488');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000033', 13, 'ABC', 'O', DATE '2024-10-07', DATE '0001-01-01', 60205.36, TIMESTAMP '2026-07-07 09:51:09.040722');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000034', 14, 'DEF', 'C', DATE '2025-11-08', DATE '2025-11-09', 250298.72, TIMESTAMP '2026-08-08 10:58:22.041956');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000035', 15, 'GHI', 'O', DATE '2026-12-09', DATE '0001-01-01', 483894.64, TIMESTAMP '2026-09-09 11:05:35.043190');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000036', 16, 'ABC', 'O', DATE '2023-01-10', DATE '0001-01-01', 76128.63, TIMESTAMP '2026-01-10 12:12:48.044424');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000037', 17, 'DEF', 'C', DATE '2024-02-11', DATE '2024-02-12', 358579.80, TIMESTAMP '2026-02-11 13:19:01.045658');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000038', 18, 'GHI', 'P', DATE '2025-03-12', DATE '0001-01-01', 415910.20, TIMESTAMP '2026-03-12 14:26:14.046892');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000039', 19, 'ABC', 'O', DATE '2026-04-13', DATE '0001-01-01', 99536.26, TIMESTAMP '2026-04-13 15:33:27.048126');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000040', 20, 'DEF', 'O', DATE '2023-05-14', DATE '0001-01-01', 339345.87, TIMESTAMP '2026-05-14 16:40:40.049360');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000041', 1, 'GHI', 'P', DATE '2024-06-15', DATE '0001-01-01', 422910.55, TIMESTAMP '2026-06-15 17:47:53.050594');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000042', 2, 'ABC', 'O', DATE '2025-07-16', DATE '0001-01-01', 68875.52, TIMESTAMP '2026-07-16 18:54:06.051828');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000043', 3, 'DEF', 'C', DATE '2026-08-17', DATE '2026-08-18', 269212.61, TIMESTAMP '2026-08-17 19:01:19.053062');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000044', 4, 'GHI', 'P', DATE '2023-09-18', DATE '0001-01-01', 300806.12, TIMESTAMP '2026-09-18 20:08:32.054296');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000045', 5, 'ABC', 'O', DATE '2024-10-19', DATE '0001-01-01', 478314.90, TIMESTAMP '2026-01-19 21:15:45.055530');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000046', 6, 'DEF', 'C', DATE '2025-11-20', DATE '2025-11-21', 105507.75, TIMESTAMP '2026-02-20 22:22:58.056764');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000047', 7, 'GHI', 'P', DATE '2026-12-21', DATE '0001-01-01', 136005.68, TIMESTAMP '2026-03-21 23:29:11.057998');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000048', 8, 'ABC', 'O', DATE '2023-01-22', DATE '0001-01-01', 442531.43, TIMESTAMP '2026-04-22 00:36:24.059232');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000049', 9, 'DEF', 'C', DATE '2024-02-23', DATE '2024-02-24', 414555.84, TIMESTAMP '2026-05-23 01:43:37.060466');
INSERT INTO CASE_MSTR (CASE_NO, APPL_ID, CASE_TYP_CD, STAT_CD, OPEN_DT, CLOSE_DT, AMT_CLAIMED, LAST_UPD_TS) VALUES ('C-000050', 10, 'GHI', 'O', DATE '2025-03-24', DATE '0001-01-01', 285666.60, TIMESTAMP '2026-06-24 02:50:50.061700');
