I can’t upload attachments. it says i’m a new user but i registered a year ago. here is a sample of a test json in my format. can you try to extract the detail tables (list Accounts and Account Level Summaries) and tell me how you did it or upload a datamapper that does it?
{
"Data": {
"FileHeader": {
"FileCreateDatetime": "Sep 8, 2022 9:50 am EDT",
"Business Unit": "DOH",
"Background Job": "",
"Generation Group": "STATEMENTS",
"Outbox Connection": "JSON STMTS"
},
"Statements": [
{
"Statement Number": "SN0000002683",
"Cumulative Format": {
"Header": {
"Header Name": "",
"Address Line 1": "",
"Address Line 2": "",
"City": "",
"State": "",
"Zip": "",
"Facility Phone Number": "",
"Header Message Text": [
"You are listed as the responsible party for the account(s) listed on this bill. Additional bills may be received for professional services rendered during the service dates listed below. ",
"For questions or information, please contact our main number. "
]
},
"Payment Footer": {
"Payment Name": "Doyleston Hospital",
"Address Line 1": "PO Box 822785",
"Address Line 2": "",
"City": "Philadelphia",
"State": "PA",
"Zip": "19182-2785",
"Remit Phone Number": "",
"Payment Due By": "09/18/22",
"Payment Amount": "10343.75",
"Payment Message Text": "",
"Statement Number": "SN0000002683"
},
"Guarantor": {
"Guarantor Number": "GN00000040",
"Guarantor Name": "Test,Medicare",
"Address Line 1": "123 Testing Lane",
"Address Line 2": "",
"City": "DOYLESTOWN",
"State": "PA",
"Zip": "18902",
"Country": "",
"Phone": "555-555-5555",
"Phone Type": "Cell Phone Number",
"Social Security Number": "555-55-5555",
"Date of Birth": "02/15/1953",
"Email": ""
},
"Accounts": [
{
"Confidential": "",
"Account Name": "Test,Medicare",
"Account Number": "A00000000054",
"Date of Birth": "02/15/1953",
"Address Line 1": "123 Testing Lane",
"Address Line 2": "",
"City": "DOYLESTOWN",
"State": "PA",
"Zip": "18902",
"Social Security Number": "555-55-5555"
},
{
"Confidential": "",
"Account Name": "Test,Medicare",
"Account Number": "A00000000132",
"Date of Birth": "02/15/1953",
"Address Line 1": "123 Testing Lane",
"Address Line 2": "",
"City": "DOYLESTOWN",
"State": "PA",
"Zip": "18902",
"Social Security Number": "555-55-5555"
},
{
"Confidential": "",
"Account Name": "Test,Medicare",
"Account Number": "A00000000120",
"Date of Birth": "02/15/1953",
"Address Line 1": "123 Testing Lane",
"Address Line 2": "",
"City": "DOYLESTOWN",
"State": "PA",
"Zip": "18902",
"Social Security Number": "555-55-5555"
}
],
"Account Level Summaries": [
{
"Account Number": "A00000000054",
"Statement Date": "09/08/22",
"Your Activity": {
"Previous Balance": "0.00",
"New Charges": "0.00",
"Payments": "0.00",
"Adjustments": "0.00",
"Refunds": "0.00",
"Insurance Auto Xfer": "357.75",
"Interest Adjustments": "0.00",
"Interest Label": "",
"Total Due": "357.75"
},
"Insurance Activity": {
"Insurance Previous Balance": "0.00",
"Insurance Billed": "1431.00",
"Insurance Paid": "-1073.25",
"Insurance Adjustment": "0.00",
"Insurance Auto Xfer": "-357.75",
"Insurance Refunds": "0.00",
"Insurance Total Due": "0.00"
}
},
{
"Account Number": "A00000000132",
"Statement Date": "09/08/22",
"Your Activity": {
"Previous Balance": "0.00",
"New Charges": "0.00",
"Payments": "0.00",
"Adjustments": "0.00",
"Refunds": "0.00",
"Insurance Auto Xfer": "851.00",
"Interest Adjustments": "0.00",
"Interest Label": "",
"Total Due": "851.00"
},
"Insurance Activity": {
"Insurance Previous Balance": "0.00",
"Insurance Billed": "851.00",
"Insurance Paid": "0.00",
"Insurance Adjustment": "0.00",
"Insurance Auto Xfer": "-851.00",
"Insurance Refunds": "0.00",
"Insurance Total Due": "0.00"
}
},
{
"Account Number": "A00000000120",
"Statement Date": "09/08/22",
"Your Activity": {
"Previous Balance": "0.00",
"New Charges": "0.00",
"Payments": "0.00",
"Adjustments": "0.00",
"Refunds": "0.00",
"Insurance Auto Xfer": "9135.00",
"Interest Adjustments": "0.00",
"Interest Label": "",
"Total Due": "9135.00"
},
"Insurance Activity": {
"Insurance Previous Balance": "0.00",
"Insurance Billed": "7993.00",
"Insurance Paid": "77.13",
"Insurance Adjustment": "1064.87",
"Insurance Auto Xfer": "-9135.00",
"Insurance Refunds": "0.00",
"Insurance Total Due": "0.00"
}
}
],
"Account Level Details": [
{
"Account Number": "A00000000054",
"Account Details": {
"From Date": "07/19/21",
"Thru Date": "07/19/21",
"Message Text": ""
}
},
{
"Account Number": "A00000000132",
"Account Details": {
"From Date": "09/30/21",
"Thru Date": "09/30/21",
"Message Text": ""
}
},
{
"Account Number": "A00000000120",
"Account Details": {
"From Date": "09/25/21",
"Thru Date": "09/25/21",
"Message Text": ""
}
}
],
"Account Level Charge Details": [
{
"Account Test,Medicare - A00000000054": [
{
"Bill/Txn Number": "R",
"Account Number": "A00000000054",
"Service Date": "",
"Charge Transaction Quantity": "2",
"Charge Transaction Amount": "1431.00",
"Charge Description": "Emergency Room"
}
]
},
{
"Account Test,Medicare - A00000000132": [
{
"Bill/Txn Number": "R",
"Account Number": "A00000000132",
"Service Date": "",
"Charge Transaction Quantity": "3",
"Charge Transaction Amount": "447.00",
"Charge Description": "Laboratory"
},
{
"Bill/Txn Number": "R",
"Account Number": "A00000000132",
"Service Date": "",
"Charge Transaction Quantity": "1",
"Charge Transaction Amount": "404.00",
"Charge Description": "EKG/ECG (Electrocardiogram)"
}
]
},
{
"Account Test,Medicare - A00000000120": [
{
"Bill/Txn Number": "R",
"Account Number": "A00000000120",
"Service Date": "",
"Charge Transaction Quantity": "3",
"Charge Transaction Amount": "826.00",
"Charge Description": "Laboratory"
},
{
"Bill/Txn Number": "R",
"Account Number": "A00000000120",
"Service Date": "",
"Charge Transaction Quantity": "1",
"Charge Transaction Amount": "296.00",
"Charge Description": "Radiology - Diagnostic"
},
{
"Bill/Txn Number": "R",
"Account Number": "A00000000120",
"Service Date": "",
"Charge Transaction Quantity": "1",
"Charge Transaction Amount": "154.00",
"Charge Description": "Respiratory Services"
},
{
"Bill/Txn Number": "R",
"Account Number": "A00000000120",
"Service Date": "",
"Charge Transaction Quantity": "1",
"Charge Transaction Amount": "410.00",
"Charge Description": "Physical Therapy"
},
{
"Bill/Txn Number": "R",
"Account Number": "A00000000120",
"Service Date": "",
"Charge Transaction Quantity": "3",
"Charge Transaction Amount": "2342.00",
"Charge Description": "Emergency Room"
},
{
"Bill/Txn Number": "R",
"Account Number": "A00000000120",
"Service Date": "",
"Charge Transaction Quantity": "2",
"Charge Transaction Amount": "808.00",
"Charge Description": "EKG/ECG (Electrocardiogram)"
},
{
"Bill/Txn Number": "R",
"Account Number": "A00000000120",
"Service Date": "",
"Charge Transaction Quantity": "41",
"Charge Transaction Amount": "3157.00",
"Charge Description": "Specialty Room - Treat/Obsv"
}
]
}
],
"Account Level Non-Charge Details": [
{
"Account Test,Medicare - A00000000054": [
{
"Bill/Txn Number": "R",
"Account Number": "A00000000054",
"Transaction Type": "PAY",
"Non-Charge Transaction Amount": "-1073.25",
"Non-Charge Date": "09/15/21",
"Non-Charge Description": "PAYMENT MEDICARE INSURANCE",
"Non-Charge Code": "PM/C"
},
{
"Bill/Txn Number": "R",
"Account Number": "A00000000054",
"Transaction Type": "PAY",
"Non-Charge Transaction Amount": "0.00",
"Non-Charge Date": "12/17/21",
"Non-Charge Description": "PAYMENT MEDICARE INSURANCE",
"Non-Charge Code": "PM/C"
}
]
},
{
"Account Test,Medicare - A00000000120": [
{
"Bill/Txn Number": "R",
"Account Number": "A00000000120",
"Transaction Type": "ADJ",
"Non-Charge Transaction Amount": "1064.87",
"Non-Charge Date": "12/17/21",
"Non-Charge Description": "WRITE-OFF MEDICARE REDUCED",
"Non-Charge Code": "AM/CREDUCE"
},
{
"Bill/Txn Number": "R",
"Account Number": "A00000000120",
"Transaction Type": "PAY",
"Non-Charge Transaction Amount": "77.13",
"Non-Charge Date": "12/17/21",
"Non-Charge Description": "PAYMENT REJECTION MEDICARE",
"Non-Charge Code": "DM/C"
}
]
}
],
"Remit (CAS) Codes": [
{
"Account Number": "A00000000054",
"Bill/Txn Number": "R",
"CAS Description": "CoPay Amt",
"CAS Amount": "143.10",
"CAS Codes": "3-CO"
},
{
"Account Number": "A00000000054",
"Bill/Txn Number": "R",
"CAS Description": "\"These are non-covered services because this is not deemed a 'medical necessity' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"",
"CAS Amount": "214.65",
"CAS Codes": "50-CO"
},
{
"Account Number": "A00000000054",
"Bill/Txn Number": "R",
"CAS Description": "Patient is enrolled in a Hospice.",
"CAS Amount": "379.00",
"CAS Codes": "B9-PR"
},
{
"Account Number": "A00000000120",
"Bill/Txn Number": "R",
"CAS Description": "Charge exceeds fee schedule/maximum allowable or contracted/legislated fee arrangement. Usage: This adjustment amount cannot equal the total service or claim charge amount; and must not duplicate provider adjustment amounts (payments and contractual reductions) that have resulted from prior payer(s) adjudication. (Use only with Group Codes PR or CO depending upon liability)",
"CAS Amount": "-1064.87",
"CAS Codes": "45-CO"
}
]
}
}
]
}
}
