company allegedly hacked as reported by Everest ransomware with details: number amount of data: ~ 3,400,000 records CZ_DOC_TRACK_DATA_TABLE.csv INPUT_JOB_ID MERGED_JOB_ID PRINT_FLAG EPOC_FLAG CMOD_FLAG PULL_FLAG ADDRESS_LINE_1 ADDRESS_LINE_2 ADDRESS_LINE_3 ADDRESS_LINE_4 ADDRESS_LINE_5 ADDRESS_LINE_6 RECEIVED_DATE PROCESSED_DATE STATEMENT_DATE ACCOUNT_NUMBER REFERENCE_NUMBER LETTER_TYPE STATEMENT_TYPE DOCUMENT_SEQUENCE_NUMBER US_HANDLING_CODE TRACK_JOB_ID VPF_FILEPATH OP_OFFSET OUT_NB LAST_MODIFIED_TIME REMOVAL_MARK CZ_DOC_ID HANDLING_CODE CUSTOMVALUE1 CUSTOMVALUE2 CUSTOMVALUE3 CUSTOMVALUE4 CUSTOMVALUE5 CUSTOMVALUE6 CUSTOMVALUE7 CUSTOMVALUE8 CUSTOMVALUE9 CUSTOMVALUE10 CUSTOMVALUE11 CUSTOMVALUE12 WOP_PRINT_SUPPRESSION WOP_REBOUND_DETECTED WOP_REBOUND_INPUT_JOB_ID WOP_REBOUND WOP_ORIGINAL_INPUT_JOB_ID WOP_ORIGINAL_MERGE_JOB_ID 186 191 N N Y N GENOESE & ASSOCIATES PA 4550 linden hill ROAD SUITE 100 WILMINGTON de 19808 30/04/2025 11:41.38 standard_account_number PDU 424 880881001447700042 002_186-000000424-P /adf/data/traffic/jobs/CITIZENS/CONSUMER/CONS_BILL_NOTICE1/000000191/processing/producerstep1/6_PLUGINS/out/CMODOUT-@-TEMPARCHDESCRIPTION_000000186_PDU_CMOD_s.vpf 846_2 2 30-APR-25 12.52.36.276761000 PM N 186-000000424-P 99 4/21/2025 880 8810014477 00042 880881001447700042 N N 0 0 PPQA_NCR_PREPROCESS_FIELDS_DATA_TABLE.csv IMAGES_PATH OVERLAY_PATH VPF_PATH VPF_IND_PATH OFFSET JOBID FILE_NUMBER REMOVAL_MARK PREMERGEJOBID DOCID MISSINGCHECKS PRINTCHANNEL MEDIA ARCHIVECHANNEL DOCUMENTPULLFLAG MAILINGADDRESSNAME1 ACCOUNTNUMBER CUSTOM_STATEMENT_TYPE MAILPIECESEQNB CHECK_IMAGE_VALIDATION MAILINGADDRESSNAME2 MAILINGADDRESS1 MAILINGADDRESS2 MAILINGADDRESS3 MAILINGADDRESSCITY FILERECEPTIONDATE PROCESSINGDATE MAILINGDATE /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_060_PA/000073487/preparation/producerstep2/3_PLUGINS/out -DM /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_060_PA/000073487/preparation/producerstep2/3_PLUGINS/out /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_060_PA/000073487/preparation/producerstep2/3_PLUGINS/out/000073487_s.vpf /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_060_PA/000073487/preparation/producerstep2/3_PLUGINS/out/000073487_s.vpf.ind 1007_4 000073487 000 N 000073487 73487-000000202-P 0 Y BOTH Y N DEONTAE X QUIN 6103598323 NIS 000000202 0 51820 CRAIG CIRCLE PITTSBURGH dad 15237-1653 17/09/2024 19:25.12 3/21/2024 PPQA_AOS_LETTER_DATA_TABLE.csv IMAGES_PATH OVERLAY_PATH VPF_PATH VPF_IND_PATH OFFSET JOBID FILE_NUMBER REMOVAL_MARK PREMERGEJOBID DOCID ACCOUNTNUMBER HOUSEHOLDINGKEY PRINTEDADDRESSLINE1 ORIGINALDOCSEQNB PRINTEDADDRESSLINE2 PRINTEDADDRESSLINE3 SLADUEDATE /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_880_NY/000069574/preparation/producerstep4/1_PLUGINS/out -DM /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_880_NY/000069574/preparation/producerstep4/1_PLUGINS/out /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_880_NY/000069574/preparation/producerstep3/4_COMPOSITION/out/000069574_s.vpf /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_880_NY/000069574/preparation/producerstep4/1_PLUGINS/out/000069574_s.ind 702_4 000069574 000 N 000069574 69574-000000173-P 4044548521 KIANNA m CARMODY 1 80234 ASH PLACE PITTSFORD NY 14534-1217 CZ_DOC_TRACK_DATA_TABLE.sql insert into HARMONIE_PRODUCER.CZ_DOC_TRACK (INPUT_JOB_ID,MERGED_JOB_ID,PRINT_FLAG,EPOC_FLAG,CMOD_FLAG,PULL_FLAG,ADDRESS_LINE_1,ADDRESS_LINE_2,ADDRESS_LINE_3,ADDRESS_LINE_4,ADDRESS_LINE_5,ADDRESS_LINE_6,RECEIVED_DATE,PROCESSED_DATE,STATEMENT_DATE,ACCOUNT_NUMBER,REFERENCE_NUMBER,LETTER_TYPE,STATEMENT_TYPE,DOCUMENT_SEQUENCE_NUMBER,US_HANDLING_CODE,TRACK_JOB_ID,VPF_FILEPATH,OP_OFFSET,OUT_NB,LAST_MODIFIED_TIME,REMOVAL_MARK,CZ_DOC_ID,HANDLING_CODE,CUSTOMVALUE1,CUSTOMVALUE2,CUSTOMVALUE3,CUSTOMVALUE4,CUSTOMVALUE5,CUSTOMVALUE6,CUSTOMVALUE7,CUSTOMVALUE8,CUSTOMVALUE9,CUSTOMVALUE10,CUSTOMVALUE11,CUSTOMVALUE12,WOP_PRINT_SUPPRESSION,WOP_REBOUND_DETECTED,WOP_REBOUND_INPUT_JOB_ID,WOP_REBOUND,WOP_ORIGINAL_INPUT_JOB_ID,WOP_ORIGINAL_MERGE_JOB_ID) values (963,997,'Y','N','Y','N','SHAYNA e HELAIRE','ALEXANDRO X TORY','75723 FAIRWEATHER PLACE','WESTWOOD, MA 02090-3417',null,null,null,'30/06/2025 11:54.58',null,'1306803761',null,'N','NSF',31,'12/03/2024','001_963-000000031-P','/adf/data/traffic/jobs/CITIZENS/CONSUMER/CONS_NOTICE_LT R2/000000997/processing/producerstep1/6_PLUGINS/out/CMODOUT-@-TEMPARCHDESCRIPTION_000000963_CMOD_CZ_s.vpf','61_2',1,to_timestamp('30-JUN-25 05.01.13.602165000 PM','DD-MON-RR HH.MI.SSXFF AM'),'N','963-000000031-P','99','SHAYNA E HELAIRE','101','1306803761','711','12/03/2024',null,null,null,null,null,null,null,'N',null,null,'N',0,0); PPQA_NCR_PREPROCESS_FIELDS_DATA_TABLE.sql enclose into HARMONIE_PRODUCER.PPQA_NCR_PREPROCESS_FIELDS (IMAGES_PATH,OVERLAY_PATH,VPF_PATH,VPF_IND_PATH,OFFSET,JOBID,FILE_NUMBER,REMOVAL_MARK,PREMERGEJOBID,DOCID,MISSINGCHECKS,PRINTCHANNEL,MEDIA,ARCHIVECHANNEL,DOCUMENTPULLFLAG,MAILINGADDRESSNAME1,ACCOUNTNUMBER,CUSTOM_STATEMENT_TYPE,MAILPIECESEQNB,CHECK_IMAGE_VALIDATION,MAILINGADDRESSNAME2,MAILINGADDRESS1,MAILINGADDRESS2,MAILINGADDRESS3,MAILINGADDRESSCITY,FILERECEPTIONDATE,PROCESSINGDATE,MAILINGDATE) values ('/adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_060_PA/000001738/preparation/producerstep2/3_PLUGINS/out -DM /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_060_PA/000001738/preparation/producerstep2/3_PLUGINS/out',null,'/adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_060_PA/000001738/preparation/producerstep2/3_PLUGINS/out/000001738_s.vpf','/adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_060_PA/000001738/preparation/producerstep2/3_PLUGINS/out/000001738_s.vpf.ind','8254_4','000001738','000','N','000001738','17 38-000002036-P','0','Y','BOTH','Y','N','JOANN MORRIS BRADY','6142386672','NIS','000002036','0','406 COVINGTON RD','HAVERTOWN PA 19083-5526',null,null,null,null,'01/08/2025 17:25.00','02/28/2025'); PPQA_AOS_LETTER_DATA_TABLE.sql introduce into HARMONIE_PRODUCER.PPQA_AOS_LETTER (IMAGES_PATH,OVERLAY_PATH,VPF_PATH,VPF_IND_PATH,OFFSET,JOBID,FILE_NUMBER,REMOVAL_MARK,PREMERGEJOBID,DOCID,ACCOUNTNUMBER,HOUSEHOLDINGKEY,PRINTEDADDRESSLINE1,ORIGINALDOCSEQNB,PRINTEDADDRESSLINE2,PRINTEDADDRESSLINE3,SLADUEDATE) values ('/adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_101_MA/000072010/preparation/producerstep4/1_PLUGINS/out -DM /adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_101_MA/000072010/preparation/producerstep4/1_PLUGINS/out',null,'/adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_101_MA/000072010/preparation/producerstep3/4_COMPOSITION/out/000072010_s.vpf','/adf/data/traffic/jobs/CITIZENS/DDA_DEPOSIT_STMTS/DDA_BANK_101_MA/000072010/preparation/producerstep4/1_PLUGINS/out/000072010_s.ind','1120_4','000072010','000','N','000072010','72010-000000263-P','1105573211',null,'SHAYE N MCDERMOTT','1','82668 anchor common CIRCLE','REVERE momma 02151-2414',null);