DR405FLTAPE.SQL Tape File for Tangible Personal Property Tax Returns

This batch procedure generates flat ASCII file for producing Tangible Personal Property Tax Return forms. This file will be called DR405TAPE.TXT.

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, DR405FLTAPE. 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 DR405FLTAPE.LIS to create the file in text format. 9. ID1: Enter the minimum Parcel ID to include in the report or zero to include all parcels. Enter IDLIST to run the report on a specific list of parcels. 10. ID2: If ID1 = minimum Parcel ID, enter the maximum Parcel ID associated with the parcels to include in the report. If ID1 = zero, enter ZZ for all parcels. If ID1 = IDLIST, enter the SETNAME of the IDLIST. 13. FCU: Formatting code. Keep the default printer setting that is present when the screen appears. If blank, enter HPLP132.

Figure 2. SY 41 (BOTTOM)

Press [Submit Job]. The system will notify you when the report is finished.

File Layout:

Data Column Field Length Table Name Column

TITLE VARCHAR2 (40) PPSYS.TITLE

NAME VARCHAR2 (40) PPSYS.NAME

ADDR1 VARCHAR2 (80) PPSYS.ADDR1

ADDR2 VARCHAR2 (80) PPSYS.ADDR2

ADDR3 VARCHAR2 (80) PPSYS.ADDR3

ZIP1 VARCHAR2 (05) PPSYS.ZIP1

ZIP2 VARCHAR2 (04) PPSYS.ZIP2

TAXYR NUMBER (04) PARAM.TAXYR

CNAME VARCHAR2 (15) COUNTY.NAME

PARID VARCHAR2 (30) PPADMN.PARID

TAXDIST VARCHAR2 (05) PPADMN.TAXDIST

USER1 VARCHAR2 (20) PPADMN.USER1

PPSTAT VARCHAR2 (01) PPADMN.PPSTAT

USECODE VARCHAR2 (04) PPADMN.USECODE

VAL0102 NUMBER (16,2) ASMT.VAL01+VAL02

ADRNO NUMBER (10) ADDRINDX.ADRNO

ADRADD VARCHAR2 (06) ADDRINDX.ADRADD

ADRDIR VARCHAR2 (02) ADDRINDX.ADRDIR

ADRSTR VARCHAR2 (30) ADDRINDX.ADRSTR

ADRSUF VARCHAR2 (08) ADDRINDX.ADRSUF

ADRSUF2 VARCHAR2 (08) ADDRINDX.ADRSUF2

CITYNAME VARCHAR2 (40) ADDRINDX.CITYNAME

UNITDESC VARCHAR2 (10) ADDRINDX.UNITDESC

UNITNO VARCHAR2 (10) ADDRINDX.UNITNO

ZIP11 VARCHAR2 (05) ADDRINDX.ZIP11

ZIP22 VARCHAR2 (04) ADDRINDX.ZIP22

LOC2 VARCHAR2 (40) ADDRINDX.LOC2

OWN1 VARCHAR2 (40) ADDRINDX.OWN1

OWN2 VARCHAR2 (40) ADDRINDX.OWN2

NAM VARCHAR2 (40) OWNALT.NAM

PADDR1 VARCHAR2 (121) ADDRINDX.PADDR1

PADDR2 VARCHAR2 (80) ADDRINDX.PADDR2

PADDR3 VARCHAR2 (123) ADDRINDX.PADDR3

Updated 7/21/2006