Exhibit G1 - NJKiDS Batch Schedule Summary~1.xls
XLS spreadsheet 155 KB Posted
- Solicitation number
- 26DPP01287
- Issued by
- Mercer County, New Jersey
About this file
NJKiDS Batch Schedule Summary
This document is a comprehensive batch schedule exhibit for contract T2314 - NJKiDS Application Maintenance and Support for New Jersey's ACSES (Automated Child Support Enforcement System). The exhibit details 432 batch processes organized across multiple functional subsystems including General, Financials, Case Management, Locate, Enforcement, and Establishment operations. The batch processes encompass critical daily, weekly, monthly, quarterly, and annual operations required to support child support case management, enforcement, collections, and financial management activities. Key processes include member data updates, certification status tracking, financial collections and disbursements, case closure eligibility determinations, enforcement remedies, location activities, and comprehensive reporting functions. The batch schedule identifies each process by job ID, batch name, stored procedure or routine name, subsystem classification, criticality designation, and execution frequency. Critical processes essential to system operations are designated and include daily financial accruals, collections, distributions, disbursements, enforcement monitoring, and notice generation activities.
The batch processes support integration with multiple external agencies and systems including the State Directory New Hire, Federal Case Registry (FCR), Child Support Enforcement Statewide Network (CSENET), Internal Revenue Service (IRS), Department of Revenue (DOR), Motor Vehicle Commission (MVC), Labor and Workforce Development (LWD), Financial Institution Data Match (FIDM), Child Support Lien Network (CSLN), Medicaid agencies, and banking institutions. The schedule encompasses both load and process functions that receive incoming data files, perform validation and reconciliation, update core NJKiDS database tables, and generate extract files for transmission to external entities. Special emphasis is placed on data quality operations including address normalization, member merge reconciliation, and certified mail status tracking. The batch environment supports parallel processing capabilities for performance optimization and includes comprehensive reporting extractions for operational analysis, federal compliance reporting (OCSE-34A and OCSE-157), and business intelligence data warehouse population.
View the file
Other files
Show all 18
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Batch Processes
| 26DPP01287 | T2314 - NJKiDS Application Maintenance and Support for NJ ACSES | ||||||
| S.No. | Job ID | Batch Name | Job Narrative | Sub System | Critical Job | Frequency | |
| 1 | NJB0001 | BATCH_COMMON.SP_UPDATE_DAILY_PARM_DATE | This process will update the Effective date for running the jobs. | General | Yes | Daily | |
| 2 | NJB1830 | BATCH_NOTICE_CERT_STATUS.SP_LOAD_CERT_MAIL_STATUS | This process loads the certified mail delivery status of the notices received from RRD through a file to a temporary table LOAD_CERT_MAIL_STATUS in NJKiDS | General | No | Daily | |
| 3 | NJB1840 | BATCH_NOTICE_CERT_STATUS.SP_PROCESS_CERT_MAIL_STATUS | This process reads the temporary table LOAD_CERT_MAIL_STATUS, updates the cd_delivered_status and date_delivered_status in VNRRQ | ||||
| table by matching the id_package and article number received in the file. This process also inserts all the multiple statuses received for each article number to a new table - CERTIFIED_MAIL_STATUSES. | General | No | Daily | ||||
| 4 | NJB0100 | BATCH_FIN_EXT_PLOG.SP_EXT_PLOG | 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. | Financials | Yes | Daily | |
| 5 | NJB1700 | BATCH_COMMON.SP_SET_BATCH_WINDOW | Capture the batch execution window | General | Yes | Daily | |
| 6 | NJB1030 | BATCH_CM_MERG.SP_PROCESS_MEMBER_MERGE | Member Merge | Case Management | No | Daily | |
| 7 | NJB1680 | BATCH_CM_MERG.SP_PROCESS_OTHP_MERGE | OTHP Merge | Case Management | No | Daily | |
| 8 | NJB1580 | BATCH_FIN_EXT_VOID_CHECK.SP_EXT_VOID_CHECKS | The process extracts the checks from the Disbursement View (DSBV) screen/LOG_DISBURSEMENT_HEADER (DSBH) table and generates a Void Check file to the bank. | Financials | Yes | Daily | |
| 9 | NJB6920 | BATCH_FIN_CLEARED_CHECKS.SP_LOAD_VOIDS_STOPS_SDU | This process loads the monthly VOIDs and STOPs from the bank | Financials | No | Monthly | |
| 10 | NJB1430 | HTTP Call from Scheduler to App Server for Labcorp --labcorp.LabcorpBatch.runLabCorp() | Get the Paternity status from Labcorp | Establishment | No | Daily | |
| 11 | NJB0190 | BATCH_FIN_COLLECTIONS.SP_LOAD_SDU | The stored Procedure SP_LOAD_SDU takes collection data from SDU in a file format, and then loads it into a temporary table in NJKiDS. | Financials | Yes | Daily | |
| 12 | NJB7010 | BATCH_FIN_COLLECTIONS.SP_LOAD_IRS | The stored procedure SP_LOAD_IRS takes collection data received from IRS in a file format, and then loads it into the temporary table in NJKiDS. | Financials | Yes | Bi-weekly | |
| 13 | NJB0200 | BATCH_FIN_NSF.SP_LOAD_NSF | This process reads the NSF Returned Items file from the SDU and inserts the records into the temporary table. | Financials | Yes | Daily | |
| 14 | NJB0220 | BATCH_FIN_EFT_SVC_ACCT_SETUP.SP_LOAD_EFT_SVC_ACCT | This process loads direct deposit and SVC instructions for a custodial parent, from the SDU. These instructions are loaded from the file into temporary table. | Financials | Yes | Daily | |
| 15 | NJB1650 | BATCH_FIN_EFT_SVC_PNOTE_REJECT.SP_LOAD_EFRJ_SDU | This procedure loads the reject file received from the bank into a temporary oracle table LOAD_EFT_REJECT. | Financials | Yes | Daily | |
| 16 | NJB0270 | BATCH_FIN_IVE_TERMINATION.SP_LOAD_IVE_TERMINATION | This process loads the update file given by IVE into temporary tables using UTL_FILE package in Oracle. | Case Initiation | No | Daily | |
| 17 | NJB0280 | BATCH_LOC_NEWHIRE.SP_LOAD_FULLSTATEHIRE | This process loads the full match file from the State Directory New Hire to the temporary table LOAD_SDNH_FULL_MATCH using the oracle package UTL_FILE. | Locate | No | Daily | |
| 18 | NJB0285 | BATCH_LOC_GA.SP_LOAD_GA | This process loads the General Assistance data. | Locate | No | Daily | |
| 19 | NJB0290 | BATCH_LOC_NEWHIRE.SP_LOAD_PARTSTATEHIRE | This process loads the partial match data from the State Directory New Hire to the temporary table LOAD_SDNH_PARTIAL_MATCH using the oracle package UTL_FILE. | Locate | No | On-request | |
| 20 | NJB0300 | BATCH_ENF_FCR_INCOMING.SP_LOAD_FCR_DETAILS | The purpose of this process is to load the file to different temporary tables based on the Record ID present in the FCR incoming file for further processing. | Locate | No | Daily | |
| 21 | NJB0330 | BATCH_CI_INCOMING_CSENET_TRANS.SP_LOAD_CSENET | This process reads the text file containing all the inbound CSENET transaction and load into temporary header table. The data for each of the blocks available in transaction gets loaded in corresponding data block table. | Case Initiation | No | Daily | |
| 22 | NJB0340 | BATCH_CI_CSENET_ERRORS.SP_LOAD_CSENET_ERRORS | This process reads the CSENET Error file returned from CSENET to the state and loads the data into a VCERR table. | Case Initiation | No | Daily | |
| 23 | NJB0370 | BATCH_FIN_IVA_UPDATES.SP_LOAD_IVA_UPDATES | This procedure loads the update file from the IVA to the temporary table LOAD_IVA_UPDATE_MAIN using UTL_FILE package in Oracle. | Case Initiation | No | Daily | |
| 24 | NJB5200 | BATCH_ENF_FIDM.SP_LOAD_FIDM_ACCTS | This process loads the FI account file from FIDM – Financial Institution Data Match to the temporary table LOAD_FIDM_ACCTS. | Enforcement | No | Daily | |
| 25 | NJB1290 | BATCH_ENF_EIWO_UPDATES.SP_LOAD_EIWO_ACK | Loads the EIWO acknowledgement file | Enforcement | No | Daily | |
| 26 | NJB1300 | BATCH_ENF_EIWO_UPDATES.SP_LOAD_EIWO_RESULT | Loads the EIWO result file | Enforcement | No | Daily | |
| 27 | NJB1590 | BATCH_FIN_CLEARED_CHECKS.SP_LOAD_CCLR_SDU | The process loads the Bank Reconciliation file from the Disbursement Bank to the temporary table for further processing. | Financials | No | Daily | |
| 28 | NJB6150 | BATCH_ENF_CSLN.SP_LOAD_CLAIMS | This process loads the insurance claim file from CSLN – Child Support Lien Network to the temporary table LOAD_INSURANCE_CLAIMS. | Enforcement | No | Daily | |
| 29 | NJB0240 | BATCH_FIN_TANF_GRANT.SP_LOAD_TANF_GRANT | This process reads the file sent by IVA and moves the data to the temporary table. | ||||
| OIT receives the daily Grant file between 10:00 PM to 11:00 PM. | Financials | Yes | Daily | ||||
| 30 | NJB1330 | BATCH_FIN_IVE_UPDATES.SP_LOAD_IVE_REFERRALS | Loads the IVE / Non IVE Referral file | No | Daily | ||
| 31 | NJB1230 | BATCH_NOTICE_PRINT_STATUS.SP_LOAD_PRINT_STATUS | This process reads the incoming print confirmation file from OIT and loads into the temporary table LOAD_PRINT_STATUS | General | No | Daily | |
| 32 | NJB1770 | BATCH_CUSW_OUTBOUND_CALLS.SP_LOAD_FAILED_CALLS | Loading Phone numbers of failed calls | General | No | Daily | |
| 33 | NJB5210 | BATCH_EST_POP_UPDATES.SP_LOAD_POP_DETAILS | This process reads the POP weekly file and loads the data into a temporary table LOAD_POP_DETAILS. | Establishment | No | Weekly | |
| 34 | NJB5180 | BATCH_ENF_CSLN.SP_LOAD_ADDRESS | This process loads the address file having NCP address details from CSLN – Child Support Lien Network to the temporary table LOAD_CSLN_ADDRESS. | Locate | No | Weekly | |
| 35 | NJB5190 | BATCH_ENF_FIDM.SP_LOAD_ADDRESS | This process loads the address file from FIDM – Financial Institution Data Match to the temporary table LOAD_FIDM_ADDRESS. | Locate | No | Weekly | |
| 34 | NJB5170 | BATCH_ENF_IRS_REJECTS.SP_LOAD_IRS_REJECTS | This process reads the case submission reject file records from the Federal Offset Process and loads it into a temporary table LOAD_IRS_REJECTS in NJKiDS. | Enforcement | No | Weekly | |
| 35 | NJB5530 | BATCH_ENF_IRS_REJECTS.SP_LOAD_IRS_UNACC_REJECTS | Loads unaccountable file | Enforcement | No | Weekly | |
| 36 | NJB5510 | BATCH_ENF_SOIL_REJECTS.SP_LOAD_SOIL_REJECTS | Loads SOIL Errors | Enforcement | No | Weekly | |
| 39 | NJB5555 | BATCH_ADDR_NORMALIZATION.SP_LOAD_NORM_NCOA_ADDRESS | LOAD NORMALIZED ADDRESS AND NCOA ADDRESS FROM RRD | General | No | Weekly | |
| 40 | NJB5620 | BATCH_ENF_CSESP_INCOMING.SP_LOAD_CSESP | This process loads the CSESP Registration file received from Child Support Employer Services Portal to the temporary tables for further processing. | Enforcement | No | Weekly | |
| 41 | NJB5460 | unzip.UnZip.loadZipFile(LOAD_SIGNATURE_IMG.ZIP) | Loading Image files to Application Server which is received from B&C | General | No | Weekly | |
| 42 | NJB5030 | BATCH_ENF_UIB_UPDATES.SP_LOAD_LWD_MATCH | The process loads the LWD – Labor Workforce Development match file into a temporary table LOAD_LWD_MATCH. | Locate | No | Weekly | |
| 43 | NJB5040 | BATCH_ENF_MVC.SP_LOAD_DRIVERS_LICENSES | The process loads the driver’s license file from MVC – Motor Vehicle Commission to the temporary table LOAD_DRIVERS_LICENSES using the oracle package UTL_FILE. | Locate | No | Weekly | |
| 44 | NJB6190 | BATCH_ENF_MEDICAID_TPL_UPDATES.SP_LOAD_MEDICAID_TPL | The process loads the member insurance details from the Medicaid agency to the intermediate table LOAD_MEDICAID_TPL or further processing. | Locate | No | Weekly | |
| 45 | NJB5100 | BATCH_ENF_SOIL_UPDATES.SP_LOAD_SOIL_NOTIFICATION | This process loads the refund notification file from DOR – Department of Revenue in NJKiDS. | Enforcement | No | Weekly | |
| 46 | NJB5540 | BATCH_ADDR_NORMALIZATION.SP_LOAD_ NORM_ADDR_2NDATTMPT | Loading Normalized addresses from 2nd attempt | General | No | Weekly | |
| 47 | NJB9140 | BATCH_ENF_ACMS.SP_LOAD_ACMS | This process loads the ACMS match file from ACMS - Automated Case Management System to the oracle temporary table LOAD_ACMS in NJKiDS. | Enforcement | No | On-request | |
| 48 | NJB9090 | BATCH_ENF_MEDICAID_MPT_UPDATES.SP_LOAD_INS_PROVIDERS | The process reads input file using the oracle UTL_FILE package and loads data to temporary LOAD_INS_PROVIDERS table. | Enforcement | No | On-request | |
| 49 | NJB7590 | BATCH_LOC_DCA.SP_LOAD_MEMBER_DETAILS | This process loads the member’s work address and professional license information sent by Division Of Consumer Affairs to a temporary table LOAD_DCA_MEMBERS using Oracle UTL_FILE package. | Locate | No | Monthly | |
| 50 | NJB6070 | BATCH_LOC_NJ_QTLY_WAGE.SP_LOAD_QTRLY_WAGE | This procedure loads the NCP / CP Name, SSN, Employment and Wage details into the NJKiDS temporary table LOAD_STATE_QTRLY_WAGE. | Locate | No | Monthly | |
| 51 | NJB6030 | BATCH_FIN_FC_GRANT.SP_LOAD_FC_GRANT | This process reads the file sent by IV-E and moves the data to the temporary table LOAD_FC_GRANT for further processing. | Financials | Yes | Monthly | |
| 52 | NJB6470 | BATCH_ENF_EIWO_UPDATES.SP_LOAD_EIWO_SETUP | Loads the EIWO FEIN file | Enforcement | No | On-request | |
| 53 | NJB6510 | BATCH_FIN_IVE_ELIG_STATUS.SP_LOAD_IVE_ELIG_STATUS | Loads the IVE / Non IVE Eligibility file | Financials | No | Monthly | |
| 54 | NJB6035 | BATCH_ENF_ACMS.SP_LOAD_ACMS_SATISFACTION | This process loads the monthly satisfaction file received from ACMS/CJOD to the oracle temporary table in NJKIDS. | General | No | Monthly | |
| 55 | NJB6220 | BATCH_LOC_DOC.SP_LOAD_CIT | This procedure loads the institution code, name and address from institute file to the temporary table LOAD_INSTITUTIONS using the oracle package UTL_FILE. | Locate | No | Weekly | |
| 56 | NJB6160 | BATCH_LOC_DOC.SP_LOAD_CRR | This procedure loads the release reason file from the Dept of Correction to the temporary table LOAD_RELEASE_REASON using the oracle package UTL_FILE. | Locate | No | Weekly | |
| 57 | NJB6170 | BATCH_LOC_DOC.SP_LOAD_INMATE | This procedure loads the inmate information to the temporary table LOAD_PAROLE using the oracle package UTL_FILE. | Locate | No | Weekly | |
| 58 | NJB6180 | BATCH_LOC_DOC.SP_LOAD_PAROLE | This procedure loads the parole information to the temporary table LOAD_PAROLE using the oracle package UTL_FILE. | Locate | No | Weekly | |
| 59 | NJB7570 | BATCH_EST_POP_NCP_UPDATE.SP_LOAD_NCP_DETAILS | This process reads the Quarterly file having NCP Details and loads into the temporary table LOAD_POP_NCP_DETAILS. | Establishment | No | Qtly | |
| 60 | NJB7510 | BATCH_EST_POP_DP_UPDATE.SP_LOAD_DP_DETAILS | This process reads the POP Dependent file having dependent place of birth details i.e. Birth city, Birth state, Birth country, Date of Birth and loads all the file data into a temporary table LOAD_POP_DP_DETAILS. | Establishment | No | Qtly | |
| 61 | NJB9030 | BATCH_LOC_BVS.SP_LOAD_BVS | This procedure loads the Bureau of Vital Statistics file from the Department of Health to the temporary table LOAD_BVS. | Locate | No | Weekly | |
| 62 | NJB8030 | BATCH_LOC_DOR_UPDATES.SP_LOAD_PROCESS | This process loads the NCP’s address sent by Division of Revenue through a file to a temporary table LOAD_NJTAXATION in NJKiDS using Oracle UTL_FILE package. | Locate | No | Semi-Annual | |
| 63 | NJB9330 | BATCH_CI_ICR_UPDATES.SP_LOAD_ICR_UPDATES | Loads the ICR response file | Case Management | Yes | Annual | |
| 64 | NJB8510 | BATCH_EST_POP_157_COUNTS.SP_LOAD_EST_POP_157_BOW | This process loads the POP counts instructions for OCSE157 report from the PEP file, into a temporary table LOAD_EST_POP_157COUNTS. | Establishment | Yes | Annual | |
| 65 | NJB8515 | BATCH_EST_POP_157_COUNTS.SP_LOAD_EST_POP_157_COP | Loads the Child Paternity information from POP-157 file | Establishment | Yes | Annual | |
| 66 | NJB8530 | BATCH_EST_POP_RECON.SP_LOAD_POP_RECON | This process reads the POP Recon file and loads the data into a temporary table LOAD_POP_RECON. | Establishment | No | Annual | |
| 67 | NJB8710 | BATCH_ENF_FCR_RECON.SP_LOAD_FCR_RECON | Loads FCR Reconciliation file. | Case Management | Yes | On-request | |
| 68 | NJB6230 | BATCH_ENF_CSLN.SP_PROCESS_CLAIMS | This process reads the insurance claim data from the temporary table LOAD_INSURANCE_CLAIMS and updates the VASFN Table. | Enforcement | No | Daily | |
| 69 | NJB1780 | BATCH_CUSW_OUTBOUND_CALLS.SP_PROCESS_FAILED_CALLS | Processing of failed Phone numbers from IVR | General | No | Daily | |
| 70 | NJB1260 | BATCH_EST_GEN_TEST.SP_UPDATE_GEN_RESULT | This process reads the stating table load_gtst_results and update the vgtst table columns dt_results_received and pct_probability | Establishment | No | Daily | |
| 71 | NJB0380 | BATCH_FIN_NSF.SP_PROCESS_NSF | This process reads the NSF receipts from the temporary table LOAD_NSF_RECEIPTS and reverses the payments automatically and sets up NSF indicator for the payor DCN. | Financials | Yes | Daily | |
| 72 | NJB0390 | BATCH_FIN_IVA_UPDATES.SP_PROCESS_IVA_UPDATES | This process reads the data from the temporary tables and updates VMHIS and VDEMO tables. Matched records are marked as “processed” by updating the IND_PROCESSED field to ‘Y’ in all temporary tables | Case Initiation | No | Daily | |
| 73 | NJB0400 | BATCH_FIN_IVE_TERMINATION.SP_PROCESS_IVE_TERMINATION | This process reads the data from the temporary table and closes all the open obligations (OWIZ screen / OBLE table) for the IV-D case. | Case Initiation | No | Daily | |
| 74 | NJB0410 | BATCH_FIN_EFT_SVC_ACCT_SETUP.SP_PROCESS_EFT_SVC_ACCT | This process reads the temporary table LOAD_EFT_SVC_ACCT and updates VEFTR and VDCRS | Financials | Yes | Daily | |
| 75 | NJB0420 | BATCH_FIN_EFT_SVC_PNOTE_REJECT.SP_PROCESS_EFRJ | This procedure reads the EFT / SVC / PNOTE rejects and marks the disbursements as rejected. If the pre-note was rejected, the EFT account is marked as Prenote Rejected. | Financials | Yes | Daily | |
| 76 | NJB0430 | BATCH_FIN_CLEARED_CHECKS.SP_PROCESS_CLEARED_CHECKS | This process changes the status to 'CA' for the checks received from PNC. | Financials | No | Daily | |
| 77 | NJB0470 | BATCH_LOC_NEWHIRE.SP_PROCESS_SDNH | This process reads the State Directory New Hire information from the temporary tables LOAD_SDNH_FULL_MATCH, LOAD_SDNH_PARTIAL_MATCH and updates the Member’s mailing address in VAHIS and employment details in VEHIS. | Locate | No | Daily | |
| 78 | NJB0475 | BATCH_LOC_GA.SP_PROCESS_GA | This process reads the data from GA load tables and inserts/updates the GA data on INEX | Locate | No | Daily | |
| 79 | NJB0480 | BATCH_ENF_FCR_INCOMING.SP_PROCESS_FCR_RESPONSE | This process records member information such as Address (mailing or residential), Employer, Wages, SSN, DOB and DOD into NJKiDS and also sets the FCR flags in the system for the acknowledgements received from FCR. |
| Output file needs to created only when NJKiDS is statewide | Locate | No | Daily | ||||
| 80 | NJB0490 | BATCH_CI_INCOMING_CSENET_TRANS.SP_PROCESS_CSENET | The rejected transactions are added in a pending queue, transactions which are not rejected will be transferred to CSENET tables for systematic updates and alerts will be generated according to FAR | Case Initiation | No | Daily | |
| 81 | NJB5250 | BATCH_ENF_FIDM.SP_PROCESS_FIDM_ACCTS | This process reads the FI account details from the temporary table LOAD_FIDM_ACCTS and updates the Member Financial Assets - VASFN Table. | Enforcement | No | Daily | |
| 82 | NJB1240 | BATCH_NOTICE_PRINT_STATUS.SP_PROCESS_PRINT_STATUS | This process reads the temporary table LOAD_PRINT_STATUS, updates the cd_delivered_status and date_delivered_status in VNRRQ table. The matching is done using the ID_PACKAGE sent in the file. | General | No | Daily | |
| 83 | NJB1310 | BATCH_ENF_EIWO_UPDATES.SP_PROCESS_EIWO_ACK | Process the EIWO acknowledgement file | Enforcement | No | Daily | |
| 84 | NJB1320 | BATCH_ENF_EIWO_UPDATES.SP_PROCESS_EIWO_RESULT | Process the EIWO result file | Enforcement | No | Daily | |
| 85 | NJB1340 | BATCH_FIN_IVE_UPDATES.SP_PROCESS_IVE_REFERRALS | Process the IVE / Non - IVE Referral file | Case Initiation | No | Daily | |
| 92 | NJB5260 | BATCH_EST_POP_UPDATES.SP_PROCESS_POP_DETAILS | This process reads the temporary table LOAD_POP_DETAILS and looks for the Member match. If the match is found then the DP’s paternity indicator and the place of birth are updated in the system. | Establishment | No | Weekly | |
| 86 | NJB1900 | etro.ETRO.runETRO() | ETRO JAVA BATCH | Establishment | No | Daily | |
| 87 | NJB1350 | facts.FACTS.runFACTS() | Call from Scheduler to App Server for AFP Notice generation | General | No | Daily | |
| 88 | NJB1560 | BATCH_FIN_TANF_GRANT.SP_PRE_TANF_GRANT | Pre TANF Grant | Financials | Yes | Daily | |
| 89 | NJB0570 | BATCH_FIN_TANF_GRANT.SP_UPDATE_TANF_GRANT | This process reads the data from the temporary table LOAD_TANF_GRANT and updates the Monthly Grant Modification (IVMG) Screen / IVA_IVE_GRANT (IVMG) table. | Financials | Yes | Daily | |
| 90 | NJB1570 | BATCH_FIN_TANF_GRANT.SP_POST_TANF_GRANT | Post TANF Grant | Financials | Yes | Daily | |
| 91 | NJB5575 | BATCH_ADDR_NORMALIZATION.SP_PROCESS_NORM_NCOA_ADDRESS | PROCESS NORMALIZED AND NCOA ADDRESS | General | No | Weekly | |
| 93 | NJB5220 | BATCH_ENF_IRS_REJECTS.SP_PROCESS_IRS_REJECTS | This process reads the IRS reject data from the temporary table LOAD_IRS_REJECTS and creates an entry in VRJDT table. | Enforcement | No | Weekly | |
| 94 | NJB5520 | BATCH_ENF_SOIL_REJECTS.SP_PROCESS_SOIL_REJECTS | Process SOIL Errors | Enforcement | No | Weekly | |
| 95 | NJB5230 | BATCH_ENF_CSLN.SP_UPDATE_ADDRESS | This process reads the address data from the temporary table LOAD_CSLN_ADDRESS and updates the NCP’s address in the VAHIS table. | Locate | No | Weekly | |
| 96 | NJB5240 | BATCH_ENF_FIDM.SP_UPDATE_ADDRESS | This process reads the address details from the temporary table LOAD_FIDM_ADDRESS and updates the NCP’s Mailing address in VAHIS table. | Locate | No | Weekly | |
| 97 | NJB5630 | BATCH_ENF_CSESP_INCOMING.SP_PROCESS_CSESP | This Processes the data from the staging table and match employers on the incoming CSESP registration file to the NJKIDS Other Party table. This process updates the CSESP tables with the received information along with the matched/not matched details | Enforcement | No | Weekly | |
| 98 | NJB5060 | BATCH_ENF_UIB_UPDATES.SP_PROCESS_LWD_MATCH | The purpose of the process is to get the unemployment, disability details and address from the Labor and workforce development. | Locate | No | Weekly | |
| 99 | NJB5050 | BATCH_ENF_MVC.SP_PROCESS_LICENSES | The purpose of the process is to get the NCP’s/CP’s address and License information from the LOAD_DRIVERS_LICENSES table and updates into VPLIC table. | Locate | No | Weekly | |
| 100 | NJB6280 | BATCH_ENF_MEDICAID_TPL_UPDATES.SP_PROCESS_TPL | The process finds the exact match for the member details provided by the Medicaid and if match found, the records are updated with the details of the NCP to the VMINS Table and VDINS Table | Enforcement | No | Weekly | |
| 101 | NJB5560 | BATCH_ADDR_NORMALIZATION.SP_PROCESS_NORM_ADDR_2NDATTMPT | Processing 2nd attempt normalized addresses | General | No | Weekly | |
| 102 | NJB6290 | BATCH_FIN_CLEARED_CHECKS.SP_PROCESS_VOIDS_STOPS | This process reconciles the VOIDs and STOPs received from the bank with NJKiDS | Financials | No | Monthly | |
| 103 | NJB9150 | BATCH_ENF_ACMS.SP_PROCESS_ACMS | This process reads the ACMS match data from the temporary table and updates the Judgment case number in the system. | Enforcement | No | On-request | |
| 104 | NJB6080 | BATCH_LOC_NJ_QTLY_WAGE.SP_PROCESS_QTRLY_WAGE | This process reads the temporary table LOAD_STATE_QTRLY_WAGE and inserts the NCP’s / CP’s Employer address details and wage details in VNJQW table. | Locate | No | Monthly | |
| 105 | NJB6040 | BATCH_FIN_FC_GRANT.SP_UPDATE_FC_GRANT | This process reads the data from the temporary table LOAD_FC_GRANT and updates the Monthly Grant Modification (IVMG) Screen / IVA_IVE_GRANT (IVMG) table. | Financials | Yes | Monthly | |
| 106 | NJB6480 | BATCH_ENF_EIWO_UPDATES.SP_PROCESS_EIWO_SETUP | Process the EIWO FEIN file | Enforcement | No | On-request | |
| 107 | NJB6520 | BATCH_FIN_IVE_ELIG_STATUS.SP_PROCESS_IVE_ELIG_STATUS | This process reads the temporary table and updates the status of the DCF members | Financials | No | Monthly | |
| 108 | NJB7620 | BATCH_LOC_DCA.SP_UPDATE_MEMBER_DEATILS | This process reads the temporary table, normalizes the address and updates the work address in VAHIS table using address de-duplicate process. In addition, it also updates the professional license information. | Locate | No | Monthly | |
| 109 | NJB6045 | BATCH_ENF_ACMS.SP_PROCESS_ACMS_SATISFACTION | This process reads the load table for ACMS satisfaction file and updates the vsord columns – id_acms and dt_acms with space and low date respcetively for the matched records. | General | No | Monthly | |
| 110 | NJB6240 | BATCH_LOC_DOC.SP_PROCESS_CRR | This process reads the data from the temporary table LOAD_RELEASE_REASON and updates VREFM table. | Locate | No | Weekly | |
| 111 | NJB6250 | BATCH_LOC_DOC.SP_PROCESS_CIT | This process reads the data from the temporary table LOAD_INSTITUTIONS and updates VOTHP table. | Locate | No | Weekly | |
| 112 | NJB6260 | BATCH_LOC_DOC.SP_PROCESS_PAROLE | The purpose of the process is to get the inmate parole details from LOAD_PAROLE and Updates inmate parole details on VMDET table. Updates NCP address, inmate and prison number on VDEMO. | Locate | No | Weekly | |
| 113 | NJB7580 | BATCH_EST_POP_NCP_UPDATE.SP_PROCESS_NCP_DETAILS | This process reads the LOAD_POP_NCP_DETAILS table and looks for the NCP match. If the NCP match found then the NCP’s mailing address updated. | Establishment | No | Qtly | |
| 114 | NJB7520 | BATCH_EST_POP_DP_UPDATE.SP_PROCESS_DP_UPDATES | This process reads the temporary table LOAD_POP_DP_DETAILS and looks for the dependent match. If the match is found then the DP’s (Dependent) place of birth is updated in VDEMO table of NJKIDS database. | Establishment | No | Qtly | |
| 115 | NJB9040 | BATCH_LOC_BVS.SP_PROCESS_BVS | The process reads the deceased information from the temporary table and updates the date of death information in VDEMO table after matching the member details in the file to the details in NJKiDS. VMSSN, VCMEM, VDEMO tables are used to match the member. | Locate | No | Weekly | |
| 116 | NJB8040 | BATCH_LOC_DOR_UPDATES.SP_UPDATE_PROCESS | This process reads the temporary table LOAD_NJTAXATION, normalizes the address and updates the address in VAHIS table using address de-duplicate process. The matching is done using the NCP’s DCN given by Department Of Revenue. | Locate | No | Semi-Annual | |
| 117 | NJB9340 | BATCH_CI_ICR_UPDATES.SP_PROCESS_ICR_UPDATES | Process the ICR response file | Case Management | Yes | Annual | |
| 118 | NJB8600 | BATCH_FIN_ESCHEATMENT.SP_MAKE_READY_FOR_ESCHEAT | This process finds the receipts which are in pending escheatment status and makes them ready for disbursement to Treasury. | Financials | No | Annual | |
| 119 | NJB8590 | BATCH_FIN_ESCHEATMENT.SP_MARK_PENDING_ESCHEAT | This process finds the eligible Unidentified Receipts where the receipt date >= 365 days and marks them Pending Escheatment. Also it marks the NCP address holds as Pending escheatment where the date >= 365 days | Financials | No | Annual | |
| 120 | NJB1810 | BATCH_FIN_TERMINATION.SP_PROCESS_TERMINATION | This process BATCH_FIN_TERMINATION automatically terminates qualifying support obligations for dependent members upon reaching their termination date. It performs financial adjustments and order changes accordingly. This program is also responsible to trigger generation of the CS740T notice for the terminating Dependent and close all the in-progress termination activity. | Financials | Yes | Daily | |
| 121 | NJB9070 | BATCH_FIN_IRS_NADJ.SP_PROCESS_IRS_NADJ | This procedure processes the IRS negative adjustments by backing out (reverse) the original receipt and reposts a new receipt if there is a difference in the amount. | Financials | Yes | Daily | |
| 122 | NJB0550 | BATCH_FIN_RELEASE_RECEIPT.SP_RELEASE_RECEIPT | This process retrieves all held receipts from the Receipt History (RHIS) Screen / RECEIPT (RCTH) table and releases them based on the receipt release date in the receipt or if the UDC Code in which they had been held is no longer valid. | Financials | Yes | Daily | |
| 123 | NJB0580 | BATCH_FIN_TANF_DISTRIBUTION.SP_TANF_DISTRIBUTION | The TANF Distribution processes money applied to TANF during the Distribution Batch process. This program will run daily after the IV-A grant file has been processed through batch | Financials | Yes | Daily | |
| 124 | NJB6050 | BATCH_FIN_FC_DISTRIBUTION.SP_FC_DISTRIBUTION | The Foster Care Distribution batch program runs once a month and processes records from Distribution Hold (DHLD screen) – DHLD table on hold type “E-Foster Care Hold” | Financials | Yes | Monthly | |
| 125 | NJB0590 | BATCH_FIN_EFTST.SP_EFT_STATUS_UPDATE | This process changes the status of the CP’s EFT from ‘PG’ – Pre-note Generated to ‘AC’ - Activated after 7 business days and there was no rejection status from the bank. | Financials | Yes | Daily | |
| 126 | NJB0600 | BATCH_FIN_RELEASE_DISB_HOLD.SP_RELEASE_DISB_HOLD | This process releases all disb holds once they have reached the specified release date on the record. Address Holds are also released in this process, if there is a new Direct Deposit or Stored Value Card or Mailing address available for the recipient. | Financials | Yes | Daily | |
| 127 | NJB1010 | BATCH_FIN_RELEASE_RECEIPT.SP_REFUND_RECEIPT | Automatic refund for Held receipts | Financials | Yes | Daily | |
| 128 | NJB0680 | BATCH_FIN_STALE_CHECKS.SP_PROCESS_STALE_CHECKS | It identifies checks with 'OU' status for more than 180 days and reissue them with the reason Stale. It also identifies all the reissued 'OU' check disbursements with ‘ST’ for more than 180 days and disburses if there is an active EFT / SVC setup. | Financials | Yes | Daily | |
| 129 | NJB0620 | BATCH_FIN_DISBURSEMENT.SP_DISB_RECOUP | This process creates disbursement entries in Disbursement header (VDSBH) and Disbursement detail (VDSBL) tables. The program also recovers recoupments that are set for a Funds Recipient according to pre-specified rules. | Financials | Yes | Daily | |
| 130 | NJB0610 | BATCH_FIN_CP_RECOUP_NOTICE.SP_CP_RECOUP_NOTICE | The batch process either sends recoupment notices to the CPs or moves Pending recoupment to Active recoupment based on different conditions. This batch generates four different recoupment notices to the CPs based on different conditions. | Financials | No | Daily | |
| 131 | NJB1470 | BATCH_FIN_RECOUP_DISB.SP_RECOUP_DISB | This batch process inserts records into new VCRDB (CREC Disbursements) table with the sum of recoupment disbursement to SDU and/or State with blank control number. This batch will process any recoupment transactions that were created in VPOFL table after the last run date of this new batch. This will ensure that old VPOFL transactions are not included in the current batch execution | Financials | No | Daily | |
| 132 | NJB0630 | BATCH_FIN_EXT_CHECK.SP_CHECK_PRINTING | It extracts all check disbusements requiring check # assignment and assigns check numbers sequentially by incrementing the last used check number. The process also generates positive pay file to the bank and check print file for printing checks. | Financials | Yes | Daily | |
| 133 | NJB0640 | BATCH_FIN_EFT_SVC_PNOTE_DISB.SP_EXTRACT_EFT_SVC_PNOTE_DISB | 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 PNC Bank. | Financials | Yes | Daily | ||||
| 134 | NJB1500 | BATCH_FIN_ACCRUAL.SP_PRE_BATCH_ACCRUAL | Pre Accrual | Financials | Yes | Daily | |
| 135 | NJB0530 | BATCH_FIN_ACCRUAL.SP_BATCH_ACCRUAL_DAILY | The process selects all open cases with open obligations and accrue for the period specified on the obligation by means of the frequency. | Financials | Yes | Daily | |
| 136 | NJB1510 | BATCH_FIN_ACCRUAL.SP_POST_BATCH_ACCRUAL | Post Accrual | Financials | Yes | Daily | |
| 137 | NJB1480 | BATCH_FIN_COLLECTIONS.SP_PRE_COLLECTIONS | Pre collection | Financials | Yes | Daily | |
| 138 | NJB0540 | BATCH_FIN_COLLECTIONS.SP_COLLECTIONS | This procedure reads the SDU, IRS and SOIL receipts and loads data to the Collection Batch Posting (CBAT) screen / RECEIPT_BATCH (RBAT) and Batch Receipt Posting (BATR) screen / RECEIPT (RCTH) tables. | Financials | Yes | Daily | |
| 139 | NJB1490 | BATCH_FIN_COLLECTIONS.SP_POST_COLLECTIONS | Post collection | Financials | Yes | Daily | |
| 140 | NJB1270 | BATCH_FIN_REG_DISTRIBUTION.SP_PRE_DIST | Pre distribution to capture all the records which are going to be processed by distribution batch. | Financials | Yes | Daily | |
| 141 | NJB1280 | BATCH_FIN_REG_DISTRIBUTION.SP_POST_DIST_UPDATES | Post distribution to clear up the temparary tables used in distribution batch. | Financials | Yes | Daily | |
| 142 | NJB0560 | BATCH_FIN_REG_DISTRIBUTION.SP_REGULAR_DISTRIBUTION | This process identifies the receipts not previously distributed, which are either case identified or NCP identified from reconciled batches and distributes the payment to the Recipients using PRWORA rules | Financials | Yes | Daily | |
| 143 | NJB0880 | BATCH_FIN_GENERATE_FINS.SP_FIN_SUM_GENERATE_RESULT | This process populates all the Collection, Distribution and Disbursement details necessary for FINS Report. This report will display the Collection, Distribution and Disbursement details for any particular given date. | Financials | Yes | Daily | |
| 144 | NJB0980 | BATCH_ENF_STAGING.SP_INSERT_ENF_STAGING_DETAILS | Arrears Calculation | Enforcement | Yes | Daily | |
| 145 | NJB0900 | BATCH_FIN_REPORTS.SP_LOAD_DIHR | This process loads the details about payments that are currently on disbursement hold. These details are obtained from VDHLD table and are stored in RDIHR table in convenient way to display the Disbursement Hold Receipt Report (DIHR). | Financials | No | Daily | |
| 146 | NJB0910 | BATCH_FIN_REPORTS.SP_LOAD_DHRR | This process loads the details about distribution hold receipts. These details are obtained from VRCTH table and are stored in RDHRR table in convenient way to display the Distribution Hold Receipts Report (DHRR). | Financials | No | Daily | |
| 147 | NJB1450 | BATCH_FIN_REPORTS.SP_LOAD_SVAR | Takes stopped, voided and cashed checks data from VDSBH, VDSBL and loads into RSVDR and sets the specific disbursement type (CP, NCP, FINS, REFUND, OTHP) | Financials | No | Daily | |
| 148 | NJB0690 | BATCH_ENF_DL_SUSPENSION.SP_IDENTIFY_DL_SUSPENSION | This process selects NCPs eligible for driver license suspension and loads an entry in VELFC table to start the remedy. | Enforcement | No | Daily | |
| 149 | NJB0720 | BATCH_ENF_NMSN. SP_IDENTIFY_NMSN | Identify cases eligible for NMSN remedy | Enforcement | No | Daily | |
| 150 | NJB0710 | BATCH_LOC_NEWHIRE.SP_EXT_NEWMEMBER_STATEHIRE | The purpose of this process is to extract the newly added Member’s from the VDEMO table and send a file to the State Directory New Hire. | Locate | No | Daily | |
| 151 | NJB0730 | BATCH_FIN_EXT_SVC_ENROLLMENT.SP_EXT_ENROLLMENT | This process extracts all the CPs who didn’t respond to the CS174 notice (to enroll in Direct Deposit) for more than 20 business days, to automatically enroll for the stored value card. | Financials | No | Daily | |
| 152 | NJB0740 | BATCH_CI_OUTGOING_CSENET_TRANS.SP_CSENET_INIT_TRAN | This process reads the transaction tables, checks for required field validations and formats of the data according to the CSENET and creates an outbound file for CSENET. | Case Initiation | No | Daily | |
| 153 | NJB0745 | BATCH_CI_OUTGOING_CSENET_TRANS.SP_MONITOR_CSENET_TIMERS | Monitor CSENET INCOMING/OUTGOING REFERRAL TIMERS | Case Initiation | No | Daily | |
| 154 | NJB0750 | BATCH_FIN_EXT_NJSDU.SP_EXT_NJSDU | This procedure identifies the cases according to the selection criteria specified below, moves the data to the temporary table and creates an output file to SDU. | Financials | No | Daily | |
| 155 | NJB5090 | BATCH_FIN_EXT_BILLING.SP_EXT_BILLING | This process creates the extract of billing coupon file to be sent to NCP. NCP suppressed from the billing coupon are excluded from this process | Financials | No | Weekly | |
| 156 | NJB0800 | BATCH_FIN_GENERATE_EFT_NOTICE.SP_GENERATE_EFT_NOTICE | This process generates the CS174 (direct deposit) notice for eligible CPs | Financials | No | Daily | |
| 157 | NJB0950 | ccsr.CCSR.runCCSR() | Java code is called from Autosys to create court summary PDF in App server | General | No | Daily | |
| 158 | NJB5280 | BATCH_CM_CASE_REASSIGNMENT.SP_PROCESS_CASE_REASSIGNMENT | This batch process will process all the case reassignment requests received from the online screen and reassign cases to workers based on the alpha ranges and request type | Case Management | No | Weekly | |
| 159 | NJB5290 | BATCH_LOC_EXT_FCR.SP_IDENTIFY_TRANSACTIONS | The purpose of this process is to identify the actions (Add/Change/Delete) taken by the worker / System against the case and participant data in the NJKiDS database and move the key fields to the temporary table PFTRK for further processing. | Case Management | No | Weekly | |
| 160 | NJB5300 | BATCH_FIN_EXT_NJSDU.SP_EXT_NJSDU_MASTER | This procedure identifies the cases according to the selection criteria specified below, moves the data to the temporary table and creates an output file to SDU. | Financials | No | Weekly | |
| 161 | NJB5330 | BATCH_ENF_EXT_UIB.SP_EXT_MEMBERS | The process extracts all the active CPs and NCPs of open IVD cases from the system and creates an output file to LWD – Labor and Workforce Development. | Locate | No | Weekly | |
| 162 | NJB5370 | BATCH_LOC_NEWHIRE.SP_EXT_MEMBER_STATEHIRE | The purpose of this process is to extract the Member information from the VDEMO table every week and send a file to the State Directory New Hire. | Locate | No | Weekly | |
| 163 | NJB5380 | BATCH_LOC_EXT_FCR.SP_CREATE_FCR_TRANSACTIONS | The purpose of this process is to extract Case details and Participant details from NJKiDS database for the cases and participants in the PFTRK table, format the data and load them into temporary tables to create an extract file to Federal Case Registry. | Locate | No | Weekly | |
| 164 | NJB5080 | BATCH_ENF_MVC.SP_EXT_NCPS | This process extracts all the NCPs / CPs who have at least one open IVD Case, Confirmed Good Primary SSN or Confirmed Good ITIN and do not have Confirmed Good driver’s license number or Confirmed Good non-legal address and creates an output file to MVC. | Locate | No | Weekly | |
| 165 | NJB5500 | BATCH_ENF_USSO_DELETE.SP_DELETE_UNSIGNED_HEARING | This batch will automatically delete the unsigned USSO records (not signed by any party, attorney, hearing officer, or Judge) where the values of the Hearing date field (VUSSO/DT_HEARING) is less than or equal to the batch run date less 90 calendar days | Case Initiation | No | Weekly | |
| 166 | NJB5440 | BATCH_CM_CASE_CLOSURE_ELIG.SP_PRE_CASE_CLOSURE | Loads the cases into PCCLR staging table which will be processed by case closure batch | Case Management | No | Weekly | |
| 167 | NJB5450 | BATCH_CM_CASE_CLOSURE_ELIG.SP_POST_CASE_CLOSURE | Checks the predecessor (case closure) job to verify its successful execution. If failed to complete, this job will get abended. | Case Management | No | Weekly | |
| 168 | NJB5270 | BATCH_CM_CASE_CLOSURE_ELIG.SP_PROCESS_CASE_CLOSURE | This procedure identify all cases that are eligible for case closure and insert a record into VELFC to initiate the Case Closure Activity Chain. | Case Management | No | Weekly | |
| 169 | NJB7600 | BATCH_ENF_ELFC.SP_PROCESS_ELFC_QUARTERLY | This procedure selects the cases eligible to be inserted into VELFC table, which then will be picked up by ELFC. It initiates/closes the remedies | Enforcement | No | Qtly | |
| 170 | NJB5410 | BATCH_ENF_ELFC.SP_PROCESS_ELFC_WEEKLY | This procedure selects the cases eligible to be inserted into VELFC table, which then will be picked up by ELFC. It initiates/closes the remedies | Enforcement | No | Weekly | |
| 171 | NJB5470 | BATCH_ENF_EMON.SP_PRE_EMON_WEEKLY | Pre EMON Weekly | Enforcement | No | Weekly | |
| 172 | NJB5480 | BATCH_ENF_EMON.SP_POST_EMON_WEEKLY | Post EMON Weekly | Enforcement | No | Weekly | |
| 173 | NJB7540 | BATCH_ENF_CBOR.SP_PROCESS_CBOR | This process identifies the NCP DCN’s who are eligible for the credit bureau reporting and eligible NCP’s are selected for remedy process. | Enforcement | No | Monthly | |
| 174 | NJB5420 | BATCH_ENF_EMON.SP_PROCESS_EMON_WEEKLY | This process monitors the Compliance Schedule, IRS Full Collection and COLA Update processes. | Enforcement | No | Weekly | |
| 175 | NJB0660 | BATCH_ENF_ELFC.SP_PROCESS_ELFC_DAILY | This process reads records from VELFC table and initiates/closes remedies based on the eligibility criteria. | Enforcement | Yes | Daily | |
| 176 | NJB0666 | BATCH_ENF_EMON.SP_VALIDATE_PAYBACK | UPDATE ARREARS PAYBACK FOR ARREAS LESS THAN ZERO | Enforcement | Yes | Daily | |
| 177 | NJB0664 | BATCH_ENF_EMON.SP_PRE_EMON | LOAD EMON DAILY PROCESSING RECORDS | Enforcement | Yes | Daily | |
| 178 | NJB0674 | BATCH_ENF_EMON.SP_POST_EMON_UPDATES | UPDATES VIWEM AND VACEN | Enforcement | Yes | Daily | |
| 179 | NJB0676 | BATCH_ENF_EMON.SP_POST_EMON_ALERTS | CREATES ALERT FOR SPAID AND NOBAL | Enforcement | Yes | Daily | |
| 180 | NJB1220 | BATCH_ENF_STAGING.SP_INSERT_ENSD_POST_EMON | REFILLS THE VENSD TABLE AFTER EMON BATCH | General | Yes | Daily | |
| 181 | NJB1820 | BATCH_FIN_GENERATE_TERM_NOTICE. SP_PROCES_TERM_NOTICES | This Job generates Pre-Termination notice of eligible Dependents and send it to CP/NCP or send it as CSENET Transactions for Interstate Cases. |
CS735 - 180 Days before Termination.
CS736 - 90 Days before Termination.
| CS737 - 90 Days before Termination of Court Ordered case/IVE Case. | Case Management | No | Daily | ||||
| 182 | NJB1670 | BATCH_FIN_REPORTS.SP_LOAD_NOTE | Create management Note Report | Reporting | No | Daily | |
| 183 | NJB0670 | BATCH_ENF_EMON.SP_PROCESS_EMON_DAILY | The process updates the current In-Progress Minor Activity after the due date for that activity is just completed and inserts the next Minor Activity depending on the reason selected for updating the current In-Progress Minor Activity. | Enforcement | Yes | Daily | |
| 184 | NJB1250 | BATCH_ENF_GEN_EIWO.SP_EXT_EIW | Extracts the e-IWO to the employers | Enforcement | No | Daily | |
| 185 | NJB0700 | BATCH_ENF_DL_SUSPENSION.SP_PROCESS_DL_SUSPENSION | This process gets NCP for whom the Bench Warrant has been issued and/or license suspension has been ordered and creates license suspend / reinstate file to Motor Vehicle Commission. | Enforcement | No | Daily | |
| 186 | NJB5490 | BATCH_UTL_COMMON.SP_UPDATE_HSKEY | Move VSKEY data into HSKEY table | ||||
| retaining any latest information for a Screen/worker in the VSKEY table | General | No | Weekly | ||||
| 187 | NJB5610 | BATCH_UTIL_RESTORE.SP_ARCHIVE_VRLOG | ARCHIVE THE VRLOG TABLE | General | No | Weekly | |
| 188 | NJB6350 | BATCH_FIN_EXT_TO_IVE.SP_EXT_IVE | This procedure identifies the IVE cases and creates an output file with monthly collections to IVE. | Financials | Yes | Daily | |
| 189 | NJB1760 | BATCH_CUSW_OUTBOUND_CALLS.SP_EXT_OUTCALLS | File to make outbound calls | General | No | Daily | |
| 190 | NJB5580 | BATCH_ADDR_NORMALIZATION.SP_EXT_UNNORM_ADDR_2NDATTMPT | Extracts unnormalized addresses for 2nd attempt | General | No | Weekly | |
| 191 | NJB5340 | BATCH_ENF_EXT_UIB_GARNISHMENT.SP_EXT_UIB_GARNISHMENT | The process extracts all the members who are eligible for garnishment and creates an output file to LWD – Labor and Workforce Development. | Enforcement | No | Weekly | |
| 192 | NJB5350 | BATCH_ENF_FIDM.SP_EXT_NCPS | This process creates an extract file to FIDM – Financial Institution Data Match with NCPs to match the NCP’s financial assets. | Enforcement | No | Weekly | |
| 193 | NJB5355 | BATCH_LOC_EXT_CLEAR.SP_EXT_MEMBER_DTLS | EXTRACTS NCP Details for CLEAR monitoring | Locate | No | Weekly | |
| 194 | NJB5360 | BATCH_ENF_CBTW.SP_PROCESS_CBTW | This process extracts the delinquent NCPs who have not responded to the CS044 notice for more than 40 days and has an arrear greater than or equal to $1000 | Enforcement | No | Weekly | |
| 195 | NJB5400 | BATCH_FIN_EXT_CEN_PAYROLL.SP_EXT_CEN_PAYROLL | This process extracts all the NCPs who have active incomewitholding. | Financials | No | Weekly | |
| 196 | NJB5070 | BATCH_ENF_EXT_LOTTERY.SP_EXT_NCPS | This process identifies NCPs whose arrears is greater than or equal to $600 and creates an output file for matching the Lottery winners. | Enforcement | No | Weekly | |
| 197 | NJB5310 | BATCH_ENF_EXT_IRS.SP_EXT_NCPS | The process extracts delinquent NCPs to IRS for FOP programs (IRS, MSFIDM, Passport Denial, Administrative Offset and Debt check). The next step in this process checks for the updates to the list sent to IRS and appended to the above extract. | Enforcement | No | Weekly | |
| 198 | NJB8550 | BATCH_ENF_EXT_SOIL.SP_EXT_NCPS_AFDC | This process extracts delinquent NCPs to DOR – Department of Revenue for SOIL programs (State Tax, Homestead Rebate and Savers). | Enforcement | No | Weekly | |
| 199 | NJB6010 | BATCH_ENF_CSLN.SP_EXT_NCPS | This process creates an extract file to CSLN – Child Support Lien Network with NCPs to match the NCP’s insurance claim information. | Enforcement | No | Weekly | |
| 201 | NJB5640 | BATCH_ENF_EXT_LUMPSUM.SP_EXT_LUMPSUM | This process generates extract file of all cases eligible for lumpsum payments. | Enforcement | No | Weekly | |
| 202 | NJB5595 | BATCH_ADDR_NORMALIZATION.SP_EXT_NORMALIZATION_NCOA | EXTRACT DATA FOR NORMALIZATION AND NCOA FOR RRD | General | No | Weekly | |
| 203 | NJB5110 | BATCH_ENF_SOIL_UPDATES.SP_PROCESS_HIT_NOTICE_AFDC | This process reads the data from the temporary table LOAD_SOIL_NOTIFICATION and creates an AFDC update file to DOR – Department of Revenue. |
| This process may go off once the CR is approved. Normally, these process runs after daily | Enforcement | No | Weekly | ||||
| 204 | NJB5430 | BATCH_ENF_SOIL_UPDATES.SP_GENERATE_SOIL_NOTICE | This procedure is used to generate 'CS087' and 'CS089' notices for 'I - Debt Information Update which are sent to SOIL | Enforcement | No | Weekly | |
| 205 | NJB6365 | BATCH_ENF_WORKER_COMPENSATION.SP_EXT_NCPS | Extracts Members to Workers' comp | Financials | No | Monthly | |
| 206 | NJB6360 | BATCH_ENF_ACMS.SP_EXT_NCPS | This process identifies the cases that have an arrears amount greater than $250 when the case is not currently charging or arrears amount exceeds one month periodic amount and creates an extract file to ACMS - Automated Case Management System. | Enforcement | No | Monthly | |
| 207 | NJB6530 | BATCH_FIN_EXT_IVE_ORD_DEMO.SP_EXTRACT_IVE_DETAILS | Extracts the demo details for all IVE / Non-IVE members | Financials | No | Monthly | |
| 208 | NJB6020 | BATCH_LOC_EXT_NJ_QTLY_WAGE.SP_EXT_PAYER_DETAILS | This process extracts all active CPs / NCPs from the NJKiDS database and loads it to the temporary table EXTRACT_STATE_QUARTERLY_WAGE. In addition, it also creates a file to the Labor and Workforce Development. | Locate | No | Monthly | |
| 209 | NJB6490 | BATCH_LOC_EXT_DOC.SP_EXT_MEMBERS | Extracts NCPs to Department of Corrections | Locate | No | Monthly | |
| 210 | NJB6370 | BATCH_ENF_EXT_MEDICAID.SP_EXT_MEMBERS | Address Normalization of input file records | Enforcement | No | Monthly | |
| 211 | NJB7700 | BATCH_FIN_REPORTS.SP_LOAD_SQCR | Sheriff quarterly collections report data will be populated at the end of every quarter using a new extract batch | Financials | No | Qtly | |
| 212 | NJB7530 | BATCH_FIN_EXT_BILLING.SP_EXT_BILLING_MASTER | This process creates the extract of billing coupon file to be sent to NCP. NCP suppressed from the billing coupon are excluded from this process | Financials | No | Qtly | |
| 213 | NJB7680 | BATCH_FIN_CP_NOTICES.SP_PRE_GEN_CP_NOTICES | Pre Gen CP Notices to capture all the records which are going to be processed by CP Notices batch. | Financials | No | Qtly | |
| 214 | NJB7690 | BATCH_FIN_CP_NOTICES.SP_POST_GEN_CP_NOTICES | Post Gen CP Notices to do Post activities | Financials | No | Qtly | |
| 215 | NJB7670 | BATCH_FIN_ASSESS_DRA_FEE.SP_ASSESS_DRA_FEE | Assess DRA Fee | Financials | No | Qtly | |
| 216 | NJB9320 | BATCH_CI_EXT_ICR.SP_EXT_ICR | The purpose of this process is to extract Case details and Participant details from NJKiDS database for all open and closed interstate and load them into temporary table EXTARCT_ICR to create an extract file to ICR | Case Management | Yes | On-request | |
| 217 | NJB7610 | BATCH_FIN_CP_NOTICES.SP_GEN_CP_NOTICES | The process describes the creating and generation of a quarterly Notices for Assigned collections to the custodial parents who are currently on IV-A, or were former IV-A. The notice is generated for the each eligible case ID associated with the CP | Financials | No | Qtly | |
| 218 | NJB8640 | BATCH_ENF_EXT_COUNTIES.SP_EXT_COUNTIES | The process extracts all county probation offices FIPS, Address and Phone number information, prepares, and transmits a file to IRS to update their database. | Enforcement | No | Annual | |
| 219 | NJB8010 | BATCH_LOC_EXT_DOR.SP_EXT_PAYER_DETAILS | This process extracts all NCP details from NJKiDS and loads the information to the temporary table, then creates a file for Department of Revenue. | Locate | No | Semi-Annual | |
| 220 | NJB8610 | BATCH_FIN_EXT_ESCHEATMENT.SP_EXT_ESCHEATMENT_FUNDS | The purpose of this process is to send a file with the escheated funds to treasury. | Financials | No | Annual | |
| 221 | NJB9020 | BATCH_ENF_EXT_IRS_RECON.SP_EXT_IRS_RECON | The process is an on-demand process which extracts the case reconciliation file to submit to IRS | Enforcement | No | On-request | |
| 222 | NJB8660 | BATCH_FIN_ANNUAL_STMNT.SP_PRE_GEN_ANNUAL_STMNT | Pre Annual statement to capture all the records which are going to be processed by batch. | Financials | No | Annual | |
| 223 | NJB8690 | BATCH_FIN_ANNUAL_STMNT.SP_POST_GEN_ANNUAL_STMNT | Post Process for annual statement | Financials | No | Annual | |
| 224 | NJB8700 | BATCH_FIN_ANNUAL_STMNT.SP_ANNUAL_EXTRACT_NOTICE | Creating extract file for annual statement. | Financials | No | Annual | |
| 225 | NJB8620 | BATCH_FIN_ANNUAL_STMNT.SP_GEN_ANNUAL_STMNT | This process generates annual statements to CPs and NCPs by January 31st of every year to include case financial data from January 1 through December 31 of the prior calendar year. | Financials | No | Annual | |
| 226 | NJB8520 | BATCH_EST_POP_157_COUNTS.SP_PROCESS_EST_POP_157_COUNTS | This process reads the temporary table LOAD_EST_POP_157COUNTS and updates the table RPT_OCSE157_RESULT_TBL with the counts information of lines 8 and 10 for the fiscal year. | Establishment | Yes | Annual | |
| 227 | NJB8540 | BATCH_EST_POP_RECON.SP_POP_RECON | This process reads the temporary table and finds the Members (NCP, CP and Child) match. If the match is found then the DP’s paternity indicator and the place of birth are updated in the system. | Establishment | No | Annual | |
| 228 | NJB9110 | BATCH_FIN_MONITORING_FEE.SP_PROCESS_ASSESS_NON_IVD | The process batch_fin_monitoring_fee will read the NJKiDS database to get the Non IVD cases for assessing the $25 fee and generates the notice | Financials | No | Annual | |
| 229 | NJB8720 | BATCH_ENF_FCR_RECON.SP_PRE_FCR_RECON | PROCESS FCR RECONCILIATION FILE AND CREATES EXTRACT FILE | Case Management | Yes | On-request | |
| 230 | NJB8730 | BATCH_ENF_FCR_RECON.SP_PROCESS_FCR_ACTIVITY | CREATES CASE JOURNAL ACTIVITY FOR FCR/SSN TRANSACTION MADE | Case Management | Yes | On-request | |
| 231 | NJB8740 | BATCH_ENF_FCR_RECON.SP_POST_FCR_RECON | VERIFIES THE FCR ACTIVITY THREAD JOB COMPLETION | Case Management | Yes | On-request | |
| 232 | NJB0960 | BATCH_AFP_NOTICE_GENERATION.SP_UPDATE_PACKAGE_ID | This process is to bundle(Package ID Creation) the eligible notices based on the recipient information, service type (Certified or Regular) and Paper style | General | No | Daily | |
| 233 | NJB0970 | afpb.AFPB.runAFP() | This process is to create AFP files for the bundled notices through a Java routine. The generated AFP notice files will be sent to Central Printing Process | General | No | Daily | |
| 234 | NJB0810 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP1 | Extracting data for BI Map | Reporting | No | Daily | |
| 235 | NJB0820 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP2A | Extracting data for BI Map | Reporting | No | Daily | |
| 236 | NJB0830 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP2B | Extracting data for BI Map | Reporting | No | Daily | |
| 237 | NJB0833 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP2C | Extracting data for BI Map | Reporting | No | Daily | |
| 238 | NJB0836 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP2D | Extracting data for BI Map | Reporting | No | Daily | |
| 239 | NJB0840 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP3A | Extracting data for BI Map | Reporting | No | Daily | |
| 240 | NJB0845 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP3B | Extracting data for BI Map | Reporting | No | Daily | |
| 241 | NJB0850 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP4A | Extracting data for BI Map | Reporting | No | Daily | |
| 242 | NJB1370 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP4B | Extracting data for BI Map | Reporting | No | Daily | |
| 243 | NJB1380 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP4C | Extracting data for BI Map | Reporting | No | Daily | |
| 244 | NJB1390 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP4D | Extracting data for BI Map | Reporting | No | Daily | |
| 245 | NJB1400 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP5A | Extracting data for BI Map | Reporting | No | Daily | |
| 246 | NJB1410 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP5B | Extracting data for BI Map | Reporting | No | Daily | |
| 247 | NJB1420 | BATCH_BI_MAPCM_EXTRACT.SP_LOAD_BI_DAILY_STEP5C | Extracting data for BI Map | Reporting | No | Daily | |
| 248 | NJB0860 | BATCH_BI_SA_EXTRACT.SP_LOAD_SA_COMPONENTS | The purpose of this batch is to extract the details required for Self Assessment components into the intermediate tables. | Self Assessment | No | On-request | |
| 249 | NJB9170 | bisa.BISA.runBISA() | To generate the files for Self Assessment Components | Reporting | No | On-request | |
| 250 | NJB6560 | BATCH_BIMD.SP_LOAD_BI_MGR_CASE | THIS BATCH PROGRAM IS USED TO LOAD CASE DETAILS INFORMATION FROM BI_CASE | Reporting | No | Monthly | |
| 251 | NJB6570 | BATCH_BIMD.SP_LOAD_BI_MGR_MEMBER | THIS BATCH PROGRAM IS USED TO LOAD MEMBER DETAILS INFORMATION FROM BI_MEMBER | Reporting | No | Monthly | |
| 252 | NJB6680 | BATCH_BIMD.SP_LOAD_BI_MGR_TCASE | THIS PROCEDURE IS USED TO LOAD DATA FROM VCASE INTO BI_MGR_TCASE | Reporting | No | Monthly | |
| 253 | NJB6580 | BATCH_BIMD.SP_LOAD_BI_FED_MEASURES | THIS BATCH PROGRAM IS USED TO LOAD FEDERAL MEASURES AT CASE LEVEL AND SUMMARY AT MONTH LEVEL | Reporting | No | Monthly | |
| 254 | NJB6590 | BATCH_BIMD.SP_LOAD_BI_CASELOAD_TYPE_RELF | THIS BATCH PROGRAM IS USED TO LOAD CURRENT CASE LOAD BY COUNTY LEVEL, CASE TYPE INFORMATION, RELIEF RESULT ANALYSIS | Reporting | No | Monthly | |
| 255 | NJB6600 | BATCH_BIMD.SP_LOAD_BI_WORKFLOW_STEP1 | THIS STEP1 BATCH PROGRAM IS USED TO LOAD WORKFLOW ACTIVITY INFORMATION | Reporting | No | Monthly | |
| 256 | NJB6610 | BATCH_BIMD.SP_LOAD_BI_WORKFLOW_STEP2 | THIS STEP2 BATCH PROGRAM IS USED TO LOAD WORKFLOW ACTIVITY INFORMATION | Reporting | No | Monthly | |
| 257 | NJB6620 | BATCH_BIMD.SP_LOAD_BI_WORKFLOW_STEP3 | THIS STEP3 BATCH PROGRAM IS USED TO LOAD WORKFLOW ACTIVITY INFORMATION | Reporting | No | Monthly | |
| 258 | NJB6630 | BATCH_BIMD.SP_LOAD_BI_COLLECTION | THIS BATCH PROGRAM IS USED TO LOAD COLLECTION INFORMATION FROM VRCTH AND VLSUP | Reporting | No | Monthly | |
| 259 | NJB6640 | BATCH_BIMD.SP_LOAD_BI_DISTRIBUTION | THIS BATCH PROGRAM IS USED TO LOAD DISTRIBUTION INFORMATION FROM VRCTH AND VLSUP | Reporting | No | Monthly | |
| 260 | NJB6650 | BATCH_BIMD.SP_LOAD_BI_DISBURSEMENT | THIS BATCH PROGRAM IS USED TO LOAD DISBURSEMENT INFORMATION FROM VDSBL, VDSBH | Reporting | No | Monthly | |
| 261 | NJB6660 | BATCH_BIMD.SP_LOAD_BI_DIST_DISB_HOLD | THIS BATCH PROGRAM IS USED TO LOAD DISBURSEMENT, DISTRIBUTION HOLD INFORMATION | Reporting | No | Monthly | |
| 262 | NJB6670 | BATCH_BIMD.SP_LOAD_BI_FINANCE_RESULT | THIS BATCH PROGRAM IS USED TO LOAD COLLECTION, DISTRIBUTION, DISBURSEMENT, DISTRIBUTION HOLD, DISBURSEMENT HOLD SUMMARY INFORMATION | Reporting | No | Monthly | |
| 263 | NJB6710 | BATCH_OPRT_GROUP1.SP_EXT_SOIL_COLLECTIONS | Operation Reports - State Collection | Case Management | Yes | Monthly | |
| 264 | NJB6720 | BATCH_OPRT_GROUP1.SP_EXT_TAX_OFFSET | Operation Reports - Tax Offset | Case Management | Yes | Monthly |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .