1. Tables and Views
  2. PSC_PZ_PARCEL_TRANS_MST_B

PSC_PZ_PARCEL_TRANS_MST_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_PZ_PARCEL_TRANS_MST_B_PK

PARCEL_TRX_MST_KEY

Columns

Name Datatype Length Precision Not-null Comments Status
PARCEL_TRX_MST_KEY NUMBER 18 Yes System generated key to identify the parcel transaction parcels
PARCEL_TRX_MST_PUID VARCHAR2 480 Yes Alternate key used by CRM Import
PARCEL_TRX_DTL_KEY NUMBER 18 Yes System generated key to identify the parcel transaction.
PARCEL_TRX_DTL_PUID VARCHAR2 480 Yes Alternate key used by CRM Import
PARCEL_TRX_KEY NUMBER 18 Yes System generated key to identify the parcel transaction. Parcel transactions can be used to merge or split existing parcels generating new ones, or to perform lot line adjustment on existing parcels.
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. Active
PROV_PARCEL_ID_ENTERED VARCHAR2 50 Provisional parcel id
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_ADJUSTMENT VARCHAR2 15 Yes Identifies parcel data before and after lot line adjustment
PARENT_PARCEL_ID NUMBER 18 Identifier of the disabled parent parcel after a parcel split or merge. Active
PARENT_PARCEL_ID_ENTERED VARCHAR2 50 Assessor Parcel Number of the Parent Parcel
PARENT_PARCEL_ADDRESS VARCHAR2 240 Address of the parent parcel
PARCEL_TYPE VARCHAR2 30 Attribute that classifies parcels into groups of similar characteristics. Active
ENABLED_FLAG VARCHAR2 1 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 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.
TEMPORARY VARCHAR2 1 Determines if this row is part of the final transaction.
EXISTING_PARCEL VARCHAR2 1 Determines if the Child Parcel is a parcel that already exists in the system.
SELECTED VARCHAR2 1 Determines if the details from this parent parcel will be assigned to this child parcel.
PREVIOUS_STATE VARCHAR2 20 Store the previous state of the row. This field is used together with field TEMPORARY to implement temporary saving logic and allow functional row back in case the user cancels the transaction changes.
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.
MIGRATED_DATA_FLAG VARCHAR2 3 Indicates in-flight or historical transaction for data migration.

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_PZ_PARCEL_TRANS_MST_B PSC_PZ_PARCEL_TRANS_DTL PARCEL_TRX_DTL_KEY
psc_pz_parcel_trans_mst_tl psc_pz_parcel_trans_mst_b PARCEL_TRX_MST_KEY

Indexes

Index Uniqueness Tablespace Columns
PSC_PZ_PARCEL_TRANS_MST_B_PK Unique Default PARCEL_TRX_MST_KEY