| | Copybook Definition | Oracle Column Name | SQL*Loader Position | Control File Datatype | #Bytes |
Create Table Data Type |
Data |
| 1. | 01 RECORD. | | | | | | |
| 2. | 02 PROPERX-KEY PIC 9(13). | PROPERX_KEY | POSITION(001:013) | INTEGER EXTERNAL NULLIF (PROPERX_KEY=BLANKS) | 13 | NUMBER(13) | 0130510000051 |
| 3. | 02 PROPERX-GRPCD PIC 9(02). | PROPERX_GRPCD | POSITION(014:015) | INTEGER EXTERNAL NULLIF (PROPERX_GRPCD=BLANKS) | 2 | NUMBER(2) | 08 |
| 4. | 02 PROPERX-DISTRICT PIC 9(02). | PROPERX_DISTRICT | POSITION(016:017) | INTEGER EXTERNAL NULLIF (PROPERX_DISTRICT=BLANKS) | 2 | NUMBER(2) | 06 |
| 5. | 02 LOTTYPE-TYPE-LOT PIC 9(02). | LOTTYPE_TYPE_LOT | POSITION(018:019) | INTEGER EXTERNAL NULLIF (LOTTYPE_TYPE_LOT=BLANKS) | 2 | NUMBER(2) | 01 |
| 6. | 02 LOTTYPE-WET-LOT PIC X(01). | LOTTYPE_WET_LOT | POSITION(020:020) | CHAR | 1 | VARCHAR2(1) | |
| 7. | 02 LOTTYPE-SITE-VALUE PIC S9(09). | LOTTYPE_SITE_VALUE | POSITION(021:029) | DECIMAL EXTERNAL NULLIF (LOTTYPE_SITE_VALUE=blanks) | 9 | NUMBER(9) | 00000000{ |
| 8. | 02 PROPERTYPE PIC X. | PROPERTYPE | POSITION(030:030) | CHAR | 1 | VARCHAR2(1) | 4 |
| 9. | 02 PROPER-NBR PIC XX. | PROPER_NBR | POSITION(031:032) | CHAR | 2 | VARCHAR2(2) | 01 |
| 10. | 02 PROPER-CODE1 PIC 9(01). | PROPER_CODE1 | POSITION(033:033) | INTEGER EXTERNAL NULLIF (PROPER_CODE1=BLANKS) | 1 | NUMBER(1) | 0 |
| 11. | 02 PROPER-AMOUNT PIC S9(04). | PROPER_AMOUNT | POSITION(034:037) | DECIMAL EXTERNAL NULLIF (PROPER_AMOUNT=blanks) | 4 | NUMBER(4) | 0023 |
| 12. | 02 PROPER-PERCENT1 REDEFINES O-LINE-AMOUNT1 | | | | | | |
| 13. | PIC S9(01)V9(03). | | | | | | |
| 14. | 02 PROPER-CODE2 PIC 9(01). | PROPER_CODE2 | POSITION(038:038) | INTEGER EXTERNAL NULLIF (PROPER_CODE2=BLANKS) | 1 | NUMBER(1) | 3 |
| 15. | 02 PROPER-PERCENT2 PIC S9(01)V9(02). | PROPER_PERCENT2 | POSITION(039:041) | DECIMAL EXTERNAL ":PROPER_PERCENT2/100" | 3 | NUMBER(3,2) | 916 |
| 16. | 02 PROPER-VALUE PIC S9(09). | PROPER_VALUE | POSITION(042:050) | DECIMAL EXTERNAL NULLIF (PROPER_VALUE=blanks) | 9 | NUMBER(9) | 000000000 |
| 17. | 02 PROPERX-ZONE PIC X(4). | PROPERX_ZONE | POSITION(051:054) | CHAR | 4 | VARCHAR2(4) | 0008 |
| 18. | 02 PROPER-AGRI-CODE PIC X(01). | PROPER_AGRI_CODE | POSITION(055:055) | CHAR | 1 | VARCHAR2(1) | 0 |
| 19. | 02 PROPER-AGRI-YEAR PIC 9(04). | PROPER_AGRI_YEAR | POSITION(056:059) | INTEGER EXTERNAL NULLIF (PROPER_AGRI_YEAR=BLANKS) | 4 | NUMBER(4) | 0 |
| 20. | 02 PROPER-EXCESS-FLAG PIC X(01). | PROPER_EXCESS_FLAG | POSITION(060:060) | CHAR | 1 | VARCHAR2(1) | |
| 21. | 02 PROPER-EFF-YEAR PIC 9(04). | PROPER_EFF_YEAR | POSITION(061:064) | INTEGER EXTERNAL NULLIF (PROPER_EFF_YEAR=BLANKS) | 4 | NUMBER(4) | 00 |
| 22. | 02 PROPER-REAPPRAISAL1 PIC S9(03). | PROPER_REAPPRAISAL1 | POSITION(065:067) | DECIMAL EXTERNAL NULLIF (PROPER_REAPPRAISAL1=blanks) | 3 | NUMBER(3) | 00{ |
| 23. | 02 PROPER-REAPPRAISAL2 PIC S9(04). | PROPER_REAPPRAISAL2 | POSITION(068:071) | DECIMAL EXTERNAL NULLIF (PROPER_REAPPRAISAL2=blanks) | 4 | NUMBER(4) | 000{ |
| 24. | 02 PROPER-INSPECT-CODE PIC 9(02). | PROPER_INSPECT_CODE | POSITION(072:073) | INTEGER EXTERNAL NULLIF (PROPER_INSPECT_CODE=BLANKS) | 2 | NUMBER(2) | 00 |
| 25. |
| | | | | | |
| 26. | OWNER TABLE | | | | | | |