text: INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -1, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -1, -1, TO_DATE('2016-11-01', 'YYYY-MM-DD'), TO_DATE('2016-11-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -2, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:01:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -3, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:02:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -4, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:03:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -5, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:04:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -6, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:05:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -7, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:06:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -8, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:07:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES ( -9, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:08:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-10, -1, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:09:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-11, -4, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:10:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-12, -4, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:11:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-13, -4, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-14, -4, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:13:00', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-15, -4, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:14:00', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-16, -5, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 12:14:00', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-16, -5, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 11:14:00', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-28, -5, TO_DATE('2017-01-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 11:14:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-29, -5, TO_DATE('2016-01-01', 'YYYY-MM-DD'), TO_DATE('2016-01-01 11:14:00', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-29, -5, TO_DATE('2017-05-01', 'YYYY-MM-DD'), TO_DATE('2017-01-01 11:14:00', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-31, -5, TO_DATE('2017-05-01', 'YYYY-MM-DD'), TO_DATE('2017-05-01 11:14:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-32, -5, TO_DATE('2017-06-01', 'YYYY-MM-DD'), TO_DATE('2017-06-01 12:14:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'LEI', 'ITAG_USER');
  
  -- Allocations at Moorland (MDI) for auto-allocation testing
  INSERT INTO OFFENDER_KEY_WORKERS (OFFENDER_BOOK_ID, OFFICER_ID, ASSIGNED_DATE, ASSIGNED_TIME, ACTIVE_FLAG, AGY_LOC_ID, USER_ID) VALUES (-35, -6, TO_DATE('2017-06-01', 'YYYY-MM-DD'), TO_DATE('2017-06-01 12:14:00', 'YYYY-MM-DD HH24:MI:SS'), 'Y', 'MDI', 'ITAG_USER');
  