TX411 – Generic Mcpay Table load Program

This program:

1. Loads the data from the data (ASCII) file into TEMP_MCPAY table in the format specified by the CTL file.

2. Inserts into MCPAY from TEMP_MCPAY by validating parcel and rolltype from CHARGE table.

3. Prints exception listing (mismatch of Mortgage Company codes with MTGTAPE table).

4. Prints totals grouped by mortgage company.

NOTE: The specific fields with permissible entries to be filled in or left blank are listed below. Ignore fields that are not in the list next to the screens.

Figure 1. SY41 (TOP)

1. Job: Report name should always appear here. For example, TX411.

2. Server Name: Keep the server name that first appears.

3. Printer_Name: Select a valid printer or keep the displayed printer if one is present.

4. Jurisdiction: Enter your jurisdiction.

5. Tax Year: Enter the current Tax Year.

6. Spool File Name: Enter the output file name, for example, TX411.LIS.

7. Beginning Date: Enter the effective date.

8. Ending Date: Enter the business date.

9. ID1: Enter the input/data (ASCII) file name. It should include the path.

10. ID2: Enter name of the control file, including path. Default is 'TX411_LOAD.CTL'

13. FCU: Formatting code. Keep the default printer setting that is present when the screen appears.

17. PARAM1 ROLLTYPE:

Enter a valid rolltype or leave blank to get the first rolltype from CHARGE table. Default is blank.

18. PARAM2 TOT CHK AMT:

Enter the total check amount received from the mortgage company or tax service. This field is validated against sum of payment amount from the data file.

19. PARAM3 REPORT FLAG (Y/N):

If Y then the MCPAY altered amount will be produced otherwise it will not be displayed. Default is Y.