1. Tables and Views
  2. PSC_PZ_PARCEL_TRANS_ADDRESS

PSC_PZ_PARCEL_TRANS_ADDRESS

This table stores the parcel address details pertaining to a project.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

PSC_PZ_PARCEL_TRANS_ADD_PK

PARCEL_TRX_ADD_KEY

Columns

Name Datatype Length Precision Not-null Comments Status
PARCEL_TRX_ADD_KEY NUMBER 18 Yes System generated key to identify the parcel transaction addresses.
PARCEL_TRX_ADD_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.
ASSIGNED_TO_CHILD VARCHAR2 50 This parent address was assigned to this child parcel
DISPLAY_PARENT_PARCEL VARCHAR2 50 Parent Parcel of the assigned address
PRIMARY_FLAG VARCHAR2 1 Determines if the address is the primary parcel. A value of Y indicated primary contact.
SUMMARY_ROW VARCHAR2 1 Determines if this row displays summary address assignment information for this child parcel.
ADDRESS_ID NUMBER 18 This column is used to indicate address id.
ADDRESS_CODE VARCHAR2 32 Unique identifier for the parcel address.
ENABLED_FLAG VARCHAR2 1 Attribute that indicates whether the parcel address is available for use. Active
COUNTRY VARCHAR2 60 This column indicates the country for the parcel.
STATE VARCHAR2 60 This column indicates the state for the parcel.
COUNTY VARCHAR2 60 This column indicates the county for the parcel.
MUNICIPALITY_ID VARCHAR2 20 This column is used to indicate municipality id.
ADDRESS1 VARCHAR2 240 This column is used to indicate address1.
ADDRESS2 VARCHAR2 240 This column is used to indicate address2.
ADDRESS3 VARCHAR2 240 This column is used to indicate address3.
ADDRESS4 VARCHAR2 240 This column is used to indicate address4.
CITY VARCHAR2 60 This column indicates the city name for the parcel.
POSTAL_CODE VARCHAR2 60 This column indicates the postal code for the parcel.
STREET_NUMBER VARCHAR2 20 This column indicates the street number for the parcel.
STREET_DIRECTION VARCHAR2 10 This column is used to indicate street direction.
STREE_NAME VARCHAR2 240 Street Name used for parcel address searches. Active
PROVINCE VARCHAR2 60 State code from the STATE_CODE_ISO column in the COM_STATE table.
POSTAL_PLUS4_CODE VARCHAR2 20 Four digit extension to the United States Postal ZIP.
STREET_NAME VARCHAR2 240 This column is used to indicate street name.
STREET_TYPE VARCHAR2 20 This column is used to indicate street type.
BUILDING_TYPE VARCHAR2 20 This column is used to indicate building type.
FLOOR VARCHAR2 20 This column is used to indicate floor.
UNIT_NUMBER VARCHAR2 30 This column is used to indicate unit number.
ADDRESS_FIELD1 VARCHAR2 20 This column is used to indicate address field1.
ADDRESS_FIELD2 VARCHAR2 20 This column is used to indicate address field2.
ADDRESS_FIELD3 VARCHAR2 20 This column is used to indicate address field3.
ADDRESS_TYPE VARCHAR2 20 This column is used to indicate address type.
EMAIL_ID VARCHAR2 50 This column is used to indicate email id.
HOME_PHONE_COUNTRY VARCHAR2 10 This column is used to indicate home phone country.
HOME_PHONE_NUM VARCHAR2 40 This column is used to indicate home phone num.
WORK_PHONE_COUNTRY VARCHAR2 10 This column is used to indicate work phone country.
WORK_PHONE_NUM VARCHAR2 40 This column is used to indicate work phone num.
CELL_PHONE_COUNTRY VARCHAR2 10 This column is used to indicate cell phone country.
CELL_PHONE_NUM VARCHAR2 40 This column is used to indicate cell phone num.
FAX_COUNTRY VARCHAR2 10 This column is used to indicate fax country.
FAX_NUM VARCHAR2 40 This column is used to indicate fax num.
LONGITUDE NUMBER This column is used to indicate longitude.
LATITUDE NUMBER This column is used to indicate latitude.
INPUT_SOURCE VARCHAR2 1 This column is used to indicate input source.
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.
NAME1 VARCHAR2 150 First Name that identifies the Parcel Address Contact.
NAME2 VARCHAR2 150 Second Name that identifies the Parcel Address Contact.
COORDINATE_X NUMBER This column is used to indicate coordinate x.
COORDINATE_Y NUMBER This column is used to indicate coordinate y.
STREET_SUFFIX VARCHAR2 20 Street name that describes the street.
CROSSROAD1 VARCHAR2 240 Cross road 1 that is part of parcel address.
CROSSROAD2 VARCHAR2 240 Cross road 2 that is part of parcel address.
LANDMARK VARCHAR2 200 Landmark for the parcel address.
TEMPORARY VARCHAR2 1 Determines if the row is still not part of the final transaction.
SELECTED VARCHAR2 1 Determines if this child parcel is using this address 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 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.
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_PZ_PARCEL_TRANS_ADDRESS psc_psc_parcel_trans_dtl PARCEL_TRX_DTL_KEY

Indexes

Index Uniqueness Tablespace Columns
PSC_PZ_PARCEL_TRANS_ADD_PK Unique Default PARCEL_TRX_ADD_KEY