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