..................
...............
.....................
....
..........................
...............................
......
.....
..
...........
............
......
.....
..
...........
............
MRN|Patient_First_Name|Patient_Middle_Name|Patient_Last_Name|Patient_Name_Suffix|Street_Address|Street_Address_2|State|Zip_Code|Birth_Date|Gender|Admission_Date|Discharge_Date|Total_Charges|net_pmt|claimid|Fin_Class_Name|primary_clm_ins_pkg_id|Ins_Plan_Name|ICD10_Prin_Proc_Code|ADM_Phys_ID|ADM_Phys_Name|ATT_Phys_ID|ATT_Phys_Name|OPR_Phys_ID|OPR_Phys_Name|REF_Phys_ID|REF_Phys_Name|PC_Phys_ID|PC_Phys_Name|DRG_Code|SSN|Marital_Status|Spoken_Language|Race_Code|Employer_Code|Email_Address|Home_Phone_Number|Cell_Phone_Number|claim_serv_day|Facility_ID|patient_city|icd10claimdiagcode01|svc_dept_grp
1171044|CAROLYN||ZUDER||8283 N 1000 W||IN|47471-6316|19460322|F|||567.4|-154.94|1817347|Commercial|52528|UMWA Health and Retirement Funds (Medicare Replacement/Advantage - HMO)||||1407849094|PENDERGAST, THOMAS|||||1659932465|SMIDDY, ROBIN||888880369|MARRIED|English|White|RETIRED|
[email protected]|8123815669|8123815669|20230207|201|WORTHINGTON|M533|NON RHC
1168668|HAROLD||ZUCCA||419 S LINCOLN ST||IN|47842|19771012|M|||196.2|-102.61|1839410|Blue|439175|BCBS-IN - HEALTHY INDIANA PLAN (MEDICAID REPLACEMENT - HMO)||||1851757983|DUNCAN, DAXTON|||||1851757983|DUNCAN, DAXTON||309826858|DIVORCED|English|White|UNKNOWN|
[email protected]|8122398850|8122398850|20230301|201|CLINTON|M5416|NON RHC
1168668|HAROLD||ZUCCA||419 S LINCOLN ST||IN|47842|19771012|M|||196.2|-102.61|1862663|Blue|439175|BCBS-IN - HEALTHY INDIANA PLAN (MEDICAID REPLACEMENT - HMO)||||1851757983|DUNCAN, DAXTON|||||1851757983|DUNCAN, DAXTON||309826858|DIVORCED|English|White|UNKNOWN|
[email protected]|8122398850|8122398850|20230322|201|CLINTON|M961|NON RHC
1168668|HAROLD||ZUCCA||419 S LINCOLN ST||IN|47842|19771012|M|||196.2|0|1899229|Blue|439175|BCBS-IN - HEALTHY INDIANA PLAN (MEDICAID REPLACEMENT - HMO)||||1851757983|DUNCAN, DAXTON|||||1851757983|DUNCAN, DAXTON||309826858|DIVORCED|English|White|UNKNOWN|
[email protected]|8122398850|8122398850|20230420|201|CLINTON|M5416|NON RHC
1168668|HAROLD||ZUCCA||419 S LINCOLN ST||IN|47842|19771012|M|||925|-254.37|1879660|Blue|439175|BCBS-IN - HEALTHY INDIANA PLAN (MEDICAID REPLACEMENT - HMO)||||1407849094|PENDERGAST, THOMAS|||||1851757983|DUNCAN, DAXTON||309826858|DIVORCED|English|White|UNKNOWN|
[email protected]|8122398850|8122398850|20230406|201|CLINTON|M5412|NON RHC
1121582|ZACHERY|ALLEN|ROMOSER||2295 N 1720 EAST RD||IL|61870-9705|19881119|M|||136.4|-105.73|1821614|Commercial|294633|Meritain Health - Aetna (POS II)||||1356756993|IRELAND, DANIELLE|||||1356756993|IRELAND, DANIELLE||355827233|SINGLE|English|White|LONGVIEW BANK & TRUST|
[email protected]|2178228052|2178228052|20230213|8|RIDGE FARM|I10|RHC_CHRISMAN
1114171|ZACHARY|WADE|PHILLIPS||19667 E 2256TH RD||IL|61924|19820204|M|||196.2|-96.57|1869133|Commercial|611119|Aetna Better Health of IL (Medicaid Replacement - HMO)||||1356756993|IRELAND, DANIELLE|||||1356756993|IRELAND, DANIELLE||361700082|SINGLE|English|White|NUTRIEN|
[email protected]|2172641835|2172641835|20230327|8|CHRISMAN|I10|RHC_CHRISMAN
1107335|ZACHARIAH|JOHN|PATRICK||1414 S MAIN ST||IL|61944-2829|19750415|M|||136.4|-77.75|1844073|Blue|21719|BCBS-IL (PPO)||||1124390943|GRIFFIN, DEBRA|||||1124390943|GRIFFIN, DEBRA||332801420|SINGLE|English|White|ZIMMERLY READY MIX|
[email protected]|2178226067|2178226067|20230301|1|PARIS|K219|RHC_Paris
1167066|KARL||CHAMBERS||7816 NORTH COUNTY ROAD 75 WEST||IN|47879|19640112|M|||196.2|-80.45|1812011|Medicare B/DME|42530|Medicare-IN (Medicare)||||1659932465|SMIDDY, ROBIN|||||1164913703|ROGERS, KACY||309684569|SINGLE|English|White|UNKNOWN|
[email protected]|8122490986|8122490986|20230206|201|SHELBURN|M48062|NON RHC