1. Tables and Views
  2. PSC_PZ_PARCEL_TRANS_DISTRICT

PSC_PZ_PARCEL_TRANS_DISTRICT

This is a setup table used by an agency administrator to assign parcels to districts in an agency, based on the location of the parcel.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_PZ_PARCEL_TRANS_DIST_PK

PARCEL_TRX_DST_KEY

Columns

Name Datatype Length Precision Not-null Comments Status
PARCEL_TRX_DST_KEY NUMBER 18 Yes System generated key to identify the parcel transaction districts.
PARCEL_TRX_DST_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 parcels.
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.
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.
PARENT_PARCEL_ID NUMBER 18 Identifier of the disabled parent parcel after a parcel split or merge.
PARENT_PARCEL_ID_ENTERED VARCHAR2 50 Assessor Parcel Number of the Parent Parcel.
DISTRICT_ID VARCHAR2 30 Identifier for the district in which a parcel is located. A district is an area within a city, county, or state. Active
ASSIGNED_TO_CHILD VARCHAR2 50 This parent district was assigned to this child parcel
SUMMARY_ROW VARCHAR2 1 Determines if this row displays summary district assignment information for this child parcel
DISPLAY_PARENT_PARCEL VARCHAR2 50 Parent Parcel of the assigned district
TEMPORARY VARCHAR2 1 Determines if this row is part of the final transaction.
SELECTED VARCHAR2 1 Determines if this child parcel is using this district from this parent parcel.
PREVIOUS_STATE VARCHAR2 20 Store the previous state of the row. This field is used together with the field TEMPORARY to implement temporary saving logic and allow functional row back in case the user cancels the transaction changes.
MIGRATED_DATA_FLAG VARCHAR2 3 Indicates in-flight or historical transaction for data migration.
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
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

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_PZ_PARCEL_TRANS_DISTRICT psc_pz_parcel_trans_dtl PARCEL_TRX_DTL_KEY

Indexes

Index Uniqueness Tablespace Columns
PSC_PZ_PARCEL_TRANS_DIST_PK Unique Default PARCEL_TRX_DST_KEY