with Name

KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - STATE_PLSS link

Properties



	Name		Value

	Data Model		Physical
	Schema		PMIS
	Primary Key Clustered		Unspecified
	Unlogged		false
	Temporal		false

Columns Summary



	Column Name		Data Type		PK / FK		Nullable		Description

	DASC_PLSS_ID		float(126)				Yes
	PERIMETER		float(126)				Yes
	PLSS_NAD83		number(10)				Yes
	PLSS_NAD_1		number(10)				Yes
	MERIDIAN_FLAG		number(10)				Yes
	MERIDIAN		number(10)				Yes
	TOWNSHIP_FLAG		number(10)				Yes
	TOWNSHIP		number(10)				Yes
	RANGE_FLAG		number(10)				Yes
	RANGE		number(10)				Yes
	SECTION_FLAG		number(10)				Yes
	ISP_SECTION		number(10)				Yes
	EXCLUDED_A		number(10)				Yes
	EXCLUDED_1		number(10)				Yes
	OBJECTID		number(10)				Yes
	S_T_R		varchar2(50)				Yes
	SHAPE_AREA		float(126)				Yes
	SHAPE_LEN		float(126)				Yes
	GEOMETRY		number(-1)				Yes
	PQL		varchar2(1)				Yes

Columns Detail



	Name		Value

	Name		DASC_PLSS_ID
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		FLOAT
	Length		126
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PERIMETER
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		FLOAT
	Length		126
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PLSS_NAD83
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PLSS_NAD_1
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		MERIDIAN_FLAG
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		MERIDIAN
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		TOWNSHIP_FLAG
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		TOWNSHIP
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RANGE_FLAG
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RANGE
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SECTION_FLAG
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		ISP_SECTION
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		EXCLUDED_A
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		EXCLUDED_1
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		OBJECTID
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		S_T_R
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		50
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SHAPE_AREA
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		FLOAT
	Length		126
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SHAPE_LEN
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		FLOAT
	Length		126
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		GEOMETRY
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		"MDSYS"."SDO_GEOMETRY"
	Length		-1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PQL
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

KDOT PMS Replacement Project