METHOD AND SYSTEM FOR IMPLEMENTING HEADER AND TRAILER RECORD VALIDATIONS

• US 20200134028A1
• Filed: 10/25/2018
• Published: 04/30/2020
• Est. Priority Date: 10/25/2018
• Status: Active Grant

• Current Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Original Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Inventors: WINIARSKI, Robert A.
• Granted Patent: US 10,884,983 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/164 File meta data generation
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

The invention relates to header and trailer record validation for batch files. According to an embodiment of the present invention, a computer implemented system implements a Header/Trailer Validation Tool. The Header/Trailer Validation Tool may read a control file containing pertinent information of each file to be validated. Key information may be determined at run time and the Header/Trailer Validation Tool may process the files dynamically. An embodiment of the present invention may also process any number of files in a single execution—this is particularly useful because in some cases a set of files may be received from another application, but not all the files may be used at the same time.

Claims

1. A computer implemented system that implements a header and trailer validation tool for batch files, the system comprising:

a memory interface that accesses a database table;

an interactive interface that receives a user selection; and

a processor, coupled to the memory interface and the interactive interface, that executes a set of JCL (Job Control Language) program lines inserted into a parameter driven program and further configured to perform the steps comprising;

receiving a plurality of files from a plurality of applications;

for each file, accessing a control card to identify a header format and a trailer format;

retrieving a filename from the control card;

dynamically reading a file corresponding to the filename;

for each record of the file, identifying a header field based on the header format and identify a trailer field based on the trailer format; and

at the end of the file, confirming that the header field corresponds to the header format and confirm that the trailer field matches a number of records in the file.

2. The computer implemented system of claim 1, wherein the header field represents a date field.

3. The computer implemented system of claim 2, wherein the date field is specific to a geographic region.

4. The computer implemented system of claim 2, wherein the date field represents a system date.

5. The computer implemented system of claim 1, wherein the trailer field represents a numeric value that represents a number of records in the file.

6. The computer implemented system of claim 1, wherein the control card comprises a file name, one or more header record characteristics, one or more trailer record characteristics, a location and date format.

7. The computer implemented system of claim 1, wherein an override control card is implemented.

8. The computer implemented system of claim 1, wherein the trailer format includes the header field and the trailer field as part of the count.

9. The computer implemented system of claim 1, wherein the trailer format excludes the header field and the trailer field as part of the count.

10. The computer implemented system of claim 1, wherein the plurality of applications are received from a plurality of branch locations.

11. A computer implemented method that implements a header and trailer validation tool for batch files, the method comprising the steps of:

executing a set of JCL (Job Control Language) program lines inserted into a parameter driven program;

receiving a plurality of files from a plurality of applications;

for each file, accessing a control card to identify a header format and a trailer format;

retrieving a filename from the control card;

dynamically reading a file corresponding to the filename;

for each record of the file, identifying a header field based on the header format and identify a trailer field based on the trailer format; and

at the end of the file, confirming that the header field corresponds to the header format and confirm that the trailer field matches a number of records in the file.

12. The computer implemented method of claim 11, wherein the header field represents a date field.

13. The computer implemented method of claim 12, wherein the date field is specific to a geographic region.

14. The computer implemented method of claim 12, wherein the date field represents a system date.

15. The computer implemented method of claim 11, wherein the trailer field represents a numeric value that represents a number of records in the file.

16. The computer implemented method of claim 11, wherein the control card comprises a file name, one or more header record characteristics, one or more trailer record characteristics, a location and date format.

17. The computer implemented method of claim 11, wherein an override control card is implemented.

18. The computer implemented method of claim 11, wherein the trailer format includes the header field and the trailer field as part of the count.

19. The computer implemented method of claim 11, wherein the trailer format excludes the header field and the trailer field as part of the count.

20. The computer implemented method of claim 11, wherein the plurality of applications are received from a plurality of branch locations.