OWNER Copybook Mapping
Table - Sorted Table - Copybook - Create Table - Load File - Row Size - Back To Table Index
Red- OCCURS seen.
Blue- Highlights DATE columns.
Brown- Highlights potential DATETIME or MONEY columns.
Orange- Redefine columns, EJECT, or SKIP.
Purple- Override columns and data types.
Green- Comments.
 Copybook DefinitionDB2 Column NamePosition#Bytes Create Table Data Type
1.
       01  OWNER-RECORD.
    
2.
           05  OWNER-PROP-KEY                   PIC  9(15).
OWNER_PROP_KEY POSITION(001:015)
15
BIGINT
3.
           05  OWNER-PROP-OWNER-NAME            PIC  X(33).
OWNER_PROP_OWNER_NAME POSITION(016:048)
33
VARCHAR(33)
4.
           05  OWNER-PROP-ADDRESS-MAILING1      PIC  X(33).
OWNER_PROP_ADDRESS_MAILING1 POSITION(049:081)
33
VARCHAR(33)
5.
           05  OWNER-PROP-ADDRESS-MAILING2      PIC  X(33).
OWNER_PROP_ADDRESS_MAILING2 POSITION(082:114)
33
VARCHAR(33)
6.
           05  OWNER-PROP-ADDRESS-MAILING3      PIC  X(33).
OWNER_PROP_ADDRESS_MAILING3 POSITION(115:147)
33
VARCHAR(33)
7.
           05  OWNER-PROP-ADDRESS-MAILING4      PIC  X(33).
OWNER_PROP_ADDRESS_MAILING4 POSITION(148:180)
33
VARCHAR(33)
8.
           05  OWNER-PROP-ADDRESS-PROPERTY      PIC  X(33).
OWNER_PROP_ADDRESS_PROPERTY POSITION(181:213)
33
VARCHAR(33)
9.
           05  OWNER-SUBDIVISION-NAME            PIC  X(50).
OWNER_SUBDIVISION_NAME POSITION(214:263)
50
VARCHAR(50)
10.
           05  OWNER-PROP-MILLAGE               PIC  9(04).
OWNER_PROP_MILLAGE POSITION(264:267)
4
SMALLINT
11.
           05  OWNER-PROP-INSPECT-DATE.
    
12.
               10  OWNER-PROP-INSPECT-DATE-MONTH PIC  9(02).
OWNER_PROP_INSPECT_DATE_MONTH POSITION(268:269)
2
SMALLINT
13.
               10  OWNER-PROP-INSPECT-DATE-YEAR  PIC  9(04).
OWNER_PROP_INSPECT_DATE_YEAR POSITION(270:273)
4
INT
14.
           05  OWNER-PROP-CLUC-CODE             PIC  X(04).
OWNER_PROP_CLUC_CODE POSITION(274:277)
4
VARCHAR(4)
15.
           05  OWNER-PROP-SLUC-CODE             PIC  X(04).
OWNER_PROP_SLUC_CODE POSITION(278:281)
4
VARCHAR(4)
16.
           05  OWNER-PROP-YEAR-BUILT            PIC  9(04).
OWNER_PROP_YEAR_BUILT POSITION(282:285)
4
SMALLINT
17.
           05  OWNER-PROP-CONDO-UNIT            PIC  X(06).
OWNER_PROP_CONDO_UNIT POSITION(286:291)
6
VARCHAR(6)
18.
           05  OWNER-PROP-LOT-SIZE              PIC  X(15).
OWNER_PROP_LOT_SIZE POSITION(292:306)
15
VARCHAR(15)
19.
           05  OWNER-PROP-CHANGE-DATE           PIC  9(08).
OWNER_PROP_CHANGE_DATE POSITION(307:314)
8
INT
20.
           05  OWNER-PROP-ASSMT-YEAR            PIC  9(04).
OWNER_PROP_ASSMT_YEAR POSITION(315:318)
4
SMALLINT
21.
           05  OWNER-PROP-LAND-VALUE            PIC S9(11).
OWNER_PROP_LAND_VALUE POSITION(319:329)
11
BIGINT
22.
           05  OWNER-PROP-BLDG-VALUE            PIC S9(11).
OWNER_PROP_BLDG_VALUE POSITION(330:340)
11
BIGINT
23.
           05  OWNER-PROP-TOTAL-VALUE           PIC S9(11).
OWNER_PROP_TOTAL_VALUE POSITION(341:351)
11
BIGINT
24.
           05  OWNER-PROP-HEX-VALUE             PIC  9(07).
OWNER_PROP_HEX_VALUE POSITION(352:358)
7
INT
25.
           05  OWNER-PROP-WIDOW-AMOUNT          PIC  9(05).
OWNER_PROP_WIDOW_AMOUNT POSITION(359:363)
5
INT
26.
           05  OWNER-PROP-VETERAN-AMOUNT        PIC  9(05).
OWNER_PROP_VETERAN_AMOUNT POSITION(364:368)
5
INT
27.
           05  OWNER-PROP-DISABLED-AMOUNT       PIC  9(05).
OWNER_PROP_DISABLED_AMOUNT POSITION(369:373)
5
INT
28.
           05  OWNER-PROP-TOTAL-EXEMPT          PIC S9(11).
OWNER_PROP_TOTAL_EXEMPT POSITION(374:384)
11
BIGINT
29.
           05  OWNER-PROP-TOTAL-NONEXEMPT       PIC S9(11).
OWNER_PROP_TOTAL_NONEXEMPT POSITION(385:395)
11
BIGINT
30.
           05  OWNER-PROP-SENIOR-AMOUNT         PIC  9(05).
OWNER_PROP_SENIOR_AMOUNT POSITION(396:400)
5
INT
31.
           05  OWNER-PROP-COUNTY-NONEXEMPT      PIC S9(11).
OWNER_PROP_COUNTY_NONEXEMPT POSITION(401:411)
11
BIGINT
32.
           05  OWNER-PROP-SCHOOL-EXEMPT         PIC S9(11).
OWNER_PROP_SCHOOL_EXEMPT POSITION(412:422)
11
BIGINT
33.
           05  OWNER-PROP-SCHOOL-NONEXEMPT      PIC S9(11).
OWNER_PROP_SCHOOL_NONEXEMPT POSITION(423:433)
11
BIGINT
34.
           05  OWNER-PROP-LAST-ASSMT-YEAR       PIC  9(04).
OWNER_PROP_LAST_ASSMT_YEAR POSITION(434:437)
4
SMALLINT
35.
           05  OWNER-PROP-LAST-LAND-VALUE       PIC S9(11).
OWNER_PROP_LAST_LAND_VALUE POSITION(438:448)
11
BIGINT
36.
           05  OWNER-PROP-LAST-BLDG-VALUE       PIC S9(11).
OWNER_PROP_LAST_BLDG_VALUE POSITION(449:459)
11
BIGINT
37.
           05  OWNER-PROP-LAST-TOTAL-VALUE      PIC S9(11).
OWNER_PROP_LAST_TOTAL_VALUE POSITION(460:470)
11
BIGINT
38.
           05  OWNER-PROP-LAST-HEX-VALUE        PIC  9(07).
OWNER_PROP_LAST_HEX_VALUE POSITION(471:477)
7
INT
39.
           05  OWNER-PROP-LAST-WIDOW-AMOUNT     PIC  9(05).
OWNER_PROP_LAST_WIDOW_AMOUNT POSITION(478:482)
5
INT
40.
           05  OWNER-PROP-LAST-VETERAN-AMOUNT   PIC  9(05).
OWNER_PROP_LAST_VETERAN_AMOUNT POSITION(483:487)
5
INT
41.
           05  OWNER-PROP-LAST-DISABLE-AMOUNT   PIC  9(05).
OWNER_PROP_LAST_DISABLE_AMOUNT POSITION(488:492)
5
INT
42.
           05  OWNER-PROP-LAST-TOTAL-EXEMPT     PIC S9(11).
OWNER_PROP_LAST_TOTAL_EXEMPT POSITION(493:503)
11
BIGINT
43.
           05  OWNER-PROP-LAST-TOTAL-NONEX      PIC S9(11).
OWNER_PROP_LAST_TOTAL_NONEX POSITION(504:514)
11
BIGINT
44.
           05  OWNER-PROP-LAST-SENIOR-AMOUNT    PIC  9(05).
OWNER_PROP_LAST_SENIOR_AMOUNT POSITION(515:519)
5
INT
45.
           05  OWNER-PROP-LAST-COUNTY-NONEX     PIC S9(11).
OWNER_PROP_LAST_COUNTY_NONEX POSITION(520:530)
11
BIGINT
46.
           05  OWNER-PROP-LAST-SCHOOL-EXEMPT    PIC S9(11).
OWNER_PROP_LAST_SCHOOL_EXEMPT POSITION(531:541)
11
BIGINT
47.
           05  OWNER-PROP-LAST-SCHOOL-NONEX     PIC S9(11).
OWNER_PROP_LAST_SCHOOL_NONEX POSITION(542:552)
11
BIGINT
48.
           05  OWNER-PROP-PREV-ASSMT-YEAR       PIC  9(04).
OWNER_PROP_PREV_ASSMT_YEAR POSITION(553:556)
4
SMALLINT
49.
           05  OWNER-PROP-PREV-LAND-VALUE       PIC S9(11).
OWNER_PROP_PREV_LAND_VALUE POSITION(557:567)
11
BIGINT
50.
           05  OWNER-PROP-PREV-BLDG-VALUE       PIC S9(11).
OWNER_PROP_PREV_BLDG_VALUE POSITION(568:578)
11
BIGINT
51.
           05  OWNER-PROP-PREV-TOTAL-VALUE      PIC S9(11).
OWNER_PROP_PREV_TOTAL_VALUE POSITION(579:589)
11
BIGINT
52.
           05  OWNER-PROP-PREV-HEX-VALUE        PIC  9(07).
OWNER_PROP_PREV_HEX_VALUE POSITION(590:596)
7
INT
53.
           05  OWNER-PROP-PREV-WIDOW-AMOUNT     PIC  9(05).
OWNER_PROP_PREV_WIDOW_AMOUNT POSITION(597:601)
5
INT
54.
           05  OWNER-PROP-PREV-VETERAN-AMOUNT   PIC  9(05).
OWNER_PROP_PREV_VETERAN_AMOUNT POSITION(602:606)
5
INT
55.
           05  OWNER-PROP-PREV-DISABLE-AMOUNT   PIC  9(05).
OWNER_PROP_PREV_DISABLE_AMOUNT POSITION(607:611)
5
INT
56.
           05  OWNER-PROP-PREV-TOTAL-EXEMPT     PIC S9(11).
OWNER_PROP_PREV_TOTAL_EXEMPT POSITION(612:622)
11
BIGINT
57.
           05  OWNER-PROP-PREV-TOTAL-NONEX      PIC S9(11).
OWNER_PROP_PREV_TOTAL_NONEX POSITION(623:633)
11
BIGINT
58.
           05  OWNER-PROP-PREV-SENIOR-AMOUNT    PIC  9(05).
OWNER_PROP_PREV_SENIOR_AMOUNT POSITION(634:638)
5
INT
59.
           05  OWNER-PROP-PREV-COUNTY-NONEX     PIC S9(11).
OWNER_PROP_PREV_COUNTY_NONEX POSITION(639:649)
11
BIGINT
60.
           05  OWNER-PROP-PREV-SCHOOL-EXEMPT    PIC S9(11).
OWNER_PROP_PREV_SCHOOL_EXEMPT POSITION(650:660)
11
BIGINT
61.
           05  OWNER-PROP-PREV-SCHOOL-NONEX     PIC S9(11).
OWNER_PROP_PREV_SCHOOL_NONEX POSITION(661:671)
11
BIGINT
62.
           05  OWNER-PROP-PRI-ZONE              PIC  X(04).
OWNER_PROP_PRI_ZONE POSITION(672:675)
4
VARCHAR(4)
63.
           05  OWNER-PROP-BLDG-SQFTG            PIC  9(09).
OWNER_PROP_BLDG_SQFTG POSITION(676:684)
9
INT
64.
           05  OWNER-PROP-XFEATURES             PIC  9(01).
OWNER_PROP_XFEATURES POSITION(685:685)
1
SMALLINT
65.
           05  OWNER-PROP-BEDROOM               PIC  9(06).
OWNER_PROP_BEDROOM POSITION(686:691)
6
INT
66.
           05  OWNER-PROP-BATH                  PIC  9(05).
OWNER_PROP_BATH POSITION(692:696)
5
INT
67.
           05  OWNER-WATER-NUMBER                PIC  9(03).
OWNER_WATER_NUMBER POSITION(697:699)
3
SMALLINT
68.
           05  OWNER-ROAD-NUMBER                 PIC  9(03).
OWNER_ROAD_NUMBER POSITION(700:702)
3
SMALLINT
69.
           05  OWNER-SEWER-NUMBER                PIC  9(03).
OWNER_SEWER_NUMBER POSITION(703:705)
3
SMALLINT
70.
           05  OWNER-LITE-NUMBER                 PIC  9(03).
OWNER_LITE_NUMBER POSITION(706:708)
3
SMALLINT
71.
           05  OWNER-LAST-SALES-DATE.
    
72.
               10  OWNER-LAST-SALES-DATE-MONTH   PIC  9(02).
OWNER_LAST_SALES_DATE_MONTH POSITION(709:710)
2
SMALLINT
73.
               10  OWNER-LAST-SALES-DATE-YEAR    PIC  9(04).
OWNER_LAST_SALES_DATE_YEAR POSITION(711:714)
4
INT
74.
           05  OWNER-LAST-SALES-AMOUNT           PIC  9(09).
OWNER_LAST_SALES_AMOUNT POSITION(715:723)
9
INT
75.
           05  OWNER-LAST-SALES-TYPE             PIC  9(01).
OWNER_LAST_SALES_TYPE POSITION(724:724)
1
SMALLINT
76.
           05  OWNER-PREV-SALES-DATE.
    
77.
               10  OWNER-PREV-SALES-DATE-MONTH   PIC  9(02).
OWNER_PREV_SALES_DATE_MONTH POSITION(725:726)
2
SMALLINT
78.
               10  OWNER-PREV-SALES-DATE-YEAR    PIC  9(04).
OWNER_PREV_SALES_DATE_YEAR POSITION(727:730)
4
INT
79.
           05  OWNER-PREV-SALES-AMOUNT           PIC  9(09).
OWNER_PREV_SALES_AMOUNT POSITION(731:739)
9
INT
80.
           05  OWNER-PREV-SALES-TYPE             PIC  9(01).
OWNER_PREV_SALES_TYPE POSITION(740:740)
1
SMALLINT
81.
           05  OWNER-SALES3-DATE.
    
82.
               10  OWNER-SALES3-DATE-MONTH       PIC  9(02).
OWNER_SALES3_DATE_MONTH POSITION(741:742)
2
SMALLINT
83.
               10  OWNER-SALES3-DATE-YEAR        PIC  9(04).
OWNER_SALES3_DATE_YEAR POSITION(743:746)
4
INT
84.
           05  OWNER-SALES3-AMOUNT               PIC  9(09).
OWNER_SALES3_AMOUNT POSITION(747:755)
9
INT
85.
           05  OWNER-SALES3-TYPE                 PIC  9(01).
OWNER_SALES3_TYPE POSITION(756:756)
1
SMALLINT
86.
           05  OWNER-PROP-RESIDENT-YEAR         PIC  9(04).
OWNER_PROP_RESIDENT_YEAR POSITION(757:760)
4
SMALLINT
87.
           05  OWNER-CITY-TAX                    PIC  S9(13)V99.
OWNER_CITY_TAX POSITION(761:775)
15
DECIMAL(16,2)
88.
           05  OWNER-COUNTY-TAX                  PIC  S9(13)V99.
OWNER_COUNTY_TAX POSITION(776:790)
15
DECIMAL(16,2)
89.
           05  OWNER-WASTE-TAX                   PIC  S9(13)V99.
OWNER_WASTE_TAX POSITION(791:805)
15
DECIMAL(16,2)
90.
           05  OWNER-WATER-TAX                   PIC  S9(13)V99.
OWNER_WATER_TAX POSITION(806:820)
15
DECIMAL(16,2)
91.
           05  OWNER-ROAD-TAX                    PIC  S9(13)V99.
OWNER_ROAD_TAX POSITION(821:835)
15
DECIMAL(16,2)
92.
           05  OWNER-SEWER-TAX                   PIC  S9(13)V99.
OWNER_SEWER_TAX POSITION(836:850)
15
DECIMAL(16,2)
93.
           05  OWNER-GROSS-TAX                   PIC  S9(13)V99.
OWNER_GROSS_TAX POSITION(851:865)
15
DECIMAL(16,2)
94.
           05  OWNER-REFFOLIO-KEY                PIC  9(15).
OWNER_REFFOLIO_KEY POSITION(866:880)
15
BIGINT
95.
           05  OWNER-LAKE-BELT-DISTRICT          PIC  X.
OWNER_LAKE_BELT_DISTRICT POSITION(881:881)
1
VARCHAR(1)
96.
           05  OWNER-CTY-SENIOR-EXEMP            PIC  9(5).
OWNER_CTY_SENIOR_EXEMP POSITION(882:886)
5
INT
97.
           05  OWNER-LAST-CTY-SENIOR-EXEMP       PIC  9(5).
OWNER_LAST_CTY_SENIOR_EXEMP POSITION(887:891)
5
INT
98.
           05  OWNER-PREV-CTY-SENIOR-EXEMP       PIC  9(5).
OWNER_PREV_CTY_SENIOR_EXEMP POSITION(892:896)
5
INT
99.
           05  OWNER-BLIND                            PIC  9(5).
OWNER_BLIND POSITION(897:901)
5
INT
100.
           05  OWNER-LAST-BLIND                            PIC  9(5).
OWNER_LAST_BLIND POSITION(902:906)
5
INT
101.
           05  OWNER-PREV-BLIND                        PIC  9(5).
OWNER_PREV_BLIND POSITION(907:911)
5
INT
102.
           05  OWNER-NO-XFEA-LINES               PIC  9(02).
OWNER_NO_XFEA_LINES POSITION(912:913)
2
SMALLINT
103.
           05  OWNER-NO-LEGAL-LINES              PIC  9(02).
OWNER_NO_LEGAL_LINES POSITION(914:915)
2
SMALLINT
104.
         05  OWNER-EXTRA-FEATURES OCCURS 5 TIMES.
    
105.
             10  OWNER-BLDG-NUMBER           PIC  9(02).
    
106.
             10  OWNER-XFEA-LINE-NO          PIC  9(02).
    
107.
             10  OWNER-XFEA-PRICE-CODE       PIC  9(03).
    
108.
             10  OWNER-XFEA-UNIT-AREA        PIC  9(07)V9(02).
    
109.
             10  OWNER-XFEA-ADDED            PIC  9(09).
    
110.
             10  OWNER-XFEA-DESCR            PIC  X(15).
    
111.
             10  OWNER-FILLER1               PIC  X(01).
    
112.
OWNER_BLDG_NUMBER_1POSITION(916:917)
2
SMALLINT
113.
OWNER_XFEA_LINE_NO_1POSITION(918:919)
2
SMALLINT
114.
OWNER_XFEA_PRICE_CODE_1POSITION(920:922)
3
SMALLINT
115.
OWNER_XFEA_UNIT_AREA_1POSITION(923:931)
9
DECIMAL(10,2)
116.
OWNER_XFEA_ADDED_1POSITION(932:940)
9
INT
117.
OWNER_XFEA_DESCR_1POSITION(941:955)
15
VARCHAR(15)
118.
OWNER_FILLER1_1_001POSITION(956:956)
1
VARCHAR(1)
119.
OWNER_BLDG_NUMBER_2POSITION(957:958)
2
SMALLINT
120.
OWNER_XFEA_LINE_NO_2POSITION(959:960)
2
SMALLINT
121.
OWNER_XFEA_PRICE_CODE_2POSITION(961:963)
3
SMALLINT
122.
OWNER_XFEA_UNIT_AREA_2POSITION(964:972)
9
DECIMAL(10,2)
123.
OWNER_XFEA_ADDED_2POSITION(973:981)
9
INT
124.
OWNER_XFEA_DESCR_2POSITION(982:996)
15
VARCHAR(15)
125.
OWNER_FILLER1_2_002POSITION(997:997)
1
VARCHAR(1)
126.
OWNER_BLDG_NUMBER_3POSITION(998:999)
2
SMALLINT
127.
OWNER_XFEA_LINE_NO_3POSITION(1000:1001)
2
SMALLINT
128.
OWNER_XFEA_PRICE_CODE_3POSITION(1002:1004)
3
SMALLINT
129.
OWNER_XFEA_UNIT_AREA_3POSITION(1005:1013)
9
DECIMAL(10,2)
130.
OWNER_XFEA_ADDED_3POSITION(1014:1022)
9
INT
131.
OWNER_XFEA_DESCR_3POSITION(1023:1037)
15
VARCHAR(15)
132.
OWNER_FILLER1_3_003POSITION(1038:1038)
1
VARCHAR(1)
133.
OWNER_BLDG_NUMBER_4POSITION(1039:1040)
2
SMALLINT
134.
OWNER_XFEA_LINE_NO_4POSITION(1041:1042)
2
SMALLINT
135.
OWNER_XFEA_PRICE_CODE_4POSITION(1043:1045)
3
SMALLINT
136.
OWNER_XFEA_UNIT_AREA_4POSITION(1046:1054)
9
DECIMAL(10,2)
137.
OWNER_XFEA_ADDED_4POSITION(1055:1063)
9
INT
138.
OWNER_XFEA_DESCR_4POSITION(1064:1078)
15
VARCHAR(15)
139.
OWNER_FILLER1_4_004POSITION(1079:1079)
1
VARCHAR(1)
140.
OWNER_BLDG_NUMBER_5POSITION(1080:1081)
2
SMALLINT
141.
OWNER_XFEA_LINE_NO_5POSITION(1082:1083)
2
SMALLINT
142.
OWNER_XFEA_PRICE_CODE_5POSITION(1084:1086)
3
SMALLINT
143.
OWNER_XFEA_UNIT_AREA_5POSITION(1087:1095)
9
DECIMAL(10,2)
144.
OWNER_XFEA_ADDED_5POSITION(1096:1104)
9
INT
145.
OWNER_XFEA_DESCR_5POSITION(1105:1119)
15
VARCHAR(15)
146.
OWNER_FILLER1_5_005POSITION(1120:1120)
1
VARCHAR(1)
147.
         05  OWNER-LEGAL-DESCRIPTION OCCURS 5 TIMES.
    
148.
             10  OWNER-LEGAL-DESCR           PIC  X(33).
    
149.
OWNER_LEGAL_DESCR_1POSITION(1121:1153)
33
VARCHAR(33)
150.
OWNER_LEGAL_DESCR_2POSITION(1154:1186)
33
VARCHAR(33)
151.
OWNER_LEGAL_DESCR_3POSITION(1187:1219)
33
VARCHAR(33)
152.
OWNER_LEGAL_DESCR_4POSITION(1220:1252)
33
VARCHAR(33)
153.
OWNER_LEGAL_DESCR_5POSITION(1253:1285)
33
VARCHAR(33)
154.
         05  OWNER-FILLER2                     PIC  X(01).
OWNER_FILLER2_006POSITION(1286:1286)
1
VARCHAR(1)
155.
    

Copybook defines 1286 bytes of data. Line delimiters are not in totals.

To Top - Print - copybook.txt

Output Generated By +1Copybook From +1 Software Engineering LLC.
Created on: 23-MAY-2020 10:46 AM