PAYMENT PROCESSING FOR SPECIAL CLIENT

The following specifications are for a new client.

The accounts from this client are going to be related to traffic tickets and will be loaded to the Intelec system as follows:

The client account number will identify the person that got the ticket(s).
There will be one account loaded for every ticket. In many cases we will receive 2 or more tickets for the same person in which case we will generate 2 or more case numbers for the same client account number. This ticket number will be stored in the "Bank" field.
The accounts for this client will be linked by the client account number.
We will also receive a violation date for every ticket, which will be stored on the Patient Last name field.
We will receive a fine amount, which will be loaded in the Primary Balance field.
We will receive a surcharge amount, which will be loaded in the Balance Type 7 field.

The payments are to be applied and distributed according to the following rules:

Payments are to be distributed along the linked accounts (tickets) in the following order:

Violation date (oldest ticket first) (Patient last name – date in YYMMDD format)

Ticket number (ascending order) (Bank)

Payments must be applied to all the surcharge amounts (Balance type 7) first, and to the fine amounts (Primary) second.
We must pay off all the tickets (Primary and Balance 7) for one validation date, before we can proceed to apply payments to the tickets of the next violation date.
Surcharges cannot be partially paid. If a payment cannot payoff the total amount of a surcharge, the whole payment must be rejected. If a payment cannot cover the amount of the first surcharge it can be applied to the next surcharge for the same violation date. Fine amounts (Primary) can be partially paid.
Files that are in dispute are not to have payments applied until the dispute is resolved, therefore files that are in dispute must not be included in the above sequencing. The dispute files will have a ‘D’ in the GPATF field.

Let’s imagine the following 3 accounts for same person. 2 tickets on 01/01/01 and 1 ticket on 05/01/01.

In the example above the minimum payment that could be received from this motorist is $30.00.

Payments would applied as follows:

Payment Amount	Case#	Ticket Number	Balance Type	Payment	COMMENTS
$30.00	71-2	78911	7	$30.00	Only the 2^nd surcharge can be paid.
$40.00	71-1	12345	7	$40.00	Only the 1^st surcharge can be paid.
$50.00	71-1	12345	7	$40.00	The 1^st surcharge could be paid, but:
	72-2	78911	7	$10.00	The remaining $10 cannot pay off the next surcharge of $30, therefore the $50 payment must be rejected.
$90.00	71-1	12345	7	$40.00
	71-2	78911	7	$30.00	Both surcharges are paid.
	71-1	12345	P	$20.00	So the remaining $20 are applied to principal.
$500.00	71-1	12345	7	$40.00
	71-2	78911	7	$30.00	Both surcharges are paid.
	71-1	12345	P	$100.00
	71-2	78911	P	$200.00	Both principals are also paid.
	71-3	33355	7	$100.00	So it can start applying to the next violation date.
	71-3	33355	P	$30.00	The remaining $30 are applied to the principal.
$400.00	71-1	12345	7	$40.00
	71-2	78911	7	$30.00
	71-1	12345	P	$100.00	All the surcharges and fines for the tickets of the first validation date are paid, but:
	71-2	78911	P	$200.00
	71-3	33355	7	$30.00	The remaining $30 cannot pay off the $100 surcharge of the ticket of the next validation date, therefore the $400 payment must be rejected.