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