Billing Module Functional Spec

Design Spec

 

UI Designs (Dropbox Link

 


 

Functional Spec

Introduction

The billing module is designed to be replacement and improvement for the existing billing module in use at JSS.

 

Goals

  1. Track payments
  2. Allow flexible costs
  3. Support partial payments
  4. Resolve the pain points of the current billing system at JSS

Out of Scope

  1. Integration with other modules (May come into scope, later)
    1. Integrate with pharmacy
    2. Integrate with all other modules, as appropriate
  2. Support payment of insurance via RSBY

 

Functionality

  1. Track payments for 
    1. Doctor's consultation
    2. Prescription drugs
  2. Allow flexible costs
    1. Doctors should be able to discount any drug price based on patient's individual needs and situation
  3. Support partial payments
    1. Patients must be able to pay only part of a bill during a given visit
    2. Patients are expected to pay remainder during one or more follow-up visit(s)
    3. Payments should be clearly separated and relate to specific items
  4. Resolve the pain points of the current billing system at JSS
    1. Difficult to track discounts, partial payments, insurance payments
    2. sometimes finances are associated with the wrong if paid later (insurance, partial payments)
    3. Problem with calculator for discounted payments – math is incorrect

 

Open Issues

These are questions we don't know answers to... need input from JSS, others to answer them. Once answered, should update this document with the answer and track it here.

 

Need to be aware of when bills were issued and when bills were paid
-Insurance RSBY
-partial payments in visit 1, follow up payment in visit 2

1 or more default prices for each item

some things covered by RSBY, some not
-medication not covered by RSBY
-"toe cut off" is covered

Can we integrate into RSBY or other payment systems (NFC)?

Approval (before bill can be issued to the patient)
-> might have "auto approve default prices"
-> might have "auto approve discounted prices"
-> might "only allow prices to be "
vs 
Auditing (after the payment and everything has occured)

logging for later auditing
history of all price changes with name / date associated?

 


 

Developer Spec

Front-end Architecture

Discuss views, controllers, models, stores you'll need. How will you build these in the ExtJS app?

REST Resources

Discuss REST resources you'll need to call on the back-end.

Database Design

Per an initial discussion, the database model may include the following tables. This needs more investigation before being confirmed. Please research existing billing tools and how they model financial transactions, bills, partial payments, discounts, etc.

Billing
status - pending, paid, partially paid, approved
patient
provider - whoever does the billing, e.g. clerk
has many: items

BillingItem
concept (concept - drug, labTest, etc)
quantity
how much it costs (value)
link to what made it - link to order ID or Encounter
provider
has many: item adjustments

BillingItemAdjustment
BillingItem
Reason
Value

Price
concept
quantity
value

(Might need more columns for any item)

Repositories

Backend Resources go into RaxaCore - https://github.com/Raxa/raxacore

Front-end Resources go into Raxa-JSS - https://github.com/Raxa/Raxa-JSS