HOMES 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  RECORD.
     
2.
           02  HOMES-KEY                      PIC  9(13).
HOMES_KEYPOSITION(001:013)INTEGER EXTERNAL NULLIF (HOMES_KEY=BLANKS)13NUMBER(13)
3.
           02  HOMES-GRPCD                    PIC  9(02).
HOMES_GRPCDPOSITION(014:015)INTEGER EXTERNAL NULLIF (HOMES_GRPCD=BLANKS)2NUMBER(2)
4.
           02  HOME-A-NUMBER                  PIC  9(02).
HOME_A_NUMBERPOSITION(016:017)INTEGER EXTERNAL NULLIF (HOME_A_NUMBER=BLANKS)2NUMBER(2)
5.
           02  HOME-B-KEY                     PIC  9(02).
HOME_B_KEYPOSITION(018:019)INTEGER EXTERNAL NULLIF (HOME_B_KEY=BLANKS)2NUMBER(2)
6.
           02  HOME-A-INFO.
     
7.
               03  HOME-A-CHANGE-FLAG         PIC  X(01).
HOME_A_CHANGE_FLAG POSITION(020:020)CHAR1VARCHAR2(1)
8.
               03  HOME-A-SITE-FLAG           PIC  X(01).
HOME_A_SITE_FLAG POSITION(021:021)CHAR1VARCHAR2(1)
9.
               03  HOME-A-SITE-VALUE-CODER    PIC  X(04).
HOME_A_SITE_VALUE_CODER POSITION(022:025)CHAR4VARCHAR2(4)
10.
               03  HOME-A-SITE-VALUE          PIC S9(09).
HOME_A_SITE_VALUEPOSITION(026:034)DECIMAL EXTERNAL NULLIF (HOME_A_SITE_VALUE=blanks)9NUMBER(9)
11.
               03  HOME-A-CURR-VALUE          PIC S9(09).
HOME_A_CURR_VALUEPOSITION(035:043)DECIMAL EXTERNAL NULLIF (HOME_A_CURR_VALUE=blanks)9NUMBER(9)
12.
               03  HOME-A-XFEA-VALUE          PIC S9(09).
HOME_A_XFEA_VALUEPOSITION(044:052)DECIMAL EXTERNAL NULLIF (HOME_A_XFEA_VALUE=blanks)9NUMBER(9)
13.
               03  HOME-A-TOTAL-SQFTG         PIC  9(09).
HOME_A_TOTAL_SQFTGPOSITION(053:061)INTEGER EXTERNAL NULLIF (HOME_A_TOTAL_SQFTG=BLANKS)9NUMBER(9)
14.
               03  HOME-A-BEDROOMS            PIC  9(07).
HOME_A_BEDROOMSPOSITION(062:068)INTEGER EXTERNAL NULLIF (HOME_A_BEDROOMS=BLANKS)7NUMBER(7)
15.
               03  HOME-A-BATHS               PIC  9(05).
HOME_A_BATHSPOSITION(069:073)INTEGER EXTERNAL NULLIF (HOME_A_BATHS=BLANKS)5NUMBER(5)
16.
               03  HOME-A-HALF-BATHS          PIC  9(05).
HOME_A_HALF_BATHSPOSITION(074:078)INTEGER EXTERNAL NULLIF (HOME_A_HALF_BATHS=BLANKS)5NUMBER(5)
17.
               03  HOME-A-UNITS               PIC  9(05).
HOME_A_UNITSPOSITION(079:083)INTEGER EXTERNAL NULLIF (HOME_A_UNITS=BLANKS)5NUMBER(5)
18.
               03  HOME-A-FLOORS              PIC  9(02).
HOME_A_FLOORSPOSITION(084:085)INTEGER EXTERNAL NULLIF (HOME_A_FLOORS=BLANKS)2NUMBER(2)
19.
           02  HOME-B-INFO.
     
20.
               03  HOME-B-CHANGE-FLAG         PIC  X(01).
HOME_B_CHANGE_FLAG POSITION(086:086)CHAR1VARCHAR2(1)
21.
               03  HOME-B-CODE                PIC  X(01).
HOME_B_CODE POSITION(087:087)CHAR1VARCHAR2(1)
22.
               03  HOME-B-ADD-SQFTG-FLAG      PIC  X(01).
HOME_B_ADD_SQFTG_FLAG POSITION(088:088)CHAR1VARCHAR2(1)
23.
               03  HOME-B-VALUE               PIC  9(09).
HOME_B_VALUEPOSITION(089:097)INTEGER EXTERNAL NULLIF (HOME_B_VALUE=BLANKS)9NUMBER(9)
24.
               03  HOME-B-ITEMS               PIC  9(03)V9(02).
HOME_B_ITEMSPOSITION(098:102)DECIMAL EXTERNAL ":HOME_B_ITEMS/100"5NUMBER(5,2)
25.
               03  HOME-B-SPECIAL             PIC  9(04)V9(03).
HOME_B_SPECIALPOSITION(103:109)DECIMAL EXTERNAL ":HOME_B_SPECIAL/1000"7NUMBER(7,3)
26.
               03  HOME-B-TOTAL-SQFTG         PIC  9(09).
HOME_B_TOTAL_SQFTGPOSITION(110:118)INTEGER EXTERNAL NULLIF (HOME_B_TOTAL_SQFTG=BLANKS)9NUMBER(9)
27.
               03  HOME-B-PTS-GRADE           PIC S9(03).
HOME_B_PTS_GRADEPOSITION(119:121)DECIMAL EXTERNAL NULLIF (HOME_B_PTS_GRADE=blanks)3NUMBER(3)
28.
               03  HOME-B-GRADE               PIC S9(03).
HOME_B_GRADEPOSITION(122:124)DECIMAL EXTERNAL NULLIF (HOME_B_GRADE=blanks)3NUMBER(3)
29.
               03  HOME-B-ADDITION            PIC  X(10).
HOME_B_ADDITION POSITION(125:134)CHAR10VARCHAR2(10)
30.
           02  HOMES-X-DISTRICT               PIC  9(02).
HOMES_X_DISTRICTPOSITION(135:136)INTEGER EXTERNAL NULLIF (HOMES_X_DISTRICT=BLANKS)2NUMBER(2)
31.
           02  HOME-B-IMPROVEMENTS.
     
32.
               03  HOME-B-NC-FLAG             PIC  X(01).
HOME_B_NC_FLAG POSITION(137:137)CHAR1VARCHAR2(1)
33.
               03  HOME-B-NC-NEW              PIC  9(09).
HOME_B_NC_NEWPOSITION(138:146)INTEGER EXTERNAL NULLIF (HOME_B_NC_NEW=BLANKS)9NUMBER(9)
34.
               03  HOME-B-NC-ADD              PIC  9(09).
HOME_B_NC_ADDPOSITION(147:155)INTEGER EXTERNAL NULLIF (HOME_B_NC_ADD=BLANKS)9NUMBER(9)
35.
               03  HOME-B-NC-DEMO             PIC  9(09).
HOME_B_NC_DEMOPOSITION(156:164)INTEGER EXTERNAL NULLIF (HOME_B_NC_DEMO=BLANKS)9NUMBER(9)
36.
               03  HOME-B-REAPPRAISAL         PIC  9(09).
HOME_B_REAPPRAISALPOSITION(165:173)INTEGER EXTERNAL NULLIF (HOME_B_REAPPRAISAL=BLANKS)9NUMBER(9)
37.
     
38.
LAND TABLE
     

Copybook defines 173 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