1. Tables and Views
  2. PSC_COM_PARCEL_ADDRESS_INT

PSC_COM_PARCEL_ADDRESS_INT

This is interface 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: INTERFACE

Primary Key

Name Columns

PSC_COM_PARCEL_ADDRESS_INT_PK

PARCEL_ID, PARCEL_ID_ENTERED, ADDRESS_ID, LOAD_REQUEST_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PARCEL_ID NUMBER 18 Yes System generated key from the parcel parent. Active
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.
PROVINCE VARCHAR2 60 Location information about the province in which the parcel address is located. Active
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. Active
ADDRESS_ID NUMBER 18 Yes System generated sequence key for the parcel address. Active
ADDRESS_CODE VARCHAR2 32 Yes Unique identifier for the parcel address. Active
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 VARCHAR2 240 SHAPE Active
NAME1 VARCHAR2 150 First Name that identifies the Parcel Address Contact. Active
NAME2 VARCHAR2 150 Second Name that identifies the Parcel Address Contact. Active
LOAD_REQUEST_ID NUMBER 18 Yes Load Request Identifier. This is to support the loading of the interface records from the data files using the cloud framework. Active
PROCESSED_FLAG VARCHAR2 1 Yes To indicate whether the row has been loaded to product table

Indexes

Index Uniqueness Tablespace Columns
PSC_COM_PARCEL_ADDRESS_INT_U1 Unique Default PARCEL_ID, PARCEL_ID_ENTERED, ADDRESS_ID, LOAD_REQUEST_ID