PSC_COM_PROJECT

Details

Schema: FUSION
Object owner: PSC_CC
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
PSC_COM_PROJECT_PARCEL_PK	PARCEL_KEY

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PARCEL_KEY	NUMBER		18	Yes	Unique key to distinguish each parcel entry.
AGENCY_ID	NUMBER		8	Yes	Unique identifier for the Agency level Installation. Agency ID comes from the table PSC_COM_AGENCY_B
PROJECT_CODE	VARCHAR2	30		Yes	Unique code to identify a project.
PRIMARY_FLAG	VARCHAR2	1			Determines if the parcel is the primary parcel. A value of Y indicated primary contact.
PARCEL_ID	NUMBER		18	Yes	This column is used to indicate parcel id.
PARCEL_ID_ENTERED	VARCHAR2	50		Yes	This column is used to indicate parcel id entered.
PARENT_PARCEL_ID	NUMBER		18		This column is used to indicate parent parcel id.
PARCEL_TYPE	VARCHAR2	30			This column is used to indicate parcel type.
JURISDICTION	VARCHAR2	50			This column is used to indicate jurisdiction.
DISTRICT_NAME	VARCHAR2	50			This column is used to indicate district name.
PROPERTY_DESCRIPTION	VARCHAR2	240			This column is used to indicate property description.
PRIMARY_ZONING_ID	VARCHAR2	30			This column is used to indicate primary zoning id.
ZONING_DESCRIPTION	VARCHAR2	240			This column is used to indicate zoning description.
BLOCK_NUM	VARCHAR2	30			This column is used to indicate block num.
UNIT_NUM	VARCHAR2	30			This column is used to indicate unit num.
LOT_NUM	VARCHAR2	30			This column is used to indicate lot num.
BOOK_NUM	VARCHAR2	30			This column is used to indicate book num.
SECTION_NUM	VARCHAR2	30			This column is used to indicate section num.
PAGE_NUM	VARCHAR2	30			This column is used to indicate page num.
SUBDIVISION	VARCHAR2	30			This column is used to indicate subdivision.
LAND_USE_CODE	VARCHAR2	30			This column is used to indicate land use code.
MAP_NAME	VARCHAR2	50			This column is used to indicate map name.
MAP_BOOK_PAGE	VARCHAR2	50			This column is used to indicate map book page.
BOUNDARY_DESCRIPTION	VARCHAR2	480			This column is used to indicate boundary description.
LONGITUDE	NUMBER				This column is used to indicate longitude.
LATITUDE	NUMBER				This column is used to indicate latitude.
SRID	NUMBER		10		This column is used to indicate srid.
SHAPE	UDT				Specifies coordinates of the location defined by the address. Special data type required to store.
COORDINATE_X	NUMBER				This column is used to indicate coordinate x.
COORDINATE_Y	NUMBER				This column is used to indicate coordinate y.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_COM_PROJECT_PARCEL	psc_com_project	PARCEL_KEY, PROJECT_CODE
psc_com_prj_parcel_owner	psc_com_project_parcel	PARCEL_KEY
psc_com_project_address	psc_com_project_parcel	PARCEL_KEY

Indexes

Index	Uniqueness	Tablespace	Columns
PSC_COM_PROJECT_PARCEL_FK1	Non Unique	Default	AGENCY_ID, PROJECT_CODE
PSC_COM_PROJECT_PARCEL_PK	Unique	Default	PARCEL_KEY