The Cash Over Time Data Tape – Daily Rollforward is a report that helps you keep track of the daily status and updates of payment plans at HFD. It offers detailed information on each loan, including origination details, payment history, balance changes, and current status. This makes it easy for providers to monitor their portfolio’s performance and make informed decisions.
Glossary
| Field | Description |
Product Type | The name of the loan product that was used for the selected application. |
Patient Transfer ID | This column will have the ID of the patient that the loan was transferred from, it if was transferred from another office. |
Application ID | The unique identifier for the Contract. |
First Name | The first name of the person who applied for financing. |
Last Name | The last name of the person who applied for financing. |
DOB | The date of birth of the person who applied for financing. |
Last4 (SSN) | The last 4 of the social security number of the person who applied for financing. |
Provider ID | The unique identifer of the provider that originated the loans. |
Company ID | An open text field that providers can use to help identify the Provider. |
Unique Patient ID | Unique patientidentifier entered by the practice at origination. |
Order Date | The original date of the application creation date. |
Docd YM | The year and month that the application was financed. |
State | The state in which the application was originated. |
Activate Date | The date that the application was executed and the agreement was signed. |
Activated YM | The year and month that the application was executed and the agreement was signed. |
Treatment Amount | The total service cost of the treatment received. |
Down Payment | The initial payment that was charged on the activate date. |
Florida Stamp Tax | A documentation tax, only relevant for retail installment contracts originated in the state of Florida. |
Original Term | The original term (length) of the contract represented in months. |
Original Maturity | The original estimation of the maturity date (when the final loan payment is due). |
Original Pmt | The first scheduled payment at origination of the contract. |
Interest Rate | The interest rate of the contract. |
Financed Amount | The amount the patient was approved to be financed under this contract. |
Pricing Code | The loan program the contract is based on. |
Report Beg | The beginning of the reporting period for this report. |
Report End | The ending date of the reporting period for this report. |
Payment Status | Current payment status at time report is generated |
Beg Bal | Principal balance up to Report Beg date. |
Originations | If the contract is activated during the report date then report the Financed Amount, otherwise this will be 0. |
Cancelled Amount | If the contract is activated during report date then report the Financed Amount, otherwise this will be 0. |
Refund Amount | If the contract is activated during the report date then report the Financed Amount, otherwise, this will be 0. |
Total Payment Amount | The total amount paid during the report period. |
Principal Payment | The principal amount paid during the report period. |
Interest Payment | The amount of interest paid during the report period. |
Adjustment Amount | The amount of adjustments made during the report period. |
Write Off Amount | The amount that was written off during the report period. |
Ending Principal Balance | The principal balance at the end of the reporting period. |
Promo Code | The promo code applied to the application. |
Updated Term | The most up to date term for the contract. |
Current Maturity | The most up-to-date term for the contract. |
Current Payment | The new payment according to modified terms schedule |
Cancel Date | The new payment according to the modified terms schedule |
Write Off Date | The last write off entry during the reporting period. |
Last Payment Date | The last payment received during the reporting period. |
Next Payment Date | The next payment estimated based on the status on the report end date. |
First Expected Pmt Date | The first expected payment date based on the original amortization schedule. |
Loan Start Date | The original loan date based on the initial amortization. |
First Recd Payment Date | The first recorded payment date. |
Expected Payoff | The expected payoff date of the contract. |
Remaining Term | The remaining term based on any modification to the terms date. |
Pmt Arrangement | The payment arrangement if the contract has one. |
CreditGrade | The credit grade used in originating the loan. |
Credit Score | The credit score used in originating the loan. |
Ending Aging | The Days Past Due as of the end date. |
Loan Mod Date | The date modified terms were recorded. |
Serviced Status | The value will be Y if the ending principal balance >0, otherwise it will be 0. |