1. Tables and Views
  2. PSC_COM_PARCEL_B

PSC_COM_PARCEL_B

This is a setup table that contains parcel information for the parcels of real estate of a city, county, or state.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_COM_PARCEL_B_PK

PARCEL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PARCEL_ID NUMBER 18 Yes System generated key to identify the parcel of real estate. Active
PROV_PARCEL_ID_ENTERED VARCHAR2 50 Identifier given by the user for the parcel of real estate. In the USA, this is the Assessor Parcel Number.
FINAL_PARCEL_ID_ENTERED VARCHAR2 50 Identifier given by the user for the parcel of real estate. In the USA, this is the Assessor Parcel Number.
PARCEL_ID_ENTERED VARCHAR2 50 Yes Identifier given by the user for the parcel of real estate. In the USA, this is the Assessor Parcel Number. Active
PARENT_PARCEL_ID NUMBER 18 Identifier of the disabled parent parcel after a parcel split. Active
PARCEL_TYPE VARCHAR2 30 Attribute that classifies parcels into groups of similar characteristics. Active
ENABLED_FLAG VARCHAR2 1 Yes Attribute that indicates whether the parcel of real estate is available for use. Active
JURISDICTION VARCHAR2 50 Name of the city or county that has jurisdiction over the parcel of real estate. Active
PRIMARY_ZONING_ID VARCHAR2 30 Identifier for the zoning of the parcel of real estate. Active
BLOCK_NUM VARCHAR2 30 Identifier for the block number of the land information related to the parcel of real estate. In the USA, this is part of the Assessor Parcel Number. Active
UNIT_NUM VARCHAR2 30 Identifier for the unit number of the land information related to the parcel of real estate. In the USA, this is part of the Assessor Parcel Number. Active
LOT_NUM VARCHAR2 30 Identifier for the lot number of the land information related to the parcel of real estate. In the USA, this is part of the Assessor Parcel Number. Active
BOOK_NUM VARCHAR2 30 Location information for the city, county, or state records that refer to the book where a user can find information about the parcel of real estate. Active
SECTION_NUM VARCHAR2 30 Location information for the city, county, or state records that contain information about the parcel of real estate. Active
PAGE_NUM VARCHAR2 30 Location information for the city, county, or state records that refer to a page in the book where a user can find information about the parcel of real estate. Active
SUBDIVISION VARCHAR2 30 Land information about the location of the parcel of real estate. Active
LAND_USE_CODE VARCHAR2 30 Zoning information related to the location of the parcel of real estate. Active
MAP_NAME VARCHAR2 50 Location information for the city, county, or state records that refer to the map where a user can find information about the parcel of real estate. Active
MAP_BOOK_PAGE VARCHAR2 50 Location information for the city, county, or state records that refer to the map, book, an page, where a user can find information about the parcel of real estate. Active
LONGITUDE NUMBER Geographical longitude location of the parcel. Active
LATITUDE NUMBER Geographical latitude location of the parcel. Active
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. Active
SRID NUMBER 10 Spatial Reference System Identifier (SRID) is a unique value used to unambiguously identify projected, unprojected, and local spatial coordinate system definitions for the parcel. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. Active
COORDINATE_X NUMBER Geographic x coordinate of the parcel location. Active
COORDINATE_Y NUMBER Geographic y coordinate of the parcel location. Active
SHAPE UDT Specifies coordinates of the location of the address. Special data type required to store. Active
PARCEL_STATUS VARCHAR2 20 Yes This column describes the status of the parcel.
PARCEL_SIZE1 NUMBER 20 Size of the parcel.
PARCEL_SIZE1_UNIT VARCHAR2 10 Unit of measurement for the size of the parcel.
PARCEL_SIZE2 NUMBER 20 Alternate size of the parcel.
PARCEL_SIZE2_UNIT VARCHAR2 10 Unit of measurement for the alternate size of the parcel.
STRUCTURE_SIZE1 NUMBER 20 Size of the structure.
STRUCTURE_SIZE1_UNIT VARCHAR2 10 Unit of measurement for the size of the structure.
STRUCTURE_SIZE2 NUMBER 20 Alternate size of the structure.
STRUCTURE_SIZE2_UNIT VARCHAR2 10 Unit of measurement for the alternate size of the structure.
DWELLING_UNIT_COUNT NUMBER 10 Number of Dwelling Units.
ZONING_CODE2 VARCHAR2 30 Secondary Zoning Code of the zoning related to the parcel.
GENERAL_PLAN2 VARCHAR2 30 Alternate Land Information of the Parcel.
TAX_RATE_AREA VARCHAR2 100 Area Identifier of the parcel location for taxation purposes.
CENSUS_TRACT VARCHAR2 100 Neighborhood information related to the location of the parcel.
CENSUS_BLOCK VARCHAR2 100 Neighborhood information related to the location of the parcel.
CLIMATE_ZONE VARCHAR2 200 Detailed land information of the parcel.
FLOOD_ZONE VARCHAR2 200 Detailed land information of the parcel.
FLOOD_INS_RATE_MAP VARCHAR2 200 Flood Insurance Rate Map related to the parcel location for floodplain management and insurance purposes.
LIQUEFACTION_RISK VARCHAR2 200 Detailed land information of the parcel.
FIRE_RISK VARCHAR2 200 Detailed land information of the parcel.
LANDSLIDE_RISK VARCHAR2 200 Detailed land information of the parcel.
SOIL_TYPE VARCHAR2 200 Detailed land information of the parcel.
YEAR_BUILT VARCHAR2 4 Year in which the building on the parcel was built (format: YYYY).
BEDROOMS VARCHAR2 20 Number of bedrooms for the building on the parcel.
BATHROOMS VARCHAR2 20 Number of bathrooms for the building on the parcel.
POOL VARCHAR2 200 Information about pools located on the parcel.
PATIO VARCHAR2 200 Information about patios located on the parcel.
ADDITIONAL_STRUCTURE VARCHAR2 200 Information about additional structures located on the parcel.

Foreign Keys

Table Foreign Table Foreign Key Column
psc_com_parcel_tl psc_com_parcel_b PARCEL_ID
psc_com_parcel_value_f psc_com_parcel_b PARCEL_ID
psc_apo_attachment psc_com_parcel_b PARCEL_ID
psc_com_parcel_district psc_com_parcel_b PARCEL_ID
psc_com_parcel_address psc_com_parcel_b PARCEL_ID
psc_com_parcel_owner psc_com_parcel_b PARCEL_ID
psc_com_parcel_comment psc_com_parcel_b PARCEL_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_COM_PARCEL_B_PK Unique Default PARCEL_ID Active
PSC_COM_PARCEL_U2 Unique Default PARCEL_ID_ENTERED