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