Exhibit 11 DSDS-BATCH_FIN_EXT_CHECK.pdf

23DPP00838

Exhibit 11

BATCH_FIN_EXT_CHECK

INTRODUCTION

The process BATCH_FIN_EXT_CHECK runs after the disbursement process. Disbursement process generates disbursement details, determines the disburse medium for each of the fund recipients and writes into Disbursement header and detail logs.

This process identifies all check disbursements requiring check number assignment and assigns check numbers sequentially by incrementing the last used check number. The process also generates a check print file to the SDU vendor.

1.1.1 BATCH_FIN_EXT_CHECK.SP_CHECK_PRINTING

1.1.1.1. Purpose

This process extracts all check disbursements requiring check number assignment and assigns check numbers sequentially by incrementing the last used check number.

The process check print file for printing checks.

1.1.1.2. Database Tables Affected:

1.1.1.2.1. Driver Tables

> LOG_DISBURSMENT_HEADER (DSBH)

1.1.1.2.2. Output Tables

> LOG_DISBURSMENT_HEADER (DSBH)

> LOG_DISBURSEMENT_ADDRESS (DADR)

> COUNTY_OPTIONS (COPT)

> GLOBAL_EVENT (GLEV)

> EXTRACT_CHECK

1.1.1.3. Process Description

The process extracts the issued checks from current disbursement with no check number from the Disbursement View (DSBV) screen / LOG_DISBURSEMENT_HEADER (DSBH) table. The system generates the check number by incrementing the last check number used from LOG_DISBURSEMENT_HEADER (DSBH) table and updates the disbursement header LOG_DISBURSEMENT_HEADER (DSBH) table which can be viewed on Disbursement View (DSBV) screen. The process also generates a file for printing checks.

- 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 ensuring that the run date is different from the last run date in the PARM table.

Otherwise, an error message to that effect will be written into the Batch Status Log (BSTL) screen / BATCH_STATUS_LOG (BSTL) table and terminate the process.

-Select the Check disbursements from the Disbursement View (DSBV) screen / LOG_DISBURSEMENT_HEADER (DSBH) table using the following conditions (all outstanding checks without a check number)

CD_MEDIUM_DISBURSE = ‘C’ -- CHECK

CD_STATUS_CHECK = 'OU' -- OUTSTANDING

TRIM (NO_CHECK) IS NULL

DT_DISBURSE <= RUN-DATE

DT_END_VALIDITY = '31-DEC-9999'

-Get the mailing address from ADDRESS_HISTORY (AHIS) if the recipient is either CP or NCP. Identify the recipient using the CD_CHECK_RECIPIENT as ‘1’ in the Disbursement View (DSBV) screen / LOG_DISBURSEMENT_HEADER (DSBH) table for the CP/NCP. Use the following conditions in MEMBER ADDRESS HISTORY (AHIS) screen / ADDRESS_HISTORY (AHIS) table to get the address

ID_MEMBER = RECIPIENT ID

CD_TYPE_ADDRESS = ‘M’ – Mailing address

RUN-DATE BETWEEN DT_BEGIN AND DT_END

AND CD_STATUS IN (‘Y’) – confirmed as good AND DT_END = '31-DEC-99' – non-end dated

-Get the mailing address from FIPS_CODES (FIPS) if the recipient is an agency. Identify the recipient using the CD_CHECK_RECIPIENT as ‘2’ in Disbursement View (DSBV) screen / LOG_DISBURSEMENT_HEADER (DSBH) table for the agency. Use the following conditions in FEDERAL INFORMATION PROCESSING STANDARDS (FIPS) screen / FIPS_CODES (FIPS) table to get the address

CD_STATE_FIPS = SUBSTR(RECIPIENT ID, 1, 2)

CD_TYPE_ADDRESS = ‘P’ (Payment processing)

-Get the mailing address from OTHER PARTY screen / OTHER_PARTY (OTHP) table if the recipient is other party. Identif y the recipient using the CD_CHECK_RECIPIENT as ‘3’ in Disbursement View (DSBV) screen /

LOG_DISBURSEMENT_HEADER (DSBH) table for other party. Use the following conditions in OTHER PARTY screen /

OTHER_PARTY (OTHP) table to get the address.

ID_OTHER_PARTY = RECIPIENT ID

-Get the interstate case id (OTH_STATE_ID_CASE) for the interstate cases from the INTERSTATE_CASES (ICRT) table by matching the ID_CASE.

-Generate a sequence number and insert into GLOBAL_EVENT (GLEV)

-Insert the check disbursement address details for disbursing the check in LOG_DISBURSEMENT_ADDRESS (DADR) table to view the disbursement details in Disbursement View (DSBV) screen. In addition to the disbursement details, we are also inserting “NAME_PAYEE” column which is retrieved from VDEMO, VFIPS or VOTHP based on the recipient type of

‘1’, ‘2’ or ‘3’ respectively. And when the disbursement is a Joint Tax Refund, “NAME_PAYEE” column will be retrieved from VRCTH.

-Create the check number by selecting the last check number from the VDSBH table and incrementing by 1 for each individual check and update the NO_CHECK field in Disbursement View (DSBV) screen

/ LOG_DISBURSEMENT_HEADER (DSBH) table for the check disbursements.

-Find the maximum control number created in Disbursement View (DSBV) screen / LOG_DISBURSEMENT_HEADER

(DSBH) table, increment by 1 and update ID_MISC field on LOG_DISBURSEMENT_HEADER (DSBH) table which can be viewed on the Disbursement View (DSBV) screen.

-Update the DT_STATUS_CHECK field with PROCESS-DATE in Disbursement View (DSBV) screen /

LOG_DISBURSEMENT_HEADER (DSBH) table for the check disbursements.

-Create an output file using the below mentioned format to print the checks.

> Use the above identified check disbursements from VDSBH.

> Format the CHECK_AMOUNT and CHECK_COLL_DATE.

> Use the oracle UTL_FILE package to create the file.

> One record will be inserted in the file for each check.

-Log the error encountered or successful completion in the BATCH STATUS LOG Screen / BATCH_STATUS_LOG

(BSTL) table for future references.

-Update last run date in the PARM table with the run date, upon successful completion.

1.1.1.4. FlowChart

1.1.1.5. Frequency

Daily

1.1.1.6. Dependencies

1.1.1.6.1. Predecessors:

The program BATCH_FIN_DISBURSEMENT.SP_DISB_RECOUP should be executed successfully before running this program.

1.1.1.6.2. Successors:

None.

1.1.1.7. Restart Procedures

Restart the job from the last commit point

1.1.1.8. Instructions if Job is skipped

Job cannot be skipped.

1.1.1.9. Commit Frequency

Onetime at end of the job

1.1.1.10. Exception Threshold

N/A

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

N/A

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 EXT_CHECK_DISBURSEMENT.

TXT

- FTP - -

1.1.1.12.1. File Layout

Field Name

Position

Length

Type

C-Char

D-Date

N-Number

Format / Default Value

Description

FILLER

1-2

C

Spaces Spaces

CHECK_NUMBER

3-11

Check number

CHK-CASE-ID

12-22

Case Number

CP_NAME_LAST

23-42

CP Name Last

CP_NAME_FIRST

43-57

CP Name First

CP_NAME_MI

58-58

CP Name Middle Initial

CP NAME SUFFIX

59-62

CP Name Suffix

NCP_NAME_LAST

63-82

NCP Name Last

NCP_NAME_FIRST

83-97

NCP Name First

NCP_NAME_MI

98-98

NCP Name Middle Initial

NCP NAME SUFFIX

99-102

NCP Name Suffix

CHECK_MESSAGE_LINE 1

103-162

Line 1 of message entered on RERT for refunds (60 C).

CHECK_MESSAGE_LINE 2

163-222

Line 2 of message entered on RERT for refunds (60 C).

CHECK_MESSAGE_LINE 3

223-282

Line 3 of message entered on RERT for refunds (60 C).

CHECK_MESSAGE_LINE 4

283-342

Line 4 of message entered on RERT for refunds (60 C).

CHECK_DATE

343-350

D

CCYYMMDD Check Date

CHECK_AMOUNT

351-361

N

Ex: $50.25 will be sent as '00000005025'

Check amount

CHECK_COLL_DATE

362-369

D

CCYYMMDD Receipt date

CHECK_PAYEE_NAME

370-429

Payee Name

CHECK_PAYEE_ATTN/CARE OF

430-469

Person or Entity through whom the check is delivered to Payee

CHECK_PAYEE_ADD_LINE1

470-519

Check Payee address line 1

CHECK_PAYEE_ADD_LINE2

520-569

Check Payee address line 2

CHECK_PAYEE_ADD_CITY

570-597

Check Payee address city

CHECK_PAYEE_ADD_STATE

598-599

Check Payee address state (standard two character abbreviation)

CHECK _PAYEE_ADD_ZIP 600-614 15 C Check Payee address zip code

CHECK_PAYEE_ADD_COUNTRY

615-616

Check Payee address country (standard two character abbreviation)

CHECK_SDUCONTRACTOR_NAME1

617-676

Official Name of the SDU Contractor

CHECK_SDUCONTRACTOR_NAME2

677-706

Doing business as Name for SDU Contractor

CHECK_SDUCONTRACTOR_ADDR1

707-756

Address line 1of the SDU Contractor

CHECK_SDUCONTRACTOR_ADDR2

757-806

Address line 2 of the SDU Contractor

CHECK_SDUCONTRACTOR_ADDR_CITY

807-834

Address city of the SDU Contractor

CHECK_SDUCONTRACTOR_ADDR_STATE

835-836

Address state of the SDU Contractor (standard two character abbreviation)

CHECK_SDUCONTRACTOR_ADDR_ZIP

837-851

Address zip code of the SDU Contractor

CHECK_FOREIGN_ST_CASE_NO 852-866 15 C Interstate case ID

Mapping table shown below displays the table names and the columns from where the information is loaded into output file.

Source Target(CHECKIMG)

VDSBH.NO_CHECK CHECK_NO

VDSBL.ID_CASE CHK-CASE-ID

VDEMO.NAME_LAST, VDEMO.NAME_FIRST,VDEMO.NAME_MI,VDEMO.NAME_SUFFIX CHECK-CLIENT-NAME-STUB

VDEMO.NAME_LAST, VDEMO.NAME_FIRST,VDEMO.NAME_MI,VDEMO.NAME_SUFFIX CHECK-OBLIGOR-NAME-STUB

VSTUB.NOTE1 CHECK_MESSAGE_LINE 1

VSTUB.NOTE2 CHECK_MESSAGE_LINE 2

VSTUB.NOTE3 CHECK_MESSAGE_LINE 3

VSTUB.NOTE4 CHECK_MESSAGE_LINE 4

Batch Process Date CHECK_DATE

VDSBH.AMT_DISBURSE CHECK_AMOUNT

VRCTH.DT_RECEIPT CHECK_COLL_DATE

VDEMO.NAME_FIRST,VDEMO.NAME_MI, VDEMO.NAME_LAST, VDEMO.NAME_SUFFIX, if

CD_CHECK_RECIPIENT=’1’ and CD_TYPE_DISBURSE is Not ‘REFND’ in VDSBL

Or

VOTHP.NAME_OTHER_PARTY if the CD_CHECK_RECIPIENT=’3’ in VDSBH

Or

VFIPS.NAME_FIPS if CD_CHECK_RECIPIENT=’2’ in VDSBH or

If the CD_TYPE_DISBURSE is ‘REFND’ in VDSBL and the IND_TAX_JOINT = ‘J’ – Joint in VRCTH then NAME_TAX_JOINT will be moved

CHECK_PAYEE_NAME

VAHIS.ADDR_ATTN CHECK_PAYEE_ATTN/CARE OF

VAHIS.ADDR_LINE1 /

VFIPS.ADDR_LINE1 where CD_TYPE_ADDRESS = ‘STA’ and CD_SUB_TYPE_ADDRESS = ‘SDU’

-- For International FIPS

VFIPS.ADDR_LINE1 where CD_TYPE_ADDRESS = ‘INT’ and CD_SUB_TYPE_ADDRESS = ‘FRC’

VOTHP.ADDR_LINE1

CHECK_PAYEE_ADD_LINE1

VAHIS.ADDR_LINE2 /

VFIPS.ADDR_LINE2 where CD_TYPE_ADDRESS = ‘STA’ and CD_SUB_TYPE_ADDRESS = ‘SDU’

-- For International FIPS

VFIPS.ADDR_LINE2 where CD_TYPE_ADDRESS = ‘INT’ and CD_SUB_TYPE_ADDRESS = ‘FRC’

VOTHP.ADDR_LINE2

CHECK_PAYEE_ADD_LINE2

VAHIS.ADDR_CITY /

VFIPS. ADDR_CITY where CD_TYPE_ADDRESS = ‘STA’ and CD_SUB_TYPE_ADDRESS = ‘SDU’

-- For International FIPS

VFIPS. ADDR_CITY where CD_TYPE_ADDRESS = ‘INT’ and CD_SUB_TYPE_ADDRESS = ‘FRC’

VOTHP. ADDR_CITY

CHECK_PAYEE_ADD_CITY

VAHIS.ADDR_STATE /

VFIPS. ADDR_STATE where CD_TYPE_ADDRESS = ‘STA’ and CD_SUB_TYPE_ADDRESS = ‘SDU’

-- For International FIPS

VFIPS. ADDR_STATE where CD_TYPE_ADDRESS = ‘INT’ and CD_SUB_TYPE_ADDRESS = ‘FRC’

VOTHP.ADDR_ STATE

Space

VREFM.DESC_VALUE matching CD_VALUE = VAHIS.ADDR_COUNTRY / VFIPS.ADDR_COUNTRY

/ VOTHP.ADDR_COUNTRY AND ID_TABLE = ‘CTRY’ AND ID_TABLE_SUB = ‘CTRY’ if VAHIS.

ADDR_COUNTRY / VFIPS.ADDR_COUNTRY / VOTHP.ADDR_COUNTRY <> ‘US’

CHECK_PAYEE_ADD_STATE

OR

CHECK_PAYEE_ADD_COUNTRY

VAHIS.ADDR_ZIP /

VFIPS. ADDR_ZIP where CD_TYPE_ADDRESS = ‘STA’ and CD_SUB_TYPE_ADDRESS = ‘SDU’

-- For International FIPS

VFIPS. ADDR_ZIP where CD_TYPE_ADDRESS = ‘INT’ and CD_SUB_TYPE_ADDRESS = ‘FRC’

VOTHP.ADDR_ ZIP

CHECK_PAYEE_ADD_ZIP

SDUCONTRACTOR Information from OTHP – OFFICE100 CHECK_SDUCONTRACTOR_NAME1

SDUCONTRACTOR Information from OTHP – OFFICE100 CHECK_SDUCONTRACTOR_NAME2

SDUCONTRACTOR Information from OTHP – OFFICE100 CHECK_ SDUCONTRACTOR_ADDR1

SDUCONTRACTOR Information from OTHP – OFFICE100 CHECK_ SDUCONTRACTOR_ADDR2

SDUCONTRACTOR Information from OTHP – OFFICE100 CHECK_ SDUCONTRACTOR_ADDR_CITY

SDUCONTRACTOR Information from OTHP – OFFICE100 CHECK_SDUCONTRACTOR_ADDR_STATE

SDUCONTRACTOR Information from OTHP – OFFICE100 CHECK_SDUCONTRACTOR_ADDR_ZIP

INTERSTATE_CASES.OTH_STATE_ID_CASE CHECK_FOREIGN_ST_CASE_NO

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_CHECK_PRINTING Processing and Extracting Populating check # for the Check disbursements and creating an output file to

- VDSBH Y - Y -

print the checks. VAHIS Y - - -

VFIPS Y - - -

VOTHP Y - - -

VDADR - Y - -

VDEMO Y - - -

VDSBL Y - - -

VRCTH Y - - -

VICAS Y - - -

VCMEM Y - - -

VSTUB Y - - -

EXTRACT_CHECK - Y - -

VREFM Y - - -

2 BATCH_COMMON.SP_GET_BATCH_DETAILS Common Routine Returns batch Run date, Last Run date, Out file location.

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 BATCH_COMMON.SP_BSTL_LOG Common Routine Inserting the batch status - - - - - -

6 BATCH_COMMON.

SP_RAISE_APPLICATION_ERROR

Common Routine This procedure is used to display the error occurred due to unhandled exceptions

7 BATCH_COMMON.

SP_BATCH_RESTART_UPDATE

Common Routine This procedure is used to insert / update restart key value in VRSTL table using input job id and Run date.

8 BATCH_COMMON.SP_BATE_LOG Common Routine This procedure is used to insert the unprocessed record error codes into VBATE table.

9 BATCH_COMMON.SP_EXTRACT_DATA Common Routine Creating a text file from the table - - - - - -