HOMES 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  RECORD.
  
2.
           02  HOMES-KEY                      PIC  9(13).
HOMES_KEY
001:013
BIGINT
3.
           02  HOMES-GRPCD                    PIC  9(02).
HOMES_GRPCD
014:015
BYTEINT
4.
           02  HOME-A-NUMBER                  PIC  9(02).
HOME_A_NUMBER
016:017
BYTEINT
5.
           02  HOME-B-KEY                     PIC  9(02).
HOME_B_KEY
018:019
BYTEINT
6.
           02  HOME-A-INFO.
  
7.
               03  HOME-A-CHANGE-FLAG         PIC  X(01).
HOME_A_CHANGE_FLAG
020:020
CHAR(1)
8.
               03  HOME-A-SITE-FLAG           PIC  X(01).
HOME_A_SITE_FLAG
021:021
CHAR(1)
9.
               03  HOME-A-SITE-VALUE-CODER    PIC  X(04).
HOME_A_SITE_VALUE_CODER
022:025
CHAR(4)
10.
               03  HOME-A-SITE-VALUE          PIC S9(09).
HOME_A_SITE_VALUE
026:034
INTEGER
11.
               03  HOME-A-CURR-VALUE          PIC S9(09).
HOME_A_CURR_VALUE
035:043
INTEGER
12.
               03  HOME-A-XFEA-VALUE          PIC S9(09).
HOME_A_XFEA_VALUE
044:052
INTEGER
13.
               03  HOME-A-TOTAL-SQFTG         PIC  9(09).
HOME_A_TOTAL_SQFTG
053:061
INTEGER
14.
               03  HOME-A-BEDROOMS            PIC  9(07).
HOME_A_BEDROOMS
062:068
INTEGER
15.
               03  HOME-A-BATHS               PIC  9(05).
HOME_A_BATHS
069:073
SMALLINT
16.
               03  HOME-A-HALF-BATHS          PIC  9(05).
HOME_A_HALF_BATHS
074:078
SMALLINT
17.
               03  HOME-A-UNITS               PIC  9(05).
HOME_A_UNITS
079:083
SMALLINT
18.
               03  HOME-A-FLOORS              PIC  9(02).
HOME_A_FLOORS
084:085
BYTEINT
19.
           02  HOME-B-INFO.
  
20.
               03  HOME-B-CHANGE-FLAG         PIC  X(01).
HOME_B_CHANGE_FLAG
086:086
CHAR(1)
21.
               03  HOME-B-CODE                PIC  X(01).
HOME_B_CODE
087:087
CHAR(1)
22.
               03  HOME-B-ADD-SQFTG-FLAG      PIC  X(01).
HOME_B_ADD_SQFTG_FLAG
088:088
CHAR(1)
23.
               03  HOME-B-VALUE               PIC  9(09).
HOME_B_VALUE
089:097
INTEGER
24.
               03  HOME-B-ITEMS               PIC  9(03)V9(02).
HOME_B_ITEMS
098:102
DECIMAL(6,2)
25.
               03  HOME-B-SPECIAL             PIC  9(04)V9(03).
HOME_B_SPECIAL
103:109
DECIMAL(8,3)
26.
               03  HOME-B-TOTAL-SQFTG         PIC  9(09).
HOME_B_TOTAL_SQFTG
110:118
INTEGER
27.
               03  HOME-B-PTS-GRADE           PIC S9(03).
HOME_B_PTS_GRADE
119:121
SMALLINT
28.
               03  HOME-B-GRADE               PIC S9(03).
HOME_B_GRADE
122:124
SMALLINT
29.
               03  HOME-B-ADDITION            PIC  X(10).
HOME_B_ADDITION
125:134
VARCHAR(10)
30.
           02  HOMES-X-DISTRICT               PIC  9(02).
HOMES_X_DISTRICT
135:136
BYTEINT
31.
           02  HOME-B-IMPROVEMENTS.
  
32.
               03  HOME-B-NC-FLAG             PIC  X(01).
HOME_B_NC_FLAG
137:137
CHAR(1)
33.
               03  HOME-B-NC-NEW              PIC  9(09).
HOME_B_NC_NEW
138:146
INTEGER
34.
               03  HOME-B-NC-ADD              PIC  9(09).
HOME_B_NC_ADD
147:155
INTEGER
35.
               03  HOME-B-NC-DEMO             PIC  9(09).
HOME_B_NC_DEMO
156:164
INTEGER
36.
               03  HOME-B-REAPPRAISAL         PIC  9(09).
HOME_B_REAPPRAISAL
165:173
INTEGER
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 10:29 AM