Exhibit 8 DSDS-BATCH_FIN_EFT_SVC_PNOTE_DISB~1.pdf

23DPP00838 1 | P a g e

Exhibit 8

BATCH_FIN_EFT_SVC_PNOTE_DISB

INTRODUCTION

The process BATCH_FIN_EFT_SVC_PNOTE_DISB extracts data relating to Pre-note for new EFT instructions created on CPs and County FIPS. No Pre-note will be created for EFT instructions on Interstate FIPS.

In addition, if the Funds Recipient has EFT/Stored Value Instructions in active status, the data relating to daily EFT disbursements of CPs, Interstate FIPS, County and data relating to daily stored value card disbursements of CPs will be extracted. This file will be delivered to SDU Contractor.

1.1.1 BATCH_FIN_EFT_SVC_PNOTE_DISB.SP_EXTRACT_EFT_SVC_PNOTE_DISB

1.1.1.1. Purpose

The process extracts

EFT pre-notes to CPs, EFT disbursements to CP’s, Interstate Agencies , CWA and DYFS Stored value card disbursements to CPs, and creates a file to be sent to SDU Contractor.

1.1.1.2. Database Tables Affected:

1.1.1.2.1. Driver Tables

LOG_DISBURSMENT_HEADER (DSBH)

ELECTRONIC_FUND_TRANSFER (EFTR)

DEBITCARD_RECIPIENTS (DCRS)

CREC_DISBURSEMENTS(VCRDB)

LOG_DISBURSEMENT_DETAIL(VDSBL)

1.1.1.2.2. Output Tables

LOG_DISBURSMENT_HEADER (DSBH)

ELECTRONIC_FUND_TRANSFER (EFTR)

LOG_DISBURSEMENT_EFT (DEFT)

GLOBAL_EVENT (GLEV)

CREC_DISBURSEMENTS(VCRDB)

1.1.1.3. Process Description

This procedure extracts the ready-for-disbursement records of all CPs/Interstate Agencies/Counties that have active EFT instructions and the ready-for-disbursement records of CPs with active Stored Value cards instructions.

The disbursement records are chosen from Disbursement View (DSBV) screen/ LOG_DISBURSMENT_HEADER (DSBH) and Bank account information is taken from the Manage EFT Instructions (EFTI) screen / ELECTRONIC_FUND_TRANSFER (EFTR) table for EFT and Stored Value Card Instructions (SVCI) screen / DEBITCARD_RECIPIENTS (DCRS) for SVC. In addition, the pre-note of CPs for activating EFT are extracted into the same file from Manage EFT Instructions (EFTI) screen/ELECTRONIC_FUND_TRANSFER (EFTR) table.

An output file is created in CCD+/PPD format to the SDU Contractor.

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 Batch Status Log (BSTL) screen / BATCH_STATUS_LOG (BSTL) table and the process will be terminated.

For EFT Disbursements:

EFT disbursements ready to be sent out to CPs, Agencies and County EFT disbursement from Disbursement View (DSBV) screen/ LOG_DISBURSMENT_HEADER (DSBH) table are selected using the following conditions:

23DPP00838 3 | P a g e

CD_MEDIUM_DISBURSE = 'E' -- EFT

CD_STATUS_CHECK = 'TR' -- TRANSFER EFT

TRIM (ID_MISC) IS NULL

DT_DISBURSE <= PROCESS-DATE

DT_END_VALIDITY = '31-DEC-9999'

23DPP00838 4 | P a g e

CD_STATUS_CHECK = 'TR' -- TRANSFER EFT

TRIM (ID_MISC) IS NULL

For all the selected records, active EFT instructions (Bank Routing Number, Account Number and Type of Account) of the Funds Recipient are extracted from Manage Electronic Funds (EFTI) screen/ ELECTRONIC_FUND_TRANSFER (EFTR) table.

ID_CHECK_RECIPIENT = RECIPIENT_ID

CD_STATUS_EFT = ‘AC’ -- ACTIVE

CD_CHECK_RECIPIENT = ‘1’ – for CP

‘2’ – for FIPS ‘3’ – for CWA/DYFS

Create the Control number and update the ID_MISC field in Check View (DSBV) screen/LOG_DISBURSMENT_HEADER (DSBH) table for each of the EFT disbursements.

Find the maximum ID_MISC number created in Disbursement View (DSBV) screen/LOG_DISBURSMENT_HEADER (DSBH) table, increment by 1 and update the Disbursement View (DSBV) screen / LOG_DISBURSMENT_HEADER (DSBH) table for the EFT disbursement.

Update the DT_ISSUE field with Job run date (PROCESS-DATE) in Disbursement View (DSBV) screen / LOG_DISBURSMENT_HEADER (DSBH) table for the EFT disbursement.

Insert a record into LOG_DISBURSEMENT_EFT (DEFT) 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, VSTAT 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.

For recipient type ‘2’, name payee/ name of other state is retrieved from VSTAT based on the first two characters of the FIPS code using the following condition

FROM VFIPS c, VSTAT s WHERE c.id_fips = RECIPIENT_ID

AND s.cd_state_fips = SUBSTR (RECIPIENT_ID, 1, 2) AND c.dt_end_validity = ’31-dec-9999’

AND ROWNUM <= 1;

For SVC (Stored Value Card) Disbursements:

Select all the CP’s SVC (Stored Value Card) disbursement from Disbursement View (DSBV) screen / LOG_DISBURSMENT_HEADER (DSBH) table using the following conditions

CD_CHECK_RECIPIENT = ‘1’

CD_MEDIUM_DISBURSE = 'B'

CD_STATUS_CHECK = 'TR'

TRIM (ID_MISC) IS NULL

Find the SVC (Stored Value Card) instructions (account number and SVC number) of the CHECK_RECIPIENT in Stored Value Card Instructions (SVCI) screen / DEBITCARD_RECIPIENTS (DCRS) table.

23DPP00838 5 | P a g e

ID_CHECK_RECIPIENT = RECIPIENT ID

CD_STATUS = 'A' -- ACTIVE

Create the Control number and update the ID_MISC field in Disbursement View (DSBV) screen / LOG_DISBURSMENT_HEADER (DSBH) table for the SVC disbursements.

Find the maximum ID_MISC number created in Disbursement View (DSBV) screen / LOG_DISBURSMENT_HEADER (DSBH) table, increment by 1 and update the Disbursement View (DSBV) screen / LOG_DISBURSMENT_HEADER (DSBH) table for the SVC disbursements.

Update the DT_ISSUE field with Job run date (PROCESS-DATE) in Disbursement View (DSBV) screen / LOG_DISBURSMENT_HEADER (DSBH) table for the SVC disbursements.

Insert a record into LOG_DISBURSEMENT_EFT (DEFT) 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.

For CP EFT pre-notes:

Select all the EFT pre-notes from the Manage EFT Instructions (EFTI) screen / ELECTRONIC_FUND_TRANSFER (EFTR) table which satisfy the following conditions

CD_STATUS_EFT = 'PP' – Pre-note Pending

PRENOTE_DATE <= PROCESS-DATE

Generate the Control number (max + 1) and update the ID_MISC field in Manage EFT Instructions (EFTI) screen / ELECTRONIC_FUND_TRANSFER (EFTR) table

Update the CD_STATUS_EFT field in Manage EFT Instructions (EFTI) screen / ELECTRONIC_FUND_TRANSFER (EFTR) table to ‘PG’ – Pre-note Generated for the selected EFT pre-notes.

For EFT Disbursements of Recoupments for State and SDU:

Recoupment EFT disbursements ready to be sent out to State(OFFICE900) and SDU(OFFICE100) are selected using the following criteria from CREC_DISBURSEMENTS(CRDB) table

TRIM (ID_MISC) IS NULL

For all the selected records, active EFT instructions (Bank Routing Number, Account Number and Type of Account) of the Funds Recipient are extracted from Manage Electronic Funds (EFTI) screen/ ELECTRONIC_FUND_TRANSFER (EFTR) table.

ID_CHECK_RECIPIENT IN (OFFICE100,OFFICE900)

CD_STATUS_EFT = ‘AC’ -- ACTIVE

Create the Control number and update the ID_MISC field in CREC_DISBURSEMENTS (CRDB) table for each of the EFT disbursements.

Find the maximum ID_MISC number created in LOG_DISBURSMENT_HEADER (DSBH) table, increment by 1 and

23DPP00838 6 | P a g e update in CREC_DISBURSEMENTS (CRDB) table for the EFT disbursement.

Update the DT_ISSUE field with Job run date (PROCESS-DATE) in CREC_DISBURSEMENTS (CRDB) table for the EFT disbursement.

• Insert a record into LOG_DISBURSEMENT_EFT (DEFT) to view the disbursement details in Electronic Funds Transfer Report

(REFT) screen.

23DPP00838 8 | P a g e

Creating the output file in CCD+ and PPD formats as applicable

INDV-PAYEE-NAME field in the output file will be populated for the disbursements with the FIPS code of the Case Id and the control # of the disbursement.

Create an output file using the above information (EFT disbursement, stored value card disbursement and EFT pre-notes) in the CCD+ format and PPD formats with the relevant bank information that is being sent to the bank.

Recoupment EFT disbursement for State/SDU will be sent in the CCD format with 5, 6 and 8 record type format. This will follow the same format as in agency disbursement without addenda record.

Any number of Detail records can be written per batch. The Addenda records are included only for Agency disbursement.

Log the error encountered or successful completion in Batch Status Log (BSTL) screen / BATCH_STATUS_LOG (BSTL) table for future references.

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

1.1.1.4. Flow Chart

23DPP00838 9 | P a g e

23DPP00838 10 | P a g

1.1.1.5. Frequency

Daily

1.1.1.6. Dependencies

23DPP00838 11 | P a g

1.1.1.6.1. Predecessors:

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

1.1.1.6.2. Successors:

N/A

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

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 EFT_OUTPUT_FILE CCD+ and PPD FTP - -

1.1.1.12.1. File Layout

Field Name Type

C-Char D-Date

N-Number

Length Format

BEGIN-HEADER

TYPE (“1”) CHAR 1

PRIOR-CODE (“01”) CHAR 2

DESTINATION (“ 031207607”) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) CHAR 10

ORIGIN (“2216000928”) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) CHAR 10

TRANSACTION-DATE1(JOB RUN DATE) CHAR 6 YYMMDD

TRANSACTION-TIME1 (SYSTIME) CHAR 4 HHMI

FILE-ID-MODE (“A”) CHAR 1

RECORD-SIZE (“094”) CHAR 3

BLOCKING-FAC (“10”) CHAR 2

FORMAT-CODE (“1”) CHAR 1

23DPP00838 12 | P a g

DESTIN-NAME (“PNC BANK”) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) CHAR 23

ORIGIN-NAME (“ST OF NJ CHILD SUPPORT”) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) CHAR 23

23DPP00838 13 | P a g e

REFERENCE-CODE CHAR 8

BATCH-BEGIN-HEADER for EFT TO COUNTY OFFICE

REC-TYPE5 (“5”) CHAR 1

SERV-CLASS-CODE5 (“200”) CHAR 3

CO-NAME-OUTOFSTATE (“NKJIDSAGENCY”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 16

CO-DISC-DATA CHAR 20

CO-ID-EFT-COUNTY (“6216000928”) (REFM reference code type ‘BANK’ and Code sub type ‘ACHD’) CHAR 10

ENTRY-CLASS-CODE (“CCD”) CHAR 3

CO-ENTRY-DESC-EFT-COUNTY (“KIDSAGENCY”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 10

DESC-DATE5 (JOB RUN DATE) CHAR 6 MMDDYY

EFFECTIVE-ENTRY-DATE

(JOB RUN DATE + 2 business days; consider the state holidays in VSHOL table)

CHAR 6 YYMMDD

JULIAN-DATE (of EFFECTIVE_ENTRY_DATE) CHAR 3

ORIGIN-STATUS-CODE (“1”) CHAR 1

ORIGIN-DFI-ID (“03120760”) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) CHAR 8

BATCH-NO5 NUMBER 7

BATCH-BEGIN-HEADER for EFT TO CLIENT

CO-NAME-EFT-CLIENT (NJKIDSDIRDEP”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 16

CO-DISC-DATA CHAR 20

CO-ID-EFT-CLIENT (“4216000928”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 10

ENTRY-CLASS-CODE (“PPD”) CHAR 3

CO-ENTRY-DESC-EFT-CLIENT (“KIDSDIRDEP”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 10

DESC-DATE5 (JOB RUN DATE) CHAR 6 MMDDYY

EFFECTIVE-ENTRY-DATE

(JOB RUN DATE + 2 business days; consider the state holidays in VSHOL table)

CHAR 6 YYMMDD

JULIAN-DATE (of EFFECTIVE_ENTRY_DATE) CHAR 3

ORIGIN-STATUS-CODE (“1”) CHAR 1

ORIGIN-DFI-ID (“03120760”) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) CHAR 8

BATCH-NO5 NUMBER 7

BATCH-BEGIN-HEADER for STORED VALUE CARD TO CLIENT

REC-TYPE5 (“5”) CHAR 1

SERV-CLASS-CODE5 (“200”) CHAR 3

CO-NAME-SVC (“NJKIDSSVC”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 16

CO-DISC-DATA CHAR 20

CO-ID-SVC (“5216000928”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 10

ENTRY-CLASS-CODE (“PPD”) CHAR 3

CO-ENTRY-DESC-SVC (“KIDSSVC”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 10

DESC-DATE5 (JOB RUN DATE) CHAR 6 MMDDYY

EFFECTIVE-ENTRY-DATE

(JOB RUN DATE + 2 business days; consider the state holidays in VSHOL table)

CHAR 6 YYMMDD

JULIAN-DATE (of EFFECTIVE_ENTRY_DATE) CHAR 3

ORIGIN-STATUS-CODE (“1”) CHAR 1

ORIGIN-DFI-ID (“03120760”) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) CHAR 8

BATCH-BEGIN-HEADER for STATE AGENCY

CO-NAME-OUTOFSTATE (“NJKIDSAGENCY”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 16

CO-DISC-DATA CHAR 20

23DPP00838 14 | P a g e

CO-ID-OUTOFSTATE (“6216000928”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 10

ENTRY-CLASS-CODE (“CCD”) CHAR 3

CO-ENTRY-DESC-OUTOFSTATE (“NJ3400000”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) CHAR 10

DESC-DATE5 (JOB RUN DATE) CHAR 6 MMDDYY

EFFECTIVE-ENTRY-DATE

(JOB RUN DATE + 2 business days; consider the state holidays in VSHOL table)

CHAR 6 YYMMDD

JULIAN-DATE (of EFFECTIVE_ENTRY_DATE) CHAR 3

ORIGIN-STATUS-CODE (“1”) CHAR 1

ORIGIN-DFI-ID (“03120760”) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) CHAR 8

DETAIL-RECORD (for EFT to CLIENT CHECKING and SVC to CLIENT)

REC-TYPE6 (“6”) CHAR 1

TRANS-CODE (“22”) (‘22’ is passed for Client’s SVC and checking account) CHAR 2

RECEIVING-DFI-ID

HASH-NUM NUMBER 8

LAST-CHECK-DIGIT NUMBER 1

DFI-ACCT-NO CHAR 17

CHECK-AMT NUMBER 10 8,2

INDV-ID (value of EFT-CASE-ID) CHAR 15

INDV-PAYEE-NAME CHAR 22

DISC-DATA CHAR 2

RECORD-IND (value of EFT-REC-IND) CHAR 1

TRACE-NO (03120760) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) NUMBER 8

DETAIL6-COUNT NUMBER 7

DETAIL-RECORD (for EFT to CLIENT SAVINGS)

REC-TYPE6 (“6”) CHAR 1

TRANS-CODE (“32”) CHAR 2

RECEIVING-DFI-ID

HASH-NUM NUMBER 8

LAST-CHECK-DIGIT NUMBER 1

DFI-ACCT-NO CHAR 17

CHECK-AMT NUMBER 10 8,2

INDV-ID (value of EFT-CASE-ID) CHAR 15

INDV-PAYEE-NAME CHAR 22

DISC-DATA CHAR 2

RECORD-IND (value of EFT-REC-IND) CHAR 1

TRACE-NO (03120760) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) NUMBER 8

DETAIL6-COUNT NUMBER 7

DETAIL-RECORD (for EFT to PRENOTE CHECKING)

TRANS-CODE (“23”) CHAR 2

RECEIVING-DFI-ID

HASH-NUM NUMBER 8

LAST-CHECK-DIGIT NUMBER 1

DFI-ACCT-NO CHAR 17

CHECK-AMT NUMBER 10 8,2

INDV-ID (value of EFT-CASE-ID) CHAR 15

INDV-PAYEE-NAME CHAR 22

DISC-DATA CHAR 2

RECORD-IND (value of EFT-REC-IND) CHAR 1

TRACE-NO (03120760) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) NUMBER 8

23DPP00838 15 | P a g e

DETAIL-RECORD (for EFT to PRENOTE SAVINGS)

TRANS-CODE (“33”) CHAR 2

RECEIVING-DFI-ID

HASH-NUM NUMBER 8

LAST-CHECK-DIGIT NUMBER 1

DFI-ACCT-NO CHAR 17

CHECK-AMT NUMBER 10 8,2

INDV-ID (value of EFT-CASE-ID) CHAR 15

INDV-PAYEE-NAME CHAR 22

DISC-DATA CHAR 2

RECORD-IND (value of EFT-REC-IND) CHAR 1

TRACE-NO (03120760) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) NUMBER 8

DETAIL-RECORD (for EFT to COUNTY OFFICE)

TRANS-CODE CHAR 2

RECEIVING-DFI-ID

HASH-NUM NUMBER 8

LAST-CHECK-DIGIT NUMBER 1

DFI-ACCT-NO CHAR 17

CHECK-AMT NUMBER 10 8,2

INDV-ID (1st 3 chars of EFT-FIPS) CHAR 15

INDV-PAYEE-NAME CHAR 22

DISC-DATA CHAR 2

RECORD-IND (“0”) CHAR 1

TRACE-NO (03120760) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) NUMBER 8

DETAIL-RECORD (for EFT to STATE AGENCY)

TRANS-CODE CHAR 2

RECEIVING-DFI-ID

HASH-NUM NUMBER 8

LAST-CHECK-DIGIT NUMBER 1

DFI-ACCT-NO CHAR 17

CHECK-AMT NUMBER 10 8,2

INDV-ID (EFT-FIPS) CHAR 15

INDV-PAYEE-NAME CHAR 22

DISC-DATA CHAR 2

RECORD-IND (“0”) CHAR 1

TRACE-NO (03120760) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) NUMBER 8

NULL-DETAIL-RECORD

N-REC-TYPE6 (“6”) CHAR 1

N-TRANS-CODE (“23”) CHAR 2

N-RECEIVING-DFI-ID

N-HASH-NUM (03120760) NUMBER 8

N-LAST-CHECK-DIGIT (7) NUMBER 1

N-DFI-ACCOUNT-NUMBER (“8007312089”) CHAR 17

23DPP00838 16 | P a g e

N-CHECK-AMT NUMBER 10 8,2

N-INDV-ID (“34000”) CHAR 15

N-INDV-PAYEE-NAME (“STATE OF NEW JERSEY”) CHAR 22

N-DISC-DATA CHAR 2

N-RECORD-IND (“0”) CHAR 1

N-TRACE-NUMBER (03120760) NUMBER 8

N-6-DETAIL-COUNT NUMBER 7

ADDENDA-RECORD (for payments to STATE AGENCY only)

REC-TYPE7 (“7”) CHAR 1

ADDENA-CODE (“05”) CHAR 2

SEGMENT-ID (“DED”) CHAR 3

SEP1 (“*”) CHAR 1

APPL-ID CHAR 2

SEP2 (“*”) CHAR 1

RELATED-INFORMATION (73 Chars)

CASE-IDENTIFIER CHAR 15 Out of state case #

SEPARATOR CHAR 1 ‘*’

PAY-DATE DATE 6 YYMMDD

SEPARATOR CHAR 1 ‘*’

PAYMENT-AMOUNT NUMBER 10 $$$$$$$$cc

SEPARATOR CHAR 1 ‘*’

NCP-SSN CHAR 9

SEPARATOR CHAR 1 ‘*’

MEDICAL-SUPPORT-INDICATOR CHAR 1 ‘Y’, ‘N’ or ‘W’ for N/A

SEPARATOR CHAR 1 ‘*’

NCP-NAME

(First 7 letters of AP Last Name + First 3 letters of AP First Name. If Last Name less than 7 characters, insert comma between Last and First Name)

CHAR 10

SEPARATOR CHAR 1 ‘*’

FIPS-CODE CHAR 5 Receiving State

SEPARATOR CHAR 1 ‘*’

EMPLOYMENT-TERMINATION-IND CHAR 1 Bypass field

SEGMENT-TERMINATOR CHAR 1 ‘\’

FILLER CHAR 8 Spaces

ADDENDA-SEQ-NO (“0001”) CHAR 4

ADDENDA7-COUNT NUMBER 7

BATCH-END-REC

REC-TYPE8 (“8”) CHAR 1

SERVICE-CLASS-CODE (“200”) CHAR 3

DET-ADD-COUNT NUMBER 6

ENTRY-HASH-COUNT NUMBER 10

DEBIT-AMT-AMT NUMBER 12 10,2

CREDIT-AMT-AMT NUMBER 12 10,2

CO-ID8

for Out of state disbursement- CO-ID-OUTOFSTATE (“6216000928”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’) for Clients disbursement- CO-ID-EFT-CLIENT (“4216000928”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’)

– for county disbursement- CO-ID-EFT-COUNTY (“6216000928”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’)

– for SVC – CO-ID-SVC (“5216000928”) (REFM reference code type ‘BANK’ and code sub type ‘ACHD’)

CHAR 10

MSG-AUTH-CODE CHAR 19

RESERVED1 CHAR 6

ORIGIN-DFI-NO (“03120760”) (REFM reference code type ‘BANK’ and code sub type ‘EFTD’) CHAR 8

BATCH-NO8 NUMBER 7

END-HEADER

23DPP00838 17 | P a g e

REC-TYPE (“9”) CHAR 1

TOTAL-BATCH8-COUNT

(Number of Batches on File)

NUMBER 6

BLOCK-COUNT

(Blocked every 10 records round up i.e., 12 records = 000002)

NUMBER 6

TOTAL-DET-ADD-COUNT

Number of Detail records + Number of Addenda records on file

NUMBER 8

TOTAL-HASH-COUNT

Sum of Batch Control Entry Hashes

NUMBER 10

TOTAL-DEBIT-AMT NUMBER 12

TOTAL-CREDIT-AMT

Sum of CREDIT-AMT-AMT on record ‘8’

NUMBER 12

RESERVED9 CHAR 39 Spaces

Mapping for the ADDENDA record

Source Target

“7” REC-TYPE

“05” ADDENA-CODE

“DED” SEGMENT-ID

“*” SEP1

‘II – Interstate Income Withholding’ – for the receipt source ‘EW – Employer Wage’

‘IT – If Interstate State Tax Offset’ – for the receipt sources ‘SH – SOIL (HOMESTEAD REBATE)’, ‘SS – SOIL (SAVER REBATE)’ and ‘ST – SOIL (STATE TAX REFUND)’

‘IO – Interstate All Others’ - For all other Receipt Source

APPL-ID

“*” SEP2

RELATED-INFORMATION (73 Chars)

VOSCS.ID_CASE_OOS CASE-IDENTIFIER

‘*’ SEPARATOR

VRCTH.DT_RECEIPT PAY-DATE

‘*’ SEPARATOR

VDSBL.AMT_DISBURSE PAYMENT-AMOUNT

‘*’ SEPARATOR

VDEMO.MEM_SSN NCP-SSN

‘*’ SEPARATOR

VSORD.IND_MEDICAL_ONLY MEDICAL-SUPPORT-INDICATOR

‘*’ SEPARATOR

VDEMO.NAME_LAST

VDEMO.NAME_FIRST

(First 7 letters of AP Last Name + First 3 letters of AP First Name. If Last Name less than 7 characters, insert comma between Last and First Name)

NCP-NAME

‘*’ SEPARATOR

VOSCS.ID_FIPS FIPS-CODE

‘*’ SEPARATOR

Not used EMPLOYMENT-TERMINATION-IND

‘\’ SEGMENT-TERMINATOR

Spaces FILLER

Starting from “0001” and incremented by 1 ADDENDA-SEQ-NO

Total # of Addenda records ADDENDA7-COUNT

23DPP00838 18 | P a g e

1.1.1.13. Contact information

Name of the Agency Technical Contact Functional Contact

SDU Contractor - -

23DPP00838 19 | P a g e

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_EXTRACT_EFT_SVC_PNOTE_DISB Processing and Extracting Extracts the CP’s, Agency’s and County’s E - VDSBH Y Y - FT disbursement, EFT pre-notes and Stored Y value card disbursements and creates an VEFTR Y Y - EFT file to the SDU Contractor -

Also generates the Recoupment VDCRS Y - - Disbursements for the State/SDU

VDEFT

Y

VCRDB

VDSBL

VOFIC

VCASE

VSTAT

VFIPS

VICAS

VDEMO

VCMEM

VRCTH

VSORD

VEFCD

2 BATCH_COMMON.SP_GET_BATCH_DETAILS Common Routine Getting Run date, Last Run date, Commit Frequency, Exception Threshold, File Name and File output Path.

3 BATCH_COMMON.SP_BATE_LOG Common Routine Inserting the batch errors in VBATE table. - - - - - -

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

6 BATCH_COMMON.SP_BSTL_LOG Common Routine Inserting the batch status - - - - - -

7 SP_GENERATE_SEQ Common Routine This procedure is used to insert a record into VGLEV and return the generated SEQ_EVENT_GLOBAL back to the calling program.