Exhibit 15 DSDS-BATCH_FIN_EXT_PLOG.pdf

23DPP00838

Exhibit 15

BATCH_FIN_EXT_PLOG

INTRODUCTION

The process BATCH_FIN_EXT_PLOG extracts data of all logged county cash payments from reconciled and forced reconciled batches that have not been sent to SDU. This extract will be sent to the SDU.

1.1.1 BATCH_FIN_EXT_PLOG.SP_EXT_PLOG

1.1.1.1. Purpose

This process identifies the county cash collections reconciled or force-reconciled on the batch run date (PROCESS-DATE), moves the data to the temporary table and creates an output file to SDU.

1.1.1.2. Database Tables Affected:

1.1.1.2.1. Driver Tables

CASH_PAYMENT_HEADER

CASH_PAYMENT_DETAILS

1.1.1.2.2. Output Tables

EXTRACT_PLOG

1.1.1.3. Process Description

This process reads the Payments Log Process Receipts (PLOG) screen / CASH_PAYMENT_HEADER and CASH_PAYMENT_DETAILS tables to get the reconciled and force-reconciled county cash collections on the PROCESS-DATE and moves the data to the temporary table EXTRACT_PLOG. An output file will be created using the data in the temporary table EXTRACT_PLOG by UTL_FILE package given by oracle. The steps in this batch process are:

Get the run date and last run date from PARM (Parameters table) and validate that the batch program was not executed for the run date by checking the last run date in the PARM table.

Delete the records in the temporary table EXTRACT_PLOG.

Read the Payments Log Process Receipts (PLOG) screen / PAMENT_LOG_MASTER table and get the batches with the status of Reconciled or Force-reconciled and no File Sent date. Any unreconciled batches at the time of run will be included in the next day run if the batch is reconciled by that time.

Use the following conditions to get the records in Payments Log Process Receipts (PLOG) screen / CASH_PAYMENT_HEADER table (all reconciled and force-reconciled batches which were not yet sent to SDU):

DT_FILE_SENT IS NULL

CD_STATUS = ‘R’-Reconciled, ‘F’-Force Reconciled

DT_END_VALIDITY = '31-DEC-9999'

Records selected for processing by the batch process are immediately locked. This will prevent the user updates using the PLOG screen, to the payment records that are being processed by the batch.

Find the remittance details in Payments Log Process Receipts (PLOG) screen / PAMENT_LOG_DETAILS table for the reconciled and force-reconciled collection batches selected from the Payment Log Master table.

Insert the remittance details to the EXTRACT_PLOG table.

Extract the data from the temporary table EXTRACT_PLOG and create an output file to SDU using the oracle UTL_FILE package.

Generate sequence event global by calling the common procedure.

Update the DT_FILE_SENT with PROCESS-DATE in Payments Log Process Receipts (PLOG) screen / CASH_PAYMENT_HEADER table if the insertion is successful.

Log any errors or successful completion in the BSTL (Batch Status table) for future reference. Abort the job if any error occurs.

Update Last Run date in the PARM table with the run date, upon successful completion.

1.1.1.4. Flow Chart

1.1.1.5. Frequency

Run Daily – to be started at 4:00 PM (final time to be determined)

Should run only on the business days

1.1.1.6. Dependencies

1.1.1.6.1. Predecessors:

1.1.1.6.2. Successors:

The program BATCH_FIN_COLLECTIONS.SP_LOAD_SDU should be executed after a run of this program. If there are no receipts to be extracted from BATCH_FIN_EXT_PLOG, and not due to an error, this should be considered a successful run of the program.

1.1.1.7. Restart Procedures

If any error, restart from the beginning

1.1.1.8. Instructions if Job is skipped

If skipped, all the backlog data need to be processed first.

1.1.1.9. Commit Frequency

One time at end of job

1.1.1.10. Exception Threshold

1.1.1.11. Input File(s)

S.No Name of the File File Format Transfer Mechanism File location Estimated size (in MB’s)

1.1.1.11.1. File Layout

1.1.1.12. Output File(s)

S.No Name of the File File Format Transfer Mechanism File location Estimated size (in MB’s)

1 PLOG-EXTRACT - FTP - -

1.1.1.12.1. File Layout

Field name Position Length Type

C-Char

D-Date

N-Number

Format/

Default value

Description

HEADER

TYPE 1-1 1 C ‘H’

CREATION-DATE 2-9 8 D CCYYMMDD Date when the file is generated

FILLER 10-116 107 C Spaces

DETAIL

TYPE 1-1 1 C ‘D’

CASE-ID 2-12 11 C

Case id

It is blank for Unidentified

Receipts

NCP-NAME 13-17 5 C

NCP’s first 5 characters of Last

Name

NCP-SSN 18-26 9 C

NCP’s SSN

FILLER 27-30 4 C Spaces

RECEIPT-DATE 31-38 8 D CCYYMMDD Receipt Date

RECEIPT-SOURCE 39-40 2 C

Source of the Receipt

REMITTANCE_TYPE 41-43 3 C ‘CSL’ Cash Payment

COLL-CTY-CODE 44-45 2 C

Collection County Code

PAY-AMT 46-56 11 N

Payment amount

NOTE 57-116 60 C

For Unidentified Receipts

TRAILER

TYPE 1-1 1 C ‘T’

TOTAL-PAY-AMT 2-12 11 N

Sum of payment amount

RECORD-COUNT 13-18 6 N

Total number of records

FILLER 19-116 98 C Spaces

Mapping table below shows the tables and the columns from where the information is loaded into output file.

Source Target (Fields in File)

(PLOG-EXTRACT)

‘D’ TYPE

VCSPL.ID_CASE CASE_ID

VCSPL.PAYOR_PARTIAL_NAME NCP-NAME

VCSPL.MEM_SSN NCP-SSN

Spaces FILLER

VCSPL.DT_RECEIPT RECEIPT-DATE

VCSPL.CD_SOURCE_RECEIPT RECEIPT-SOURCE

‘CSH’ REMITTANCE_TYPE

VCSPL.CD_OFFICE COLL-CTY-CODE

VCSPL.AMT_RECEIPT PAY-AMT

VCSPH.NOTES NOTE

1.1.1.13. Contact information

Name of the Agency Technical Contact Functional Contact

1.1.1.14. Stored Procedure / Functions matrix

No Stored Procedure Name/ Arguments Nature of the procedure

/ Function

Description Output Tables / Screens Applicability

I A U D

1 SP_EXT_PLOG Extract Inserting the cash collections created by counties to the temp table extract_plog. Crea ting an output file using the data in the temporary table to SDU.

- VPBAT

VPLOG

Y

Y

2 BATCH_COMMON.SP_GET_RUN_DATE Common Routine Getting Run date - - - - - -

3 BATCH_COMMON.SP_GET_LAST_RUN_DATE Common Routine Getting Last Run date - - - - - -

4 BATCH_COMMON.SP_UPDATE_PARM_DATE Common Routine Updating Last run date - - - - - -

5 SP_BATCH_ERROR_LOG Common Routine Inserting the batch status - - - - - -

6 BATCH_COMMON.SP_BATCH_GENERATE_SEQ Common Routine Generating sequence number - - - - - -