FW_PARCEL_AGENT_DOC ATTRIBUTE DATA FORMAT
Position	R	Item	Framework Column Name	Oracle Datatype	Column Short Name	Description	Description Definition Table
1		Parcel system id	fw_prcl_syst_id	NUMBER(10)	fwprclsyid	Identifier for Land Parcel records in the Framework System.
2	*	Parcel shape record number	prcl_shape_id	NUMBER(10)	prclshpid	Identifier to associate tabular data record with Land Parcel spatial record.
3	*	agent id	agent_id	NUMBER(10)	agentid	Identifier to associate tabular data record within LAND_AGENT table.
4	*	land interest type code	land_int_type_cd	NUMBER(2)	landintycd	1 Granting agent in a transaction	land_agent_interest_ty_code
						2 receiver of property rights being granted
						5 manager that acts on behalf of the property right
						6 responsible to care for the management beneficiary
						7 executor/executrix
						8 appointed or required by law to execute a trust
						9 representative for another agent
						11 receives income from land in leiu of the property
						12 loan security agent
						13 one that encroches on anothers land
						14 one that bring action against another agent
						15 Agent that sets a corner point of does a survey
						16 Person or Organization responsible for polluting
						17 Administrative agent
						18 Agent involved in an Exchange of easement or land
						19 Agent requesting to use rights on land
						20 agent that has insured title to land
						21 Agent responding to a court action
						22 Gov Org designated to receive taxes
						23 County recording agent
5		land responsibility type code	land_resp_type_cd	NUMBER(2)	landrptycd	1 primary interest in the agreement	land_resp_ty_code
						2 secondary interest such as loan security
						3 representative for a primary or secondary agent
						4 Not Applicable
6	*	document id	doc_id	NUMBER(10)	docid	Number to identify document from the data transfer standard document file.
7		agent interest percentage	agent_int_pc	NUMBER(12,4)	agntintpc	Percentage of interest/ownership in the parcel by the agent.
8		agent record volume type code	agent_vol_type_cd	NUMBER(2)	agntvltycd	1 DNR Upland Deed Book	agent_record_vol_ty_code
						2 DNR Aquatic Land Deed Book
						3 DNR Unspecified Deed Book
						4 DNR Easement Book
						5 DNR Register
						6 DNR Right of Way Certificates Book
						7 DNR Railroad Certificate Book
						8 DNR Patent Book
						9 DNR Clear List Book
						10 DNR Lease Book
						11 DNR Mineral Book
						12 DNR Permit Book
						13 DNR Range Book
						14 DNR Aquatic Plat
						21 County Record Binding Site Plans
						22 County Record Condominiums
						23 County Record County Commissioners Records
						24 County Record Surveyor Records
						25 County Record Deeds
						26 County Record Land Corner Records
						27 County Record Large Lots
						28 County Record Lien Records
						29 County Record Miscellaneous
						30 County Record Mortgages
						31 County Record Patents
						32 County Record Plats
						33 County Record Road Waivers
						34 County Record Short Plats
						35 County Record Surveys
						36 County Record Book or Volume unknown
9		agent deed number text	agent_deed_no_txt	VARCHAR2(12)	agntdnotxt	The agent's deed number.
10		agent deed volume text	agent_deed_vol_no_txt	VARCHAR2(12)	agntdvltxt	The agent's deed volume number.
11		agent deed page text	agent_deed_page_no_txt	VARCHAR2(12)	agntdpgtxt	The agent's deed page number.
12		agent file number txt	agent_file_no_txt	VARCHAR2(20)	agntfnotxt	The agent's file number.
13		agent contract number text	agent_contract_no_txt	VARCHAR2(20)	agntcnotxt	The agent's contract number.
14		agent ownership type	agntown_type_cd	NUMBER(2)	agntowtycd	1 No rights	transact_agent_own_ty_code
						2 Individual rights
						3 Each owner owns rights that are shared by all
						4 Unable to determine with information available
15		recording date	rec_dt	DATE	recdt	Date the item is recorded in the county. (CCYYMMDD)
16		recording auditor file number text	rec_aud_file_no_txt	VARCHAR2(24)	recafntxt	A text field for recording county auditor file numbers.
17		recording barcode number text	rec_barcode_no_txt	VARCHAR2(24)	recbarntxt	For counties have changed to a barcode system