PURPOSE: This report allows you to download all fields (all data) of each agent-assisted IVR payment requests generated for a selected period.
RELATED REPORT: Payments By Users -- See: https://1800notify.zendesk.com/hc/en-us/articles/35431984048781
FORMAT: CSV (Comma Separated Variable) format that can be opened in any spreadsheet such as Microsoft Excel.
FILE NAME: (First 12 char of your Org name)_Payment_Logs_MMDDYYYY-MMDDYYYY.CSV
EXAMPLE: For "Greenfield Health Care" 03-01-2025 to 03-31-2025
the file name would be: Greenfield_H_Payment_Logs_03012025-03312025.csv
FIELD NAMES: (See the bottom of this article)
HOW TO GENERATE:
1- Login to your account at www.1800notify.com
2- Click the IVR tab, then PAYMENTS sub-tab
3- Click the REPORTS button.
Select Payments Logs
Choose the Time Period you want to use for your report.
Click the DOWNLOAD button.
Depending on your browser download settings, you may asked to select a folder and optionally adjust the file name. Or, the file will be automatically downloaded to your "Downloads" folder.
Here's a sample report:
TIP: When you open the spreadsheet in Excel, you may want to save the file as a Spreadsheet using the "Save As" button.
FIELD NAMES DEFINED
| Field Name | Definition / Details |
| Date of Activity | Date the request was sent |
| Status | Status (pending if not paid, or done, if paid) |
| Request By | Name (email) of person who sent the payment request |
| First Name | First Name of person who received the request |
| Last Name | Last Name of person who received the request |
| Payment Code | 4-digit payment code |
| Ivr Phone | IVR Phone # to call with the payment code |
| Payment Code Expires | When the payment code expires |
| Amount Requested | Total amount requested |
| Amount Paid | Total amount paid |
| Auth Code | Auth Code (of a successful payment) |
| Payment Time | Date/Time of payment |
| Sms Status | Status of SMS Text Message ("sent" or blank) |
| Email Status | Status of Email Message ("sent" or blank) |
| Pay Pat Mrn | MRN (Medical Record Number) of paying patient |
| V1 Mrn | Visit 1 MRN (for Epic Prepay) |
| V1 Csn | Visit 1 CSN - Contact Serial Number of this visit (for Epic Prepay) |
| V1 Copay | Visit 1 Copay Amount |
| V1 Prepay | Visit 1 Prepay Amount |
| V1 First Name | Visit 1 First Name of patient |
| V1 Last Name | Visit 1 Last Name of patient |
| V2 Mrn | Visit 2 MRN (for Epic Prepay) |
| V2 Csn | Visit 2 CSN - Contact Serial Number of this visit (for Epic Prepay) |
| V2 Copay | Visit 2 Copay Amount |
| V2 Prepay | Visit 2 Prepay Amount |
| V2 First Name | Visit 2 First Name of patient |
| V2 Last Name | Visit 2 Last Name of patient |
| V3 Mrn | Visit 3 MRN (for Epic Prepay) |
| V3 Csn | Visit 3 CSN - Contact Serial Number of this visit (for Epic Prepay) |
| V3 Copay | Visit 3 Copay Amount |
| V3 Prepay | Visit 3 Prepay Amount |
| V3 First Name | Visit 3 First Name of patient |
| V3 Last Name | Visit 3 Last Name of patient |
| V4 Mrn | Visit 4 MRN (for Epic Prepay) |
| V4 Csn | Visit 4 CSN - Contact Serial Number of this visit (for Epic Prepay) |
| V4 Copay | Visit 4 Copay Amount |
| V4 Prepay | Visit 4 Prepay Amount |
| V4 First Name | Visit 4 First Name of patient |
| V4 Last Name | Visit 4 Last Name of patient |
| Active Debt To Pay | Amount requested to pay Active Debt |
| Bad Debt To Pay | Amount requested to pay Bad Debt |
| Pay Pat Gid | Guarantor ID of Paying Patient |
| Pay Pat Dob | Date of Birth of Paying Patient |
| View | |
| Id Preauth | Unique ID of this agent assisted payment request |
| Feature Name |
Feature name: epic_prepay epic_existing_balance_with_BD Payment |
| Payment Type |
Payment Type: Epic Prepay Epic Existing Balance With BD Payment |
| Dob | Date of birth |
| Zip | Zip Code |
| Unique Id | Unique ID of this agent assisted payment request |
| Notify Method | Notification method |
| Mobile Phone | mobile phone (to send SMS Text) |
| email address | |
| Email Action | Email action (TRUE, blank) |
| Email Template Subject | Subject of email |
| Sms Action | SMS Text action (TRUE, blank) |
| Payment Code Ttl | Time to Live in seconds for the payment code |
| Last Four Digits | Last 4 digits of payment account |
| Transaction Id | Transaction ID of payment |
| Audit | Audit Log |
| Payment Account | Payment Account (not used) |
| Payment Url Id | Payment URL (not used) |
| Scheduled Time | Scheduled Time (not used) |
| Epic Billing Account | Billing Account (not used) |
| Item Summary | Item Summary (not used) |
| Item Paid Summary | Item paid summary (not used) |
| Expiry Mm | Expiration month (not used) |
| Expiry Yy | Expiration year (not used) |
| Payment Method | Payment method |
| Pay Pat First | Paying patient first name |
| Pay Pat Last | Paying patient last name |
| Pay Pat Mobile | Paying patient mobile phone |
| Pay Pat Email | Paying patient email |
| Grand Total | Grand total of request |
Comments