METADATA for newresident.csv and newresident ######################################################################################################## Both the comma separated value file and the data* file use the following fields in this order: Row 1: Parcel ID formatted to Range-Township-Section with no fillers between numbers (20 character field) 2: Name & Address Line 1 (35 character field) 3: Name & Address Line 2 (35 character field) 4: Name & Address Line 3 (35 character field) 5: Name & Address Line 4 (35 character field) 6: Name & Address Line 5 (35 character field) 7: Physical Address Line 1 (35 character field) 8: Physical Address Line 2 (35 character field) 9: Sale Date formatted to YYYYMMDD (8 character field) *The data file use a blank space for filler between fields. ######################################################################################################## COMMAFILE has the following layout: 01 FTP-RECORD-CD. 05 FTP-ID-CD PIC X(20). 05 FTP-COMMA1 PIC X. 05 FTP-NAMEADD1-CD PIC X(35). 05 FTP-COMMA2 PIC X. 05 FTP-NAMEADD2-CD PIC X(35). 05 FTP-COMMA3 PIC X. 05 FTP-NAMEADD3-CD PIC X(35). 05 FTP-COMMA4 PIC X. 05 FTP-NAMEADD4-CD PIC X(35). 05 FTP-COMMA5 PIC X. 05 FTP-NAMEADD5-CD PIC X(35). 05 FTP-COMMA6 PIC X. 05 FTP-PHYS-ADDR-CD PIC X(35). 05 FTP-COMMA7 PIC X. 05 FTP-PHYS-ADDR2-CD PIC X(35). 05 FTP-COMMA8 PIC X. 05 FTP-SALE-DATE1-CD PIC X(08). ######################################################################################################## NOCOMMAFILE has the following layout: 01 FTP-RECORD-NC. 05 FTP-ID-NC PIC X(20). 05 FILLER PIC X. 05 FTP-NAMEADD1-NC PIC X(35). 05 FILLER PIC X. 05 FTP-NAMEADD2-NC PIC X(35). 05 FILLER PIC X. 05 FTP-NAMEADD3-NC PIC X(35). 05 FILLER PIC X. 05 FTP-NAMEADD4-NC PIC X(35). 05 FILLER PIC X. 05 FTP-NAMEADD5-NC PIC X(35). 05 FILLER PIC X. 05 FTP-PHYS-ADDR-NC PIC X(35). 05 FILLER PIC X. 05 FTP-PHYS-ADDR2-NC PIC X(35). 05 FILLER PIC X. 05 FTP-SALE-DATE1-NC PIC X(08). ########################################################################################################