FW_DOCUMENT ATTRIBUTE DATA FORMAT
Position	R	Item	Framework Column Name	Oracle Datatype	Column Short Name	Description	Description Definition Table
1	*	document id	doc_id	NUMBER(10)	docid	Partner's internal identifier for the document.
2	*	document type code	doc_type_cd	NUMBER(2)	doctypecd	1 Abstract Title Map	land_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 date	doc_dt	DATE	docdt	Document Date (CCYYMMDD) Required for doc_type_cd of: 14,21,24,25,26,28,30,33,35,36,37,38
4		document name	doc_nm	VARCHAR2(32)	docnm	Document Name
5	*	document source text	doc_src_txt	VARCHAR2(240)	docsrctxt	Written 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.
6		document remarks text	doc_remarks_txt	VARCHAR2(240)	docremstxt	Remarks about the document
7		instrument type code	rp_instr_ty_cd	NUMBER(2)	rpinstycd	1 Conveyance	INSTRUMENT_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
8		agreement type code	rp_agrmt_type_cd	VARCHAR2(2)	rpagrmtycd	02 LAND SALE	agrmt_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
9		dnr authorization type code	rp_dnr_auth_type_cd	NUMBER(2)	rpdnratycd	1 Board of Natural Resources	dnr_auth_ty_code
						2 Division authority level
						3 Region authority level
						4 Direct DNR agent authority
10		convey type code	rp_conveyty_type_cd	NUMBER(2)	rpconvtycd	1 Land Patent	convey_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
11		easment encumbrance type code	rp_esmttype_cd	NUMBER(2)	rpesmtycd	1 APPURTENANT EASEMENT (BENEFIT OF THE LAND)	easemt_encum_ty_code
						2 GROSS EASEMENT (FOR PUBLIC)
12		dnr contract type code	rp_dnr_cntrt_type_cd	NUMBER(2)	rpdnrctycd	1 Lump Sum Payment	dnr_cntrt_ty_code
						2 Scale weight or measurement of product
						3 Harvest contract sale of product
13	*	reocurring document flag	rp_reoccurring_document_flg	VARCHAR2(1)	rpredocflg	A lease or easement that is granted for a period of time that automatically reoccurs. "T" is yes, "F" is no.
14	*	convey life estate flag	convey_life_estate_flg	VARCHAR2(1)	conlifeflg	If the conveyance is a limited fee simple estate. "T" is yes, "F" is no.
15	*	convey reversionary right flag	convey_reversionary_right_flg	VARCHAR2(1)	conrevrflg	A flag that states a condition on ownership. Conveyor could regain ownership if the condition is not met. "T" is yes, "F" is no.
16		instrument acres	rp_instr_acres	NUMBER(8,2)	rpinstrac	The acres granted as stated in the document.
17		receiver name	receiver_nm	VARCHAR2(240)	recievernm	The name of the receiver of rights in a document.
18		conveyor name	conveyor_nm	VARCHAR2(240)	conveyornm	The name of the grantor of rights in a document.
19		conveyor cams ref number text	convey_cams_ref_no_txt	VARCHAR2(16)	concrnotxt	DNR specific information on identifier given in the CAMS system to land.
20		transact aps/rms number text	transact_aps_rms_no_txt	VARCHAR2(9)	tranarntxt	DNR specific information on identifier used in DNR APS or RMS systems to land documents.
21		expiration date	rp_expiration_dt	DATE	rpexpirdt	Date that an instrument with an expiration date expires.