FW_DOCUMENT ATTRIBUTE DATA FORMAT
PositionRItemFramework Column NameOracle DatatypeColumn Short NameDescriptionDescription Definition Table
1*document iddoc_idNUMBER(10)docidPartner's internal identifier for the document.
2*document type codedoc_type_cd NUMBER(2) doctypecd 1 Abstract Title Mapland_area_doc_ty_code
2 Transaction Exhibit
3 Tract Book pages that have been scanned.
4 Map that relates to a particular section of land
5 Aquatic index plates
6 Orthophoto
7 A general map showing planimetric and topographic
8 Aquatic Plat
9 Aerial photo
10 Survey field notes
12 A Geographic Information System Database
14 Deed or conveyance document
15 Survey map or mylar
16 Tabular Database
17 Index
18 Survey Record
19 Letter
20 Memo
21 Agreement, Instrument or Document
22 Note
23 Nautical Chart
24 Business Order
25 Resolution
26 Meeting Minutes
28 Court document
29 Legal Notice
30 State Environmental Policy Act, Report
31 Timber Cruise
32 Auction bid
33 Title Report
34 Register
35 Transaction Application
36 Claim
37 Certificate
38 Permit
39 HCP Document
3Ñdocument datedoc_dt DATE docdtDocument Date (CCYYMMDD) Required for doc_type_cd of: 14,21,24,25,26,28,30,33,35,36,37,38
4document namedoc_nm VARCHAR2(32) docnmDocument Name
5*document source textdoc_src_txt VARCHAR2(240) docsrctxtWritten information that tells information about the source of the land map image. This could be a tract book historical record, GLO survey, or new survey for a transaction.
6document remarks textdoc_remarks_txt VARCHAR2(240)docremstxtRemarks about the document
7instrument type coderp_instr_ty_cdNUMBER(2)rpinstycd 1 ConveyanceINSTRUMENT_TY_CODE
2 Lease
3 Easement
4 Management
5 Stewardship
6 Judgement
7 Resource Sale (timber, rock, minerals, etc.)
8 Personal Property
9 Boundary Agreement
10 Security Agreement
11 Contract of Sale Agreement
12 Will
13 Internal document that conveys within an org.
14 Transfer of Jurisdiction
8agreement type coderp_agrmt_type_cdVARCHAR2(2)rpagrmtycd02 LAND SALEagrmt_ty_code
03 MINERAL RIGHTS RETAINED
04 ESCHEATED TO THE STATE
05 FOREST PRACTICES SENSITIVE AREA
07 ARCHAEOLOGICAL/HISTORICAL SITE
08 SPECIAL DNR LAND ACQUISITION
10 GRAZING LEASE
11 PERMIT RANGE
12 AGRICULTURAL LEASE
20 AQUATIC LAND LEASE
21 UNAUTHORIZED U AND O
22 HARBOR AREA LEASE
23 AGRICULTURE LICENSE / PERMITS
24 1ST CLASS AQ PURCHASE
26 2ND CLASS AQ PURCHASE
30 TIMBER SALE
31 AQUATIC MATERIAL SALE
32 UPLAND MATERIAL SALE
35 MINOR FOREST PRODUCT LEASE
39 COMMERCIAL LEASE
43 MILWAUKEE RAILROAD
50 RIGHT OF WAY--STATE UPLAND
51 RIGHT OF WAY--PUBLIC AQUATIC LAND
52 ELECTRONIC SITE
53 RIGHT OF WAY--WATER SYSTEM
55 RIGHT OF WAY--PRIVATE LAND
59 IAC RECREATION SITES
60 SPECIAL USE LEASE
61 UPLAND USE/OCCUPANCY
62 DEFAULT LEASE MANAGEMENT
63 OIL AND GAS LEASE
64 MINERALS CONTRACT
65 MINERAL PROSPECTING LEASE
70 SURFACE MINING PERMIT
71 SURFACE MINING HISTORICAL
72 AQUATIC VALUATION DATA
78 WATER RECORD
79 ASSESSMENTS
82 CONDEMNATION LAND
84 TRESPASS
86 EXCHANGE
87 URBAN TRACTS-BEING DEVELOPED
89 MISCELLANEOUS BILLING
90 RESEARCH PERMANENT PLOTS
91 GENETIC SELECTED TREES
92 MANAGEMENT AGREEMENT
93 DFW ENDANGERED/THREATENED ANIMAL SPECIES
94 DEPARTMENT OF HEALTH - WATER INTAKES
95 PLANT SPECIES OR NATURAL AREA
96 Cutting Line Agreement
99 CLOSED LOCATOR FILE
G1 DOE - WATER RIGHTS - GROUND
G2 DOE - WATER RIGHTS - GROUND
G3 DOE - WATER RIGHTS - GROUND
G4 DOE - WATER RIGHTS - GROUND
GE DNR GIS LEGAL DESCRIPTION AND ACRES
R1 DOE - WATER RIGHTS - RESERVOIR
R2 DOE - WATER RIGHTS - RESERVOIR
R3 DOE - WATER RIGHTS - RESERVOIR
R4 DOE - WATER RIGHTS - RESERVOIR
S1 DOE - WATER RIGHTS - SURFACE
S2 DOE - WATER RIGHTS - SURFACE
S3 DOE - WATER RIGHTS - SURFACE
S4 DOE - WATER RIGHTS - SURFACE
T1 TIMBER SALE TRESPASS
T3 LAND TRESPASS
T5 AQUATIC TRESPASS
9dnr authorization type coderp_dnr_auth_type_cdNUMBER(2)rpdnratycd 1 Board of Natural Resourcesdnr_auth_ty_code
2 Division authority level
3 Region authority level
4 Direct DNR agent authority
10convey type coderp_conveyty_type_cdNUMBER(2)rpconvtycd 1 Land Patentconvey_inst_ty_code
2 Indemnity Clear List
3 Capitol Building Clear List
4 Original University Clear List
5 Agricultural Clear List
6 Scientific Clear List
7 Normal School Clear List
8 Correctional, Educational, Penal & Reform. Institu
9 Judgement Transfer
10 Statutory Warranty Deed
11 Warranty Deed
12 Bargain and Sale Deed
13 General Warranty Deed
14 Gift Deed
15 Quit Claim Deed
16 Sheriffs Deed
17 Special Warranty Deed
18 Correction Deed
19 Marshals Deed
20 Reversionary Quit Claim Deed
21 Receivers Deed
22 Tax Deed
23 Treasurers Deed
24 Condominium Deed
25 Executors Deed
26 Administrators Deed
27 Personal Representatives Deed
29 Trustees Deed
30 Reconveyance Deed
31 Guardians Deed
32 Timber Deed
33 Mineral Deed
34 Geothermal Deed
35 Forest Board Transfer Deed
36 Deed, specified type not listed
37 Governmental Declaration
11easment encumbrance type coderp_esmttype_cdNUMBER(2)rpesmtycd 1 APPURTENANT EASEMENT (BENEFIT OF THE LAND)easemt_encum_ty_code
2 GROSS EASEMENT (FOR PUBLIC)
12dnr contract type coderp_dnr_cntrt_type_cdNUMBER(2)rpdnrctycd 1 Lump Sum Paymentdnr_cntrt_ty_code
2 Scale weight or measurement of product
3 Harvest contract sale of product
13*reocurring document flagrp_reoccurring_document_flgVARCHAR2(1)rpredocflgA lease or easement that is granted for a period of time that automatically reoccurs. "T" is yes, "F" is no.
14*convey life estate flagconvey_life_estate_flgVARCHAR2(1)conlifeflgIf the conveyance is a limited fee simple estate. "T" is yes, "F" is no.
15*convey reversionary right flagconvey_reversionary_right_flgVARCHAR2(1)conrevrflgA flag that states a condition on ownership. Conveyor could regain ownership if the condition is not met. "T" is yes, "F" is no.
16instrument acresrp_instr_acresNUMBER(8,2)rpinstracThe acres granted as stated in the document.
17receiver name receiver_nmVARCHAR2(240)recievernmThe name of the receiver of rights in a document.
18conveyor nameconveyor_nmVARCHAR2(240)conveyornmThe name of the grantor of rights in a document.
19conveyor cams ref number textconvey_cams_ref_no_txt VARCHAR2(16)concrnotxtDNR specific information on identifier given in the CAMS system to land.
20transact aps/rms number texttransact_aps_rms_no_txtVARCHAR2(9)tranarntxtDNR specific information on identifier used in DNR APS or RMS systems to land documents.
21expiration daterp_expiration_dtDATErpexpirdtDate that an instrument with an expiration date expires.