1. Tables and Views
  2. PSC_COM_PARCEL_OWNER_INT

PSC_COM_PARCEL_OWNER_INT

This is interface table that contains parcel ownership 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_OWNER_INT_PK

PARCEL_ID, PARCEL_ID_ENTERED, OWNER_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 Province in which the address of the parcel owner 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
COUNTY VARCHAR2 60 County in which the address of the parcel owner is located. Active
OWNER_CODE VARCHAR2 32 Yes Unique identifier for the parcel owner. Active
OWNER_ID NUMBER 18 Yes System generated sequence key for the parcel owner. Active
ENABLED_FLAG VARCHAR2 1 Yes Attribute that indicates whether the parcel owner information is available for use. Active
OWNER_TYPE VARCHAR2 20 Identifier to classify the parcel owner into groups of common characteristics. Active
NAME1 VARCHAR2 150 First Name that identifies the parcel owner. Active
NAME2 VARCHAR2 150 Second Name that identifies the parcel owner. Active
ADDRESS1 VARCHAR2 240 Address Line 1 that is part of the parcel owner address. Active
ADDRESS2 VARCHAR2 240 Address Line 2 that is part of the parcel owner address. Active
ADDRESS3 VARCHAR2 240 Address Line 3 that is part of the parcel owner address. Active
ADDRESS4 VARCHAR2 240 Address Line 4 that is part of the parcel owner address. Active
CITY VARCHAR2 60 City that is part of the parcel owner address. Active
POSTAL_CODE VARCHAR2 60 Postal code that is part of the parcel owner address. Active
COUNTRY VARCHAR2 3 Yes Country that is part of the parcel owner address. Active
STATE VARCHAR2 60 State that is part of the parcel owner address. Active
STREET_NUMBER VARCHAR2 20 Street number used for parcel owner address searches. Active
STREET_DIRECTION VARCHAR2 10 Street direction used for parcel owner address searches. Active
STREE_NAME VARCHAR2 240 Street name used for parcel owner address searches. Active
STREET_TYPE VARCHAR2 20 Street type used for parcel owner address searches. Active
BUILDING_TYPE VARCHAR2 20 Buiding type used for parcel owner address searches. Active
FLOOR VARCHAR2 20 Floor number used for parcel owner address searches. Active
UNIT_NUMBER VARCHAR2 30 Apartment unit number used for parcel owner address searches. Active
ADDRESS_FIELD1 VARCHAR2 20 Additional parcel owner address information 1 used for parcel owner address searches. Active
ADDRESS_FIELD2 VARCHAR2 20 Additional parcel owner address information 2 used for parcel owner address searches. Active
ADDRESS_FIELD3 VARCHAR2 20 Additional parcel owner address information 3 used for parcel owner address searches. Active
EMAIL_ID VARCHAR2 50 Email id of the owner of the parcel. Active
HOME_PHONE_COUNTRY VARCHAR2 10 Phone country code of the home phone number of the parcel owner. Active
HOME_PHONE_NUM VARCHAR2 40 Home phone number of the parcel owner. Active
WORK_PHONE_COUNTRY VARCHAR2 10 Phone country code of the work phone number of the parcel owner. Active
WORK_PHONE_NUM VARCHAR2 40 Work phone number of the parcel owner. Active
CELL_PHONE_COUNTRY VARCHAR2 10 Phone country code of the cell phone number of the parcel owner. Active
CELL_PHONE_NUM VARCHAR2 40 Cell phone number of the parcel owner. Active
FAX_COUNTRY VARCHAR2 10 Country code of the fax number of the parcel owner. Active
FAX_NUM VARCHAR2 40 Fax number of the parcel owner. Active
LAST_TRANSFER_TYPE VARCHAR2 50 Identifier that classifies transfer of parcel ownerships into groups of common characteristics. Active
LAST_TRANSFER_DATE DATE Date when the parcel changed owner previously. Active
DOCUMENT_NUM VARCHAR2 50 Document number recording previous transfer of ownership. 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
PRIMARY_FLAG VARCHAR2 1 Identifies the parcel owner as the primary owner. 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
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_OWNER_INT_U1 Unique Default PARCEL_ID, PARCEL_ID_ENTERED, OWNER_ID, LOAD_REQUEST_ID