1. Tables and Views
  2. PSC_COM_PARCEL_ADDRESS

PSC_COM_PARCEL_ADDRESS

This is a setup table that contains parcel address 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_ADDRESS_PK

PARCEL_ID, ADDRESS_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PARCEL_ID NUMBER 18 Yes System generated key from the parcel parent. Active
PROVINCE VARCHAR2 60 Location information about the province in which the parcel address is located.
POSTAL_PLUS4_CODE VARCHAR2 10 For US addresses, the full postal code is often quoted as a 5 digit number, followed by a 4 digit number. This column represents the second number having 4 digits.
ADDRESS_ID NUMBER 18 Yes System generated sequence key for the parcel address. Active
ADDRESS_CODE VARCHAR2 480 Yes Unique identifier for the parcel address.
ENABLED_FLAG VARCHAR2 1 Yes Attribute that indicates whether the parcel address is available for use. Active
COUNTRY VARCHAR2 3 Yes Country that is part of the parcel address. Active
STATE VARCHAR2 60 State that is part of the parcel address. Active
COUNTY VARCHAR2 60 County in which the parcel address is located. Active
MUNICIPALITY_ID VARCHAR2 20 Municipality in which the parcel address is located. Active
ADDRESS1 VARCHAR2 240 Address Line 1 that is part of the parcel address. Active
ADDRESS2 VARCHAR2 240 Address Line 2 that is part of the parcel address. Active
ADDRESS3 VARCHAR2 240 Address Line 3 that is part of the parcel address. Active
ADDRESS4 VARCHAR2 240 Address Line 4 that is part of the parcel address. Active
CITY VARCHAR2 60 City that is part of the parcel address. Active
POSTAL_CODE VARCHAR2 60 Postal Code that is part of the parcel address. Active
STREET_NUMBER VARCHAR2 20 Street number used for parcel address searches. Active
STREET_DIRECTION VARCHAR2 10 Street Direction used for parcel address searches. Active
STREE_NAME VARCHAR2 240 Street Name used for parcel address searches. Active
STREET_TYPE VARCHAR2 20 Street Type used for parcel address searches. Active
BUILDING_TYPE VARCHAR2 20 Building Type used for parcel address searches. Active
FLOOR VARCHAR2 20 Floor number used for parcel address searches. Active
UNIT_NUMBER VARCHAR2 30 Apartment unit number used for parcel address searches. Active
ADDRESS_FIELD1 VARCHAR2 20 Additional parcel address information 1 used for parcel address searches. Active
ADDRESS_FIELD2 VARCHAR2 20 Additional parcel address information 2 used for parcel address searches. Active
ADDRESS_FIELD3 VARCHAR2 20 Additional parcel address information 3 used for parcel address searches. Active
ADDRESS_TYPE VARCHAR2 20 Attribute used for address point validation. Possible values might be main address, virtual address, shipping gate address, or others. Active
EMAIL_ID VARCHAR2 50 Email id of the parcel contact person. Active
HOME_PHONE_COUNTRY VARCHAR2 10 Phone country code of the home phone number of the parcel contact person. Active
HOME_PHONE_NUM VARCHAR2 40 Home phone number of the parcel contact person. Active
WORK_PHONE_COUNTRY VARCHAR2 10 Phone country code of the work phone number of the parcel contact person. Active
WORK_PHONE_NUM VARCHAR2 40 Work phone number of the parcel contact person. Active
CELL_PHONE_COUNTRY VARCHAR2 10 Phone country code of the cell phone number of the parcel contact person. Active
CELL_PHONE_NUM VARCHAR2 40 Cell phone number of the parcel contact person. Active
FAX_COUNTRY VARCHAR2 10 Country code of the fax number of the parcel contact person. Active
FAX_NUM VARCHAR2 40 Fax number of the parcel contact person. Active
LONGITUDE NUMBER Geographical longitude location of the parcel address. Active
LATITUDE NUMBER Geographical latitude location of the parcel address. Active
INPUT_SOURCE VARCHAR2 1 Yes Indicates how parcel address data was entered. Data could have been entered by a user, or it could have been loaded by a process. 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 address. Active
PRIMARY_FLAG VARCHAR2 1 Identifies the parcel address as the primary address. 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
COORDINATE_X NUMBER Geographic x coordinate of the parcel address location. Active
COORDINATE_Y NUMBER Geographic y coordinate of the parcel address location. Active
SHAPE UDT Specifies coordinates of the location defined by the address. Special data type required to store. Active
NAME1 VARCHAR2 150 First Name that identifies the Parcel Address Contact.
NAME2 VARCHAR2 150 Second Name that identifies the Parcel Address Contact.
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.
STREET_NAME_CONCAT VARCHAR2 350 A concatenation of parts of an address that contains street information.

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_COM_PARCEL_ADDRESS psc_com_parcel_b PARCEL_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_COM_PARCEL_ADDRESS_PK Unique Default PARCEL_ID, ADDRESS_ID Active