00001 ***** 12/05/14 00002 * DTSIX140 00003 * DTSIX140 EMPLOYER TAX REPORT EXTRACT RECORD LV003 00004 * DTSIX140 00005 * EXCHANGES EMPLOYER TAX REPORTS BETWEEN MAINFRAME AND DTSIX140 00006 * SQL SERVER DATABASE. DTSIX140 00007 * DTSIX140 00008 * 05/04/2010 ADDED CHECK SCAN DATE, CHECK SEQUENCE NBR, DTSIX140 00009 * LEVEL-88 FOR REPORTS FROM IN-HOUSE CASHIERING, DTSIX140 00010 * INTEREST AND PENALTY WAIVER INDICATORS, DTSIX140 00011 * RESPONSIBLE OPID AND ACTIVITY. GD DTSIX140 00012 ***** DTSIX140 00013 DTSIX140 00014 15 X140-REC-TYPE PIC X(03) VALUE '140'. DTSIX140 00015 15 FILLER PIC X(01) VALUE ','. DTSIX140 00016 15 X140-EMP-NO PIC 9(06). DTSIX140 00017 15 FILLER PIC X(01) VALUE ','. DTSIX140 00018 15 X140-QUARTER PIC X(06). DTSIX140 00019 15 FILLER PIC X(01) VALUE ','. DTSIX140 00020 15 X140-SOURCE PIC X(02). DTSIX140 00021 88 X140-WEB-RPT-88 VALUE '00'. CL**2 00022 88 X140-MAG-RPT-88 VALUE '01'. CL**2 00023 88 X140-IN-HOUSE-88 VALUE '02'. CL**2 00024 15 FILLER PIC X(01) VALUE ','. DTSIX140 00025 15 X140-REPORT-TYPE PIC X(02). DTSIX140 00026 88 X140-ORIG-88 VALUE 'OR'. DTSIX140 00027 88 X140-EMP-AMEND-88 VALUE 'EA'. DTSIX140 00028 88 X140-AUDIT-88 VALUE 'AU'. DTSIX140 00029 88 X140-FLD-SUP-88 VALUE 'FS'. DTSIX140 00030 88 X140-ADMIN-CORR-88 VALUE 'AC'. DTSIX140 00031 88 X140-ESTIM-88 VALUE 'ES'. DTSIX140 00032 88 X140-WITHDRW-88 VALUE 'WD'. DTSIX140 00033 15 FILLER PIC X(01) VALUE ','. DTSIX140 00034 15 X140-PSEUDO-BATCH-NO PIC 9(05). DTSIX140 00035 15 FILLER PIC X(01) VALUE ','. DTSIX140 00036 15 X140-PSEUDO-ITEM-NO PIC 9(03). DTSIX140 00037 15 FILLER PIC X(01) VALUE ','. DTSIX140 00038 15 X140-TOTAL-WAGES PIC ----------9.99. DTSIX140 00039 15 FILLER PIC X(01) VALUE ','. DTSIX140 00040 15 X140-TAX-WAGES PIC ----------9.99. DTSIX140 00041 15 FILLER PIC X(01) VALUE ','. DTSIX140 00042 15 X140-REMITTANCE PIC --------9.99. DTSIX140 00043 15 FILLER PIC X(01) VALUE ','. DTSIX140 00044 15 X140-CONFIRMATION PIC X(13). DTSIX140 00045 15 FILLER PIC X(01) VALUE ','. DTSIX140 00046 15 X140-RCVD-DATE PIC X(10). DTSIX140 00047 15 FILLER PIC X(01) VALUE ','. DTSIX140 00048 15 X140-WRKR-CNT-1ST-MNTH PIC 9(07). DTSIX140 00049 15 FILLER PIC X(01) VALUE ','. DTSIX140 00050 15 X140-WRKR-CNT-2ND-MNTH PIC 9(07). DTSIX140 00051 15 FILLER PIC X(01) VALUE ','. DTSIX140 00052 15 X140-WRKR-CNT-3RD-MNTH PIC 9(07). DTSIX140 00053 15 FILLER PIC X(01) VALUE ','. DTSIX140 00054 15 X140-CHECK-SCAN-DT PIC X(12). DTSIX140 00055 15 FILLER PIC X(01) VALUE ','. DTSIX140 00056 15 X140-CHECK-SEQ-NBR PIC 9(05). DTSIX140 00057 15 FILLER PIC X(01) VALUE ','. DTSIX140 00058 15 X140-WAIVE-INTEREST PIC X(01). DTSIX140 00059 88 X140-WAIVE-INT-YES-88 VALUE 'Y'. DTSIX140 00060 88 X140-WAIVE-INT-NO-88 VALUE 'N'. DTSIX140 00061 15 FILLER PIC X(01) VALUE ','. DTSIX140 00062 15 X140-WAIVE-PENALTY PIC X(01). DTSIX140 00063 88 X140-WAIVE-PEN-YES-88 VALUE 'Y'. DTSIX140 00064 88 X140-WAIVE-PEN-NO-88 VALUE 'N'. DTSIX140 00065 15 FILLER PIC X(01) VALUE ','. DTSIX140 00066 15 X140-RESP-ACTIVITY PIC X(03). DTSIX140 00067 15 FILLER PIC X(01) VALUE ','. DTSIX140 00068 15 X140-RESP-OPID PIC X(08). DTSIX140 00069 15 FILLER PIC X(01) VALUE ','. CL**3 00070 15 X140-WRKR-CNT-TOTAL PIC 9(07). CL**3